Dechra
Data Preparation Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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 Opportunity
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.
Role Responsibility
So, what will you be doing? This role has a broad and varied remit and the successful candidate will have responsibility for duties including:
Data Profiling & Cleanse for Migration Readiness
- 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).
Migration Rule Definition & Mapping Support
- 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Validation, Reconciliation & Business Sign-off
- 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.
Defect & Issue Management
- 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.
Mock Migration, Cutover & Hypercare Support
- 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.
Documentation & Governance Alignment
- 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.
Cross-Functional Collaboration
- 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 within the wider programme plan and its delivery/implementation partners.
- Collaborative engagement across these roles ensures data migration is business-aligned, technically sound, and controlled.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
The Candidate
Here at Dechra we pride ourselves on being an inclusive employer. We know that individuals’ unique background and experience can bring a wealth of variety and expertise to our global workforce. For this role, we’re particularly keen to hear from those who have/are:
Essential
- Relevant experience in data migration, data quality, data analysis, or enterprise data initiatives.
- Strong data analysis skills using SQL and/or Excel (Power Query desirable).
- Experience in defining and executing data validation and reconciliation checks.
- Ability to work confidently with business stakeholders to agree on data rules and outcomes.
- Strong documentation, discipline and attention to detail.
Desirable
- Experience supporting ERP or other data-related programmes (e.g. SAP S/4HANA).
- Familiarity with data governance concepts and roles (Data Owner, Data Steward).
- Experience working in regulated or controlled environments (e.g. GxP / data integrity).
- Understanding of migration tooling concepts (without needing to build ETL pipelines).
What we can offer you:
- 33 days annual (inclusive of Bank Holidays)
- Holiday purchase scheme
- Healthcare
- Employee Assistance Program
- Life Assurance
- 8% Employer Pension Contribution
- Enhanced Family Leave
- Bonus (discretionary)
- Discounted Pet Food
About the Company
If a career at Dechra has piqued your interest, find out more at Dechra Careers.
Dechra is a growing, global specialist in veterinary pharmaceuticals. Our expertise is in the development, manufacture, marketing and sales of high quality products exclusively for veterinarians worldwide.
All applications received are reviewed by our internal talent acquisition team and we will get in touch if your skills and experience match what we're looking for. Should you not hear back from us within 28 days please don't be too disappointed - we may keep your CV on our database for any future vacancies which could be suitable, and we encourage you to keep an eye on our careers site. We value diversity within our global workforce and encourage an inclusive culture. Any questions or queries, please contact us at recruituk@dechra.com
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills