Skills that the intern will gain/enhance through this experience include:
Basic understanding of Stepan spend and key influences through utilization of spend analytic models
Enhanced Excel formula creation and utilization
Experience in SAP and Zycus
High level raw material feedstock learnings
Professional communication
Spend Analytics – Provides global spend ($1.5+ billion) analytics to Procurement, Business and Supply Chain stakeholders on both direct and indirect spend categories. Analysis made available by business, region, country and site and available in Direct and Indirect material categories and subcategories. Supports provision of spend analytics for procurement conferences, supplier meetings and to enable sourcing strategy revision and development, working in collaboration with Commodity Managers.
Works heavily on processing, cleansing, and verifying the integrity of data used for analysis.
Intern will work heavily on assisting the Sr Sourcing Analyst cleanse our global spend data, as well as building a canned report and dashboard suite in the new Zycus tool. Intern will also assist the Category Managers on ad hoc reporting needs.
Global Spend Forecasting and Awareness – Coordinate the collection and reporting of Global Direct Materials procurement forecasting. The Intern will attend weekly forecast calls and assist the Sr Sourcing Analyst in providing the latest statistics on material forecasting pricing trends. The Intern will also attend the North America Monthly Marketing Meetings.
Update the weekly reporting of Raw Material forecasting and Sales information for the Global Tuesday morning calls.
Qualifications
Credentials Required: The suitable candidate for this position will, at minimum, be a college student working towards fulfilling the degree requirements of a Bachelor’s Degree with focus in Procurement/Supply Chain or closely-related field.
Job: Procurement
Primary Location: United States-Illinois-Northbrook
Schedule: Full-time
Job Posting: Jun 10, 2019
Recruiter: Erin L Ellen
BenU Undergrad Business 