Senior Analytics Analyst - Procurement

Responsibilities

Deliver analysis, reporting, and knowledge of relevant business processes and data as a Procurement subject matter expert serving the centralized Procurement department managing $3+ billion in annual spend.

• Demonstrate accumulated Post-specific knowledge regarding business processes affecting master data, analytics and business metrics, data sources & the meaning of each data component across the various divisional ERP systems.
• Conduct ad-hoc research and analysis and provide expertise to enable Procurement to make data-driven decisions, while ensuring that conclusions reflect relevant complex business processes.
• Support category manager strategic sourcing efforts with discovery of relevant spend and incumbent suppliers.
• Complete supply chain analysis relating to contemporary challenges of the business with timely, accurate and creative output.
• Leverage trusted data sources to discover and communicate Supply Chain Risks.

Provide thought leadership for new data development efforts, primarily to articulate and ensure the needs of the end users are met.

• Collaborate with team members to define the vision and desired outcome for new projects and efforts.
• Participate in data validation of department projects, to ensure alignment to existing trusted data sources, and to stress-test the usability of the deliverable.
• Develop daily / weekly hedge position reporting for all counterparty trades tied to board positions leveraging intelligent designs.
• Proactively identify opportunities for automation, consolidation, standardization, and improvement.
• Support special efforts or proof-of-concept exercises, such as crop analysis and predictions.
• Socialize new deliverables with key Procurement Team members for User Acceptance Testing.

Enrich the Procurement team’s communication of monthly category and market movements through variance analysis, report development or enhancements, verification with category managers, and by providing commentary for presentation to business unit leadership teams.

• Generate monthly reporting suite for our centralized Procurement department, to support effective messaging of category risks and opportunities, coverage levels, and market fluctuations.
• Coordinate the monthly harvest of new intelligence from category managers, through Excel, Access, Smartsheet, and other tools.
• Discover drivers of variance changes between reporting cycles and craft explanatory commentary for material shifts.
• Analyze reasonableness of actual and projected costs for quality issues to ensure accurate reporting.
• Perform reconciliations as needed to explain differences between Procurement reporting results compared to custom PPV definitions used by business unit financial contacts and related reporting systems.
• Analyze Cost Out project pipeline and communicate savings results and changes from prior cycle.
• Collect and store market price history for categories of interest, using an automated tool and / or Procurement Team contacts.
• Drive automation for recurring reporting to reduce manual tasks and create repeatable processes.

Manage existing, or implement new, component price models for relevant categories, currently in Excel.

• Manage and maintain the structure of existing component price tools to ensure functionality drivers accurate pricing outcomes, including troubleshooting and research when harvested pricing contradicts expectations.
• Work with category buyers to gather conceptual relationships for relevant components for new-to-PHI categories.
• Facilitate budgets for raw materials, packaging, and energy, including changing item mix from year to year as reflected in purchasing budgets received from operating companies, and work with category managers to update component structure as needed.
• Provide support for the monthly / quarterly / annual forecasting process at the component price level.

Manage and champion the Procurement Team’s reporting portfolio for the entire purchase to pay life cycle.

• Become a super user of Procurement’s trusted datasets and existing report.
• Lead periodic training sessions to equip existing and new team members to fully leverage available assets and socialize new deliverables within the Procurement department.
• Leverage trusted data sources to expand visibility to our various purchasing areas, including direct materials, indirect spend, and co-manufacturing of finished goods.
• Manage supply base data cleansing with Dun and Bradstreet for quarterly and annual diversity spend reporting.
• Responsible for USDA, MWBE, and SEC reporting for Procurement
• Curate Supplier and Item categorization which allows aggregation of data regardless of ERP system origin.
• Receive issues / questions from report users that suggest data issues. Research issues to identify probable root cause.

Prioritize issues by impact.

Support the integration of new company acquisitions.

• Aid in integration of new acquisitions into Post’s infrastructure to support centralized Procurement across divisions.
• Onboard new acquisitions in collaboration with the Procurement Analytics team and Decision Science team; formulate and execute plans for immediate data visibility and master data integration & classification as a stop-gap during the ERP implementation phase.

This is a hybrid role. In the office Tuesdays, Wednesdays, Thursdays, and work from home Mondays and Fridays

Qualifications

The successful candidate will have the following knowledge, skills, and abilities :

• Degree required (Finance, Business, Economics, Management Information Systems, or other quantitative discipline a plus)
• 7-10 years related experience (Finance, Procurement, Supply Chains)
• Advanced experience in Tableau Desktop or another data visualization tool required. Advanced authorship skill level in Tableau Desktop preferred, with ability to understand and modify existing complex visualizations, and proven ability to transform data into a compelling story / message.
• Experience required in reporting or data analytics to discover / communicate key drivers when there are multiple moving elements.
• Excellent written and verbal communication skills required.
• Creative / innovative / strategic problem-solving skills and strong business acumen required.
• Advanced experience with Excel, Access and Power Point preferred.
• Experience with Smartsheet or other online spreadsheet tools preferred.
• Data warehousing, data modeling of CPG data, or experience with relational data platforms a plus (Snowflake, MS Access, Data Warehouse, Oracle, or other).
• Ability to manage multiple projects, competing priorities, and ensure follow-through on committed deliverables.
• Strong initiative, detail-oriented, proactive, and thrives in a fast-paced environment.
• Candidate will demonstrate a wide degree of creativity, initiative, and logical thinking in problem solving, as well as a drive to streamline / automate / improve and innovate.
• Excellent written and verbal communication skills, including the ability to concisely convey analytical interpretation and / or data issues to affected members of departments.
• Demonstrate high personal standards of behavior in a professional environment. Demonstrate credibility, competence, and the ability to manage through influence.
• Self-motivated and curious; willingness & strong desire to learn.
• Demonstrate credibility, competence, and the ability to manage through influence.
• Demonstrate awareness of the confidentiality of data and its distribution.
• Candidate will initiate periodic review of work progress, action plans, and deliverables with manager.
30+ days ago