Sr. Demand Planning Analyst

About the role

Senior Demand Planning Analyst who is as comfortable writing SQL as they are explaining a forecast miss to a Procurement Director. You'll own the demand signal that drives every operational decision at HelloFresh, from how much food we buy to how many staff we schedule and how many trucks we book. Your forecasts directly determine food waste, labour costs, and customer experience for millions of meals across Europe.

What you'll do

• Write and maintain SQL queries daily to extract, validate, and transform demand data across cloud data platforms (e.g., Databricks, BigQuery, Snowflake).
• Develop and refine forecasting models in Python, applying statistical and machine learning techniques.
• Design dashboards and automated reporting using visualisation tools (e.g., Tableau, Power BI) that give stakeholders self-service access to demand insights.
• Generate and validate daily and weekly demand plans for European markets and ensure forecast reliability.
• Build "What-If" scenario simulations to stress-test operational capacity and quantify supply chain risk.
• Drive cross-functional alignment in the weekly S&OP planning cycle with Market Leadership, Logistics, Production, and Procurement.
• Partner with Marketing to ensure growth campaigns and promotions are reflected in the demand view.
• Diagnose root causes of deviations and deliver actionable insights that prevent recurrence.

What you'll need

• SQL: Fluent with complex queries, joins, window functions, CTEs, and cloud data platforms (Databricks, BigQuery, Snowflake).
• Python: Good working knowledge to write and maintain scripts for data manipulation, forecasting, and analysis.
• Visualisation: Experience building dashboards in Tableau or Power BI.
• Excel/Google Sheets: Advanced proficiency.
• 4+ years in Demand Planning, Supply Planning, or Supply Chain Analytics. E-commerce, food retail, or FMCG experience strongly preferred.
• Strong grasp of forecasting techniques: bias, accuracy metrics (MAPE, WMAPE), trend decomposition, and model performance evaluation.
• Experience forecasting in environments with limited historical data using proxy data and trend smoothing.
• Strong communication skills to present insights and articulate trade-offs to technical and non-technical audiences.

Nice to have

• Perishable/short shelf-life product experience.
• Comfortable with project tools like JIRA/Confluence.

What they offer

• Discount on HelloFresh meal kits.
• Company pension scheme.
• Discounted memberships with Urban Sports Club and John Reed, yoga, Headspace, and Spill access.
• Flexible hours, Work From Home/Abroad options, and home office setup budget.
• Monthly allowance for Deutschlandticket and childcare support.
• Internal trainings and central L&D budget, plus modern office in Berlin-Kreuzberg.