Data Modeler

Role: Data Modeler Location: Toronto, ON Employment Type: Fulltime 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 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."

The Data Modeler designs and maintains enterprise data models supporting various insurance operations and regulatory reporting. They are responsible for creating conceptual, logical, and physical models across domains like Policy, Claims, and Underwriting.

Candidates need over 5 years of data modeling experience and at least 3 years within the Property & Casualty Insurance industry. Proficiency in relational database design and tools like ER/Studio or PowerDesigner is required.

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Dimensional Modeling
• Snowflake
• ER Modeling
• Data Governance
• Metadata Management
• ER/Studio
• PowerDesigner
• Visio
• Property & Casualty Insurance
• Database Design
• Normalization
• Denormalization
• Data Quality

• Data & Analytics
• Technology
• Finance & Accounting
• Software
• Consulting

Expérience minimale

5+ ans

Postuler avant le

24 sept. 2026

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte