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 .
The Data Modeler role works with stakeholders across technology and
product teams to build the data model for the enterprise data warehouse and analytics needs across areas such areas as Underwriting, Claims, Finance, etc.
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 [email protected] .
Top Skills
What We Do
CNA is one of the largest U.S. commercial property and casualty insurance companies. Backed by more than 125 years of experience, CNA provides a broad range of standard and specialized insurance products and services for businesses and professionals in the U.S., Canada and Europe.
As a company of allies, we understand the importance of fostering an inclusive and supportive culture for all employees. Our eight Employee Resource Groups elevate the voices of underrepresented groups and champion critical DEI initiatives in the workplace and beyond. We strive to promote an environment of inclusion and continuously work to ensure all employees feel valued and respected.
Why Work With Us
CNA knows the importance of having the tools you need to expand your expertise and develop your career. With a variety of cross-discipline and cross-functional opportunities, CNA provides you with the tools and resources needed to customize your career path and understand what is needed to be effective in your role.
Gallery
