Data Migration Lead / Specialist - Oracle HCM Cloud
Location: UK Wide
Travel Requirements: Approximately one onsite visit per month to Edinburgh, Birmingham or London
Rate: Competitive (inside IR35)
Contract Length: 12-month programme engagement plus 3 months of post-go-live hypercare

The Opportunity
We are seeking an experienced Data Migration Lead / Specialist to take ownership of the end-to-end migration of HR, workforce and payroll data into Oracle HCM Cloud as part of a major business transformation programme.
This role is critical to supporting the migration away from Aegon's HR and payroll platforms by the end of 2027. The successful candidate will lead the movement of HR, payroll and workforce data from Workday and associated satellite systems into Oracle HCM Cloud, ensuring all data is accurate, reconciled, secure and fully operational in the target environment.
This is a hands-on delivery role requiring a genuine "doer" rather than someone who purely coordinates activity. You will be responsible for the entire migration lifecycle, from discovery and profiling through extraction, transformation, cleansing, loading, testing, reconciliation and final cutover. A key milestone for the role will be the completion of discovery activities by the end of Q1.

Key Responsibilities

• Own the end-to-end data migration strategy, planning and delivery across HR, workforce and payroll data domains.
• Lead source-system discovery and data profiling activities, identifying data quality issues, dependencies and migration risks.
• Complete discovery and migration readiness assessments by the end of Q1.
• Define and maintain source-to-target mappings between Workday, payroll systems, satellite applications and Oracle HCM Cloud.
• Lead data extraction, transformation and load (ETL) activities, including cleansing, standardisation and validation.
• Establish and manage reconciliation processes, controls and validation frameworks to ensure data completeness and accuracy.
• Plan and execute multiple migration cycles to support System Integration Testing (SIT), User Acceptance Testing (UAT), payroll testing and production deployment.
• Lead dress rehearsals, delta migrations and final cutover activities.
• Work closely with HR, Payroll, Technology, Data Governance, Security and Programme teams, as well as Oracle implementation partners.
• Manage migration risks, issues and dependencies throughout the programme lifecycle.
• Support go-live and post-production hypercare activities through to programme completion.

Essential Experience

• Significant experience delivering complex HR and payroll data migrations within large-scale transformation programmes.
• Proven experience migrating data from Workday or similar HCM platforms into Oracle HCM Cloud.
• Strong hands-on experience across the full migrationlifecycle, including:
  • Data discovery and profiling
  • ETL design and execution
  • Data cleansing and remediation
  • Source-to-target mapping
  • Data loading
  • Validation and reconciliation
  • Cutover and post-go-live support
• Experience supporting multiple testing cycles, including SIT, UAT, payroll parallel runs, dress rehearsals and production migrations.
• Strong understanding of payroll and workforce data structures and dependencies.
• Experience managing delta migrations and complex cutover activities.
• Strong knowledge of data governance, information security and controls relating to sensitive employee and payroll data.
• Strong stakeholder management and communication skills.
• Ability to work independently and take ownership of delivery in a complex programme environment.

Guidant, Carbon60, Lorien & SRG - The Vertage Group Portfolio are acting as an Employment Business in relation to this vacancy.