OverviewThis 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 udpates / 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)
- Manage on-ticket and bottle bill pricing (South Division only)
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
