OverviewThis role will support the Account Sales team by:
- Maintaining the trade promotions management system (SAP TPM) with all inputs for planned promotional activities, including accruals and claims processing.
- Maintaining GS1 Net with all relevant product updates ensuring consistency of information across PepsiCo and the retailer landscape.
- Forecasting (both promotion and base into PepsiCo and customer systems) and invoicing (matching customer invoices with associated PepsiCo ids).
The sales coordinator's role is business critical, managing day to day administration while allowing the national account management team to focus on customer engagement & strategy
ResponsibilitiesExternal (30% time): interface with customer portals
- Promotions: load promotions in line with promotional plan every period (including retro or off invoice trigger spend). Ensure all promotion entries and updates fall within required control standards and in line with the weekly Integrated Planning cycle
- Price file: manage customer price file on customer portal
- Invoicing: manage invoicing from customer portal where required
- Price claims: able to cross reference activities in customer system with activities set up in PEP system
- Bad debt: able to work with KAM to identify cause of bad debt and push back to customer
- Pricing tracking: able to track live pricing in the market when applicable (e.g. post CPI changes)
Internal (70% time): lead for internal forecasting and promotional set up
- Promotional Calendar: Manage & update promotional calendars for KAM teams
- Promotions: load promotions into system for customer base
- Evaluation: evaluation of promotions, working with KAM to course correct where necessary
- Forecasting: manage and input account forecast to line level detail (base, promo, and promotions)
- Forecast accuracy: manage forecast accuracy in line with agreed targets / KPIs
- Invoicing: manage invoicing from customers and matching to SAP activities for processing
- Price claims: manage and process claims via AR collect, agreeing with KAM which activities are correct
- Team: lead cross functional group (KAM + supply chain) to ensure forecast is accurate and reflective of execution
- Systems: use of sap and excel
Functional Responsibilities
- Maintain internal and external promotional systems for Pep & Customer ensuring all promotions are set up correctly with right products, time periods, funding mechanism (off invoice vs. retro) and discounts.
People Responsibilities
- Develop winning relationships with Account Management team and other key stake holders within the business, ensuring highest levels of agility and support are provided
- Work closely with Cluster Sales Coordinators & POBM analysts, ensuring accurate and timely processing of trade claims
- Support the Cluster Sales Lead with all initiatives to improve GBS service offerings
Qualifications- Degree qualified in Business / Commerce
- Builds robust and successful working relationships
- Strong written and verbal communication skills
- Excellent organisation and prioritisation skills
- Proactive, responsive and results driven
- Highly proficient in Microsoft Office programs and Reporting
Essential
- Fluent English with excellent interpersonal skills
- Exceptional written and oral communication, adapting approach by situation and audience
- High attention to detail
- Collaboratively and proactively works with multi-functional teams
- Dynamic, organized and able to handle competing priorities
Good to have :
- Working knowledge of SAP TPM, SAP ERP and BI
Experience in FMCG