Senior Data Test Analyst

ㅤ

Contract Type: Permanent
Location: Wilmslow or Glasgow
Working Style: Hybrid 50% from home / 50% office based

We're looking for a Senior Data Test Analysts to join our Core Data Engineering team within our Group Data & AI Office and help ensure the quality, accuracy and integrity of data across a modern enterprise data platform. You'll play a key role in testing data as it moves through Bronze, Silver and Gold layers, supporting trusted reporting, analytics, APIs and business decision-making.

About the team

You'll be part of a collaborative Core Data Engineering team made up of Data Engineers, Data Test Analysts, QA professionals and Data Modellers. Together, the team ingests, transforms and validates data from multiple sources, including pensions, protection and third-party systems.

About the role

This is a great opportunity to work on a strategic data platform where high-quality data is essential. You'll validate data ingestion, test business rules and data quality controls, and ensure transformed data remains accurate and aligned to source systems as it moves through the data lifecycle.

• Validate data ingestion from multiple source systems and perform reconciliation checks on raw data.
• Test data quality controls, business rules and validations across the data platform.
• Check transformations across Bronze, Silver and Gold data layers to ensure outputs are accurate and reliable.
• Validate mapping from source systems into the Enterprise Data Model.
• Test data used for Power BI reporting, API integrations and downstream systems.
• Create and maintain test plans, test cases and results documentation.
• Work closely with Data Engineers, Data Modellers, Project Managers, Project Testers and wider delivery teams.

What you'll bring

• Strong SQL skills.
• Experience in data testing, data validation or reconciliation within data-focused projects.
• Understanding of end-to-end testing approaches and good test documentation practices.
• Experience testing data mappings, transformations and business rules.
• Python experience would be helpful, but we're open to candidates who are keen to develop this skill.
• Databricks, Azure DevOps or modern cloud data platform experience would be beneficial, but training can be provided.
• Financial Services experience would be useful but is not essential.

What we're looking for

Alongside technical capability, we're looking for people who enjoy working collaboratively and take pride in helping teams make confident, data-led decisions.

• You're detail-oriented and care about data quality.
• You communicate clearly with technical and non-technical colleagues.
• You enjoy working across teams and building positive relationships.
• You're curious, keen to learn and open to developing new skills.
• You're comfortable asking questions and challenging data issues in a constructive way.

If you don't meet every requirement but have strong data testing experience and a willingness to learn, we'd still encourage you to apply.

Why join us?

• Work on a strategic enterprise data platform with high visibility across the organisation.
• Gain exposure to modern cloud data architecture and data models.
• Support trusted reporting, APIs and analytics used across the business.
• Collaborate with data engineering, modelling and project delivery teams.
• Join a team that values learning, curiosity and continuous development.

ㅤ

About Royal London

We're the UK's largest mutual life, pensions and investment company, offering protection, long-term savings and asset management products and services. Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve .

We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, an up to 14% employer matching pension scheme and private medical insurance.

We're an inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected - whatever their background.