Lead Data Engineer

Lead Data Engineer

Salary £45,000 - £60,000

Are you someone who is passionate about the power of data, recognises 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.

The Insurance, Wealth, and Retirement business is excited to transform and invest in its core data capabilities and modernise its technology and data estate. As part of this transformation, we have an exciting opportunity for a Lead Data Engineer to join the team and work across our business units to shape our data into an asset that supports our business strategies.

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.

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 £45,000 - £60,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.

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 Matthew Drew a call on 0121 234 7664 or send an email to matthew.drew@aviva.com.