Business Intelligence Manager

Gallagher; Santiago; On-site; CLP 60,000,000 - 110,000,000; Full time

Job summary

Arthur J. Gallagher & Co. is seeking a Business Intelligence Manager to lead a team of BI developers and deliver enterprise-scale reporting solutions.

You will design and optimize data models, ETL/ELT pipelines, and semantic layers using Power BI, SSRS, SQL, DAX, and Power Query. You will collaborate with business stakeholders, technology teams, and leadership to translate requirements into actionable insights and drive governance and best practices across analytics projects.

Qualifications

• Bachelor's degree in CS/IS/Analytics or a related field.
• Advanced English proficiency.
• 10+ years delivering enterprise BI and reporting solutions.
• Advanced expertise in Power BI, SSRS, SQL, DAX, Power Query, and data modeling.

Responsibilities

• Lead and develop a team of Power BI and SSRS developers.
• Design, build, and support enterprise BI solutions.
• Develop and optimize SQL, DAX, Power Query, and semantic models.
• Work with SQL Server, Snowflake, Azure Synapse, and data platforms.
• Conduct architecture reviews, code reviews, and governance activities.
• Manage production support, incident resolution, and continuous improvement.

Skills

Advanced English

Leadership

BI strategy

AI in analytics

Education

Bachelor's degree in CS/IS/Analytics/BI

Tools

Power BI

SSRS

SQL

DAX

Power Query

Semantic models

SQL Server

Snowflake

Azure Synapse

CI/CD

Source control

Deployment automation

Governance

Job description

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.

Overview

At Gallagher, we believe data has the power to shape better business outcomes. We're looking for a Business Intelligence Manager who combines technical expertise, leadership capability, and a passion for transforming data into actionable insights. If you're a natural problem solver who enjoys developing people, influencing strategy, and delivering enterprise-scale reporting solutions, this could be your next opportunity.

How you'll make an impact

As a hands-on leader, you'll guide a team of BI developers while actively contributing to the design, development, and optimization of enterprise reporting solutions. You'll work closely with business stakeholders, technology teams, and leadership to deliver scalable, high-impact data solutions.

Key responsibilities include:

• Leading and developing a team of Power BI and SSRS developers.
• Designing, building, and supporting enterprise reporting and business intelligence solutions.
• Developing and optimizing SQL, DAX, Power Query, and semantic models.
• Working with SQL Server, Snowflake, Azure Synapse, and enterprise data platforms.
• Conducting architecture reviews, code reviews, and governance activities.
• Managing production support, incident resolution, and continuous improvement initiatives.
• Partnering with business stakeholders to translate requirements into meaningful insights.
• Leveraging emerging AI-enabled tools to improve reporting, analytics, and development productivity.

About you

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.
• Advanced English proficiency.
• 10+ years of experience delivering enterprise BI and reporting solutions.
• Advanced expertise in Power BI, SSRS, SQL, DAX, Power Query, and data modeling.
• Experience with SQL Server, Snowflake, Azure Synapse, and modern data architectures.
• Knowledge of CI/CD, source control, deployment automation, and development governance.
• Previous experience leading BI, analytics, reporting, or software development teams.
• Understanding of AI-enabled technologies and their application within analytics and reporting.
• Insurance or risk management industry experience is highly valued.