Business Intelligence Manager

Gallagher; Bogotá; On-site; Confidencial; Full time

Job summary

Gallagher in Bogotá is seeking a seasoned Business Intelligence Manager to lead a team of BI developers and deliver enterprise reporting solutions. You will design, build, and optimize data models and reporting using Power BI, SSRS, SQL, and DAX while partnering with stakeholders to translate requirements into actionable insights.

The ideal candidate has 10+ years in enterprise BI, strong leadership, and experience with SQL Server, Snowflake, and Azure Synapse, plus familiarity with AI-enabled

Qualifications

• Bachelor's degree in a relevant field.
• 10+ years delivering enterprise BI 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 governance.
• Previous experience leading BI, analytics, reporting, or software development teams.
• Understanding of AI-enabled technologies and their application within analytics.

Responsibilities

• Lead and develop a team of BI developers to deliver enterprise reporting solutions.
• Design, build, and optimize reporting platforms and data models.
• Collaborate with stakeholders to translate requirements into insights.
• Oversee governance, deployments, and production support.
• Utilize AI-enabled tools to improve reporting efficiency and insights.

Skills

Power BI

SSRS

SQL

DAX

Power Query

Data Modeling

Leadership

AI in analytics

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics

Tools

SQL Server

Snowflake

Azure Synapse

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.

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.
• 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.