Plan Administration - Administrator

Company:Mercer

Description:

We are seeking a talented individual to join our Workforce team at MMB Operations. This role will be based in Manila – Six/NEO. This is a hybrid role that has a requirement of working at least three days a week in the office.

The Workforce team, operating within the MMB Operations Department, plays a vital role in supporting business functions by delivering insightful and data-driven reports. They specialize in analyzing capacity and full-time equivalent (FTE) metrics, enabling MMB Operations to make strategic, high-impact decisions that drive operational efficiency and optimize resource allocation, and resource management.

We will count on you to:

• Analyzes actual production volume arrival and patterns
• Updates / creates reports necessary for forecasting and planning service delivery team capacity
• Reports all changes to adjust workforce game plan to meet operational business targets.
• Works with Workforce Manager in generating locked forecasts to support Service Delivery Team
• Monitors employee performance against work schedules and real-time productivity through reports
• Helps calculate resource projections to optimize staffing efficiencies by means of forecasting and scheduling
• Generates and analyzes daily, weekly, and monthly reports and provides data and recommendations to leaders by established deadlines.
• Communicate actual performance & productivity of employee KPIs to operational leaders to promote the achievement of KPI targets.
• Consolidate staffing reports (i.e. vacation, sick time) and communicate with colleagues and management to ensure business needs are supported.

What you need to have: 

• Must have a minimum of 2-3 years workforce management (WFM) related experience with hands-on in SQL and PowerBI platform.
• Required experience in either of the following skills: RTA (Real Time Adherence), Scheduling, Capacity Planning and Forecasting
• Mastery in MS Excel; reports automations (VBA and Macro) and template creation
• Good time management and adherence to timeline
• Highly motivated team player with good interpersonal skills

What makes you stand out?

• Proficiency in Microsoft Excel, including advanced functions and data analysis tools.
• Experience with Power BI or other business intelligence platforms for report creation and visualization.
• Basic understanding of workforce management concepts and capacity planning.

Why join our team: 

• We help you be your best through professional development opportunities, interesting work and supportive leaders. 
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being. 

Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn and X.

Marsh is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.