Organizational Design Data Analyst

Arthur J. Gallagher & Co. (AJG); Medellín; Presencial; COP 60.000.000 - 90.000.000; Jornada completa

Descripción de la vacante

Gallagher is seeking a Workforce Analytics Specialist to turn workforce data into clear insights for organizational design, planning, and M&A integration. You’ll partner with HR, Finance, and business leaders to keep data reliable and build actionable reports in HRIS, Power BI, and Tableau.

You’ll develop dashboards and run recurring analyses on headcount, attrition, and workforce movement, helping leaders make informed decisions in a global, matrixed environment.

Formación

• 3 to 5 years of experience in workforce analytics or a similar analytical role.
• 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 in simple terms in updates.
• Ability to work independently in a global, matrixed environment.
• Bachelor's degree in statistics, data analytics, industrial/organizational psychology, human resources, economics, business analytics, information systems, or a related field.

Responsabilidades

• Turn workforce data into clear insight for organizational design and planning.
• Build dashboards and reports for HR leadership and stakeholders.
• Support org analytics for mergers, acquisitions, restructures, and transformations.
• Ensure data reliability and explain numbers in plain language.

Conocimientos

Data analysis

Excel

Power BI

Tableau

Stakeholder communication

Educación

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

Herramientas

OrgVue

Power BI

Tableau

Excel

HRIS

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.