CNA Logo

CNA

Sr. Data Engineer-GCP

Sorry, this job was removed at 06:15 p.m. (CST) on Saturday, Apr 19, 2025
Remote
Hybrid
2 Locations
72K-141K Annually
Remote
Hybrid
2 Locations
72K-141K Annually

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 a high level of expertise in the design, development, and integration of strategic, high-priority data applications across the entire software development lifecycle (Agile). This role may also provide 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:

  • Participates in the building of large-scale data processing systems and data lakes, optimized for both computational and storage efficiency on Google Cloud Platform. Applies technical knowledge on data modeling and best engineering practices.
  • Working as a key team member, delivers results, creating value for the CNA brand, customers, and key internal stakeholders. Works with external (and offshore) resources as required.
  • May lead or sub-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.
  • May lead or sub-lead robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
  • Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
  • May lead or sub-lead the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems. May lead or sub-lead the creation of integrated data views based on business or analytics requirements.
  • Researches, identifies and implements process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
  • May lead or sub-lead the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Drives the evolution of CNA application development processes and standards.
  • Applies machine learning to work as applicable.


May perform additional duties as assigned.
Reporting Relationship
Typically Director or above
Skills, Knowledge & Abilities

  • Strong knowledge of relational database concepts, ETL/ELT (Informatica IICS preferred) , star schema, data modeling.
  • Strong data integration design and development, ensuring accuracy and ease of consumption. Strong troubleshooting and problem solving skills.
  • Proficient in Python or advanced SQL in a business environment with large-scale, complex datasets.
  • Strong communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
  • Preferred experience in building data analytics solutions using Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep. AWS, including, Amazon Redshift, Postgres, Elastic MapReduce a plus.
  • Experience with code management tooling such as Github, Concourse, Yaml
  • Preferred experience with the insurance industry, its products and services.
  • Experience in implementing big data processing technology. Apache Spark preferred.
  • Working knowledge of Business Intelligence tools preferred.


Education & Experience

  • Bachelor's degree with Master's preferred in Computer Science, Information Technology, related discipline or equivalent work experience.
  • 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.
  • Applicable certifications preferred (GCP, Data Engineering).


#LI-MF1
#LI-Remote
I n 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 $72,000 to $141,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 visit cnabenefits.com .
CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact [email protected] .

HQ

CNA Chicago, Illinois, USA Office

Located in the heart of the loop, CNA’s headquarters are at 151 N Franklin. With close proximity to both L and Metra stations.

Similar Jobs at CNA

21 Days Ago
Remote
Hybrid
2 Locations
97K-189K Annually
Senior level
97K-189K Annually
Senior level
Cloud • Insurance • Professional Services • Analytics • Cybersecurity
The Data Modeler will design and maintain data models for the Enterprise Data Warehouse, manage data quality, and guide stakeholders in data architecture.
Top Skills: ComposerErwinGcp Big QueryGitIicsPostgres
30 Minutes Ago
Remote
Hybrid
13 Locations
97K-189K Annually
Senior level
97K-189K Annually
Senior level
Cloud • Insurance • Professional Services • Analytics • Cybersecurity
The Senior Claims Counsel handles complex high severity D&O and E&O claims, evaluates liability, formulates resolution strategies, mentors junior staff, and collaborates with business partners.
Top Skills: Microsoft Office Suite
3 Days Ago
Remote
Hybrid
2 Locations
152K-242K Annually
Senior level
152K-242K Annually
Senior level
Cloud • Insurance • Professional Services • Analytics • Cybersecurity
The AVP, Cloud Security directs cloud security strategy, oversees a cloud security team, and ensures the security of all cloud platforms and services at CNA.
Top Skills: AWSAzureCloudtrailDevsecopsGoogle Cloud PlatformIaasIamPaasSccThird-Party Cloud Security Tools

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account