What are the responsibilities and job description for the Supply Chain Planning & Optimization Analyst position at AllSTEM Connections?
PURPOSE OF THE POSITION:
The Supply Chain Planning & Optimization Analytics role supports operational and strategic objectives by combining production and inventory planning with advanced analytics, forecasting, and optimization. This position is responsible for developing finished good production plans, fruit utilization, and inventory plans while leveraging enterprise data, and analytical tools to improve decision-making, efficiency, and financial performance. The role partners cross‑functionally with field operations, sales, and plant teams to ensure aligned, efficient, and informed execution of business plans.
This role sits at the intersection of supply chain operations and data science, transforming complex datasets into actionable insights and scalable analytical solutions that enhance planning accuracy, optimize inventory, and drive continuous improvement across the organization.
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
ABILITY TO:
· Apply advanced analytical and problem-solving skills to optimize supply chain decisions
· Translate complex data into clear, actionable business insights
· Build scalable analytical tools, models, and reporting solutions
· Manage and prioritize multiple projects in a fast-paced environment
· Collaborate effectively across technical and business teams
· Communicate complex concepts to diverse audiences
· Identify root causes and implement sustainable solutions
· Exercise independent judgment in planning and decision-making
· Leverages enterprise technology tools—including AI, word processing, spreadsheets, databases, and collaboration platforms—to analyze information, support decision‑making, and communicate effectively.
· Meet behaviors established performance culture and development process.
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 : $32 - $35