Senior Data Analyst

Gallagher•Rolling Meadows, IL

About The Position

At Gallagher Benefit Services, you’re a trusted partner to organizations navigating some of their most important people decisions. We help clients build better workplaces, where people feel supported, empowered, and inspired to thrive. Whether it’s shaping benefit strategies, designing wellbeing programs, or advising on workforce challenges, the work you do here creates meaningful change for businesses and the people who power them. We’re a community of bold explorers, trusted experts, and compassionate partners; working side by side to solve problems, and shape the future of work. Here, curiosity is encouraged, collaboration is second nature, and your ideas have room to grow. If you’re looking for a place where your contribution matters and where you can help build a better world of work; think of Gallagher. Overview As a Senior Data Analyst on the Drive team, you will lead end‑to‑end analytical workflows—from ingest and transformation (ETL) through modeling, visualization, and business storytelling—aligning with our standardized product lifecycle. This role is designed around the technical stack and patterns commonly leveraged by Drive analysts (e.g., Python, data processing, ETL, SQL, and BI tools).

Requirements

Bachelor's degree and a minimum of 1 year professional experience
Prior experience in a quantitative field, through internships or other consultative work, and/or demonstrated ability to perform independent quantitative analyses of a moderate to highly complex nature accepted in lieu of full experience
Less than 20% travel

Nice To Haves

Master's/MBA degree; Strong academic credentials
Proficient with Excel and PowerPoint, familiarity with Access or enterprise database programs a plus
Critical Thinking
Complex Problem Solving
Deductive Reasoning
Mathematical Reasoning
Excellent Judgment & Decision Making skills
Excellent Communication Skills

Responsibilities

Design, build, and maintain robust, testable ETL pipelines for diverse data sources feeding Drive; implement data quality checks, lineage, and documentation.
Contribute to the GBS Data & Analytics service areas (data engineering, reporting & analytics, financial reporting, applications) through cross‑team collaboration.
Partner with Gallagher Technical Services on release coordination, versioning, and environment dependencies tied to data governance.
Contribute to our data platform with an emphasis on modeling and stewardship of curated datasets used by Drive analytics.
Assist in knowledge capture aligned to clear narratives for commercial use cases
Develop dashboards and visual stories in Power BI, complemented by Python visualization (e.g., Matplotlib) as needed; ensure accuracy, usability, and adoption.
Present insights to stakeholders across sales, consulting, and client service; drive alignment on actions and measure business impact.
Uphold Gallagher’s data ethics and privacy standards.

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