Demand and Operations Planning Analyst

Automatic Data Processing, Inc.; Cleveland (OH); On-site; USD 85,000 - 105,000; Full time

Job summary

Avtron in Cleveland, OH is seeking a Demand and Operations Planning Analyst to align supply chain with production capacity and optimize inventory. You will support SIOP processes, forecast accuracy, and monthly reporting using SAP, Excel, and Power BI.

The role requires a BA/BS in a related field and 5–7 years of experience in SIOP/data analysis, with strong SAP and analytical skills. This is an on-site position in a global supply chain team.

Qualifications

• BA/BS in Business, Statistics, Industrial Engineering, or Supply Chain Management required.
• Ability to multi-task and handle quick turnarounds.
• Strong interpersonal and communication skills with internal/external customers.
• Excellent organizational skills and attention to detail.
• Experience with SAP, Excel, PowerPoint and databases.

Responsibilities

• Forecast monthly demand using past sales data, market trends, and CRM data.
• Align operations with supply chain capabilities and forecast demand.
• Support SIOP meetings with data and analysis.
• Monitor inventory with ERP systems and reorder points.
• Track KPI accuracy, inventory turns, and service levels.
• Collaborate on monthly forecasting with Supply Chain, Sales, and Operations.

Skills

Multi-tasking

Problem solving

Interpersonal skills

Organizational skills

Safety awareness

Education

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

Tools

SAP

Excel

Power BI

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

Global Supply Chain Full Time Individual Contribtr Cleveland, OH, US

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 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 elevate 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)