Product Analyst

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 SUMMARY The 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 RESPONSIBILITIES Product Portfolio Analysis Analyze 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 Analysis Quantify 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 Reporting Develop 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 Analytics Develop 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 / EXPERIENCE Bachelor'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 Requirements Position based in Sharon, Pennsylvania, or Niles, OH Travel 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/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.