Senior Consultative Analyst

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

Benefits offered by this job

Competitive compensation

Comprehensive benefits programs

Career development opportunities

Collaborative, people-first culture

Job summary

Gallagher Bassett is seeking a Senior Consultative Analyst to drive quantitative insights for one of GB’s largest carrier clients. The role emphasizes developing scorecards and executive reports, with close collaboration across Client Services, Claims Operations, and internal analytics teams.

The ideal candidate will use advanced SQL and Excel skills to transform data into actionable insights, deliver timely analyses, and streamline reporting processes while aligning with organizational goals.

Qualifications

• Bachelor's degree and 3+ years of quantitative analysis experience.
• Willing to travel ≤20%.
• 4+ years of quantitative analysis experience.

Responsibilities

• Action-Oriented Performance Monitoring: develop custom reports/KPI dashboards.
• Deep Dive / Root Cause Analysis: conduct hypotheses-driven analyses with variance vs benchmarks.
• Bespoke Analysis and Reporting: deliver expedited reports and assist with client risk management system.
• Impact on Outcomes: translate insights into actions with client services and operations.

Skills

Quantitative analysis

Communication skills

Critical thinking

Education

Bachelor's degree

Tools

SQL

Excel

Job description

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.

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

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 include:

• 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)