Back to jobs

Lead Data Solution and AI Engineer

Reads like a Data Engineer role: pipelines and data infrastructure.

Rolling Meadows, Illinois

Live, first seen by us 43 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 and maintain scalable ETL/ELT pipelines on Azure and Databricks

  • Build ingestion and validation workflows from APIs, databases and cloud storage

  • Write and optimize T-SQL queries, stored procedures and views

  • Troubleshoot ETL failures, data latency issues and production incidents

  • Develop, deploy and monitor AI/ML models on structured and unstructured data

From the employer’s posting
Design and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, Synapse Analytics, and Azure SQL
Develop data ingestion, transformation, validation, and loading workflows from APIs, databases, Azure Blob Storage, ADLS Gen2
Write and optimize T-SQL queries, stored procedures, views, and functions
Troubleshoot ETL failures, data latency issues, and production incidents
Develop, train, fine-tune, deploy, and monitor AI/ML models using structured and unstructured data

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
Oct 9, 202643 days ago
Recorded sightings
57
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 43

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.

  • C#
  • Python
  • SQL
  • T-SQL
  • Azure
  • Databricks
  • Snowflake
  • SQL Server
  • SSIS
  • NumPy
  • pandas
Where the posting names them
2+ years experience with microservices, event-driven architectures, and containerized applications 3+ years experience working with C#, .NET, REST APIs, and modern application architecture to support integration and solution development.
Core technical stack: Data Platform and Engineering Microsoft/Azure: Azure Data Warehouse, Azure SQL Database / Synapse, Azure Data Factory, Azure Functions, SQL Server, T-SQL, SSIS Data & engineering tools: DevOps, Databricks AI and Advanced Analytics Enablement Python, NumPy, Pandas, PyArrow AI/LLM tools: OpenAI, LangChain, LlamaIndex, AI tools, Vector Database About You 10+ years of progressive experience as a Data Solutions and AI Engineer using current and emerging data technologies and approaches, including 7+ years on the Microsoft platform.
SQL Python, Azure data factory, Data •
Key Responsibilities: Data Platform and Pipeline Delivery Design and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, Synapse Analytics, and Azure SQL to support analytics, reporting, and AI/ML workloads.
Develop data ingestion, transformation, validation, and loading workflows from APIs, databases, Azure Blob Storage, ADLS Gen2, third-party systems, and on-premises SQL databases.
Support on-premises SQL Server integration, including data extraction, synchronization, replication, and performance tuning.
Write and optimize T-SQL queries, stored procedures, views, and functions to support data processing, reporting, and analytics.
7+ years designing and building large applications using SQL Server and related database technologies.
Troubleshoot ETL failures, data latency issues, and production incidents across Azure and on-premises environments.
Security, Governance and Compliance Apply Azure security best practices, including RBAC, Managed Identities, Azure Key Vault, and private networking.
5+ years strong understanding of database and application performance tuning Experience in Snowflake and Microsoft Fabric a plus Bachelor’s degree in computer science, Engineering, or a related field Strong communication skills with management, development teams, vendors, systems administrators, and other service providers Required: Typically requires a University Degree and minimum 7 years of prior relevant experience, or equivalent experience.

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 At Gallagher Bassett, we're there when it matters most because helping people through challenging moments is more than just our job, it’s our purpose. Every day, we help clients navigate complexity, support recovery, and deliver outcomes that make a real difference in people’s lives. It takes empathy, precision, and a strong sense of partnership—and that’s exactly what you’ll find here. We’re a team of fast-paced fixers, empathetic experts, and outcomes drivers — people who care deeply about doing the right thing and doing it well. Whether you're managing claims, supporting clients, or improving processes, you’ll play a vital role in helping businesses and individuals move forward with confidence. Here, you’ll be supported by a culture that values teamwork, encourages curiosity, and celebrates the impact of your work. Because when you’re here, you’re part of something bigger. You’re part of a team that shows up, stands together, and leads with purpose. How you'll make an impact The Lead Data Solution and AI Engineer developer provides guidance, leadership, and solid execution of data integration solutions as they related to BI and AI project initiatives. Typically, this role participates in multiple, technically complex, mission-critical, and/or high-profile data projects or initiatives. This individual must possess strong leadership skills including the ability to make sound data architectural solutions recommendations. Key Responsibilities: Data Platform and Pipeline Delivery Design and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, Synapse Analytics, and Azure SQL to support analytics, reporting, and AI/ML workloads. Develop data ingestion, transformation, validation, and loading workflows from APIs, databases, Azure Blob Storage, ADLS Gen2, third-party systems, and on-premises SQL databases. Support on-premises SQL Server integration, including data extraction, synchronization, replication, and performance tuning. Write and optimize T-SQL queries, stored procedures, views, and functions to support data processing, reporting, and analytics. Support data models, data marts, and feature stores for analytics and machine learning use cases. Develop, train, fine-tune, deploy, and monitor AI/ML models using structured and unstructured data, including model versioning, performance tracking, and retraining. Develop AI-powered capabilities using modern large language models (LLMs) and AI services. Implement intelligent search, knowledge retrieval, and automation solutions. Troubleshoot ETL failures, data latency issues, and production incidents across Azure and on-premises environments. Process Improvement and Operational Excellence Identify and implement process improvements that automate manual activities and improve data delivery. Improve the performance, scalability, reliability, and maintainability of data engineering solutions. Security, Governance and Compliance Apply Azure security best practices, including RBAC, Managed Identities, Azure Key Vault, and private networking. Ensure data quality, consistency, lineage, and governance through validation, reconciliation, and exception-handling processes. People Leadership Provide technical guidance and leadership to junior developers. Provide data architecture recommendations, project team leadership, technology vision, and detailed estimates. Core technical stack: Data Platform and Engineering Microsoft/Azure: Azure Data Warehouse, Azure SQL Database / Synapse, Azure Data Factory, Azure Functions, SQL Server, T-SQL, SSIS Data & engineering tools: DevOps, Databricks AI and Advanced Analytics Enablement Python, NumPy, Pandas, PyArrow AI/LLM tools: OpenAI, LangChain, LlamaIndex, AI tools, Vector Database About You 10+ years of progressive experience as a Data Solutions and AI Engineer using current and emerging data technologies and approaches, including 7+ years on the Microsoft platform. 7+ years designing and building large applications using SQL Server and related database technologies. 7+ years experience with physical and cloud database design 7+ years experience migrating code, database changes, data, and menus through the software development lifecycle. 2+ years experience designing, developing, and deploying AI/ML-powered applications and cloud data solutions. 2+ years experience with NLP, entity resolution algorithms, Graph RAG, ontology, and distributed systems 4+ years experience with CI/CD pipelines and deployment tools 2+ years experience developing search, retrieval, recommendation, or knowledge management solutions. 2+ years experience with microservices, event-driven architectures, and containerized applications 3+ years experience working with C#, .NET, REST APIs, and modern application architecture to support integration and solution development. 5+ years strong understanding of database and application performance tuning Experience in Snowflake and Microsoft Fabric a plus Bachelor’s degree in computer science, Engineering, or a related field Strong communication skills with management, development teams, vendors, systems administrators, and other service providers Required: Typically requires a University Degree and minimum 7 years of prior relevant experience, or equivalent experience. You are a strong communicator and an active listener. A passion for technology Deep technical understanding of all things data Ability to lead a project team Ability to paint a technology vision and communicate its value Ability to create detailed estimates for planned technology activities. A disciplined approach to your work life and your craft Stay current with emerging data engineering and AI technologies. 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)

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.