Salary: £15,000 - 72,000 per year Requirements: Strong SQL skills Hands-on experience with dbt, including models, tests, documentation, and incremental strategies Solid understanding of data modelling techniques, such as Kimball-style dimensions, facts, and Slowly Changing Dimensions Experience handling large, complex datasets in an enterprise environment Excellent problem-solving, collaboration, and communication skills, with the ability to explain complex data concepts to business stakeholders Responsibilities: Design and implement scalable analytical data models in Snowflake using dbt, following best practices including dimensional modelling, Slowly Changing Dimensions (SCDs), and incremental processing Transform complex Claims source data into business-ready datasets aligned with agreed metrics and definitions Own and evolve models that underpin dashboards, management information (MI), regulatory reporting, and ad-hoc analysis Collaborate with business and technical teams to understand requirements and deliver actionable data solutions Maintain documentation, testing, and quality standards to ensure data reliability and consistency Technologies: SQL Snowflake dbt More: We are Aviva, a company committed to investing in our strategic data platform to unlock actionable insights across Insurance Claims. We are looking for an experienced Analytics Engineer for a hybrid role located at NR1 3NG, where you will work 50% from the office and 50% from home. This position offers a unique opportunity to design, build, and maintain high-quality analytical data models, supporting key Claims use cases across various Lines of Business. We believe in fostering diversity and inclusivity within our team. last updated 21 week of 2026