Data Migration Consultant

Get AI-powered advice on this job and more exclusive features.

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.

• 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

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

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

• 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

• 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

Mid-Senior level

Contract

Information Technology