Data Migration Lead (SAP On-Prem * Oracle Fusion Cloud) - Remote - Outside IR35

Qode

13 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Job location

Remote

Tech stack

Microsoft Excel

Cloud Computing

Data Control

ETL

Data Migration

Data Profiling

Data Security

RAID

Hardware Description Language

Intrusion Detection Systems

Oracle Applications

Reference Data

SAP Applications

SAP FI

SQL Databases

Oracle Fusion Middleware

Data Management

Data Objects

Job description

Role Title: Data Migration LeadProgramme: SAP On-Prem ERP to Oracle Fusion Cloud (Finance, Procurement, HCM Core, Payroll)Role Type: Programme / Delivery Role (Workstream Lead)Reports To: Programme Director1. Role PurposeThe Data Migration Lead is accountable for planning, designing, delivering, and governing the end-to-end data migration from SAP on-prem to Oracle Fusion Cloud across Finance, Procurement, HCM Core, and Payroll. The role bridges technical and business teams to ensure high data quality, repeatable migration cycles, audit-ready reconciliation, and successful cutover execution.2. Key AccountabilitiesA) Data Migration Strategy & Governance* Define and maintain the Data Migration Strategy (approach, scope, tooling, cycles)

Establish data ownership and sign-off governance by domain (Finance/Procurement/HCM/Payroll)
Define migrate vs archive rules, retention windows, and cutover principles
Own the data migration plan, milestones, RAID, and dependencies

B) Data Scope & Mapping (Business + Technical)* Confirm data objects in scope across Finance, Procurement, HCM Core, and Payroll

Lead source-to-target mapping workshops and documentation
Define transformation rules and business validation approach
Ensure alignment of organisational structures, hierarchies, and reference data

C) Extraction, Transformation & Load (ETL)* Coordinate SAP extraction methods (reports, table extracts, ETL tooling)

Design staging approach and load sequencing
Ensure Oracle load method is fit-for-purpose (FBDI for Finance/Procurement; HDL/HSDL for HCM)
Define runbooks, error handling, re-runs, and load performance constraints

D) Data Quality & Cleansing* Drive data profiling and cleansing activities (duplicates, missing fields, invalid dates, inactive records)

Create and maintain the Data Quality Dashboard and issue log
Ensure compliance with GDPR and data privacy controls for HR/Payroll data

E) Reconciliation, Controls & Audit Evidence* Define reconciliation approach (record counts, control totals, balances, payroll YTD)

Maintain audit-ready evidence packs for migration activities and approvals
Own data readiness gates and provide go/no-go input for cutover

F) Mock Loads, Dress Rehearsals & Cutover* Plan and execute multiple mock migration cycles and dress rehearsals

Lead final cutover extract, load, and validation activities
Coordinate with Testing and Cutover leads to ensure readiness and execution success

G) Stakeholder & Supplier Management* Act as a bridge between business SMEs and technical teams

Manage delivery with system integrator/partner resources (if applicable)
Communicate risks, progress, and decisions to PMO and programme leadership

Key Deliverables* Data Migration Strategy & Plan

Data Object Inventory (in-scope / out-of-scope)
Data Ownership & Sign-off Matrix
Source-to-target mapping specifications
Transformation rules documentation
Mock load results packs and defect/issue logs
Reconciliation workbooks (counts and control totals)
Cutover runbooks and final migration sign-off pack
Migrate vs Archive and Retention Rules

Scope Coverage (Typical Data Objects)Finance* CoA and hierarchies

Legal entities / ledgers
Suppliers (financial attributes)
Open AP/AR items (if in scope)
GL opening balances
Fixed assets (active only)

Procurement* Supplier master + sites

Open PRs / POs
Receipts in transit / GR-IR open items
Contracts (active only, optional)

HCM Core* Workers (employees + contingent)

Assignments and supervisors
Org structure + departments
Locations
Jobs, grades, positions

Payroll* Statutory IDs and payroll relationships

Bank details (active)
Opening balances and YTD balances
Elements/deductions mapping (as required)

Required Skills & Experience* Proven experience leading ERP data migrations (SAP on-prem to Oracle Fusion preferred)

Strong understanding of SAP FI/MM and master data dependencies
Strong understanding of HCM Core and Payroll critical data controls
Experience with Oracle Fusion load tools: FBDI (Finance/Procurement) and HDL/HSDL (HCM)
Strong reconciliation mindset (control totals, balancing, audit evidence)
Strong stakeholder management with senior SMEs and delivery partners
Advanced Excel skills; SQL/data querying preferred
Understanding of data security, privacy, and GDPR controls