Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design of a centralised data model for a top UK insurance brand.
- Company: Join a renowned insurance company undergoing a major data transformation.
- Benefits: Enjoy hybrid working, competitive pay, and potential contract extension.
- Why this job: Make a significant impact in a collaborative environment with cutting-edge data solutions.
- Qualifications: 5+ years in data modelling, strong SQL and Python skills required.
- Other info: Opportunity to influence foundational work in a new CDO function.
An opportunity to play a lead role in designing a centralised, standardised data model for one of the UK’s most recognisable insurance brands. This contract role sits within a wider enterprise data transformation programme, focused initially on building a group-wide data model for the ingestion and consumption of bordereaux files; replacing multiple inconsistent approaches across five business units with a single, scalable solution.
You’ll be responsible for designing and communicating the conceptual, logical and physical models that will underpin this new unified data capability. It’s a hands-on, highly collaborative role, requiring both technical expertise and stakeholder influence. As the programme evolves, there’s scope to move into broader modelling work supporting a new unified data platform.
The role:
- Analyse current-state ingestion processes (circa 15) and define a clean, centralised model
- Design and deliver fit-for-purpose conceptual, logical and physical data models
- Work with messy, inconsistent incoming data and translate it into structured designs
- Engage directly with technical teams, business units and external data providers
- Be a pragmatic voice in the room: challenge constructively, focus on what’s good enough vs shooting for perfect
What we’re looking for:
- 5+ years' experience in data modelling
- Strong grasp of Kimball or Inmon approaches
- Able to clearly communicate model logic and rationale to technical and non-technical audiences
- Hands-on skills with SQL, Python and common data modelling tools
- Experience designing models to support ingestion, integration or standardisation
- Strong documentation and stakeholder engagement skills
Desirable:
- Experience in insurance or financial services
- Exposure to cloud technologies (Azure or GCP)
- Familiarity with tools like Erwin
- Calm, pragmatic and outcome-focused attitude
This is a great opportunity to lead foundational work within a newly formed CDO function, where your decisions will have a lasting impact across the business.
Contact Detail:
SPG Resourcing Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeller
✨Tip Number 1
Familiarise yourself with the specific data modelling approaches mentioned in the job description, such as Kimball and Inmon. Being able to discuss these methodologies confidently during your interactions will demonstrate your expertise and alignment with our needs.
✨Tip Number 2
Prepare to showcase your hands-on experience with SQL and Python. Consider having examples ready that illustrate how you've used these skills in previous projects, especially in relation to data ingestion and integration.
✨Tip Number 3
Engage with our current data transformation initiatives by researching similar projects in the insurance sector. This will help you understand the challenges we face and allow you to contribute valuable insights during discussions.
✨Tip Number 4
Highlight your stakeholder engagement skills by preparing anecdotes that demonstrate your ability to communicate complex data concepts to both technical and non-technical audiences. This is crucial for the collaborative nature of the role.
We think you need these skills to ace Data Modeller
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your relevant experience in data modelling, particularly your familiarity with Kimball or Inmon approaches. Include specific examples of projects where you've designed conceptual, logical, and physical data models.
Craft a Strong Cover Letter: In your cover letter, emphasise your hands-on skills with SQL and Python, and how these have contributed to successful data modelling projects. Mention your ability to communicate complex model logic to both technical and non-technical audiences.
Showcase Stakeholder Engagement: Provide examples in your application that demonstrate your strong documentation and stakeholder engagement skills. Highlight instances where you’ve effectively collaborated with technical teams and business units.
Highlight Relevant Experience: If you have experience in the insurance or financial services sector, make sure to mention it. Also, if you have exposure to cloud technologies like Azure or GCP, include this information as it is desirable for the role.
How to prepare for a job interview at SPG Resourcing
✨Showcase Your Technical Skills
Be prepared to discuss your hands-on experience with SQL, Python, and data modelling tools. Bring examples of past projects where you successfully designed data models, especially those that involved ingestion and integration.
✨Understand the Business Context
Research the insurance industry and the specific company you're interviewing with. Understanding their business model and how data plays a role will help you tailor your responses and demonstrate your interest in the role.
✨Communicate Clearly
Practice explaining complex data concepts in simple terms. You’ll need to communicate effectively with both technical teams and non-technical stakeholders, so being able to articulate your thoughts clearly is crucial.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills. Be ready to discuss how you would approach messy, inconsistent data and what steps you would take to create a clean, centralised model.
