Sourcing Planner Sr. 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.**Know more**:PepsiCoJobs**Join PepsiCo, dare for better.****Responsibilities**:**Tactical Capacity Sourcing Planner in Mexico City**:**The Opportunity**:Are you passionate about supply chain optimization and looking to make a real impact in a dynamic environment? As a **Tactical Capacity Sourcing Planner**, you will play a critical role in ensuring an optimized capacity plan across the network, balancing service levels, costs, and operational constraints.You will collaborate closely with **platform owners, industry managers, and raw material planners** to develop sourcing plans, analyze supply chain strategies, and drive optimization initiatives. Your expertise will help shape key decisions by leveraging **data-driven insights, scenario analysis, and supply chain planning tools**.If you enjoy working with complex data, influencing strategic decisions, and optimizing supply chain performance, this is the perfect opportunity for you**Your Impact**:As a **Tactical Capacity Sourcing Planner**, your responsibilities will include:**Data Management & Optimization**- Ensuring accuracy of master and transactional data within supply chain tools.- Maintaining and updating key data sources to support network optimization.- Monitoring and adjusting optimization models to improve efficiency.**Strategic Planning & Analysis**- Partnering with business leaders to develop sourcing and production plans for **internal plants and external manufacturing partners** over short- and mid-term horizons.- Running scenario and simulation analyses to assess sourcing strategies.- Identifying opportunities to improve cost efficiency and service levels through strategic sourcing decisions.**Collaboration & Influence**- Coordinating sourcing changes with key stakeholders across supply chain functions, including **production planning, transportation, warehousing, and inventory management**.- Supporting the **monthly and annual business planning processes** with insights from network optimization.- Communicating optimization results in a clear and actionable way to senior decision-makers.**Operational Execution**- Publishing sourcing and production ratios for supply chain planning teams.- Setting up **transportation lanes** to enable smooth daily and weekly operations.- Driving continuous improvement in sourcing analytics and planning processes.Qualifications:**Who We're Looking For**:**Location**: This position is **based in Mexico City**.**Education & Experience**:- Bachelor's degree or equivalent work experience.- ** At least 4 years of experience** in supply chain planning, with a preference for **network optimization experience**.**Technical & Analytical Skills**:- Strong ability to **analyze large datasets and develop data-driven recommendations**.- Proficiency in **Excel, Pivot Tables, and supply chain optimization tools** (experience with SAP systems is a plus).- Background in **data analysis or model building** is a plus.**Problem-Solving & Communication**:- Ability to **translate supply chain constraints into optimization models** while maintaining data integrity.- Strong **influencing and negotiation skills**—comfortable challenging assumptions and asking critical questions.- Effective communicator who can **simplify complex data** for business decision-making.**Collaboration & Adaptability**:- Team player who thrives in **cross-functional collaboration**.- Flexible mindset, with the ability to run **“what if” scenario modeling** to support strategic business decisions.- Understanding of **network and production capabilities and capacity**.**Why Join Us?**:**Impactful Work** - Play a key role in optimizing our global supply chain.**Collaborative Culture** - Work with talented professionals across multiple business functions.**Career Growth** - Gain experience in strategic decision-making and leverage cutting-edge technology.If you're a **data-driven, strategic thinker** with a passion for supply chain optimization, we want to hear from you**What can you expect from us**