Title: Senior Data Modeler (Insurance / Reinsurance/Underwriting/Broker Reporting)

Duration: 12+ Months Contract

Location: Mississauga, ON

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 model 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 Skills and Experience

Data Modeling Skills

- 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.
- Robust 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.

Technical Skills

- 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.

Domain Experience preffered

- 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.

Metadata and Data Governance

- 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.

Regards

Surbhi Chandan

M (phone hidden)

[email protected]

📌 Senior Data Modeler (Mississauga)
🏢 Precision Technologies
📍 Mississauga