The closing date of this role will be April 7, 2014.
The Procurement Analyst supports strategic sourcing operations of the Group and Business Units (BU) by collecting, analyzing, and managing data to provide key insights for actionable improvements to the procurement process. The Procurement Analyst will become a key member of the Group and BU Strategic Sourcing teams, providing analytical rigor and technical expertise to produce fact based summary information enabling Senior Procurement personnel to improve their sourcing decisions. This role will help develop Procurement related dashboards and metrics in support of strategic and tactical sourcing as well as Procure to Pay processes.
This position will process, extract, and query data to help make decisions., run optimization software which will require query experience (i.e. SQL) to provide multi-variable solutions based upon the sourcing team’s constraints.
This role will reside at the Group level, supporting the Group and BUs, while getting training support and taking strategic and tactical advice from the Global Sustainable Procurement (GSP) Center of Excellence (COE) Analytics or GSP Marketing Procurement. Based upon the specific strategic project, spend from the Group level, BU level and even Bottler level may be in scope.
KEY DUTIES/RESPONSIBILITIES:
- Gather and analyze key procurement metrics using data collection techniques (e.g., downloading of transactional data to spreadsheet format) in order to report results to Senior Management to be used in business plan and strategy development; Develop savings and avoidance reports, if not in place
- Create databases to collect and report information using telephones, computers or collaboration with third parties in order to provide customers with intellectual data
- Extract, analyze and report mainframe / system data in order to improve supply chain efficiencies using Company sponsored software (e.g., Showcase, DBS, SAP, JD Edwards, Excel, Access)
- Synthesize data and identify problems through operational and financial analysis in order to improve operational and financial performance
- Build dashboards and metrics from the tactical buying activity which informs leaders of values, opportunities, and prioritizations.
- Analyze performance data in order to identify business plan variances using established systems and ad-hoc problem solving; Maintain database to track Marketing Support funds from suppliers
- Maintain and update all group volume and spend reporting for use in general communications and internal/external stakeholder inquiries in order to facilitate accurate volume – related transactions & reporting
- Assist in the development of cost models, data collection and measurements to provide regarding product performance and services
- The position will be expected to communicate primarily with internal stakeholders (Group, BU, GSP, and Bottlers), but will also have discussions with external suppliers and 3rd party (e.g., consultants, industry organizations). The position will be responsible for collecting, ensuring accuracy and cleansing data provided from multiple sources for use in routine and complex problem solving. The position will provide summary information and insights gleaned from independent analysis. From time to time, the position will be called upon to prepare and present reports to Group, BU and GSP leadership.
- The position requires a deep understanding of quantitative analysis and the proper handling and interpretation of data coming from multiple sources. The position will be responsible for populating and maintaining complex databases to provide fact-based information for multiple procurement categories. Additionally, Procurement Analysts will be called upon to provide analytical support during the supplier evaluation and negotiation process. The position will be expected to handle a significant amount of data which provide fundamental support to Category managers as they develop, execute and manage sourcing strategies.
- The position will ensure Category Managers receive summaries of key data collected and insights gained from analysis completed.
- P2P systems are designed to provide organizations with control and visibility over the entire lifecycle of a transaction – from the way an good or service is requested to the way that the final invoice is processed – providing full insight into cash flow and financial commitments. The position will be expected to communicate with internal stakeholders (Group, BU, and GSP), external suppliers, and 3rd party organizations (e.g., consultants, industry organizations). The position will be responsible for synthesizing multiple streams of data into clear and concise reports. The position will be called upon to prepare and present reports to Procurement leadership on a frequent and routine basis.
- The position will be responsible for collecting and verifying the accuracy of data used in the development and implementation of complex models and decision frameworks. In completing this work, the position will develop techniques to improve the collection and verification of the data which we then expected to document and share the processes as best practices.
TECHNICAL SKILLS:
- Customer Focus: Making customers (external and internal) and their needs a primary focus of one's actions; developing and sustaining productive customer relationships; creating and executing plans and solutions in collaboration with the customer
- Data Extraction: Ability to extract and query data from systems (e.g., PAPA$, SAP, Focus, Billing and Promotions, Nielsen, Compass, PLUS, OPS, MEM, Messenger)
- Data Validation: Knowledge of and ability to understand and resolve data inconsistencies or variances
- Information Systems: Knowledge and use of existing KO Technical Information Systems (e.g., JDE, DBS, SAP, Intranet) to generate necessary data; Ability to access, analyze and use information in a manner that adds value to the organization; Ability to propose system enhancements based upon business needs
- Monitoring, Measurement and Metrics: Knowledge of key business drivers or measures used to gauge the effectiveness and performance of an internal group or a supplier; Ability to determine appropriate measures or metrics; Ability to measure against those standards; Ability to communicate performance standards and metrics
- Record Retention: Knowledge of the policies and procedures for storing and retaining financial, non-financial and company documents
- Requirements Planning: Knowledge of how to plan materials and service requirements in order to support ongoing business
- Software Applications: Knowledge and use of technical software applications appropriate to the specific work activities (e.g., basic Company applications, SAP, DBS, MRP, OPS, JDEdwards, Service Source, MRP II,)
- Strong computer skills, including knowledge of SAP systems; Excellent Excel skills, strong skills in Powerpoint, Word, and Access.
- Familiarity with optimization tools (and preferably linear programming), SQL and other querying tools.
RELATED EXPERIENCE REQUIREMENTS/ QUALIFICATIONS:
- 3+ years of data and financial analysis experience
- 3+ years of Procurement, Supply Chain or Operations
CORE COMPETENCIES:
- Drives Innovative Business Improvements: sets an environment of continuous improvement to ensure maximum results.
- Balances immediate and long-term priorities: ensure that the team achieves an appropriate balance between short-term demands and long-term value.
- Delivers results: holds self and others accountable for setting goals and striving for excellence.
- Imports and exports good ideas: builds relationships (internal and external) that result in plans/solutions for the business.
- Develops and inspires others: adjusts personal style to the situation to ensure appropriate impact upon others.
- Sets a winning example: encourages open, trusting and candid relationships with others.
EDUCATIONAL REQUIREMENTS:
Bachelor’s Degree or equivalent experience
PREFERRED QUALIFICATIONS:
- Bachelors/Master/s Degree in a quantitative or engineering discipline such as Operations Research, Decision Sciences, Industrial Engineering, Supply Chain, or Logistics.
- Tactical procurement or P2P experience
- SQL experience
