What are the responsibilities and job description for the Supply Chain Planner & Optimization Analyst position at AllSTEM Connections?
- Partner with cross‑functional business stakeholders (Finance, Information Services,Procurement, and Co-pack facilities, QA, Sales, Marketing, Demand, Customer Service, Traffic, Purchasing, Contract Manufacturing, Engineering, and software consultants) to deliver data‑driven planning and optimization solutions that support operational and strategic decision‑making.
- Build and maintain forecasting models and scenario analyses to improve demand planning accuracy, production alignment, and inventory positioning.
- Implement optimization approaches to balance service levels, inventory costs, capacity constraints, and waste reduction across the supply chain network.
- Analyze large, complex datasets to identify trends, risks, cost drivers, and opportunities; translate findings into actionable recommendations for production, inventory, and demand planning.
- Develop and maintain business dashboards and reports using approved enterprise tools to provide visibility into supply chain performance. Manage documentation of data definitions and reporting requirements.
- Manage finished goods and aged inventory for assigned product lines; apply analytical techniques to identify at-risk inventory and recommend disposition strategies.
- Perform root cause analysis on MRP and planning discrepancies and recommend corrective actions to prevent recurrence. Develop scalable solutions to present recurrence through improved data quality and system enhancements.
- Oversee production planning and inventory coordination with assigned manufacturing facilities; evaluate performance data and adjust plans based on analytical insights.
- Define, monitor, and enhance operational KPIs; lead data-driven continuous improvement initiatives across planning and execution processes.
- Support data integrity by defining business rules, validating outputs, and escalating data issues.
- Lead and participate in cross-functional planning cadences; clearly communicate complex analytical insights to both technical and non-technical stakeholders.
- Continuously improve technical and analytical capabilities through training, certifications, and application of supply chain planning, forecasting, and business analytics best practices
KNOWLEDGE OF:
- Material Requirements Planning (MRP) and supply chain planning principles
- Production planning, inventory management, and demand forecasting methodologies
- Data analysis, statistical modeling, and optimization techniques
- Ability to interpret and validate data using standard query and reporting tools. Advanced SQL is a plus.
- Proficiency with advanced Excel and reporting and analytics tools such as Power BI, Tableau, or similar preferred.
- Working knowledge of enterprise data concepts, including data definitions, data quality, and how to partner with Information Services on data and reporting requests.
- Data architecture fundamentals
- Business process analysis and requirements definition
- Financial and operational performance metrics
- Good Manufacturing Practices and relevant regulatory requirements
EXPERIENCE, CERTIFICATION/LICENSES, AND TRAINING:
- A bachelor’s degree in Supply Chain, Industrial Engineering, Business Analytics, Operations, Data Science, or equivalent experience in lieu of a degree.
- Two plus years of experience in data analytics, supply chain analytics, or related field.
- Strong experience with SQL and data extraction required.
- Experience building business reporting, forecasting, and scenario analysis using enterprise analytics tools preferred Experience with forecasting, optimization, or statistical modeling preferred.
- Experience in supply chain, production planning, or inventory management preferred.
Salary : $66,000 - $72,800