Manager - Business Intelligence

Gallagher; Bengaluru; On-site; INR 4,500,000 - 6,000,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits programs

Career development opportunities and O

Collaborative, people-first culture

Job summary

Gallagher in India seeks an experienced Manager, Business Intelligence to lead scalable BI solutions for GBS Digital Delivery. You will model data, build trusted reporting, and deliver actionable insights while mentoring a small team.

Role combines hands-on SQL, semantic modelling, and Power BI, with governance and collaboration across data owners and product leaders to improve data reliability and business value.

Qualifications

• Advanced SQL with complex joins, CTEs, and window functions.
• Experience with dimensional and semantic data modelling.
• Proficient in Power BI, DAX, and data visualisation best practices.
• Ability to define BI architecture and governance standards.
• Experience delivering dashboards and analytical products end-to-end.
• Understanding of data quality, profiling, and lineage.

Responsibilities

• Lead BI strategy, design dashboards, semantic models and KPI frameworks.
• Govern data models including fact/dimension design and star schemas.
• Collaborate with data engineers to optimise pipelines and performance.
• Establish data quality controls and validate BI outputs.
• Partner with stakeholders to define KPIs and drive insights.
• Mentor analysts and provide light-touch team supervision.
• Document governance, metadata, and data dictionaries.

Skills

Advanced SQL

Dimensional data modelling

Semantic modelling

Power BI

Data governance

Stakeholder management

Mentoring

Data quality

DAX

Leadership

Education

Bachelor’s degree in a relevant discipline

Bachelor’s or Master’s in CS/IT/Data Analytics or related

Tools

Microsoft Fabric

Azure Data Services

Snowflake

Databricks

Python

Power Automate

Collibra

Alation

Informatica

Tableau

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

The Manager, Business Intelligence will lead the design and delivery of scalable BI solutions for GBS Digital Delivery, with primary accountability for robust data modelling, trusted reporting, and actionable insight. The role combines hands-on technical leadership in SQL, semantic and dimensional modelling, Power BI, data quality, and governance with mentoring of analysts and limited day-to-day people-management responsibilities for a small team. The Manager will establish modelling and reporting standards, review solution quality, allocate work, support development objectives, and partner with Data Owners, Data Stewards, Product Owners, Data Engineers, and business leaders to improve the reliability and business value of critical data assets.

How you'll make an impact

Responsibilities:

• BI Strategy and Delivery Leadership: Translate business priorities into a practical BI roadmap; lead the design, development, validation, release, and ongoing support of dashboards, semantic models, management information,
• KPI frameworks, and analytical products.
• Data Modelling and Architecture: Design and govern dimensional, relational, and semantic data models, including facts, dimensions, star schemas, measures, hierarchies, relationships, calculation logic, naming standards, and reusable datasets that support scalable self-service analytics.
• SQL and Data Engineering Collaboration: Write and review complex SQL; define transformation and integration requirements; and work with Data Engineers to optimise source-to-report pipelines, model performance, refresh reliability, and data availability.
• Data Quality and Model Assurance: Establish validation and reconciliation controls for data models and BI outputs; investigate anomalies and defects; lead root cause analysis; and ensure completeness, accuracy, consistency, timeliness, uniqueness, and validity.
• Reporting, Insight and Stakeholder Partnership: Partner with senior business and CDO stakeholders to define KPIs, clarify requirements, communicate insights, manage expectations, and ensure BI products support measurable business decisions.
• Technical Leadership and Mentoring: Mentor analysts through design reviews, pair problem-solving, coaching, knowledge sharing, and feedback; set standards for SQL, DAX, modelling, visualisation, documentation, testing, and deployment.
• Small-Team People Management: Provide light-touch supervision for a small BI team, including work allocation, priority setting, regular check-ins, objective setting, development support, leave and capacity coordination, and timely escalation of formal people matters.
• Governance, Documentation and Continuous Improvement: Maintain model documentation, lineage, business definitions, data dictionaries, SOPs, release records, and control evidence; promote reusable assets, automation, governed self-service BI, and continuous improvement.

About you

Qualifications

• Minimum Required Degree: Bachelor’s degree in a relevant discipline
• Preferred Degree: Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Analytics, Statistics, Mathematics, Engineering, Business Analytics, or a related quantitative discipline

Certificate(s)/Special Training

• Preferred certification or training in Power BI, data modelling, Microsoft Fabric, Azure, SQL, data architecture, data quality, data governance, leadership, coaching, or equivalent platforms and practices

Experience (Career Level Guide)

• Manager Level: 10 to 15 years of progressive experience in business intelligence, analytics, SQL, dimensional or semantic data modelling, dashboard delivery, data validation, or data governance, including demonstrated technical leadership and mentoring. Prior experience coordinating the work and development of a small team is preferred; formal people-management experience is desirable but not essential. Experience in BFSI, insurance, consulting, shared services, or global capability centre environments is preferred.

Knowledge, Skills and Ability

• Advanced SQL capability, including complex joins, subqueries, common table expressions, aggregations, window functions, performance tuning, data extraction, validation, and troubleshooting
• Demonstrated expertise in dimensional, relational, and semantic data modelling, including star schemas, fact and dimension design, grain, keys, slowly changing dimensions, hierarchies, relationships, reusable measures, and model governance
• Advanced Power BI capability covering semantic models, DAX, Power Query, row-level security, deployment practices, performance optimisation, refresh management, KPI design, and governed self-service BI
• Ability to define BI architecture and modelling standards, conduct design and code reviews, assess technical trade-offs, and guide scalable, maintainable solution design
• Experience leading dashboard, management-information, and analytical-product delivery from requirements and data discovery through testing, release, adoption, and support
• Strong understanding of data quality dimensions, profiling, reconciliation, control design, exception reporting, root cause analysis, issue management, and model assurance
• Working knowledge of data governance concepts including ownership, stewardship, metadata, business glossaries, lineage, Critical Data Elements, controls, access, and audit evidence
• Proven mentoring and coaching skills, with the ability to build analyst capability through feedback, knowledge sharing, pair problem-solving, and structured development support
• Ability to provide light-touch people management for a small team, including work allocation, prioritisation, regular check-ins, capacity planning, objective setting, and appropriate escalation
• Strong stakeholder-management and communication skills, including the ability to influence senior technical and non-technical audiences and translate business needs into clear BI outcomes
• Exposure to Microsoft Fabric, Azure Data Services, Snowflake, Databricks, Python, Power Automate, Collibra,
• Alation, Informatica, Tableau, or similar platforms is desirable
• Strong ownership, attention to detail, commercial awareness, curiosity, problem-solving ability, and commitment to reliable delivery in a global stakeholder environment

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)