Data Engineer (Remote)

ICF is a global advisory and technology services provider, and they are seeking a Data Engineer to support the modernization of legacy systems by migrating documentation into a cloud-based environment. The role focuses on transforming workflows into structured processes and enabling data integration across systems, enhancing analytics 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

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
• 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)