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 Franchise Leadership team, highlighting all opportunities for growth and productivity. The Franchise Analyst roles has the added key responsibility of interacting with the relevant bottler team members to gather the data and support reconciliation between PepsiCo and Bottler on Co-op Budgets and Spends along with PepsiCo Finance and Controls team. 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 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 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 Develop daily interaction with senior leadership with the market under scope. Across multiple Functions including Franchise Directors, and BU Finance Planning and Controls teams Qualifications Bachelors in Business / Accounting; MBA preferred Min 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