ABOUT THE ROLE
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 quickly
- Strong 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
- Experience in outdoor sports categories
SALARY RANGE
$58,500 – $71,500 per year
