Your personal AI career agent
Sr. Demand Planning Analyst(m/w/x)
Forecasting meal kit demand with Python and SQL on cloud platforms. Fluent SQL and Python for data analysis required. Flexible hours, work from home/abroad options.
Requirements
- Fluent SQL for complex queries (joins, window functions, CTEs)
- Comfortable working in cloud data platforms (Databricks, BigQuery, Snowflake)
- Good working knowledge of Python for data manipulation, forecasting, analysis
- Confident using Python to solve analytical problems
- Experience building dashboards in Tableau or Power BI
- Making data accessible to non-technical stakeholders
- Advanced Excel/Google Sheets for ad-hoc analysis
- 4+ years in Demand Planning, Supply Planning, or Supply Chain Analytics
- E-commerce, food retail, or FMCG experience strongly preferred
- Perishable/short shelf-life experience is a significant plus
- Strong grasp of forecasting techniques (bias, accuracy metrics, trend decomposition)
- Understanding how to evaluate model performance holistically
- Experience forecasting with limited historical data using proxy data
- Experience forecasting with trend smoothing
- Proven ability to manage demand and supply risks
- Proposing risk mitigations (buffers, caps, swaps)
- Communicating complex trade-offs to senior stakeholders
- Comfortable with project tools like JIRA/Confluence
- Managing backlogs and improvement roadmaps
- Strong communication skills for presenting forecast insights
- Explaining variance drivers clearly
- Articulating trade-offs clearly to technical and non-technical audiences
- Ensuring alignment across functions
- Diverse experiences and willingness to learn
Tasks
- Write and maintain SQL queries for data extraction, validation, and transformation.
- Develop and refine forecasting models using Python and statistical techniques.
- Design dashboards and automated reports for stakeholder self-service access.
- Collaborate with forecast engineers to build scalable data pipelines.
- Create and run scenario simulations to stress-test operational capacity.
- Generate and validate daily and weekly demand plans for European markets.
- Monitor trends, seasonality, and promotional impacts on demand.
- Proactively flag and communicate forecast adjustments to the supply chain.
- Implement data validation and QA checks to ensure forecast reliability.
- Drive cross-functional alignment in the weekly S&OP planning cycle.
- Partner with Marketing to integrate growth campaigns into demand forecasts.
- Diagnose root causes of forecast deviations and deliver actionable insights.
Work Experience
- 4 years
Education
- Bachelor's degreeOR
- Master's degree
Languages
- English – Fluent
Tools & Technologies
- SQL
- Databricks
- BigQuery
- Snowflake
- Python
- Tableau
- Power BI
- Excel
- Google Sheets
- JIRA
- Confluence
Benefits
Flexible Working
- Flexible hours
- Work From Home/Abroad options
Corporate Discounts
- Discount on HelloFresh meal kits
- Discounted Urban Sports Club membership
- Discounted John Reed membership
Retirement Plans
- Company pension scheme
Healthcare & Fitness
- Yoga classes
Mental Health Support
- Headspace access
Other Benefits
- Spill access
Additional Allowances
- Home office setup budget
Childcare
- Childcare support
Public Transport Subsidies
- Monthly allowance for Deutschlandticket
Learning & Development
- Access to internal trainings
- Central L&D budget
Modern Office
- Modern office in Berlin-Kreuzberg
Team Events
- Social events
- Team outings
- Company runs
Snacks & Drinks
- Friday beers
Like this job?
BetaYour Career Agent finds similar jobs for you every day.
Sr. Demand Planning Analyst(m/w/x)
Forecasting meal kit demand with Python and SQL on cloud platforms. Fluent SQL and Python for data analysis required. Flexible hours, work from home/abroad options.
Requirements
- Fluent SQL for complex queries (joins, window functions, CTEs)
- Comfortable working in cloud data platforms (Databricks, BigQuery, Snowflake)
- Good working knowledge of Python for data manipulation, forecasting, analysis
- Confident using Python to solve analytical problems
- Experience building dashboards in Tableau or Power BI
- Making data accessible to non-technical stakeholders
- Advanced Excel/Google Sheets for ad-hoc analysis
- 4+ years in Demand Planning, Supply Planning, or Supply Chain Analytics
- E-commerce, food retail, or FMCG experience strongly preferred
- Perishable/short shelf-life experience is a significant plus
- Strong grasp of forecasting techniques (bias, accuracy metrics, trend decomposition)
- Understanding how to evaluate model performance holistically
- Experience forecasting with limited historical data using proxy data
- Experience forecasting with trend smoothing
- Proven ability to manage demand and supply risks
- Proposing risk mitigations (buffers, caps, swaps)
- Communicating complex trade-offs to senior stakeholders
- Comfortable with project tools like JIRA/Confluence
- Managing backlogs and improvement roadmaps
- Strong communication skills for presenting forecast insights
- Explaining variance drivers clearly
- Articulating trade-offs clearly to technical and non-technical audiences
- Ensuring alignment across functions
- Diverse experiences and willingness to learn
Tasks
- Write and maintain SQL queries for data extraction, validation, and transformation.
- Develop and refine forecasting models using Python and statistical techniques.
- Design dashboards and automated reports for stakeholder self-service access.
- Collaborate with forecast engineers to build scalable data pipelines.
- Create and run scenario simulations to stress-test operational capacity.
- Generate and validate daily and weekly demand plans for European markets.
- Monitor trends, seasonality, and promotional impacts on demand.
- Proactively flag and communicate forecast adjustments to the supply chain.
- Implement data validation and QA checks to ensure forecast reliability.
- Drive cross-functional alignment in the weekly S&OP planning cycle.
- Partner with Marketing to integrate growth campaigns into demand forecasts.
- Diagnose root causes of forecast deviations and deliver actionable insights.
Work Experience
- 4 years
Education
- Bachelor's degreeOR
- Master's degree
Languages
- English – Fluent
Tools & Technologies
- SQL
- Databricks
- BigQuery
- Snowflake
- Python
- Tableau
- Power BI
- Excel
- Google Sheets
- JIRA
- Confluence
Benefits
Flexible Working
- Flexible hours
- Work From Home/Abroad options
Corporate Discounts
- Discount on HelloFresh meal kits
- Discounted Urban Sports Club membership
- Discounted John Reed membership
Retirement Plans
- Company pension scheme
Healthcare & Fitness
- Yoga classes
Mental Health Support
- Headspace access
Other Benefits
- Spill access
Additional Allowances
- Home office setup budget
Childcare
- Childcare support
Public Transport Subsidies
- Monthly allowance for Deutschlandticket
Learning & Development
- Access to internal trainings
- Central L&D budget
Modern Office
- Modern office in Berlin-Kreuzberg
Team Events
- Social events
- Team outings
- Company runs
Snacks & Drinks
- Friday beers
Like this job?
BetaYour Career Agent finds similar jobs for you every day.
About the Company
HelloFresh
Industry
Food
Description
HelloFresh is one of Europe's fastest-growing tech powerhouses, offering meal kit delivery services and a diverse workplace culture.