Data Engineer Specialist

Aviva; Bristol; Hybrid; GBP 55,000 - 65,000; Full time

Job summary

A leading insurance provider in the UK is seeking a Data Engineer Specialist to join their Data Engineering Team. The role involves designing and delivering scalable data solutions using SQL and Python, with tools like Snowflake. Ideal candidates will communicate effectively across teams, ensure strong data governance, and mentor junior engineers. Salary ranges from £55,000 to £65,000 with opportunities for bonuses and a comprehensive benefits package, including a generous pension scheme.

Benefits

Bonus opportunity of 10%

Generous pension scheme

29 days holiday plus bank holidays

Up to 40% discount on Aviva products

Free Aviva shares through Matching Share Plan

Supportive parental and carer's leave policy

Flexible benefits options

Paid volunteering days

Qualifications

• Proven experience in developing and optimizing data solutions in Snowflake.
• Hands-on experience creating robust data pipelines for analytics.
• Understanding of data modelling techniques suitable for analytical purposes.

Responsibilities

• Lead the design and delivery of scalable data products.
• Work closely with data scientists to provide quality data for analytics.
• Communicate with non-technical stakeholders effectively.

Skills

Experience in Snowflake

SQL proficiency

Python skills

Data modeling techniques

CI/CD processes

Data governance

Tools

dbt

Dataiku

Informatica

Azure Dev Ops

Job description

Overview

Data Engineer Specialist

Salary: £55,000 - £65,000

Locations: Norwich/ Bristol/ Sheffield/ York

Are you someone who would like to be part of our high-profile Data Engineering Team? We are seeking an enthusiastic Data Engineer Specialist to be part of our innovative team which help shape the future of the life insurance business at Aviva. You’ll work and guide the work of a team of data engineers using languages of SQL and some Python in market leading tools like Snowflake and dbt (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 for protection, healthcare, wealth, coo and retirement.

We are looking to find 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 Dataiku 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 here

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]