Model Analysis Planner

Description

Job Summary: Coca-Cola FEMSA is seeking a Model Analysis Planner to analyze and monitor financial models, ensuring business sustainability and goal achievement. Key Highlights: 1. Analyze and monitor financial models using Monster and KO. 2. Generate financial insights to support strategic decision-making. 3. Support financial planning and forecasting processes. We know our Talent is the key to success. That’s why we invite you to **unlock your potential** with this new career opportunity: At Coca\-Cola FEMSA, we are seeking a **MODEL ANALYSIS PLANNER**, responsible for analyzing and monitoring financial models using Monster and KO, tracking portfolio profitability, and supporting the company’s strategic decision-making. **Position Objective:** Analyze and monitor financial models using Monster and KO, track portfolio profitability, and generate financial insights that support the company’s strategic decision-making, ensuring financial sustainability and achievement of business objectives. **Key Responsibilities:** Develop and maintain financial models to evaluate profitability, operational efficiency, and strategic initiatives. * Monitor and analyze P\&L performance, identifying risks, opportunities, and key business drivers. * Conduct sensitivity analyses and scenario simulations to support decision-making. * Generate financial insights and recommendations for commercial, supply chain, and leadership teams. * Compare actual results against budget, forecast, and prior-year performance. * Track and update the local production model in Monster. * Lead financial analyses of exports, evaluating impacts on profitability, logistics costs, supply chain, and operating margins. * Support financial planning, forecasting, and long-term planning exercises. * Consolidate and summarize large volumes of financial data into executive-level, actionable presentations for stakeholders. * Prepare and present financial analyses and strategic recommendations to executive teams and C\-Level audiences, both locally and across LATAM. * Collaborate cross-functionally with commercial, operations, supply chain, and finance teams to align business strategies with financial objectives. * Identify opportunities to improve and automate analytical and financial processes. * **Requirements:** Bachelor’s degree in Finance, Economics, Business Administration, Industrial Engineering, or related fields. **Mandatory Requirement:** Experience in financial planning, profitability analysis, and financial modeling, with advanced Excel proficiency. **Desirable (non-exclusive):** Experience with Power BI, SAP, or financial planning tools. **Experience:** 2–4 years of experience in financial planning, financial analysis, profitability, business intelligence, or financial modeling, with advanced Excel skills and financial modeling expertise. If this profile matches yours, we invite you to apply for this opportunity! At Coca\-Cola FEMSA, diversity, equity, and inclusion are the foundation of innovation, business integration, and sustainable growth. We strive to reflect and respect the richness of identities, perspectives, and talents present in the communities where we operate. We offer equal opportunities and career development without discrimination based on age, ethnic or indigenous origin, skin color, nationality, religion or beliefs, social or migratory status (including refugees), disability, marital status, sexual orientation, gender identity or expression (including transgender and non-binary individuals), or any other characteristic protected by applicable law. We promote talent attraction and selection processes grounded in talent, experience, and potential—free from discrimination and bias. If you require reasonable accommodations or accessibility support during the selection process, please notify the Talent Attraction team. We want your experience to be respectful, inclusive, and fair.