CareerPlan

Lead Data Designer

Markham, CAFull-time2026-10-09 → 2026-11-10

Core

Lead enterprise data design, modeling, and governance to enable trusted, secure, and reusable data across analytics, AI, and digital solutions for an insurance company.

Role type

Senior IC Lead Data Designer

Builds

Enterprise data models, semantic layers, data contracts, and AI-ready datasets

Domain

Insurance (Property & Casualty) + Data Engineering & Governance

Deliverable

production ML models

Required skills

Enterprise data modeling, data governance, SQL, ETL/ELT, data quality, metadata management, data security, ACORD standards, cloud data platforms

Preferred skills

Snowflake, AWS data services, dbt, Airflow, SAP PowerDesigner, ERwin, vector/embedding structures

Technologies

Snowflake, AWS, PostgreSQL, Hadoop, Informatica, dbt, Airflow, AWS Glue, SAP PowerDesigner, ERwin

Responsibilities

Own and govern data models for assigned domains; Partner with business experts to define key business concepts and domain boundaries; Lead data design across operational stores, warehouses, and data lakes; Govern data modeling standards and maintain data contracts; Define canonical structures for migration and modernization; Embed privacy and security by design; Design governed datasets and semantic layers for AI use cases; Review and approve data models and schemas; Manage model lifecycle including versioning and observability; Guide and coach data, analytics, and engineering teams

Seniority

Senior, hands-on IC