Siop Analyst

Description: The SIOP Analyst supports the end‑to‑end Sales, Inventory & Operations Planning (SIOP) process by delivering accurate data, actionable insights, and reliable reporting. This role plays a critical part in aligning demand, supply, inventory, and financial targets across the organization. The SIOP Analyst partners closely with Demand Planning, Supply Planning, Procurement, Sales, Finance, and Operations to drive improved forecast accuracy, inventory performance, and execution across multiple distribution channels

Responsibilities:

SIOP Process Support

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

Demand & Supply Analytics

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

Reporting & Dashboarding

• Build and maintain dashboards covering WOS, fill rate, forecast accuracy, OTIF, and inventory health.
• Ensure data integrity across ERP, planning, and BI platforms.

Inventory Health & Risk Management

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

Cross-Functional Collaboration

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

Continuous Improvement

• Identify opportunities to streamline planning workflows, improve planning maturity, and enhance reporting capability.
• Support tool enhancements, standard templates, and SIOP process documentation.

Key Performance Indicators (KPIs)

The SIOP Analyst will be measured on the following core metrics:

• Sell‑Through Forecast Accuracy ≥ 85%
• Sell‑In Forecast Accuracy ≥ 85%
• Forecast Bias within acceptable thresholds by channel/product family
• Consistent, on-time delivery of SIOP reporting and meeting materials
• Inventory health metrics (e.g., WOS, excess/slow-moving inventory)
• Data integrity and reporting accuracy across systems

Required Qualifications:

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

Competencies: To perform the job successfully, an individual should demonstrate the following competencies in this position; Analytical Rigor, Cross-Channel Understanding, Collaboration & Influence, Accountability and Continuous Improvement Mindset

About Us

The PurePlay business is a growing portfolio of purpose-driven water filtration brands and part of Culligan International, a private-equity held company based in Rosemont, Illinois.

Our PurePlay brands serve a shared mission: to make clean, great-tasting, and contaminant-free water accessible in every household.

• APEC Water is our flagship brand, widely trusted by professionals and discerning consumers alike for its uncompromising performance, rigorous engineering, and industry-leading reverse osmosis systems.
• Express Water brings bold design and modern simplicity to everyday households, delivering powerful water filtration in sleek, user-friendly formats-designed for DIY installers and first-time buyers alike.
• CuZn extends our professional-grade portfolio with performance-focused specialty filters, while
• Pure Blue delivers reliable, accessible solutions tailored for value-seeking families looking for high-quality hydration with minimal complexity.

Across the portfolio, we combine technical credibility with consumer-first thinking-creating products that are engineered to perform, built to last, and positioned to win in every channel.

Target Salary Range: $80,000 - $100,000 per year. Exact pay will be based on factors including, but not limited to relevant education, qualifications, certifications, experience, level, geographic location, and business and organizational needs. Full-time positions are eligible for competitive benefits, including paid time off, health, dental, vision, life, disability benefits and 401(k).