CNA Insurance · 5 hours ago
Business Analytics Consulting Director (Data Modeler)
Chicago, IL, USA
Full-time
Hybrid
Senior Level, Lead/Staff
$97K/yr - $189K/yr
8+ years expCNA Insurance is dedicated to fostering a culture where employees feel valued and empowered. The Business Analytics Consulting Director (Data Modeler) is responsible for designing and maintaining enterprise-level data models to support CNA’s analytics and reporting ecosystem, collaborating with cross-functional teams to drive business value across data initiatives.
FinanceFinancial ServicesInformation ServicesInformation TechnologyInsuranceProperty ManagementReal EstateRisk Management
Responsibilities
Lead design discussions and create conceptual and logical data models for the Enterprise Data Warehouse
Manage and maintain data models and define reporting strategies
Perform data quality analysis and propose solutions to identified issues
Guide product teams in creating physical data model designs and data dictionaries
Review design adherence to ensure standards and best practices are followed
Facilitate discussions to understand data sources and establish systems of record
Create information architecture roadmaps with current and future state data flows
Interact with stakeholders across diverse teams, both IT and business
Interprets model results and identifies potential model errors, such as overfitting
Qualification
Required
8+ years of data modeling experience with expertise in relational and/or dimensional analysis
Experience in Insurance Industry, preferably in Property and Casualty Insurance
Deep understanding of data modeling principles and architecture concepts
Knowledge of different database platforms (relational and NoSQL)
Experience with enterprise data modeling tools such as ERWIN
3+ years of experience in a data lake environment
Experience with database technologies such as GCP Big Query, PostgreSQL, IICS, Composer, Github etc
Understanding of ETL processes to load large data warehouses
Ability to work as an individual contributor
Strong communication and collaborative skills to work with agile teams in articulating the model and guiding the development
Advanced analytical, critical thinking and problem solving skills to effectively resolve complex situations and issues
Master's degree or equivalent work experience
Typically a minimum of eight years of related work experience
Benefits
CNA offers a comprehensive and competitive benefits package to help our employees – and their family members – achieve their physical, financial, emotional and social wellbeing goals.
Company
CNA Insurance
CNA is one of the largest U.S. commercial property and casualty insurance companies.
5001-10000 employees
H1B Sponsorship
CNA Insurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (30)
2024 (32)
2023 (25)
2022 (43)
2021 (32)
2020 (14)
Funding
Current Stage
Public CompanyTotal Funding
$0.88M2016-09-12Post Ipo Equity· $0.88M
1978-01-13IPO
Leadership Team
Luke Mellors
Vice President, Technology
Daniel Franzetti
Chief Administrative Officer
Recent News
2026-01-20
2025-11-03
Company data provided by crunchbase