Data Engineer Specialist

| Chicago, IL
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Data Engineer
Description:
Headquartered in the heart of downtown Chicago, CNA is a leading commercial and specialty insurer, offering a diverse range of insurance products including Workers Compensation, Property, General Liability, Professional Liability, Cyber Insurance, Surety, and Warranty. We are one of the world leaders in underwriting non-medical professionals, from lawyers and accountants to architects and management consultants.
What CNA offers:
  • A collaborative and growing analytics team with diverse skills and experiences, combined with deep expertise in insurance applications of data and analytics
  • Modern cloud computing environment that enables you to explore data, build and deploy sophisticated processes that impact key areas such as underwriting, pricing, claims management and risk control
  • Sponsorship of continued professional growth through support for attending technical conferences, meetings and symposia

What we are looking for:
The successful candidate will:
  • Work cross functionally at CNA to build next generation data capabilities to enable superior decision support and insight generation
  • Support data and processes for the pricing, underwriting, claims, operations and marketing for an exciting mix of business insurance products

Essential Duties & Responsibilities:
  • Assemble large and complex data sets from disparate data sources into consumable formats that meet business requirements
  • Create efficient and reproducible ETL Data Pipelines using SQL, Python or big data tools such as Spark
  • Work closely with Data Science, DevOps and data management teams to assist with data-related technical issues and support their data infrastructure needs
  • Build and maintain capabilities for data quality control, identify data quality issues and pipeline failures
  • Build exploratory Dashboards/tools for data scientists and business partners that can be deployed relatively quickly and require low maintenance
  • Create streamlined process for geocoding internal data for matching to external sources
  • Collaborate with application owners to help define data collection requirements
  • Work with Data Scientists to understand requirements and help design systems and processes to deliver business value. Research new uses for existing data
  • Build infrastructure required for flexible and scalable extraction, transformation and loading of data from a wide variety of data sources
  • Design and implement functionality, participate in team code reviews, and provide feedback on performance, logic, standard methodologies and maintenance issues to ensure code-level consistency
  • Create production quality code to support deployment of predictive models
  • Produce coherent documentation, metadata, and reports
  • Own data processing pipelines from conception to production deployment.

Required Skills, Knowledge & Abilities:
  • Advanced SQL knowledge and proven experience working with relational databases.
  • Demonstrated experience in manipulating, merging, cleaning, profiling, and preparing large datasets for analytics, from disparate sources
  • Working knowledge of Python, including pandas
  • Experience working with XML and JSON formats
  • Practical experience with version control, preferably git
  • Experience implementing and maintaining ETL and CI/CD data pipelines
  • Ability to write efficient, well documented data wrangling code
  • Intellectual curiosity to find new and innovative ways to solve data management issues
  • Employ an array of technologies and tools to connect systems together
  • Strong analytical, problem solving and critical thinking skills
  • Attention to detail and accuracy of work, ability to spot and correct issues
  • Strong interpersonal and communication skills
  • Drive to continuously improve and learn new tools and methods
  • Ability to work collaboratively with colleagues with diverse perspectives and backgrounds
  • Strong time management skills
  • Capable of operating with little supervision and thinking independently and innovatively

Preferred Skills, Knowledge & Abilities:
  • Experience with data pipeline and workflow management tools such as Airflow
  • Experience with GCP cloud services such as Big Query, Google Storage, Google Cloud Functions
  • Experience with distributed data processing technologies such as Spark
  • Knowledge of R, including the dplyr and data.table packages
  • Experience working with unstructured data
  • Experience working with insurance data
  • Familiarity with data dash-boarding tools such as Python dash, R Shiny, or Tableau
  • Experience in extracting meaningful information from data using visualization

Reporting Relationship:
Director or above
Education & Experience:
  • Bachelor's degree, with two or more years of relevant work experience.

*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