Demand Planner

Job Title: Demand Planner

Location: Bogotá, Colombia

About us:

With over 200 brands sold in nearly 180 countries, we’re the world’s leading premium drinks company. Bring your passion and use your curiosity as you explore, collaborate, and innovate to build brands consumers love. Together with passionate people from all over the world, you’ll test new insights, learn and grow, and unlock a brighter, more exciting future.

Join us to create a career worth celebrating.

About the Role:

The Demand Planner Role is a key role within the IBP structure responsible for the utilization of next generation demand planning tools to generate a multivariate statistical forecast considering variables such as category growth, market share, pricing, promotions, sell out, stock in trade and economic factors influencing demand. The planner will create statistical forecast models to support the monthly IBP process including using mathematical and statistical trends to find opportunities and risk.  The demand planner will own and drive statistical forecast accuracy performance to achieve targets.  They will collaborate with the IBP Lead and Baseline Planners (where applicable) on history adjustments to drive robust statistical forecasts.  The demand planner is responsible for data integrity, ensuring that the systems are maintained and updated with the correct history to deliver the most accurate forecast for the business.

The demand planner will be expected to display the flowing amongst other skills to be successful:

-          the ability to translate AI and Machine learning into business language.

-          resolve problem statements to solve.

-          Model algorithms using the latest data and technology.

-          Display critical thinking and digital dexterity by using data to tell a story based on fact and trends.

-          Understands the principles that underpin demand planning, including formal education in demand planning and execution to complete work.

-          Understand the principles that underpin statistical forecasting.

-          Has experience in demand planning in a similar environment using statistical tools, building block assumptions, opportunities and risks, and S&OP/IBP to agree plans.

-          Can maintain a statistical dataset, including data cleansing, item relationships and product families to facilitate the delivery of a statistical forecast with minimal rework. Can do this in the appropriate Diageo tool as selected.

-          Understand the principles and practices that support Advanced Statistical Forecasting, including Artificial Intelligence and Machine Learning, in a way that this knowledge can be used to support existing and future statistical modelling and improvement within Diageo.  

-          Can handle a sophisticated building block management process, which is digitally driven, updated using demand sensing and insight, and fully integrated with forecast and O&R to deliver a seamless integration with other business plans.

-          Can create and maintain appropriate commercial scenarios as required. This includes articulation of key building blocks and assumptions, the impact of volume, price, promotion, inventory and other related drivers, and the link between decision options and relate outcomes.

Top Accountabilities:

-          Pro-actively works with the IBP Lead and baseline planners, owning the statistical forecast and highlighting deviations to the shipment and/or depletion trends.

-          Use and maintain the planning software as the primary forecasting system tool.

o    Collaborate with IBP Leads and other departments on all forecast history cleaning activities including documenting adjustments and assumptions (market trends, seasonality, promotions).

o    Maintain statistical parameters for “best fit” model & generate a baseline at least 18 months rolling.

-          Maintain system master data including CVC creation, disaggregation factors and attributes.

-          Analyze outliers through appropriate reports and make corrections.

-          Support scenario planning for promotions, innovation, and major events (duty, economics change, etc.) through stat analysis.

-          Provide reports and insights to collaborators to improve the use of statistical forecasting forecast.

-          facilitate a monthly Demand Planning cycle, including the collection of information from relevant business collaborators, the alignment of key changes, and the delivery of a consensus on inputs and impact from commercial and other businesscollaboratorss.

-          create and maintain an integrated demand plan, which shows a realistic bottom-up view of expected demand using a combination of statistical forecasting, performance insight, building blocks and assumptions, and demand planning competence and knowledge.

-            Generate multivariate sophisticated Statistical Forecasting, including Artificial Intelligence and Machine Learning

-          Create and maintain the statistical forecast for the market monthly This includes data management, solution management and technology use and integration.

-          Create and maintain the demand plan for the market monthly, by combining the statistical baseline, building blocks and assumptions and other plans and data to create a single demand plan.

-          Understand the detail underpinning demand plans and changes and maintains appropriate information to support information requests.

-          Support the management of Opportunities and Risks in the Demand Plan

-          Support the analysis of Demand Plan performance (accuracy and bias)

-          Works to maintain an efficient integrated digital process to deliver the monthly demand plan. This includes management of appropriate master data and system change requests.

-          Supports the development of market scenarios and plans as required.

-          Develops a key understanding of dynamic market drivers and how they impact overall demand and uses this information to validate or challenge market demand assumptions.

-          Supports the Pre-Demand Review as required.

-          Supports the S&OE process as required.

-          Develops focused and enhanced capabilities to leverage the demand planning process for value including the use of analytics, data modelling, demand sensing and artificial intelligence.

-          Supports the digitisation of planning processes through the elimination of manual processes and information.

-          Supports the continuous improvement of business processes in their area of work.

Experience required/Skills/Capabilities

-          Baseline understanding of the end-to-end Supply Chain Planning processes; Supply Planning, Distribution Requirements Planning, Inventory Planning, Conversion, Logistics, Procurement and Customer Service

-          Demonstrated proficiency in statistics and/or forecasting methodologies with an understanding of their financial and operational impacts

-          Strong analytical, organizational and decision making skills.

-          Good communication skills – verbal, written and presentation.  

-          Proficient in MS applications e.g. Excel, Word, PowerPoint, Access, Outlook

Previous Successful Experience:  

-           Experience with sophisticated planning software with Supply Planning (SAP APO system and Business Intelligence/BW )

-          Has practical experience of Demand Analytics, to analyse demand performance and trends, marketing, and sales activity impact (including pricing), and reach conclusions on what that might meant about current and future demand plans.

-          Has practical experience of IBP in a similar role and / or business, which can be used to support the current role and challenge?

-          Can handle an appropriate change management process to ensure market adoption of IBP, using Diageo principles, processes, and resources, as well as their own skills, capabilities, and position.

-          Demonstrated ability working in IBP/S&OP

-           First-hand planning experience in IBP, S&OP, S&OE, Demand Planning.

Skills/Capabilities:

-          Growth Mindset  

-          Passion for data and a performance culture.  

-          Very strong analytical skills.  

-          Collaboration:  Demonstrated ability to develop and maintain strong working relationships and influence at all levels of the organisation. At ease working effectively with a diverse group of collaborators and business cultures.

-          Excellent communication skills, both verbal and written combined with the ability to engage effectively at all levels in the organisation.

-          Digital dexterity. Previous experience (and hunger to learn) on sophisticated planning tools, digital control towers, BI, etc.  

-          Critical Thinking and robust problem-solving ability.

-          The most vocal voice of truth.

-          Collaborate efficiently.

-          Stands for digitization and does not tolerate drift. 

-          Robust discernment.

-          Evidence of strong bias performance. 

-          Evidence of reconciliation. 

-          Superbly understand the Rout to Market and consumer insights of the market they will operate in. 

Desirable:

-          Experience in S&OP/ Demand Planning working in a multinational CPG / FMCG

-          BSc or equivalent experience in engineering, supply chain, data science/statistics/applied mathematics, economics.

Flexible Working Statement:

Flexibility is key to our success. Talk to us about what flexibility means to you so that you’re

supported to handle your wellbeing and balance your priorities from day one.

Diversity statement:

Our purpose is to celebrate life, every day, everywhere. And creating an inclusive culture, where everyone feels valued and that they can belong, is a crucial part of this.

We embrace diversity in the broadest possible sense. This means that you’ll be welcomed and celebrated for who you are just by being you. You’ll be part of and help build and champion an inclusive culture that celebrates people of different gender, ethnicity, ability, age, sexual orientation, social class, educational backgrounds, experiences, approaches, and more.

Our ambition is to create the best performing, most trusted and respected consumer products companies in the world. Join us and help transform our business as we take our brands to new heights and build new ones as part of shaping the next generation of celebrations for consumers around the world.

Feel inspired? Then this may be the opportunity for you.