Senior Consultative Analyst

Gallagher; Rolling Meadows (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Gallagher Bassett in Rolling Meadows, IL is seeking a senior consultative analyst to execute quantitative analysis, build KPI dashboards, and deliver actionable insights for a major carrier client.

The role requires advanced SQL and Excel, collaboration with Client Services, Claims Operations, and executive teams, and the ability to translate data into strategic recommendations while balancing tight timelines.

Qualifications

• Bachelor's degree and a minimum of 3 years professional experience with quantitative analysis.
• Ability to use Intermediate to expert level skills in SQL and Excel to analyze and convert complex data into meaningful insights

Responsibilities

• Action-Oriented Performance Monitoring: develop custom reports / KPI dashboards which drive actionable insights
• Package insights from analyses into highly polished presentations for internal and external stakeholders and/or executive team
• Deep Dive / Root Cause Analysis: conduct hypotheses driven, exhaustive analyses of metrics with material variance vs. historical trends and/or benchmarks
• Analyses will deliver targeted recommendations and actions
• Bespoke Analysis and Reporting: expedited delivery of reports and answers to ad-hoc questions
• Expert help with optimizing and configuring client’s risk management information system
• Impact on Outcomes: translate analytical insights into actions that drive superior outcomes

Job description

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

As the dedicated senior consultative analyst for one of GB’s largest carrier clients, you will execute quantitative analysis to drive actionable insights. Your insights should identify performance gaps and hypotheses for root cause, leading to specific action plans to capitalize on opportunities. You will work very closely with Client Services, Claims Operations, as well as the Client’s analytics team and our internal executive team. You will be responsible for developing and maintaining appropriate scorecards and reports to track this client’s claims and operational performance, including packaging of monthly insights for an executive report out. The ideal candidate will be able to juggle numerous inflight asks with a short timeline and communicate expectations effectively with internal and external stakeholders across the organization. Intermediate to expert level skills in SQL and Excel are essential for analyzing and transforming complex data into meaningful insights, presenting the findings clearly, and identifying strategic next steps to effectively influence outcomes. In addition, you will be required to streamline processes and automate reporting where applicable.

Essential responsibilities

• Action-Oriented Performance Monitoring:
  • In collaboration with the client, and internal teams, develop custom reports / KPI dashboards which drive actionable insights
  • Package insights from analyses into highly polished presentations for internal and external stakeholders and/or executive team
• Deep Dive / Root Cause Analysis:
  • Conduct hypotheses driven, exhaustive analyses of metrics with material variance vs. historical trends and/or benchmarks
  • Analyses will deliver targeted recommendations and actions
• Bespoke Analysis and Reporting:
  • Expedited delivery (often same day) of reports and/or answers to ad-hoc questions
  • Expert help with optimizing and configuring client’s risk management information system
• Impact on Outcomes:
  • Close connection with both Gallagher Bassett Client Services and Claims Operation to translate analytical insights into actions that drive superior outcomes

About You

Required

• Bachelor's degree and a minimum of 3 years professional experience with quantitative analysis.
• Less than 20% travel.
• Minimum of 4 years professional experience with quantitative analysis
• Ability to use Intermediate to expert level skills in SQL and Excel to analyze and convert complex data into meaningful insights

Work Traits

• Critical Thinking, Complex Problem Solving, Deductive Reasoning, Mathematical Reasoning, Excellent Judgment & Decision Making skills, and Excellent Communication 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)