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.
Own and maintain sourcing cost condition mass loads for Tariffs, Freight, and Devanning within SAP.
Ensure data integrity between SAP, Power BI, and supporting systems in partnership with IT.
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.
Work closely with IT to troubleshoot data integration issues, enhance reporting automation, and optimize ERP/BI connectivity.
Develop and maintain Power BI dashboards to visualize spend trends, supplier performance, cost variances, and planning/purchasing KPIs over time.
Provide reporting for Monthly and Quarterly Commodity updates.
Analyze purchasing trends, lead times, and supplier performance metrics to identify risks and opportunities.
Create and distribute standardized and ad hoc reports to stakeholders across Supply Chain, Pricing, Finance, and Sourcing.
Design dashboards and reporting tools to support real-time decision-making.
Collaborate with Customs Compliance to validate tariff rates and trade-related cost factors for accuracy.
Requirements
power bi
excel
sap
bachelor's
5+ years
problem solving
Self-starter with a continuous improvement mindset and ability to manage multiple priorities.
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.
Bachelor’s degree in Supply Chain Management, Business Analytics, Finance, or a related field, or equivalent relevant experience in lieu of degree.
Leverage Excel (advanced formulas, pivot tables, macros, and data modeling) for in-depth analysis.
Strong analytical and problem-solving skills with keen attention to detail.
Effective communication and presentation skills for cross-functional collaboration.
Ability to translate data into actionable insights for business partners.
Hands-on experience with SAP or a comparable ERP system.
5+ years of experience in supply chain analytics, sourcing analytics, or a related analytical role.
Benefits
Immediate eligibility and vesting in 401(k), including 100% company match, up to 5% of eligible compensation
Paid Maternity and Paid Parental Leave
Generous paid time off programs and paid company holidays to support flexibility and work-life balance
Significant company contribution to Health Savings Account with a High Deductible Health Plan (HDHP)
Market leading health insurance including medical, dental, vision, and life insurance offerings for associates and qualified dependents
Annual Discretionary Cash Profit Sharing
Tuition reimbursement
A strong set of complementary resources to support associate well-being, including resource groups, EAP, and dedicated mental health support.
Short-Term and Long-Term Disability income protection coverage at no cost to associates
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
Founded in 1916
Year Established
Reflecting over a century of innovation and trust in the plumbing industry.
The company specializes in solutions for both residential and commercial markets, delivering high-quality products like pipe repair materials, adhesives, and faucets.
Oatey’s product portfolio is designed to support a wide range of projects, from routine residential plumbing repairs to large-scale industrial applications.
Oatey’s longstanding reputation is rooted in innovation, constantly adapting to meet the evolving needs of the plumbing industry.
Oatey’s commitment to reliability and performance has made it a go-to provider for contractors and professionals across various sectors.
Through its decades of experience, Oatey has cultivated a deep understanding of the plumbing landscape, creating products that are trusted in both routine and critical applications.
Oatey’s growth trajectory is marked by strategic acquisitions, expanding its product offerings and geographic footprint across North America.
Culture + Values
Collaboration: Work together to achieve shared goals
Integrity: Honor God in all we do. Be honest and have strong moral principles.
Respect: For oneself, each other, our environment, and our business relationships. Embrace diversity and be empathetic.
Courage: Take initiative and be accountable.
Leadership: Set the standard within our community, our markets, our industry, and with our associates.
Excellence: Performance driven to maximize opportunities
Environment + Sustainability
>20% recycled materials
sustainable construction materials
The company's Cleveland headquarters used more than 20% recycled materials in its construction.
Sustainability strategy anchored in three pillars: minimizing operational footprint; developing products that solve environmental problems; encouraging ecologically sensitive community practices
LEED-certified Distribution Center and Customer Support Center in Cleveland, plus Las Vegas Distribution Center designed to reduce resource consumption, lower costs, and enhance associate well-being
Cleveland headquarters achieved LEED Gold (New Construction) certification in 2018, featuring water-saving fixtures using rainwater cisterns, energy-efficient LED lighting and HVAC, diversion of construction waste, renewable project materials, and enhanced indoor air quality
No official net-zero target date publicly stated
Inclusion & Diversity
Committed to creating an inclusive and equitable environment where everyone can be their authentic self.
Strategy includes recruiting and retaining a diverse workforce.
Strategy also includes collaborating with a diverse supplier base.
Engages with the community on DE&I topics.
Does not publicly share gender-related statistics.