Data Integration Engineer

ICF is a global advisory and technology services provider that delivers technology solutions for complex client challenges. The Data Integration Engineer will design, implement, and optimize secure, traceable data pipelines and integrations for government data migration and modernization, including data mapping, transformation, validation, monitoring, and reliable movement.

Responsibilities:

• Design, build, and optimize ETL and data-integration pipelines
• Map and transform legacy data into approved target schemas and models
• Create integrations using APIs, database tools, and data-platform services
• Implement data-quality checks, validation, monitoring, security, and traceability
• Tune data movement and storage for reliability and performance
• Collaborate with data governance personnel, subject-matter experts, developers, and testers

Requirements:

• • Candidate must reside in the U.S., be authorized to work in the U.S., and all work must be performed in the U.S
• • Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years
• • Minimum five years of experience designing and optimizing end-to-end data pipelines, ETL, data models, validation, storage, and retrieval
• • Strong SQL skills and experience with Microsoft SQL Server
• • Experience with SSIS and at least one of Python, Java, Scala, or R
• • Experience with APIs, relational and NoSQL databases, and cloud data platforms
• • Ability to work effectively in Agile delivery teams and collaborate with government and contractor stakeholders
• • Clear written and verbal communication skills, strong organization, and attention to detail
• • Highly effective analytical, problem-solving, and decision-making capabilities
• • Excellent communication and interpersonal skills to work effectively across business, technical, and client teams
• • Organized, detail-oriented, and able to prioritize multiple assignments in a delivery-focused environment
• • Bachelor's degree in a related field; directly related experience may be considered in place of education
• • Azure, AWS, GCP, or data-engineering certification
• • Experience with Databricks, Azure Data Factory, Spark, Hadoop, or Kafka