Data Migration Analyst

Job Overview

The Data Migration Analyst will play a key role in supporting data migration, mapping, and master data management activities across multiple systems. The role ensures accurate, high-quality data transfer and integration while supporting business processes and stakeholders. The analyst will collaborate with business teams, QA, and technical teams to deliver clean, validated data and maintain governance standards.

Job Details

Work Setup: Work From Home

Schedule: Monday to Friday | 8:00 AM – 5:00 PM UK Time | 3:00 PM – 12:00 AM PHT

Holiday: Will follow UK holidays

Responsibilities

1. Static Master Data Maintenance

• Maintain and update static master data (Accounts, Contacts, Products, etc.) directly in Salesforce using Data Loader, Data Import Wizard, and other native tools.

• Ensure data accuracy, completeness, and consistency according to data standards and governance rules.

• Reconcile Salesforce master data with upstream/supplementary sources where integrations are not in place.

• Support controlled updates following release cycles, sandbox refreshes, or structural model changes.

2. Project Data Mapping & Migration

Source Data Identification

• Work with business data owners and SMEs to identify all required source data across spreadsheets, legacy CRMs, manually maintained lists, and other systems.

• Confirm volumes, date ranges, field definitions, and business usage to ensure correct interpretation before mapping.

Data Mapping to Salesforce Objects

• Analyse source structures and map fields, relationships, and reference data to Salesforce objects.

• Produce version-controlled data-mapping specifications covering transformations, dependencies, and business rules.

Data Cleansing (with Business)

• Lead data cleansing with stakeholders to remove duplicates, standardize values, populate missing mandatory fields, and correct inconsistent or deprecated values.

• Coordinate data reviews, validation sessions, and approval workshops.

Transformation & Load Preparation

• Transform and prepare data based on agreed mapping logic and cleansing rules.

• Align transformed data with controlled Salesforce reference data and the defined Core Model.

Migration Testing & QA

• Execute or support test data loads in SIT and UAT.

• Review datasets with business teams for accuracy, completeness, usability, and alignment with expected outcomes.

• Resolve defects collaboratively with QA and business testers ahead of production cutover.

3. Data Quality & Governance

• Apply internal data standards, validation logic, deduplication rules, and mandatory field requirements.

• Monitor data quality through dashboards, reports, and exception logs; drive continuous improvement.

• Manage data-related defects and improvements via Jira and governance processes.

• Align with Core Model guidelines, data dictionaries, and RACI structures.

4. Cross-Team Collaboration

• Partner with Salesforce Product Owners, Business Analysts, MuleSoft Integration teams, QA testers, DevOps engineers, and commercial stakeholders.

• Provide data expertise in project ceremonies (refinement, planning, cutover readiness).

• Support collaboration between UK&I digital teams and wider group teams aligning to CRM360/Core Model standards.

5. Operational & BAU Support

• Handle routine BAU data requests, updates, extracts, and reconciliations.

• Support one-off analysis, cleansing reviews, or investigations into data inconsistencies.

• Assist with sandbox refresh data preparation and production fix deployments.

Qualifications

Required:

• 3+ years of practical experience in data migration, data mapping, or master data management

• Hands-on experience with data migration or CRM tools (Salesforce Data Loader or Data Import Wizard a plus)

• Strong background in data cleansing, validation, deduplication, and standardization

• Experience working with multiple data sources (spreadsheets, legacy systems, CRMs)

• Ability to produce and follow data mapping and migration documentation

• Strong attention to detail and data quality focus

• Effective communication skills and experience working with business stakeholders

Preferred:

• Bachelor’s degree in IT, Computer Science, Data, Business, or equivalent

• Exposure to Salesforce CRM projects or similar CRM platforms

• Familiarity with data governance, Core Data Models, and UAT/SIT support

• Experience using Jira or similar tracking tools