Lead BI Engineer in Norwich

Lead BI Engineer in Norwich

Norwich Full-Time 45000 - 55000 £ / year (est.) Hybrid
Aviva

At a Glance

  • Tasks: Lead the development of a modern data transformation platform and support a talented team.
  • Company: Join Aviva, a forward-thinking company committed to inclusivity and innovation.
  • Benefits: Enjoy a competitive salary, bonus opportunities, generous pension scheme, and 29 days holiday.
  • Other info: Flexible working options available, including part-time and job shares.
  • Why this job: Make a real impact by shaping data-driven decisions across the business.
  • Qualifications: Strong experience with Snowflake, dbt, SQL, and previous leadership roles.

The predicted salary is between 45000 - 55000 £ per year.

This is a great job for someone who enjoys combining hands-on data engineering expertise with team leadership. You'll be experienced with Snowflake, dbt and SQL and ready to play a key role in shaping how data supports decision‑making across Personal Lines.

A bit about the job

You'll join our Personal Lines Business Intelligence team, helping us deliver trusted, high‑quality data that supports decisions across the business. The role exists to lead the development and enhancement of our modern data transformation platform, ensuring data is reliable, scalable and ready for future growth. You'll coordinate engineering delivery, support and develop a talented team, and help drive our move from legacy platforms to a cloud‑based data ecosystem. Working with engineers, analysts and business stakeholders, you'll make sure our data products meet business needs and deliver real value. You'll also play an important role in shaping engineering standards, ways of working and continuous improvement across the team.

Skills and experience we're looking for:

  • 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.

What you'll get for this role:

  • Starting salary circa £50k (depending on location, skills, experience, and qualifications).
  • Bonus opportunity 10% - actual amount depends on your performance and Aviva's.
  • Generous pension scheme e.g. if you put in 8%, Aviva adds 14% in.
  • 29 days holiday plus bank holidays, and you can choose to buy or sell up to 5 days.
  • Aviva-funded Private Medical Benefit to help you get expert support when you need it.
  • 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.

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 at least 50% of their time in our offices every week - combining the benefits of flexibility, with time together with colleagues.

Lead BI Engineer in Norwich employer: Aviva

Aviva is an excellent employer for a Senior Business Analyst, offering a dynamic hybrid working environment in Bristol or York. With a strong focus on employee growth and flexible working arrangements, Aviva fosters a collaborative culture that empowers individuals to thrive while contributing to significant transformation programmes in Third Party Risk Management. The company provides competitive benefits and the opportunity to engage in meaningful projects that drive real impact across multiple markets.

Aviva

Contact Details:

Aviva Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Lead BI Engineer in Norwich

✨Get to Grips with Data Visualisation Tools

If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.

✨Join Local Business Intelligence Meetups

Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Aviva!

✨Engage with Online BI Communities

Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.

✨Leverage Your University’s Career Support

If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!

We think you need these skills to ace Lead BI Engineer in Norwich

Communication Skills
Python
Data Governance
Data Engineering
Data Pipeline Development
Data Quality Assurance
SQL

Some tips for your application 🫡

Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.

Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.

Tailor Your Documents for Us:When applying for a full-time role at Aviva, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!

Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.

How to prepare for a job interview at Aviva

✨Show off your analytical skills

In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!

✨Practice your technical know-how

Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.

✨Portfolio of Projects

Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.

✨Know their business model

Get familiar with Aviva’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.