Data Preparation Analyst

Want to play a key role in the most significant transformation programme in our company's history?

As part of Helix, our global transformation programme bringing together process, tech, data and people, we're building the trusted data foundation that will support how we work for years to come. This role offers a unique opportunity to apply your data expertise on a global scale, helping shape how data is managed, trusted and used across the business. Working with colleagues across functions and regions, you'll help build the data capabilities that will power our future success and deliver lasting business impact.

The Data Preparation Analyst plays a critical role in supporting the successful delivery of enterprise data migration initiatives. Positioned within the Data Workstream, the role supports the Data Migration Lead by analysing legacy data, defining migration rules, supporting the business in preparing data for migration (non-ERP), validating migrated data, and coordinating issue resolution with business and technical teams.

The Data Preparation Analyst ensures that data migrated into target platforms is accurate, complete, fit for purpose, and supported by clear business evidence and sign-off, enabling operational readiness and trusted decision-making from day one.

So, what will you be doing? This role has a broad and varied remit and the successful candidate will have responsibility for duties including:

• Analyse legacy data to understand structure, usage, dependencies, and quality issues across agreed data domains.
• Support data profiling activities to assess readiness and identify risks early.
• Work with Business Data Owners and SMEs to agree on data cleansing approaches, exclusions, tolerances, and assumptions (including manual data preparation, especially for source data that does not reside in an ERP).

• Contribute to the definition and validation of source-to-target mappings, transformation rules, defaults, and reference data usage.
• Ensure migration logic aligns with target system design, enterprise data models, and downstream reporting requirements.
• Maintain clear documentation of rules, assumptions, and decisions to support traceability and governance.

• Define and execute data validation and reconciliation checks following each mock migration and cutover rehearsal.
• Analyse reconciliation variances, identify root causes, and clearly articulate impacts in business language.
• Prepare validation evidence packs and support formal business sign-off of migrated data.
• Log, analyse, and manage data migration defects using agreed tooling and processes.
• Act as a key liaison between business stakeholders and technical teams, ensuring issues are clearly understood and addressed.
• Identify recurring or systemic data issues and recommend remediation or rule changes to the Data Migration Lead.
• Support preparation and execution of mock migrations and dress rehearsals.
• Participate in cutover validation activities, ensuring agreed checks and acceptance criteria are met.
• Provide hyper‑care support post‑go‑live by analysing reported data issues and confirming resolution effectiveness.

• Maintain clear, structured documentation covering migration rules, validation approaches, reconciliations, and sign‑off decisions.
• Ensure activities align with data governance standards, ownership models, and approval processes.
• Support audit and compliance requirements through complete, traceable evidence.

• With Data Migration Lead:
• Provides insight, validation findings, and risk input to support delivery decisions.
• With Data Governance Lead, Business Data Owners & Stewards/SME:
• Develops data rules, quality thresholds, and sign‑off criteria.
• Support with manual data preparation.
• With Data Architects & Migration Technicians:
• Works with Migration Leads & Engineers to translate profiling results into remediation effort.
• With Testing, Cutover & PMO Teams:
• Aligns data readiness, validation timing, and cutover dependencies…