Customer Collaboration Analyst at PepsiCo Athens, GA

Comunidade Metodista; Athens (GA); On-site; USD 90,000 - 110,000; Full time

Job summary

PepsiCo is seeking a Supply Chain professional to act as the main liaison between Supply Chain and Sales, ensuring full visibility of the product portfolio and optimal service levels. You will drive improvements, coordinate scheduling and transportation, and monitor inventory and forecasts to support customer growth.

The role requires a university degree in a related field, 3–5 years of logistics experience, and advanced Excel plus BI reporting experience with Power BI or Tableau.

Qualifications

• University degree in Engineering, Logistics, Supply Chain Management, or a related field.
• 3–5 years of experience in logistics or supply chain operations, ideally in customer-facing roles.
• Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, and Power Query.
• Proven experience creating, managing, and analyzing BI reports with Power BI/Tableau.

Responsibilities

• Serve as primary contact between Supply Chain and Sales with full visibility of the product portfolio.
• Drive continuous improvement of customer experience and service levels through proactive engagement.
• Manage scheduling, transportation, and repacking follow-up with production for availability.
• Monitor weekly inventory per SKU and prepare optimized replenishment orders for the DC.
• Provide portfolio visibility to Sales and align priorities with supply constraints.
• Track marketing plans, ensure volumes reflect in forecasts, and adjust orders to optimize truck utilization.
• Deliver service level reporting, root-cause analyses, and corrective actions.

Skills

Customer orientation

Analytical thinking

Cross-functional collaboration

Communication skills

Education

University degree in Engineering, Logistics, Supply Chain Management, or related field

Tools

Power BI

Tableau

Excel

Job description

Overview

PepsiCo is home to some of the world's most loved food and drink products. Making every day favourites like Lay's, Quaker, Doritos, Pepsi and Lipton, to name a few! We have a fantastic reputation for developing and launching products that our consumers love. PepsiCo products are enjoyed by consumers around the world more than one billion times a day in more than 200 countries and territories. The company generated $91 billion in net revenue in 2023.

Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability at the centre of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people. For more information, visit

Responsibilities

This position serves as the primary point of contact between the Supply Chain function and the Sales team, ensuring full visibility of the product portfolio and maintaining optimal service levels.

• Act as the main Supply Chain contact for the largest OT account, ensuring seamless communication and collaboration.
• Drive continuous improvement of customer experience and service levels through proactive engagement and responsiveness.
• Manage scheduling, transportation, and repacking follow-up, including daily coordination with production to ensure availability.
• Monitor weekly customer inventory per SKU and prepare optimized replenishment orders for the Distribution Center.
• Provide full portfolio visibility to the Sales team, ensuring alignment on priorities and supply constraints.
• Adjust orders to optimize truck utilization and influence customer order patterns when necessary.
• Track and monitor customer marketing and promotional plans, ensuring volumes are accurately reflected in forecasts.
• Support customer growth through value-driven proposals that align with financial goals for both PepsiCo and the customer.
• Deliver comprehensive service level reporting, conduct root cause analysis, and recommend corrective actions for any issues across the portfolio.

Report and analyze key supply chain KPIs including service level, Days on Hand (DOH), fill rate, logistics cost per unit (CPU) per customer, and service satisfaction.

Qualifications

• University degree in Engineering, Logistics, Supply Chain Management, or a related field.
• 3-5 years of experience in logistics or supply chain operations, ideally in customer-facing roles.
• Advanced proficiency in Microsoft Excel, including functions such as pivot tables, VLOOKUP, Power Query, etc.
• Proven experience in creating, managing, and analyzing Business Intelligence (BI) reports (e.g., using Power BI, Tableau, or similar tools).
• Strong customer orientation, proactive mindset, and ability to collaborate cross-functionally.
• Excellent analytical and problem-solving skills with keen attention to detail.
• Strong communication skills and ability to influence stakeholders across various levels.
• Fluent in English, both written and spoken.
• Strong organizational skills and the ability to manage multiple priorities effectively.