Analytics Engineer

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

Required Skills:

• Strong SQL skills

• Experience with dbt

• Data modelling techniques

• Handling large datasets

• Problem-solving and communication skills

Preferred Skills:

• Experience in an enterprise environment

Pay range and compensation package: Contract: 6 Months

Equal Opportunity Statement: Aviva is committed to diversity and inclusivity

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