AI Data Engineer

Gallagher

United States

Hybrid

Confidential

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Gallagher is hiring for a data-focused IT role in Rolling Meadows, IL. The position centers on building and maintaining robust data infrastructures, pipelines, and large-scale datasets to fuel analytics across business units.

Ideal candidates bring 5+ years of experience with SQL, Python, Azure Data Factory, and cloud data platforms, plus strong communication to partner with Executives, Product, Data, and Design teams.

Qualifications

  • Typically requires a university degree and minimum 5 years of prior relevant experience.
  • Experience with SQL, Python, Azure Data Factory, and data platforms.
  • Knowledge of data lakes, distributed data warehouses, and big data tech.
  • Strong communication and stakeholder management skills.
  • Experience with cloud data and data transformation.

Responsibilities

  • Develops, maintains, and tests infrastructures for data generation.
  • Creates and maintains data pipeline architecture to meet business needs.
  • Assembles large, complex datasets that meet functional/nonfunctional requirements.
  • Identifies, designs, and implements internal process improvements; automates manual processes.
  • Builds infrastructure for ETL from diverse sources using SQL and big data technologies.
  • Collaborates with Executive, Product, Data, and Design teams to support data needs.
  • Keeps data separated and secure across national boundaries through data centers and AWS regions.
  • Creates data tools for analytics and data science teams to build innovative products.
  • Oversees data generation infrastructure and analytics tooling.

Skills

SQL
Python
Azure Data Factory
Databricks
Spark
Data transformation
Cloud data
Distributed data warehouse
Data Lakes
Communication
Stakeholder management

Education

University degree

Job description

Rolling Meadows, Illinois

Information Technology

59290

$100,000 - $195,000

Partially Scheduled in the Office

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.

How you'll make an impact

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 CAREER: Applies advanced knowledge of sub-function typically obtained through advanced education and work experience. Responsibilities may include:

  • Managing products, systems and/or projects/processes, and working independently with limited supervision.
  • Facing IT function related problems that are sometimes difficult and moderately complex.
  • Coaching and reviewing the work of lower-level professionals.
About You
Required
  • Typically requires a University Degree and minimum 5 years of prior relevant experience, or equivalent experience.
Preferred
  • 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
Compensation and benefits

At Gallagher, we believe supporting our colleagues goes far beyond the role itself. For more information, visit our Benefits page.

Competitive compensation

Comprehensive benefits programs designed to support your well-being

Career development opportunities and ongoing learning

A collaborative, people-first culture with accessible leadership

The opportunity to do meaningful work with global reach and local impact

At Gallagher, we are dedicated to building an inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. At times, we will consider transferable skills from previous roles.

Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect - Insurance Data
Data Architect - Insurance Data

Arthur J. Gallagher & Co. (AJG) • Rolling Meadows (IL)

On-site
USD 130,000 - 190,000
Competitive compensation
Comprehensive benefits
Career development opportunities
+1
Lead Data Solution and AI Engineer
Lead Data Solution and AI Engineer

Gallagher • Chicago (IL)

Remote
Confidential
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+1
Data Architect - Insurance Data
Data Architect - Insurance Data

Gallagher • Rolling Meadows (IL)

On-site
Confidential
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+2
Data Support Manager
Data Support Manager

Gallagher • Fort Washington

On-site
USD 120,000 - 190,000
Competitive compensation
Comprehensive benefits
Career development opportunities
+2
Data Support Manager
Data Support Manager

Arthur J. Gallagher group • Washington

On-site
USD 120,000 - 160,000
Competitive compensation
Comprehensive benefits programs
Career development opportunities
+2
U.S. Internship - Data Analytics - ALL LOCATIONS
U.S. Internship - Data Analytics - ALL LOCATIONS

Gallagher • Chicago (IL)

On-site
Confidential
Competitive compensation
Comprehensive benefits programs
Career development opportunities and学习
Senior Consultative Analyst
Senior Consultative Analyst

Gallagher • Chicago (IL)

Hybrid
Confidential
Competitive compensation
Comprehensive benefits
Career development opportunities
+2
Data Science Engineer
Data Science Engineer

Gallagher • Rolling Meadows (IL)

Remote
USD 110,000 - 150,000
Medical/dental/vision plans
Life and accident insurance
401(K) and Roth options
+8
Data Analyst
Data Analyst

Arthur J. Gallagher & Co. • Holly Springs (NC)

On-site
USD 65,000 - 85,000
Competitive compensation
Comprehensive benefits
Career development
+1
Area Senior Vice President
Area Senior Vice President

Gallagher • Chicago (IL)

Remote
Confidential
Competitive compensation
Comprehensive benefits programs