Job Specifications
Migration Analyst (SalesForce)
Role Purpose
The Data Migration Analyst plays a critical role in delivering successful system transitions by ensuring data is moved accurately, securely, and efficiently between platforms. With a strong emphasis on Salesforce migrations, this role requires deep analytical capability, strong ETL expertise, and the confidence to manage complex data transformations across varied source systems. The analyst ensures migrated data is trustworthy, well-governed, and aligned with business expectations in the target Salesforce environment.
Core Responsibilities
Source Data Analysis & Discovery
Examine legacy and upstream systems to understand data models, relationships, volumes, and dependencies, with particular focus on Salesforce target structures
Conduct detailed data profiling to surface quality issues, gaps, and transformation risks ahead of migration
Engage with business stakeholders and Salesforce SMEs to confirm data meanings, rules, and migration assumptions
Migration & ETL Solution Design
Design and implement robust ETL solutions to move data into Salesforce, adhering to agreed mappings, transformation rules, and load strategies
Build and document complex transformation logic with full traceability from source to Salesforce objects and fields
Ensure migration pipelines are scalable and performant, using batching, incremental loads, and optimisation techniques
Testing, Reconciliation & Cutover Support
Define and execute reconciliation, validation, and audit checks to confirm data completeness and accuracy post-migration
Develop repeatable test and validation approaches to support multiple migration cycles and rehearsals
Support cutover activities, defect resolution, and post-load verification in collaboration with testing and release teams
Data Quality & Governance
Embed data quality controls throughout the migration lifecycle to ensure Salesforce data meets agreed standards
Identify source data defects and contribute to cleansing, enrichment, or remediation strategies
Maintain clear metadata, lineage, and audit trails for migrated data
Collaboration & Continuous Improvement
Work closely with Salesforce architects, data engineers, DBAs, and business SMEs to ensure migration outcomes align with the target Salesforce design
Share lessons learned and promote best practices for Salesforce data migration and ETL development
Continuously refine migration frameworks, automation, and tooling to improve reliability and efficiency
Key Skills & Experience
Proven experience delivering large-scale data migrations into Salesforce, from discovery through to cutover and post-migration validation
Strong background in ETL design and implementation using tools such as SSIS, Azure Data Factory, or equivalent
Extensive hands-on SQL experience, including complex querying, profiling, reconciliation, and stored procedures
Deep understanding of Salesforce data models, objects, relationships, and data loading approaches
Demonstrated expertise in data mapping, transformation logic, lineage, and reconciliation techniques
Experience with migration strategies including incremental loads, delta handling, mock runs, rehearsals, and rollback planning
Ability to quickly build a working understanding of unfamiliar source data, including meaning, structure, and quality challenges
Experience simplifying and standardising ETL logic to improve maintainability and reduce operational risk
Exposure to performance, scalability, and reusability non-functional requirements
Experience in regulated or highly controlled environments is advantageous
Personal Attributes
Curious by nature, with a strong drive to fully understand data behaviour and anomalies
Highly detail-focused while remaining pragmatic and delivery-oriented
Enjoys turning complex, imperfect source data into clean, structured Salesforce datasets
Confident working at the intersection of technical delivery and business understanding
Values collaboration, learning, and continuous improvement in fast-moving migration programmes