Senior Forecasting Administrator

HelloFresh; United States; Remote; USD 65,000 - 95,000; Full time

Benefits offered by this job

Competitive compensation

Wellness & Perks

Growth opportunities

Dynamic environment

Work-life balance

Job summary

HelloConnect is seeking a detail-oriented data forecasting analyst to join our team in BGC. You will develop and run SQL queries to validate forecast data, perform quality checks, and investigate discrepancies to ensure reliable BAU forecasting and support future automation.

You’ll collaborate with Forecast Analysts and other stakeholders, document validation procedures, and help standardize processes to improve efficiency and forecasting accuracy while delivering clear, data-driven insights.

Qualifications

• Experience in data analysis, forecasting support, or related operations.
• Proficient in writing SQL queries for data validation.
• Experience with data quality checks and reporting.
• Exposure to forecasting, inventory planning, or commercial analytics is desirable.

Responsibilities

• Develop, maintain, and execute SQL queries to validate forecast data.
• Conduct data quality checks to identify discrepancies and anomalies.
• Investigate forecast issues by analyzing datasets and historical trends.
• Assess impact, track recurring problems, and propose corrective actions.
• Standardize validation checks and streamline manual processes.
• Develop reusable SQL queries and document validation steps.
• Support testing of forecasting processes and automation opportunities.
• Prepare analyses for forecast reviews and operational reporting.
• Analyze historical trends to explain forecast movements.
• Prepare BAU forecasts using established methodologies.
• Apply assumptions and ensure consistency.
• Communicate findings and forecast risks clearly.
• Collaborate with Forecast Analysts and stakeholders.

Skills

SQL

Excel/Sheets

Data validation

Data analysis

Forecasting support

Reporting

Stakeholder communication

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