> Markdown version of [/jobs/ext/1163689-lead-data-modeller](https://www.wearedevelopers.com/jobs/ext/1163689-lead-data-modeller). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Modeller

- **Company:** Capgemini
- **Location:** London, UK (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** 3d Models, Third Normal Form, Agile Methodology, Data Integrity, Data Structures, Data Vault Modeling, Data Warehousing, Systems Development Life Cycle, Enterprise Data Management, Azure Data Factory, Snowflake, Data Pipelines, Databricks
- **Published:** July 3, 2026
- **Apply:** https://uk.indeed.com/viewjob?jk=ebeb846836fa9231

## About the Role

* Experience delivering data models for PC Specialty insurance projects with exposure to Lloyds London Market and Syndicate data structures is required
 * Understanding of insurance domain concepts and proficiency with data modelling toolset Erwin
 * Expertise in enterprise data modelling including conceptual logical and physical models for transactional domains
 * Experience in data modelling using Dimensional Star Snowflake Data Vault and 3NF methodologies
 * Knowledge of data warehousing and ETLELT pipelines
 * Experience with Azure Data Factory and Databricks designing data pipelines can be advantageous
 * Understanding and knowledge of system development life cycle methodologies such as agile software development
 * Excellent collaboration and communications skills to deal with senior leaders stakeholders and technical teams is required
Flexibility and bringing a curious and creative mindset open to new things and able to propose innovative ideas

## Description

We are seeking an experienced data modeler with 10 years Handson experience designing logical and physical models for Property Casualty Specialty Insurance data projects
Hybrid working:
The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time., * Develop and maintain data models Logical and Physical to support business needs ensuring data integrity for Insurance domains

 * Design models aligned to Databricks medallion architecture by translating the requirements of underwriting delegated authority reinsurance actuarial claims and finance
 * Implement and maintain modelling standards naming conventions metadata and documentation working closely with data analyst data engineers and associate's in data office
 * Review existing models and propose simplification standardisation and target state improvements across projects and for wider requirements
 * Lead the evolution of requirements refine and translate the specifications into data models to enable development phase
 * Ensure the models accurately reflect Insurance processes and data elements before handing it over to engineering


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [TresJS a new declarative ThreeJS as Vue components](https://www.wearedevelopers.com/videos/543-tresjs-a-new-declarative-threejs-as-vue-components)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [From A2A to MCP: How AI’s “Brains” are Connecting to “Arms and Legs”](https://www.wearedevelopers.com/videos/1631-from-a2a-to-mcp-how-ai-s-brains-are-connecting-to-arms-and-legs)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)