Data Engineer

Aviva Direct Ireland Limited; Norwich; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

A leading insurance company is seeking a Data Engineer to join their high-profile Data Engineering Team. The role involves building data products and pipelines, ensuring data integrity, and collaborating with data scientists. The successful candidate will have expertise in SQL and relational databases, particularly Snowflake. This position offers a competitive salary ranging from £35,000 to £45,000, along with flexible work arrangements and a robust benefits package including a generous pension, annual bonus, and personal development opportunities.

Benefits

Bonus opportunity up to 8%

Generous pension scheme

29 days holiday plus bank holidays

Discounts on Aviva products

Free Aviva shares

Flexible benefits

Paid volunteering days

Wellbeing support

Qualifications

• Experience in relational database management systems.
• SQL experience with large databases.
• ETL/ELT experience especially with dbt.

Responsibilities

• Build and support data products and pipelines.
• Work closely with data scientists for accurate data.
• Communicate data issues to non-technical stakeholders.

Skills

Relational database management systems

SQL

ETL/ELT

Data interrogation

Data modelling techniques

Tools

Snowflake

dbt

DataIku

Informatica PowerCenter

Job description

Data Engineer

Salary: £35,000 - £45,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 enthusiastic Data Engineers to be part of our innovative team which help shape the future of the life insurance business at Aviva. You’ll use SQL and Python based tools to transform raw data from multiple systems into business focussed information that can be used for a range of purposes from Data Science, though 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:

• Build and support data products and pipelines, translating defined business requirements into well‑engineered data solutions.
• Work closely with data scientists and analysts to provide accurate, well‑prepared data that supports analytics and data science use cases.
• Communicate data issues and solutions clearly to non‑technical stakeholders, escalating risks or blockers where needed.
• Support regular data loads and data platform maintenance, helping ensure data environments are reliable and performant.
• Follow data governance and engineering standards, collaborating with other data engineers, and business teams while sharing knowledge and learning best practices.

Skills and experience we’re looking for

• Experience in relational database management systems.
• SQL experience (preferably Snowflake experience would be ideal) the ability to query large and complex databases using SQL.
• ETL/ELT experience ("dbt" experience would be ideal).
• Strong data interrogation and manipulation skills and any experience in tools like DataIku, Informatica PowerCenter or similar would be advantageous.
• Understanding of data modelling 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.

• Salary £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 Harjot Kaur a call on 07353138456 or send an email to [e-mail].