Principal Data Engineer

1 month ago


Chicago, United States CNA Full time

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's Guide.

An individual contributor role that provides the highest level of leadership in the design, development, and integration of strategic, high-priority business applications across the entire software development lifecycle (Agile). This role also provides guidance to others to support the building of complex technical capabilities.

JOB DESCRIPTION:

Essential Duties & Responsibilities

Performs a combination of duties in accordance with departmental guidelines:

  • Acts as the principal builder of large-scale data processing systems and data lakes, optimized for both computational and storage efficiency on Google Cloud Platform. Applies deep technical knowledge on data modeling and best engineering practices.
  • Independently delivers results, creating value for the CNA brand, customers, and key internal stakeholders. Works with external (and offshore) resources as required.
  • Leads the design, implementation and automation of data pipelines sourcing data from internal and external systems, transforming the data for the optimal needs of various systems and business requirements.
  • Leads robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
  • Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
  • Leads the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems. Leads the creation of integrated data views based on business or analytics requirements.
  • Researches and leads the identification and implementation of process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
  • Leads the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Drives the evolution of CNA application development processes and standards.
  • Applies machine learning to work as applicable.
May perform additional duties as assigned.

Reporting Relationship

Typically Director or above

Skills, Knowledge & Abilities
  • Expert knowledge of relational database concepts, ETL/ELT, star schema, data modeling.
  • Expert knowledge of data integration design and development, ensuring accuracy and ease of consumption. Strong troubleshooting and problem solving skills.
  • Proficient in Python or advanced SQL in a business environment with large-scale, complex datasets.
  • Excellent communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
  • Strong experience in building data analytics solutions using Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep. AWS, including, Amazon Redshift, Postgres, Elastic MapReduce a plus.
  • Preferred experience with the insurance industry, its products and services.
  • Strong experience in implementing big data processing technology. Apache Spark preferred.
  • Working knowledge of Business Intelligence tools.
Education & Experience
  • Bachelor's degree with Master's preferred in Computer Science, Information Technology, related discipline or equivalent work experience.
  • Typically 7+ years of experience in data, analytics or application development.
  • 3+ years of coding proficiency in at least one programming language (Python, Java, SQL).
  • Experience using Agile methods preferred.
  • Previous project leadership experience preferred.
  • Applicable certifications preferred (GCP, Data Engineering).


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.

  • Chicago, United States Blue Health Intelligence Full time

    About Us:BHI is a data and analytics company and helping health plans, researchers, healthcare providers, employers, and government agencies use data to improve the health outcomes, promote value-based care, and address health equity and increase the value of care provided. We leverage the industry’s most comprehensive and highest quality commercial data...


  • Chicago, United States Blue Health Intelligence Full time

    About Us:BHI is a data and analytics company and helping health plans, researchers, healthcare providers, employers, and government agencies use data to improve the health outcomes, promote value-based care, and address health equity and increase the value of care provided. We leverage the industry’s most comprehensive and highest quality commercial data...


  • Chicago, United States Workday Full time

    As a Senior Analytics Data Specialist you will play a vital role by serving as a Data Product Owner or Data Specialist. You will collaborate with Data Engineers, Data Architects, Business Owners to curate scalable, consumable data models with pre Data Engineer, Data Specialist, Product Owner, Principal, Analytics Specialist, Business Systems, Technology


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas. The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas. The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas. The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven vision...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Request Technology Full time

    ***Hybrid, 3 days onsite, 2 days remote*** ***We are unable to sponsor as this is a permanent full-time role*** A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses,...


  • Chicago, United States Tiger Analytics Full time

    Tiger Analytics is looking for experienced Principal Data Scientist to join our fast-growing advanced analytics consulting firm. Our employees bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our business value and...


  • Chicago, United States Tiger Analytics Full time

    Job DescriptionJob DescriptionTiger Analytics is looking for experienced Principal Data Scientist to join our fast-growing advanced analytics consulting firm. Our employees bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data....


  • Chicago, United States Tiger Analytics Full time

    Job DescriptionJob DescriptionTiger Analytics is looking for experienced Principal Data Scientist to join our fast-growing advanced analytics consulting firm. Our employees bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data....


  • Chicago, United States Tiger Analytics Full time

    Tiger Analytics is looking for experienced Principal Data Scientist to join our fast-growing advanced analytics consulting firm. Our employees bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our business value and...