HR Data Migration Specialist

CE Back Office; Manchester; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading HR consulting firm in Manchester seeks an experienced HR Data Migration Specialist to design and migrate complex HR datasets from various platforms including Workday and SAP SuccessFactors. The role focuses on ensuring data accuracy and compliance during migration, requiring strong expertise in ETL tools and data transformation logic. Ideal candidates will have proven experience in delivering HR data migrations and will work closely with technical and HR teams to ensure smooth implementation and post-go-live support.

Qualifications

• Proven experience in HR data migrations from Workday, Oracle HCM, and SAP SuccessFactors.
• Strong hands-on experience with various ETL tools.
• Demonstrable SQL skills and ability to work with complex datasets.

Responsibilities

• Lead HR data migrations from source systems into target platforms.
• Design complex data transformations and mappings.
• Perform data cleansing and alignment with target data models.
• Develop data validation strategies and reconcile data.
• Support HR business requirements and translate them into technical logic.

Skills

Data migration from Workday

ETL tools expertise

SQL skills

Data transformation logic

HR data architecture

Tools

Informatica

Talend

Boomi

MuleSoft

Azure Data Factory

Job description

Overview

The HR Data Migration Specialist is responsible for designing, transforming, and migrating complex HR data from legacy HCM platforms into target HR systems. This role plays a critical part in HR system implementations and transformations, ensuring data integrity, accuracy, and compliance throughout the migration lifecycle.

The role requires deep hands-on experience migrating data from Workday, Oracle HCM, and SAP SuccessFactors, alongside strong expertise in ETL tooling, HR data architecture, and complex transformation logic.

Key Responsibilities

• Data Migration & Transformation: Lead end-to-end HR data migrations from source systems including Workday, Oracle HCM, and SAP SuccessFactors into target HR platforms
• Data Migration & Transformation: Design and execute complex data transformations, mappings, and business rules across multiple HR domains (Core HR, Org Structures, Compensation, Talent, Absence, Payroll interfaces)
• Data Migration & Transformation: Build, configure, and maintain ETL processes to extract, transform, and load HR data accurately and efficiently
• Data Migration & Transformation: Perform data cleansing, enrichment, and standardisation to align with target data models

HR Data Design & Architecture

• Define and validate HR data models, structures, and hierarchies in line with best practice and target system requirements
• Advise on HR data design decisions, including effective dating, historical data strategies, and country-specific requirements
• Ensure alignment between HR functional design and technical data structures

Testing, Validation & Cutover

• Develop and execute data validation strategies, reconciliation checks, and exception handling
• Support unit testing, system testing, parallel runs, and cutover activities
• Identify, analyse, and resolve data defects and inconsistencies
• Produce migration documentation including mapping specs, transformation logic, and run books

Stakeholder & Delivery Support

• Work closely with HR, Payroll, Finance, and Technical teams to understand data requirements
• Translate HR business rules into technical transformation logic
• Provide guidance and assurance on data quality, risk, and readiness
• Support go-live and post-implementation stabilisation activities

Required Experience & Skills

Essential:

• Proven experience delivering HR data migrations from Workday, Oracle HCM, and SAP SuccessFactors
• Strong hands-on experience with ETL tools (e.g. Informatica, Talend, Boomi, MuleSoft, Azure Data Factory, or equivalent)
• Deep understanding of HR data structures and design, including effective dating, organisational hierarchies, and employee lifecycle data
• Demonstrable experience performing complex data transformations, including cross-object logic and historical data handling
• Strong SQL skills and experience working with large, complex datasets
• Experience supporting multiple migration cycles (mock loads, dress rehearsals, cutover)

Desirable:

• Experience working on global or multi-country HR implementations
• Exposure to Payroll, Time & Attendance, or Finance data integrations
• Experience in data governance, data quality frameworks, or GDPR-compliant data handling
• Consulting or transformation programme experience

Key Competencies

• High attention to detail and data accuracy
• Strong analytical and problem-solving skills
• Ability to translate business requirements into technical solutions
• Comfortable working in fast-paced, delivery-focused environments
• Clear communicator with both technical and non-technical stakeholders