Cloud Data Migration Specialist

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Oversee comprehensive data migration processes, which encompass source data evaluation, migration strategy, extraction, transformation, loading, and validation.

• Examine source and target data models, structures, relationships, dependencies, and assess data quality.

• Create and sustain Source-to-Target Mapping documents, data dictionaries, and transformation guidelines.

• Utilize ETL tools, SQL, and Salesforce data migration utilities for data cleansing, transformation, and loading tasks.

• Handle Salesforce data dependencies, which include object relationships, external IDs, record ownership, and parent-child associations.

• Perform mock conversions, troubleshoot migration challenges, and enhance migration processes prior to production deployment.

• Carry out production migrations and conduct data reconciliation as well as post-migration validation.

• Partner with business stakeholders to verify migrated data, address discrepancies, and secure formal approval.

• Keep migration documentation, runbooks, validation reports, and issue logs up to date.

• Collaborate with business stakeholders, Business Analysts, Salesforce Architects, and Developers to integrate federal grant programs onto GrantLens, a Salesforce-based Grants Management application.

⛳️ Requirements

• Minimum of 3 years of experience in enterprise data migration, data conversion, ETL development, or data integration.

• At least 3 years of experience in data modeling, relational databases, and intricate data relationships.

• Over 3 years of experience in planning and executing comprehensive data migrations into Salesforce.

• A minimum of 2 years of experience with Salesforce Data Loader, Salesforce Inspector, Workbench, Salesforce APIs, or comparable migration utilities.

• At least 2 years of experience using ETL tools and technologies for data extraction, transformation, cleansing, and loading.

• A minimum of 2 years of experience in SQL, crafting queries and scripts for data profiling, transformation, and validation.

• Over 2 years of experience in developing Source-to-Target Mapping documentation and managing data quality, reconciliation, and migration exceptions.

• Familiarity with Salesforce Public Sector Solutions (PSS), Service Cloud, or other enterprise Salesforce applications.

• A strong understanding of Salesforce data architecture, including standard/custom objects, lookup and master-detail relationships, and external IDs.

• Experience with ETL platforms like Informatica, Talend, MuleSoft, Azure Data Factory, or SSIS.

• Experience using Salesforce Bulk API and techniques for large-volume data migrations.

• Proven experience in automating data migration, validation, and reconciliation processes.

• Background in developing migration cutover plans, rollback procedures, and production migration runbooks.

• Experience supporting federal government or other complex enterprise data migration projects.

• Knowledge of FISMA, FedRAMP, and NIST security and compliance standards.

• Relevant Salesforce or data management certifications.

🏝️ Benefits

• Occasional travel to the client's Washington, D.C. office.

• Equal opportunity employer.

• Reasonable accommodations for disabilities, veteran status, and sincerely held religious beliefs.

• Benefits information provided under the Transparency in Benefits Coverage Act.