Senior Data Engineer: Data Pipelines & Integrations

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

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