Senior Data Engineer

Company: CNA Insurance
Location: Chicago
Posted on: August 7, 2022

Job Description:

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 & ResponsibilitiesPerforms a combination of duties in accordance with departmental guidelines:Build large-scale data processing systems on premise (Oracle) and cloud platforms (Google), optimized for both computational and storage efficiency.Build big datamarts for Business Intelligence in Microsoft Azure.Design and develop ETL pipelines for data projects using Python, Informatica and Datastage.Create analytical models using Alteryx Analytics for complex applications.Lead the design, implementation and automation of data integration with 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 provide expertise to support subsequent release testing. Lead the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems.Lead the creation of integrated data views based on business or analytics requirements.Research, identify and implement process improvements that address complex technology gaps.Lead the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.Reporting RelationshipTypically Director or above.Education & ExperienceBachelor s degree in computer science, IT or engineering and 5 (five) years of experience in data analytics or application developmentMust have work experience with each of the following:Building big datamarts for Business Intelligence in Microsoft Azure;Designing and developing ETL pipelines for data projects using Python, Informatica and Datastage; andCreating analytical models using Alteryx Analytics for complex applications in the Insurance Domain.Primary Location United States - Illinois - ChicagoOrganization - ITMon-Fri., 8:30am - 4:45pm, 37.5 hours/week; $114,899 to $142,800 per year, overtime exempt. This position qualifies for CNA s employee referral policy program.Apply: Submit cover letter and resume at CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact .

Keywords: CNA Insurance, Chicago , Senior Data Engineer, Engineering , Chicago, Illinois