Demand and Operations Planning Analyst

Avtron Power Solutions, LLC
  • Independence, OH
    Today

    Job Description

    Job Description

    Job Description

    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)

    Numbers & Facts

    LocationIndependence, OH

    Skills

    • Analysis Skillsunmatched
    • Best Practicesunmatched
    • Capacity Analysisunmatched
    • Control Systemsunmatched
    • Cross-Functionalunmatched
    • Customer Relationship Management (CRM)unmatched
    • Data Analysisunmatched
    • Data Miningunmatched
    • Data Qualityunmatched
    • Demand Forecasting/Planningunmatched
    • ERP (Enterprise Resource Planning)unmatched
    • Electricityunmatched
    • Expense Managementunmatched
    • Financeunmatched
    • Forecastingunmatched
    • Identify Issuesunmatched
    • Improvement Metricsunmatched
    • Industrial Engineeringunmatched
    • International Salesunmatched
    • Interpersonal Skillsunmatched
    • Inventory Managementunmatched
    • Inventory Planningunmatched
    • Inventory Turnsunmatched
    • Load Testingunmatched
    • Manufacturingunmatched
    • Manufacturing Operationsunmatched
    • Market Trend Analysisunmatched
    • Metricsunmatched
    • Microsoft Excelunmatched
    • Microsoft PowerPointunmatched
    • Multitaskingunmatched
    • Operational Auditunmatched
    • Operations Planningunmatched
    • Organizational Skillsunmatched
    • Performance Metricsunmatched
    • Pivot Tablesunmatched
    • Power BIunmatched
    • Presentation/Verbal Skillsunmatched
    • Process Improvementunmatched
    • Procurement Managementunmatched
    • Producer Price Index (PPI)unmatched
    • Purchasing/Procurementunmatched
    • Reporting Skillsunmatched
    • Resource Managementunmatched
    • SAPunmatched
    • SAP BusinessObjects Business Intelligence (BI)unmatched
    • SAP ECC (fka SAP R/3 and SAP ERP)unmatched
    • Safety/Work Safetyunmatched
    • Salesunmatched
    • Sales Forecastingunmatched
    • Sales Operationsunmatched
    • Sales Supportunmatched
    • Standards Developmentunmatched
    • Statisticsunmatched
    • Supply Chainunmatched
    • Supply Chain Managementunmatched
    • Supply Chain Operationsunmatched
    • Supply Chain Optimizationunmatched
    • Team Playerunmatched
    • Time Managementunmatched
    • Training/Teachingunmatched
    • Trend Analysisunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder