Senior Data Modeler: Insurance & Azure Analytics
Compunnel Inc.
JOB SUMMARYWe 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 ResponsibilitiesDesign, 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 QualificationsMinimum 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 QualificationsExperience 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.
#J-18808-Ljbffr
Key ResponsibilitiesDesign, 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 QualificationsMinimum 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 QualificationsExperience 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.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Senior Data Modeler: Insurance & Azure Analytics in Winnipeg, MB vacancy
- About the Role Our client, a forward-thinking insurance technology firm, is seeking a Senior Data Scientist with specialized expertise in insurance analytics. This is a fully remote role, offering significant flexibility and the opportunity to work with advanced data tools...SeniorRemote work
- A leading consulting firm in Toronto is seeking a Senior Data Architect/Modeller to manage technical architecture across platforms. The ideal candidate will have extensive experience with Mulesoft and Azure, strong knowledge of cloud security principles, and the ability to effectively...Senior
- Transform reporting requirements into scalable analytics solutions at Synechron, combining Cube Dev, Power BI, Snowflake, SQL, and GraphQL... ...translate business needs into reports, dashboards, semantic models, and data pipelines. Responsibilities span data quality, security,...Suggested
- Shape actionable insights through data modeling, dashboard optimization, and analytics as a Data Developer III at Walmart in Mississauga.This position translates business needs into high-quality analytical outcomes and scalable data structures. You will support problem formulation...Suggested
- ZoomInfo, a leading Go-To-Market Intelligence Platform, is seeking a Senior Analytics Engineer to advance the maturity of our data organization. You will design, build, and own core data models and pipelines powering reports, BI, product analytics, and operational decision-making...Senior
$91.33k - $114k per year
...KF Aerospace in Kelowna, BC, is seeking a Data Engineer to design, develop, and modernize... ...enterprise data platform using Microsoft Fabric, Azure, SQL Server, and Power BI. You will build... ..., and developers in a growing cloud analytics environment. This full-time role offers...SeniorFull time- ...Solutions, a national IT consulting firm, is recruiting experienced Senior Data Modellers to support Government of Canada IT consulting engagements... ...analysts, and application development teams. Strong analytical, problem-solving, communication, and technical documentation...SeniorRemote work
- Placements24 is seeking a Senior Data Scientist with expertise in insurance analytics to work remotely. You will develop predictive models for pricing, risk, churn, and fraud, and lead cross-functional analytics projects with actuaries, underwriters, and product managers. You...SeniorRemote work
$96.9k - $136.8k per year
...details for this role. Job DescriptionThe Model Validation (MV) group in Enterprise Risk, Risk... ...the independent validation and approval of all analytical models used for TD. The position reports to Senior Manager, Insurance Model Validation. Detailed accountabilities include...SeniorWork from home- Turn complex insurance data into action with Aviva Canada’s Pricing and Analytics teams. Use programming, critical thinking, and actuarial analysis in a hybrid flexible model.As a Senior Actuarial Analyst, you will uncover opportunities, test new ideas, and improve pricing...SeniorFlexible hours
$125k - $140k per year
...clients is building a world-class data organization that leverages... ...consume data. We are seeking a Senior Business Analyst to support... ...help establish scalable data models supporting multiple asset... ...solutions Experience with AWS, Azure, or Google Cloud platforms Knowledge...SeniorLong term contractTemporary workWork at officeLocal areaRemote work- ...Financial Group in Canada is seeking a Data Scientist to turn data into practical... ...statistical and machine learning models, work with Databricks, Azure ML and Python, and collaborate with business... ...to translate needs into actionable analytics. You will own end-to-end model...
- Senior Azure Data Engineer5 days ago Be among the first 25 applicants Job Description Pipeline Development: Design, build, and maintain... ...frameworks that accelerate data product creation. Data Modelling: Develop and optimize semantic models, star schemas, and data...SeniorFull time
- Lead strategic modeling and forecasting from Canada, connecting financial... ...capacity through advanced analytics. Build predictive insights for critical decisions.This senior manager will establish and lead... ...commercial assumptions, operational data, recruitment, training, and...SeniorLong term contract
- Senior Data Architect / Data ModellerPosition OverviewSeeking a Senior Data Architect / Data Modeller with 8+ years of experience analyzing business requirements, evaluating existing data... ...Familiarity with Parquet, Delta Lake, Azure Data Lakehouse, star schema, and Snowflake...Senior
- Insurance risk modelling and machine learning are central to this Senior Actuarial Advisor opportunity with Desjardins. Analyze complex datasets for strategic decisions.Within... ..., geospatial, climatological, and insurance data to address individual and portfolio risk modelling...SeniorPrice work
- ...servicing, securitization, mortgage analytics, and market intelligence. Backed... ...ll own the Commercial Analytics data platform in Microsoft Fabric — how data is ingested, modeled, secured and served across our... ...and reporting, help migrate Azure Data Factory pipelines and legacy...SeniorLong term contractInternship
$55.5k - $120k per year
...2026Address: 250 Yonge StreetJob Family Group: Data Analytics & Reporting#bmoinsuranceWe are seeking a... ...BI, including DAX, Power Query, data modeling, dashboards, and data visualization .... ...platform, would be considered an asset.Insurance industry knowledge or experience would be...Part time- Design Azure data architectures and optimize PySpark systems as a Senior Data Engineer with ARC’TERYX in North Vancouver or remotely.This senior position supports the Supply Chain Analytics Squad and its data-informed decision-making. You will build scalable pipelines, translate...SeniorRemote work
- Lead Azure data engineering in Toronto with Python expertise and AI automation skills at JLL’... ...solutions for real estate technology.As a Senior Data Engineer, you will provide technical... ...across advanced data processing and analytics. You will architect Azure solutions, develop...Senior
$137k - $205k per year
...your team for events or meetings. Join our team...GoDaddy is a data-driven company dedicated to empowering entrepreneurs worldwide. We are seeking a Senior Manager, Business Analytics, Strategic Modeling to lead Strategic Modeling within Care Commercial Success. In this...SeniorLong term contractFull timeSecond jobWork at officeLocal areaRemote workWork from homeWorldwide- ...risk really works-and happiest when your models change how decisions get made? Then... ...the place for you! We're looking for a Senior Risk Modelling & Analytics Manager to be part of our Analytics... ...decision support function that connects data, business insights, and our internal tech...SeniorLocal areaWork from home
$80 per hour
SENIOR DATA ANALYTICAL SPECIALIST/SCIENTIST (Azure ML; Enterprise AI & Data Centre of Excellence) Requisition #: R26-3630 (RQ00242)Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON – See Work Model)Engagement Type: ContractNumber of Resources required...SeniorHourly payFor contractorsWork at office- Build scalable Azure data platforms in Winnipeg using Python, PySpark, and advanced SQL for large... ...on end-to-end engineering projects.This Senior Data Engineer role supports an Industrial... .... You will design pipelines, build data models, and maintain integrations using...Senior
- About the job RQ08912 - Data Architect/Modeller - SeniorResponsibilities: Construct a high-level overview... .... Hands‑on experience with Azure services, including Azure Data Factory,... ...IT trends and directions. Excellent analytical, problem‑solving and decision‑making skills...SeniorFlexible hours
- About the Role The Senior Developer, Data Analytics Delivery, will ensure that the various business stakeholders’ needs are met while maintaining alignment... ...and/or data engineering experience. Strong knowledge of Azure, Snowflake, Databricks and/or Fabric. Strong knowledge of...SeniorSummer workWork at officeRemote work1 day per week
- Reporting to the Director, Data and Analytics, the Senior Advisor is responsible for building Lassonde’s enterprise business intelligence capabilities... ...policy and the requirements of the role. A group insurance plan and a pension plan with employer contributions. Telemedicine...SeniorRemote work
$70k - $150k per year
As a Senior Analyst, Data Analytics, you’ll play a key role in advancing investigative and detection capabilities within a highly visible team focused... .... The role is based in Toronto and operates in a hybrid model (3 days in office). Performs sophisticated data...SeniorContract workPart timeWork at office- Design Azure data solutions as a Senior Data Engineering Advisor, using ELT tools, SQL, and data modeling in a hybrid work model.At Desjardins, you support a dedicated client group within Personal Services Analytics and Data Solutions. You develop scalable solutions for collecting...Senior
$64k - $106k per year
What you’ll do The Senior Data Scientist, Predictive Modelling develops predictive and prescriptive solutions that can be integrated into key enterprise... ...). You will conduct traditional and machine learning analytics to identify and quantify cause-and-effect relationships...SeniorLong term contract
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Modeler: Insurance & Azure Analytics. Be the first to apply!
Related searches
- senior disability case manager Winnipeg, MB
- senior hardware engineer Winnipeg, MB
- senior cook Winnipeg, MB
- amica senior lifestyles Winnipeg, MB
- senior building operator Winnipeg, MB
- senior project manager Winnipeg, MB
- senior communications Winnipeg, MB
- sr. IT support analyst Winnipeg, MB
- senior marketing Winnipeg, MB
- senior manager investigations Winnipeg, MB

