Lead BI Engineer

Lead Business Intelligence Engineer

Salary £45,000 - £60,000

Are you someone who thrives on turning data into powerful insights? Do you have a passion for developing innovative Business Intelligence (BI) solutions that drive real impact? If you’re experienced in BI engineering and excited about leading projects at the forefront of data transformation, we want to hear from you!

A bit about the job:

At Aviva, we’re seeking a dynamic and highly skilled Lead BI Engineer to join our growing Business Intelligence team. In this role, you’ll have the opportunity to shape and optimise our BI architecture, working with cutting-edge tools and technologies to deliver solutions that empower decision-makers across the organisation.

Skills and experience we’re looking for:

• Technical Expertise: A deep understanding of data architecture and modelling, proficiency in SQL or similar languages. Hands-on experience with Snowflake, dbt, and Airflow, or equivalent data pipeline tools.

• Data Transformation: Expertise in data transformation processes and a proven track record in designing and implementing data pipelines to extract data from various sources and transform it for use in visualisation tools like Qlik, Tableau, or Power BI.

• Data Modelling: The ability to create robust data models that support complex business analysis and reporting. Experience with data modelling techniques such as dimensional modelling or entity-relationship modelling.

• Data Quality: having a strong understanding of data quality principles and best practices and experience with data validation, cleansing, and standardisation techniques.

• Continuous Learning and Adaptability: A passion for staying current with the latest trends and technologies in data and analytics in addition to the ability to adapt to new tools, methodologies, and business needs.

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