Inventory Production Data Analyst

Essential Functions

• Machine spares and consumables Inventory management
• Tool Room system implementation and management
• Production monitoring system implementation project support

Duties and Responsibilities

• Track stock levels, shortages, excess inventory, and inventory accuracy.
• Track incoming and outgoing goods.
• Help predict material needs and prevent stockouts or overproduction.
• Maintain inventory records in Excel or ERP systems.
• Identify stock shortages, excess stock, and discrepancies.
• Prepare daily, weekly, and monthly inventory reports.
• Analyze sales trends and forecast stock requirements.
• Coordinate with warehouse, purchasing, and finance teams.
• Monitor production output, schedules, efficiency, and manufacturing delays by implementing production monitoring system project coordination.
• Use Excel, SQL, Power BI, or ERP systems to analyze operational data.
• Create machine utilization dashboards and reports using a production monitoring system to help management make decisions.

Required Skills and Qualifications:

• Monitor production output, schedules, efficiency, and manufacturing delays by implementing production monitoring system project coordination.
• Use Excel, SQL, Power BI, or ERP systems to analyze operational data.
• Create machine utilization dashboards and reports to help management make decisions.
• Other duties as assigned

Education/Experience

• Bachelor’s degree in data Analytics, Finance, Business Analytics, Supply Chain Management, Industrial Engineering, Statistics, or a related field; equivalent experience may be accepted.
• 2+ years of previous experience in inventory analysis, production reporting, supply chain operations, or data analysis is preferred.

Preferred Qualifications:

• Knowledge of SQL for querying and analyzing data.
• Experience with Power BI or Tableau for data visualization.
• Understanding of inventory forecasting, demand planning, and production scheduling.
• Knowledge of key performance indicators (KPIs), including inventory turnover, stockout rates, and production efficiency.

Physical Demands

• The ability to stand for extended periods of time
• Personnel to be capable of lifting/carrying up to 50 pounds (approx. 23 kg) under ideal conditions.

Work Environment

• Shop floor and/or office work environment