Data Quality Assurance/Test Engineer

Schroders Personal Wealth
Leeds
4 days ago
Create job alert
Job Type

Fixed Term (Fixed Term)


Closing Date

04/04/2026


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 bank holidays, with the option to buy or sell 5 days.
  • Health & Wellbeing: Company-paid Private Medical Insurance, Life Insurance, and Health Screening.
  • Company Pension Contribution: A matched pension contribution of up to 15% of your base pay.
  • Cash Allowance: Flexible allowance to spend on additional benefits personal to you, including: dental cover, paid sabbatical leave, gym membership, menopause support.
  • Bonus Opportunity: Dependent on individual/company performance (eligible after 3 months’ service)
  • Financial Advice: Access to free financial advice to help secure your financial future.

To find out more, please visit https://www.spw.com/careers-at-spw/rewards-and-benefits


We support flexible working:

At SPW, we know how important it is to be able to achieve a balance. We want to support your lifestyle as well as meeting our business needs, so will always aim to be flexible. As well as traditional working patterns, we have colleagues who work informal flexible hours, reduced working hours, and have job-sharing arrangements. Many colleagues work from home, or in a hybrid way.


Ready to restart your career?

We warmly welcome applications from those returning to work after a period of leave, providing appropriate support and training where required.


You belong here:

At SPW, we embrace individuality and diversity of identity, experience, and thought. We actively strive for inclusive behaviours and actions, making appropriate adjustments for disabilities, health conditions and neurodiversities. We ensure equal opportunities for all and transparently report on gender pay to promote fairness.


Schroders Personal Wealth operates under the Senior Managers and Certification Regime as a solo-regulated firm and if this role is classed as a Certified Role under that regime you will be subject to enhanced vetting and will have a number of additional conduct and regulatory duties to adhere to, as well as certifying at least annually that you are fit and proper to perform this role.


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Test Engineer — Data Quality & Validation Expert

ICT Data Engineer

Test and Measurement Data Analyst

Lead Data Engineer

Materials Lab Technician & Data Analyst

Materials Lab Technician & Data Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.