Data Modeler

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. 

CNA seeks to offer a comprehensive and competitive benefits package to our employees that helps them — and their family members — achieve their physical, financial, emotional and social wellbeing goals.

For a detailed look at CNA’s benefits, check out our Candidate Guide.

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

• Master’s degree or equivalent work experience.
• Typically a minimum of eight years of related work experience.

#LI-MF1

#LI-Remote

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