Principal Data Engineer

CNA; Chicago (IL); Remote; USD 150,000 - 186,000; Full time

Job summary

CNA is seeking a data engineer to lead the design and development of data processing systems on Google Cloud Platform. In this role, you'll integrate multiple data sources, implement security controls, and ensure high-quality deliverables in an agile environment, offering 100% telecommuting options.

Benefits

Standard benefits package

Qualifications

• 5 years of experience as data engineer, systems analyst, or related role.
• Experience designing data architectures and implementing GCP security features.
• Proficient in data processing systems and cloud technologies.

Responsibilities

• Lead design, implementation, and automation of data pipelines.
• Integrate data sources and manage workflows within GCP.
• Evaluate and recommend data tools based on organizational needs.

Skills

Data architecture

Data integration

Data modeling

Education

Bachelor’s degree in computer science

Tools

Google Cloud Platform

BigQuery

Cloud Dataflow

Cloud Storage

Google Cloud Pub/Sub

Data Fusion

dbt

Google Dataform

Job description

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.

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:

• Act as the principal builder of large-scale data processing systems and data lakes, optimized for both computational and storage efficiency on Google Cloud Platform.
• Design and implement scalable data architectures on GCP using services such as BigQuery, Cloud Dataflow, and Cloud Storage.
• Implement stringent access controls and data encryption using GCP’s security features like IAM, VPC, and Cloud Key Management.
• Integrate various data sources and manage data workflows using GCP tools like Google Cloud Pub/Sub and Data Fusion.
• Conduct thorough evaluations of data tools like Google Dataform and dbt to determine their viability for the organization.
• Apply deep technical knowledge on data modeling and best engineering practices.
• Lead 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.
• Lead robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
• Actively adhere to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
• Lead the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems.
• Lead the creation of integrated data views based on business or analytics requirements.
• Research and lead the identification and implementation of process improvements that address complex technology gaps.
• Build strong knowledge of technology enablers.

100% telecommuting allowed from anywhere within the U.S.

Reporting Relationship

Typically Director or above

Education & Experience Requirements

Bachelor’s degree in computer science, engineering management or related and 5 (five) years of experience as a data engineer, systems analyst or related

Must have some work experience with each of the following:

• Design and implement scalable data architectures on GCP using services such as BigQuery, Cloud Dataflow, and Cloud Storage;
• Implement stringent access controls and data encryption using GCP’s security features like IAM, VPC, and Cloud Key Management;
• Integrate various data sources and manage data workflows using GCP tools like Google Cloud Pub/Sub and Data Fusion; and
• Conduct thorough evaluations of data tools like Google Dataform and dbt to determine their viability for the organization.

100% telecommuting allowed from anywhere within the U.S.

Primary Location: United States – Chicago, IL

Organization – Technology

Mon-Fri., 8:30am – 4:45pm, 37.5 hours/week, $150,325 to $185,842 per year, overtime exempt. This position qualifies for CNA’s employee referral policy program.

Apply: CNA offers a standard benefits package. See a full list of benefits here: https://www.cna.com/careers/benefits. Submit cover letter and resume at www.cna.com

#LI-DNI

In certain jurisdictions, CNA is legally required to include a reasonable estimate of the compensation for this role. In District of Columbia,California, Colorado, Connecticut, Illinois, Maryland, Massachusetts, New York and Washington, the national base pay range for this job level is $97,000 to $189,000 annually.Salary determinations are based on various factors, including but not limited to, relevant work experience, skills, certifications and location. CNA offers a comprehensive and competitive benefits package to help our employees – and their family members – achieve their physical, financial, emotional and social wellbeing goals. For a detailed look at CNA’s benefits, please visitcnabenefits.com.

CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please [e-mail].