Hello ,

We have the following openings at Toronto Canada Hybrid. Kindly send your updated resume if interested at [email protected] and you may reach out to me at (phone hidden).

Job Title

Snowflake Data Modeler

Location

Toronto Canada Hybrid

Duration

12 months and possible Contract-To-Hire any time after 90 days

: CGEMJP00352281 - Data Modeler - Toronto, Canada Hybrid

:

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 modelling methodologies, and data governance practices.

A strong candidate will have 5+ years of Data Modelling 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 Modelling and Database Design experience.
- 3+ years Property & Casualty Insurance experience.
- Solid knowledge of insurance business processes and enterprise data structures.

Technical Skills

- Conceptual, Logical & Physical Data Modelling
- ER Modelling and Dimensional Modelling (Star/Snowflake)
- Snowflake, Database Design, Normalization, Denormalization
- Data Governance, Metadata Management, Data Quality
- ER/Studio, Power Designer, 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 Page 2

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.

Regards,

Manish Jakhar

Millennium Software Inc.

Cell: (phone hidden)

2000 Town Center, Suite 300, Southfield, MI, 48075

Visit us at www.webmsi.com

📌 Data Modeler (Toronto)
🏢 Millennium Software and Staffing
📍 Toronto