Data Management Consultant

Posted 10 Days Ago
Chicago, IL
Hybrid
1-3 Years Experience
Cloud • Insurance • Professional Services • Analytics • Cybersecurity
The Role
Seeking an experienced data and technology professional to collaborate with business partners, design and implement data processes, and support the development of dashboards and visualizations using SQL, DAX, and Power BI on tools like Google Cloud Platform.
Summary Generated by Built In

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 Actuarial Data Management team is looking for an experienced data and technology professional to help us deliver innovative data solutions. This role provides the opportunity to utilize your deep technical skills and business partnership skills on a daily basis. The successful candidate will work collaboratively with our business partners to architect, design and deliver information utilizing standard tools and technologies including Google Cloud platform and Microsoft Power BI.
The ideal candidate will be technically strong with SQL proficiency and demonstrated experience creating semantic data models, DAX formulas, and visuals in Power BI. This candidate will understand the process of creating and deploying new data pipelines, and will enhance our capabilities to deliver data and technology in support of our data goals.
JOB DESCRIPTION:
Essential Duties & Responsibilities

  • Collaborate with leaders and business partners to understand analytical requirements, identify appropriate data sources, and deliver information that supports the expected outcomes.
  • Design and implement standard, sustainable data processes, including the creation of common datasets with appropriate controls to ensure reliability and data integrity.
  • Work with data management director to guide and upskill other associates in Power BI, DAX, M Query Language, semantic model best practices, and visual/model performance optimization.
  • Evaluate existing Actuarial tools and processes and collaborate with our technology partners to define future state solutions that meet our requirements and eliminate support issues.
  • Work closely with Information Technology and ADMO teams to align our Actuarial data and technology solutions to the broader enterprise architecture and data governance guidelines.
  • Support the development of dashboards, visualizations, and standard exhibits to improve our ability to monitor and communicate results to our business partners.
  • Provide architectural and production support for our growing cloud data environment build-out across Google BigQuery, Looker, and Power BI's online service.
  • Independently identify and investigate issues related to projects. Recommend alternatives which include system identification, remediation of issues, and documentation of analysis and resolution.
  • Create and develop presentations, design documentation, diagrams, and training material as part of the deliverables.


Reporting Relationship
Director, Data Management or above
Skills Knowledge and Abilities

  • Strong data architecture, design and coding skills with hands-on experience designing and developing with SQL.
  • Experience in R, Python, and/or related programming languages is a plus. Substantive experience in one or more common visualization tools such as Power BI, Tableau, or Qlik required.
  • Multiple years of experience leading medium-to-large projects in Power BI strongly preferred.
  • Intermediate to advanced DAX-writing ability also preferred. Knowledge of cloud-based data applications (Google Cloud Platform, AWS, Azure, etc.) preferred, but not required in lieu of strong on-premise data experience.
  • Strong interpersonal, verbal and written communication skills with the ability to effectively interact and build trusted relationships across different departments and all levels of management.
  • Strong technical and problem solving skills with the ability to resolve complex situations and issues in an efficient and timely manner.
  • Detail-oriented with strong organizational skills, and the ability to independently manage or lead multiple projects.
  • Understanding of the insurance industry, its products, practices and operations is preferred but not required.
  • Knowledge of common actuarial data needs is a plus.


Education and Experience

  • Bachelor's Degree in Technology, Finance, Statistics, or related field
  • Typically a minimum of five to seven years of related work experience


#LI-KP1
#LI-Hybrid
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

Dax
SQL

What the Team is Saying

Meghan Bautista
Mehrzad Adelzadeh
Alison Massey
SenthilKumar Asokan
Zach Jones
Lisa Smith
Josie Lee
The Company
HQ: Chicago, IL
7,000 Employees
Hybrid Workplace
Year Founded: 1897

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

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

CNA Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
Company Office Image
HQChicago, IL
Located in the heart of the loop, CNA’s headquarters are at 151 N Franklin. With close proximity to both L and Metra stations.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account