Junior Demand Analyst

Norco Bikes; Port Coquitlam; On-site; CAD 45,000 - 65,000; Full time

Job summary

Norco Bikes is hiring a Junior Demand Analyst in Canada to anchor the data and statistical foundation of our forecasting process for assigned markets. You will extract, cleanse, and maintain demand data, build forecasting models, and help shape the forecasting approach and baselines used by the Demand Planning team.

You will turn large data sets into accurate baselines and insights, support forecast accuracy tracking, and create dashboards (Excel, Power BI) to monitor performance and data health

Qualifications

• 1-3 years of experience in any role with data, reports or numbers.
• Advanced proficiency in Microsoft Excel, including Power Query and pivot tables.
• Strong mathematical aptitude and comfort with large data sets.
• Ability to learn technical skills quickly and maintain data accuracy and integrity.
• Strong analytical, problem-solving, and organizational skills; able to explain data findings to non-technical audiences.
• Strong interpersonal skills to work with all teams and levels of the business.

Responsibilities

• Extract, cleanse, validate, and maintain historical sales, shipment, order, inventory, and product master data from 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 and selection of 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 variances and share findings with the Demand Planning team.
• Provide the statistical baseline and supporting analysis to Demand Planners to reach 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.

Skills

Advanced Excel

Power Query

Pivot Tables

Data Analysis

Statistical thinking

Attention to detail

Communication

Learning agility

Interpersonal skills

Education

Degree in Business / Supply Chain / Economics / Mathematics / Statistics / Analytics

Tools

Power BI

SQL

Relational databases

Python

R

ERP systems

Job description

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
• Strong 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