Inventory Planning Analyst

Job Description

FORECAST PLANNING AND INSIGHTS

Responsible for SKU‑level forecasts using historical sales, seasonality patterns, product lifecycle curves, and statistical models (e.g., moving averages, exponential smoothing, regression‑based methods). Continuously refine models to improve accuracy and reduce bias.

Incorporate inputs from Sales, Marketing, Operations and Distribution—including promotions, pricing changes, new product introductions, and market shifts—to 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, end‑of‑life items, seasonal assortments, and slow‑moving SKUs. Use proxy products or attribute‑based modeling when historical data is limited.

Oversee the full lifecycle of LTO products, from initial forecast through end‑of‑program transition.

Create scenario analyses to evaluate the impact of promotions, supply constraints, lead‑time 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 cross‑functional 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 data‑driven ways of working.

Build strong relationships across the organization to improve information flow, reduce friction, and accelerate decision‑making.

 

COMMUNICATION AND STAKEHOLDER PRESENTATIONS

Translate complex data into clear narratives that non‑technical stakeholders can understand, using visuals, storytelling, and business‑focused framing.

Provide decision‑ready recommendations, not just data—clearly outlining trade‑offs, 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 decision‑making by presenting scenario analyses, risk assessments, and strategic recommendations in a concise, business‑oriented format.

 

SUBMISSION PROCESS AND SYSTEM INPUTS

Enter/upload finalized inputs into Red Bull CPM forecasting system according to established planning cycles and cut‑off 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.

Bachelor’s Degree preferred, advanced degree a plus.

Additional Information

The expected annual base salary range for this position is $80,750 to $89,250. The actual base salary for this position will depend on various factors including, but not limited to, the candidate’s qualifications, skills, experience and work location. This position is also eligible for an annual bonus in accordance with the terms of Red Bull’s 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.