At a Glance
- Tasks: Design and build analytical data models using dbt and Snowflake for impactful insights.
- Company: Join Aviva, a leader in insurance, driving innovation through data.
- Benefits: Flexible work environment with 50% remote options and competitive pay.
- Other info: Collaborative team culture with opportunities for professional growth.
- Why this job: Transform raw data into actionable insights that shape the future of insurance.
- Qualifications: Strong SQL skills and experience with dbt and data modelling techniques.
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.
Job Type: Contract - 6 Months
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
Data Modelling (dbt/snowflake) in Coventry employer: Aviva
Aviva is an exceptional employer that prioritises employee growth and development within a collaborative work culture. With a flexible working model that allows for a balanced approach between office and home, employees can thrive in their roles while contributing to meaningful projects that drive innovation in the insurance sector. The company offers competitive benefits and a commitment to unlocking actionable insights through strategic data initiatives, making it an attractive place for professionals seeking impactful careers.
StudySmarter Expert Advice🤫
We think this is how you could land Data Modelling (dbt/snowflake) in Coventry
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Aviva before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Aviva.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Aviva.
We think you need these skills to ace Data Modelling (dbt/snowflake) in Coventry
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Aviva, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Aviva, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Aviva’s attention and show the tangible impact of your work.
How to prepare for a job interview at Aviva
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Aviva.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Aviva.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Aviva.
