Data Modeler – P&C

SCOR; Zürich; On-site; CHF 110,000 - 150,000; Full time

Job summary

SCOR is seeking a Data Modeler for the P&C domain to join our Tech, Data & AI team. The role combines data modeling with knowledge of (re)insurance processes and requires translating requirements into scalable data models across systems.

You will design, build, and maintain models within Databricks and Palantir Foundry, ensuring consistency, traceability, and alignment with enterprise standards to support reporting, planning, and decision-making.

Qualifications

• Experience in data modeling or data engineering.
• Experience building analytical data models for reporting and analytics.
• Proficiency in SQL and PySpark.
• Experience in the insurance industry or financial services is a strong plus.
• Experience with Databricks and Palantir Foundry is a plus.
• Understanding of data governance, metadata management, and data quality principles.

Responsibilities

• Design, build, and maintain conceptual, logical, and physical data models for P&C within the Data Foundation (Databricks & Palantir Foundry), supporting reinsurance processes such as underwriting, pricing, claims.
• Develop and evolve analytical data models that enable scalable reporting, self-service analytics, and AI-driven use cases.
• Contribute to the enterprise P&C data model, ensuring consistent business definitions and alignment across domains and systems.
• Collaborate with Data Engineers, Architects, and P&C stakeholders to ensure models reflect business semantics and integrate into the overall data architecture.
• Ensure data consistency, reconciliation capability, and proper handling of granularity, time dimensions, and historical tracking in financial datasets.
• Support metadata management, business glossaries, and data lineage in collaboration with data stewards to provide transparent and governed P&C data.
• Apply and promote data modeling standards and best practices to improve quality, reusability, and maintainability of P&C data assets

Skills

Data modeling

Data engineering

SQL

PySpark

Databricks

Palantir Foundry

Analytical thinking

Collaboration

Tools

Databricks

Palantir Foundry

SQL

PySpark

Job description

We are seeking a Data Modeler for the P&C domain to join our Tech, Data & AI team. The successful candidate combines data modeling skills with a good understanding of (re)insurance processes. You bring the ability to translate functional requirements into structured, scalable, and business-aligned data models.

This position goes beyond pure technical modeling: it requires ownership of how (re)insuance data is represented across systems, ensuring consistency, traceability, and alignment with enterprise standards to support reporting, closing, planning, and decision-making.

Responsibilities

K ey duties and responsibilities

Under the responsibility of the P&C Lead Data Engineer, your mission will be to:

Design, build, and maintain conceptual, logical, and physical data models for P&C within the Data Foundation (Databricks & Palantir Foundry), supporting reinsurance processes such as underwriting, pricing, claims.

Develop and evolve analytical data models that enable scalable reporting, self-service analytics, and AI-driven use cases.

Contribute to the enterprise P&C data model, ensuring consistent business definitions and alignment across domains and systems

Collaborate with Data Engineers, Architects, and P&C stakeholders to ensure models reflect business semantics and integrate into the overall data architecture.

Ensure data consistency, reconciliation capability, and proper handling of granularity, time dimensions, and historical tracking in financial datasets.

Support metadata management, business glossaries, and data lineage in collaboration with data stewards to provide transparent and governed P&C data.

Apply and promote data modeling standards and best practices to improve quality, reusability, and maintainability of P&C data assets

Qualifications

Required experience & competencies

Experience in data modeling or data engineering, with a focus on understanding conceptual, logical, and physical models.

Experience building analytical data models for reporting and analytics.

Proficiency in SQL and/or PySpark, with understanding of modern data platform architectures.

Experience in the insurance industry or in financial services is a strong plus.

Experience with Databricks and/or Palantir Foundry is a plus.

Understanding of data governance, metadata management, and data quality principles.

Strong analytical thinking, attention to detail, and ability to structure complex topics.

Ability to collaborate effectively with both technical and business stakeholders.

Excellent communication skills and ability to operate in an international, matrix environment.

About Us

As a leading global reinsurer, SCOR offers its clients a diversified and innovative range of reinsurance and insurance solutions and services to control and manage risk. Applying "The Art & Science of Risk", SCOR uses its industry-recognized expertise and cutting-edge financial solutions to serve its clients and contribute to the welfare and resilience of society in around 160 countries worldwide.

Working at SCOR means engaging with some of the best minds in the industry - actuaries, data scientists, underwriters, risk modelers, engineers, and many others - as we work together to find solutions to pressing challenges facing societies.

As an international company, our common culture is defined by "The SCOR Way". Serving both to build momentum that drives the Group forward and as a compass to guide our actions and choices, The SCOR Way is anchored by five core values, reflecting the input of employees at all levels of the Group. We care about clients, people, and societies. We perform with integrity. We act with courage. We encourage open minds. And we thrive through collaboration.

SCOR supports inclusion and the diversity of talents, and all positions are open to people with disabilities.