Why Oatey?

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?

-

Position Summary:
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.

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

Knowledge and Experience:

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

Education and Certification:

• Bachelor’s degree in Supply Chain Management, Business Analytics, Finance, or a related field, or equivalent relevant experience in lieu of degree.

#LI-SV1

#LI-Hybrid

Compensation Range for the Position:

Target Cash Profit Sharing for the Position:

Offer amount determined by experience and review of internal talent.

Oatey Total Rewards

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

Equal Opportunity Employer

The Oatey family of companies are an equal opportunity employer committed to Diversity, Equity, and Inclusion. We recruit, employ, promote, and offer competitive pay for all jobs without regard to race, color, creed, religion, sex, age, national origin, disability, sexual orientation, or any other characteristic protected by law.