Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and maintain enterprise-wide data models for analytics and compliance in the insurance sector.
- Company: Leading P&C insurance firm based in London with a focus on innovation.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Why this job: Shape the future of data architecture in a dynamic and impactful industry.
- Qualifications: 10+ years in data modelling with strong knowledge of insurance standards.
- Other info: Collaborative environment with a focus on cutting-edge technologies and career advancement.
The predicted salary is between 72000 - 108000 £ per year.
We are seeking an experienced Data Architect / Data Modeler with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves designing scalable, compliant, and high-quality data structures that support enterprise analytics, regulatory reporting, and operational data needs.
RESPONSIBILITIES:
- Design and maintain enterprise-wide data models (conceptual, logical, physical) to support analytics, operational reporting, regulatory compliance, and integration use cases.
- Own the design of canonical data models for delegated insurance covering Contract, Premium/Risk, and Claims, including full transaction and movement-based constructs (e.g. endorsements, cancellations, reinstatements, claim financial movements).
- Translate conceptual and logical models into implementation-ready artefacts including JSON/XML schemas and Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions.
- Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies.
- Create and manage metadata and modelling artefacts using Erwin with traceability and governance.
- Support Medallion Architecture (Bronze, Silver, Gold) across ingestion and curation layers.
- Collaborate with engineering teams to implement models on Databricks and Unity Catalog.
- Participate in governance forums to drive standardization across data domains.
- Conduct model reviews and solution walkthroughs for architectural alignment.
- Define and govern integration patterns for third-party datasets including geocoding, hazard, valuation, and reference data.
- Ensure compliance with GDPR, Solvency II, and Lloyd’s reporting and oversight requirements, compliance with MAR/SOX controls through documentation and validation processes when applicable.
- Interpret and apply ACORD and CSIO data standards for global and Canadian insurance data exchange.
- Align modelling standards with the GSI Data Target Operating Model (TOM) and Partner Management & Data Intake workstreams acting as the architectural authority for delegated data standards.
- Lead data modelling workshops and SME councils to drive stakeholder alignment.
- Provide architectural oversight during partner onboarding including mapping, validation, exception handling, and change control.
REQUIRED SKILLS & KNOWLEDGE:
- Industry Standards: Knowledge of ACORD (global, comprehensive insurance data standards).
- Knowledge of CSIO (Canadian insurance standards, including XML, EDI, and JSON formats).
- Tools & Platforms: Erwin Data Modeler – Mandatory; Familiarity with Medallion Data Architecture, Databricks & Unity Catalog, MAR/SOX data governance and regulatory frameworks, GDPR, Solvency II, and Lloyd’s reporting and oversight requirements.
- Modelling Techniques: Dimensional Modelling: Star and Snowflake schemas, Data Vault Modelling, Third Normal Form (3NF) relational modelling, JSON/XML schemas.
- Optional / Nice to Have: Experience with MDM / RDM (Master Data Management / Reference Data Management).
Data Architect / Data Modeler - P&C Insurance in City of London employer: ValueMomentum
Contact Detail:
ValueMomentum Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect / Data Modeler - P&C Insurance in City of London
✨Tip Number 1
Network like a pro! Get out there and connect with industry folks on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data models and projects. This is your chance to demonstrate your expertise in tools like Erwin and methodologies like Dimensional Modelling. Make it easy for potential employers to see what you can do!
✨Tip Number 3
Prepare for interviews by brushing up on industry standards like ACORD and CSIO. Be ready to discuss how you've applied these in your previous roles. Confidence in your knowledge will impress interviewers and show you're the right fit for the job.
✨Tip Number 4
Don't forget to apply through our website! We love seeing applications directly from candidates who are passionate about joining us. Tailor your application to highlight your experience with data architecture and compliance, and let’s get the conversation started!
We think you need these skills to ace Data Architect / Data Modeler - P&C Insurance in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Architect role. Highlight your experience with data modelling and insurance standards, and don’t forget to mention any hands-on work with tools like Erwin. We want to see how your skills match what we’re looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about data architecture in the insurance sector. Share specific examples of your past projects that align with our needs, and let us know why you want to join StudySmarter.
Showcase Relevant Projects: If you’ve worked on projects that involved data models or compliance with industry standards, make sure to showcase them. We love seeing real-world applications of your skills, so include details about your contributions and the impact they had.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it’s super easy to do!
How to prepare for a job interview at ValueMomentum
✨Know Your Data Standards
Make sure you brush up on ACORD and CSIO standards before the interview. Being able to discuss these frameworks confidently will show that you understand the insurance industry's data exchange requirements, which is crucial for the role.
✨Showcase Your Modelling Skills
Prepare to talk about your experience with different data modelling techniques like Dimensional Modelling, Data Vault, and 3NF. Bring examples of past projects where you've successfully implemented these methodologies, as this will demonstrate your hands-on expertise.
✨Familiarise Yourself with Tools
Since Erwin Data Modeler is mandatory for this position, make sure you're comfortable discussing how you've used it in previous roles. If you have experience with Databricks and Unity Catalog, be ready to share specific instances where you've applied these tools effectively.
✨Understand Compliance Requirements
Be prepared to discuss GDPR, Solvency II, and Lloyd’s reporting requirements. Showing that you can navigate these regulations and understand their implications on data architecture will set you apart as a candidate who can ensure compliance in your designs.