Forecasting Analyst

Job Duties and Responsibilities

• Analyze forecast requirements and initiate appropriate forecast trend models
• Understand the role forecast plays in the MRP process
• Export daily, weekly, and monthly reports out of SAP
• Work with sales on promotions, new customer onboarding, and customer forecast reviews
• Analyze and compile data in a professional and easy to read format
• Provide a monthly forecast to internal and external suppliers
• Respond to sales, customer operations, and product planning inquiries in a timely manner
• Create ad hoc reports for different business units
• Maintain and recalculate 9 cell data for ABC and safety stock analysis
• Maintain and calculate slow moving and obsolete inventory reserve calculations
• Download data from customer portals for review of forecast and stocking positions
• Participate in implementation of forecasting systems into other facilities
• Cook up and review supersessions for historical value updates based on product planning recommendations
• Identify opportunities to align forecast with current market trends
• Working knowledge of MRP codes / settings affect how MRP effects packaged and purchased parts
• Must be able to learn and explain how different business decisions will affect the various outcomes

Education and Qualifications

• Bachelor degree in business, computer science, or data analytics
• +5 years demand planning / forecasting experience preferred
• SAP experience preferred
• GIB forecast software experience preferred
• Good working knowledge of material flow and inventory control
• Knowledge of ERP, MRP theories and procedures, and Lean Manufacturing preferred
• Knowledge of concepts and application of materials requirements and inventory planning
• General understanding of manufacturing activities and shop floor control
• Understanding of systems functions and transactions
• Must have excellent computer skills and thorough knowledge of MS Word, PowerPoint, Excel and Power BI
• MS Access experience preferred
• Possess excellent communication and interpersonal skills and must be capable of professionally interacting with an international customer base
• Must be proactive, detail oriented and have excellent organization, planning and follow-through skills
• Committed to tasks and skilled at identifying and solving a variety of problems of broad scope and complexity with little to no supervision