Overview We Are PepsiCo Join PepsiCo and Dare for Better! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place. Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries. Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years. A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world. Know more: PepsiCoJobs Join PepsiCo, dare for better. Responsibilities The Opportunity GCC LAB FP&A Analyst will play a key role in the LATAM’s Beverage business. This role is responsible for supporting in report generation and consolidation of a world class GCC for LAB Mexico. Supporting digital transformation agenda, financial planning process, innovation agenda from the financial standpoint and financial and volume information, deliver accurate information to lead decision making process. Additionally, it´s expected to become a business partner for CU providing financial insights for decision making and process improvement. Your Impact As Finance Analyst your responsibilities would consist of: Monthly Closing 1. Sell In Coordinate the concentrate units closing information with teams like Operations and Franchise, consolidate in the closing templates and analyze the variations versus forecast. Align with the Operations team any significant variation (phasing, incremental POs, air freights and others). Prepare the Finished Goods and OTS closing (Month and YTD) reports and analyze the variations versus forecast. 2. P&L Latest Estimate (LE) Manage information in LAB’s MS Teams file the P&L information and comments previously aligned with the CU FP&A team. 3. Mosaic Take responsibility for uploading monthly closings into the TM1 (Mosaic) system for the assigned CU. Ensure end-to-end management of all related inputs and processes that may affect the accuracy and timeliness of these uploads. Ensure that all information matches between all systems related: HFM-TM1-Cockpit Monthly Forecast 1. Sell Out Prepare the sell out volume templates, request the information and consolidate the reports of the monthly volume forecast. Analyze volume trends by market and category/brand and running rates and align the rationale with the Franchise teams. Lead the volume review and approval meeting. Update any changes in the volume after monthly closing and prior to the forecast reporting. 2. Sell In Request the concentrate units BOY forecast to the Operations team, consolidate in the forecast template. Update the monthly splits for imports, exports, and reclassification between CBC plants, according to historical rates or bottler’s information. Align with the Operation team the rationale of the BOY forecast (bottlers, finance or Operations team recommendations, DIIs, Build and Draw). Update any changes in concentrate units after preliminary P&Ls review and prior to the forecast reporting to LAB. 3. Mosaic Take responsibility for uploading monthly forecast information into the TM1 (Mosaic) system for the assigned CU. Ensure end-to-end management of all related inputs and processes that may affect the accuracy and timeliness of these uploads. HFM Run the overall P&Ls check to ensure the correct information upload and confirm to the LAB Finance team the reporting process closure. Ensure that ODPL´s are correctly allocated across expenses lines. Qualifications Who Are We Looking For? Education • Education: Finance, Accounting, Industrial Engineering, Computer Engineering Experience • Proficient in English (C1-C2) • Minimum 2 years of proven experience in financial planning and modelling • Deep understanding of a P&L and interrelation • Expertise in financial analysis, work with massive data and maintaining data integrity. • Computer literate – Advanced Excel, Power Point, SharePoint, Teams, Power BI and Tableau. If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements. What can you expect from us:   • Opportunities to learn and develop every day through a wide range of programs. • Internal digital platforms that promote self-learning. • Development programs according to Leadership skills. • Specialized training according to the role. • Learning experiences with internal and external providers. • We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others. • Financial wellness programs that will help you reach your goals in all stages of life. • A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle. • And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.   We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.