Lead Data Engineer

Aviva Direct Ireland Limited; Norwich; Hybrid; GBP 55,000 - 65,000; Full time

Job summary

A leading insurance company is seeking a Lead Data Engineer to join their high-profile Data Engineering Team. In this role, you’ll deliver innovative data solutions, work closely with data scientists, and lead a team of engineers in transforming data into business insights. The position offers a salary range of £55,000 - £65,000, along with a bonus opportunity, generous pension scheme, and a range of employee benefits, including flexible working options.

Benefits

Bonus opportunity of 10%

Generous pension scheme

29 days holiday plus bank holidays

40% discount on Aviva products

Up to £1,200 of free Aviva shares

Flexible benefits

Paid volunteering days

Wellbeing support

Qualifications

• Proven experience designing and optimizing data solutions in Snowflake.
• Hands-on experience creating robust data pipelines for analytics.
• Knowledge of data modeling techniques like Data Vault and Dimensional Modelling.

Responsibilities

• Lead design and delivery of scalable data products.
• Work closely with data scientists for high-quality data.
• Ensure strong data governance and maintain documentation.
• Provide technical leadership and mentorship to data engineers.

Skills

Data product design

Data governance

Communication with stakeholders

Hands-on data pipeline experience

Tools

Snowflake

dbt

Azure DevOps

Data Iku

Job description

Lead Data Engineer

Salary: £55,000 - £65,000

Locations: Norwich/ Bristol/ Sheffield/ York

Are you someone who would like to be part of our high-profileData Engineering Team?We are seekinganenthusiastic Data EngineerSpecialist to be part of our innovative team which help shape the future of the life insurance business at Aviva.You’llwork and guide the work of a team of data engineers using languages of SQL and some Python in market leading tools like Snowflake anddbt(as well as SQL Server) to transform raw data from multiple systems into business focussed information. Information that can be used for a range of purposes from Data Science, Informational Dashboards and Reporting through to Self-service queries by analysts.

A bit about the job:

We work across all business lines, delivering data analytics solutions forprotection, healthcare, wealth,cooand retirement.

We are looking to finding candidates who can:

• Lead the design and delivery of scalable data products, translating complex business problems into robust data solutions and owning core data pipelines and platform reliability.
• Work closely with data scientists to provide high‑quality, well‑modelled data that enables advanced analytics and data science use cases.
• Communicate effectively with non‑technical stakeholders, clearly explaining data solutions, progress, risks, and issues across project and BAU work.
• Ensure strong data governance and engineering standards, producing clear high‑ and low‑level designs, maintaining documentation, and ensuring data is used appropriately and securely.
• Provide technical leadership and mentorship to data engineers through coaching, code and design reviews, and collaboration across engineering, and wider business teams to embed best practices.

Skills and experience we’re looking for

• Proven experience designing, developing, and optimizing data solutions in Snowflake and ability to build and maintain modular, testable, and well‑documented transformations using dbt.
• Hands‑on experience creating robust data pipelines and data products for analytics. Familiarity with tools like Data Iku or Informatica is advantageous.
• Knowledge of CI/CD processes and in particular tools like ADO (Azure Dev Ops) would be very beneficial as this will be key to our delivery and deployment processes.
• Understanding of data modelling techniques particularly those suited to analytical data (Data Vault and Dimensional Modelling).
• Familiarity with healthcare or insurance data domains is a plus, as you’ll be working on critical data products that support healthcare initiatives.

What you’ll get for this role:

Our purpose - with you today, for a better tomorrow – is a promise we make to our colleagues too. And one of the ways we live up to that promise is by investing in you. We have so much to offer when it comes to being an Aviva colleague.

• Salary £55,000 - £65,000 (depending on location, skills, experience, and qualifications)
• Bonus opportunity 10% of annual salary - Actual amount depends on your performance and Aviva’s
• Generous pension scheme - Aviva will contribute up to 14%, depending on what you put in
• 29 days holiday plus bank holidays, and you can choose to buy or sell up to 5 days
• Make your money go further - Up to 40% discount on Aviva products, and other retailer discounts
• Up to £1,200 of free Aviva shares per year through our Matching Share Plan and share in the success of Aviva with our Save As You Earn scheme
• Brilliantly supportive policies including parental and carer’s leave
• Flexible benefits to suit you, including sustainability options such as cycle to work
• Make a difference, be part of our Aviva Communities and use your 3 paid volunteering days to help others
• We take your wellbeing seriously with lots of support and tools

Take a look to learn more. Put a salary into this calculator to see what your total Aviva Reward could be

Aviva is for everyone:

We’re inclusive and welcome everyone – we want applications from all backgrounds and experiences. Excited but not sure you tick every box? Even if you don’t, we would still encourage you to apply. We also consider all forms of flexible working, including part time and job shares.

We flex locations, hours and working patterns to suit our customers, business, and you. Most of our people are smart working – spending around 50% of their time in our offices every week - combining the benefits of flexibility, with time together with colleagues.

To find out more about working at Aviva take a look

We interview every disabled applicant who meets the minimum criteria for the job. Once you’ve applied, please send us an email stating that you have a disclosed disability, and we’ll interview you.

We’d love it if you could submit your application online. If you require an alternative method of applying, please give Harjot Kaur a call on 07353138456 or send an email to [e-mail]