A

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Manager Business Intelligence

Business IntelligenceConfirmed live in the last 24 hours
Full-timeBengaluru, Karnataka, IndiaNo salary listedIn-person

About the Job

Requirements

  • A bachelor's degree in a relevant discipline is required.
  • A preferred bachelor's or master's degree in Computer Science, Information Technology, Data Analytics, Statistics, Mathematics, Engineering, Business Analytics, or a related quantitative discipline.
  • Advanced SQL capability, including complex joins, subqueries, common table expressions, aggregations, window functions, performance tuning, data extraction, validation, and troubleshooting.
  • 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.
  • 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.
  • Strong ownership, attention to detail, commercial awareness, curiosity, problem-solving ability, and commitment to reliable delivery in a global stakeholder environment.

Responsibilities

  • Translate business priorities into a practical BI roadmap and lead the design, development, validation, release, and ongoing support of dashboards, semantic models, management information, KPI frameworks, and analytical products.
  • 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.
  • 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.
  • 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.
  • Partner with senior business and CDO stakeholders to define KPIs, clarify requirements, communicate insights, manage expectations, and ensure BI products support measurable business decisions.
  • Mentor analysts through design reviews, pair problem-solving, coaching, knowledge sharing, and feedback; set standards for SQL, DAX, modelling, visualisation, documentation, testing, and deployment.
  • 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.
  • 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.

Desired Qualifications

  • 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.
  • Prior experience coordinating the work and development of a small team; formal people-management experience is desirable but not essential.
  • Experience in BFSI, insurance, consulting, shared services, or global capability centre environments.
  • Exposure to Microsoft Fabric, Azure Data Services, Snowflake, Databricks, Python, Power Automate, Collibra, Alation, Informatica, Tableau, or similar platforms.

About the Company

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Arthur J. Gallagher & Co. is a global insurance brokerage and risk management firm. It helps businesses, public entities, and individuals manage risk and obtain insurance through three segments: brokerage, risk management, and corporate. The brokerage unit offers a full range of retail and wholesale insurance brokerage and consulting services to match clients with coverage. The risk management unit handles contract claim settlements, claim administration, loss control consulting, and risk management information services to reduce exposures. The corporate unit oversees the company’s clean energy and other investments. The firm differentiates itself by providing end-to-end risk solutions across insurance placement, claims handling, risk counseling, and investment activities, rather than focusing on a single service. Its goal is to help clients manage risk effectively, protect assets, and pursue value through diverse investments, including clean energy.

Company size
10,001+
Company stage
IPO
Headquarters
Itasca, IL
Founded
1927

Recently Posted Jobs

Explore more opportunities at Arthur J. Gallagher & Co.

See more jobs