Cloud Data Migration Specialist

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

📋 Description

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

• Assess source and target data models, data structures, relationships, dependencies, and data quality standards.

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

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

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

• Perform mock conversions, address migration challenges, and enhance migration procedures prior to production rollout.

• Carry out production migrations and conduct data reconciliation along with post-migration validation.

• Collaborate with business stakeholders to confirm migrated data, resolve inconsistencies, and secure formal approval.

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

• Assist in onboarding federal grant programs onto GrantLens, a comprehensive Salesforce-based Grants Management application.

⛳️ Requirements

• A minimum of 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 intricate data relationships.

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

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

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

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

• Over 2 years of experience in creating 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.

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

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

• Proficiency in Salesforce Bulk API and techniques for large-volume data migration.

• Experience in automating data migration, validation, and reconciliation workflows.

• Proven experience in developing migration cutover plans, rollback strategies, and production migration runbooks.

• Background in 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

• Equal opportunity employer.

• Reasonable accommodations for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs.

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