Senior Data Modeler: Insurance & Azure Analytics

Compunnel, Inc.; Mississauga; On-site; CAD 120,000 - 150,000; Full time

Job summary

Compunnel, Inc. is seeking an experienced Senior Data Modeler to design, develop, and maintain logical and physical data models supporting analytics, actuarial, underwriting, broker, and enterprise initiatives.

The role focuses on translating business requirements into scalable data structures and mappings within Azure Databricks and related data platforms. The ideal candidate has 12+ years in data modeling, hands-on experience with enterprise data models for data warehouses, data lakes,

Qualifications

• Minimum 12+ years of relevant experience.
• Strong expertise in conceptual, logical, and physical data modeling.
• Hands-on experience designing enterprise data models for data warehouses, data lakes, lakehouses, and reporting platforms.
• Advanced SQL skills.
• Recent insurance domain experience.
• Familiarity with Azure Data Platform (Databricks, Azure Data Lake, Synapse, Azure SQL).
• Proven experience as a Senior Data Modeler, Enterprise Data Modeler, Data Architect, or similar role.
• Strong knowledge of: data modeling, enterprise data modeling, dimensional modeling, star/snowflake schemas, keys, hierarchies, and slowly changing dimensions.

Responsibilities

• Design, develop, and maintain logical and physical data models for analytics, actuarial, underwriting, and reporting needs.
• Translate business requirements into scalable data structures.
• Define source-to-target mappings.
• Ensure models align with enterprise standards and governance frameworks.

Skills

Data modeling

SQL

Azure Databricks

Data warehouses

Dimensional modeling

Source-to-target mappings

Data governance

ETL/ELT

Data lineage

Partitioning/ indexing

Tools

Azure Data Platform

Databricks

Delta Lake

Azure Synapse

Azure SQL

Job description

Compunnel, Inc. is seeking an experienced Senior Data Modeler to design, develop, and maintain logical and physical data models supporting analytics, actuarial, underwriting, broker, and enterprise initiatives.

The role focuses on translating business requirements into scalable data structures and mappings within Azure Databricks and related data platforms. The ideal candidate has 12+ years in data modeling, hands-on experience with enterprise data models for data warehouses, data lakes,