Role Title: Data Migration Lead
Programme: SAP On-Prem ERP to Oracle Fusion Cloud (Finance, Procurement, HCM Core, Payroll)
Role Type: Programme / Delivery Role (Workstream Lead)
Reports To: Programme Director
1. Role Purpose
The 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 Accountabilities
A) 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
3. 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
4. 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)
5. 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
6. KPIs / Success Measures
- Mock load success rate ≥ 95% by maturity of cycles
- Mandatory field completeness ≥ 98–100%
- Payroll control totals matched 100%
- Cutover load completed within planned downtime window
- Low severity data issues during hypercare
7. Stakeholder Interfaces
- Finance Lead (GL/AP/Assets)
- Procurement Lead (Suppliers, PR/PO, Receipts)
- HR Core Lead (Workers, Org, Positions)
- Payroll Lead (Balances, Statutory Compliance)
- Solution Architect, Integration Lead, Testing Lead, Cutover Lead
- Security Lead, PMO, System Integrator / Oracle Partner
8. Decision Rights
- Authority to stop migration runs if quality thresholds are not met
- Authority to enforce migration scope rules (active-only, open-items-only)
- Authority to require business sign-off before promoting data to the next cycle
- Authority to escalate data readiness risks to programme leadership and SteerCo