Sr. Data Engineer-GCP

Cna - Chicago, IL

Full-time - Mid Level

Remote - Chicago, IL

Professional, Scientific, and Technical Services

About the position

The Sr. Data Engineer-GCP role at CNA is an individual contributor position focused on the design, development, and integration of strategic data applications within the software development lifecycle, particularly in an Agile environment. This position requires a high level of expertise in building large-scale data processing systems and data lakes on Google Cloud Platform, while also providing guidance to team members and ensuring adherence to quality standards.

Responsibilities

• Participates in building large-scale data processing systems and data lakes on Google Cloud Platform.
• Delivers results that create value for the CNA brand and stakeholders.
• Leads or sub-leads the design, implementation, and automation of data pipelines.
• Conducts robust unit testing to ensure deliverables match design specifications.
• Ensures adherence to quality and reliability standards in an Agile environment.
• Designs complex physical data models and cloud-based data lake constructs.
• Researches and implements process improvements to address technology gaps.
• Designs and builds data solutions for reporting, analytics, and data management.
• Maintains professional knowledge through workshops and publications.
• Applies machine learning techniques as applicable.

Requirements

• Strong knowledge of relational database concepts, ETL/ELT, star schema, and data modeling.
• Proficient in Python or advanced SQL with large-scale datasets.
• Strong troubleshooting and problem-solving skills.
• Strong communication and interpersonal skills in a matrixed environment.
• Preferred experience with Google Cloud Platform services and AWS.
• Experience with code management tools like Github and Concourse.
• Experience in implementing big data processing technology, preferably Apache Spark.
• Bachelor's degree in Computer Science or related field, Master's preferred.
• Typically 5+ years of experience in data, analytics, or application development.

Nice-to-haves

• Experience in the insurance industry and its products.
• Working knowledge of Business Intelligence tools.
• Applicable certifications in GCP or Data Engineering.

Benefits

• Comprehensive and competitive benefits package for employees and their families.