BI An Reporting Assistant Analyst

1 week ago


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

**Responsibilities**:
**Functional 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.
- 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 Cluster Sales Leadership team on a monthly basis and in a clear, concise manner.
- Support preparation of customer business reviews and JBPs, 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: AOP and Mid-Year / Annual Sales conferences.
- Assist with back-end management of Field Sales tool (NewsPage), ensuring data completion and accuracy.

**People Responsibilities**
- Develop winning relationships with Cluster Sales Leadership team and other key stake holders in the Cluster business, ensuring highest levels of agility and support are provided within established SLAs.
- Partner with Cluster 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 Cluster business.
- Support business development and continuous improvement initiatives to drive growth and efficiency both within Cluster and GBS Hub.

Qualifications:

- Degree qualified in Business / Commerce
- 0 -1 Year of experience in Reporting and Analytics role
- 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
- Highly proficient in Microsoft Office, esp. Excel.



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


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

    Egypt (Cairo)- Information Technology- Hybrid- Experienced Professionals**DEPARTMENT**:Data & Automation **REPORTS TO**:BI Reporting Platform Manager **LOCATION**:Egypt*** As an experienced **Platform Architect** with significant technical skills in Power BI and Azure**, **you will join our team in Coca-Cola Hellenic Digital & Technology Platform Services...


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

    Overview: This role is responsible for supporting the MENA FOBO BU Franchise Commercial, finance & planning & other support functions with key reporting and analysis of performance by Channel, Key Customer and Sales Area against key deliverables, Adding value to the reports suite, this role also provides meaningful insights and recommendations to the...


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


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

    **Role Purpose**: To read, analyze and digest what a business wants to accomplish with its data, and develop Business Analytics, Ad-hoc Reporting, Reports, Dashboards and Descriptive Modelling and participate in IT/Commercial projects and choose the best possible design from the DWH and BI perspective. **Key Responsibilities**: - Achieve the agreed...


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


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


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


  • القاهرة, 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: This role is responsible for supporting the MENA FOBO BU Franchise Commercial, finance & planning & other support functions with key reporting and analysis of performance by Channel, Key Customer and Sales Area against key deliverables, Adding value to the reports suite, this role also provides meaningful insights and recommendations to the...


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

    **Responsibilities**: - Execute financial reporting calendar / deliverables and ensure its accuracy before submission. - Ensure timely Monthly reporting package and variance analysis and Monthly Flash. - Ensure all unusual income statement / balance sheet / statement of cash flow variances resolved on a timely basis. - Complete periodic, quarterly & annual...


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

    **Our Company**: StatsBomb was founded in January 2017 to provide data, analytics, and consultancy to football clubs, media, and sports betting companies. StatsBomb continually undertakes new research and is well-known in the analytics industry for providing unique insights into the game of football. We have developed our own proprietary industry-leading...

  • Data Analyst

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

  • Senior Data Analyst

    4 days ago


    القاهرة, Egypt Giza Systems EG Full time

    We are seeking an experienced and results-driven Senior Data Analyst to join our dynamic analytics team. As a Senior Data Analyst, you will be responsible for analyzing complex data, providing actionable insights, and supporting data-driven decision-making across various business functions. You will play a key role in interpreting large datasets, identifying...


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

    The Finance Acctg Intmd. Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the...


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

    **Responsibilities**: - Execute financial reporting calendar / deliverables and ensure its accuracy before submission. - Ensure timely Monthly reporting package and variance analysis and Monthly Flash. - Ensure all unusual income statement / balance sheet / statement of cash flow variances resolved on a timely basis. - Complete periodic, quarterly & annual...


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