Workforce Analyst_Hybrid BGC_100K

weSource Management Consultancy Firm; Taguig; Hybrid; PHP 1,015,560 - 1,216,440; Full time

Job summary

A recruitment consultancy is seeking a Workforce Analyst to work in a hybrid environment in Taguig, Philippines. The role involves leading forecasting and capacity planning initiatives, requiring at least 3 years of experience in reporting, and expertise in MS Excel and Power BI. Candidates should possess strong analytical skills and be able to manage stakeholder relationships effectively. This position offers a salary of up to 100K PHP and will allow for both independent and team collaboration in a dynamic work setting.

Qualifications

• Minimum 3 years of relevant experience in reporting, forecasting, and capacity planning.
• Experience in a BPO company is an advantage.
• Strong proficiency in Excel and familiarity with Power BI.

Responsibilities

• Lead data collection for forecasting and capacity planning.
• Standardize forecasting methods and tools.
• Communicate with teams to understand factors impacting forecasts.
• Review forecasts and capacity plans regularly.
• Generate capacity plans and reports with insights for optimization.

Skills

Strong analytical and quantitative skills.

Strong communication and presentation skills.

Effective collaboration and problem-solving skills.

Ability to create visualizations and dashboards.

Hands-on experience in forecasting and planning.

Ability to manage multiple stakeholders.

Proficiency in MS Office applications, especially Excel.

Interest in Power BI and reporting tools.

3+ years of reporting experience.

Tools

SQL

Python

SSIS

Power BI

MS Excel

Job description

About the job Workforce Analyst_Hybrid BGC_100K

We are hiring for a Workforce/Reporting Analyst for a client in BGC

This is a hybrid role and the salary is up to 100K

Main requirement is at least 3 years of relevant experience with background on reporting, forecasting and capacity planning ideally in a BPO company

Qualifications

The Requirements

• Strong analytical and quantitative skills.
• Strong communication and presentation skills.
• Effective collaboration and problem-solving skills.
• Ability to collect, organize, synthesize data and summarize findings into simple, compelling visualizations and dashboards.
• Hands-on experience in creating volume forecasts, capacity models and resource plans in a back-office BPO or Shared Services environment.
• Ability to work within tight deadlines; balancing time across multiple, simultaneous projects that may involve different procedures and project team members.
• Ability to work in a team as well as independently.
• Experience in managing multiple stakeholders and working across geographic boundaries, including taking accountability for quality and on-time delivery of own work and involving other team members when appropriate.
• Strong proficiency in MS Office applications, particularly PowerPoint and Excel.
• Interest in Power BI and similar reporting tools, and an enthusiasm to develop expertise in this area.
• 3+ years of reporting experience.

Preferred Skills

• Experience analyzing data and producing reports and dashboards using SQL, Python, SSIS, MS Excel and Power-BI.
• Experience in Power BI.
• Experience implementing and maintaining business-centered performance metrics across a diverse range of processes.
• Experience in operations forecasting, capacity modelling & planning.
• Understanding of developing stored procedures, functions, views and T-SQL programs. Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS, to extract the data from multiple source systems.
• Working knowledge of application QA & Testing procedures.
• Good documentation of End User Developed Applications.

Non-Negotiable:

• Capacity Planning, Forecasting, MS Excel

The Role

Forecasting and Capacity Planning

• Lead the collection of all historical data needed for trending, forecasting, and capacity planning volume, AHT, Service Level Targets, Shrinkage, and other factors. Trending needs to be provided down to the interval level or as aligned with business requirements.
• Standardize and document the methods to be used for forecasting and capacity planning. Develop and implement forecasting and capacity planning tools and templates. Provide training, consultative, and necessary support to GSD Leads, Regional Leads, and relevant stakeholders so they can properly adapt to these methodologies and templates.
• Based on trend, forecast the baseline volume, AHT, and shrinkage factors for a rolling period aligned with business requirements.
• Consult with all areas that could impact any of the components to forecasting and capacity planning (e.g. GSD Leads for seasonality, new product launches, etc. and Support Teams for training, recruitment, etc.)
• Review with GSD Leads, Regional Leads, and relevant stakeholders the forecasts and capacity plans at least once a month or as aligned with business requirements.
• Using the forecasted data, create a capacity plan for each GSD Team showing the FTE requirements to deliver all the services assigned to each respective team. Generate a report of this capacity plan with analysis, insights, and recommendations to optimize resources and discuss this with GSD Leads, Regional Leads, and relevant stakeholders at least once a quarter or as aligned with business requirements.