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.
Required Qualifications
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
Requirements
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)
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 will consider for employment qualified applicants with arrest and conviction records.
Additional Information
Job Summary
This role supports the large-scale modernization of legacy systems by leading the migration of over 10TB 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.
Icf · West Virginia Field Office (wv66)