Haystack
← Back to Jobs
Operations & Project Management

Test Engineer 12-month FTC

LV=bournemouth🇬🇧United KingdomPosted 22 Jul 2026

Why This Role Stands Out

This role offers a fantastic opportunity to contribute to a crucial data transformation project, enhancing your skills in ETL testing and automation within a reputable, member-focused organization. You'll thrive here if you're a detail-oriented Test Engineer passionate about data quality and keen to make a tangible impact. Embrace this chance to join a supportive, inclusive team and advance your career in a hybrid environment.

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

Test Engineer 12-month FTC

About the Role

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.
Were 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 UKs 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 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, youll go above and beyond to do the right thing for our customers. Well 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 (youll 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.

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.

Were 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 its right for you, our members and customers, and our business, then well 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=.

Skills

Root Cause Analysis

Similar jobs