About the Company : Aviva is investing in its strategic data platform to unlock actionable insights across Insurance Claims. Location: NR1 3NG (50% office based 50% from home) About the Role : Randstad Sourceright is recruiting on behalf of Aviva. We are seeking an experienced Analytics Engineer to design, build, and maintain high-quality analytical data models using dbt and Snowflake, supporting key Claims use cases across Motor, Property, and other Lines of Business. This role sits at the intersection of data engineering, BI, and business understanding transforming raw operational data into trusted, governed datasets that enable reporting, self-service analytics, and advanced insight generation. 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...