Senior IT Data Engineer

System One is hiring a Senior IT Data Engineer (contract) to support the Federal Reserve Board’s Division of Research & Statistics (R&S) DATA section in Washington, DC (onsite). In this role, you will help expand and optimize data and data pipeline architecture, strengthen ETL/ELT workflows, and deliver enterprise data platform capabilities for economists and research teams working on economic policy and analysis.

Responsibilities

• Expand and optimize data and data pipeline architecture for economic policy and research use cases.
• Optimize data flow and collection to improve how multiple teams access and use data.
• Design and develop delivery architecture to support next generation R&S data initiatives.
• Improve existing data systems and/or build new systems from the ground up.
• Optimize or redesign the R&S division’s data architecture to support evolving data initiatives.
• Support economists and technical experts with a service mindset and a self-directed approach.
• Design and communicate enterprise information architecture at conceptual, logical, and physical levels.
• Develop and communicate enterprise architecture that supports data needs across teams and systems.

Requirements

• Bachelor’s degree in computer science, Information Technology, Engineering or a related technical field, plus at least 7 years of related experience (advanced degree preferred).
• Advanced working knowledge of SQL and experience with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQL.
• Advanced working knowledge of Python, R, and other scripting languages used for data engineering and analytics.
• Experience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume workloads.
• Experience designing, developing, and automating ETL/ELT workflows and data integration pipelines.
• Experience building, optimizing, and maintaining scalable databases, data pipelines, and data processing frameworks.
• Experience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions.
• Experience migrating workflows and data pipelines between on-premises and cloud environments.
• Experience processing, analyzing, and integrating structured and unstructured data sources.
• Experience developing in Linux and using source control platforms such as GitLab and/or GitHub.
• Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify improvement opportunities.
• Ability to design and communicate enterprise information architecture at conceptual, logical, and physical levels.
• 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 and services.
• 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.
• Experience in a research environment and/or with economic or financial data.
• Experience with NoSQL and graph database technologies.
• Experience developing, training, deploying, and maintaining machine learning models.
• Working experience with AWS, Microsoft Azure, and Snowflake.
• Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies.
• Experience implementing and maintaining CI/CD pipelines and DataOps platforms.
• Working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or Perl.

Technology

SQL, PostgreSQL, Microsoft SQL Server, MySQL, Python, R, Apache Airflow, Prefect, Dagster, AWS Step Functions, Linux, GitLab, GitHub, NoSQL, graph database technologies, machine learning models, AWS, Microsoft Azure, Snowflake, Change Data Capture (CDC), CI/CD pipelines, DataOps, Java, Scala, JavaScript, Perl

Benefits

• Eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans
• Participation in a 401(k) plan