How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Modeler
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 designing logical and physical models for Property Casualty Specialty Insurance data projects.
Hybrid Working Arrangement
Our flexible approach means your working location will vary, blending company offices, client sites, and home—while ensuring less than 100% full-time remote work.
Key Responsibilities
- Develop and maintain logical and physical data models aligned with business needs, ensuring data integrity for Insurance domains
- Design models based on Databricks Medallion architecture, translating requirements from:
- Underwriting
- Delegated authority
- Reinsurance
- Actuarial claims
- Finance
- Implement and uphold modeling standards, naming conventions, metadata, and documentation, collaborating closely with data analysts, data engineers, and data office associates
- Review existing models and propose simplification, standardization, and target state improvements across projects and for broader requirements
- Lead the evolution of requirements, refining and translating specifications into actionable data models for the development phase
- Ensure models accurately reflect Insurance processes and data elements before handoff to engineering teams
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 & Expertise
- Hands-on experience in delivering data models for PC (Property & Casualty) Specialty Insurance projects, including exposure to Lloyd’s London Market and Syndicate data structures
- Strong understanding of insurance domain concepts and proficiency with data modelling tools—particularly Erwin
- Expertise in:
- Enterprise data modelling (conceptual, logical, and physical models)
- Transactional domains with methodologies:
- Dimensional
- Star Schema
- Snowflake Schema
- Data Vault
- 3rd Normal Form (3NF)
- Experience with:
- ETL/ELT pipelines
- Data warehousing
- Advantageous skills:
- Experience with Azure Data Factory and Databricks for designing data pipelines
Technical & Methodological Skills
- Able to apply SDLC methodologies, including Agile software development lifecycles
- Proficient in collaboration and stakeholder communication with senior leaders, technical teams, and cross-functional partners
Mindset & Soft Skills
- Flexibility, curiosity, and creativity with an openness to innovative ideas
- Ability to lead change and drive model simplification for broader business impact
Why Join Capgemini?
Capgemini is proud to be a Disability Confident Employer (Level 2). We commit to offering interviews to all candidates who declare they have a disability and meet the minimum essential criteria.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Employee Wellbeing & Growth
- work at Capgemini’s 2024 "Great Place to Work for Wellbeing" accreditation
- Access to mental health support champions, Thrive and Peppy wellbeing apps, and tailored health programs
- Join a culture where you’re empowered to innovate, upskill, and progress
- Unlimited learning opportunities with 250,000+ courses—including certifications from AWS, Microsoft, Harvard ManageMentor, and cybersecurity
- Ranked a World’s Most Ethical Company® for 13 consecutive years
Transformation & Career Impact
- Work at the forefront of sustainable business transformation while driving client growth through technology
- Collaborate with a global team of 420,000+ experts across 50 countries
- Make meaningful technical and ethical contributions while shaping industries and careers
About Capgemini
A near 60-year veteran in business and technology transformation, Capgemini partners globally to help clients leverage AI, cloud, and digital innovation. With €22.1 billion in 2024 revenues, Capgemini delivers end-to-end solutions spanning strategy, engineering, and business operations—powers the world’s leading companies to thrive ethically.
Visit Capgemini | Making the future real
“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