Remote Salesforce Data Migration Expert

ICF; Reston (VA); Remote; USD 81,000 - 139,000; Full time

Job summary

ICF is seeking a Cloud Data Migration Specialist to lead end-to-end migration of federal grant programs onto GrantLens, a Salesforce-based system. You will assess legacy data, define STM mappings, and execute reliable data conversions, working with stakeholders, Salesforce architects, and developers to ensure data integrity.

Remote within the U.S. with occasional travel to Washington, D.C., you will leverage ETL, SQL, and Salesforce utilities to transform complex legacy data into structured data

Qualifications

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

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 (STM) 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.
• Maintain migration documentation, runbooks, validation reports, and issue logs.

Skills

Data migration

ETL development

Data modeling

SQL

Salesforce data migration

Stakeholder collaboration

Tools

Salesforce Data Loader

Workbench

Salesforce APIs

ETL tools

Job description

ICF is seeking a Cloud Data Migration Specialist to lead end-to-end migration of federal grant programs onto GrantLens, a Salesforce-based system. You will assess legacy data, define STM mappings, and execute reliable data conversions, working with stakeholders, Salesforce architects, and developers to ensure data integrity.

Remote within the U.S. with occasional travel to Washington, D.C., you will leverage ETL, SQL, and Salesforce utilities to transform complex legacy data into structured data