Data Engineer

Data Engineer

Salary: Circa £80,000

A bit about the job:

You will be joining a Data Engineering team that is responsible for ensuring our data consumers have access to the insights they need to ensure we are delivering the best service to our customers, and continuing to grow the Aviva Zero business.

Our downstream consumers don't want simple dashboards. They are highly skilled analysts, actuaries, and data scientists that are using this data to directly impact the business and our customers. You will play a key role in this process, and immediately be able to see the impact of your work.

We work projects all the way through from initial discovery to completion. You won't be handing work off to large teams of architects, analysts, testers, infrastructure, etc. You will take ownership for the full development lifecycle (with specialist support/pairing etc where required).

You will be working closing with our application teams to ingest data from our modern AWS stack into Snowflake. Being a greenfield platform there's little to no digging into horrible legacy systems. From there, we use dbt to transform raw data into our Data Vault model. We then build data products on top of this to serve our diverse array of internal and external data consumers.

Everything we do is with good engineering principles first and foremost, so you will be deploying all infrastructure as code (Terraform for Snowflake, CDK for AWS), writing tests with dbt and Python, updating CI/CD pipelines on GitHub Actions, building out observability and monitoring with AWS CloudWatch etc.

Skills and experience we’re looking for:

• Advanced SQL proficiency – capable of writing clean, efficient queries to handle complex datasets; able to demonstrate skills in a technical test.

• Cloud expertise – experienced in deploying, running, and monitoring workloads on major cloud platforms (preferably AWS), with hands-on delivery of cloud-based data projects.

• Strong Python skills – familiar with tools like Pandas, PySpark, and Airflow; able to demonstrate foundational Python knowledge in a technical test.

• Data warehouse experience – skilled in using cloud-based data warehouses such as Snowflake, with understanding of data modeling principles.

• Tech stack familiarity – exposure to tools like dbt, Airflow (MWAA), Terraform, CDK, and scripting in Python or Go is a plus.

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 £80,000 for London based (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