Data Engineering Associate

TN United Kingdom; York; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

An innovative firm is seeking a passionate Data Engineer to join its Life Data Engineering Team. In this role, you'll harness SQL and Python-based tools to transform raw data into actionable insights for the life insurance sector. Your contributions will drive data analytics solutions across various business lines, from pricing to claims. With a focus on collaboration and data governance, you'll work alongside data scientists and other teams to create impactful data products. This is a fantastic opportunity to make a difference in a forward-thinking organization committed to investing in its employees' growth and wellbeing.

Benefits

Generous pension scheme

29 days holiday plus bank holidays

Up to 40% discount on Aviva products

Free Aviva shares through Matching Share Plan

Paid volunteering days

Flexible benefits

Supportive wellbeing policies

Qualifications

• Experience in relational database management systems.
• Proficiency in SQL and Snowflake experience is ideal.
• Strong data interrogation and manipulation skills.

Responsibilities

• Deliver data analytics solutions for pricing, risk cost, and underwriting.
• Collaborate with data scientists to provide data for business solutions.
• Support regular load processes and maintain data environments.

Skills

SQL

Python

Data Modeling

ETL/ELT

Data Interrogation

Tools

DBT

Snowflake

DataIku

Informatica PowerCenter

Job description

Social network you want to login/join with:

Are you ready to be part of our high-profile Life Data Engineering Team? We are seeking an enthusiastic Data Engineer to join our innovative team at Aviva, helping shape the future of the life insurance business. You will use SQL and Python-based tools like DBT and Snowflake to transform raw data from multiple systems into business-focused information. This data will be used for a range of purposes, from Data Science and Informational Dashboards to Reporting and Self-service queries by analysts.

A bit about the job:

• Work across all business lines, delivering data analytics solutions for pricing, risk cost, and underwriting, as well as customer-facing initiatives in claims, fraud, and beyond.
• Interpret business problems and build suitable data solutions in the form of “Data Products.”
• Collaborate with data scientists to provide data that enables them to solve business problems through data science.
• Support regular load processes and maintain data environments.
• Assist with data governance processes to ensure data is used correctly by the right people.
• Collaborate with other business lines, data engineering functions, and IT within Aviva, sharing knowledge, ideas, and best practices.

Skills and experience we’re looking for:

• Experience in relational database management systems.
• Proficiency in SQL (preferably SQL Server Management Studio 2012) and Snowflake experience is ideal.
• ETL/ELT experience (SSIS packages 2005/2010, experience with “dbt” is ideal).
• Strong data interrogation and manipulation skills; experience with tools like DataIku, Informatica PowerCenter, or similar is advantageous.
• Understanding of data modeling techniques, particularly those suited to analytical data.

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.
• Starting salary between £35,000 - £45,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.

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.