Data Analytics and Insights Specialist

NFU Mutual; Stratford-upon-Avon; Hybrid; GBP 45,000 - 55,000; Full time

Benefits offered by this job

Annual bonus up to 17.5% of salary

Contributory pension up to 20%

25 days annual leave + holidays

Life Assurance 4x salary

Employee discounts on NFU Mutual pol.

Health and wellbeing plan

Job summary

NFU Mutual is seeking a Data Analytics and Insights Specialist to safeguard data integrity across Life, Pensions & Investments. You will leverage SQL, Python and Power BI to extract insights, investigate data changes, and collaborate with Finance, data and IT teams to implement tested solutions.

Based at our Tiddington Head Office near Stratford-upon-Avon, the role offers hybrid working with up to 80% from home and access to NFU Mutual benefits and a supportive culture.

Qualifications

• SQL capability with reading/writing queries and stored procedures.
• Understanding of databases, data models and reporting environments.
• Experience tracing data flows and validating discrepancies to produce reliable outputs.
• Experience assessing data changes, testing solutions and documenting results.
• Proven data analysis and insight using SQL or Python and Power BI.
• Azure, Power Apps, Power Automate, data ingestion in Life, Pensions & Investments desirable.

Responsibilities

• Support data integrity and understanding across Life Pensions & Investments.
• Investigate data changes and issues across data sources and business rules.
• Extract and interrogate data using SQL; trace defects to source and assess downstream impact.
• Collaborate with Finance, data and technology teams to deliver practical solutions.
• Ensure solutions are tested and approved before implementation.

Skills

SQL queries

Stored procedures

Databases and data models

Data transformations

Data quality

Data flows tracing

Python

Power BI

Azure

Insurance domain knowledge

Tools

Power BI

Power Apps

Power Automate

Azure

Job description

Data Analytics and Insights Specialist Support the integrity and understanding of data across the Life Pensions & Investments Business. Play a key role in implementing business change and maintaining data quality, from impact analysis and first investigation through to final sign off. Hybrid 80% homeworking and 20% from Stratford Upon Avon

About the role

NFU Mutual has created this role following the successful delivery of new reporting and analytics capabilities in the Financial Services Business (Life, Pensions & Investments). You'll join the Financial Services Data and Analytics team, part of the Financial Planning & Analysis function, at an exciting stage in their journey, helping ensure the information used for reporting and decision making is accurate, consistent and well understood. You'll investigate data changes and issues across a variety of data sources, database structures, transformations and business rules. Using SQL, you'll extract and interrogate data, trace defects through data transformations to their source and assess any downstream impact. You will work with Finance, data and technology teams to agree practical solutions that meet data governance expectations. You will work with IT colleagues to deliver change and ensuring solutions are fully tested and approved before implementation. Your work will strengthen data quality, support trusted reporting and help NFU Mutual make well informed business decisions. This role is based in our Tiddington Head Office, just outside Stratford Upon Avon. However, we understand how important a positive work life balance is, so to help you give your best, we offer great facilities when you want to be in an office environment and support to work up to 80% of your hours from home.

About you

• Practical SQL capability, with experience of reading and writing queries and understanding stored procedures and scripts.
• Understanding of databases, data models and reporting environments, including data transformations.
• Experience of tracing data flows, diagnosing data quality issues and validating discrepancies to produce accurate, reliable outputs
• Experience of assessing data changes, testing solutions and creating clear supporting documentation
• Proven experience of data analysis and data driven insight using SQL or Python and Power BI.
• Experience of Azure, Power Apps, Power Automate, data ingestion and Life, Pensions & Investments business or insurance is desirable

We support an inclusive workplace and value all the differences that make us unique. We celebrate the creativity and innovation that comes from diverse perspectives and experiences and share a common vision of doing the right thing for our customers and employees. We recognise that some candidates may experience barriers during the recruitment process. So, we encourage candidates to discuss any adjustments or accommodations they need to be the best they can be throughout our recruitment process. We're proud to be a Disability Confident Employer, a Race at Work and Women in Finance Charter signatory and welcome applications from people of all backgrounds, regardless of age, ethnicity, disability, neurodiversity, gender, religion, marital status, sexual orientation or socioeconomic background.

Benefits and Rewards

• Salary - £45,000 - £55,000
• Annual bonus (up to 17.5% of salary)
• Contributory pension scheme, up to 20%, including your 8% contribution
• 25 days annual leave + bank holidays + buy/sell/save holiday trading scheme
• A Family Friendly policy that helps you balance your work and family responsibilities
• Access to savings at High Street brands, travel and supermarkets
• £20 contribution to a monthly gym membership - subject to T&Cs
• Health and wellbeing plan - cashback for dentist, opticians, physio and more
• Access to voluntary benefits, including health assessments, private medical insurance and dental insurance
• Employee Volunteering - volunteer in the community for one day each year
• Unlimited access to Refer a Friend £500 bonus scheme
• Life Assurance cover of 4 x salary
• Employee discounts of 15% on a range of NFU Mutual insurance policies.
• Salary sacrifice employee car scheme - subject to eligibility

Working at NFU Mutual

We're one of the UK's leading general insurance and financial services organisations, and for over 110 years we’ve put our customers at the heart of everything we do. Our people are just as important to us, so we’re proud to be recognised as "a great place to work". Our Gallup Exceptional Workplace 2026 award was not only awarded with Distinction, but it also marked us as the first UK based company to earn a Gallup Exceptional Workplace award for eleven consecutive years. We’ve also been consistently recognised by Glassdoor. We appeared in the Glassdoor Best Places to Work UK list in 2023, 2024 and 2026 - and in 2026, we were the highest ranked insurance business in the UK, highlighting our strong employee experience and the positive feedback our people share on the platform. Additionally, we were named in the LinkedIn Top Companies 2026 list of "Best midsize employers to grow your career in the UK", and we’ve been certified as a UK Top Employer by the Top Employers Institute in 2023, 2024, 2025 and 2026. We offer a supportive and empowering culture where people are inspired to perform, given opportunities to grow, and recognised and rewarded for their contribution. Our people are proud to work for a company that respects them and their communities, and they trust us to be financially sustainable - so we’re successful now and in the future.