USPTM Data Analyst - Operations

US Premier Tube Mills•Madison, IN

4d•Onsite

About The Position

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. 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.

Requirements

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.
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.
Bachelor’s Degree preferred — Analytics, Industrial Engineering, Supply Chain, Data Science, Business Analytics, Mathematics, or related field.
Equivalent experience with strong technical skills considered.
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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.