This role converts raw operational data into decisions that improve service, cost, and speed across our global supply chain. By building trusted metrics and actionable analytics, you will help us deliver on our mission and contribute to a culture that's "a Force of Nature" through smarter, more sustainable operations and inclusive teamwork.
Key Responsibilities
- Own core supply chain KPIs and publish weekly / monthly dashboards for forecast accuracy (MAPE / bias), customer service / OTIF, inventory turns / DOH, capacity utilization, production adherence, and supplier OTIF.
- Build robust data models that combine ERP (e.g., Oracle E‑Business Suite) with planning, logistics, and quality data; implement efficient SQL transformations and governed data sets for reuse.
- Develop self‑service analytics in Power BI (DAX / Power Query) and Excel for planners, procurement, manufacturing, distribution, and leadership-standardizing definitions and drill‑downs.
- Support S&OP : prepare demand / supply analytics, scenario modeling, and pre‑reads; quantify risks / opportunities and surface drivers that guide consensus.
- Inventory & service optimization : create diagnostic reports for safety stock, MOQ / EOQ health, lead‑time variability, slow / no‑move, and phase‑in / phase‑out; recommend actions with quantified impact.
- Data quality and governance : define data contracts, run data quality checks (completeness, timeliness, accuracy), and coordinate fixes for master data elements (items, suppliers, sites, BOMs).
- Automation & reliability : automate refreshes, alerting, and job orchestration; reduce manual effort in recurring reports through scripts / macros and documented pipelines.
- Ad‑hoc analysis and root cause : investigate exceptions (expedites, backorders, shortages), structure hypotheses, and translate findings into prioritized actions for planners and buyers.
- Business partnering : serve as the analytics point of contact for Planning, Procurement, Manufacturing, DC operations, Finance, and IT; communicate clearly with technical and non‑technical audiences.
- Continuous improvement : benchmark processes, capture user feedback, and iterate dashboards and models; contribute to analytics standards and best practices.
Core Skills
Working relationships
Internal : Planning, Procurement, Manufacturing, DC Operations, Quality, Finance (Supply Chain Finance), IT / Data.External : Select vendors, 3PLs, data / solution partners.Tools you'll use
Data & BI : Power BI, Excel (Power Query / Power Pivot), SQL (Oracle), Python (preferred), Power Automate (nice to have).Platforms : ERP (Oracle E‑Business Suite), data lake / warehouse (as available), SharePoint / Teams for collaboration.Methods : Agile delivery, version control and documentation standards.QUALIFICATIONS
Required
Bachelor's degree in Supply Chain, Industrial Engineering, Information Systems, Statistics, or related field.3–5+ years in supply chain analytics, planning, or operations with measurable business impact.Strong Power BI skills (DAX, Power Query) and advanced Excel (Power Pivot, complex formulas, scenario modeling).Experience working with ERP data (Oracle EBS or similar) across items, inventory, purchasing, work orders, and order management.Ability to translate business questions into datasets, metrics, and visuals; excellent story‑telling and stakeholder communication.Nice to Have (Optional but Valuable)
SQL for data extraction and transformation (joins, CTEs, window functions).Python (pandas) for data prep, analytics automation, or pipeline support.Experience with S&OP analytics, inventory optimization methods (ABC / XYZ, safety stock, EOQ / MOQ), or capacity modeling.Familiarity with data quality frameworks and master data governance.Certifications : APICS CPIM / CSCP , Microsoft PL‑300 (Power BI Data Analyst) .Measures of success (first 6–12 months)
30 days : onboard to data sources and definitions; publish a refreshed KPI catalog and data dictionary; deliver fast wins by stabilizing 2–3 recurring reports.60–90 days : launch a consolidated Supply Chain KPI dashboard with drill‑downs; reduce manual reporting time by ≥30%.6 months : implement data quality checks for top master data pain points; enable automated weekly S&OP analytics pack.12 months : deliver at least two analytics projects (e.g., safety stock right‑sizing, supplier OTIF visibility) yielding hard savings or service improvement .Nature's Sunshine is dedicated to being a Force of Nature that champions social and environmental wellness. We are focused on building a team of professionals with diverse backgrounds and experiences to become the natural supplement company of the future. By celebrating the individuality and unique perspectives of our workforce, we empower our employees to share the healing power of nature with more people around the world. And through our commitment to sustainable processes, renewable energy usage and waste reduction initiatives, we're devoted to preserving nature and its power for future generations.
We believe we are stronger together, and our ongoing commitment to diversity, equity, inclusion and belonging ensures that every employee is treated with fairness and respect. Because doing what's right-in the right way-is how we succeed as a company and a society.
Job Posted by ApplicantPro