Role description

Role Data Modeller Policy Claim

Location Mississauga Ontario Onsite

Primary Skill

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 regulator reporting The role requires strong expertise in insurance data concepts relational database design data modelling methodologies and data governance practices

Policy Administration Claims Management Underwriting Risk Exposure Premium Billing Coverage

Endorsements Broker Customer Data Regulatory Reporting

Experience in Years 5 years

Must Have Skills

Conceptual Logical Physical Data Modeling

ER Modeling and Dimensional Modeling StarSnowflake

Snowflake Database Design Normalization Denormalization

Data Governance Metadata Management Data Quality

ERStudio PowerDesigner Visio

Secondary Nice To Have Skills NOT MANDATORY

Policy Claims Billing Customer Broker Risk Coverage and Reinsurance domains

Soft Skills

Strong analytical thinking stakeholder management communication problem solving collaboration documentationand Agile delivery experience

3 Qualifying Questions

1Design conceptual logical and physical data models

2 Create models for Policy Claims Billing Customer Broker Risk Coverage and Reinsurance domains

3 Develop dimensional models for reporting and analytics

4 Maintain sourcetotarget mappings metadata and data dictionaries

5 Support database optimization data quality governance audit and compliance initiatives

6 Collaborate with Business Architecture Engineering and Analytics teams