The Procurement Analyst supports the Strategic Sourcing Procurement team through the collection, management, and analysis of data. This role partners with internal Procurement managers, collaborates with external supplier community as well as internal cross functional teams to ensure data accuracy, increase forecast accuracy, drive audit compliance, and arrive at practical solutions for business challenges. The Procurement Sourcing Analyst will be a critical member of the procurement team providing analytical rigor and technical expertise to produce fact-based summary information enabling Procurement personnel to improve sourcing decisions.
Key Job Activities/Key Activities
Reports to Sr. Manager, Procurement Center of Excellence, supports a team of strategic sourcing, global supplier quality, and replenishment procurement professionals. Works with other procurement and operations analysts as well as team members from other departments including Production Planning, Operations, Material Management, Master Data and Finance.
Design template, gather and scrub data, and evaluate complex RFx data submitted by participants for selection of vendor that will provide the best price, service level, and quality combination. Agree on selection criteria for selection. Continue to work with the organization on P2P and electronic RFx.
Provide data analysis and strategic support to procurement leadership to execute successful integration of recently acquired brands into Ferrara procurement process as well as to assist in bringing current reporting to a higher level.
Provides project management support for each strategic sourcing event including time management, communication, and timely completion.
Super user for all sourcing and reporting modules. Responsible for the creation and execution of sourcing events and develop accurate detailed analysis at conclusion of the strategic sourcing events.
Provides data analysis with preliminary explanations for manager review and improvement recommendations for category spend.
Develop, implement, and maintain Vendor Scorecard. Prepare and hold business reviews with stakeholders to review and improve supplier performance.
Create cost models that accurately reflect financial impact for sourcing scenarios, reporting, forecasting and budgeting.
Creates customized reporting for internal reporting, negotiations, and managerial decision making.
To gain organizational efficiencies, supports policy development, implementation and maintenance of Outline Agreements, Framework Purchase Orders, Purchase Information records, Source list, GR/IR -Tolerances (3-way matching), and other Procurement activities encouraging spend compliance and standardization for the organization.
Support the "3-way match" process (Purchase Order, Goods Receipt, Invoice Receipt); act as a liaison/resolution implementer between finance/AP, warehouse management, and procurement to define tolerance, and address individual purchase order/invoice discrepancies to limit financial exposure.
Support the budgeting and forecasting process for assigned categories in addition to assisting with creating spreadsheets and executing the overall budgeting and forecasting process.
Work with assigned managers to resolve blocked invoice issues on the weekly MRBR Report as well as creating the overall MRBR Report.
Review Daily Finance PPV Report circulated by the IT team for accuracy and confirm if variances are correct or if the POs need to be updated.
Work with the PO Material Planners to resolve PO quantity and price issues prior to PO creation and goods receipt.
Create new reports as assigned including, but not limited to, indirect plant purchasing, capital purchasing, marketing and temporary labor spend cubes.
Work on assigned tasks for both the Nestle and Kellogg's integrations.
Complete monthly contract balancing and commodity reporting including forecasting for assigned categories ensuring that data is consistent across related reports.
Must be able to build and retain knowledge of assigned categories to understand the underlying business trends including production changes and commodity component price changes.
Assists with departmental process and reporting improvements including new direct and indirect reporting system development and implementation.
2+ years' experience preferably in a Supply Chain-Procurement environment
Experience with SAP ECC, SAP QM, SAP Business Objects, SAP Master Data required.
Experience with SAP Product Lifecycle Management is a plus.
Experience with Ariba, Coupa or a similar indirect spend management system is a plus.
Experience with Sievo or a similar direct spend management system is a plus.
Experience extracting data, developing reports and presenting findings/results to internal customers.
Experience in a disciplined, yet constantly changing, operating environment, in a matrix organization
Excellent time management skills and method based approach to project management
Advanced Excel skills and PowerPoint familiarity are required along with an understanding of data relationships and the ability to construct complex files.
Ability to work independently on new assignments which require report/project development researching the correct data sources and solutions with manager alignment
Food background a plus but not required
Individual should be detail oriented, analytical, organized, with strong communication skills
Ability to clarify expectations up front and provides accurate project effort estimates
A can-do attitude within a matrix organization and ability to navigate in external supplier environment.
Ability to function in rapidly changing, post integration environment with multiple sets of stakeholders
Understands the origin and reasoning behind key procurement policies, practices and procedures
Must be able to work with Procurement Managers and other departments to resolve procurement related issues in a timely and positive manner.
Must be able to attend to a broader range of activities and changing priorities including multi-tasking, as necessary
Must be flexible, agile, results and deadline driven
We are proud to be an equal opportunity employer. In order to provide equal employment and advancement opportunities to all qualified applicants and employees, employment decisions and opportunities at Ferrara will be based on merit, qualifications, and abilities, without regard to race, color, creed, religion, sex, sexual orientation, gender identity and expression, marital or civil union status, national origin, ancestry, citizenship, age, military or veteran status, disability, handicap, genetic information, pregnancy (childbirth or related medical condition), or on any other basis prohibited by law. This policy governs all aspects of employment, including selection, job assignment, compensation, discipline, termination, and access to benefits and training.