Senior Data Modeler: Insurance & Azure Analytics

Compunnel Inc.

Mississauga

On-site

CAD 120,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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

JOB SUMMARY
We are seeking an experienced Senior Data Modeler with strong expertise in enterprise data modeling and insurance domain data. The successful candidate will design, develop, and maintain logical and physical data models that support analytics, reporting, actuarial, underwriting, broker, and enterprise data initiatives. The role requires close collaboration with business analysts, data analysts, data engineers, architects, actuaries, underwriters, and reporting teams. The ideal candidate will be skilled at translating business requirements into scalable data structures, defining source-to-target mappings, and ensuring that data models align with enterprise standards, governance frameworks, and reporting needs. Experience with insurance, underwriting, or broker data, along with familiarity with Databricks and Azure data platforms, is highly desirable.

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

Required Qualifications
Minimum 12+ years of relevant experience.
Strong expertise in conceptual, logical, and physical data modelling.
Hands-on experience designing enterprise data models for data warehouses, data lakes, lakehouses, and reporting platforms.
Advanced SQL skills.
Recent insurance domain experience.
Good knowledge of Actuarial data models.
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: Conceptual, logical, and physical data modeling, Enterprise data modeling, Dimensional modeling, Star and snowflake schemas, Fact and dimension design, Data grain and aggregation, Primary and foreign keys, Relationships, hierarchies, and slowly changing dimensions, Normalization and denormalization, Reference and master data modeling.
Experience designing models for data warehouses, data marts, data lakes, lakehouses, and reporting platforms.
Strong understanding of analytical and operational data structures.
Ability to design scalable models that support reporting, analytics, actuarial analysis, and downstream data products.
Experience defining reusable enterprise entities and canonical data structures.
Strong SQL skills, including data investigation, profiling, validation, joins, aggregations, and relationship analysis.
Experience creating detailed source-to-target mappings and transformation specifications.
Familiarity with ETL/ELT processes, data integration patterns, and pipeline dependencies.
Experience with relational databases, data warehouses, and cloud data platforms.
Familiarity with Databricks, Delta Lake, Azure Data Lake, Azure Synapse, Azure SQL, or related Azure data services.
Understanding of performance considerations for large-scale data models, including partitioning, indexing, clustering, distribution, and query optimization.
Experience working with structured and semi-structured data.
Understanding of data lineage, metadata repositories, data catalogs, and data dictionaries.
Experience with metadata management and data governance frameworks.
Knowledge of: Business and technical metadata, Data lineage, Data dictionaries, Data ownership and stewardship, Data quality rules, Critical data elements, Data classification, Data standards and naming conventions.
Ability to align data models with enterprise governance, security, privacy, and compliance requirements.
Experience supporting consistent definitions and governed reporting across business functions.

Preferred Qualifications
Experience working in the insurance industry, particularly in areas such as: Underwriting, Broking, Policy administration, Premium and commission processing, Claims, Risk and exposure, Actuarial reporting, Portfolio and performance analysis.
Strong understanding of insurance data entities and relationships, including policies, risks, insured parties, brokers, submissions, quotes, bound business, premiums, claims, exposures, and financial transactions.
Ability to model complex insurance and underwriting business processes.
Familiarity with insurance data definitions, reporting requirements, business rules, and key performance measures.
Experience supporting actuarial, underwriting, broker, finance, or regulatory reporting is advantageous.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Modeler
Senior Data Modeler

Compunnel Inc. • Mississauga

On-site
CAD 120,000 - 150,000
Data Modeler – Insurance ,ACORD
Data Modeler – Insurance ,ACORD

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 130,000
Business System Analyst
Business System Analyst

Compunnel Inc. • Mississauga

On-site
CAD 110,000 - 140,000
Senior Data Modeler/Analyst
Senior Data Modeler/Analyst

EPAM Systems • Canada

Hybrid
CAD 90,000 - 130,000
Full Stack Data Engineer
Full Stack Data Engineer

Manulife John Hancock • Toronto

On-site
CAD 110,000 - 150,000
Senior Data Analyst – Capital Markets & Azure Databricks
Senior Data Analyst – Capital Markets & Azure Databricks

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
Lead Data Analyst
Lead Data Analyst

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
Data Management Business Analyst
Data Management Business Analyst

Maarut Inc • Montreal

On-site
CAD 90,000 - 130,000
Insurance domain knowledge
DevOps exposure
Power BI experience
Azure Databricks Data Architect
Azure Databricks Data Architect

N2P Systems • Toronto

On-site
CAD 180,000 - 230,000
Lead Data Modeler (10+ years) to design enterprise-level data models using conceptual and logical data modelling for capital management 59040
Lead Data Modeler (10+ years) to design enterprise-level data models using conceptual and logical data modelling for capital management 59040

S I Systems • Toronto

Hybrid
CAD 120,000 - 180,000