Note: The job is a remote job and is open to candidates in USA. APEC Water Systems is a growing portfolio of purpose-driven water filtration brands. The SIOP Analyst supports the end-to-end Sales, Inventory & Operations Planning process by delivering accurate data, actionable insights, and reliable reporting, while collaborating with various teams to improve forecast accuracy and inventory performance.
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
- Support Amazon consumption-based forecasting, analyzing POS/consumption signals to identify drivers of variance and risk
- 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
Skills
- 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
- BI tools (Power BI, Tableau)
- Familiarity with ERP/planning systems (SAP, Oracle, NetSuite, Anaplan, Kinaxis)
- Experience with Amazon consumption forecasting or Amazon vendor analytics
Benefits
- Paid time off
- Health
- Dental
- Vision
- Life
- Disability benefits
- 401(k)
Company Overview
APEC Water Systems manufactures reverse osmosis drinking water filtration systems as well as offers filter and parts replacement services. It was founded in 1995, and is headquartered in City Of Industry, California, USA, with a workforce of 51-200 employees. Its website is https://www.freedrinkingwater.com/.Company H1B Sponsorship
APEC Water Systems has a track record of offering H1B sponsorships, with 2 in 2021. Please note that this does not guarantee sponsorship for this specific role.