Forecasting & Reporting Analyst

Johnson & Johnson Innovation; Taguig; On-site; PHP 600,000 - 900,000; Full time

Job summary

Johnson & Johnson Innovation in the Philippines seeks a Forecasting & Reporting Analyst who owns end-to-end reporting and forward-looking forecasts to enable data-driven decisions. The role blends insights, analytical modeling, dashboard development, and lightweight data engineering to automate recurring reporting and forecasting.

The ideal candidate balances technical skills (SQL, BI tools, scripting) with business sense and communication, ensuring forecasts and reports are reliable, auditable,

Qualifications

• 5+ years experience in Workforce Management, particularly forecasting and scheduling.
• Detailed understanding of key systems impacting contact center operations.
• Highly organized with strong attention to detail, highly self-motivated.
• Advanced skills in forecasting and scheduling applications like Genesys Cloud, IEX, Aspect, Verint and similar tools.
• 3+ years experience creating reports and dashboards for insights.
• Demonstrated strong analytical skills with emphasis on forecasting & scheduling.
• Willingness to learn new software applications.
• Strong problem solving, judgement, critical thinking and decision making.
• Ability to be highly organized with accuracy and timeliness.
• Ability to work well with a team.

Responsibilities

• Create daily, weekly, monthly forecasts for multiple sites/work groups.
• Develop, maintain, and automate simple dashboards for internal use and scheduled reports.
• Update and publish forecast, staffing requirements and projected performance.
• Provide recommendations to improve group performance.
• Meet with WFM team/stakeholders to discuss projections and performance.

Skills

Forecasting

Scheduling

Advanced Excel

SQL

Power BI

Data Analysis

Genesys Cloud

IEX

Aspect

Verint

Problem Solving

Teamwork

Tools

Genesys Cloud

IEX

Aspect

Verint

Power BI

SQL

Job description

At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions 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