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. Role 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 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. Required 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 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 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. Technologies SQL Python RESTful APIs Git Bitbucket ETL ELT Compensation and FLSA Location: Arlington, VA (onsite). Salary range: USD 150,000 - 200,000 per year. A reasonable estimate is $150K-$200K, with actual compensation determined by factors including experience, skills, education, certifications, geography, role scope, business needs, and internal equity. This is an exempt position (FLSA designation). #J-18808-Ljbffr DataJobs.com