Test Engineer in Bournemouth

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.

About You

• Proven experience testing data pipelines, ETL processes and data transformations
• Strong knowledge of Azure Dev Ops (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 Py Test)
• 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
• Experience within the Life Insurance sector across a range of projects and operational areas

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
• Shared parental leave
• Up to 20% discount on our life products for you and your immediate family.
• 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.

#J-18808-Ljbffr