Supply Chain Forecasting & Data Analyst

About the role

We are seeking a highly analytical Supply Chain Forecasting & Data Analyst to turn historical sales and order data into demand forecasts, inventory insights, and actionable recommendations for our growing distribution operation.

Key responsibilities

• Analyze historical sales and order data to identify demand patterns, build SKU‑level and customer‑level forecasts, and develop rolling 12‑ to 18‑month demand projections.
• Design and maintain scalable forecasting and inventory analysis models in Microsoft Excel, using advanced formulas, PivotTables, and lookup functions.
• Extract, clean, and validate large datasets from ERP systems, resolve data‑quality issues, and document data‑cleaning processes.
• Provide inventory and supply‑chain insights, recommending stocking adjustments, identifying declining or growing SKUs, and supporting replenishment decisions.
• Prepare clear reports and presentations that translate complex analysis into practical business recommendations for non‑technical stakeholders.

Required profile

• 3+ years of experience in supply‑chain analytics, demand planning, or related analytical fields.
• Hands‑on experience building demand forecasts and supply‑planning models from raw transactional data.
• Strong analytical reasoning, problem‑solving skills, and ability to work independently with imperfect data.
• Excellent written and spoken English and ability to communicate findings to non‑technical audiences.

Required skills

• Microsoft Excel (advanced formulas, PivotTables, XLOOKUP, INDEX‑MATCH, SUMIFS).
• Data cleaning, transformation, and trend analysis on large datasets.
• Forecasting model development and growth‑rate calculations.
• ERP data extraction (e.g., Microsoft Dynamics 365 Business Central).
• Power BI for reporting and visualization.