Lead, Workforce Forecasting & Analysis

Mercer; Philippines; Hybrid; PHP 1,339,000 - 2,009,000; Full time

Job summary

Marsh is seeking a Team Lead - Workforce Management for our Manila-based hybrid role at MMB Operations. You will ensure service delivery by forecasting, reporting and workforce insights, with at least three in-office days weekly.

You will guide a small team, analyze capacity and performance, and provide data-driven recommendations to leaders. The ideal candidate has 5–7 years in workforce management, hands-on SQL and Power BI, advanced Excel (VBA/macros), and experience in forecasting and

Qualifications

• 5–7 years of workforce management experience.
• Hands-on experience with SQL and Power BI.
• Experience in real-time adherence, scheduling, capacity planning or forecasting.
• Advanced Excel skills including VBA or macro development and template creation.
• Well-developed time management skills with the ability to meet deadlines.
• Effective interpersonal skills and a collaborative, team-oriented approach.
• Experience leading or supporting a small team.

Responsibilities

• Analyse production volume, arrival patterns and workforce trends to support planning and service delivery.
• Create and update reports used for forecasting, capacity planning and scheduling.
• Work with the Workforce Manager to produce locked forecasts and support workforce planning activities.
• Monitor employee performance, schedules and real-time productivity through regular reporting.
• Prepare daily, weekly and monthly reports and share data and recommendations with leaders by agreed deadlines.
• Consolidate staffing information, including vacation and sick leave data, to support business needs.
• Communicate KPI performance and productivity trends to operational leaders.
• Support and guide a small team as needed.

Skills

Time management

Interpersonal skills

Team leadership

Tools

SQL

Power BI

Excel VBA

Job description

Marsh is seeking a Team Lead - Workforce Management for our Manila-based hybrid role at MMB Operations. You will ensure service delivery by forecasting, reporting and workforce insights, with at least three in-office days weekly.

You will guide a small team, analyze capacity and performance, and provide data-driven recommendations to leaders. The ideal candidate has 5–7 years in workforce management, hands-on SQL and Power BI, advanced Excel (VBA/macros), and experience in forecasting and