Data Engineer

Gallagher•Rolling Meadows, IL

About The Position

Develops, maintains, and tests infrastructures for data generation. Creates and maintains optimal data pipeline architecture and assembles data to meet business needs. Assembles large, complex datasets that meet functional / nonfunctional business requirements. Identifies, designs, and implements internal process improvements; automates manual processes, optimizing data delivery and redesigning infrastructure for greater scalability. Builds infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and "big data" technologies. Works with stakeholders including the Executive, Product, Data, and Design teams to assist with data related technical issues and support data infrastructure needs. Keeps data separated and secure across national boundaries through multiples data centers and AWS regions. Creates data tools for analytics and data scientist team members that that assist with building and optimizing products into innovative, industry leaders. Oversees data generation infrastructure. Builds analytics tools to provide actionable insights and assist data science and analytics team members with building bestinclass products. Works with stakeholders to assist with data related tech issues and support data infrastructure needs. Applies practical knowledge of sub-function area typically obtained through advanced education and work experience. May require the following proficiencies: Working independently with general supervision. Facing IT function related problems that are difficult but typically not complex. Potentially influencing others within the function through explanation of facts, policies and practices.

Requirements

Typically requires a University Degree and minimum 3 years of prior relevant experience, or equivalent experience.

Nice To Haves

SQL Python, Azure data factory, Data Bricks, Spark (experience would be a plus)
Data transformation
Cloud Data Experience
Distributed data warehouse knowledge
Data Lakes
Communication and stakeholder management skills

Responsibilities

Develops, maintains, and tests infrastructures for data generation
Creates and maintains optimal data pipeline architecture and assembles data to meet business needs
Assembles large, complex datasets that meet functional / nonfunctional business requirements
Identifies, designs, and implements internal process improvements; automates manual processes , optimizing data delivery and redesigning infrastructure for greater scalability
Builds infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and "big data" technologies
Works with stakeholders including the Executive, Product, Data, and Design teams to assist with data related technical issues and support data infrastructure needs
Keeps data separated and secure across national boundaries through multiples data centers and AWS regions
Creates data tools for analytics and data scientist team members that that assist with building and optimizing products into innovative, industry leaders
Oversees data generation infrastructure
Builds analytics tools to provide actionable insights and assist data science and analytics team members with building bestinclass products
Work with stakeholders to assist with data related tech issues and support data infrastructure needs

Benefits

Medical/dental/vision plans, which start from day one!
Life and accident insurance
401(K) and Roth options
Tax-advantaged accounts (HSA, FSA)
Educational expense reimbursement
Paid parental leave
Digital mental health services (Talkspace)
Flexible work hours (availability varies by office and job function)
Training programs
Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
Charitable matching gift program