Analyst III, Demand Planning, CSP

DEMAND SUPPLY PLANNER SCHEDULER

•    Execution of the monthly S&OP process, which encompasses developing effective partnerships with sales, operations, and product management colleagues to understand and create a consensus driven demand forecast
•    Develop methodology to monitor significant variances between sales, budget and consensus forecasts and report findings to upper management in monthly S&OP meetings
•    Lead root-cause analysis on major variances which defines & implements initiatives that may span across various departments to improve forecast accuracy
•    Develop & manage monthly supply review analyses for the 3-18-month horizon, including capacity planning and optimization strategies to meet budgeted growth, service, inventory and sales targets
•    Align with Operations team to determine correct production capacity levels needed to support consensus forecast
•     Create forward looking supply shortage predictors, w/ potential mitigation strategies
•    Drive standardization and continuous improvement to enhance long term planning and continued S&OP process advancements
•    Serves as a daily point of contact and liaison with Sales/Customer Service, Quality, Supply Chain, and Manufacturing departments to coordinate sales orders status’ and completion dates and as needed, replenishment of raw materials
•    Ensure smooth flow of released work to shop floor. Review capacity and shortages daily
•    Attend production meetings. Communicate with department leads to identify production issues or needs.
•    Use and maintain the Demand Planning software in SAP IBP as the primary planning and forecasting system tool.
•    Work closely with Procurement to monitor raw materials.
•    Perform other duties as required/assigned by manager.

Background and required skills:
•    Extensive knowledge of Excel (Pivot tables, Vlookups, VBA, etc..) is required
•    Experience in SAP APO, ECC & IBP preferred
•    Previous statistical analysis/modeling experience preferred
•    Demonstrated ability to gather and interpret data to identify trends, patterns and provide recommendations for forecast and action
•    Ability to multi-task and manage multiple projects simultaneously
•    Ability to deliver projects in full, on time and to the highest quality