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.

Strong SQL skills and experience building analytical models in Snowflake.
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.
Strong SQL skills
Experience with dbt
Data modelling techniques
Handling large datasets
Problem-solving and communication skills
Experience in an enterprise environment

About the Company: Aviva is investing in its strategic data platform to unlock actionable insights across Insurance Claims.

Pay range and compensation package: Contract: 6 Months

2 Insurance jobs in Thorpe Hamlet, Norwich