Product Analytics & Portfolio Strategist

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

Benefits offered by this job

Tuition Assistance Program

Bonus Plan

401(k) with Company Match

Health, Dental & Vision Insurance

Paid Vacation & Holidays

Employee Loyalty Awards

Job summary

Sharon Tube, a division of Zekelman Industries, seeks a Product Analyst to provide analytical insights supporting strategy, profitability, and operational excellence.

You will collaborate with commercial, operations, supply chain, planning, finance, and executive leadership to drive data-driven decisions in a fast-paced manufacturing environment located on-site in Sharon, PA or Niles, OH, with 10–20% travel.

Qualifications

• Five or more years of experience in business, operations, pricing, commercial analytics, or a related analytical role within a manufacturing environment.
• 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.

Responsibilities

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

Skills

Advanced Excel

BI platforms

Dashboards & Reports

Data Visualization

Cross-functional collaboration

Communication skills

Problem solving

Education

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

Tools

Power BI

Tableau

SQL

ERP systems

Job description

Sharon Tube, a division of Zekelman Industries, seeks a Product Analyst to provide analytical insights supporting strategy, profitability, and operational excellence.

You will collaborate with commercial, operations, supply chain, planning, finance, and executive leadership to drive data-driven decisions in a fast-paced manufacturing environment located on-site in Sharon, PA or Niles, OH, with 10–20% travel.