US PREMIER TUBE MILLS · 16 hours ago
USPTM Data Analyst - Operations
US-IN-Madison
Full-time
Onsite
Mid LevelUS Premier Tube Mills (USPTM) is a leading steel manufacturing facility dedicated to operational excellence, safety, and continuous improvement. They are seeking a highly analytical Operations Data Analyst to support production planning, reporting, and drive performance improvements across manufacturing processes. The role involves data analysis, reporting, and collaborating with operations teams to enhance productivity and operational efficiency.
Consumer Goods
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
Qualification
Required
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
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
Preferred
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
Company
US PREMIER TUBE MILLS
Located in the heartland of southern Indiana, US Premier Tube Mills is manufacturing steel fence pipe and tubing products for you! We are a domestic manufacturer of domestic steel posts made from only domestic steel sources.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase