Inventory Optimization Sr Analyst

OverviewWe Are PepsiCoJoin 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: PepsiCoJobsJoin PepsiCo, dare for better.ResponsibilitiesThe OpportunityThis role is to provide support to the PBNA Inventory Optimization modeling by collecting input data, cleaning or removing data discrepancy, running the models and analyzing the output. This role is responsible for data accuracy for all locations/material in scope for PBNA. The will entail monitoring data quality metrics, engaging SMEs in field and sector to determine appropriate input values for each parameter. Will include running sensitivity analyses to determine impact of a range of choices for input values have on the output values; analyze and review with IO team. This resource will also be required to initialize all the data and meet the exit criteria for exiting hypercare.Your ImpactSupport IO/RP Division Capability LeadsMake mass update master data updates upon request from DivisionManage the business rules for default input values and ensure correct parameters settingPull together historical data and summarize for SMEs reviewRun sensitivity studies upon request from Division CLsMonitor & respond to alerts found in IBP Analytics StoriesProvide Visibility on Fix needed within IBP per Item LocationManage SKUs segmentation and lead inventory policies for each segmentIdentify and manage Inventory in Excess / stockouts on the network, leading action plans for improvementsRun deep dives and what-if scenarios simulations for inventory managementSupport Cross functional partner FTS/ITMonitor for IO QoS IssuesImplement model changes on current solution designImplement/Monitor input/output data consistency checksInvestigate input data discrepancies (for e.g. schedule adherence < 60% in IO)Support Analytics/VisualizationUpdate Inventory and Supply dashboards weeklyImplement enhancements on current tools utilized to calculate optimal levelsPerform data consistency checks on SAP ModulesCreate, share & respond to weekly Inventory levels to Review reportDesign different optimization scenarios for product/locationsReporting of missing master data for all NA product/locationsReporting of Changes in Forecast increase/decreaseProvide Full detailed explanation on Inventory Results and give recommendations on parameter setQualificationsWho Are We Looking For?Bachelor degree in Supply Chain, Logistics, Operations Research, or Industrial EngineeringFluent knowledge and use of MS EXCEL, Powerpoint, Word, and Business IntelligenceKnowledge of SAP IBP, SQL, Python and Power BI tools preferred3-5 years of planning / Inventory management experience, E2E SC KnowledgeKnowledge of Automation Tools and creating connectionsAbility to navigate complex datasetsFlexible, ability to model “what if” scenarios with business acumenEffective team playerAdvanced degree (MBA/MS) in Supply Chain, Logistics, Operations Research, or Industrial Engineering is a plusIf 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. #J-18808-Ljbffr