Senior Data Engineer, Enterprise Modernization

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

Job summary

FI Consulting is seeking a Senior Data Engineer to lead design and implementation of reusable data ingestion frameworks, enterprise integrations, and scalable pipelines for a federal data modernization initiative. The role collaborates with data architects, analytics specialists, application developers, and security personnel to integrate disparate sources and create a trusted centralized data environment.

The ideal candidate has 8+ years of experience in data integration and API-based

Qualifications

• 8+ years of data engineering and integration experience.
• Experience building enterprise data pipelines and reusable data integration solutions.
• Strong SQL development and data modeling experience.
• Experience with API-based data integrations and data quality controls.

Responsibilities

• Design, develop, and maintain scalable enterprise data pipelines and integration services.
• Lead reusable connectors and automated data acquisition across agency systems.
• Design and implement ETL/ELT solutions for structured and unstructured data.
• Integrate data from various systems using APIs, files, and databases.
• Collaborate with architects to implement canonical data models and standards.
• Develop source-to-target mappings, transformation rules, and data lineage.
• Implement profiling, validation, reconciliation, monitoring, and data quality controls.
• Ensure secure handling of PII and sensitive financial data in transit and at rest.
• Optimize data processing for performance, scalability, and reliability.
• Support centralized data repositories and analytics-ready data structures.
• Troubleshoot data integrations and perform root-cause analysis.
• Prepare governed data for dashboards, search, analytics, and reporting.
• Participate in backlog refinement, sprints, reviews, and retrospectives.
• Mentor engineers and establish reusable engineering practices.
• Ensure compliance with security, privacy, governance, and records-management requirements.
• Assist deployment, testing, and knowledge transfer across environments.

Skills

Data engineering

ETL/ELT development

RESTful APIs

Python

SQL

Git/CI-CD

Agile delivery

Data profiling

Data quality controls

Education

Bachelor's degree in Computer Science or related field

Tools

PostgreSQL

SQL Server

Oracle

Airflow

Azure Data Factory

AWS Glue

Informatica

Talend

Docker

Kubernetes

Job description

Position Overview

FI Consulting is seeking a Senior Data Engineer to support a federal government data modernization initiative focused on integrating and analyzing enterprise grants, financial, performance, and operational data. The Senior Data Engineer serves as a hands-on technical leader responsible for designing and implementing reusable data ingestion frameworks, enterprise integrations, and scalable data pipelines. The role works closely with data architects, business stakeholders, analytics specialists, application developers, and security personnel to integrate disparate data sources and create a trusted, centralized data environment. The ideal candidate has 8 or more years of experience leading data integration efforts, developing enterprise ETL/ELT solutions, building API-based integrations, and implementing data quality controls in complex federal or enterprise environments.

Responsibilities

• Design, develop, and maintain scalable enterprise data pipelines, ingestion frameworks, and integration services.
• Lead the development of reusable connectors and automated data acquisition processes across multiple agency systems and environments.
• Design and implement ETL/ELT solutions that support 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, including protection of PII and sensitive financial data through appropriate encryption in transit and at rest, access controls, and safeguarding of data throughout the pipeline.
• Optimize data processing 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 and perform 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 activities across development, test, staging, and production environments.

Minimum 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 working in modern engineering environments using 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.

Compensation

Actual compensation will be determined based on a variety of factors, including experience, skills, education, certifications, geography, role scope, business needs, and internal equity considerations. At FI, we view employees as individuals rather than simply matching compensation to a job title. We recognize that people with the same title may bring different experiences, capabilities, specialties, and contributions, and we strive to evaluate each candidate holistically.

A reasonable estimate of the compensation range for this position is $150K-$200K. The full range is intended to accommodate varying levels of qualifications and growth within the role over time. As a result, candidates are typically not hired at the top of the posted range, with compensation increasing as employees develop skills, take on additional responsibilities, and demonstrate sustained performance.

FLSA Designation

This is an exempt position.

FI Consulting participates in E-Verify.

Equal Employment Opportunity/disability/protected veteran status.

FI Consulting is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please email [e-mail] or call: 571-255-6768. We will make a determination on your request for reasonable accommodation on a case-by-case basis.

AI plays only a supporting role in our recruitment process. All decisions are made by human members of our talent acquisition team.