Data Modeler
The IT 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 Risk.
- Hybrid
- Toronto, ON
- Posted Aug 6, 2026
- Apply by Sep 5, 2026
- 1 position
Job summary
IT Data Modeler Toronto- Hybrid Contract 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. 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 Soft Skills Strong analytical thinking Stakeholder management Communication Problem solving Collaboration Documentation Agile delivery experience Preferred Qualifications Azure Data Services knowledge Data Warehousing/Data Lake experience 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 Delivery Focus
What you’ll do
The IT 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 Risk.
Requirements
Candidates need over 5 years of data modeling experience and at least 3 years within the Property & Casualty Insurance industry. Proficiency in tools like ER/Studio or PowerDesigner and knowledge of dimensional modeling is required.
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- Dimensional Modeling
- Snowflake
- ER/Studio
- PowerDesigner
- Data Governance
- Property & Casualty Insurance
- Metadata Management
- Database Design
- Normalization
- Denormalization
- Azure Data Services
- Data Warehousing
- Agile Delivery
Job areas
- Data & Analytics
- Technology
- Engineering
- Consulting
- Finance & Accounting
Additional details
- Minimum experience
- 5+ years
- Apply by
- Sep 5, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available