Sales Assistant Analyst
PepsiCo
This role is responsible for supporting the IND Commercial team with key reporting and analysis of performance by Channel, Customer and Sales Area against key deliverables. Adding value to the reporting suite, this role also provides meaningful insights and recommendations to the THF Sales Leadership team, highlighting all opportunities for growth and productivity.
Responsibilities
Functional Responsibilities
- Support IND Commercial function with performance reporting against established KPIs, including ad-hoc reporting requests using shipment / POS data and leveraging SAP BI, DMS Distributor and Nielson systems. This support should be extended for TT, MT and Sales Capability as against the initial arrangement of being dedicated to a certain channels.
- Develop on-demand reports delivering improved agility through ease of access and enhanced visualization
- Collate and format large and complex sets of data across multiple channels, customers and sales areas. Analyze data to distil meaningful insights on performance trends and opportunities
- Analyze promotion and NPD activity effectiveness to monitor return on investment and identify opportunities for improvement and customization by Channel, Customer and/or Sales Territory
- Assist with field sales execution and compliance reporting as well as survey initiatives (i.e. price checks in market)
- Present insights and recommendations to THF Sales Leadership team on a monthly basis and in a clear, concise and professional manner
- Support preparation of customer business reviews and JBPs, working cross-functionally with THF stakeholders to collate information on performance trends and opportunities by channel, customer, sales territory or distributor
- Contribute to the development of internal business reviews, providing information to support key planning processes and events. Eg: AOP and Mid-Year / Annual Sales conferences
- Assist with back-end management of Field Sales tool (NewsPage), ensuring data completion and accuracy
- Sustain all digital products developed for Sales capability
- Be the single point of contact for any queries on data integrity and data sanctity
- Develop winning relationships with IND Sales Leadership team and other key stake holders in the IND business, ensuring highest levels of agility and support are provided within established SLAs
- Partner with IND Commercial team to revise and refine reporting requirements, ensuring outputs remain relevant, meaningful and user-friendly to best support decision-making
- Work closely with wider GBS team members to deliver full loop data support to IND business
- Support business development and continuous improvement initiatives to drive growth and efficiency both within IND and GBS Hub
- Degree qualified in Business / Commerce
- Minimum experience 6 years
- Builds robust and successful working relationships
- Strong written and verbal communication skills
- Excellent organisation and prioritisation skills
- Proactive, responsive and results driven
- Strong Analytical skill with Power BI and Sales Commercial domain experience.
- Highly proficient in Microsoft Office, esp. Excel.
- Strong Stakeholder Management skills.
- Fluent English with excellent interpersonal skills
- Exceptional written and oral communication, adapting approach by situation and audience
- High attention to details
- Collaboratively and proactively works with multi-functional teams
- Dynamic, organized and able to handle competing priorities
Working knowledge of SAP BI, and DMS (Newspage) Distributor system