Job Description
/
ㅤ
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.
We’re the UK’s largest mutual life, pensions and investment company, offering protection, long-term savings and asset management products and services.
Royal London is a purpose-driven mutual. Our Purpose, ‘Protecting today, investing in tomorrow. Together we are mutually responsible’, defines the impact we want to have. It shapes what we do on behalf of our members and customers, financial advisers, our colleagues and the communities in which we operate. Our People Promise is our collective commitment that our workplace will be inclusive, responsible, enjoyable and fulfilling where all colleagues can thrive and experience a sense of belonging. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve.
Our inclusive values and people promise are core to who we are and how we work. It’s good for our people, and good for our customers too, because with an inclusive workplace and a diverse workforce we will reflect our members, customers and communities to deliver the best outcomes.
We celebrate and value different backgrounds and cultures across our organisation. Our diverse people and perspectives give us a range of skills which are recognised and respected– whatever their background.
Workplace Initiatives
Program for parents returning to work after Parental Leave? |
No |
Leadership development programmes? |
Yes |
Mentoring programmes? |
Yes |
Coaching programmes? |
Yes |
Employee-led diversity networks? |
Yes |
Internal women’s networking groups? |
Yes |
Open to discussing flexible work arrangements at interview stage? |
Yes |
No. of weeks paid maternity leave at full salary: |
26 weeks (followed by 13 weeks half pay) |
Minimum weeks tenure required to be eligible for paid maternity leave: |
Open to all regardless of length of service |
No. of weeks paid paternity leave at full salary: |
4 weeks |
Minimum tenure required to be eligible for paid paternity leave: |
Open to all regardless of length of service |
Gender pay gap reporting information 2022: |
|
Mean pay gap: |
35.3% |
Median pay gap: |
33.9% |
Mean bonus gap: |
70.4% |
Median bonus gap: |
48.5% |
Signatory of the UK Women in Finance Charter? |
Yes |
Targets to raise the number of women in leadership? |
Yes |
Targets to raise the number of BAME individuals in leadership? |
No |
Listed in the Bloomberg Diversity & Inclusion Index? |
No |
Graduate Programmes
We have a number of graduate programmes designed to deliver technical experts and future leaders.
Royal London Career Confidence programme
Our hybrid programme focuses on equipping you to feel empowered in your career and supported to explore new opportunities as they arise.
Apprenticeships
We offer a wide range of Apprenticeships that are targeted at both new joiners and existing colleagues.
Inclusion
We promote an inclusive culture at Royal London and have a range of inclusion networks for our colleagues to get involved with.
Our Women's Network is a community that celebrates and supports its members, helps everyone to learn more and inspires all of us to aim higher. Confidence and development are strong themes here and our events focus on three key areas of team working, finance, and wellbeing. There are two sub-groups to the Women’s Network – Women in Technology and our Periods and Menopause Group – focused on actions such as supporting over 20 new Periods and Menopause champions and launching guidance and training for leaders.