Cloud Data Migration Specialist

ICF • Reston, VA

1d • Remote

About The Position

ICF is hiring a Cloud Data Migration Specialist to support onboarding federal grant programs onto GrantLens, a large-scale Salesforce-based Grants Management application. The specialist leads end-to-end data migration, partnering with business stakeholders, Business Analysts, Salesforce Architects, and Developers to assess legacy data, create migration strategies and source-to-target mappings, and execute reliable data conversions. The role uses data modeling, ETL, and Salesforce migration expertise to transform legacy data into structured formats that support GrantLens business processes and ensure data integrity and quality from initial assessment through production migration and validation.

The position is fully remote within the U.S., with occasional travel to the client’s Washington, D.C. office. The role must support U.S. Eastern time zone working hours.

Requirements

• At least 3 years of experience in enterprise data migration, data conversion, ETL development, or data integration.
• At least 3 years of experience with data modeling, relational databases, and complex data relationships.
• At least 3 years of experience planning and executing end-to-end data migrations into Salesforce.
• At least 2 years of experience with Salesforce Data Loader, Salesforce Inspector, Workbench, Salesforce APIs, or similar migration utilities.
• At least 2 years of experience with ETL tools and technologies for data extraction, transformation, cleansing, and loading.
• At least 2 years of experience using SQL to develop queries and scripts for data profiling, transformation, and validation.
• At least 2 years of experience developing Source-to-Target Mapping documentation and managing data quality, reconciliation, and migration exceptions.

Nice To Haves

• Experience with Salesforce Public Sector Solutions (PSS), Service Cloud, or other enterprise Salesforce applications.
• Strong understanding of Salesforce data architecture, including standard and custom objects, lookup and master-detail relationships, and external IDs.
• Excellent analytical, problem-solving, and communication skills.
• Experience with ETL platforms such as Informatica, Talend, MuleSoft, Azure Data Factory, or SSIS.
• Experience with Salesforce Bulk API and large-volume data migration techniques.
• Experience automating data migration, validation, and reconciliation processes.
• Experience developing migration cutover plans, rollback procedures, and production migration runbooks.
• Experience supporting federal government or other complex enterprise data migration initiatives.
• Familiarity with FISMA, FedRAMP, and NIST security and compliance requirements.
• Relevant Salesforce or data management certifications.

Responsibilities

• Lead end-to-end data migration activities, including source data assessment, migration planning, extraction, transformation, loading, and validation.
• Analyze source and target data models, structures, relationships, dependencies, and data quality.
• Develop and maintain Source-to-Target Mapping documents, data dictionaries, and transformation rules.
• Use ETL tools, SQL, and Salesforce migration utilities to cleanse, transform, and load data.
• Manage Salesforce data dependencies, including object relationships, external IDs, record ownership, and parent-child relationships.
• Conduct mock conversions, troubleshoot migration issues, and refine migration processes before production deployment.
• Execute production migrations and perform data reconciliation and post-migration validation.
• Collaborate with business stakeholders to validate migrated data, resolve discrepancies, and obtain formal sign-off.
• Maintain migration documentation, runbooks, validation reports, and issue logs.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed