BI & Reporting Associate Analyst

2 days 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...

  • BI Sr. Specialist

    3 weeks ago


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

    **Key Accountabilities & Decision Ownership**: - Handle end of month non-financial closing & weekly outlook in addition to its P&L. - Analysis and monitor non financials trends, ensure data quality & proactive detection for abnormal trends for data accuracy. - Acting as Business Analyst for BI tribe, supporting tribe in automation projects and BI normal...


  • القاهرة, Egypt Rawaj - Human Capital Management Full time

    Leverage your abilities and join the dynamic team of a leading company specializing in **Mining & Logistics In Riyadh, Saudi Arabia** **Job Context: working as a Financial Reporting Analyst **you will be responsible for preparing and reviewing accurate and timely financial reports, conducting in-depth analyses of financial data, and providing actionable...

  • Power BI Developer

    3 weeks ago


    القاهرة, Egypt Coca‑Cola HBC Austria GmbH Full time

    Egypt (Cairo) - Information Technology - Hybrid - Experienced Professionals - We are looking for an intellectually curious Power BI Developer with significant technical skills in Power BI and business acumen to join our team in Coca-Cola Hellenic Digital & Technology Platform Services (DTPS) and be part of the BI Reporting team. You will have the opportunity...


  • القاهرة الجديدة, 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...

  • Data Analyst

    1 week ago


    مصر الجديدة, Egypt Employ me Full time

    Job Description: Data Analyst About the Role: Key Responsibilities: **⁠ ⁠Collect, clean, and preprocess large datasets from various sources.** **⁠ ⁠Write and optimize complex SQL queries for data extraction, aggregation, and analysis.** **⁠ ⁠Perform data analysis using advanced aggregation techniques to identify trends, patterns, and...


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

    Overview: This role will manage a team of 8-9 AR analysts who are responsible for timely and accurate preparation of day to day/ monthly/quarterly/annual AR deliverables. The role entails interaction with the business unit control teams and outsourced delivery teams. The role should meet defined service levels and KPIs, including customer...


  • القاهرة, 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...

  • Big Data Analyst

    3 weeks ago


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

    **Advansys** is a dynamic solutions provider focused on delivering smart, modular, and sustainable technology solutions that enhance operations, improve customer experiences, and drive business modernization. With over 400 skilled engineers, we serve 100+ enterprise customers across 14 countries. Specialized in a wide array of premium services including...

  • Data Analyst

    2 weeks ago


    القاهرة, Egypt Orange Business Full time

    **Votre rôle**: The CTIO department is in charge of decision-making information systems, serving Orange Business different line of businesses such as marketing, pre-sales, sales, production, after-sales services, and customer-service for both France and international domains. In an Agile context, the senior data analyst is to undertake the following...

  • Data Analyst

    3 days ago


    القاهرة, Egypt On-Hire Full time

    A leading Fintech company is seeking a detail-oriented and analytical Data Analyst to join our growing team. As a Data Analyst, you will play a critical role in transforming data into actionable insights that can help guide strategic decision-making across the organization. You will work closely with various departments to analyze trends, create reports, and...


  • القاهرة الجديدة, 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...

  • Sr. BI Engineer

    2 days ago


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

    **Role Purpose**: The Sr. BI Engineer is a core member of the agile teams implementing BI solutions. The Business Intelligence Authority engineer will be responsible to implement and develop BI solutions including data modelling and system development while guiding junior developers in fulfilling the same **Key accountabilities and decision ownership**: -...

  • Data Analyst

    2 days ago


    القاهرة, Egypt On-Hire Full time

    On-Hire, a trailblazer in the FinTech space, is looking for a dynamic and skilled Data Analyst to join our innovative team. In this role, you will harness the power of data to inform and propel our business strategies. As a Data Analyst, you will work closely with our product, marketing, and operational teams to uncover insights from complex datasets, drive...


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

    Octopus by RTG is partnering with consultancy firm in KSA to hire a Senior Power BI designer with an engagement for 6 Months, As a Senior Power Bi Designer, you are responsible for the visual and user experience aspects of Power BI including creating visually appealing and intuitive dashboards and reports that effectively communicate data insights to...


  • القاهرة, Egypt Souq.com for E-Commerce LLC Full time

    Work a flexible schedule/shift In addition to having shop-floor affinity and experience in Industrial Engineering/Business Process Engineering,/Quality, Operations or Logistics, you are an active networker with: BI sage and SQL experience Strong analytical capabilities Excellent communication skills (written and verbal) Fluent English The Business Analyst...


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

    **AP Posting Associate** **POSITION SNAPSHOT** **Company: Nestlé Business Services Location: Cairo, Egypt. Department: Source to Pay **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...

  • Programme Associate

    3 days ago


    القاهرة, Egypt World Food Programme Full time

    DEADLINE FOR APPLICATIONS 13 January 2025-23:59-GMT+02:00 Eastern European Standard Time (Cairo) ABOUT WFP The World Food Programme is the world’s largest humanitarian organization saving lives in emergencies and using food assistance to build a pathway to peace, stability and prosperity, for people recovering from conflict, disasters and the impact of...