Forecasting Coordination

Description

Job Summary: Responsible for consolidating, analyzing, and enhancing short- and long-term financial forecasts by leveraging advanced tools and cross-functional collaboration. Key Highlights: 1. Experience in financial planning, results or scenario analysis 2. Use of advanced analytical tools (Power BI, Excel, Power Query) 3. Collaboration with key business areas and leadership in finance **Location:** OC \- CDMX **Objective:** Responsible for consolidating, analyzing, and improving short- and long-term financial forecasts by integrating data from multiple internal and external sources. This is achieved through the use of advanced analytical tools, cross-functional collaboration with business areas, and a focus on digital efficiency. The purpose is to ensure that forecasts are accurate, relevant, and actionable to support strategic decisions driving profitable growth for Nestlé Mexico. **What Will Make You Successful:** * Graduates in Business Administration, Finance, Industrial Engineering, or related fields. * Experience in financial planning, results analysis, or scenario development. * Intermediate to Advanced English **Key Responsibilities:** 1\.\- Consolidate and update the business-level financial forecast within the NIM scope. Integrate information related to category P\&L from various functions and external sources. Generate an integrated view of revenues, costs, and margins across different time horizons and scenarios. Understand and apply cost allocation models to effectively manage P\&L. Support scenario simulations and/or new business models aimed at achieving sustainable business growth. 2\.\- Conduct variance analysis among forecast, plan, and actual results, comparing key assumptions, identifying significant deviations, and documenting their root causes. Develop proposals to mitigate future variances. 3\.\- Develop and maintain automated forecasting models using tools and dashboards such as Power BI, Excel, Power Query, and macros to improve forecast process efficiency, traceability, and accuracy. Provide inputs for the design and harmonization of digital tools. Integrate new tools supporting digitalization and process simplification (e.g., Python, AI, APIs). 4\.\- Collaborate with commercial areas, supply chain, financial control, and categories. Participate in the monthly planning cycle to validate consistency, understand variances, and provide inputs. Ensure the quality of information generated throughout the planning cycle. 5\.\- Produce executive reports and ad hoc analyses for Finance and Business Leadership. Deliver them in automated, visual, and interactive formats to facilitate agile, scenario-based, and reliable decision-making. 6\.\- Support the generation of business insights in critical decision-making forums such as Business Reviews (local and with the Zone) and Key Material Committees (e.g., Dairy, Coffee, Cocoa)