Manager, Supply Chain Analytics

Oatey Company • Cleveland, OH

19h • Hybrid

About The Position

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.

Requirements

• 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 related field, or equivalent relevant experience in lieu of degree.

Responsibilities

• Sourcing Analytics & Cost Management
• 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.
• Planning & Purchasing Analytics
• 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.
• Reporting & Visualization
• 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.

Benefits

• Generous paid time off programs and paid company holidays to support flexibility and work-life balance
• Annual Discretionary Cash Profit Sharing
• Immediate eligibility and vesting in 401(k), including 100% company match, up to 5% of eligible compensation
• Market leading health insurance including medical, dental, vision, and life insurance offerings for associates and qualified dependents
• Significant company contribution to Health Savings Account with a High Deductible Health Plan (HDHP)
• Short-Term and Long-Term Disability income protection coverage at no cost to associates
• Paid Maternity and Paid Parental Leave
• Tuition reimbursement
• A strong set of complementary resources to support associate well-being, including resource groups, EAP, and dedicated mental health support.

What This Job Offers

• Job Type: Full-time
• Career Level: Manager
• Number of Employees: 501-1,000 employees