Forecasting Insights Executive

BAT is evolving at pace - truly like no other organization.

To achieve the ambition, we have set for ourselves, we are looking for colleagues who are ready to live our ethos every day. Come be a part of this journey!

SENIORITY LEVEL: Junior Manager

FUNCTION: Digital Business Solutions – SP&I

LOCATION: Monterrey, Mexico

ROLE POSITIONING AND OBJECTIVES

We are searching for a Forecasting Insights Executive who will bring innovation, creativity, energy, and a positive attitude to our team. This position is an integral role within the Forecasting & Planning team and is responsible for the end-to-end forecasting process at an area level leveraging on the Polaris CoE. An ideal candidate will have an enthusiasm for learning, experience organizing and analysing data, strong excel capability, and high attention to detail.

Reports to: GBS Sr. Manager SOP Support - Polaris
Reporting Level: DBS Mexico
Geographic Scope: US - RAI

WHAT YOU WILL BE ACCOUNTABLE FOR

• Polaris: Multi-category Machine Learning Forecasting Model / Tool:
  • Support the system input management ensuring accurate and timely inputs.
  • Ownership of assigned sales area forecast and associated drivers end to end through top line engagement with forecast and planning team to bottom line engagement with sales managers.
  • Full feedback loop with trade to understand market dynamics and competitive activity to explain forecast variances.
  • Develop, execute & maintain KPI dashboards for State Level performance vs forecast with in sales area.
  • Analyse variances between the forecast inputs and assumptions vs actuals
  • Provide insights into the gaps in performance and tie those back to input variances when appropriate.
  • Stay abreast of pricing and marketing initiatives in their assigned geographies.
  • Support the Performance Team in creating communications to socialize findings.
  • Extract relevant information from systems such as MicroStrategy and Gateway 360
  • Perform ad-hoc queries related to any performance gaps or analysis required by the business.
• Sales & Operations Planning:
  • Support meeting material development & standardisation for the Sales & Operations Planning cycle.
  • Ensure accuracy in reporting and material development through cross-referencing multiple sources and engaging with Forecasting, Performance, and other teams.
  • Develop advanced understanding of company data and data environments, focusing primarily on key commercial metrics (sales volumes and market share) found in MicroStrategy.
  • Generate data cubes in MicroStrategy to support the SOP cycle analysis.
  • Generate business intelligence tools to improve the ongoing material and analysis generated during the cycle.
  • Perform ad hoc analysis to support forecasting team during Sales & Operations Planning cycle.
  • Ensure a cohesive story between different data bases and data sources across areas (MSTR, BPC, Kinaxis)

CAN THIS BE YOUR FUTURE ROLE?

• Have you worked in a detail-oriented role that provides essential information for leadership decision-making?
• Have you worked with large amounts of data and applied a business intelligence tool (front or back end)?
• Have you worked in a role that involves holding team members or cross-functional partners accountable for action points?

ESSENTIAL EXPERIENCE, SKILLS, AND KNOWLEDGE

• 2-4 years of work experience in domain, senior stakeholder management and project management in a large-scale organisation.

• Bachelor's Degree required, Business Engineering, Industrial Engineering, Finance, Business Administration, Data Science, or related area.
• Use of Data Visualization Tools (Power BI)
• Experience with Data Analysis tools like MicroStrategy, RedShift, SQL, Python, R or others.
• Strong skills in MS Excel
• Hands-on experience in finance models and reporting tools.
• Good commercial awareness and strong understanding of domain along with BAT strategy and business model.
• Appreciation of the value of detail and accuracy.
• High sense of urgency, work ethic, and flexibility.
• Ability to navigate through ambiguity and work under minimal supervision; must be a self-starter.
• Capacity for innovation, strong problem-solving skills, unafraid to challenge the status quo as necessary.
• Strong interpersonal skills with the ability to communicate with senior and other levels of staff in all departments and companies both within the Group and externally.
• Writing, communication, organizational, and decision-making skills to a high standard and in fluent English (the working language).
• Highly numerate with the ability to make decisions and judgements, the ability to work in a changing environment generating innovative ideas and creative solutions.

BENEFICIAL

• Programming skills Python, SQL, R or Stata for extracting, validating, and reviewing performance data.
• Dataiku / Alteryx knowledge is considered a plus.
• FMCGs or retailer background.
• Expertise in Forecasting and Analysis.
• Knowledge of Tobacco Industry.

WE ARE BAT

At BAT we are committed to our Purpose of creating A Better Tomorrow. This is what drives our people and our passion for innovation. See what is possible for you at BAT.

• Global Top Employer with 53,000 BAT people across more than 180 markets
• Brands sold in over 200 markets, made in 44 factories in 42 countries
• Newly established Tech Hubs building world-class capabilities for innovation in 4 strategic locations
• Diversity leader in the Financial Times and International Women’s Day Best Practice winner
• Seal Award winner – one of 50 most sustainable companies

BELONGING, ACHIEVING, TOGETHER

Collaboration, diversity and teamwork underpin everything we do here at BAT. We know that collaborating with colleagues from different backgrounds is what makes us stronger and best prepared to meet our business goals. Come bring your difference!