Forecasting And Reporting Analyst

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

Job summary

Johnson & Johnson Innovative Medicine in the Philippines is seeking a Forecasting & Reporting Analyst to own end-to-end forecasting, reporting, and lightweight data engineering for internal stakeholders in a fast-paced environment.

The role blends analytics and dashboard development with collaboration across the business, requiring strong SQL, BI skills, and experience with call center forecasting tools. The position offers an opportunity to impact planning and performance decisions.

Qualifications

• 5+ years in Workforce Management, especially forecasting and scheduling.
• Strong understanding of contact center operations systems.
• Excellent attention to detail and self-motivated.
• Experience with Genesys Cloud, IEX, Aspect, Verint.
• 3+ years creating reports and dashboards.
• Willingness to learn new software.
• Strong problem solving and teamwork.

Responsibilities

• Create daily, weekly, monthly forecasts for multiple sites.
• Develop, maintain, and automate dashboards and scheduled reports tracking KPIs.
• Update forecast, staffing, and projected performance of GSCC.
• Provide recommendations to improve group performance.
• Meet with WFM team and stakeholders to discuss projections and performance.

Skills

Forecasting

Scheduling

WFM systems

Analytical skills

Data analysis

Team collaboration

SQL

Power BI

Excel

Adaptability

Tools

Genesys Cloud

IEX

Aspect

Verint

SQL scripting

Power BI

Job description

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)

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