Data Engineer Specialist

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 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 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 harjot.kaur@aviva.com