Senior Data Analyst - Procurement Analytics - Post Holdings Inc.
Saint Louis, MO
About the Job
Brand: Post Holdings Inc.
Categories: Procurement
Locations: Saint Louis, Missouri
Position Type: Regular Full-Time
Remote Eligible: No
Req ID: 24458
Job Description
Business Unit Overview
Feeding the world is what we do – how we do it is unique. We are not your textbook consumer packaged goods company. While others may be slow to make change happen, Post continuously drives both inorganic and organic growth. Our history is evidence of that fact with over 100 years of heritage and growth from brands that transcend generations like Honey Bunches of Oats, Fruity Pebbles, Malt-O-Meal, Bob Evans Farms, Kibbles 'n Bits, Egg Beaters, Peter Pan Peanut Butter, Ronzoni Pasta and more. Our foodservice and ingredient businesses supply other products you love for brands, restaurants and stores. Our offices and manufacturing sites are in 62 locations in five countries, and we have 11,500+ employees. Over the past 10 years, Post has made 22+ acquisitions and reached $7 billion in net sales in fiscal 2023. During turbulent times of market uncertainty, the food industry has provided a level of stability unlike other industries. Post Holdings, Inc. is headquartered in Brentwood, a suburb of St. Louis, Missouri. Our casual professional atmosphere encourages team members to collaborate, innovate and support our operating companies. Our passion and drive advance the reputation of our operating companies and brands—together, we make a difference. 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.
Post Holdings provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, status as a covered veteran and any other category protected under applicable federal, state, provincial and local laws.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
Categories: Procurement
Locations: Saint Louis, Missouri
Position Type: Regular Full-Time
Remote Eligible: No
Req ID: 24458
Job Description
Business Unit Overview
Feeding the world is what we do – how we do it is unique. We are not your textbook consumer packaged goods company. While others may be slow to make change happen, Post continuously drives both inorganic and organic growth. Our history is evidence of that fact with over 100 years of heritage and growth from brands that transcend generations like Honey Bunches of Oats, Fruity Pebbles, Malt-O-Meal, Bob Evans Farms, Kibbles 'n Bits, Egg Beaters, Peter Pan Peanut Butter, Ronzoni Pasta and more. Our foodservice and ingredient businesses supply other products you love for brands, restaurants and stores. Our offices and manufacturing sites are in 62 locations in five countries, and we have 11,500+ employees. Over the past 10 years, Post has made 22+ acquisitions and reached $7 billion in net sales in fiscal 2023. During turbulent times of market uncertainty, the food industry has provided a level of stability unlike other industries. Post Holdings, Inc. is headquartered in Brentwood, a suburb of St. Louis, Missouri. Our casual professional atmosphere encourages team members to collaborate, innovate and support our operating companies. Our passion and drive advance the reputation of our operating companies and brands—together, we make a difference. 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.
Post Holdings provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, status as a covered veteran and any other category protected under applicable federal, state, provincial and local laws.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
Source : Post Holdings Inc.