Cloud Data Migration Specialist- Remote

ICF Incorporated, LLC; Washington; Remoto; USD 81.000 - 139.000; Tempo pieno

Descrizione del lavoro

ICF Incorporated, LLC is seeking a Senior Data Migration Lead to manage end-to-end Salesforce data migrations and ETL workflows. You will assess sources, design mappings, and validate migrated data, coordinating with stakeholders to ensure accuracy and sign-off.

The role requires strong SQL, extensive ETL experience, and familiarity with Salesforce utilities. Remote in the U.S. with occasional travel to DC supports US Eastern time.

Competenze

• 5+ years in enterprise data migration, conversion, ETL or data integration.
• 3+ years in data modeling and complex relationships.
• 3+ years planning end-to-end migrations into Salesforce.
• 2+ years with Salesforce data utilities (Data Loader, Inspector, Workbench).
• 2+ years working with ETL tools for extraction, transformation, cleansing and loading.
• 2+ years writing SQL for profiling, transformation and validation.

Mansioni

• Lead end-to-end data migration activities from assessment to validation.
• Analyze source and target data models, relationships, and data quality.
• Develop STM documents, data dictionaries, and transformation rules.
• Leverage ETL tools, SQL, and Salesforce migration utilities to cleanse and load data.
• Manage Salesforce data dependencies and object relationships.
• Conduct mock conversions and refine migration processes before production.
• Execute production migrations and perform data reconciliation and post-migration validation.
• Collaborate with stakeholders to validate data and obtain sign-off.
• Maintain migration runbooks, validation reports, and issue logs.

Conoscenze

Data migration

ETL development

SQL

Data modeling

Salesforce migration

Stakeholder collaboration

Migration testing

Formazione

Bachelor's degree (relevant)

Strumenti

Salesforce Data Loader

Workbench

Salesforce APIs

Informatica

Talend

MuleSoft

Azure Data Factory

SSIS

Descrizione del lavoro

Job Location:

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

What You Will Do:

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

Required Skills:

• 3+ years of experience in 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.
• 2+ years of experience developing Source-to-Target Mapping documentation and managing data quality, reconciliation, and migration exceptions.

Preferred Skills:

• Experience with Salesforce Public Sector Solutions (PSS), Service Cloud, or other enterprise Salesforce applications.
• Strong understanding of Salesforce data architecture, including standard/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.

Working at ICF

ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.

We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy.

We will consider for employment qualified applicants with arrest and conviction records.

Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email [e-mail] and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.

Candidate AI Usage Policy

At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in‑person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.

However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at [e-mail]. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.

Pay Range

There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.

The pay range for this position based on full-time employment is:

$81,499.00 - $138,549.00

Nationwide Remote Office (US99)