Data Modeler

Millennium Software and Staffing Inc; Toronto; Hybrid; CAD 95,000 - 125,000; Full time

Job summary

Millennium Software Inc. in Toronto, Ontario, is seeking an experienced Snowflake Data Modeler for a 12-month contract with possible contract-to-hire after 90 days.

The role focuses on designing, developing, and maintaining enterprise data models for insurance operations, with emphasis on Snowflake schemas and data governance. A candidate will have 5+ years of data modelling and 3+ years in Property & Casualty insurance.

Qualifications

• 5+ years data modelling and database design experience.
• 3+ years Property & Casualty Insurance experience.
• Strong knowledge of insurance business processes and data structures.

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 data governance, quality, audit, and compliance initiatives.
• Collaborate with Business, Architecture, Engineering, and Analytics teams.

Skills

Data Modelling

Relational Databases

Snowflake

SQL

Analytical Thinking

Stakeholder Management

Communication

Tools

Azure Data Services

Job description

Toronto Canada Hybrid.

Job Title

Snowflake Data Modeler

Duration

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

Job Description

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.
• Strong knowledge of insurance business processes and enterprise data structures.

Technical Skills

• Conceptual, Logical & Physical Data Modelling
• ER Modelling and Dimensional Modelling (Star/Snowflake)

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,

Preferred Qualifications

• Azure Data Services knowledge, Data Warehousing/Data Lake experience, and familiarity with MDM and Data Governance frameworks.
• Insurance Business Acumen, Data Architecture, Database Optimization, Data Governance, Business Analysis, Stakeholder Engagement, Communication, Strategic Thinking, and Delivery Focus.

Employers

Millennium Software Inc.