Manager, Supply Chain Analytics

20600 Emerald Parkway, Cleveland, Ohio 44135 United States of America

Since 1916, Oatey has provided reliable, high-quality products for the residential and commercial plumbing industries, with a commitment to delivering quality, building trust and improving lives. Today, Oatey operates a comprehensive manufacturing and distribution network comprised of industry leading family of companies:
Oatey, Cherne, Keeney, Quick Drain, Hercules, Dearborn, Oatey Canada, William H. Harvey, Masters, Contact, Belanger, Lansas, and Durgo.

At Oatey, we're doing big things — and by joining us, you'll have the chance to do big things too. You can build a strong career in an innovative, inclusive, high-performance environment, with the confidence that your company cares — about you, our customers and our world. Ready to make an impact in a place where you matter?

The Supply Chain Analytics Manager will support the Planning, Purchasing, and Sourcing functions through advanced data analytics and reporting. This role will own and manage sourcing-related cost condition mass loads (including Tariffs, Freight, and Devanning costs) and develop Power BI dashboards and reports to drive visibility into spend, cost trends, and supplier performance. The analyst will work cross-functionally with Sourcing, Planning, Purchasing, IT, Customs Compliance, and Pricing teams to ensure data accuracy, and overall system optimization.

The ideal candidate has strong analytical acumen, expert-level Excel skills, and hands-on experience with SAP or a similar ERP system.

• Own and maintain sourcing cost condition mass loads for Tariffs, Freight, and Devanning within SAP.
• Collaborate with Customs Compliance to validate tariff rates and trade-related cost factors for accuracy.
• Partner with Pricing and Accounting teams to ensure sourcing cost changes (tariffs, freight, devanning) are accurately reflected in product cost models and margin analyses.
• Monitor and report on total landed cost impacts, highlighting cost drivers.
• Provide reporting for Monthly and Quarterly Commodity updates.
• Complete monthly Purchase Price Variance forecasting.
• Analyze purchasing trends, lead times, and supplier performance metrics to identify risks and opportunities.

• Create automation for planning and purchasing KPIs, including but not limited to Demand Planning Accuracy/Bias, production attainment, past due purchase orders and invoices, purchase requisitions, import purchase orders, and inventory levels.
• Collaborate with IT partners to develop analytics roadmaps for the supply chain and sourcing functions.

• Design dashboards and reporting tools to support real-time decision-making.
• Develop and maintain Power BI dashboards to visualize spend trends, supplier performance, cost variances, and planning/purchasing KPIs over time.
• Create and distribute standardized and ad hoc reports to stakeholders across Supply Chain, Pricing, Finance, and Sourcing.
• Leverage Excel (advanced formulas, pivot tables, macros, and data modeling) for in-depth analysis.
• Ensure data integrity between SAP, Power BI, and supporting systems in partnership with IT.
• Work closely with IT to troubleshoot data integration issues, enhance reporting automation, and optimize ERP/BI connectivity.

• 5+ years of experience in supply chain analytics, sourcing analytics, or a related analytical role.
• Hands-on experience with SAP or a comparable ERP system.
• Strong working knowledge of Power BI and advanced Excel (Power Query, Power Pivot, macros preferred).
• Expert-level Excel skills with the ability to manipulate and analyze large datasets.
• Strong analytical and problem-solving skills with keen attention to detail.
• Ability to translate data into actionable insights for business partners.
• Effective communication and presentation skills for cross-functional collaboration.
• Self-starter with a continuous improvement mindset and ability to manage multiple priorities.

• Bachelor’s degree in Supply Chain Management, Business Analytics, Finance, or a…