Note: The job is a remote job and is open to candidates in USA. ICF is a global advisory and technology services provider that combines specialized expertise with technology to help clients solve complex challenges. The Data Engineer will lead large-scale legacy system migrations to cloud platforms, transform document-heavy data into structured formats, and build MuleSoft integrations supporting Salesforce, analytics, governance, and operational efficiency.
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
Skills
- 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
- 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)
Company Overview