Senior Data Engineer

DataJobs; Arlington (VA); On-site; USD 150,000 - 200,000; Full time

Job summary

FI Consulting seeks a Senior Data Engineer to support a federal data modernization initiative, focusing on reusable ingestion frameworks and scalable, analytics-ready data pipelines. The role emphasizes secure integrations across grants, financial, performance, and operational data with strong data quality controls.

The candidate will lead the design and implementation of ETL/ELT solutions, collaborate with architects, and mentor junior engineers while ensuring compliance with security and

Qualifications

• Bachelor's degree or equivalent in a technical field.
• 8+ years with data engineering, systems integration, or ETL/ELT development.
• Experience designing enterprise data pipelines and reusable data integration.
• Proficiency with Git/Bitbucket and CI/CD for collaborative development.
• Strong SQL, data modeling, and query optimization.
• Proficient in Python for data processing.
• Experience with RESTful APIs and file-based integrations.
• Experience with structured and unstructured data sources.
• Ability to translate requirements into secure technical solutions.
• Experience working in Agile environments and cross-functional teams.

Responsibilities

• Design, build, and maintain scalable data pipelines and ingestion frameworks.
• Lead reusable connectors and automated data acquisition across agency systems.
• Create ETL/ELT solutions for diverse data sources.
• Integrate data from grants, financial, operational, and performance systems.
• Collaborate to implement canonical data models and engineering standards.
• Develop data lineage, mappings, and interface documentation.
• Implement data profiling, validation, and monitoring."
• Ensure secure handling of PII and sensitive data.
• Optimize workflows for performance and reliability.
• Support centralized data repositories used for reporting and analytics.
• Mentor engineers and conduct code reviews.
• Ensure compliance with security and governance requirements.

Skills

SQL development

Python

RESTful APIs

Agile delivery

Data modeling

Analytical thinking

Written communication

Troubleshooting

Security practices

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

Git

Bitbucket

CI/CD pipelines

PostgreSQL

SQL Server

Oracle

Airflow

Azure Data Factory

Docker

Kubernetes

Job description

FI Consulting is seeking a Senior Data Engineer to support a federal government data modernization initiative, focusing on reusable ingestion frameworks and scalable, analytics-ready data pipelines. The role will lead secure and governed integrations across enterprise grants, financial, performance, and operational data, with a strong emphasis on data quality controls and traceability.

Role Responsibilities

• Design, develop, and maintain scalable enterprise data pipelines, ingestion frameworks, and integration services.
• Lead development of reusable connectors and automated data acquisition processes across multiple agency systems and environments.
• Design and implement ETL/ELT solutions for structured and unstructured data sources.
• Integrate data from grants, financial, operational, performance, and business systems using APIs, files, relational databases, and approved platform services.
• Collaborate with the Lead Data Architect and Solution Architect to implement canonical data models, integration patterns, and engineering standards.
• Develop and maintain source-to-target mappings, transformation rules, interface specifications, data lineage, and technical documentation.
• Implement data profiling, validation, reconciliation, monitoring, and data quality controls.
• Apply secure data-handling practices to protect PII and sensitive financial data through encryption in transit and at rest, access controls, and end-to-end pipeline safeguards.
• Optimize workflows for performance, scalability, reliability, maintainability, and repeatability.
• Support centralized data repositories and analytics-ready data structures used for reporting, search, analysis, and application services.
• Troubleshoot complex integration, pipeline, and data quality issues using root-cause analysis.
• Collaborate with analytics and application teams to prepare governed, traceable data for semantic search, dashboards, analytical signals, and reporting.
• Participate in backlog refinement, sprint planning, daily coordination, demonstrations, technical reviews, and retrospectives.
• Mentor data engineers, conduct code reviews, and establish reusable engineering practices.
• Ensure data solutions follow applicable security, privacy, governance, records-management, and configuration-management requirements.
• Support deployment, testing, documentation, knowledge transfer, and transition across development, test, staging, and production environments.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, Applied Mathematics, or a related technical field.
• 8-15+ years of experience in data engineering, systems integration, ETL/ELT development, software engineering, or enterprise data management.
• Experience designing and implementing enterprise data pipelines and reusable data integration solutions.
• Experience using modern engineering environments with source control (Git/Bitbucket) and CI/CD pipelines for collaborative development and automated deployment.
• Strong SQL development, relational database design, and query-optimization experience.
• Proficiency with Python and experience applying modern software engineering practices to data-processing solutions.
• Experience developing and consuming RESTful APIs, web services, database interfaces, and file-based integrations.
• Experience integrating structured and unstructured data from multiple source systems.
• Experience creating source-to-target mappings, transformation specifications, interface documentation, and data lineage.
• Experience implementing automated data quality, validation, reconciliation, logging, and monitoring controls.
• Ability to translate business and data requirements into secure, maintainable technical solutions.
• Experience working in Agile delivery environments and collaborating across technical and functional teams.
• Strong analytical, troubleshooting, written communication, and technical documentation skills.
• Ability to obtain and maintain a Top Secret clearance.
• Must be available to work onsite in Washington, DC upon project start.

Preferred Qualifications

• Experience supporting federal government clients and multi-agency data initiatives.
• Experience integrating federal grants, financial management, acquisition, performance management, or operational data.
• Experience with PostgreSQL, SQL Server, Oracle, or comparable enterprise database platforms.
• Experience with data orchestration or integration tools such as Apache Airflow, Azure Data Factory, AWS Glue, Informatica, Talend, or comparable technologies.
• Experience with cloud or hybrid data services in Azure, AWS, or Google Cloud.
• Experience deploying containerized data-processing solutions using Docker, Kubernetes, or OpenShift.
• Familiarity with data governance, metadata management, master data management, and data catalog solutions.
• Experience implementing data lineage, provenance, source traceability, and auditability capabilities.
• Experience preparing data for advanced analytics, semantic search, retrieval-augmented generation, or machine learning applications.
• Experience supporting financial management, accounting, budgeting, grants management, reconciliation, or reporting environments.

Technologies

• SQL
• Python
• RESTful APIs
• Git
• Bitbucket
• ETL
• ELT

Compensation and FLSA

• Location: Arlington, VA (onsite).
• Salary range: USD 150,000 - 200,000 per year.
• A reasonable estimate is $150K-$200K, with actual compensation determined by factors including experience, skills, education, certifications, geography, role scope, business needs, and internal equity.
• This is an exempt position (FLSA designation).