We are seeking an experienced Data Modeler / Architect with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. • The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. • This role involves designing scalable, compliant, and high-quality data structures that support enterprise analytics, regulatory reporting, and operational data needs. Design and maintain enterprise-wide data models (conceptual, logical, physical) to support analytics, operational reporting, regulatory compliance, and integration use cases. • Own the design of canonical data models for delegated insurance covering Contract, Premium/Risk, and Claims, including full transaction and movement-based constructs (e.g. endorsements, cancellations, reinstatements, claim financial movements. • Translate conceptual and logical models into implementation-ready artefacts including JSON/XML schemas and Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions • Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. • Participate in governance forums to drive standardization across data domains. • Define and govern integration patterns for third-party datasets including geocoding, hazard, valuation, and reference data. • Interpret and apply ACORD and CSIO data standards for global and Canadian insurance data exchange. • Align modelling standards with the GSI Data Target Operating Model (TOM) and Partner Management & Data Intake workstreams acting as the architectural authority for delegated data standards. • Lead data modelling workshops and SME councils to drive stakeholder alignment. • Knowledge of ACORD (global, comprehensive insurance data standards). • Knowledge of CSIO (Canadian insurance standards, including XML, EDI, and JSON formats). Erwin Data Modeler – Mandatory • Medallion Data Architecture • MAR/SOX data governance and regulatory frameworks • Data Vault Modelling • JSON/XML schemas. Experience with MDM / RDM (Master Data Management / Reference Data Management)
