200+ applicants

Company

CNA Insurance · 3 days ago

Sr. Data Engineer-GCP

Chicago, IL

Full-time

Remote

Senior Level

5+ years exp

Maximize your interview chances

FinanceFinancial Services

Actively Hiring

Insider Connection @CNA Insurance

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data modelingETL/ELTPythonSQLGoogle Cloud PlatformData integrationApache SparkAgile methodsBusiness Intelligence toolsGithubConcourseYamlInsurance industry experienceMachine learningLarge-scale datasetsData analytics solutions

Required

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.

Experience with code management tooling such as Github, Concourse, Yaml.

Experience in implementing big data processing technology.

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).

Preferred

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.

Preferred experience with the insurance industry, its products and services.

Experience using Agile methods preferred.

Applicable certifications preferred (GCP, Data Engineering).

Working knowledge of Business Intelligence tools preferred.