Overview

The Data analyst will play a critical role in the success of the Mosaic (global planning tool). Mosaic is transforming the way FP&A teams work across PepsiCo markets and the level of financial information available for the senior leadership teams.The analyst will be responsible for the ongoing live market support focussing mostly on resolution of data issues, providing guidance on data sources, systems, data flow to the solution, root cause analysis and solution deployment. Additionally, he/she will be key in understanding data compliance requirements and assisting local teams by supporting their data preparation to be MOSAIC ready.The role will require working closely with the IT/BRM, the Sector FP&A, the Cockpit and other functions teams (Net Revenue Management, Global Procurement, Coman, Supply Chain, etc.)

Responsibilities

• Live market support – technical support:o Gain knowledge on data used within MOSAIC Program including existing data set up, data sources, transformation logico Gain knowledge on how data is being “consumed” by the end-users (analysts, senior leaders)o Run root cause analysis of issues raised by BU users, suggest potential solution and drive their executiono Provide guidance and help in getting BU SPOT ready regardless of the origin and size of their data

• Live market support – support with Data Quality Rules:o Deep understanding of data quality requirements to be SPOT complianto Gain knowledge on existing Data Quality Rules including logic behind them and data objects being checked and their sources o Run root cause analysis of data issues flagged with Data Quality Rules, suggest solution and drive execution

• Support sustainable data solution:o Close collaboration with wider Global MOSAIC Data team to drive consistency in set up of master datao Prepare user guides for common processes and help building documentation for common data issue fixes

Qualifications

• Love for data and problem solving demanding sharp analytical skills to handle/evaluate large amount of data (strong attention to details); Ability to navigate from the “big picture” to the details translating quickly multiple stakeholders’ perspectives into clearly defined data quality requirements• Strong communicator and a good people person given the need to collaborate effectively across teams and people of diverse backgrounds• Technical competencies across a variety of software including: Tableau, Alteryx, Databricks, SAP, Oracle, Power Steering, TM1 & Cognos and the drive to expand knowledge into new areas• Familiarity with technical database structures and hierarchy as well as ability to structure highly complex concepts into simple execution• Ability to structure highly complex concepts into simple execution.• Expertise and knowledge of database management principles and applications.• Ability to navigate complex and varied processes across multiple markets.• Knowledge of Basic Python, Python Spark and SQL will be considered a plus