Product Analyst

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

Benefits offered by this job

401(k) match

Health, dental & vision

Tuition assistance

Paid vacation & holidays

Profit-sharing opportunities

Job summary

Sharon Tube, a division of Zekelman Industries, seeks a Product Analyst to provide analytical insights shaping strategy, profitability, and operational excellence. The role collaborates across commercial, operations, supply chain, planning, finance, and executives in a fast-paced manufacturing setting.

On-site in Sharon, PA or Niles, OH with 10–20% travel. You will build dashboards, analyze pricing, and drive data-driven decisions to improve margins and portfolio performance.

Qualifications

• Bachelor’s degree in Engineering, Business, Finance, Supply Chain, Analytics, Operations Management, or a related field.
• Advanced proficiency in Excel, ERP systems, business intelligence platforms, and AI-enabled analytics tools.
• Experience developing dashboards, reports, analytical models, and data visualization solutions.

Responsibilities

• Analyze product portfolios to identify opportunities for growth, margin improvement, capacity optimization, and complexity reduction.
• Develop portfolio performance dashboards and deliver actionable recommendations aligned with business objectives.
• Quantify operational and financial impacts of product complexity across manufacturing, inventory, procurement, scheduling, and supply chain activities.
• Track and report results of pricing, portfolio, and rationalization initiatives against established business objectives.
• Create reporting tools and analytics that support pricing governance and business performance management.

Skills

Advanced Excel

ERP systems

BI platforms

Dashboard development

Cross-functional leadership

Communication skills

Power BI

Tableau

SQL

Education

Bachelor’s degree in Engineering, Business, Finance, Supply Chain, Analytics, or Operations Management

Tools

Power BI

Tableau

SQL

ERP systems

AI-enabled analytics 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.

About the Role

As a Product Analyst at Sharon Tube, a division of Zekelman Industries, you will play a key role in providing the analytical insights that support business strategy, profitability, and operational excellence. This position requires strong analytical capabilities, strategic thinking, and the ability to translate complex data into actionable recommendations. It offers the opportunity to contribute directly to margin improvement, portfolio optimization, pricing effectiveness, inventory performance, and overall business growth. You will collaborate with commercial, operations, supply chain, planning, finance, and executive leadership teams, ensuring data-driven decisions support key business objectives and long-term strategic initiatives. This is an on-site role located in Sharon, PA or Niles, OH, with approximately 10%-20% travel required. This role is perfect for someone who thrives in a fast-paced manufacturing environment, enjoys solving complex business problems through analytics, and is passionate about driving measurable results through data-driven decision making.

What You’ll Do

• Analyze product portfolios to identify opportunities for growth, margin improvement, capacity optimization, and complexity reduction.
• Apply segmentation methodologies, including 80/20, ABCxyz, AB12, and similar analytical frameworks to support portfolio optimization and strategic decision-making.
• Evaluate product, customer, and market profitability to recommend rationalization, simplification, and growth strategies.
• Develop portfolio performance dashboards and deliver actionable recommendations aligned with business objectives.
• Quantify the operational and financial impacts of product complexity across manufacturing, inventory, procurement, scheduling, and supply chain activities.
• Track and report results of pricing, portfolio, and rationalization initiatives against established business objectives.
• Develop pricing analyses and recommendations that support profitability and revenue growth.
• Monitor margin, cost, pricing, and profitability trends to identify opportunities for improvement.
• Create reporting tools and analytics that support pricing governance and business performance management.
• Maintain product and pricing data supporting e-commerce platforms and customer-facing tools.
• Develop dashboards, reports, and analytical models that provide visibility into key business performance indicators.
• Create recurring and ad hoc analyses that support executive decision-making and strategic initiative execution.
• Improve data quality, accessibility, and consistency across business systems to strengthen organizational decision-making.
• Develop and enhance analytical tools that support product portfolio management, profitability analysis, forecasting, and strategic planning.
• Support the 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 drives business performance improvement.
• Automate reporting and analysis processes to improve efficiency, decision-making speed, and organizational effectiveness.
• Lead and promote healthy and safe work practices as required by regulatory agencies and Company policy.
• Perform other duties as assigned.

Who You Are

Five or more years of experience in business, operations, pricing, commercial analytics, or a related analytical role within a manufacturing environment, preferably in steel, metals, tubing, engineered products, or related industries.

Bachelor’s degree in Engineering, Business, Finance, Supply Chain, Analytics, Operations Management, or a related field.

Advanced proficiency in Excel, ERP systems, business intelligence platforms, and AI-enabled analytics tools.

Experience developing dashboards, reports, analytical models, and data visualization solutions.

Strong analytical, problem-solving, and data interpretation skills with the ability to convert findings into actionable business recommendations.

Proven ability to lead cross-functional initiatives and influence stakeholders across multiple levels of the organization.

Excellent verbal and written communication skills.

Experience applying 80/20 or similar portfolio optimization methodologies.

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

What You’ll Get

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, loyalty awards, and much more:

• Competitive Compensation Bonus Plan & Profit-Sharing Opportunities
• 401(k) with Company Match
• Comprehensive Health, Dental & Vision Insurance
• Tuition Assistance Program
• Paid Vacation & Holidays
• Employee Loyalty Awards
• Compensation & Benefits

The base salary for this position will be determined based on experience, education, skill set, and interview performance.

Additional compensation may include:

• Yearly merit increase
• Profit-sharing bonus opportunities

M/F/D/V

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