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.
Qualifications
* 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
Preferred Skills
* Experience in an enterprise environment
Benefits
Contract: 6 Months
Equal Opportunity Statement
Aviva is committed to diversity and inclusivity.
#J-18808-Ljbffr