Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and maintain data models for enterprise analytics and regulatory 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: Join a dynamic team and shape the future of data architecture in insurance.
- Qualifications: 10+ years in data architecture with strong knowledge of insurance standards.
- Other info: Collaborative environment with a focus on cutting-edge data technologies.
The predicted salary is between 48000 - 72000 £ per year.
LOCATION: London, UK (3 days/week onsite)
EXPERIENCE: 10+ Years
ROLE OVERVIEW: 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 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 London
✨Network Like a Pro
Get out there and connect with folks in the insurance and data architecture space. Attend industry meetups, webinars, or even local events. You never know who might have the inside scoop on job openings or can put in a good word for you!
✨Show Off Your Skills
When you get the chance to chat with potential employers, make sure to highlight your hands-on experience with data modelling tools and frameworks. Share specific examples of how you've designed scalable data structures that meet compliance needs – it’ll show you mean business!
✨Tailor Your Approach
Before any interview, do your homework! Research the company’s data practices and be ready to discuss how your experience aligns with their needs. This shows you’re genuinely interested and have done your due diligence.
✨Apply Through Us!
Don’t forget to check out our website for the latest job openings. Applying directly through us not only gives you a better chance but also keeps you in the loop about upcoming opportunities in the data architecture field!
We think you need these skills to ace Data Architect / Data Modeler - P&C Insurance in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Architect / Data Modeler role. Highlight your experience with data modelling practices and insurance industry standards, as these are key for us. Use specific examples that showcase your skills in designing scalable data structures.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data architecture and how your background aligns with our needs. Mention any hands-on experience with tools like Erwin and your familiarity with ACORD and CSIO standards to grab our attention.
Showcase Relevant Projects: Include any relevant projects or achievements in your application that demonstrate your expertise in data modelling and compliance with regulations like GDPR and Solvency II. We love seeing real-world applications of your skills!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining the StudySmarter team!
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 how these standards apply to your previous work will show that you’re not just familiar with them, but that you can also implement them effectively.
✨Showcase Your Modelling Skills
Prepare to talk about your experience with different data modelling techniques like Dimensional Modelling and Data Vault. Bring examples of your past projects where you’ve successfully designed scalable data structures, as this will demonstrate your hands-on expertise.
✨Familiarise Yourself with Tools
Since Erwin Data Modeler is a must-have for this role, make sure you’re comfortable discussing your experience with it. If you’ve used Databricks or Unity Catalog, be ready to explain how you’ve leveraged these tools in your previous roles.
✨Understand Compliance Requirements
Be prepared to discuss GDPR, Solvency II, and Lloyd’s reporting requirements. Showing that you understand these regulations and how they impact data architecture will set you apart as a candidate who can navigate the complexities of the insurance industry.