Data & Migration Lead

Ventula Consulting Ltd.; Greater London; Hybrid; GBP 104,000 - 136,000; Full time

Job summary

Ventula Consulting Ltd. is seeking a Data & Migration Lead to build the data foundation for an ERP transformation covering Finance, HR, and Procurement.

You will map data across two legacy estates and drive cleansing for a single cloud ERP platform. You will collaborate with Phase 0 partners and data engineers to document schemas, create migration maps, and extend inventories to include customer, HR, payroll, and banking systems.

Qualifications

• 8+ years in data migration or governance on ERP programmes.
• Data modelling and profiling at volume with hands-on SQL and analysis tools.
• Oracle E-Business Suite and Microsoft Dynamics NAV data models.
• On-premise to cloud ERP and HCM migration experience.
• Match-and-merge rules and golden records across merged estates.
• Knowledge of data structures that enable AI in ERP.
• UK and EU GDPR knowledge for HR and payroll data, incl. special-category data.
• HR, Finance and Procurement concepts with autonomy and stakeholder interviewing skills.
• Post-merger dual-estate, cross-border data considerations (EU/UK) and related systems may be desirable.

Responsibilities

• Confirm in-scope objects; verify partner counts and catalogues.
• Document schemas across estates and target ERP; create migration maps and flag gaps.
• Extend inventory to customer, HR, payroll and banking systems; include spreadsheets and Access databases.
• Document volumes and interview stakeholders to capture field usages and local customisations.
• Write match-and-merge rules for one master record per entity with e-invoicing identifiers.
• Agree data protection approach for profiling, test loads and AI trials; assign owner per object and maintain a scorecard.
• Build migration pipelines for high-risk objects and align scores before implementation.
• Set history per object and map object flows between systems; drive cleansing in remediation plan order.
• Specify AI-ready data structures and supply anonymised data sets to AI Experimentation.

Skills

Data modelling

SQL

Data analysis

ERP data migration

Stakeholder interviewing

Tools

Oracle E-Business Suite

Microsoft Dynamics NAV

Job description

Leading international transport client needs a Data & Migration Lead to build the data foundation for a Finance, HR and Procurement ERP transformation.

You will work with Phase 0 consulting partners and data engineers to map every data object across two legacy ERP estates and drive cleansing and governance for a single cloud ERP platform.

Key responsibilities:

• Confirm in-scope objects; check every partner count and catalogue.
• Document schemas across both estates and the target ERP; produce migration maps and flag gaps.
• Extend the inventory to customer, HR, payroll and banking systems, including spreadsheets and Access databases.
• Document volumes and interview stakeholders to capture field-usage quirks and local customisations.
• Write quality rules and design match-and-merge rules for one master record per supplier, customer, bank account and employee, with e-invoicing identifiers (VAT, company registration, Peppol IDs).
• Agree with data protection how profiling, test loads and AI trials treat personal data; name an owner and steward per object and maintain an object scorecard.
• Build migration pipelines for high-risk objects, scoring alignment issues before implementation.
• Set history per object, map object flows between systems and interim flows to each legacy system, and drive cleansing in remediation-plan order.
• Specify AI-ready data structures and supply anonymised data sets to the AI Experimentation workstream.

About you:

• 8+ years in data migration or governance on ERP programmes.
• Data modelling and profiling at volume, with hands-on SQL and analysis tools.
• Oracle E-Business Suite and Microsoft Dynamics NAV data models.
• On-premise to cloud ERP and HCM migration experience.
• Match-and-merge rules and golden records across merged estates.
• Knowledge of data structures that make AI work in an ERP.
• UK and EU GDPR knowledge for HR and payroll data, including special-category data.
• HR, Finance and Procurement concepts, plus autonomy and strong stakeholder interviewing skills.
• Post-merger dual-estate, rail or transport, Belgian/French/Dutch statutory data, retrieval and agent content preparation, Salesforce/SuccessFactors/Concur data, EU AI Act employment rules, and French (all desirable).

This is an initial 6-month contract, paying £650 per day (Outside IR35).

Hybrid: 2-3 days per week in London, the remainder would be remote, with regular travel to Brussels and Paris.