Overview The main responsibility of this person is to: 1) Set up New & Change ownership of Properties including equipment requests (General Sales Support) 2) Ensure all customers receive accurate trade rebates down to the COF level across all three teirs of trade management including GPO, Management company, Hotel Brand and Property (TPM) 3) The role pulls data to allow for analysis of trends in business to identify areas of opportunity to capitalize on funding and growth models for both customer and PepsiCo. This is a subsidy for category management team on the retail side of the business. (R&A) Responsibilities Provide excellent customer service, response time to executive level customer stakeholders- 800 Management Companies Align Rebate payments to management company level across PBC, FBU while maintaining customer list for HSM properties + Hiltons that are under Avendra Customer reporting to issue rebates & provide insights related to the data (automate and provide enhancemnts to the data then upload to PowerBI) Build presentable tables for KAMs Hilton + Hilton Supply new business on beverage (add to existing data). Second Largest GPO in lodging (similar to Avendra) Qualifications Written and spoken English language proficiency Analytical: pull, analyze, and automate data within PowerBI Detail oriented when looking at large amounts of data to provide trends Strategic Thinker: to plan for future reporting enhancements Knowledge of IT systems including: Star2, ERT, Micro Strategies (but will change in April ’24) Excel skills required: vlookup, pivot tables, cross referencing multiple excel sheets Powerpoint skills required: decks to report out insights (charts to visusalize data, but could also be in PowerBI)