Procurement Analyst

Fareva is currently seeking a Procurement Analyst to join our Procurement – USA team. This position is on-site and is based out of Fareva Morton Grove (16 miles north of Chicago and within walking distance from the Golf Metra Station).

Who we are:

Fareva USA is one of the top 3 Global leaders in contract manufacturing with more than 13,000 employees, 800 customers, and 40+ manufacturing sites in Europe, the Americas, and the emerging markets. Fareva, headquartered in Luxembourg, has revenues of US$2.5 billion and is divided into five core areas: household & industrial, beauty care, pharmaceutics, API, and makeup.

About the role:

Fareva USA has an immediate opening for a Procurement Analyst position in Morton Grove, IL. The Procurement Analyst reports to the Business Process Manager and plays a vital role in the Fareva Procurement team. The Procurement Analyst will support Procurement USA leadership, the category managers, and the new product development buyer in tracking spend, performance of suppliers, costs, and OTIF metrics. As Fareva is a global company, there will be opportunities to work with and support other Fareva locations around the world. Responsibilities include tracking cost savings projects, continuous improvement activity, and procurement dashboard development and maintenance. The Procurement Analyst will be asked to assist in identifying and assessing sourcing opportunities with supplier relationship management and supplier service levels.

What you’ll do:

Responsibilities include but are not limited to:

• Maintain spend database including attributes that provide insights into our monthly spend and pricing patterns
• Support monthly Procurement supplier reporting and request category manager/buyer’s reviews for supplier scorecards
• On Time In Full (OTIF) Reports
• Spend by supplier/material/family/subfamily
• Savings
• Collaborate with the Finance department for analysis and tracking of general expenses and departmental savings
• Collaborate with the Corporate Procurement team based in France in charge of managing the Company’s procurement data
• Update material price quarterly for the R&D cost estimation tool
• Track and report monthly on price changes in SAP by category by product for review and update Purchase Price Variance (PPV) reports to support Procurement, Operations and Sales
• Develop and maintain process to obtain market intelligence on raw material and packaging feed stocks, indirect spend, and assist in providing material price forecasts for internal stakeholder communications and budget planning purposes as required
• Validate payment terms on the monthly scorecard to enable monthly reports and communicate discrepancies to category managers/buyers
• Create, analyze and recommend Minimum Order Quantity (MOQ) and Economic Order Quantity (EOQ) for raw & packaging materials monthly
• Develop and maintain a detailed supplier database including a supplier profile, product offerings, spend history by product (price, quantity, total spend), key feedstock by product, production and distribution center locations
• Document and maintain a standard operating procedure for all the reports and activities this role is responsible for
• Support data collection for raw & pack materials, and indirect library
• Create and develop new reporting that supports process improvement and business intelligence
• Contribute to process improvement work both within and outside of the Procurement department

Our ideal candidate:

Location

• Must be eligible to work in the US, as our company is not currently sponsoring work visas.
• Ideal candidate lives in the Chicago, Il. area, or is planning to relocate on their own; there is no relocation package with this position.

Education and experience

• Bachelor’s degree from an accredited university or college in business analytics, physics, mathematics, computer science, engineering, statistics, economics, or finance

• 0-3 years of experience with business analytics and reporting

Skills and abilities:

• Advanced Excel skills (i.e. index match function, pivot table, macros, VBA)
• Working knowledge of Qlik Sense, Business BI, Tableau, or business analytics software
• Working knowledge of Enterprise resource planning -- SAP knowledge is preferred
• Experience with dashboard design and key performance indicators tracking
• Working knowledge of supply chain and sourcing is a plus
• Strong interpersonal skill to collaborate with other functions for collecting data
• Ability to translate business requirements into non-technical, layman terms
• Demonstrated follow through and self-starter
• Detail-oriented and highly analytical with excellent problem-solving skills
• High-level written and verbal communication skills
• Previous analytical experience is preferred

Job Requirements

• 5 to 10% Travel
• In office 5 days a week
• Language: English is a must; additional language such as French, Portuguese or Spanish is preferred

What we offer:

Competitive salaries, comprehensive health/vision/dental insurance, company paid short term disability, company paid life and accidental death insurance, 401(k) plan match of 4.5% with immediate vesting, generous employee referral program, 15 days of vacation annually, paid holidays annually, onsite cafeteria, job advancement opportunities. Manufacturing employees also receive company paid work shoes, uniforms and prescription safety eyeglasses.