Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and build analytical data models to transform raw data into actionable insights.
- Company: Join Aviva, a leader in insurance, driving innovation through data.
- Benefits: Flexible work environment with a mix of office and remote options.
- Why this job: Make a real impact by turning complex data into valuable business solutions.
- Qualifications: Strong SQL skills and experience with dbt and Snowflake required.
- Other info: Diverse and inclusive workplace with opportunities for growth.
The predicted salary is between 50000 - 60000 £ per year.
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 inclusivity.
Analytics Engineer employer: Randstad Sourceright
Contact Detail:
Randstad Sourceright Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your analytical models and projects. This is your chance to demonstrate your expertise with dbt and Snowflake, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling techniques. Be ready to discuss how you've transformed complex datasets into actionable insights, as this will resonate well with potential employers.
✨Tip Number 4
Don't forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Analytics Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Analytics Engineer. Highlight your SQL skills and experience with dbt and Snowflake, as these are key for us at Aviva. Customising your CV shows that you understand what we’re looking for!
Showcase Your Projects: Include specific examples of analytical models you've built or complex datasets you've handled. We love seeing real-world applications of your skills, so don’t hold back on sharing your successes!
Keep It Clear and Concise: When writing your application, clarity is key! Use straightforward language and avoid jargon unless it’s relevant. We want to see your problem-solving skills shine through without getting lost in technical terms.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Randstad Sourceright
✨Know Your Tools Inside Out
Make sure you’re well-versed in SQL, dbt, and Snowflake. Brush up on your skills and be ready to discuss how you've used these tools in past projects. Being able to share specific examples will show that you’re not just familiar with them, but that you can leverage them effectively.
✨Understand the Business Context
Since this role involves transforming data for business use, take some time to understand Aviva's insurance claims process. Familiarise yourself with key metrics and definitions they might use. This will help you demonstrate how your technical skills can directly support their business goals.
✨Prepare for Problem-Solving Questions
Expect questions that assess your problem-solving abilities, especially around handling large datasets and data modelling techniques. Think of scenarios where you’ve tackled complex data challenges and be ready to explain your thought process and the outcomes.
✨Showcase Your Collaboration Skills
This role requires working closely with both technical and business teams. Be prepared to discuss how you’ve successfully collaborated in the past. Highlight any experiences where you’ve had to explain complex data concepts to non-technical stakeholders, as this will showcase your communication skills.