Demand and Operations Planning Analyst

Avtron Power Solutions, LLC.; Cleveland, Northern (OH, KY); Hybrid; USD 85,000 - 105,000; Full time

Job summary

Avtron Power Solutions, LLC, in Cleveland, OH, is seeking a Demand and Operations Planning Analyst to align supply chain with manufacturing capacity and optimize inventory. You will support the SIOP process and provide analytics using SAP, Excel, and Power BI.

This role emphasizes monthly forecasting, cross-functional collaboration with Sales and Operations, and data-driven reporting to improve service levels and reduce excess inventory.

Qualifications

• BA/BS in Business, Statistics, Industrial Engineering, or Supply Chain Management.
• Minimum 5-7 years of progressive experience in SIOP and data analysis.
• Advanced user of SAP, Excel, Power BI and databases.

Responsibilities

• Build and update monthly statistical demand forecasts from sales data and trends.
• Support SIOP meetings and coordinate with manufacturing and supply chain teams.
• Monitor inventory levels, reorder points, and KPI tracking.
• Develop and maintain standard reports and adhoc data analytics.
• Train SCM team on Excel, SAP, and Power BI tools.

Skills

Forecasting

SIOP

Data analysis

Cross-functional collaboration

Problem solving

Education

BA/BS in Business

Statistics

Industrial Engineering

Supply Chain Management

Tools

SAP

Excel

Power BI

PowerPoint

Databases

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Demand and Operations Planning Analyst

Full Time Individual Contribtr Cleveland, OH, US

30+ days ago Requisition ID: 1122

Salary Range: $85,000.00 To $105,000.00 Annually

COMPANY OVERVIEW:

Founded in 1953 Avtron has a long history of manufacturing market leading power test solutions. Now with a global footprint and sales into some of the largest industrial projects, Avtron will continue to push the envelope of what’s possible in the electrical test environment. Avtron Power Solutions manufacture and distribute market leading load bank solutions for mission critical applications. We have the largest portfolio in the industry and can meet the highest load testing standards with our intelligent SIGMA load bank control system.

POSITION SUMMARY:

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.

DUTIES AND RESPONSIBILITIES:

Essential Functions:

• Demand Forecasting: Build and update monthly statistical demand forecasts using past sales data, market trends, and customer resource management (CRM) opportunity funnel.
• Operations Alignment: Partner with manufacturing and operational supply chain teams to assess production capacity and capability against forecasted demand.
• SIOP Management: Support and prepare data for Sales, Inventory, and Operations Planning (SIOP) meetings.
• Inventory Control: Monitor stock levels and reorder points in ERP systems, in collaboration with operational supply chain team members to avoid shortages or excess stock.
• KPI Tracking: 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

EDUCATION, SKILLS AND EXPERIENCE:

Education:

• BA/BS in Business, Statistics, Industrial Engineering, or Supply Chain Management required

Skills

• Ability to multi-task, handling quick turnaround
• Ability to identify problem issues and escalation 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

Experience

• 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

COMPUTER SKILLS:

• Possesses strong computer skills with demonstrated proficiency in standard business software packages (e.g., Microsoft Office)