Data Engineering Associate

Aviva; York; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer and be part of a high-profile Life Data Engineering Team. This role offers the opportunity to use SQL and Python tools to transform raw data into valuable business insights, supporting various initiatives from data science to reporting. You will collaborate with diverse teams, helping to build data products that address business challenges. With a competitive salary and generous benefits including a bonus scheme, pension contributions, and flexible working options, this is an exciting opportunity to make a meaningful impact in the life insurance sector.

Benefits

Bonus opportunity

Generous pension scheme

29 days holiday

Discount on Aviva products

Free Aviva shares

Supportive policies

Flexible benefits

Paid volunteering days

Wellbeing support

Qualifications

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

Responsibilities

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

Skills

SQL

Python

ETL/ELT

Data interrogation

Data modeling techniques

Tools

DBT

Snowflake

DataIku

Informatica PowerCenter

Job description

Data Engineer

Salary:£35,000 - £45,000

Are you ready to be part of our high-profile Life Data Engineering Team? We are seeking 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.

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 Leena Manga a call on 07353163239 or send an email [e-mail].