M

Marsh

Global insurance brokerage and risk advisory

Junior Automation Analyst - HR / People Analytics

Business IntelligencePosted on Nov 12
Full-timeBogotá, Bogota, ColombiaNo salary listed

About the Job

Requirements

  • Have technical or technological training.
  • Have at least 1 year of experience as a data analyst, automation analyst, or robotic process automation analyst.
  • Have very good Excel skills, including data management, information matching, pivot tables, and Power Query, and strong Power BI skills.
  • Have intermediate knowledge of Python, Power Query, Power BI, and Power Platform.
  • Have intermediate English, with good reading comprehension.

Responsibilities

  • Respond promptly to daily requests from the HR team and support business needs.
  • Keep internal platforms updated with key information and reliable operational records related to people data.
  • Consolidate, clean, and manage HR information, including salaries, gaps, trends, and workforce indicators, ensuring quality, consistency, and traceability.
  • Create and maintain interactive dashboards and reports in Power BI to monitor People/HR indicators.
  • Analyze data to identify trends, risks, and opportunities, and propose concrete actions to improve processes and decisions.
  • Collaborate with regional teams to define requirements, design solutions, and ensure implementation of data quality and governance best practices.
  • Run automation and improve reporting and data-update processes using advanced Excel, Power Query, Power BI, and Power Platform.
  • Develop automation solutions using tools such as Python and/or Power Platform to optimize repetitive processes.

Desired Qualifications

  • Previous experience supporting People Analytics initiatives, including salaries, gaps, trends, and HR key performance indicators.
  • Experience supporting process automation in regional or shared-services environments.
  • Agility in adapting to change, innovation, and continuous improvement.

About the Company

Marsh

Global insurance brokerage and risk advisory

Marsh helps organizations manage risk and obtain insurance by acting as a risk adviser and broker, placing coverage with multiple underwriters rather than from a single source. It has grown into a diversified professional services firm that includes Mercer, Guy Carpenter, and Oliver Wyman, all under one holding company. Unlike traditional brokers, Marsh combines risk transfer with advisory and consulting services across insurance, reinsurance, HR, and management consulting. Its goal is to lower clients’ financial risk and total cost of risk by offering integrated risk management and advisory solutions.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1871

Recently Posted Jobs

Explore more opportunities at Marsh

See more jobs