Inventory Production Data Analyst

Star Pipe Products; Houston (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

Star Pipe Products is seeking a skilled Inventory Production Data Analyst to analyze inventory and production data, monitor stock levels, and prepare reports to support operational decisions. This role supports inventory accuracy, identifies discrepancies, and helps improve production efficiency across the supply chain.

The analyst collaborates with inventory, production, and finance teams to optimize processes and ensure materials are available to meet production requirements.

Qualifications

• Bachelor’s degree in data analytics, finance, business analytics, SCM, IE, statistics or related field; equivalent experience allowed.
• 2+ years of inventory analysis, production reporting, supply chain operations, or data analysis preferred.
• Knowledge of SQL for querying data; experience with Power BI or Tableau for visualization.

Responsibilities

• Track stock levels, shortages, excess inventory, and inventory accuracy.
• Track incoming and outgoing goods.
• Forecast 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.

Skills

Production monitoring

Data analysis

Dashboards & reporting

Inventory analysis

Education

Bachelor’s degree in related field

2+ years experience in inventory analysis or data analysis

Tools

Excel

SQL

Power BI

ERP systems

Tableau

Job description

• You must live in Houston or the Greater Houston area to be eligible for consideration.

Brief Description

• You must live in Houston or the Greater Houston area to be eligible for consideration.

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

Summary

We are seeking a skilled Inventory Production Data Analyst to analyze inventory and production data, monitor stock levels, track production performance, and prepare reports to support operational decisions. This role helps maintain inventory accuracy, identify discrepancies, improve production efficiency, reduce waste, and ensure materials are available to meet production requirements. The analyst works closely with inventory, production, and supply chain teams to improve processes and support business goals.

Star Pipe Products is an Equal Opportunity Employer