Data modeler [h1.location_city]

You have a clear vision of where your career can go. And we have the leadership to help you get there. At CNA we strive to create a culture in which people know they matter and are part of something important ensuring the abilities of all employees are used to their fullest potential.

The Business Analytics Consulting Director (Data Modeler) will serve as a handson individual contributor responsible for designing developing and maintaining enterpriselevel data models that support CNAs cloudbased analytics and reporting ecosystem. This role partners closely with crossfunctional teamsboth internal and externalto build scalable highquality conceptual logical and physical data models that drive business value across emerging data initiatives.

The Director will collaborate with product teams to guide model design ensure adherence to standards and establish clear systems of record. This position plays a key role in shaping data architecture within a rapidly expanding environment supporting multiple newly forming teams focused on cloud data modernization. The ideal candidate brings deep data modeling expertise experience within the P&C insurance industry strong analytical skills and the ability to operate independently while influencing technical and business stakeholders.

JOB DESCRIPTION : Job Description

Essential Duties & 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

Reporting Relationship Typically Reports to System Architect or above

Skills Knowledge & Abilities

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.

Education & Experience

Masters degree or equivalent work experience.

Typically a minimum of eight years of related work experience.

#LI-ED1

#LI-Hybrid

I n certain jurisdictions CNA is legally required to include a reasonable estimate of the compensation for this District of Columbia California Colorado Connecticut Illinois Maryland Massachusetts New York and Washington the national base pay range for this job level is $97000 to $189000 determinations are based on various factors including but not limited to relevant work experience skills certifications and location. 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. For a detailed look at CNAs benefits please visit .

CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation please contact .

Required Experience :

Director

Key Skills

Atl,CMMS,ABAP,Community Support,CRM,Fleet

Employment Type : Full-Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 97000 - 189000