USPTM Data Analyst - Operations

About USPTM

US Premier Tube Mills (USPTM) is a leading steel manufacturing facility dedicated to operational excellence, safety, and continuous improvement. We are seeking a highly analytical and production-savvy Operations Data Analyst to support production planning, department reporting, enhance data-driven decision-making, and drive performance improvements across our manufacturing processes.

Position Summary

The Operations Data Analyst will play a crucial role in applying data analysis and reporting to support operational performance, production scheduling, and process improvements. This position will work closely with operations teams to assist in scheduling tasks as needed, while also owning analytics processes, reporting, and data-driven insights that improve productivity, quality, and throughput.

This is an on-site, full-time position in Madison, Indiana. Hybrid or remote work is not available.

• Key Responsibilities

  Operations Support

  • Work with the Production Planning and Operations teams to assist with scheduling and capacity planning tasks as required.
  • Support production workflow adjustments based on real-time data analysis and operations needs.
  • Assist in coordinating production schedules, communicating changes, and tracking execution performance.

  Data Analysis & Reporting

  • Develop, maintain, and automate dashboards and reports to monitor key production, quality, and performance metrics.
  • Analyze manufacturing data to identify bottleneck processes, trends, anomalies, and improvement opportunities.
  • Translate complex datasets into actionable insights for operations leadership.

  Data Management & Systems

  • Design and maintain SQL queries, stored procedures, and data models to support reporting and analytics needs.
  • Ensure data integrity, accuracy, and consistency across systems (ERP/MRP, Excel models, and other data sources).
  • Collaborate with IT/Systems teams to extract and integrate data from multiple sources for analysis.

  Process Improvement

  • Partner with Operations and Continuous Improvement teams to standardize analytical tools and decision-support systems.
  • Support root cause analysis and problem-solving efforts using data and statistical methods.
  • Recommend actionable strategies to improve throughput, reduce waste, and increase operational efficiency.

• Required Qualifications

  Technical Skills

  • Strong SQL skills: ability to write complex queries, join large datasets, optimize performance, and produce reliable analytical outputs.
  • Advanced Excel expertise: pivot tables, VLOOKUP/XLOOKUP, Power Query, macros/VBA a strong plus.
  • Experience with data visualization tools (Power BI, Tableau, or similar) preferred.
  • Comfortable working with large datasets and generating meaningful insights.

  Production Experience

  • Understanding of production planning, operations workflows, and scheduling concepts — ideally in a manufacturing/industrial environment.
  • Prior work in supporting production operations with analytical tools or capacity planning.

  Education

  • Bachelor’s Degree preferred — Analytics, Industrial Engineering, Supply Chain, Data Science, Business Analytics, Mathematics, or related field.
  • Equivalent experience with strong technical skills considered.

  Other Requirements

  • Must be able to work on-site in Madison, Indiana, full-time.
  • Excellent communication skills with the ability to present analysis and recommendations clearly to non-technical teams.
  • Strong organizational skills and ability to manage multiple priorities in a fast-paced environment.
  
  

   Preferred Qualifications

  • Experience with manufacturing ERP/MRP systems.
  • SQL Server, MySQL, PostgreSQL, or similar database experience.
  • Familiarity with scheduling tools or production modules within ERP systems.
  • Knowledge of Lean Manufacturing or Continuous Improvement methodologies.