BI Engineering Lead: Snowflake, dbt & SQL

Aviva; Norwich; On-site; GBP 45,000 - 55,000; Full time

Benefits offered by this job

Bonus 10%

Generous pension scheme

29 days holiday

Private Medical Benefit

Discounts on Aviva products

Matching Share Plan

Save As You Earn

Parental and carer's leave

Flexible benefits

Cycle to work

Paid volunteering day

Wellbeing support

Job summary

Aviva in Norwich is seeking a Lead BI Engineer to combine hands-on data engineering with team leadership. You will shape our modern data transformation platform, ensure data is reliable, scalable and ready for growth, and coordinate delivery across the BI team.

You'll mentor engineers, collaborate with analysts and business stakeholders, drive engineering standards, and help move from legacy systems to a cloud-based data ecosystem while delivering real business value.

Qualifications

• Strong experience using Snowflake, dbt and SQL to build and enhance data transformation pipelines and data models.
• Experience leading technical delivery, setting engineering standards and supporting teams to solve complex challenges.
• Previous people leadership experience, including coaching, development conversations and performance reviews.
• Ability to work closely with stakeholders and translate business requirements into practical engineering solutions.
• Experience working in Agile environments. Scrum Master, Azure DevOps, Jira or wider BI platform migration experience would be beneficial.

Responsibilities

• Lead the development and enhancement of our modern data transformation platform, ensuring data is reliable and scalable.
• Coordinate engineering delivery, support and develop a talented team.
• Help move from legacy platforms to a cloud-based data ecosystem and ensure data products meet business needs.
• Shape engineering standards, ways of working and continuous improvement across the team.

Skills

Snowflake

dbt

SQL

Technical leadership

People leadership

Stakeholder management

Agile

Scrum Master

Azure DevOps

Jira

Tools

Azure DevOps

Jira

Job description

Aviva in Norwich is seeking a Lead BI Engineer to combine hands-on data engineering with team leadership. You will shape our modern data transformation platform, ensure data is reliable, scalable and ready for growth, and coordinate delivery across the BI team.

You'll mentor engineers, collaborate with analysts and business stakeholders, drive engineering standards, and help move from legacy systems to a cloud-based data ecosystem while delivering real business value.