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. PepsiCo has recognized brands such as DETODITO, TROPICANA, CHEESE TRIS, CONCORDIA, PLATANITOS, KCHITOS, among others. 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 The main purpose of this role is to coordinate all end-to-end concentrate supply chain processes: Importation, Inventory Management and Distribution and Sale to the Bottler, in order to produce finished beverage products in Colombia with brands such as Pepsi, 7 Up, H2Oh and Gatorade. Your Impact As SC Analystyour responsibilities would consist of PURCHASE (Imports). - Concentrate import management of all Colombian beverage brands valued at US MM per month in 2023 - Coordinate transportation to warehouse (CSD) and to bottler plants (NCB). (Making decisions,being informed, providing consultation and executing actions) - Support Colombia's demand planning process by ensuring correct concentrate purchasing and inventory coverage. - Generate PO in SAP for CSDs, NCBS. (Executing actions) - Coordinate the product arrival to the warehouse. (Making decisions and Executing actions) - Approve supplier billing (Customs, Transportation and Logistics Operator), . (Making decisions,being informed, providing consultation and executing actions). SALES (Invoicing) - Plan the monthly concentrate distribution based on the bottler's requirements. Purchase order per month valued at US MM in 2022. (Making decisions,being informed, providing consultation and executing actions) - Crear order cycle in SAP that include order, picking (according to FEFO policy) and billing. (Making decisions and Executing actions) - Coordinate dispatches between warehouse and transportation (Executing actions) - Generate unit and billing reports. (Executing actions) - Create new SKUs in SAP for all beverage brands. (Executing actions) - Execute SOX controls: Double counting of picking and warehouse dispatch. (Providing consultation and executing actions). INVENTORY - Manage concentrate inventories valued per month at US$ MM in 2023, guaranteeing product availability and minimum lost inventory. - Physical inventory count and monthly inventory conciliation between warehouse and SAP Pepsico ensuring there are no inventory differences (Making decisions,being informed, providing consultation and executing actions) - Report transits and expiration risk alerts, ensuring that risks are provisioned and expirations are avoided. (Executing actions) - Execute SOX controls: Physical inventory. (Providing consultation and executing actions). OTHER - Analyze and provide visibility of supply chain KPis (Analyzing and executing actions) - Identify and activate productivity projects and improvement of Supply chain processes. (Planing and executing actions) - Support and costing of area projects such as new finished product import businesses. (Executing actions) - Responsible for SST control for contractors related to the area's concentrates. (Providing consultation and executing actions). - Send documentation to ANDI with requirements for plastics placed on the market. - Support in internal and external audits. These responsibilities affect different internal stakeholders such as Operations, Franchise, Finances, Control, Treasury, AP, AR and Marketing, and external stakeholders such as the bottlers (Postobon-Vemco-Demerara), warehouse, transportation, customs agents, foreign suppliers (Uruguay, United States and United Kingdom). Qualifications Who Are We Looking For? - 3+ years of experience in supply chain. - Experience in import management and knowledge in international trade (Incoterms, Freights, Customs). - Experience in inventory management. - Knowledge in supply chain planning - Outsourced logistics administration - Knowledge in software management: SAP, Office, etc. - Knowledge in excel and dynamic tables - Work under pressure. - English B1 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.