Demand Planner

Napoleon•Barrie, ON

6d•CA$62,400 - CA$85,800

About The Position

This Demand Planning position is responsible to facilitate all forecasting activities associated with customers and products. The Demand Planner analyses and challenges forecasts for their customers, incorporating business intelligence and forecast information gathered from sales, marketing, finance, retailer replenishment analysts, and other sources. The Demand Planner is the integration point into the sales and commercial organization. Sales Forecast/Sales History/Operational analytics and modeling is the responsibility of this position. This position leads all teams in the organization through the monthly S&OP process and manages all information relating to it. This role consistently leads the dialogue of the cross functional teams each month to ensure alignment across the organization.

Requirements

Post secondary education in Statistics, Data Sciences, Business Management, or Supply Chain Management. University level education preferred.
3-5 years of work experience
Must be proficient in Microsoft Office (Word, Excel, PowerPoint, Outlook), Power BI, IBM Planning Analytics and knowledge of ERP's, S&OP software's.
Demonstrated proficiency in statistics, data management, forecasting and forecasting methods with an understanding of their financial and operational impacts.

Nice To Haves

Certified Professional Forecaster designation or working towards considered an asset
SCM Degrees or Designations would be an asset, with preference for Data Science Certificate or APICS

Responsibilities

Lead the management of all S&OP monthly cadence for the organization for new and existing products. Achieve consensus for operational demand forecasts by facilitating a collaborative planning process with Sales, Marketing R&D, Supply Chain, Executive Team and Finance.
Through various phases of forecast analysis, identify financial risks and opportunities for the company as it relates to demand forecasts and inventory. Facilitate alignment on the organizations decisions/direction with the SMT and ELT.
Measure forecast accuracy at multiple levels of granularity across all lines of business. Collaborate with Sales Leaders, PMO, and PM Leaders to identify actions to drive improved accuracy. Coordinate the execution of these actions to have a positive financial impact through inventory.
Coordinate cross-functional research activities to understand drivers in the market to support demand forecasts, reconcile significant variances and refine the forecast models to reflect updated sales and marketing qualitative data/assumptions from customers.
Manage the demand forecasts for all sales channels and lines of business from 7-18 months to ensure clear data for internal and supplier capacity planning, internal labour planning, supplier negotiations/contracts, cash flow projections, inventory forecasts, storage capacity projections and support the SMT and ELT in making data driven decisions for the company.
Develop and manage tools in Power BI, IBM Planning Analytics, D365 and Excel to support improved analysis and scenario building for demand forecasts, sales orders, financial comparisons, forecast accuracy, changing customer demand trends, changing tariffs, market competitiveness, etc. This includes the creation of comparative data models such as time series, linear regression, decomposition, exponential smoothing etc. to best suit the SKU in specific sales channels.
Complete detailed analysis for various levels of demand forecasts, sales channels and regions to identify recommended amendments based on current sales and customer buying patterns, historical sales, planned promotions, rebates, delta's between financial forecasts and demand forecasts, changes to customer relationships, supply constraints, etc. Challenge Sales and SMT with the recommended changes and negotiate consensus.
Provide input to the Supply Planning organization in developing inventory strategies on existing items, new products, and product phase-outs.
Complete analysis of new products being launched and provide forecast estimates to support the business plans at various levels of the stage gate process to review with SMT. Track the forecast accuracy of each new SKU by region and sales channel. This information will then be presented to the ELT monthly to communicate the achieved ROI of new products.
Complete data scrubs to ensure data integrity in Q2. Provide data to sales leaders and finance to support assumptions for the next rolling 18 months that will be the baseline for the next years sales budget. Analyze the recommendations made by Sales Leaders and make recommendations/amendments.
Create various presentations monthly to support Sales Leaders, SMT and ELT to elevate concerns through to consensus, communicate the financial plans relating to demand forecasts, describe economic situations, standings in marketplace, facilitate CFT discussions, changing strategies, etc.
Utilize, maintain and recommend upgrades the Demand Planning software as the primary forecasting system tool for the organization.

Benefits

Comprehensive health, dental, vision, and life insurance coverage – 100% of premiums paid by the Company!
Long Term Disability Protection
Well-being support programs and virtual medical visits
Employee & Family Assistance Program for mental health and well-being (EAP)
Training Allowance and continuous learning opportunities and programs
Leadership development and mentorship programs
Clear pathways for advancement
Appreciation events, raffles, and team building activities
Napoleon Cares – A fund sponsored by Associates to help Associates in times of need
Competitive total compensation package, inclusive of bonus opportunity
Retirement savings plan with matching Company contributions (RRSP/DPSP)
Exclusive Associate discounts on our award-winning products