Principal Data Engineer

| Chicago, IL
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Job Summary
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.
Essential Duties & Responsibilities
Performs a combination of duties in accordance with departmental guidelines:
  1. 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.
  1. Independently delivers results, creating value for the CNA brand, customers, and key internal stakeholders. Works with external (and offshore) resources as required.
  1. 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.
  1. Leads robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
  1. Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
  1. 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.
  1. Researches and leads the identification and implementation of process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
  1. Leads the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
  1. 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.
  1. 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, data modeling and ETL/ELT.
  • 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.
  • 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).

*LI-KC1
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PerlLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • AccessDatabases
    • DB2Databases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • SalesforceCRM
    • SendGridEmail
    • MarketoLead Gen

What are CNA Perks + Benefits

CNA Benefits Overview

One of the many advantages of working at CNA is the benefits program we offer you and your eligible dependents,
beginning on the first day of your employment. The program features a variety of plans that provide health care
benefits, well-being, disability and survivor protection, and 401(k) savings, among others. Below are highlights
of the offerings.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Open door policy
Team owned deliverables
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Online course subscriptions available
More Jobs at CNA180 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Finance
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Developer
new
Chicago, IL
Finance
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Sales
new
Philadelphia, PA
HR + Recruiting
new
Chicago, IL
Developer
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Content
new
Chicago, IL
Operations
new
Lake Mary
Operations
new
Lisle
Operations
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Operations
new
Lake Mary
Operations
new
Lisle
Operations
new
Sioux Falls
Operations
new
Wyomissing
Operations
new
Lake Mary
Data + Analytics
new
Chicago, IL
Operations
new
Dallas-Fort Worth, TX
Product
new
Chicago, IL
Sales
new
Lake Mary
Data + Analytics
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Operations
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Operations
new
Chicago, IL
Finance
new
Chicago, IL
Finance
new
Chicago, IL
Finance
new
Chicago, IL
Operations
new
Lisle
Finance
new
Chicago, IL
Project Mgmt
new
Chicago, IL
Developer
new
Chicago, IL
Operations
new
Chicago, IL
Operations
new
Chicago, IL
Operations
new
Sioux Falls
Data + Analytics
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Sales
new
Melville
Sales
new
Philadelphia, PA
Sales
new
Chicago, IL
Operations
new
Chicago, IL
HR + Recruiting
new
Chicago, IL
Developer
new
Wyomissing
Data + Analytics
new
Chicago, IL
Content
new
Dallas-Fort Worth, TX
Operations
new
Chicago, IL
Developer
new
Chicago, IL
Operations
new
Chicago, IL
Finance
new
Chicago, IL
Sales
new
Minneapolis–Saint Paul, MN
Finance
new
Dallas-Fort Worth, TX
Marketing
new
Chicago, IL
Operations
new
Wyomissing
Finance
new
Kansas City, MO
Operations
new
Phoenix – Mesa – Scottsdale, AZ
Data + Analytics
new
Detroit, MI
Operations
new
Minneapolis–Saint Paul, MN
HR + Recruiting
new
Chicago, IL
HR + Recruiting
new
Chicago, IL
Finance
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Operations
new
Chicago, IL
Operations
new
Chicago, IL
Operations
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Developer
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Finance
new
Houston, TX
Finance
new
Dallas-Fort Worth, TX
Finance
new
Minneapolis–Saint Paul, MN
Project Mgmt
new
Chicago, IL
Developer
new
Chicago, IL
Finance
new
Chicago, IL
Operations
new
Miami, FL
Data + Analytics
new
Chicago, IL
Internships
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Finance
new
Lake Mary
HR + Recruiting
new
Chicago, IL
Data + Analytics
new
Chicago, IL
Finance
new
Philadelphia, PA
Finance
new
Dallas-Fort Worth, TX
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView CNA's full profileSee more CNA jobs