Senior Consultative Analyst

Gallagher • Rolling Meadows, IL

1d

About The Position

As the dedicated senior consultative analyst for one of Gallagher Bassett’s largest carrier clients, this role executes quantitative analysis to produce actionable insights, identify performance gaps and root-cause hypotheses, and recommend specific action plans. The analyst works closely with Client Services, Claims Operations, the client’s analytics team, and Gallagher Bassett’s internal executive team.

The position develops and maintains scorecards and reports tracking claims and operational performance, and packages monthly insights for executive presentations. It also handles short-deadline requests, communicates expectations with internal and external stakeholders, and streamlines processes and automates reporting where appropriate. The role requires intermediate-to-expert SQL and Excel skills to analyze and transform complex data, clearly present findings, and influence strategic next steps.

Requirements

• Bachelor’s degree.
• At least 4 years of professional experience with quantitative analysis.
• Intermediate-to-expert SQL skills.
• Intermediate-to-expert Excel skills.
• Ability to analyze and convert complex data into meaningful insights.
• Critical thinking, complex problem solving, deductive reasoning, and mathematical reasoning.
• Excellent judgment, decision-making, and communication skills.
• Ability to manage multiple concurrent requests with short timelines and communicate expectations effectively.

Responsibilities

• Develop custom reports and KPI dashboards in collaboration with the client and internal teams to drive actionable insights.
• Package analytical findings into polished presentations for internal and external stakeholders and executive teams.
• Conduct hypothesis-driven, exhaustive analyses of metrics showing material variance against historical trends or benchmarks.
• Provide targeted recommendations and action plans based on analyses.
• Deliver expedited reports and answers to ad hoc questions, often on the same day.
• Help optimize and configure the client’s risk management information system.
• Work with Client Services and Claims Operations to translate analytical insights into actions that improve outcomes.
• Develop and maintain scorecards and reports tracking claims and operational performance, including monthly executive reporting.
• Streamline processes and automate reporting where applicable.

Benefits

• Competitive compensation.
• Comprehensive benefits programs designed to support well-being.
• Career development opportunities and ongoing learning.
• Collaborative, people-first culture with accessible leadership.
• Opportunity to do meaningful work with global reach and local impact.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior