Manager - Reporting Services

The BI and Reporting is the digital transformation engine for PepsiCo that sits within the Strategy & Transformation organization. It focuses on the re-imagination and digitization of capabilities, processes, services, and reporting for the Enterprise through the design, development, and deployment of digital products and solutions. S&T BI & Reporting works with business, sectors, markets, and regions, leveraging a core set of integrated technologies, such as AI, ML, RPA, and Conversational AI.

As an Analyst, you will be responsible for delivering and publishing reports as per defined timelines, quality standards and SLAs as per the Reporting catalogue. You are required to align and prioritize on delivery of reports improvements aligned to Transformation goals/priorities, and assist with design, development of automation solutions along with scoping value outcomes.

Execute against team charter for Reporting vertical

• Execute market, portfolio, and brand level reporting of marketing KPI performance (utilizing dashboards, templated decks, and reporting tools)
• Good degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen (POS and HH panel), Kantar Worldpanel
• Leverage business performance explanations from teams around the world to incorporate considerations beyond data into reporting
• Explain business performance, drivers, and optimization opportunities
• Monitor key channel, customer, competitor (incl. PL) and emerging player performance and execute reporting at required intervals

Support Reporting Lead/Sr. Managers/Managers deliver against needs articularted by Business Partners within the Hubs to address the business questions and process requirements

• Deliver against needs of stakeholders, requestors and sector/functional leaders

Support processes for output adherence and delivery to agreed scope in line with the agreed timelines, aligned templates and content management

Monitor and act upon regular feedback inputs from deliverables end-users and Business Partners

Flag and monitor any business risks related to delivering the operational output (facilities, IT resources, recruitment efforts)

Primary executor responsible for flawless support process and structure, including knowledge management and transfer

Process management

• Consults and collaborates with business stakeholders and Product Solution Designers to understand and assess the current state of existing processes through interviews, time activity analyses, process observations, and surveys
• Support strategic initiatives by managing communication with the management team, ensuring all stakeholders are updated on performance and key deliverables.
• Improve existing processes based on frequent end-user and Business Partner feedback loop

• 7 to 9 years overall experience; with excellent written & Verbal Communication skills, world-class stakeholder management skills and solution-oriented approach to problem solving
• Advanced powerpoint and intermediate excel skills. Would be involved in Template creation and alignment with the BU/Sector team
• Ability to convert insights into story that answers critial business questions.
• Intermediate to advanced Power BI knowledge
• Python/ R language knowledge or willingness to pick it up required (preferred)
• Hands on with tools for RMS/POS/Syndicated data sources, IRI, Nielsen, GlobalData, Household panel
• Ability to visualize data set and identify KPIs that will help descision making.