Data Engineer

Role Summary

This role supports the large-scale modernization of legacy systems by leading the migration of documentation and records into a cloud-based environment. The position focuses on transforming document-heavy workflows into structured, digital processes, while enabling seamless data integration across systems using MuleSoft APIs. The work directly supports enhanced analytics, reporting, and operational efficiency for a mission-critical enterprise platform.

Responsibilities

• Lead end-to-end data migration from legacy systems to cloud platforms, including data mapping, transformation, and validation (Salesforce-centric).
• Analyze and convert unstructured, document-heavy data into structured, analytics-ready formats using Document AI.
• Implement data quality processes (cleansing, deduplication, reconciliation) to ensure accuracy and completeness post-migration.
• Support phased migration and system cutover with minimal operational disruption.
• Design, build, and maintain MuleSoft integrations, including API development for real-time and batch data exchange.
• Apply data transformation logic (e.g., DataWeave) and troubleshoot integration/data flow issues across systems.
• Contribute to Salesforce Data 360 implementation, including data harmonization, identity resolution, and unified profiles.
• Ensure proper data ingestion, lineage, metadata management, and traceability across the ecosystem.
• Ensure compliance with data governance, privacy, and security requirements (e.g., PII).
• Collaborate in Agile teams; support testing, documentation, and audit readiness across migration and integration efforts.

Requirements

• U.S. Citizenship required due to federal contract requirements
• Ability to obtain and maintain a Public Trust clearance
• Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years
• 6+ years of experience in data engineering, data migration, or data integration roles
• Proven experience executing large-scale data migration efforts, including legacy system transformation
• 2+ years hands-on experience with Salesforce data migrations, including data modeling, data loading (e.g., Data Loader, APIs), and managing relational datasets
• 2+ years' experience implementing data quality, validation, and reconciliation processes during migration efforts

Preferred Qualifications

• Current or recent Public Trust or active Secret clearance
• Experience supporting DHS or other federal agencies
• 1+ year Experience using Informatica (e.g., PowerCenter, IICS) for ETL/ELT development, data mapping, and pipeline orchestration
• 2+ years proficiency in SQL and relational data modeling concepts
• Experience working with both structured and unstructured data, including document-based records
• 1+ year Experience supporting or developing MuleSoft integrations, including API development, data transformations, and system-to-system data flows
• 1+ years experience with MuleSoft Anypoint Platform, including DataWeave and API-led connectivity patterns
• Familiarity with cloud-based SaaS platforms and distributed data architectures
• Familiarity with metadata management, data lineage, and audit frameworks
• Experience working in federal or highly regulated environments
• Experience supporting Agile delivery teams and cross-functional collaboration
• Experience supporting large-scale, document-centric system migrations
• Familiarity with Docusign eSignature and Contract Lifecycle Management (CLM) products a plus
• Experience with Salesforce Data 360 (Data Cloud), including data harmonization and identity resolution
• Experience with Salesforce Document AI / Intelligent Document Processing (IDP) tools for extracting structured data from documents
• Understanding of data governance, security, and compliance requirements, particularly for sensitive data (e.g., PII)
• # ICF cleared
• 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 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 theirexpertiseand collaborate with others to achieve personal and professional goals. For more information, please read our EEOpolicy.

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 withsincerely heldreligious beliefs, in all phases of the application and employment process. To requestan accommodation,please email  and we will be happy toassist. All information you provide will be kept confidential and will be used only to the extentrequiredto provide needed reasonable accommodations.

Read more about workplace discrimination rightsor our benefit offerings which are included in the Transparency in (Benefits) CoverageAct.

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 orassistwith responses during interviews (whether in-person or virtual) is notpermitted. This policy is in place tomaintainthe integrity and authenticity of the interview process.

However, we understand that some candidates may require accommodation that involves the use of AI. Ifsuch anaccommodation is needed, candidates are instructed to contact us in advance at . Weare dedicated to providingthe 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:

$98,614.00 - $167,644.00Nationwide Remote Office (US99)

About the Company

Why Join Our Reservist Team?

About On-Call Employment with ICF

Due to the seasonal or project-specific nature of our disaster and emergency management work, ICF hires professionals as "On-Call" employees. On-Call employees are scheduled for work as it becomes available, with the freedom to accept or decline assignments. Individuals may work on concurrent projects outside of their ICF assignments, provided there is no conflict of interest.

For many professionals, this model provides the opportunity to contribute to meaningful disaster recovery efforts while maintaining flexibility and pursuing other professional interests.

Please provide an updated resume that highlights experience relevant to the qualifications listed below, including construction, estimating, disaster recovery, FEMA Public Assistance, infrastructure assessment, and related technical expertise, where applicable.

Support communities during some of their most critical moments of recovery.

Apply your expertise to meaningful, real-world challenges.

Gain experience across a variety of disaster recovery programs and geographies.

Work alongside experienced disaster recovery professionals committed to helping communities rebuild.

Enjoy the flexibility of on-call employment while remaining connected to impactful work.