Lead Data Engineer

TN United Kingdom; York; On-site; GBP 50,000 - 65,000; Full time

Job summary

Join a forward-thinking company as a Data Engineering Specialist, where you will design and deliver impactful data products. Collaborate with diverse teams to transform raw data into actionable insights, driving innovation in the insurance sector. This role offers a unique opportunity to shape the future of data and AI, working with cutting-edge technologies and methodologies. With a competitive salary, generous benefits, and a commitment to professional development, you will thrive in an environment that values your contributions and promotes continuous learning.

Benefits

Generous pension scheme

29 days holiday plus bank holidays

Up to 40% discount on Aviva products

Free Aviva shares through Matching Share Plan

Flexible benefits including sustainability options

Paid volunteering days

Wellbeing support and tools

Qualifications

• Strong experience in SQL and database management.
• Proficient in ETL/ELT development using SQL and Python.

Responsibilities

• Design and maintain reusable data products for business solutions.
• Collaborate with teams to solve data-related business problems.

Skills

SQL

Database Management

ETL/ELT Development

Data Modelling

CI/CD Processes

Tools

Snowflake

SQL Server

dbt

Azure DevOps

Azure Data Factory

Job description

Social network you want to login/join with:

Are you someone who is passionate about the power of data, recognizes its value, and loves working with a broad range of stakeholders and teams? If so, this could be a great opportunity for you.

The insurance industry is evolving rapidly with technological advancements, and Aviva is investing in creating data products that drive machine learning and analytics as a distinctive capability.

Quantum is dedicated to collaboration, sharing expertise and ideas, and fostering continuous learning from our data professionals. Coming together as one allows us to share data techniques more easily, rapidly re-use best practice ideas, and support your learning and development. This year we were shortlisted for five categories at the prestigious Data IQ 2024 Awards, recognising Aviva’s unwavering commitment to innovation and excellence in the field of Data and AI.

A bit about the job:

The role involves collaborating with senior data and business leaders, engineers, data & platform architects, and business/data teams to deliver solutions that empower our data teams to transform our data capability. You will be responsible for owning and delivering the Data Engineering pipelines that power our Analytics. Working across a broad range of initiatives in both BAU and our transformation portfolio, you will formulate and deliver against a data roadmap, balancing tactical and strategic needs to move towards a purposeful set of data products to support the business.

We are looking for someone who can challenge the status quo, focus on delivering great business outcomes, and champion the use of data, technology, and collaboration to help us shape an exciting future.

Come and join our high-profile Data Engineering Team as a Data Engineering Specialist and be part of an innovative team that transforms raw data into valuable business insights.

Are you ready to join us in our quest to drive innovation and harness the power of data and AI across Aviva? Quantum is Aviva's Global Data Community, with us, you will have access to data for over 19 million customers, allowing you to create truly outstanding products and deliver enhanced experiences for our customers. This year we were shortlisted for five categories at the prestigious Data IQ 2024 Awards, recognising Aviva’s unwavering commitment to innovation and excellence in the field of Data and AI.

What You'll Do:

• Design, Build, and Deliver Data Products: Interpret business problems and create and maintain reusable data products that are trusted and maintained.
• Collaborate Across Teams: Share knowledge, provide the data and support needed to solve business problems.
• Communicate Effectively: Explain data issues and solutions to non-data stakeholders.
• Maintain Data Environments: Oversee regular processes and ensure adherence to data governance.
• Mentor and Lead Others: Guide other data engineers, review code, and reduce risk to data quality and delivery.

Skills and Experience:

• SQL and Database Management: Strong experience with Snowflake and SQL Server or similar.
• ETL/ELT Development: Experience with dbt (core or cloud) using SQL and Python and/or similar technology such as MS SQL SSIS, Azure Data Factory, DataIku, or Informatica.
• CI/CD Processes: Knowledge of Azure DevOps and how to use it to support a CI/CD process for data.
• Data Modelling: Understanding of Analytical Data Modelling techniques like Dimensional Modelling and Data Vault Modelling.

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 £50,000 - £65,000 (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.