How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Modeler – Property Casualty Specialty Insurance
Location: London
Domain: Property Casualty Specialty Insurance data projects
About the Role
We are seeking an experienced Data Modeler with 10+ years of hands-on experience in designing both logical and physical data models for Property Casualty Specialty Insurance data projects.
Working Arrangement: Hybrid Model
This role will involve a flexible hybrid approach, blending:
- Company offices
- Client sites
- Home working (though not 100% remote)
Key Responsibilities
- Develop and maintain logical and physical data models to support business requirements, ensuring data integrity across insurance domains
- Align models with Databricks medallion architecture, translating needs from underwriting, delegated authority, reinsurance, actuarial, claims, and finance into structured models
- Implement and maintain data governance standards, including naming conventions, metadata, and documentation, collaborating with data analysts, data engineers, and data associates
- Review existing models and propose simplification, standardisation, and improvements for current and future projects
- Lead the evolution of requirements, refining and translating them into actionable data models for development teams
- Ensure models accurately reflect insurance processes and data elements before handover to engineering
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Requirements & Experience
- 10+ years delivering data models for Property Casualty (PC) Specialty Insurance projects, with exposure to Lloyd’s London Market data structures
- In-depth understanding of insurance domain concepts, proficiency in data modelling tools (preferably Erwin)
- Expertise in enterprise data modelling, including:
- Conceptual, logical, and physical models
- Transactional data domains
- Experience with dimensional, Star, Snowflake, Data Vault, and 3NF methodologies
- Knowledge of data warehousing and ETL/ELT pipelines
- Familiarity with Azure Data Factory, Databricks, and pipeline design is advantageous
- Understanding of system development life cycle (SDLC) methodologies, including Agile software development
- Strong collaboration and communication skills to engage with senior leaders, stakeholders, and technical teams
- Flexibility, curiosity, and creative problem-solving mindset
Company Commitments
Disability Confident Employer
Capgemini is a Disability Confident (Level 2) employer. We guarantee an interview to: ✔ Candidates who declare a disability ✔ Those meeting the minimum essential criteria
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Make It Real – Employee Wellbeing & Growth
- Join an accredited ‘Great Place to Work’ (2024 Wellbeing credentials)
- Dedicated resources for mental health support (e.g., Mental Health Champions, Thrive/Peppy wellbeing apps)
- Continuous learning:
- Access to 250,000+ courses (AWS, Microsoft, Harvard ManageMentor, cybersecurity certifications)
- Thinkthank events, hackathons, innovation labs
- Ethics & sustainability: Capgemini is listed as a World’s Most Ethical Company® (Ethisphere®, 13 consecutive years)
Why Capgemini?
Transforming Industries with Technology
- Part of a global 420,000-strong team delivering end-to-end business & technology transformation
- AI-powered solutions for clients driving sustainability & inclusion
- A space for free-thinkers, entrepreneurs, and industry experts to innovate
- Build skills that shape careers and push boundaries
“Making the world a better place rarely is easy—and neither are we.”
About Capgemini
A responsible, inclusive global leader with €22.1B (2024) in global revenue, transforming industries through strategy, AI, design, engineering, and operations. Dedicated to helping clients leverage technology for growth.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location