Sr. Data Engineer-GCP

01460 Continental Casualty Company - Chicago, IL

Full-time - Mid Level

Chicago, IL

About the position

CNA is seeking an individual contributor who will 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 efficiency and quality in data handling, and may include leading efforts in data pipeline automation and testing. The position emphasizes collaboration with both internal teams and external resources, with a focus on delivering value to the organization and its stakeholders.

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 established 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 for effective collaboration in a matrixed environment.
• 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 in building data analytics solutions using Google Cloud Platform services.
• Experience with AWS services such as Amazon Redshift and Elastic MapReduce.
• Familiarity with code management tools like Github and Concourse.
• 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 for employees and their families.