Senior Data Engineer

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.

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

• 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…