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 solid 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.
Robust 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
Solid 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

📌 Data Modeler Toronto
🏢 Epsilon Solutions
📍 Toronto