Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Ensure data accuracy and integrity while supporting the Data Migration project.
- Company: Join Schroders Personal Wealth, transforming financial advice for everyone.
- Benefits: Enjoy 30 days of annual leave, competitive salary, and professional development opportunities.
- Why this job: Make a real impact on data quality and enhance customer experiences.
- Qualifications: Experience in data testing, strong SQL skills, and attention to detail required.
- Other info: Dynamic role with opportunities for growth in a collaborative environment.
The predicted salary is between 46000 - 58000 ÂŁ per year.
Schroders Personal Wealth aims to improve the way financial advice is offered, by making it more affordable, accessible and powerful for more people. We want to change lives for the better.
As a Data Quality Assurance Analyst, youâll play a key role in ensuring the accuracy, reliability and integrity of the data that underpins our business. Working at the heart of the Data Migration project, youâll help shape how information flows across our organisation - supporting better decisionâmaking, smoother processes and a stronger data foundation for the future.
Youâll work closely with colleagues across data, business analysis, engineering and project delivery, validating datasets, improving data standards and ensuring that what we deliver is accurate, complete and trusted. Whether youâre testing migrated data, analysing patterns, resolving issues or supporting downstream reporting, your work will directly enhance our data quality and overall employee and customer experience.
Key Responsibilities
- Data Testing & Validation
- Conduct detailed validation of client, advice and product datasets, including structured records and unstructured content (e.g., documents, notes, attachments).
- Execute test cases for each stage of the migration lifecycle: extraction, staging, transformation, loading and postâload validation.
- Perform reconciliation between source data and target data, ensuring completeness, accuracy and referential integrity.
- Validate iterative mock migration cycles and identify patterns, data gaps, mapping discrepancies and transformation issues.
- Support the triage, documentation and resolution of data defects in collaboration with data migration and engineering teams.
- Maintain detailed test evidence, defect logs, and validation reports.
- Downstream System Testing
- Validate data ingestion into downstream platforms including the data lakehouse, data warehouse and reporting systems.
- Ensure schema adherence, metadata accuracy, lineage integrity and transformation rule correctness in downstream datasets.
- Test dashboards, MI reports and regulatory outputs to ensure that reported values reflect migrated data accurately.
- Support regression testing where changes are made to pipelines, mappings or transformation rules.
- Data Quality Assurance
- Perform exploratory data profiling to identify abnormalities, missing values, duplicate records and data format issues.
- Support the execution of data cleansing, enrichment and transformation checks.
- Validate business rules, logic and mappings defined by the Data Migration Analysts and business SMEs.
- Monitor data quality throughout migration cycles and contribute to improving data standards and quality controls.
- Migration & Cutover Support
- Assist in validating data quality during cutover rehearsals, data freeze periods and postâgoâlive verification.
- Contribute to defining and applying entry and exit criteria for migration testing cycles.
- Support hypercare activities by validating live data defects, reconciling issues and confirming fixes.
Qualifications & Skills
- Relevant experience in data testing, QA, data validation or similar roles.
- Strong SQL skills and experience analysing data across databases, data lakes or data warehouses.
- Experience validating both structured and unstructured datasets.
- Understanding of data migration, ETL/ELT processes, data mapping and data lineage.
- Experience working with 3rd party vendors is advantageous.
- Experience working in financial services or financial advice environments is desirable.
- Knowledge of data quality principles, GDPR, and data governance practices.
- Strong analytical skills with excellent attention to detail.
- Experience with test and documentation management tools such as Jira, Xray and Confluence.
- Excellent communication skills and an ability to translate technical findings for business audiences.
We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role. This job vacancy may close earlier than the advertised date if a suitable candidate is found. We encourage interested applicants to submit their applications as soon as possible.
Some fantastic benefits SPW colleagues enjoy:
Generous Holiday Entitlement: 30 days of annual leave plus
Data Quality Assurance/Test Engineer in London employer: Schroders Personal Wealth
Contact Detail:
Schroders Personal Wealth Recruiting Team
StudySmarter Expert Advice đ¤Ť
We think this is how you could land Data Quality Assurance/Test Engineer in London
â¨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
â¨Tip Number 2
Prepare for interviews by practising common questions and scenarios related to data quality assurance. We recommend doing mock interviews with friends or using online platforms to boost your confidence.
â¨Tip Number 3
Showcase your skills! Create a portfolio of your work, including any projects or case studies that highlight your data testing and validation expertise. This will give you an edge over other candidates.
â¨Tip Number 4
Donât forget to apply through our website! Itâs the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Quality Assurance/Test Engineer in London
Some tips for your application đŤĄ
Tailor Your CV: Make sure your CV speaks directly to the role of Data Quality Assurance/Test Engineer. Highlight your relevant experience in data testing, QA, and any specific tools like SQL or Jira that youâve used. We want to see how your skills align with what weâre looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why youâre passionate about data quality and how you can contribute to our mission at Schroders Personal Wealth. Keep it concise but impactful â we love a good story!
Showcase Your Analytical Skills: In your application, donât forget to mention specific examples where youâve demonstrated strong analytical skills. Whether itâs resolving data discrepancies or validating datasets, we want to know how youâve tackled challenges in the past.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you donât miss out on any important updates. Plus, itâs super easy â just a few clicks and youâre done!
How to prepare for a job interview at Schroders Personal Wealth
â¨Know Your Data Inside Out
Before the interview, brush up on your knowledge of data quality principles and the specific datasets mentioned in the job description. Be ready to discuss how you would validate both structured and unstructured data, as well as your experience with SQL and data migration processes.
â¨Showcase Your Problem-Solving Skills
Prepare examples from your past experiences where you've identified data issues and resolved them. Highlight your analytical skills and attention to detail, especially in relation to data profiling and cleansing. This will demonstrate your ability to enhance data quality effectively.
â¨Familiarise Yourself with Tools
Make sure you're comfortable discussing tools like Jira, Xray, and Confluence. If you have experience with these or similar documentation management tools, be ready to explain how you've used them in previous roles to manage test evidence and defect logs.
â¨Communicate Clearly and Confidently
Practice explaining technical concepts in simple terms, as you'll need to translate your findings for business audiences. During the interview, focus on clear communication, ensuring that you convey your ideas effectively and confidently.