Sales Admin & Ops Asst Analyst

Overview This individual contributes to the success of PepsiCo by supporting pricing systems and field, Division and Sector teams. Role provides reporting and minor analysis support to Field Sales & Finance teams, as well as manage annual price increases for Division price groups and Key Accounts (KAs). Team will create a strong relationship with Finance & Sales (KAMs, FSRs, Channel Managers). This role requires analytical thinking, flexibility to adapt to changes, proactiveness and relationship-building skills. Responsibilities Manage SPA Box and provide 48hr SLA response to all requests, determining next steps and looping in partner functions as needed Maintain Customer group names per standards; complete edits as terms change 2x Annual Price Change activities, including but not limited to: Identify expiring groups; work w/ finance for rates, calculate new prices, collect sales tams changes, submit thru approval process, generate mailing lists 2x Annual Nat’l Ftn Price maintenance, including but not limited to: Identify expiring groups, submit pricing based on National guidance, forward thru approval process Create new price groups as needed, adhering to contractual or finance-provided thresholds and approvals Manage multi-regional account pricing by partnering w/ Multi-regional coordinator (forwarding emails / issues / projects) Maintain Customer Groups: moving customers from one group to another, adding customers to “blocked” groups (including HQC managed), adhering to all thresholds and alignments required Regularly review KA groups to ensure all COFs have same pricing Provide price sheets to sales upon request via online tool Provide analysis and recommendations to finance and sales to assist in clean-up & reduction of price groups (YOY pricing, caps, volume/price analysis) Provide data / analysis for ad hoc pricing reporting requests Provide explanation and training to sales, including but not limited to: definitions of price groups & products, how to read pricing groups, items, set up, national flag, etc.. Be able to explain down-stream impacts of decisions within pricing Manage all contractually mandated pricing w/in thresholds of contract, communicate w/ sales and finance as needed on updates / changes, required documentation needed Manage RFP forms on behalf of sales in VCS locations (currently Central & West Division only) Ensure business segment is valid and accurate where it exists Manage wholesale pricing via location reports and/or Siebel inquiries – work with sales and/or finance to determine correct pricing where needed, or determine best price when supportable, and update price group Manage daily free goods requests, gaining appropriate approvals and submitting requests timely Update price groups as needed for innovation items per guidance from national / division finance and sales (including some HQC Management) Add new package configurations to pricing as needed per guidance from national / division finance and sales Manage special deal creation (i.e., volume hurdle deals, short-term overrides, etc.) Maintain upcharges for on-ticket pricing in specific markets (Hawaii and Alaska) Qualifications 5-6 years of experience as junior/mid-level analytics professional with experience, preferably in a leading consumer goods company Bachelors in finance or economics Strong knowledge of MS Office programs specifically Excel Have 1+ years’ experience using SAP & Oracle platforms Propensity to learn PepsiCo software systems Highly organized and responsive, with ability to work to SLAs and tight deadlines Best-in-class time management skills, ability to multitask, set priorities and plan Excellent written and oral communication skills; proactively communicates using appropriate methods for situation and audience in clear, concise and professional manner Ability to provide superior customer service Language Skills – Fluent English Ability to see connections in data, anticipate next steps and provide actionable insights