Demand Planner

<p><strong>The role: What's in the Box</strong></p> <p>We're looking for a highly technical Demand Planner who blends deep forecasting expertise with strong data engineering skills. This is a hands-on analytical role: you must have a proven track record of applying SQL specifically to demand planning and forecasting data. You'll spend your time writing queries to build reports, run deep-dive analyses, validate demand models, and use your planning expertise to drive operational decisions.</p> <p>You'll support the demand signal that dictates every operational decision at HelloFresh, from how much food we order to how many staff we schedule and how many trucks we book. Your work directly contributes to reducing food waste, improving product availability, managing labour costs, and protecting customer experience for millions of meals across Europe.</p> <p>Our Demand Planning team is evolving into a new structure that splits the ownership of the final demand numbers from the ownership of the forecasting methods. You will contribute to that transformation, supporting country-level market planners and category experts to build next-generation forecasting capabilities, while keeping daily supply chain execution accurate and ensuring market inputs are aligned on time.</p> <p><strong>What you’ll do: The Recipe</strong></p> <ul> <li><strong>Data Extraction & Modeling for Insights:</strong> Write and maintain SQL queries to extract, transform, and analyse demand data across cloud platforms (e.g., Databricks, Snowflake). Ensure the data is structured to power accurate forecasting models, test hypotheses, and generate clear business takeaways.</li> <li><strong>Dashboard Creation:</strong> Build and maintain automated reporting using visualisation tools (e.g., Tableau, Genie) that give stakeholders access to operational KPIs such as forecast accuracy, bias, waste risk, and availability.</li> <li><strong>Pipeline Scalability:</strong> Work alongside forecast engineers and senior analysts to support scalable pipelines, ensuring local market nuances are handled within the unified codebase.</li> <li><strong>AI Integration:</strong> Use AI tools (e.g., Gemini, Claude) to speed up everyday tasks like writing SQL, debugging queries, and summarising data; we encourage experimentation to help the team work smarter.</li> <li><strong>Plan Generation:</strong> Support the creation and validation of daily and weekly demand plans for European markets, ensuring the Decision-Time forecast is accurate at the exact moment Procurement and Production need to act.</li> <li><strong>Trend Monitoring:</strong> Monitor trends and seasonality using a data-driven approach, flagging when the plan needs adjusting and escalating where appropriate.</li> <li><strong>Performance Tracking:</strong> Track forecast performance against KPIs (MAPE, bias) and their downstream impact on waste and fulfilment, surfacing findings that help the team improve.</li> <li><strong>Proactive Data Quality & QA:</strong> Act as the first line of defence for forecast reliability. Own the day-to-day data validation across demand pipelines, proactively identifying anomalies, flagging data breaks, and ensuring all inputs are clean before they influence the final plan.</li> <li><strong>Deviation Root Cause Analysis:</strong> Whenever deviations between the forecast and actuals occur, lead deep-dive investigations to identify the underlying drivers. Translate these findings into immediate, actionable</li> <li><strong>S&OP Participation:</strong> Participate in the weekly operational planning cycle, preparing materials and analysis for meetings with Market Leadership, Logistics, Production, and Procurement.</li> <li><strong>Commercial & Marketing Alignment:</strong> Partner with Marketing and Commercial teams to ensure growth campaigns, promotions, and new product launches are accurately quantified and integrated into the demand view long before they impact the supply chain.</li> <li><strong>Automated Insights & Communication:</strong> Build and maintain automated alerts that instantly communicate missing feeds and forecast anomalies to the right stakeholders. The goal is to catch problems early and prevent downstream operational disruptions before they happen.</li> <li>adjustments that improve the demand plan and mitigate operational risks before they escalate.</li> </ul> <p><strong>What you’ll bring: The Ingredients</strong></p> <ul> <li><strong>Applied SQL (Commercial Experience Required):</strong> Confident in writing complex queries (joins, window functions, CTEs) in cloud data platforms. Crucially, you must have proven professional experience applying SQL directly to forecasting models, demand plans, or S&OP data. (Note: Purely academic/bootcamp SQL, or SQL applied without a demand forecasting element, will not be considered).</li> <li><strong>Analytical Problem Solving & Attention to Detail:</strong> Highly analytical with a proven ability to dive deep into complex datasets. You possess a structured approach to solving ambiguous problems and the meticulous attention to detail required to catch minor errors before they scale into major supply chain costs.</li> <li><strong>Visualisation & Storytelling:</strong> While you only need intermediate experience building dashboards (e.g., Tableau, Power BI), you must possess strong data storytelling skills—the ability to distill complex data into clear recommendations and present them confidently to decision-makers.</li> <li><strong>Excel/Google Sheets:</strong> Strong. Used confidently for ad-hoc analysis and stakeholder communication.</li> <li><strong>Python:</strong> A plus, not a requirement. Willingness to learn or maintain scripts for data manipulation is great.</li> </ul> <p>Above all, we are looking for people who will make HelloFresh better. There are many different ways of developing skills, and we love diverse experiences! So even if you don’t “tick all the boxes” but think you’d thrive in this role, we would really like to learn more about you.</p> <p>Are you the missing ingredient? If this sounds like a tasty opportunity, we’d be excited to hear from you. We aim to review your profile and respond within 5 business days.</p> <p><strong>What we offer: The Toppings</strong></p> <section id="h.558c0ea4fbef4789_118" class="yaqOZd"> <div class="mYVXT"> <div class="LS81yb VICjCf j5pSsc db35Fc"> <div class="hJDwNd-AhqUyc-EehZO Ft7HRd-AhqUyc-EehZO purZT-AhqUyc-II5mzb ZcASvf-AhqUyc-II5mzb pSzOP-AhqUyc-qWD73c Ktthjf-AhqUyc-qWD73c JNdkSc SQVYQc yYI8W HQwdzb"> <div class="JNdkSc-SmKAyb LkDMRd"> <div class="qUO6Ue"> <div class="oKdM2c ZZyype"> <div id="h.558c0ea4fbef4789_123" class="hJDwNd-AhqUyc-EehZO Ft7HRd-AhqUyc-EehZO jXK9ad D2fZ2 zu5uec wHaque g5GTcb"> <div class="jXK9ad-SmKAyb"> <div class="tyJCtd mGzaTb Depvyb baZpAe"> <ul> <li class="zfr3Q CDt4Ke "><span class="C9DxTc ">Enjoy a €30 weekly discount on your HelloFresh boxes.</span></li> <li class="zfr3Q CDt4Ke "><span class="C9DxTc ">Benefit from €10 meal vouchers per day.</span></li> <li class="zfr3Q CDt4Ke ">Stay covered with Alan Health Assurance for your physical and mental well-being.</li> <li class="zfr3Q CDt4Ke ">Benefit from our partnership with Wellpass, providing entry to over 4,000 gyms and 300 activities.</li> <li class="zfr3Q CDt4Ke ">Receive public transportation reimbursement (50%) or a bicycle mileage allowance.</li> <li class="zfr3Q CDt4Ke ">Grow with our "Learning Never Stops" value: access the HelloFresh Academy, clear career paths, and regular development check-ins.</li> <li class="zfr3Q CDt4Ke ">Enjoy free drinks, fresh fruit, and snacks at the workplace.</li> <li class="zfr3Q CDt4Ke ">Connect with the team at our annual offsite event and festive "Back to School" and Christmas parties.</li> </ul> </div> </div> </div> </div> </div> </div> </div> </div> </div> </section> <p><em>Please note that our working language is <strong>English</strong>, and we kindly ask that all application materials (resume/CV) are submitted in English. otherwise they <strong>will not be considered</strong>. </em></p> <p><strong>Are you up for the challenge?</strong></p> <p style="text-align: justify;"><span style="font-weight: 400;">Please submit your complete application below including your salary expectations and earliest starting date.</span></p>