Senior Data Architect

Contract Performance Period : July 15, 2026 - December 31, 2026
Job Location : Washington, DC location(s) (Metro Access) On-Site 5 days/week.
Direct Hire : Term: through 31/12/2026, with a strong possibility of extension
Pay Range : Depending on Experience
Travel Requirements : Washington, DC location(s) (Metro Access) On-Site 5 days/week.
Working Remotely : Not possible

Project Description :

We are seeking an experienced, detail-oriented Data Architect/Engineer to design, develop, and implement modern data infrastructure and analytical capabilities that enhance economic forecasting and policymaking at a large, highly regulated federal financial institution. This program transforms legacy and proprietary databases and fragmented data pipelines into integrated cloud platforms, enterprise data integration systems, and collaboration tools that improve data accessibility and security.

The ideal candidate is a hands-on data modeler with working knowledge of database design and administration, data pipeline building, and data wrangling who enjoys improving existing data systems and/or building them from the ground up. The right candidate will be excited by the prospect of optimizing or re-designing an enterprise data architecture to support the next generation of data initiatives.

US Citizenship is required for this position.

Qualification Requirements :

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field; advanced degree preferred
• At least 7 years of related data architecture/engineering experience
• Advanced working knowledge of SQL and relational database platforms (PostgreSQL, Microsoft SQL Server, MySQL)
• Advanced working knowledge of Python, R, and other scripting languages for data engineering and analytics
• Experience with large-scale data systems including distributed computing, scalable data processing, and high-volume data workload optimization
• Experience designing, developing, and automating ETL/ELT workflows and data integration pipelines
• Experience with workflow orchestration tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions
• Experience migrating workflows and data pipelines between on-premises and cloud environments
• Experience developing in Linux environments and using source control platforms (GitLab, GitHub)
• In-depth experience designing and implementing database, data lake, and enterprise data platform solutions
• Strong hands-on software engineering experience including development, testing, and deployment of data applications
• Excellent oral and written communication skills with a strong customer service orientation
• Exceptional analytical, problem-solving, and troubleshooting skills
• Understanding of time series data and related analytical and forecasting techniques (preferred)
• Experience working in a research environment and/or with economic or financial data (preferred)
• Experience with NoSQL and graph database technologies (preferred)
• Experience developing, training, deploying, and maintaining machine learning models (preferred)
• Working experience with cloud technologies such as AWS, Microsoft Azure, and Snowflake (preferred)
• Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies (preferred)
• Experience implementing and maintaining CI/CD pipelines and DataOps platforms (preferred)
• Working knowledge of additional programming languages such as Java, Scala, JavaScript, or Perl (preferred)

Skills Requirements :

• SQL & relational databases (PostgreSQL, Microsoft SQL Server, MySQL)
• Python, R & scripting languages (Java, Scala, JavaScript, Perl)
• ETL/ELT workflow design, development & automation
• Workflow orchestration (Apache Airflow, Prefect, Dagster, AWS Step Functions)
• Distributed computing & large-scale data processing architecture
• Data lake & enterprise data platform design and implementation
• NoSQL & graph database technologies
• Cloud platforms (AWS, Microsoft Azure, Snowflake)
• Change Data Capture (CDC) & data warehouse implementation
• CI/CD pipelines & DataOps platforms
• Machine learning model development, training & deployment
• Time series data analysis & forecasting
• Source control (GitLab, GitHub) & Linux development environments
• Structured & unstructured data processing and integration
• Enterprise information architecture (conceptual, logical & physical levels)
• Data quality monitoring & governance
• Logical & physical data modeling, data dictionaries & technical metadata documentation

Responsibilities :

• Analyze data processes, applications, and source data to understand dependencies, anomalies, and implicit business rules impacting data management
• Review and analyze existing data models and processes to optimize and modernize current data architectures
• Design, develop, and maintain robust data pipelines that ingest, transform, and deliver data from multiple sources to analytics platforms
• Architect and implement ETL/ELT workflows using modern data engineering tools and frameworks to support large-scale economic data processing
• Create data solution designs for economic policy and research projects including conceptual models, integration models, and sourcing strategies
• Translate division and section requirements into long-term information architecture solutions
• Define specifications and implement database structures including logical and physical data models, backup and recovery procedures, and access security controls
• Develop and maintain formal documentation of data structures, data flows, data dictionaries, and technical metadata
• Collaborate with research and business teams to improve data models and processes supporting analytics and visualization tools
• Implement processes and systems to monitor data quality, ensuring production data is accurate, reliable, and available
• Identify and implement internal process improvements including automation of manual processes and optimization of data delivery
• Migrate workflows and data pipelines between on-premises and cloud environments
• Participate in the development of future-state data architecture standards, guidelines, and principles

Job ID : 1568

---

Submit your resume for this position