Advanced Supply Planning Analyst

Job Description

Position Summary

The Advanced Supply Analyst plays a critical role in ensuring accurate and efficient planning system and data governance to support seamless product transitions, inventory management, and an optimized End-to-End (E2E) supply plan for all import beer items. This position leads cross-functional collaboration to maintain data integrity, oversee the item setup process, and track key performance indicators to drive continuous improvement. By leveraging advanced data analytic principles, the Advanced Supply Analyst provides actionable insights to optimize supply plans, enhance inventory strategies, and support key business initiatives. Strong communication and analytical skills are essential to integrate data-driven solutions across multiple teams, including Network Supply, Advanced Planning, Procurement, Operations, and Logistics.

• Lead monthly cross-functional meetings (Brewery, Customer Management, Network Supply, Advanced Planning, S&OE, etc.) to review new product introductions and transitions. Ensure accurate and timely system data setup for successful in-market launches by maintaining an updated transition spreadsheet, tracking open actions, and coordinating follow-ups to prevent delays.
• Maintain and update centralized reference files for existing and new SKUs, ensuring complete and accurate details for Planning Teams (S&OE, Network Supply, Advanced Planning). This includes unit of measure conversations (physical cases vs. case equivalent), Master SKU list, pallet quantity, and other critical attributes.
• Manage item setup in JDA (or future planning/ERP system) to ensure all planning parameters are updated and input into the system so accurate supply plans are generated during weekly, monthly, and adhoc planning cycles
• Oversee sourcing data accuracy in the planning or source system (JDA/09) as a part of the sourcing governance process. Ensure timely and precise updates after cross-functional approvals from T&L, Network Supply, Finance, and Customer Management and communicate system updates to cross-functional teams so they are informed when sourcing changes take effect.
• Support the Advanced Supply Planning team in preparing the monthly DC Capacity report by managing Depletions Sourcing Mapping, aggregating S&OP and 5-year shipment plans, and maintaining up-to-date sourcing tables, as described in the prior bullet.
• Maintain and update Inventory KPI and Historical DOH files monthly to track trends, analyze plans, and ensure an accurate historical data log.

• Provides recommendations to improve the data governance process by introducing enhancements to the tracking & tuning process, such as creating routine exception-based reporting to identify missing or incorrect data.
• Supports the Advanced Supply Planning Manager by providing critical reporting and analysis to help to identify opportunities to improve the efficiency & effectiveness of long-range plans, inventory settings based on historic trends, and other adhoc analysis to support data & planning improvement initiatives.
• Strong skills in data analysis tools like Power BI, Tableau, Excel to interpret large, complex data sets and generate actionable insights.
• Proficiency in advanced Excel functions (pivot tables, vlookups, etc) for efficient data management and analysis.
• Understands the impact of their work on cross functional teams and helps support the Planning teams through change initiatives & digital work.

• Communicate and collaborate effectively with multiple key Advanced Planning critical business partners, such as Network Supply, Advanced Demand, Procurement, Operations, Logistics, and Supply Chain Finance to integrate relevant data and insights to drive supply planning enhancements.

• B.A./B.S. majoring in Supply Chain, Operations, or a business-related field and/or 3-5+ years' experience in Planning, Procurement, Optimization, Supply Chain, Production roles
• Deep understanding of technology enablement and current technology tools (i.e. o9, Blue Yonder, SAP), business intelligence tools & business analytics software
• Must have excellent quantitative and qualitative skills to consolidate and analyze large volumes of data, with the ability to translate information for all areas of the business.
• Advanced experience with ability to translate data thru storytelling into presentation formats such as PowerPoint.
• Expert within conflict management. Understands organizational "hot spots" and focuses diverse groups on common organizational outcomes. Fosters productive dialogue and manages high-tension situations with diplomacy and tact to maintain credibility and influence.

• Strong analytical, critical thinking, & problem-solving skills required.
• Results driven and detail oriented
• Self-motivated - able to set priorities and implement decisions to meet deadlines.
• Strong interpersonal skills and ability to work collaboratively with co-workers, related internal functions, external partners, and on project teams.
• Demonstrated ability to influence others, build business partners, to reduce risk by managing exceptions, accelerating results, and generating value.
• Superior communication skills to foster communication/collaboration amongst department.
• Demonstrated results with process discipline and process adherence, and able to identify and take opportunities to develop, further and strengthen a process.
• Efficiently manages tasks and understands need for priority or escalation.

• Passion to challenge the status quo and find new solutions and drive out of the box ideas - loves and embraces change.
• Believes in a non-hierarchical culture of collaboration, transparency, safety, and trust.
• Not afraid to "roll up the sleeves" and seeks to go outside comfort zone to learn.
• Comfortable and experience bringing structure to ambiguity.
• Possesses a spirit of intellectual curiosity, creativity, and innovation.
• Takes responsibility for actions and tasks.
• Maintains integrity and honesty as part of value system.

• Must be able to sit and/or stand for long periods of time and work on a computer for extended periods. Lifting may be required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.