People & Workforce Analytics Analyst

Arthur J. Gallagher & Co. (AJG); Bogotá ciudad; Presencial; COP 60.000.000 - 90.000.000; Jornada completa

Descripción de la vacante

Gallagher is seeking an experienced Workforce Analytics specialist in Bogotá to transform people data into actionable insights. You will partner with HR, Finance, and IT to build reliable dashboards and reports that executives rely on for workforce decisions.

You’ll leverage HRIS data, Excel, Power BI, and Tableau to analyze headcount, attrition, and organizational design, while ensuring data quality and governance in a global, matrixed environment.

Formación

• 3–5 years of experience in workforce analytics or similar analytical HR roles.
• Experience with HRIS data and employee master data.
• Proficient in Excel for data analysis and reporting.
• Experience creating dashboards in Power BI or Tableau.
• Ability to explain complex data clearly in presentations and written updates.
• Comfort working in a global, matrixed environment with HR, Finance and IT stakeholders.
• Bachelor's degree in statistics, data analytics, or related field.

Responsabilidades

• Analyze workforce data to identify trends, risks, and opportunities.
• Build and maintain dashboards and reports for HR leadership and stakeholders.
• Ensure data quality: extract, validate, cleanse, transform, and reconcile HRIS data.
• Contribute to organizational analytics for mergers, acquisitions, restructures, and transformations.
• Collaborate with Organizational Design and HR teams to monitor changes and risks.

Conocimientos

Workforce analytics

HRIS

Excel

Power BI

Tableau

Data storytelling

Stakeholder collaboration

Educación

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

Herramientas

OrgVue

Power BI

Tableau

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.