Specialist - Data Engineering

Role Data Modeller Policy Claim Location Mississauga Ontario On-site 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 Star Snowflake Snowflake Database Design Normalization Denormalization Data Governance Metadata Management Data Quality ERStudio Power Designer 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

Mandatory Skills : MS SQL Server