BI & Reporting Associate Analyst

2 weeks ago


القاهرة الجديدة, Egypt PepsiCo Full time

**Responsibilities**:

- Support PepsiCo Franchise senior leadership team (typically LG1+) - with standard reporting against established performance measurables as well as ad-hoc reporting requests
- Responsible on all financial & planning reporting related to the assigned market on the agreed frequency with high level of accuracy. The accuracy of these reports has significant impact on Pepsico spends related decisions running into Millions of Dollars, and without another layer of control - apart from the Franchise Directors themselves, whom the analyst role supports.
- Partner with Cluster Commercial Leadership to revise and refine reporting requirements, ensuring outputs remain relevant, meaningful and user-friendly to best support decision-making
- Analyze large complex data sets, across multiple categories, channels, customers and highlight opportunities by Customer/Channel. The role is expected to not just compile data but understand and highlight insights with better business understanding. This is a key expectation as the Franchise Team is very lean and does not have any other team members supporting data insights.
- Develop on-demand reports delivering improved agility through ease of access and enhanced visualisation
- 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
- Present insights and recommendations to Franchise Leadership team on a monthly basis and in a clear, concise and professional manner. Franchise Analyst is expected to deliver presentations for the Franchise Director that can be then in turn presented to the Bottler of Franchise BU GM for making the business case of investment or insights on spend performance tracking as needed.
- Support Commercial Analytics functional excellence, helping to evaluate new technologies to improve capability of GBS service offering. The role is expected to upgrade the current quality of MS-excel based reports to further enable Power BI and other technology enabled Dashboards for agile and visually enhanced reporting.
- Support business development and continuous improvement initiatives to drive growth and efficiency both within Cluster and GBS Hub
- The Franchise analyst role also works on Funds reconciliation between Bottler and PepsiCo and supports the BU Franchise Finance and Controls teams with Fact Sheets (Approved Spends) tracking and activities completed by the bottler against the approved budgets along with highlight remaining budget on a regular interval.

Qualifications:

- Bachelors in Business / Accounting; MBA preferred
- 1-3 years of experience in Analytics & Reporting within FMCG (Sales or Finance)
- Strength in IT with ability to develop complex analytical modeling, advanced analytical and reporting visualization tools including Power BI and / or tableau, (AI an advantage)
- Strong communication and interpersonal skills



  • القاهرة الجديدة, Egypt PepsiCo Full time

    Overview: - Accelerate PepsiCo business growth by supporting the AMESA DX Sector Leads with category analysis, reporting and category strategy recommendations to drive growth - Responsible for delivering periodic and on-demand category performance reviews, and addressing ad-hoc customer requests, based on internal and external data...


  • القاهرة الجديدة, Egypt PepsiCo Full time

    **Responsibilities**: - Support Cluster 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 - Develop on-demand reports and Scorecards delivering improved agility through ease of access and enhanced visualization -...


  • القاهرة الجديدة, Egypt PepsiCo Full time

    Overview: As the Reporting & Analytics Leader, He/she will ensure that exceptional operational services are provided, by his/her organization, to sales associates across multiple teams and markets. These services include support of all reporting and analytics services included in the service catalogue in addition to ad-hoc analysis and reporting aligned...

  • Analyst, Sales

    15 hours ago


    القاهرة الجديدة, Egypt Energizer Full time

    This is Energizer Holdings, Inc.: Energizer Holdings responsibly creates products to make lives easier and more enjoyable. To do this, we lean into our culture as an organization - we win together, while serving each other, with a willingness to act boldly, all while doing right. Our colleagues hail from all backgrounds, nationalities and walks of life, but...


  • القاهرة الجديدة, Egypt PepsiCo Full time

    Overview: This role is responsible for supporting the Cluster Commercial team with key reporting and analysis of performance by Channel, Customer and Sales Area against key deliverables. Adding value to the reports suite, this role also provides meaningful insights and recommendations to the Cluster Sales Leadership team, highlighting all opportunities for...


  • القاهرة, Egypt Payless Kitchen Cabinets Full time

    **JOB TITLE: Data Analyst** **JOB TYPE: Part-time** **LOCATION: Remote** **SCHEDULE: Monday-Friday, 9:00am - 1:00pm PST** **COMPENSATION: To be discussed by Hiring Manager** **Our Story**: We're a family owned and operated, kitchen, bath, and flooring remodeling company located in Southern California. We've been in business for over 35 years, and are...


  • القاهرة الجديدة, Egypt PepsiCo Full time

    Overview: You are in charge of analyzing, monitoring and resolving pricing disputes. You prepare the monthly closing elements by centralizing and codifying all the disputes in your customer portfolio. **Responsibilities**: - **Management of the dispute database**: - Collect and complete information relating to customer disputes (deductions) in order to...

  • Cluster Analyst

    1 week ago


    القاهرة, Egypt Nestlé Full time

    **Cluster Analyst** Full-time Department: Finance **Position Summary** Joining Nestlé means you are joining the largest food and Beverage Company in the world. At our very core, we are a human environment - passionate people driven by the purpose of enhancing the quality of life and contributing to a healthier future. Responsible for the financial...


  • القاهرة, Egypt Vodafone Full time

    **Responsibilities**: - Business Intelligence Product Owner will work closely with other members of the team to provide focused backlog management and iteration planning. This is a fast-paced and demanding role working with Finance stakeholders & technical squad members in a bid to deliver the best experience for customers. - Working with Finance teams,...

  • Data Analyst vois

    7 days ago


    القاهرة, Egypt Vodafone Full time

    **Role purpose**: To turn data into information and information into insight to support Vodafone ambition to improve energy efficiency. The Data Analyst will be working with key stakeholders within Group Technology to ingesting and describing data, assessing data utility, producing ad hoc and regular reporting that will help us identify energy cost saving...