Business Intelligence Engineer

Are you someone who thrives on turning data into actionable insights? At Aviva, we’re looking for a Business Intelligence Engineer who is passionate about using data to solve complex problems and help drive strategic decisions. If you’re excited by the idea of working with cutting-edge tools and transforming business challenges into data-driven solutions, then this is the perfect role for you.

As a Business Intelligence Engineer, you’ll play a critical role in developing and maintaining our business intelligence pipelines. You’ll work closely with cross-functional teams to design innovative data models, write clean and efficient code, and deliver new data features that support our business objectives.

A bit about the job:

• Working alongside other Engineers you will be building and maintaining data pipelines into the Claims BI team, creating long lasting data modelling necessary to facilitate reporting and analytics, identifying new data sources, and building out comprehensive data views for your BI colleagues to ingest. You will:
• Collaborate with and build on the work of Data Engineering to build out a governed, strategic, Claims data asset in Snowflake for use across UKGI Claims
• Collaborate with colleagues across Aviva IT/Data Engineering to improve the ingestion of 3rd party data, including removing existing manual effort, improving the quality and timeliness of existing feeds as well as setting up the ingestion of new feeds of data
• Work with data source providers to ensure the delivery of timely and accurate data to our Claims BI colleagues

Skills and experience we’re looking for:

• Writes clean, maintainable, and robust code in SQL or similar languages
• Knowledge of data architecture, data warehousing and modelling techniques
• Communication and interpersonal skills, ability to build relationships, internally and externally
• Experience working on relational databases e.g. Snowflake, Oracle, SQL Server, etc or with reporting and BI packages e.g. QlikView, Tableau, Power BI etc
• Experience in Data Quality Assessment (profiling, anomaly detection) and data documentation (schema, dictionaries)

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 £30,000 - £45,000 depending on location, skills, experience, and qualifications)
• Bonus opportunity – 8% 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

Salary: £30,000 - £45,000 per annum