SIOP Analyst
APEC Water Systems · Rosemont, IL · 3 wk ago
HybridSales$80k–$100k/yrFull-time
Responsibilities
- Prepare and publish all materials for monthly/weekly SIOP cycles (Demand Review, Supply Review, Pre-SIOP, Executive SIOP).
- Validate and consolidate demand, supply, inventory, and financial inputs.
- Maintain the SIOP calendar and ensure stakeholder adherence to timelines.
- Analyze forecast outputs, demand trends, and historical patterns to identify risks and opportunities.
- Support supply-side analytics such as capacity reviews, production constraints, and inventory projections.
- Track forecast accuracy and bias by product family, region, and channel.
- Build and maintain dashboards covering WOS, fill rate, forecast accuracy, OTIF, and inventory health.
- Ensure data integrity across ERP, planning, and BI platforms.
- Monitor SKU-level inventory performance including excess/slow-moving inventory and safety stock adherence.
- Support scenario modeling and what-if analyses to guide mitigation strategies.
- Provide data-driven insights during SIOP meetings to align Sales, Finance, Operations, and Product teams.
- Partner with channel teams (Amazon, Retail, Distributor, DTC) to understand channel-specific demand behaviors.
- Participate in root-cause analysis for demand/supply gaps and support corrective action closure.
- Identify opportunities to streamline planning workflows, improve planning maturity, and enhance reporting capability.
- Support tool enhancements, standard templates, and SIOP process documentation.
Requirements
- Bachelor’s degree in Supply Chain, Operations, Business, Analytics, or related field.
- 2–4 years in supply chain planning, demand planning, forecasting, or analytics.
- Strong analytical skills and ability to work with large datasets.
- Advanced Excel required; BI tools (Power BI, Tableau) preferred.
- Familiarity with ERP/planning systems (SAP, Oracle, NetSuite, Anaplan, Kinaxis) is a plus.
- Experience with Amazon consumption forecasting or Amazon vendor analytics strongly preferred.
- Ability to manage or analyze multiple channels of distribution (Amazon, Retail, Distributor, DTC).
- Strong communication skills and ability to present insights to cross-functional partners.
- High attention to detail and strong data quality mindset.