Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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.

Responsibilities

Conduct detailed validation of client, advice and product datasets, including structured records and unstructured content.
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.
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.
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.
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.

Requirements

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.

Skills

SQL
Data validation
Data testing
QA
ETL/ELT
Data mapping
Data lineage
Jira
Xray
Confluence
Analytical skills
Attention to detail
Communication skills

Location

Leeds
London

Work Type

Fixed-term contract
Flexible working

Salary/Compensations

National: £51,907- £57,100
London: £56,060- £61,700

Benefits

30 days of annual leave plus bank holidays
Option to buy or sell 5 days of annual leave
Company-paid Private Medical Insurance
Life Insurance
Health Screening
Matched pension contribution of up to 15% of base pay
Flexible allowance for additional benefits (dental cover, paid sabbatical leave, gym membership, menopause support)
Bonus Opportunity (dependent on individual/company performance)
Access to free financial advice

About the Company

Lloyds Wealth aims to improve the way financial advice is offered by making it more affordable, accessible and impactful for more people.

Equal Opportunity

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.