Demand and Operations Planning Analyst

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

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)