Expire in: 24 days
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 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
* 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 inclusivityDo not include the following in your job application, CV, or cover letter:
You should not be asked for payment or irrelevant information. If you have concerns about a job advert or employer, seek guidance on how to proceed.
Looking for your next career move? Join a top company hiring Analytics Engineer job near me in LS1, Leeds, West Yorkshire! This is your chance to work on exciting projects, grow professionally, and enjoy a rewarding career with competitive pay and excellent benefits. Whether you're an experienced professional or looking to take the next step, this role offers the perfect opportunity to enhance your skills and make an impact. Don’t miss out—apply today via Vita CV and take your career to the next level!
© Vita CV: Registered in England and Wales (16187919).
Vita CV uses cookies to enhance your experience, analyze site traffic, and personalize content. By continuing to browse, you agree to our use of cookies.