Senior Forecasting Administrator

HelloFresh; Manila (UT); Remote; USD 65,000 - 90,000; Full time

Benefits offered by this job

Long service benefits

HMO medical coverage

Life insurance

Learning budget

360 Learning access

Global team collaboration

Job summary

HelloConnect is seeking a detail-oriented data analyst to validate and improve forecast data through SQL queries and robust quality checks. You will collaborate with forecasting teams to investigate anomalies, standardize validation processes, and contribute to automation efforts across forecasting operations.

The role emphasizes analytical rigor, data integrity, and clear communication of findings with stakeholders while supporting scalable forecasting practices in a remote, global team.

Qualifications

• Experience writing SQL queries for data analysis or validation.
• Ability to perform data quality checks and investigate discrepancies.
• Exposure to forecasting, forecasting support, or operational analytics is desirable.

Responsibilities

• Develop, maintain, and execute SQL queries to validate forecast data.
• Conduct routine and ad hoc data quality checks to identify discrepancies and anomalies.
• Investigate forecast issues by analysing datasets and identifying root causes.
• Document validation procedures and identify opportunities for automation to improve efficiency.
• Prepare analyses for forecast reviews and operational reporting.

Skills

SQL

Excel/Google Sheets

Data quality checks

Forecasting support

Tools

Google Sheets

Job description

The Role

At HelloConnect, you will be part of a dynamic team in Inoza tower, BGC that embraces innovation and leverages advanced technology to create exceptional experiences. Our culture is built on collaboration, continuous learning, and a commitment to excellence. You’ll have the opportunity to work on impactful projects, develop your skills, and grow within a supportive environment that values diverse perspectives and experiences.

In this role, you will take on a key responsibility in ensuring accurate and reliable BAU forecasts through SQL-based data validation, investigation of discrepancies and anomalies, analytical reporting, and the development of standardized processes to improve forecasting efficiency and support future automation.contributing to our ongoing efforts to drive business success and enhance customer satisfaction.

We’re looking for passionate individuals who can bring their unique skills and ideas to the table. Even if you don't meet every requirement but believe you’d excel in this role, we’d love to hear from you!

What you’ll do

• Develop, maintain, and execute SQL queries to validate forecast data, ensuring the completeness, accuracy, and consistency of forecast inputs and outputs.
• Conduct routine and ad hoc data quality checks to identify discrepancies, unusual movements, and forecast anomalies.
• Investigate forecast-related issues by analysing datasets, comparing historical trends, and identifying potential root causes.
• Assess the impact of identified issues, track recurring problems, recommend corrective actions, and elevate complex issues or material forecast risks when required.
• Identify opportunities to standardise validation checks, streamline manual processes, and improve the efficiency and consistency of forecasting operations.
• Develop reusable SQL queries and document validation procedures to reduce manual effort and minimise rework.
• Support the testing and validation of new or updated forecasting processes and automated checks, and identify opportunities for automation to improve efficiency and scalability.
• Support the preparation of analysis for forecast reviews and other operational reporting requirements.
• Analyse historical trends and forecast movements to help identify and explain potential issues.
• Prepare BAU forecasts when needed, using established methodologies and tools, and following guidance provided by Forecast Analysts.
• Apply agreed assumptions, adjustments, and processes accurately and consistently.
• Perform reasonableness checks on forecast outputs and investigate unexpected movements before submission.
• Work closely with Forecast Analysts and other relevant stakeholders to support reliable forecast delivery.
• Communicate investigation findings, data limitations, and forecast risks clearly and promptly.

Key Skills and Experience

Technical skills

• • Working knowledge of SQL
  • Strong Excel or Google Sheets skills, including formulas, data manipulation, reconciliation, and reporting.
  • Experience working with large datasets and identifying data quality issues.
  • Ability to develop repeatable checks and produce clear, reliable analytical outputs.

Analytical skills

• • Strong attention to detail and a methodical approach to data validation.
  • Ability to investigate discrepancies, identify patterns, and determine likely root causes.
  • Ability to interpret historical trends and explain movements in forecast data.
  • Good numerical reasoning and the ability to quantify the impact of data issues.

What you’ll bring

• Relevant experience in data analysis, forecasting support, reporting, business operations, or a related field.
• Demonstrated experience writing SQL queries for data analysis or validation.
• Experience conducting data quality checks, investigating discrepancies, and preparing reports.
• Exposure to demand forecasting, inventory planning, commercial analytics, or operational forecasting is desirable.

What we offer

• Competitive Compensation: Beyond the standard package, we offer perks like Long Service Benefits (anniversary bonus) to recognize and celebrate your dedication
• Wellness & Perks: We prioritize your well-being by offering mental health support, HMO medical coverage, generous leave benefits plus life insurance for both you and your family's peace of mind
• Growth Opportunities: Invest in your personal development with an annual learning & development budget, plus access to the 360 Learning platform
• Dynamic Environment: Join a rapidly growing global Business Process Outsourcing company, where you'll collaborate with a diverse community spanning across multiple continents and cultures
• Work-Life Balance: Enjoy a healthy balance between your professional and personal life, with a supportive environment that prioritizes your well-being and personal time

#helloconnect
#LI-Remote
#LI-DNI