Business Intelligence Manager

Gallagher; Bogotá; On-site; COP 120,000,000 - 210,000,000; Full time

Job summary

Arthur J. Gallagher & Co. (AJG) seeks a seasoned Business Intelligence Manager in Bogotá to lead a team delivering enterprise BI solutions.

You will guide design, development, and optimization of reporting using Power BI, SSRS, SQL, DAX, Power Query, and data modeling, partnering with stakeholders to translate requirements into impactful insights. You will also oversee architecture reviews, governance, and production support, while exploring AI-enabled tools to boost reporting productivity and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, BI, or related field.
• 10+ years 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.

Responsibilities

• 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 AI-enabled tools to improve reporting, analytics, and development productivity.

Skills

Power BI

SSRS

SQL

DAX

Power Query

Data modeling

AI analytics

Leadership

Enterprise reporting

Education

Bachelor's degree in Computer Science / Information Systems

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 is right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you will find more than a job; you will find a culture built on trust, driven by collaboration, and sustained by the belief that we are 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 will have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you are encouraged to be yourself, supported to succeed, and inspired to keep learning. That is what it means to live The Gallagher Way.

Overview

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

How you will make an impact

As a hands-on leader, you will guide a team of BI developers while actively contributing to the design, development, and optimization of enterprise reporting solutions. You will 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.