Sales Reporting Sr. Associate- GBS (Cairo Hub) At Pepsico
New Cairo, Egypt
Support Cluster Commercial function with performance reporting against established KPIs, including ad-hoc reporting requests using shipment / Point Of Sale data and leveraging SAP BI, Distributor and Nielson systems.
Develop on-demand reports and Scorecards 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 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 Cluster Sales Leadership team on a monthly basis and in a clear, concise manner.
Support preparation of customer business reviews, working cross-functionally with Cluster 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: Annual Operational Plan and Mid-Year / Annual Sales conferences.
Assist with back-end management of Field Sales tool (NewsPage), ensuring data completion and accuracy.
0-1 years of experience in Sales Reporting role.
Strong written and verbal communication skills.
Strong Analytical skills.
Highly proficient in Microsoft Office, esp. Excel.
Excellent command of English.