Senior Data Engineer

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:

• Participate in the building of large-scale data processing systems and data lakes optimized for both computational and storage efficiency on Google Cloud using Google cloud storage, Google Composer and BigQuery.
• Design and build data solutions and applications that enable reporting analytics data science and data management.
• Apply technical knowledge on data modeling and best engineering practices.
• Analyze data to create value for the CNA brand customers and key internal stakeholders.
• Lead 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.
• Lead robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
• Ensure team adherence to the same quality and standards working in an Agile development environment.
• Building ETL pipelines using Python and building Docker images.
• Design complex physical data models projects and cloud-based data lake constructs including SQL/NoSQL database systems.
• Create integrated data views based on business or analytics requirements.
• Research, identify, and implement process improvements that address complex technology gaps. Build strong knowledge of technology enablers.
• Apply machine learning to work as applicable.

Reporting Relationship
Typically Director or above.
Education & Experience
Bachelor's degree in computer science, IT or related and 5 (five) years of experience in data engineering. In lieu of a bachelor's degree plus 5 years of experience, employer will accept a master's degree plus 2 years of experience in the same fields.
Must have work experience with each of the following:

• Designing complex physical data models projects and cloud-based data lake constructs including SQL/NoSQL database systems;
• Building large-scale data processing systems and data lakes optimized for both computational and storage efficiency on Google cloud using Google cloud storage, Google Composer and BigQuery; and
• Building ETL pipelines using Python and building Docker images.

Primary Location United States - Illinois - Chicago
Organization - IT
Mon-Fri., 8:30am - 4:45pm, 37.5 hours/week; $130,000 to $140,000 per year, overtime exempt. This position qualifies for CNA's employee referral policy program.
Apply: Submit cover letter and resume at www.cna.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] .