Data Integration Engineer

Posted 8 Days Ago
2 Locations
In-Office or Remote
81K-139K Annually
Mid level
Consulting
Come solve with us
The Role
Builds and maintains cloud-based data pipelines, transformations, semantic views, conformed dimensions, and analytical data models supporting reporting and AI/ML. Implements data quality checks, documentation, lineage, testing, release-readiness evidence, and defect resolution. Collaborates with data owners, governance, engineering, security, product, and customer teams to deliver reliable, governed data products. The role supports enterprise data modernization, migrations, DataOps, and production data platforms for a federal client.
Summary Generated by Built In

Please note: This role is contingent upon a contract award. While it is not an immediate opening, we are actively conducting interviews and extending offers in anticipation of the award. 


The Work 

At ICF our Digital Modernization Division is an information technology and management consulting organization that delivers integrated, strategic solutions to federal clients. We bring expertise in cloud, cybersecurity, enterprise architecture, data modernization, and digital transformation to support mission-critical government programs.  

 

Join a team accelerating the modernization of a large federal agency's enterprise data and analytics ecosystem. This cloud-based platform provides data storage, analytics, governance, and AI/ML capabilities that enable thousands of users to transform data into actionable insights. As demand continues to grow, the team is focused on migrating legacy workloads, streamlining onboarding and support, expanding platform capabilities, and helping organizations across the enterprise adopt modern data and AI solutions at scale. 

 

The Data Integration Engineer implements data movement, replication, APIs, interoperability patterns, and source-system integration support needed to connect source systems and legacy data pathways to Summit. Coordinates secure connectivity with Platform Engineering and Security, documents approved connection patterns, and supports reliable feeds by validating performance, lineage, error handling, and operational runbooks. 


Job Location: Remote, however, strong preference for candidates who live in the Washington DC Metro Area. There will be occasional onsite meetings on the client site in Washington, DC. 


*If you accept this position, you should note that ICF does monitor employee work locations, blocks access from foreign locations/foreign IP addresses, and prohibits personal VPN connections. 


What You Will Do: 

  • Implements data movement, replication, APIs, interoperability patterns, and source-system integration support needed to connect source systems and legacy data pathways to Summit. 
  • Coordinates secure connectivity with Platform Engineering and Security, documents approved connection patterns, and supports reliable feeds by validating performance, lineage, error handling, and operational runbooks. 
  • Apply Data integration, APIs, replication, source-system connectivity, secure data movement, ETL/ELT, operational runbooks, and migration support to support role delivery. 
  • Collaborate with relevant product, engineering, security, governance, quality, and customer-facing stakeholders as required by the role. 
  • Document work products, decisions, risks, and delivery evidence to support traceability and continuous improvement. 

Basic Qualifications: 

  • U.S. Citizenship is required due to federal contract 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. 
  • Bachelor's degree in Computer Science, Data Engineering, Information Systems, Database Administration, Systems Engineering, Cloud Engineering, or related field; or a high school diploma with four (4) additional years of relevant experience in lieu of a bachelor's degree. 
  • Minimum 6 years of relevant experience aligned to the responsibilities of this role. 
  • Master's degree may substitute for two (2) years of relevant experience. 

Preferred Qualifications: 

  • Experience designing, implementing, and supporting enterprise-scale data integration, interoperability, and data movement solutions across cloud, hybrid, and on-premises environments. 
  • Strong experience implementing ETL/ELT pipelines, data replication strategies, ingestion frameworks, and migration solutions utilizing Databricks, Delta Lake, Azure Data Factory, Spark, SQL, and Python. 
  • Experience supporting large-scale legacy data warehouse modernization and migration initiatives, including data validation, reconciliation, and migration cutover activities. 
  • Experience designing and implementing API-based, event-driven, batch, and streaming integration patterns utilizing REST APIs, MuleSoft, Azure Event Hubs, messaging frameworks, or comparable technologies. 
  • Experience implementing secure data exchange, data-sharing, and interoperability solutions across multiple platforms, business domains, and cloud environments. 
  • Experience with Databricks Lakehouse architecture, Delta Sharing, Lakehouse Federation, Unity Catalog, and modern data-sharing frameworks. 
  • Experience integrating structured, semi-structured, and unstructured data sources into enterprise analytics platforms. 
  • Experience implementing secure connectivity patterns, network integration controls, identity management, and access governance in collaboration with Security and Platform Engineering teams. 
  • Experience developing and maintaining operational runbooks, integration standards, connection patterns, support documentation, and troubleshooting procedures. 
  • Experience implementing data lineage, metadata capture, monitoring, observability, alerting, and operational telemetry for data integration platforms. 
  • Experience validating integration performance, throughput, latency, reliability, error handling, exception management, and operational readiness. 
  • Experience supporting cloud-native integration platforms and services including Azure Data Factory, Azure Integration Services, Databricks Workflows, APIs, Event Hubs, and comparable technologies. 
  • Experience collaborating with Data Engineers, Architects, Governance teams, Security teams, Platform Engineers, Product Owners, and operations personnel to deliver reliable and supportable integration capabilities. 
  • Familiarity with data governance, metadata management, stewardship processes, and publication controls utilizing technologies such as Unity Catalog, Collibra EDC, Microsoft Purview, or similar solutions. 
  • Strong programming and scripting skills utilizing SQL, Python, Spark, REST APIs, JSON, and data integration frameworks. 
  • Understanding of DataOps principles, automated testing, pipeline validation, deployment automation, and CI/CD integration patterns. 
  • Experience supporting Federal government, healthcare, or other highly regulated environments preferred. 
  • Experience working in Agile, DevSecOps, DataOps, or cross-functional delivery teams. 

Professional Skills: 

  • Highly effective analytical, problem-solving, and decision-making capabilities. 
  • Excellent written and verbal communication skills, with the ability to work effectively across technical and non-technical audiences. 
  • Strong organization, attention to detail, and the ability to prioritize and manage multiple responsibilities. 
  • Collaborative approach with a commitment to quality, accountability, and continuous improvement. 

#LI-CC1 

#Indeed 


Bot and Third-Party Applications

Please note that this application must be submitted directly by the applicant for consideration. Failure to do so may result in the application being excluded for consideration.  Applicants needing an accommodation for disability or religious purposes in connection with the application process should contact [email protected] for assistance.

Working at ICF

ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.

We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy.

We will consider for employment qualified applicants with arrest and conviction records.

 

Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email [email protected] and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.  

Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. 

 

Candidate AI Usage Policy

At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.  

However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at [email protected]. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.  


 

Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.

The pay range for this position based on full-time employment is:

$81,499.00 - $138,549.00

Nationwide Remote Office (US99)

Skills Required

  • U.S. citizenship
  • Must reside in the United States
  • Must be authorized to work in the United States
  • All work must be performed in the United States
  • Must have lived in the United States for three full years out of the last five years
  • Bachelor's degree in Computer Science, Data Engineering, Information Systems, Data Science, Statistics, Software Engineering, or a related field
  • High school diploma plus four additional years of relevant experience may substitute for a bachelor's degree
  • Minimum three years of relevant experience aligned to the role responsibilities
  • Master's degree may substitute for two years of relevant experience
  • Experience designing, building, and maintaining modern cloud-based data pipelines, data products, and analytical data platforms
  • Experience with Databricks, Delta Lake, Apache Spark, SQL, and Python
  • Experience implementing ETL/ELT pipelines with Databricks Workflows, Azure Data Factory, Spark, notebooks, orchestration frameworks, and DataOps practices
  • Experience designing and implementing Lakehouse architectures with bronze, silver, and gold layers
  • Experience developing semantic views, conformed dimensions, curated data products, and consumption-ready datasets
  • Experience supporting enterprise data warehouse modernization, migration, and cloud transformation initiatives
  • Experience implementing data quality controls, validation checks, exception handling, automated testing, and release-readiness processes
  • Experience maintaining metadata, lineage documentation, pipeline documentation, operational runbooks, and technical design artifacts
  • Experience with Unity Catalog, metadata management solutions, and governance controls
  • Experience supporting Power BI, enterprise reporting platforms, semantic models, and analytical consumption layers
  • Experience designing data models for machine learning, predictive analytics, data science, NLP, and generative AI use cases
  • Experience supporting MLOps and AI/ML workflows
  • Experience implementing DataOps practices, automated deployments, CI/CD integration, observability, monitoring, defect resolution, and operational telemetry
  • Experience collaborating with Data Owners, Product Owners, Governance teams, Data Scientists, AI Engineers, Architects, and customer stakeholders
  • Familiarity with Azure Data Factory, Azure Machine Learning, Azure storage services, Azure Event Hubs, or comparable technologies
  • Experience supporting federal government, healthcare, or other highly regulated environments
  • Experience working in Agile, DataOps, DevSecOps, or cross-functional delivery teams
  • Strong analytical, problem-solving, and decision-making capabilities
  • Excellent written and verbal communication skills
  • Strong organization, attention to detail, and ability to manage multiple responsibilities
  • Collaborative approach with commitment to quality, accountability, and continuous improvement

ICF Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about ICF and has not been reviewed or approved by ICF.

  • Healthcare Strength — Multiple medical plan choices (UHC PPO/HDHP and Kaiser in some areas) come with employer HSA/HRA funding and wellness incentives, with dental and vision included. Mental-health access is emphasized via Modern Health, offering up to 10 therapy and 10 coaching sessions annually.
  • Parental & Family Support — Family-building resources include Maven support on UHC plans, $10,000 lifetime fertility/surrogacy reimbursement, and $5,000 for adoption, milk-shipping, and clinician-led programs. Caregiver and 24/7 resources are also available through the EAP.
  • Equity Value & Accessibility — An Employee Stock Purchase Plan with a 5% discount is broadly available and regularly highlighted in postings. This adds a straightforward path for employees to build ownership alongside salary and benefits.

ICF Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Reston, VA
9,000 Employees
Year Founded: 1969

What We Do

ICF is a leading global solutions and technology provider with approximately 9,000 employees in industries across the public and private sectors. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.

Why Work With Us

At ICF, we’ve built a culture rooted in expertise, innovation, and purpose—enabling us to build a more prosperous and resilient world for all. When our employees grow, our solutions thrive—regardless of your role, team, or location, you’ll have opportunities to make connections, build community, and take action to develop your career.

Gallery

Gallery

Similar Jobs

mPulse Logo mPulse

Integration Engineer

Artificial Intelligence • Healthtech • Software • Analytics
Remote
United States
631 Employees
In-Office or Remote
2 Locations
9000 Employees
81K-139K Annually

Peraton Logo Peraton

Senior GIS Developer - Spatial Data & Integration

Aerospace • Information Technology • Security • Cybersecurity • Defense
Remote
United States
18000 Employees
66K-106K Annually

Clarium Logo Clarium

Integration Engineer

Artificial Intelligence • Healthtech • Software
Remote
US
47 Employees
130K-150K Annually

Similar Companies Hiring

Charted, Inc. Thumbnail
Software • Payments • Fintech • Financial Services • Consulting • Automation • Artificial Intelligence
Boston, MA
72 Employees
Teragonia Thumbnail
Artificial Intelligence • Big Data • Machine Learning • Software • Analytics • Business Intelligence • Consulting
Chicago, IL
50 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account