Demand and Operations Planning Analyst

Avtron Power Solutions, LLC•Cleveland, OH

5h•$85,000 - $105,000

About The Position

The Demand and Operations Planning Analyst aligns operations with supply chain capabilities, and optimizes inventory. This role will support the Global Sales, Inventory, and Operations Planning (SIOP) process as well as all strategic and tactical supply chain metric reporting and analytical activities. Additional focus will be placed on monthly collaborative forecasting efforts between Supply Chain, Sales, and Operations. The Demand and Operations Planning Analyst will also support reporting and analysis of timely and accurate Supply Chain metric reporting using SAP, Excel, and other technology/software to ensure the effective management of procurement and inventory.

Requirements

BA/BS in Business, Statistics, Industrial Engineering, or Supply Chain Management required
Ability to multi-task, handling quick turnaround
Ability to identify problem issues and escalate and/or execute acceptable solutions
Possess strong interpersonal skills and the ability to work with customers, suppliers and employees/managers at all levels within the company
Excellent organizational skills
Ability to maintain safe work environment
Minimum of 5-7 years’ progressive experience in SIOP and data analysis for SCM, operations, and/or finance; preferably experience with manufacturing operations
Understanding of Supply Chain Management best practices
Advanced user of SAP, Excel, power point and databases
Advanced analytical and presentations skills required
Experience in ERP systems, SAP desired
Possesses strong computer skills with demonstrated proficiency in standard business software packages (e.g., Microsoft Office)

Responsibilities

Build and update monthly statistical demand forecasts using past sales data, market trends, and customer resource management (CRM) opportunity funnel.
Partner with manufacturing and operational supply chain teams to assess production capacity and capability against forecasted demand.
Support and prepare data for Sales, Inventory, and Operations Planning (SIOP) meetings.
Monitor stock levels and reorder points in ERP systems, in collaboration with operational supply chain team members to avoid shortages or excess stock.
Measure forecast accuracy, inventory turns, and service levels.
Participate in monthly forecasting efforts between Supply Chain, Sales, and Operations.
Receive, analyze, and enter all customer submitted forecasts into demand planning process.
Support monthly SIOP data files and monthly meetings with cross functional teams.
Compare statistical forecast data with projected sales trends to highlight and correct imbalances in inventory positions.
Meet regularly with Operational SCM Team to drive inventory optimization.
Analysis to ensure data integrity related to system forecasts and customer submitted forecasts.
Participate in forecast improvement initiatives with sales, procurement, and operations.
Assist in managing inventories in excess/obsolete status with emphasis in creating channels for movement.
Monitor department KPIs related to days inventory and excess/obsolete to drive metric results and meet operating objectives.
Monitors and measures the business unit’s supply chains overall performance with appropriate metrics that are published and reviewed on a timely basis.
Ensure the setup of SAP is accurate and the tools are usable and accurate for all SCM team members.
Work with Supply Chain stakeholders to develop adhoc reporting needs. Proficient in Data Mining.
Provide Training on software, including: excel, SAP, Power BI, and other software and technology To SCM. This role will become the Power BI subject matter expert (SME).
Report out on metrics to drive improvements including a cost tracking database and PPV and PPI reporting.
Develop simple and standardized tools in Excel, SAP, and Power BI to be used by all of SCM to be more efficient and accurate in managing spend (macros, auto release, pivot tables, etc.).
Develop, write, edit and maintain standard work for the department