Job Title

Migration Analyst (SalesForce)Role PurposeThe 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 ResponsibilitiesSource Data Analysis & DiscoveryExamine legacy and upstream systems to understand data models, relationships, volumes, and dependencies, with particular focus on Salesforce target structuresConduct detailed data profiling to surface quality issues, gaps, and transformation risks ahead of migrationEngage with business stakeholders and Salesforce SMEs to confirm data meanings, rules, and migration assumptionsMigration & ETL Solution DesignDesign and implement robust ETL solutions to move data into Salesforce, adhering to agreed mappings, transformation rules, and load strategiesBuild and document complex transformation logic with full traceability from source to Salesforce objects and fieldsEnsure migration pipelines are scalable and performant, using batching, incremental loads, and optimisation techniquesTesting, Reconciliation & Cutover SupportDefine and execute reconciliation, validation, and audit checks to confirm data completeness and accuracy post-migrationDevelop repeatable test and validation approaches to support multiple migration cycles and rehearsalsSupport cutover activities, defect resolution, and post-load verification in collaboration with testing and release teamsData Quality & GovernanceEmbed data quality controls throughout the migration lifecycle to ensure Salesforce data meets agreed standardsIdentify source data defects and contribute to cleansing, enrichment, or remediation strategiesMaintain clear metadata, lineage, and audit trails for migrated dataCollaboration & Continuous ImprovementWork closely with Salesforce architects, data engineers, DBAs, and business SMEs to ensure migration outcomes align with the target Salesforce designShare lessons learned and promote best practices for Salesforce data migration and ETL developmentContinuously refine migration frameworks, automation, and tooling to improve reliability and efficiencyKey Skills & ExperienceProven experience delivering large-scale data migrations into Salesforce, from discovery through to cutover and post-migration validationStrong background in ETL design and implementation using tools such as SSIS, Azure Data Factory, or equivalentExtensive hands-on SQL experience, including complex querying, profiling, reconciliation, and stored proceduresDeep understanding of Salesforce data models, objects, relationships, and data loading approachesDemonstrated expertise in data mapping, transformation logic, lineage, and reconciliation techniquesExperience with migration strategies including incremental loads, delta handling, mock runs, rehearsals, and rollback planningAbility to quickly build a working understanding of unfamiliar source data, including meaning, structure, and quality challengesExperience simplifying and standardising ETL logic to improve maintainability and reduce operational riskExposure to performance, scalability, and reusability non-functional requirementsExperience in regulated or highly controlled environments is advantageousPersonal AttributesCurious by nature, with a strong drive to fully understand data behaviour and anomaliesHighly detail-focused while remaining pragmatic and delivery-orientedEnjoys turning complex, imperfect source data into clean, structured Salesforce datasetsConfident working at the intersection of technical delivery and business understandingValues collaboration, learning, and continuous improvement in fast-moving migration programmes