Commercial Reporting Analyst

**Auto req ID**: BRPepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®, DORITOS ®, CHEETOS ®, GATORADE ®, PEPSI ®, QUAKER ® and more. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands that generate more than $1 billion each in estimated annual retail sales.Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability and human capital at the center of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people.Our employees drive our culture. No two days are the same; we are dynamic and full of passionate teams that embrace new ideas through our collaborative spirit. At PepsiCo, we know that our company can only succeed when our associates and the society we serve flourishes. We are committed to fostering a diverse workforce by creating a collaborative, equitable and inclusive space where everyone, regardless of what we look like, where we come from or who we love, has a voice. At PepsiCo we create a Space to be y( )u.**GBS Commercial Reporting Analyst****Main Purpose**We are PepsiCo. We are a diverse organization, spread among 200 countries and united by a shared set of values and goals. That’s why we Perform with Purpose. Together, we blaze new trails, succeed, celebrate and never settle for second best. At PepsiCo, we’re committed to performing well as individuals and in teams, to strengthen the company as a whole.The Role of Commercial reporting Analyst has the objective of supporting the PMF business teams by creating, executing, and populating the information related to the commercial area with standards reports and BI tools.Point of contact between the business and the technology teams as troubleshooting for any data or performance issues.As the Commercial Reporting Analyst, it will be necessary to work through requirements gathering with functional teams of PMF, being able to document needs, manage themselves with setting appropriate activities.**ACCOUNTABILITIES:- Capable to analyze a request or issue and provide a solution either with existing reporting tools or by enhancing new functionalities.- Able to optimize process by leveraging best practices- Establish process to identify, track, escalate, resolve, and report customer problems- Ensure appropriate customer escalations and ticket assignment with different teams including sustain- Oversees on-boarding of new reports and services by training end user’s community- Participate in fine tuning activities to improve performance and/or ensure the SLA- Participate the continues improvements meeting- Responsible of Business Intelligence functional specs documents and the assessment of the project.- Execute reports according to SLAs (Service level agreement)**Qualifications/Requirements**:**KEY SKILLS/EXPERIENCE REQUIRED**- Business Administration, Engineer or Data & Analytics related career- Good understanding of Business analytics and reporting tools (Tableau, SAP Business Objects, etc.)- Expertise using different source systems of data like SAP/BW, Teradata, EDW, Flat files etc.- Advanced skills on Microsoft Excel- Knowledge of data governance models and Customer/Material hierarchies- Proficient on creating dynamics Dashboards and Reports at different levels of details using the PepsiCo standards reporting tools (e.g. Tableau, Business Objects, MicroStrategy, etc.)- Basic EnglishThank you so much for thinking about PepsiCo to start or continue your career**Relocation Eligible**: Not Applicable**Job Type**: Regular