Apply on Employer Site

Oatey Company · 3 weeks ago

Manager, Supply Chain Analytics

Cleveland, OH (Headquarters)

Full-time

Hybrid

Senior Level

$73K/yr - $117K/yr

5+ years exp

Oatey Company is a well-established provider of plumbing products since 1916, committed to quality and innovation. The Supply Chain Analytics Manager will support planning, purchasing, and sourcing through advanced data analytics, managing cost conditions, and developing dashboards to enhance visibility into spend and supplier performance.

Building Material

Responsibilities

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

Qualification

Supply Chain AnalyticsSAPPower BIAdvanced ExcelAnalytical SkillsCommunication SkillsProblem-Solving SkillsSelf-Starter

Required

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

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

Preferred

Strong working knowledge of Power BI and advanced Excel (Power Query, Power Pivot, macros preferred)

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.

Company

Oatey Company

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.

Founded in 1916

Cleveland, Ohio, USA

1001-5000 employees