Senior Data Engineer

FI Consulting is seeking a Senior Data Engineer for an onsite role in Arlington, VA, supporting a federal government data modernization initiative. The position focuses on building reusable ingestion frameworks and scalable data pipelines that deliver secure, governed, analytics-ready integrations across enterprise grants, financial, performance, and operational data.

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 both structured and unstructured data sources.
• Integrate data from grants, financial, operational, performance, and business systems using APIs, files, relational databases, and approved platform services.
• Work with the Lead Data Architect and Solution Architect to implement canonical data models, integration patterns, and engineering standards.
• 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 encryption in transit and at rest, access controls, and protection of PII and sensitive financial data throughout the pipeline.
• Optimize data processing workflows for performance, scalability, reliability, maintainability, and repeatability.
• Support centralized data repositories and analytics-ready data structures 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 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.

Requirements

• 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 with modern engineering environments using source control (Git/Bitbucket) and CI/CD pipelines.
• 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.

Technologies

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

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.

Location

Arlington, VA (onsite)

Compensation

• Estimated range: $150K-$200K per year.
• Actual compensation is determined by factors including experience, skills, education, certifications, geography, role scope, business needs, and internal equity.
• The full range is intended to accommodate varying qualifications and growth over time.
• Candidates are typically not hired at the top of the posted range, with compensation increasing as skills expand, responsibilities grow, and sustained performance is demonstrated.

FLSA Designation

Exempt