Back to jobs

Data Engineering Lead

Rolling Meadows, Illinois

Live, first seen by us 87 days ago
Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Design, build and support ETL/ELT pipelines and data integrations

  • Lead technical design of complex data engineering initiatives

  • Establish engineering standards and conduct design and code reviews

  • Troubleshoot production data issues and lead root-cause analysis

  • Develop curated datasets and data products for analytics and AI

From the employer’s posting
Design, develop, test, deploy, and support scalable ETL/ELT pipelines and data integrations.
Lead technical design and implementation of complex data engineering initiatives.
Establish engineering standards for coding, testing, data quality, documentation, security, and deployment.
Lead root-cause analysis and implement permanent fixes for production issues.
Develop curated datasets and data products supporting analytics, reporting, data science, and AI.

Before you apply

Employer’s visa record
1 H-1B petition approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Apply at Gallagher

Posting record

Report an error
Status in our records
Live
First seen by us
Aug 26, 202687 days ago
Recorded sightings
402
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 87

Up longer than most. Similar jobs usually come down between day 6 and day 56.

At Gallagher, jobs usually come down by about day 45.

From 14,771 similar postings that came down, and 139 of Gallagher’s. Coming down is not always a hire.

Gallagher is hiring

62 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is steady
  • Takes jobs down at a usual pace
  • 3% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • Scala
  • SQL
  • Azure
  • Databricks
  • Snowflake
  • Spark
  • SQL Server
Where the posting names them
Write production-quality SQL and Python/Scala/Spark code for data ingestion, transformation, and processing.
Strong programming experience with Python, Scala, or equivalent.
Work across Snowflake, Azure Data Factory, Databricks, Spark, ADLS Gen2, Azure Synapse, and SQL Server/Azure SQL.
Strong hands-on experience with Snowflake, Azure Data Factory, Databricks/Spark, ADLS Gen2, and SQL.

Your next step

Complete your application on usjobs-ajg.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

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. Overview The Data Engineering Lead is a hands-on technical leader responsible for designing, building, and supporting the data platform that powers analytics, reporting, and AI at Gallagher. You will lead complex data engineering initiatives while remaining deeply involved in the technology. This includes developing data pipelines, designing integrations, troubleshooting production issues, optimizing performance, reviewing code, and establishing engineering standards. This is an individual contributor role with technical leadership responsibilities and no direct people management. You will work closely with data engineers, analytics, data science, business, and technology teams to translate business needs into scalable and reliable data solutions. How you'll make an impact Hands-On Data Engineering Design, develop, test, deploy, and support scalable ETL/ELT pipelines and data integrations. Write production-quality SQL and Python/Scala/Spark code for data ingestion, transformation, and processing. Build reusable, modular, and reliable data engineering frameworks and pipelines. Work across Snowflake, Azure Data Factory, Databricks, Spark, ADLS Gen2, Azure Synapse, and SQL Server/Azure SQL. Develop curated datasets and data products supporting analytics, reporting, data science, and AI. Troubleshoot complex data, pipeline, integration, and performance issues. Optimize pipelines, queries, compute, and storage for performance, reliability, and cost. Technical Leadership Lead technical design and implementation of complex data engineering initiatives. Translate business requirements into practical, scalable technical solutions. Establish engineering standards for coding, testing, data quality, documentation, security, and deployment. Conduct design and code reviews and establish reusable engineering patterns. Mentor engineers and provide technical direction without direct management responsibility. Identify technical risks, dependencies, and opportunities to simplify or modernize existing solutions. Data Platform & Reliability Design scalable data lake, warehouse, and integration solutions using appropriate data modeling practices. Build data quality, monitoring, logging, and observability into production pipelines. Own the technical reliability of data pipelines and integrations. Lead root-cause analysis and implement permanent fixes for production issues. Improve CI/CD, release management, automation, and operational support practices. Help reduce technical debt, manual processes, duplicate integrations, and single points of failure. Business & AI Partnership Partner with business, analytics, data science, security, and technology teams to deliver data solutions aligned to business priorities. Communicate technical decisions, risks, and tradeoffs clearly to technical and non-technical stakeholders. Build data foundations that support AI and advanced analytics, including structured and unstructured data use cases. Apply appropriate security, governance, and access controls to enterprise data. About You Required Qualifications Bachelor's degree in Computer Science, Information Technology, Engineering, or related field. 7+ years of hands-on data engineering experience, including 3+ years in a technical lead or senior engineering role. Strong hands-on experience with Snowflake, Azure Data Factory, Databricks/Spark, ADLS Gen2, and SQL. Strong programming experience with Python, Scala, or equivalent. Proven experience designing and implementing enterprise ETL/ELT pipelines and data integrations. Strong understanding of data lake, data warehouse, and data modeling concepts. Experience with production troubleshooting, performance tuning, data quality, and pipeline reliability. Experience with CI/CD and modern software engineering practices. Ability to lead technical initiatives and influence engineers without direct management authority. Strong problem-solving and communication skills. Preferred Qualifications Experience modernizing legacy data platforms and integrations. Experience with data observability, lineage, metadata, or governance. Experience supporting AI/ML, RAG, semantic search, or other advanced analytics workloads. Experience optimizing cloud data platforms for performance and cost. Experience working with distributed engineering teams. #LI-NP1 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)

About Gallagher

People
About 72,000 in 2025, up 29% from the year before.Annual report (SEC Form 10-K)
Company
Listed as AJG.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Rolling Meadows, Illinois

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.