Analytics Engineer
Aviva Plc, Marylebone, City of Westminster
Analytics Engineer
Salary not available. View on company website.
Aviva Plc, Marylebone, City of Westminster
- Full time
- Permanent
- Onsite working
Posted 1 week ago, 17 Apr | Get your application in now before you're too late!
Closing date: Closing date not specified
Job ref: 5b5a09807670429195c4669c28592d46
Location ref: Marylebone, City of Westminster
Full Job Description
- 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
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
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.
Direct job link
https://www.jobs24.co.uk/job/analytics-engineer-126706130