Inventory Planning Analyst
Department:
Job Summary
FORECAST PLANNING AND INSIGHTS
Responsible for SKUlevel forecasts using historical sales seasonality patterns product lifecycle curves and statistical models (e.g. moving averages exponential smoothing regressionbased methods). Continuously refine models to improve accuracy and reduce bias.
Incorporate inputs from Sales Marketing Operations and Distributionincluding promotions pricing changes new product introductions and market shiftsto create a consensus demand plan.
Track key forecasting KPIs such as MAPE WAPE and forecast bias. Identify root causes of variance and implement corrective actions to improve future performance.
Responsible for forecasting approaches for new product introduction (NPI) launches endoflife items seasonal assortments and slowmoving SKUs. Use proxy products or attributebased modeling when historical data is limited.
Oversee the full lifecycle of LTO products from initial forecast through endofprogram transition.
Create scenario analyses to evaluate the impact of promotions supply constraints leadtime changes and demand shifts. Provide recommendations to mitigate risk and optimize inventory positioning.
Identify emerging patterns early such as accelerating demand declining velocity or SKU cannibalization and communicate these insights proactively.
CROSS FUNCTIONAL COLLABORATION
Support monthly Sales & Operations Planning (S&OP) or Integrated Business Planning (IBP) cycles by preparing demand insights presenting forecast changes and aligning on demand assumptions with crossfunctional teams.
Act as the connective tissue between Sales Finance Operations and Distribution by ensuring all teams have a shared understanding of demand assumptions inventory risks and supply constraints vs forecast planning models.
Partner with Sales and Marketing to understand upcoming promotions assortment changes and product launches translating business strategies into actionable demand plans.
Work closely with supply planning and logistics to communicate demand shifts prioritize constrained supply and support decisions on allocation replenishment and inventory positioning.
Encourage continuous improvement by sharing best practices identifying process gaps and helping teams adopt more datadriven ways of working.
Build strong relationships across the organization to improve information flow reduce friction and accelerate decisionmaking.
COMMUNICATION AND STAKEHOLDER PRESENTATIONS
Translate complex data into clear narratives that nontechnical stakeholders can understand using visuals storytelling and businessfocused framing.
Provide decisionready recommendations not just dataclearly outlining tradeoffs scenarios and the expected impact on service levels revenue and working capital.
Lead discussions on portfolio forecast changes explaining the why behind shifts in demand and ensuring stakeholders understand the implications for supply revenue and margin.
Support executive decisionmaking by presenting scenario analyses risk assessments and strategic recommendations in a concise businessoriented format.
SUBMISSION PROCESS AND SYSTEM INPUTS
Enter/upload finalized inputs into Red Bull CPM forecasting system according to established planning cycles and cutoff timelines.
Ensure proper formatting and mapping so that system fields populate correctly and downstream processes (forecasting replenishment allocation) run without errors.
Validate system outputs (e.g. forecast runs replenishment recommendations allocation results) to ensure they reflect the submitted inputs accurately.
Document and present changes and rationale so stakeholders understand what was submitted why and how it impacts planning outcomes.
Automate recurring input processes where possible using system features macros or analytics tools.
Qualifications :
3-4 years professional experience - Consumer Goods or Retail industry preferred.
Advanced Excel skills including Pivot tables Power Pivot lookups advanced formulas etc.
Advanced skills in data analytics forecasting planning developing projections and estimates.
Experience in statistics including descriptive statistics correlation regression hypothesis testing and inference.
Experience in data visualization tools like Power BI or Tableau.
Team player and strong communicator with plenty of time spent consulting with leadership and key stakeholders in the business.
SAP Spring (or other sales data systems) experience would be an asset.
Prior working experience in statistical modelling software packages (e.g. R or Python) would be nice to have.
Bachelors Degree preferred advanced degree a plus.
Additional Information :
The expected annual base salary range for this position is $80750 to $89250. The actual base salary for this position will depend on various factors including but not limited to the candidates qualifications skills experience and work location. This position is also eligible for an annual bonus in accordance with the terms of Red Bulls bonus plan.
Red Bull Canada is committed to treating all people in a way that allows them to maintain their dignity and independence. We believe in integration and equal opportunity. Accommodations are available throughout the recruitment process and applicants with a disability may request to be accommodated throughout the recruitment process. We will work with all applicants to accommodate their individual accessibility needs.
Remote Work :
No
Employment Type :
Full-time
About Company
Red Bull Student Marketeers are part of the most dynamic and empowered brand and product ambassador program in the world. They understand Red Bulls target group and are responsible for driving the brand image and product understanding on their university campus and in their region. T ... View more