A

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Organizational Design Data Analyst

Business IntelligenceUpdated on Nov 10
Full-timeMedellín, Medellin, Antioquia, ColombiaNo salary listedIn-person

About the Job

Requirements

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

Responsibilities

  • Analyze workforce data to identify trends, risks, and opportunities across headcount, attrition, spans of control, workforce mix, organizational effectiveness, and talent movement.
  • Build and maintain dashboards, scorecards, and visualizations in human resources information systems, OrgVue, Power BI, Tableau, or similar tools.
  • Create recurring and ad hoc reports for human resources leadership and business stakeholders.
  • Support organizational analytics work for mergers, acquisitions, restructures, and enterprise transformation, including organizational structure models, reporting structures, workforce scenarios, health checks, and analysis of workforce impacts, synergy capture, and talent integration.
  • Work with Organizational Design and Human Resources teams to assess options, track changes over time, and identify implementation risks.
  • Extract, validate, cleanse, transform, and reconcile human resources information system data, and help maintain consistent workforce data across reporting systems.
  • Partner with Human Resources, Finance, and IT colleagues to support data governance and improve reporting methods.

About the Company

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Arthur J. Gallagher & Co. is a global insurance brokerage and risk management firm. It helps businesses, public entities, and individuals manage risk and obtain insurance through three segments: brokerage, risk management, and corporate. The brokerage unit offers a full range of retail and wholesale insurance brokerage and consulting services to match clients with coverage. The risk management unit handles contract claim settlements, claim administration, loss control consulting, and risk management information services to reduce exposures. The corporate unit oversees the company’s clean energy and other investments. The firm differentiates itself by providing end-to-end risk solutions across insurance placement, claims handling, risk counseling, and investment activities, rather than focusing on a single service. Its goal is to help clients manage risk effectively, protect assets, and pursue value through diverse investments, including clean energy.

Company size
10,001+
Company stage
IPO
Headquarters
Itasca, IL
Founded
1927

Recently Posted Jobs

Explore more opportunities at Arthur J. Gallagher & Co.

See more jobs