Data Migration Specialist - Senior
About the Opportunity
SStech LLC is seeking an experienced data migration specialist - senior to support a large-scale, greenfield Salesforce customer technology transformation for a regulated energy and utilities organization. The program is modernizing utility customer operations, customer programs, service experiences, data capabilities, integrations, and legacy Salesforce environments while reducing technical debt and preparing the future-state platform for production adoption.
The core technology landscape includes Salesforce Energy & Utilities Cloud, Service Cloud, Sales Cloud, Data Cloud, OmniStudio with particular emphasis on OmniScript, the Salesforce Clean Energy Module, Salesforce Flow, enterprise integrations, data migration, security, release engineering, and quality engineering. SAP BTP and customer-facing APIs are part of the broader integration ecosystem. Agentforce or other Salesforce AI capabilities may be introduced as the broader AI strategy develops.
This is a hands-on, delivery-focused role that remains engaged from discovery and design through implementation, testing, release readiness, deployment, and production transition. All team members are expected to use client-provided or client-approved AI acceleration tools when appropriate for analysis, design, documentation, development, testing, and defect resolution. Each individual remains accountable for independently validating AI-generated outputs for accuracy, security, maintainability, privacy, and compliance.
Role Overview
The Senior Data Migration Specialist will provide onsite, hands-on migration leadership and validation support for the greenfield Salesforce implementation. The role will analyze and reconcile customer, account, service, program, clean-energy, knowledge, and operational data being loaded into Energy & Utilities Cloud, the Clean Energy Module, Service Cloud, Sales Cloud, Data Cloud, and OmniStudio-enabled processes. This individual will coordinate closely with business data owners, developers, QA, architects, and cutover teams to resolve issues and confirm business readiness.
Key Responsibilities
1. Lead assigned data-migration workstreams covering discovery, profiling, mapping, cleansing, transformation, loading, validation, reconciliation, and defect resolution.
2. Define source-to-target mappings for customer, account, service, program, clean-energy, knowledge, case, and operational data supporting Energy & Utilities Cloud, the Clean Energy Module, Service Cloud, Sales Cloud, Data Cloud, and OmniStudio processes.
3. Coordinate business data owners, developers, architects, QA, and integration teams to confirm data definitions, ownership, quality expectations, and migration readiness.
4. Plan and support mock loads, trial conversions, cutover rehearsals, production migration, post-load validation, and issue remediation.
5. Maintain mapping workbooks, transformation rules, data-quality findings, reconciliation evidence, issue logs, and cutover documentation.
6. Communicate migration risks, dependencies, decisions, and readiness status clearly to business and technical stakeholders.
Required Qualifications
1. 7+ years of relevant enterprise delivery experience, including senior-level ownership of complex workstreams, mentoring, and delivery quality.
2. Hands-on data migration experience including data profiling, source-to-target mapping, ETL or ELT, SQL or data querying, transformation rules, validation, and reconciliation.
3. Experience migrating data into Salesforce objects and relationships, with understanding of IDs, external IDs, dependencies, load sequencing, and data-loading tools.
4. Working knowledge of Salesforce data requirements supporting Service Cloud, Data Cloud, OmniStudio, and OmniScript-driven processes, including the dependencies needed for guided workflows and customer interactions.
5. Ability to identify data-quality risks, resolve mapping questions, coordinate mock conversions, and maintain clear evidence of migration completeness and accuracy.
6. Strong communication and coordination skills across business SMEs, data owners, developers, QA, architecture, and cutover teams.
7. Experience working in Agile or iterative delivery environments with cross-functional onshore and offshore teams.
8. Strong verbal and written communication skills, including the ability to explain decisions, document risks and dependencies, and collaborate directly with business and technology stakeholders.
9. Experience using enterprise-approved AI-assisted tools where appropriate, with independent validation of outputs.
Preferred Qualifications
1. Experience migrating data for Salesforce Energy & Utilities Cloud and/or the Salesforce Clean Energy Module in utility customer information system, clean-energy, or regulated-industry programs.
2. Data Cloud, enterprise data platforms, SAP, API, or middleware experience.
3. Salesforce Data Cloud, Administrator, Energy & Utilities Cloud, data management, ETL, or cloud certifications.