Product Analyst

Wheatland Tube, LLC; Farrell (Mercer County); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical and dental benefits

Tuition assistance

401(k) with company match

Job summary

Zekelman Industries seeks a Product Analyst to deliver analytical insights that drive profitability and portfolio strategy. You will transform data into recommendations, support pricing governance, and develop dashboards to monitor performance across manufacturing and supply chain.

Based in Sharon, PA or Niles, OH, the role emphasizes collaboration with sales, operations, and planning teams, leveraging ERP/BI tools and AI-enabled analytics to improve margins and inventory efficiency.

Qualifications

• Bachelor's degree in Engineering, Business, Finance, Supply Chain, Analytics, Operations Management or related field.
• Five or more years of experience in business, operations, pricing, or commercial analytics within a manufacturing environment.
• Experience applying 80/20 or similar portfolio optimization methodologies.
• Strong analytical, problem-solving, and data interpretation skills.
• Proven ability to lead cross-functional initiatives and influence stakeholders.
• Advanced Excel and AI-enabled analytics skills, including experience with ERP and business intelligence systems.
• Experience developing dashboards, reports, and analytical models.
• Strong verbal and written communication skills.
• Experience in steel, metals, tubing, engineered products, or other manufacturing environments preferred.
• Experience in pricing, profitability, operational, or product portfolio analytics preferred.

Responsibilities

• Analyze product portfolios to identify opportunities for growth, margin improvement, and capacity optimization.
• Develop portfolio performance dashboards and provide actionable recommendations.
• Quantify operational and financial impact across manufacturing, inventory, and supply chain.
• Monitor margins, cost, pricing, and profitability trends and report results.
• Create reporting tools supporting pricing governance and business performance management.
• Develop dashboards, reports, and analytical models for executives.
• Improve data quality and consistency across business systems to enable decision-making.
• Support implementation and continuous improvement of reporting platforms and BI systems.
• Automate reporting and analysis processes to improve efficiency.

Skills

Advanced Excel

Power BI

SQL

Tableau

ERP

CRM

Pricing analytics

Portfolio optimization

Forecasting

Data analysis

Education

Bachelor's degree

Tools

AI-enabled analytics tools

BI tools

Pricing tools

Job description

You may not know our name, but you know our products. What we make is part the places where we live, work and play – all day, everyday.Zekelman is a family of companies — 100% domestic manufacturers — with a legacy dating back to 1877. We’re proud to be the largest independent steel pipe and tube manufacturer in North America and the leading innovator in multi-family housing development.We believe in what we build and what we build, builds the world around us. Hospitals, hotels, schools, bridges, airports and more.Come build a career you believe in.JOB SUMMARYThe Product Analyst provides the analytical insights that support Sharon Tube's business strategy and profitability objectives. Partnering closely with cross-functional leaders, this role transforms data into actionable recommendations that improve margins, optimize inventory and capacity, and enhance operational efficiency. The position develops analytical tools and reporting that enable informed decisions on pricing, product portfolio strategy, and business performance. The position reports to the Business Unit VP of Sales with dotted lines to the Director of Planning and the Business Unit President.JOB RESPONSIBILITIESProduct Portfolio AnalysisAnalyze product portfolios to identify opportunities for growth, margin improvement, capacity optimization, and complexity reduction.Utilize segmentation methods, 80/20, ABCxyz, AB12, and similar methodologies to support portfolio optimization and strategic decision-making.Evaluate product, customer, and market profitability and recommend rationalization, simplification, or growth strategies.Develop portfolio performance dashboards and provide actionable recommendations aligned with business objectives.Support long-term portfolio planning through data-driven insights.Operational, Supply Chain, Commercial, and Financial AnalysisQuantify the operational and financial impact of product complexity on manufacturing, inventory, scheduling, procurement, and supply chain performance.Analyze the operational and financial impacts of product complexity across manufacturing, inventory, scheduling, procurement, and supply chain activities.Track and report results of portfolio, pricing, and rationalization initiatives against established business goals.Develop pricing analytics and recommendations that support profitability and growth objectives.Monitor margin, cost, pricing, and profitability trends to identify improvement opportunities.Create reporting and tools that support pricing governance and business performance management.Maintain product and pricing data supporting e-commerce platforms and customer-facing tools.Business Intelligence and ReportingDevelop dashboards, reports, and analytical models that provide visibility into key business performance indicators against the Business Unit goals.Create recurring and ad hoc analyses supporting executive decision-making and strategic initiative execution.Improve data quality, accessibility, and consistency across business systems to strengthen organizational decision-making.Digital Tools and AnalyticsDevelop and enhance analytical tools that support product portfolio management, profitability analysis, forecasting, and strategic decision-making.Support implementation and continuous improvement of reporting platforms, databases, pricing tools, and business intelligence systems.Leverage ERP, CRM, and business intelligence systems to extract, organize, and analyze data that supports business performance improvement.Automate reporting and analysis processes where possible to improve efficiency, decision-making speed, and organizational effectiveness.EDUCATION / EXPERIENCEBachelor's degree in Engineering, Business, Finance, Supply Chain, Analytics, Operations Management, or a related field.Five or more years of experience in business, operations, pricing, or commercial analytics within a manufacturing environment.Experience applying 80/20 or similar portfolio optimization methodologies.Strong analytical, problem-solving, and data interpretation skills.Proven ability to lead cross-functional initiatives and influence stakeholders.Advanced Excel and AI-enabled analytics skills, including experience with ERP and business intelligence systems.Experience developing dashboards, reports, and analytical models.Strong verbal and written communication skills.Experience in steel, metals, tubing, engineered products, or other manufacturing environments preferred.Experience in pricing, profitability, operational, or product portfolio analytics preferred,Proficiency with AI, Power BI, Tableau, SQL, AI-enabled analytics tools, and related reporting platforms preferred.Knowledge of manufacturing operations, inventory management, supply chain processes, and cost accounting preferred.Travel RequirementsPosition based in Sharon, Pennsylvania, or Niles, OHTravel expected approximately 10%–20%.Zekelman Industries offers competitive compensation and excellent benefits, including low-cost, high-quality medical and dental benefits. In addition, we have an amazing tuition assistance program, a bonus plan, a 401(k) plan with a generous company match, immediate vesting, and much more.M/F/D/VWe are Zekelman Industries.We manufacture superior quality tubular and related products, and provide outstanding service for our valued customers.We seek to continuously advance the skills and opportunities of our employees, utilizing the latest technology and management tools available to consistently increase profitability and the enterprise value of Zekelman Industries and of our customers.