Data Engineer DBT and Snowflake

Aviva Direct Ireland Limited; Norwich; Hybrid; GBP 48,000; Full time

Job summary

A leading insurance firm is seeking a Data Engineer proficient in Snowflake and DBT to enhance customer data solutions. In this role, you will work with cross-functional teams to design and deliver high-quality data products that improve customer engagement. The ideal candidate will have strong analytical skills, hands-on experience with SQL and ETL, and a focus on scalable engineering solutions. The position offers a competitive salary of circa £48,000, located in Norwich, UK.

Benefits

Salary circa £48,000

Bonus opportunity up to 8%

Generous pension scheme

29 days holiday plus bank holidays

Discounts on Aviva products

Free Aviva shares through Matching Share Plan

Supportive policies for parents and carers

Flexible benefit options

3 paid volunteering days

Wellbeing support and tools

Qualifications

• 5+ years experience in data engineering or related field.
• Ability to design data models and transformation pipelines.
• Excellent problem-solving and analytical skills.

Responsibilities

• Join the SVOC platform team to enhance customer data.
• Deliver engineering changes to improve customer engagement.
• Collaborate with multiple stakeholders to create data solutions.

Skills

Strong analytical mindset

Translation of business needs to scalable solutions

Experience with Snowflake and DBT

Hands-on experience with SQL and ETL

Proficiency in Python or PySpark

Data modelling techniques

Tools

Snowflake

DBT

AWS services (S3, Redshift)

Job description

Overview

Data Engineer ( DBT and Snowflake)

Salary: circa £48,000

This is a great job for someone who loves solving data puzzles and is curious about how data engineering influences our Aviva customer journeys. You will already be a Data Engineer, excited by the possibilities of big data, automation, and innovation. You’re keen to grow your skills in a collaborative, supportive team and want to make a real impact on how we understand and serve our customers. If Snowflake, DBT, SQL, Python, and customer-centric data solutions spark your interest – this could be your next big move.

A bit about the job:

You’ll join the Single View of Customer (SVOC) platform team, part of Aviva’s Customer Data Platforms (CDP). We build and manage unified customer data products that power analytics, marketing, servicing, and operations. As a Snowflake Analyst/Engineer, you’ll help deliver engineering changes that improve customer experience and engagement. You’ll work closely with designers, engineers, product owners and stakeholders to turn business needs into high-quality data solutions.

Skills and experience we’re looking for

• Strong analytical mindset with expertise in data analysis, low‑level design, fact‑finding, and root‑cause investigation.
• Proven ability to translate business needs, mappings, and transformation rules into scalable engineering solutions and DBT models on Snowflake.
• Hands‑on experience with Snowflake, DBT, SQL, ETL pipelines, and AWS services including S3, Redshift, and Postgres.
• Proficient in Python or PySpark with experience using orchestration tools like Airflow for data engineering workflows.
• Skilled in data modelling techniques, performance optimisation in Snowflake, and building scalable data models and transformation pipelines in cloud environments.

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 circa £48,000 (depending on location, skills, experience, and qualifications)
• Bonus opportunity 8% 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

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 [e-mail]