Remote Cloud Data Migration Specialist — Salesforce ETL

ICF International; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

ICF is seeking a Cloud Data Migration Specialist to lead onboarding federal grant programs onto GrantLens, a Salesforce-based grants management platform. You will guide data assessment, mapping, and migration strategies with stakeholders, analysts, and developers.

Fully remote in the U.S. with occasional travel to Washington, DC. The role emphasizes data quality, validation, and production migrations, using ETL, SQL, and Salesforce migration tools.

Qualifications

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

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, data structures, relationships, dependencies, and data quality.
• Develop and maintain Source-to-Target Mapping documents, data dictionaries, and transformation rules.
• Leverage ETL tools, SQL, and Salesforce data 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 prior to 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.

Skills

Data migration

Data modeling

SQL

ETL development

Salesforce data migration

Source-to-Target Mapping

Data quality

Data dictionaries

Migration validation

Stakeholder collaboration

Tools

Salesforce Data Loader

Salesforce Inspector

Workbench

Salesforce APIs

Informatica

Talend

MuleSoft

Azure Data Factory

SSIS

Job description

ICF is seeking a Cloud Data Migration Specialist to lead onboarding federal grant programs onto GrantLens, a Salesforce-based grants management platform. You will guide data assessment, mapping, and migration strategies with stakeholders, analysts, and developers.

Fully remote in the U.S. with occasional travel to Washington, DC. The role emphasizes data quality, validation, and production migrations, using ETL, SQL, and Salesforce migration tools.