Data Modeler

Capgemini; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

Capgemini is seeking an IT Data Modeler to design, develop, and maintain enterprise data models supporting insurance operations, reporting, analytics, underwriting, claims, policy administration, and risk management.

The candidate should have 5+ years of data modeling experience, robust knowledge of relational databases, and 3+ years in Property & Casualty insurance data structures. Collaboration with cross-functional teams is essential.

Qualifications

• 5+ years of Data Modeling and Database Design experience.
• 3+ years of Property & Casualty Insurance domain experience.
• Strong knowledge of insurance business processes and enterprise data structures.

Responsibilities

• Design conceptual, logical, and physical data models.
• Create models for Policy, Claims, Billing, Customer, Broker, Risk, Coverage, and Reinsurance domains.
• Develop dimensional models for reporting and analytics.
• Maintain source-to-target mappings, metadata, and data dictionaries.
• Support database optimization, data quality, governance, audit, and compliance initiatives.
• Collaborate with Business, Architecture, Engineering, and Analytics teams.

Skills

Data Modeling

Relational Database Design

Insurance Domain Knowledge

Data Governance

Stakeholder Engagement

Tools

Azure Data Services

Data Warehousing

MDM

Job description

The IT Data Modeler is responsible for designing, developing, and maintaining enterprise data models that support insurance operations, reporting, analytics, underwriting, claims, policy administration, risk management, and regulatory reporting. The role requires strong expertise in insurance data concepts, relational database design, data modeling methodologies, and data governance practices.

A strong candidate will have 5+ years of Data Modeling experience, deep knowledge of relational databases and table design, and practical experience in the Property & Casualty Insurance industry including Policy, Claims, Underwriting, Risk, and Premium data structures.

Key Responsibilities

• Design conceptual, logical, and physical data models.
• Create models for Policy, Claims, Billing, Customer, Broker, Risk, Coverage, and Reinsurance domains.
• Develop dimensional models for reporting and analytics.
• Maintain source-to-target mappings, metadata, and data dictionaries.
• Support database optimization, data quality, governance, audit, and compliance initiatives.
• Collaborate with Business, Architecture, Engineering, and Analytics teams.

Required Qualifications

• 5+ years Data Modeling and Database Design experience.
• 3+ years Property & Casualty Insurance experience.
• Strong knowledge of insurance business processes and enterprise data structures.

Technical Skills

• Conceptual, Logical & Physical Data Modeling
• ER Modeling and Dimensional Modeling (Star/Snowflake)

Insurance Domain Knowledge

Policy Administration, Claims Management, Underwriting, Risk & Exposure, Premium & Billing, Coverage & Endorsements, Broker & Customer Data, Regulatory Reporting.

Preferred Qualifications

Azure Data Services knowledge, Data Warehousing/Data Lake experience, and familiarity with MDM and Data

Governance frameworks.

Insurance Business Acumen, Data Architecture, Database Optimization, Data Governance, Business Analysis,

Stakeholder Engagement, Communication, Strategic Thinking, and Delivery Focus."