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