Last Mile Analyst

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. Responsibilities The Opportunity in Mexico City The Last Mile Closed Loop Routing Support Analyst will provide operational support to Sales and Go To Market teams across LATAM, ensuring real-time route and customer management, as well as the proper execution of commercial operational processes. This role operates cross-functionally and cross-country, ensuring compliance with defined OLAs and SLAs while driving the centralization, standardization, and optimization of customer and route information throughout the region. What You’ll Do Act as an expert user of Omnitracs, managing customer and route configuration for assigned markets and OUs. Analyze and validate route structures, including number of routes, route types, customers per route, and regional/district coverage. Execute mass geocoding updates, truck assignments, new customer setups, and scorecard/report updates (Power BI). Validate incorrect configurations such as bad geocodes, route-to-truck assignments, out-of-cluster customers, depot configurations, and loading days. Drive alignment with the business to centralize, standardize, and optimize customer and route data. Build and manage strong relationships with Sales and GTM stakeholders across LATAM markets. Communicate system deviations to local Sales and GTM teams based on agreed sustainability models and KPIs. Prepare and present status, performance, and productivity reports during weekly operational and tactical meetings. Support continuous improvement initiatives and capability development plans. Ensure service delivery according to defined SLAs. Be available to work flexible or mixed schedules based on market needs. Qualifications Bachelor’s degree. 1–2 years of relevant professional experience analyzing data or commercial operations. Proficiency in Microsoft Office (Excel, PowerPoint, Word, Outlook). English: Intermediate to Advanced (written and spoken) – Mandatory. Portuguese: Intermediate to Advanced (written and spoken) – Mandatory, especially for Brazil and LATAM support. Strong ability to manage multiple tasks simultaneously. Customer-focused mindset with strong organizational and follow-up skills. Ability to adapt quickly in dynamic and changing environments. Strong communication skills and experience working with cross-functional and multicultural teams. Adaptable, detail-oriented, and execution-focused. Even if you do not meet 100% of the requirements, we encourage you to apply. Benefits 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. 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 allows you to balance personal and work life, adapting your working day to your lifestyle. Family benefits such as Wellness Line, thousands of Agreements and Discounts, Scholarship programs for children, Aid Plans for different moments of life, among others. Equal Opportunity Employer 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 workforce and innovation for the organization. #J-18808-Ljbffr