Role Name: Data Modeler
Location: Toronto, ON
Position Summary
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)
Snowflake, Database Design, Normalization, Denormalization
Data Governance, Metadata Management, Data Quality
ER/Studio, PowerDesigner, Visio
Insurance Domain Knowledge
Policy Administration, Claims Management, Underwriting, Risk & Exposure, Premium & Billing, Coverage & Endorsements, Broker & Customer Data, Regulatory Reporting.
IT Data Modeler - Insurance Domain
Soft Skills
Strong analytical thinking, stakeholder management, communication, problem solving, collaboration, documentation, and Agile delivery experience.
Preferred Qualifications
Azure Data Services knowledge, Data Warehousing/Data Lake experience, and familiarity with MDM and Data Governance frameworks.
Key Competencies
Insurance Business Acumen, Data Architecture, Database Optimization, Data Governance, Business Analysis,
Stakeholder Engagement, Communication, Strategic Thinking, and Delivery Focus.