Demand Planning Analyst

Summary

Minor Figures is a plant-based beverage company creating innovative products for coffee shops and retailers worldwide. The Demand Planning Analyst supports North American sales, finance, and operations teams by managing demand, sales, trade, and revenue forecasting, maintaining reporting systems, and improving forecast accuracy and order fulfillment.

Responsibilities

• Become the internal expert on our demand and trade forecasting tool, Modus, including maintaining and inputting all sales & trade forecasting data, while owning all system updates and outputs to create monthly, quarterly and annual forecasts
• Participate in weekly sales updates to identify revenue gaps and opportunities that need to be reflected in forecasts and addressed by sales teams
• Lead monthly forecast review meetings with each sales lead to amend customer forecasts and identify sales gaps; keeping teams on track and accountable to meeting agendas
• Own the monthly Demand Review process, including preparation of reporting tools, facilitation of forecast review meetings, documentation of agreed forecast changes, and publication of the Rolling Latest Estimate (LE)
• Build and distribute Retailer Forecast Performance, Customer DC Forecast Performance, Pipeline Review and Rolling LE reports in support of the monthly S&OP process
• Build and distribute all sales reports, continually seeking system or output improvements that better enable the sales team
• Manage customer and consumption-data portals (ie, SPINS, Nielsen) to update sales reporting files, tools and platforms
• Update pipeline reporting tools via the CRM platform
• Own weekly Modus actuals uploads, invalid connection management, forecast snapshots, and master data monitoring
• Monthly comparisons of On-Premise distributor chargebacks against forecast, making dynamic system updates to improve customer-investment planning accuracy
• Enable the team to better utilize customer-investment budgets by monitoring and tracking distributor spend
• Support PMAT and customer-investment forecasting by ensuring approved investments are accurately reflected within Modus and the demand plan
• Maintain promotion, trade-spend, and customer-investment forecasting inputs within Modus
• Support revenue planning and trade promotion planning by incorporating promotional activity, trade spend and customer investment assumptions into the demand plan
• Participate in regular meetings with our external trade management partner to identify gaps and optimization opportunities within the trade forecast
• Support Sales, Operations and Finance teams through the monthly S&OP process by ensuring forecasts, pipeline reporting, promotional plans and demand assumptions are accurately maintained and communicated
• Serve as the primary administrator for forecasting workflows, reporting files, and forecast governance processes

Skills

• This role demands incredible attention to detail, an obsession with numbers, the ability to work as part of multiple teams and on one's own, a desire and ability to learn systems and processes very quickly, initiative to proactively improve systems, strong problem solving skills, a commitment to keep work moving against key deadlines, and the skills to adapt to ever-changing business requirements
• This role requires residence in states located in Mountain Standard Time (CST) or Central Standard Time (CST)
• Deep knowledge of Google Sheets: pivot tables and VLOOKUPS are your baseline
• Self-motivation to complete required work autonomously while proactively optimizing systems and processes
• Strong attention to detail and ability to manage multiple deadlines and deliverables
• Strong problem-solving skills and ability to identify issues, determine root cause, and drive solutions
• Ability to collaborate cross-functionally and engage the right stakeholders to keep work moving
• Ability to create ad hoc reporting and demand-planning models
• Demonstrated ability to manage a recurring planning calendar, meet deadlines consistently, and proactively follow up to keep deliverables moving
• This role requires residence in states located in Mountain Standard Time (CST) or Central Standard Time (CST)
• Work schedules are flexible, but in general hours of work will be 9:00am – 5:00pm. This position may need to be available for extended hours at the end of each month and the fiscal quarter. This role may also need to be flexible to accommodate calls across the US in different time zones, and on occasion be free for calls with our UK-based team
• Experience building bottoms-up forecasts (strongly preferred)
• Experience with Modus, SAP IBP, Logility, o9, Blue Yonder, or other demand planning software (strongly preferred)
• Strong commercial acumen, preferably in CPG, grocery, or coffee (strongly preferred)
• Experience with grocery forecasting and/or trade spend (strongly preferred)
• Experience with UNFI and KeHE (preferred)
• Experience working with a trade promotion management or trade spend management tool (preferred)
• Experience navigating and building reports via SPINS and Nielsen (preferred)

Qualifications

Must Haves

• This role demands incredible attention to detail, an obsession with numbers, the ability to work as part of multiple teams and on one's own, a desire and ability to learn systems and processes very quickly, initiative to proactively improve systems, strong problem solving skills, a commitment to keep work moving against key deadlines, and the skills to adapt to ever-changing business requirements
• This role requires residence in states located in Mountain Standard Time (CST) or Central Standard Time (CST)
• Deep knowledge of Google Sheets: pivot tables and VLOOKUPS are your baseline
• Self-motivation to complete required work autonomously while proactively optimizing systems and processes
• Strong attention to detail and ability to manage multiple deadlines and deliverables
• Strong problem-solving skills and ability to identify issues, determine root cause, and drive solutions
• Ability to collaborate cross-functionally and engage the right stakeholders to keep work moving
• Ability to create ad hoc reporting and demand-planning models
• Demonstrated ability to manage a recurring planning calendar, meet deadlines consistently, and proactively follow up to keep deliverables moving
• This role requires residence in states located in Mountain Standard Time (CST) or Central Standard Time (CST)
• Work schedules are flexible, but in general hours of work will be 9:00am – 5:00pm. This position may need to be available for extended hours at the end of each month and the fiscal quarter. This role may also need to be flexible to accommodate calls across the US in different time zones, and on occasion be free for calls with our UK-based team

Nice to Haves

• Experience building bottoms-up forecasts (strongly preferred)
• Experience with Modus, SAP IBP, Logility, o9, Blue Yonder, or other demand planning software (strongly preferred)
• Strong commercial acumen, preferably in CPG, grocery, or coffee (strongly preferred)
• Experience with grocery forecasting and/or trade spend (strongly preferred)
• Experience with UNFI and KeHE (preferred)
• Experience working with a trade promotion management or trade spend management tool (preferred)
• Experience navigating and building reports via SPINS and Nielsen (preferred)

Benefits

• Opportunity to invest in the business, with the option to buy shares in the company at an agreed price
• Health, Dental, Vision and Life Insurance plans
• 15 days vacation, 14 days paid holiday
• Employee share options scheme, available to all full time employees
• 1 day paid leave to support a cause of your choice through volunteering or activism
• 401(k) retirement plan with company match
• Paid Parental leave policy
• Flexible working to meet the needs of the role
• Access to the Calm app
• Flexible CoWorking Spaces across the US