Organizational Design Data Analyst

Gallagher; Bogotá ciudad; Presencial; Confidencial; Jornada completa

Descripción de la vacante

Gallagher is seeking a Workforce Analytics Specialist in Bogotá to turn workforce data into insights that inform organizational design and planning. You’ll partner with Organizational Design, HR, Finance, and business leaders to ensure data reliability and to create actionable reporting for leadership.

You will build dashboards in Power BI/Tableau, manage data quality across HRIS, and support mergers, restructures, and talent integration.

Formación

• 3–5 years of experience in workforce analytics or a similar analytical role.
• Experience with HRIS data and employee master data.
• Proficient in Excel for analyzing data and building reports.
• Experience creating dashboards/visualizations in Power BI or Tableau.
• Ability to explain complex data in clear presentations and updates.
• Ability to work independently in a global, matrixed environment.
• Bachelor’s degree in statistics, data analytics, or related field.

Responsabilidades

• Analyze workforce data to spot trends, risks, and opportunities across headcount, attrition, spans of control, and workforce mix.
• Build and maintain dashboards, scorecards, and visualizations in HRIS/Power BI/Tableau.
• Create recurring and ad hoc reports for HR leadership and business stakeholders.
• Support org design, M&A integration, restructures, and enterprise transformations.
• Ensure data quality by extracting, validating, cleansing, transforming, and reconciling HRIS data.

Conocimientos

Data storytelling

Stakeholder collaboration

Independent work

Global/matrix environment

Presentations

Educación

Bachelor's degree in statistics, data analytics, industrial/organizational psychology, HR, economics, business analytics, information systems or related field

Herramientas

Power BI

Tableau

Excel

Descripción del empleo

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

You’ll turn workforce data into clear insight that helps shape organizational design, workforce planning, M&A integration, and broader people analytics work. In this role, you'll partner with Organizational Design, HR, Finance, and business leaders to keep data reliable, build reporting that people can use, and explain what the numbers mean in plain language. You'll be part of work that helps colleagues make informed decisions and improve organizational effectiveness.

How You’ll Make An Impact

You’ll analyze workforce data to spot trends, risks, and opportunities across headcount, attrition, spans of control, workforce mix, organizational effectiveness, and talent movement. You’ll build and maintain dashboards, scorecards, and visualizations in HRIS, OrgVue, Power BI, Tableau, or similar tools, and you’ll create recurring and ad hoc reports for HR leadership and business stakeholders.

You’ll also support organizational analytics work for mergers, acquisitions, restructures, and enterprise transformation. That means helping with org structure models, reporting structures, workforce scenarios, health checks, and analysis of workforce impacts, synergy capture, and talent integration. You’ll work closely with Organizational Design and HR teams to assess options, track changes over time, and highlight implementation risks.

Data quality is a big part of the role too. You'll extract, validate, cleanse, transform, and reconcile HRIS data, then help keep workforce data consistent across reporting systems. You'll also partner with HR, Finance, and IT colleagues to support data governance and improve reporting methods.

About You

• You have 3 to 5 years of experience in workforce analytics, people analytics, HRIS, organizational effectiveness, organizational design analytics, or a similar analytical role.
• You have worked with HRIS data and employee master data.
• You use Excel to analyze workforce data and build reports.
• You have created dashboards and visualizations in Power BI, Tableau, or a similar platform.
• You can explain complex data in simple terms in presentations and written updates.
• You can work independently in a global, matrixed environment.
• You can work with HR, Finance, IT, and business stakeholders to gather information and keep work moving.
• You have a bachelor's degree in statistics, data analytics, industrial/organizational psychology, human resources, economics, business analytics, information systems, or a related field.