Sr. Data Engineer-GCP

Cna - Chicago, IL

Full-time - Mid Level

Chicago, IL

Professional, Scientific, and Technical Services

About the position

CNA is seeking an individual contributor to provide high-level expertise in the design, development, and integration of strategic data applications throughout the software development lifecycle, particularly in an Agile environment. This role involves building large-scale data processing systems and data lakes on Google Cloud Platform, ensuring optimal performance and efficiency, while also guiding others in developing complex technical capabilities.

Responsibilities

• Participates in building large-scale data processing systems and data lakes on Google Cloud Platform.
• Applies technical knowledge on data modeling and best engineering practices.
• Delivers results as a key team member, creating value for the CNA brand and stakeholders.
• Works with external and offshore resources as required.
• 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.
• Creates integrated data views based on business or analytics requirements.
• Researches and implements process improvements for technology gaps.
• Builds knowledge of technology enablers and applies machine learning as applicable.

Requirements

• Strong knowledge of relational database concepts, ETL/ELT, star schema, and data modeling.
• Proficient in Python or advanced SQL in a business environment with large-scale datasets.
• Strong troubleshooting and problem-solving skills.
• Strong communication and interpersonal skills to work effectively in a matrixed environment.
• Preferred experience in building data analytics solutions using Google Cloud Platform services.
• Experience with code management tooling such as Github and Concourse.
• Bachelor's degree in Computer Science, Information Technology, or related discipline; Master's preferred.
• Typically 5+ years of experience in data, analytics, or application development.
• 2+ years of coding proficiency in at least one programming language (Python, Java, SQL).
• Experience using Agile methods preferred.

Nice-to-haves

• Preferred experience with the insurance industry and its products.
• Experience in implementing big data processing technology, preferably Apache Spark.
• Working knowledge of Business Intelligence tools.

Benefits

• Comprehensive and competitive benefits package to support physical, financial, emotional, and social wellbeing.