Logo for HelloFresh

Senior Forecasting Administrator

Role overview

Qualifications

  • 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.

Responsibilities

  • Develop, maintain, and execute SQL queries to validate forecast data.
  • Conduct routine and ad hoc data quality checks to identify discrepancies.
  • Investigate forecast-related issues by analyzing datasets.
  • Identify opportunities to standardize validation checks and improve efficiency.

Key facts

Hard skills

Other skills

  • Microsoft Excel
  • Detail Oriented
  • Analytical Thinking

About the company

HelloFresh logo

HelloFresh

  • Food & Beverage
  • Large
  • 10,001+
HelloFresh is on a mission to change the way people eat, forever! From our 2011 founding in Europe’s vibrant tech hub Berlin, we’re evolving from the world’s leading meal kit company to the world's leading food solutions group. We delivered 227 million meals and reached 6.94 million active customers around the world in Q3 2021. HelloFresh Group consists of six brands that provide customers with high quality food and recipes for different meal occasions. Every ingredient needed for our meals are carefully planned, responsibly sourced and delivered to your door when it’s most convenient for you. Only HelloFresh gives you the tools to achieve something delicious every day. Making a meal a delicious achievement - not just fuel for your day - takes a lot of work and smart people. From Designers and Copywriters to Data Scientists and DevOps Engineers, to potato farmers, pasta makers and the people who ensure every box is perfectly packed for every customer, we’re collectively disrupting the food supply chain and the multi-trillion-dollar food tech industry. Our more than 15,000 high-performing and ambitious employees across the globe from New York to Berlin, London to Sydney and Tokyo to Milan enjoy a number of benefits including flexible working arrangements, discounts on our boxes, health and well-being and learning and development programs. We’re always looking for quality ingredients to perfect our recipe, so join us now! https://www.hellofresh.com/careers/locations

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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 escalate 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

Are you up for the challenge?

The first step to your new role starts here. Send in your application, along with your salary expectations and preferred start date. Our dedicated team will thoroughly review your details. We are excited to connect with you soon! 

 #helloconnect
 #LI-Remote
 #LI-DNI

Related jobs

See all jobs

Other jobs at HelloFresh