Senior Data Engineer Opportunity at CNA Insurance

At CNA Insurance, we believe in empowering our employees to reach their full potential, supported by exceptional leadership. We're dedicated to fostering a culture where everyone feels valued and part of something significant. Our comprehensive and competitive benefits package is designed to help you and your family achieve your health, financial, emotional, and social wellbeing goals.

For more details, explore our .

Job Description

The role of Senior Data Engineer is a highly specialized individual contributor position focused on the design, development, and integration of strategic, high-priority data applications throughout the software development lifecycle (Agile). You will also provide guidance to support the building of complex technical capabilities.

Essential Duties & Responsibilities

Perform a combination of duties as per departmental guidelines, including:

• Lead the design and building of data solutions and applications that facilitate reporting, analytics, data science, and data management.
• Guide development teams in building complex technical capabilities.
• Lead the design, implementation, and automation of data pipelines, sourcing data from both internal and external systems, and transforming it to meet various business requirements.
• Conduct robust unit testing to ensure deliverables match designs and support subsequent release testing.
• Create integrated data views based on business or analytics needs.
• Develop batch and real-time data pipelines using GCP cloud platform and data processing frameworks.
• Develop data pipelines/APIs using Python, SQL, Spark, and GCP methods.
• Create Apache Airflow Composer workflows using Python scripts in GCP for cloud compute orchestration.
• Develop Python scripts in GCP for batch processing with predefined APIs to read/write data into Big Query.
• Set up SNS or PubSub notification processes for job alerts and completion notifications.
• Identify and implement process improvements to address technology gaps.
• Maintain professional knowledge by attending workshops, reviewing publications, networking, and participating in professional societies.

100% telecommuting allowed from anywhere in the United States.

Reporting Relationship

Typically reports to Director or above.

Education & Experience Requirements

• Bachelor’s degree in computer science, IT, engineering, or a related field.
• Five years of experience as a data engineer, data analyst, software developer, software engineer, systems analyst, technical architect, or related roles.
• Experience with building large-scale batch and real-time data pipelines using GCP cloud platform and data processing frameworks.
• Experience in developing Python scripts in AWS or GCP for batch processing with predefined APIs to read/write data into Big Query or Aurora.
• Experience with developing State Machines and Lambdas or Apache Airflow Composer using Python scripts in AWS or GCP for cloud compute orchestration.
• Experience in creating SNS or PubSub notification processes for job alerts and completion notifications.

100% telecommuting allowed from anywhere in the United States.

Primary Location

United States – Illinois – Chicago

Company Information

Organization: IT
Work Schedule: Mon-Fri., 8:30am – 4:45pm, 37.5 hours/week
Salary: $144,560 to $155,000 per year, overtime exempt.
Application Process: Submit cover letter and resume at (Job ref: #LI-DNI).

Equal Opportunity Employer

CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact .