The Junior Demand Analyst is responsible for the data and statistical foundation of the forecasting process for the products and distributed brands of assigned markets. You'll extract, cleanse, and maintain demand data, build and run statistical forecast models, and help develop the forecasting approach and baseline forecast used by the Demand Planning team. This role turns large data sets into accurate, well-documented baselines and insights.

WHAT YOU'LL DO

Extract, cleanse, validate, and maintain historical sales, shipment, order, inventory, and product master data from the ERP and other databases to create a reliable, single source of demand history

Build and maintain data tables, queries, and data models (e.g., SQL, Power Query) that feed the forecasting process; monitor data quality and resolve gaps, outliers, and inconsistencies

Cleanse demand history for anomalies such as stock-outs, promotions, one-time orders, and product transitions to establish a clean baseline

Run and maintain the statistical baseline forecast at multiple levels of aggregation (SKU, product family, brand, customer, market) across various time horizons

Help develop and document the forecasting approach, including item segmentation (e.g., ABC/XYZ, lifecycle, seasonality) and selection of appropriate statistical methods such as moving averages, exponential smoothing, seasonal, and regression models

Track forecast accuracy and bias (e.g., MAPE) and recommend improvements as experience grows

Analyze historical trends, seasonality, and demand drivers; investigate significant variances between forecast and actuals and share findings with the Demand Planning team





Provide the statistical baseline and supporting analysis to Demand Planners, who layer in sales, marketing, and customer intelligence to reach the consensus forecast

Build and maintain reports and dashboards (Excel, Power BI) on forecast performance, demand trends, and data health for the Demand Planning team and S&OP;

Support continuous improvement of data processes, automation, and forecasting practices within Demand Planning and S&OP;

QUALIFICATIONS
Required

1-3 years of experience in any role where data, reports, or numbers were a regular part of the job

Advanced proficiency in Microsoft Excel, including Power Query and pivot tables

Strong mathematical aptitude and comfort working with large data sets

Demonstrated ability to learn technical skills and new systems quicklyStrong attention to detail and commitment to data accuracy and integrity

Robust analytical, problem-solving, and organizational skills, with the ability to explain data findings clearly to non-technical audiences

Strong interpersonal skills to work effectively with all teams and levels of the business that affect the forecast process

Preferred

Diploma or degree in Business, Supply Chain, Economics, Mathematics, Statistics, Analytics, or a related discipline

Working knowledge of Microsoft Power BI, SQL, and relational databases

Exposure to statistics or forecasting, including statistical or programming tools (e.g., Python, R) or a demand planning statistical engine

Knowledge of ERP systems and demand planning software

ASCM/APICS, IBF, or other supply chain or forecasting certification

#J-18808-Ljbffr

📌 Junior Demand Analyst (British Columbia)
🏢 Norco Bikes
📍 British Columbia