Senior Data Engineer, Enterprise Modernization

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.

• 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., * 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.

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.

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