Skip to main contentA logo with &quat;the muse&quat; in dark blue text.
Diageo

Advanced Demand Planning Analyst – Mexico

Mexico City, Mexico

Diageo is the world's leading premium drinks company with an outstanding collection of brands, such as Johnnie Walker, Smirnoff, Baileys, Captain Morgan, Tanqueray and Guinness. With over 200 brands in 180 countries and a global network of entrepreneurial individuals, our teams blend a diverse range of experience, knowledge and skills. We connect customers and consumers to our iconic products and create innovative experiences that bring people together to celebrate life.

The OMP advance analyst is a key role within the i-IBP and implementation of Advanced demand planning system OMP. Based on business processes/requirements, the role will be responsible for understanding Multivariate forecasting, building block management and advanced use of demand sensing to assist users within the Market thereby unlocking any obstacles to efficient utilization of the tool. The Analyst will be required to have a robust understanding of the data structure and requirements for integration of the multivariate forecast process not limited to but including, CPG structures, Sales history, SIT, Depletion, Market Share, Category Growth, Price Elasticity History, Historical promotions, OOS. The analyst together with the OMP adoption Manager will ensure adoption of the tool as the single demand planning tool in Diageo and effectively work to eliminate parallel demand planning processes.

Want more jobs like this?

Get Data and Analytics jobs in Mexico City, Mexico delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


In addition, the Analyst is required to understand the report structure within OMP and collectively understand the business reporting requirements to craft and develop standardized reports that will be used to drive an effective IBP cycle in the markets.

The analyst together with the OMP adoption Manager will be also responsible for the readiness of the market. This mean work in APO adoption pre-work and data consolidation & preparation.

Is responsible for acquiring and disseminating system knowledge, thorough understanding of the system through training, by following very closely the modelling work done by the consultant(s) and by testing the system.

This analyst will often train the end users of the system and will often become the first line support person and contact person for help desk of OMP during and after Launch acceptance.

Is responsible for testing and validating the proposed software solutions, thorough knowledge of scope / design both at technical level and functional level along with creating corresponding functional and user documentation.

The OMP Analyst will be expected to display the following skills to be successful:
  • Understands the principles that underpin demand planning processes, including formal education in demand planning and execution to complete work.
  • Understanding of the Business complexity.
  • The ability to translate business requirements into system parameters/rules as well as translate AI and Machine learning outputs into clear business language.
  • The ability to understand statistical forecasting principles and algorithms used in process.
  • Model and test 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.
  • 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 create and maintain scenario planning for Demand and IBP purposes including the understanding of how probabilistic forecasting can be used to resolve most likely scenarios and teach the demand analyst and iBP leads how to effectively use it.


Dimensions:

Market (Mexico, Colombia, Brazil, CCA or SLAC)

Interfaces:

This role operates within a very complex and evolving network with the following dimensions:
  • Multi-functional collaboration with demand planning, data analytics and IBP
  • Global IBP Process Owners
  • Global Demand Planning Process Owner
  • Digital tools such as APO/OMP, Anaplan


Top Accountabilities:
  • Understand the current APO system configuration of CPG, Hierarchies, and sales organization.
  • Identification and follow-through with business teams of sales history corrections to ensure readiness for utilization of sell in history in OMP.
  • Analyze and clean up the master data system with the technical team
  • Alignment / consistency of Hierarchies according to global standards.
  • Work multi-functionally with the OMP Analyst to understand the MI and statistical forecast algorithms.
  • Test and report back on errors and areas for improvement prior to the full-scale implementation of OMP in the market.
  • Assist in the eradication of parallel demand planning processes and stabilization of OMP as the interim forecasting solution.
  • Together the with global demand planning process owner and the Adoption manager develop the requisite system training modules in preparation for launch.
  • Becomes the key contact for technical errors and system issues resolution.
  • Run multiple user test cases as part of the design and user acceptance group.
  • Run Governance for market implementation with multifunctional teams (Finance, marketing, supply, IBP, CMO)
  • Understand the interface with multiple systems within Diageo including an understanding of the stat architecture.
  • Contribute to the development of a Data strategy for the region together with the Global Demand Process Owner.
  • Hands on assistance during the hyper-care period post implementation.
  • Provide continuous support during BAU for the key market.
  • Brainstorm areas of improvement for the implementation in phase two markets within the region.
  • Hands on data preparation for market readiness for Global design (Sell in, Sell out, Stock in trade, promotions, media spend, innovation)
  • Acquiring and disseminating system knowledge, thorough understanding of the system through training, by following very closely the modelling work done by the consultant(s) and by testing the system.
  • Train the end users of the system and will often become the first line support person and contact person for help desk of OMP during and after Launch acceptance.


Provide key input to Demand forecasting process.
  • Participate where relevant in forecasting preparation process to assist in unlocking improvement.
  • Review statistical input to OMP process and challenge projected growth based on historical trends.
  • Collaborate with the Demand Planner, Adoption Manager to implement and sustain the weekly and daily utilization of the demand forecasting tool.


Continuously improve statistical forecasting method:
  • Test and implement new models.
  • Implement standard processes.
  • Support system developments


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
  • Showed strength 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
  • Self confidence
  • Process Orientation
  • Build the future demand tools and processes.
  • Data Analysis and Reporting Skills


Previous Successful Experience:
  • Working within the Demand and/or Supply Chain Planning process; Consumer Packaged Goods Industry preferred
  • Experience with advanced planning software with Supply Planning (SAP APO system and Business Intelligence/BW/Power Bi )
  • 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 assumptions
  • Can handle an appropriate organisational change process to ensure market adoption of IBP, using Diageo principles, processes, and resources, as well as their own skills, capabilities, and position.
  • First-hand planning experience in IBP, S&OP, S&OE, Demand Planning.


Skills/Capabilities:
  • Growth Mindset
  • Passion for data and a performance culture.
  • Comfortable with inspiring change and adoption.
  • Very strong analytical skills and applied statistics knowledge.
  • Collaboration: Demonstrated ability to foster and maintain strong working relationships and influence at all levels of the organisation. At ease working effectively with a diverse group of partners and business cultures.
  • Superb 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 advanced planning tools, digital control towers, BI, etc.
  • Critical Thinking and robust problem-solving ability.
  • Stands for digitization and does not tolerate drift.
  • Robust eye for business.

Desirable:
  • Experience in S&OP/ Demand Planning working in a multinational CPG / FMCG
  • BSc in engineering, supply chain, data science/statistics/applied mathematics, economics. Additional MBA or MSc in Supply Chain Management or similar would be desirable.


Flexibility

This is key to success in our business and many of our staff work flexibly in many different ways. Please talk to us about what flexibility means to you and don't let anything stop you from applying.

Diversity statement

Celebrating our inclusive and diverse culture is core to Diageo's purpose of "celebrating life every day everywhere". This purpose is, in itself, inclusive in nature, as it values everybody irrespective of background, disability, religion, gender identity, sexuality or ethnicity.

We know that for our business to thrive and for Diageo to realize its ambition, we depend on having diverse talent with a range of backgrounds, skills and capabilities in each of the 180 countries in which we operate and to reflect our broad consumer base. We view diversity as one of the key enablers that helps our business to grow and our values, purpose and standards set the conditions for us to respect the unique contribution each person brings.

Client-provided location(s): Mexico City, CDMX, Mexico
Job ID: Diageo-JR1099212
Employment Type: Full Time

Perks and Benefits

  • Health and Wellness

    • Health Insurance
    • Health Reimbursement Account
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Short-Term Disability
    • Long-Term Disability
    • FSA
    • FSA With Employer Contribution
    • HSA
    • HSA With Employer Contribution
    • Fitness Subsidies
    • Pet Insurance
    • Mental Health Benefits
  • Parental Benefits

    • Birth Parent or Maternity Leave
    • Non-Birth Parent or Paternity Leave
    • Fertility Benefits
    • Adoption Assistance Program
    • Family Support Resources
    • Adoption Leave
  • Work Flexibility

    • Hybrid Work Opportunities
  • Office Life and Perks

    • Commuter Benefits Program
    • Casual Dress
    • Happy Hours
    • On-Site Cafeteria
    • Holiday Events
  • Vacation and Time Off

    • Paid Vacation
    • Paid Holidays
    • Personal/Sick Days
    • Leave of Absence
    • Volunteer Time Off
  • Financial and Retirement

    • 401(K)
    • Pension
    • Stock Purchase Program
    • Performance Bonus
    • Relocation Assistance
  • Professional Development

    • Tuition Reimbursement
    • Promote From Within
    • Mentor Program
    • Access to Online Courses
    • Lunch and Learns
    • Internship Program
    • Leadership Training Program
    • Associate or Rotational Training Program
  • Diversity and Inclusion

    • Diversity, Equity, and Inclusion Program
    • Employee Resource Groups (ERG)
    • Woman founded/led

Company Videos

Hear directly from employees about what it is like to work at Diageo.