Specialist Business Intelligence

Arthur J. Gallagher & Co. (AJG); Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits programs

Career development opportunities

Collaborative, people-first culture

Global reach with local impact

Job summary

Arthur J. Gallagher & Co. (AJG) in India seeks a Lead Specialist Business Intelligence to drive complex data analytics projects, design advanced data models, and mentor a team of 6–10 BI analysts.

You will deliver dashboards and reports that enable data-driven decisions for clients and internal stakeholders. The role centers on Power BI and SQL, translating business requirements into scalable solutions, maintaining standards, and fostering a high-performance culture across cross-functional teams

Qualifications

• End-to-end business intelligence and analytics delivery.
• Advanced Power BI development and dashboard design.
• Strong SQL querying, data analysis, and validation skills.
• Ability to translate business requirements into actionable insights.
• Team leadership and people management (6-10 members).
• Stakeholder and client requirement management.
• Clear verbal, written, and data storytelling communication.
• Critical thinking and structured problem-solving skills.
• Process improvement and analytics innovation mindset.

Responsibilities

• Lead multiple BI and data analytics projects simultaneously, owning delivery end to end.
• Translate business and client requirements into scalable reporting and analytics solutions.
• Design, build, and maintain dashboards, reports, and metrics primarily using Power BI and SQL.
• Mentor teams of 6-10 BI analysts/developers.
• Motivate team members and foster a high-performance, collaborative culture.
• Conduct technical and functional training for team members (Power BI, SQL, analytics best practices).
• Support team members’ technical and non-technical skill development.
• Perform advanced data analysis to generate actionable insights that drive business value.
• Documentation and Reporting Standards: Maintain comprehensive documentation of Power BI solutions, including data models, report specifications, and user guides.

Skills

End-to-end BI analytics delivery

Power BI development

Dashboard design

SQL querying and data analysis

Translate business requirements into I

Team leadership

Stakeholder management

Data storytelling

Critical thinking

Education

Bachelor's degree

Any technical graduation

Tools

Power BI

SQL

Job description

Introduction

Welcome to Gallagher in India - where expertise, technology, and purpose come together. Since 2006, Gallagher in India has supported global teams by delivering quality, service, and speed through deep expertise, smart technology, and specialized knowledge services. More than just an operations center, it's a place where careers grow through collaboration, continuous learning, and purposeful work. We drive efficiency, compliance, and innovation so our teams can focus on serving clients. If you enjoy solving problems and working with purpose, Gallagher is the place where you can grow and feel a sense of belonging.

Overview

A Lead Specialist Business Intelligence at Arthur J. Gallagher leads complex data analysis projects, providing strategic insights to drive business growth. They design advanced data models, create sophisticated reports, and mentor junior analysts. Collaborating with cross-functional teams, they ensure data-driven decision-making aligns with organizational goals, enhancing client solutions and operational efficiency.

How you'll make an impact

Responsibilities:

• Lead multiple BI and data analytics projects simultaneously, owning delivery end to end.


• Translate business and client requirements into scalable reporting and analytics solutions.


• Design, build, and maintain dashboards, reports, and metrics primarily using Power BI and SQL.


• Mentor teams of 6-10 BI analysts/developers.


• Motivate team members and foster a high-performance, collaborative culture.


• Conduct technical and functional training for team members (Power BI, SQL, analytics best practices).


• Support team members’ technical and non-technical skill development.


• Perform advanced data analysis to generate actionable insights that drive business value.


• Documentation and Reporting Standards: Maintain comprehensive documentation of Power BI solutions, including data models, report specifications, and user guides.

About you

Qualifications:

• Minimum Required Degree: Bachelor's degree


• Preferred Degree: Any technical graduation

Certificate(s)/Special Training:

• Microsoft Certified: Power BI Data Analyst Associate

Experience (Career Level Guide):

• Mid-Level (5+ Years)

Knowledge, Skills, and Ability

• End-to-end business intelligence and analytics delivery


• Advanced Power BI development and dashboard design


• Strong SQL querying, data analysis, and validation skills


• Ability to translate business requirements into actionable insights


• Team leadership and people management (6-10 members)


• Stakeholder and client requirement management


• Clear verbal, written, and data storytelling communication


• Critical thinking and structured problem-solving skills


• Process improvement and analytics innovation mindset

Additional Information

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)