How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Test Engineer for Data Transformation Project
We have a new opportunity for a Test Engineer to join our Data Transformation Project and play a key role in delivering a reliable, high-quality data platform built on Microsoft Fabric.
As a leading UK life and pensions mutual insurer with a proud history dating back to 1843, we exist to help people live financially confident lives – protecting their income while they work and maximising it when they stop. Today, over one million members and customers trust us to look after their futures, families and finances.
Joining us means becoming part of a team that puts our members, customers and advisers at the heart of everything we do. We’re committed to creating an inclusive culture where colleagues can thrive. We are proud to have built a workplace where our colleagues feel welcomed, respected, supported and valued – reflected in our recognition as one of the Financial Times UK’s Best Employers in 2025 and 2026.
We celebrate individuality and believe our differences make us stronger, so bring your true self and help shape the future of LV=.
Working across the data delivery lifecycle, you'll lead ETL testing, data validation, test automation and defect management. You'll ensure data is accurately and securely transferred into data warehouse and datalake environments, validating transformations and business rules to support trusted reporting, analytics and decision-making.
As a guardian of quality, you'll drive automated testing, regression testing and early validation practices to ensure robust and scalable data solutions.
The role is offered on a fixed-term basis of 12 months and will be based out of our Bournemouth office with presence required once a month.
Key Accountabilities
- Develop and execute ETL test plans, test cases and test scenarios for data pipelines.
- Validate data accuracy, completeness, security, transformation logic and pipeline performance.
- Perform data validation and reconciliation testing to ensure data integrity across source and target systems.
- Develop and maintain automated ETL test scripts using SQL, Python and testing frameworks.
- Integrate automated data validation checks into CI/CD pipelines.
- Identify, document, track and manage defects, undertaking root cause analysis where required.
- Produce and maintain test plans, execution reports, defect logs and data quality metrics.
- Collaborate with Data Engineers, Architects and business stakeholders to ensure solutions meet requirements and user stories.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
About You
- Proven experience testing data pipelines, ETL processes and data transformations
- Strong knowledge of Azure DevOps (or similar test management tools)
- Strong SQL and/or Python skills for data analysis and validation of large datasets
- Experience producing test status reports and identifying delivery risks
- Experience with test automation tools and frameworks (Python and PyTest)
- Strong understanding of data warehousing, databases, ETL concepts and architecture
- Excellent analytical and problem-solving skills with strong attention to detail
- Experience working with cloud data platforms such as Microsoft Fabric or Azure Databricks
- Experience testing OLTP, OLAP and BI reporting solutions
- Experience generating and manipulating test data
- Excellent communication skills with the ability to work effectively across technical and non-technical teams
Desirable
- ISEB Foundation Level in Software Testing (or equivalent)
- Experience within the Life Insurance sector across a range of projects and operational areas
Rewards & Benefits
At LV= Savings and Retirement, you’ll go above and beyond to do the right thing for our customers. We’ll reward your hard work with an attractive, competitive salary and benefits package, which includes:
- 30 days' holiday, with the option to buy up to 5 additional days
- Competitive pension scheme - LV= Life and Pensions will double-match the amount you pay, up to 14% (subject to National Minimum Wage requirements)
- An annual bonus scheme based on personal performance
- Single-cover private medical insurance (with the option for you to upgrade to family cover)
- Flexible benefits, including a cycle to work scheme, personal accident insurance, critical illness cover and dental insurance
- Up to 20% discount on our life products for you and your immediate family
- A group life assurance policy with 4 x your basic pay to go to your dependents (you’ll have the option to increase to 8 x cover)
- Group Income Protection (if you become a member of the Pension scheme and reach 5 years of service)
- Access to our Employee Assistance Programme (EAP) for support when you need it
- A virtual GP service
- Shared parental leave
- Up to 20% discount on our life products for you and your immediate family.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Please note all salary sacrifice benefits are subject to National Minimum Wage requirements i.e. you are unable to select any benefits that would reduce your base pay below the minimum wage threshold.
We’re proud of our inclusive culture at LV= and, as an equal-opportunity employer, we continually work to remove unconscious bias from our recruitment process. We value our colleagues for what they bring to our team regardless of any protected status or characteristics they may have. Talk to us about flexible working as part of your application; if it’s right for you, our members and customers, and our business, then we’ll do everything we can to make it happen.
Please note that we are unable to offer Skilled Worker Visa Sponsorship for this role. Therefore, you must ensure that you are eligible to work in the UK without our sponsorship in order for your application to be considered.
Go on, bring your true self to LV=.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills