Forecasting & Reporting Analyst

Johnson & Johnson Innovative Medicine; Taguig; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

Johnson & Johnson Innovative Medicine in Taguig seeks a Forecasting & Reporting Analyst to deliver end-to-end forecasting, reporting, and dashboard development for internal stakeholders. This role blends analytical modeling with lightweight data engineering to automate recurring reports and translate results into actionable recommendations.

The ideal candidate has strong SQL, BI tool skills, and business acumen, with experience in workforce forecasting, scheduling, and data visualization.

Qualifications

• 5+ years Experience in Workforce Management, particularly in Forecasting and Scheduling.
• Detailed understanding of key systems impacting contact center operations
• Very organized with strong attention to detail, highly self-motivated
• Advance skills in Forecasting and Scheduling applications like Genesys Cloud, IEX, Aspect, Verint
• 3+ years Experience creating reports and dashboards to help aid reporting and insights
• Demonstrated strong analytical skills, with emphasis on Forecasting & Scheduling
• Ability and willingness to learn new software applications
• Skills in complex problem solving, judgement, critical thinking and decision making
• Ability to be highly organized with an emphasis on accuracy and timeliness
• Ability to work well with a team

Responsibilities

• Create Daily, Weekly, Monthly Forecasts for multiple sites/work groups and publish schedules.
• Develop, maintain, and automate dashboards tracking KPIs related to demand, capacity, and performance.
• Update and publish forecast, staffing requirements and projected performance of GSCC.
• Provide recommendations to improve group performance.
• Meet with WFM team/stakeholders to discuss projections and performances.

Skills

Advanced Analytics

Analytical Reasoning

Data Reporting

Problem Solving

Cross-Functional Collaboration

Data Modeling

SQL

Power BI

Tools

Genesys Cloud

IEX

Aspect

Verint

Job description

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions are personal.Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow, and profoundly impact health for humanity.Learn more at jnj.com.

As guided by Our Credo, Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson, we respect the diversity and dignity of our employees and recognize their merit.

Job Function:

Data Analytics & Computational Sciences

Job Sub Function:

Business Intelligence

Job Category:

Professional

All Job Posting Locations:

Taguig, National Capital Region (Manila), Philippines

Job Description:

The Forecasting & Reporting Analyst owns the end-to-end delivery of timely, accurate reporting and forward-looking forecasts that enable data-driven decisions across the business. This role blends insights, analytical modeling, report/dashboard development for internal use, and lightweight data engineering to automate recurring reporting, maintain forecasting models, and translate results into clear recommendations for stakeholders. The ideal candidate balances technical skills (SQL, BI tools, scripting) with strong business sense and communication, ensuring forecasts and reports are reliable, auditable, and actionable.

Major Duties & Responsibilities

• Creation of Daily, Weekly, Monthly Forecasts for multiple sites / work groups. Creation/Adjustment of Schedules based on the forecasts created. Publishing of schedules, management of Time Off requests. Plotting and management of activities within the shift. Provide analysis, insight and recommendations for volume and performance impacting activities like announcements, launches, acquisition etc.
• Develop, maintain, and automate simple dashboards for internal use and scheduled reports that track KPIs related to demand, capacity, and schedule performance.
• Update, consolidate and publish forecast, staffing requirements and projected performance of GSCC.
• Give recommendations on how to improve the performance of the group.
• Meet with WFM Team/Stakeholders to discuss matters affecting the daily, weekly, monthly projections and performances.

Required Knowledge, Skills and Abilities

• 5+ years Experience in Workforce Management particularly in Forecasting and Scheduling
• Detailed understanding of key systems impacting contact center operations
• Very organized with strong attention to detail, highly self-motivated
• Advance skills in Forecasting and Scheduling applications like Genesys Cloud, IEX, Aspect, Verint and other applications of the same nature
• 3+ years Experience creating reports and dashboards to help aid reporting and insights
• Demonstrated strong analytical skills, with emphasis on Forecasting & Scheduling
• Ability and willingness to learn new software applications
• Skills in complex problem solving, judgement, critical thinking and decision making.
• Ability to be highly organized with an emphasis on accuracy and timeliness.
• Ability to work well with a team

Preferred Related Industry Experience (if applicable)

• Experience supporting a Shared Services environment and service center technologies
• Prior experience with Contact Center and CRM applications
• BPO Experience

Preferred Knowledge, Skills and Abilities

• Excellent Analytic and Problem Solving skills
• Needs to demonstrate flexibility, possible alternative work shifts and possible overtime
• Advance Microsoft Excel skills
• Advance skills in Forecasting and Scheduling applications like Genesys Cloud, IEX, Aspect, Verint and other applications of the same nature
• Intermediate to Advance SQL, Power BI experience (or any related application/program)

Required Skills:

Advanced Analytics, Analytical Reasoning, Business Behavior, Business Intelligence (BI), Cross-Functional Collaboration, Data Analysis, Data Integration, Data Modeling, Data Privacy Standards, Data Reporting, Detail-Oriented, Management Systems Implementation, Problem Solving, Process Oriented, Project Management, Statistical Analysis Systems (SAS) Programming, Workflow Analysis

Preferred Skills:

Advanced Analytics, Analytical Reasoning, Business Behavior, Business Intelligence (BI), Cross-Functional Collaboration, Data Analysis, Data Integration, Data Modeling, Data Privacy Standards, Data Reporting, Detail-Oriented, Management Systems Implementation, Problem Solving, Process Oriented, Project Management, Statistical Analysis Systems (SAS) Programming, Workflow Analysis