.Overview: We Are PepsiCo Join PepsiCo and Dare for Better! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place. Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries. Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years. A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world. Know more: PepsiCoJobs Join PepsiCo, dare for better.Responsibilities: The OpportunityThe Role of Commercial Reporting Analyst has the objective of supporting the LATAM 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 LATAM, being able to document needs, manage themselves with setting appropriate activities.Your Impact As Reporting and analytics Analyst your functions would consist of: 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.Consistently attending meetings with the client subject matter expert to acquire functional business requirements.Participate in the continuous improvements meeting.Responsible for Business Intelligence functional specs documents and the assessment of the project.Execute reports according to SLAs (Service level agreement).Qualifications: Who Are We Looking For?Education:Business Administration, Engineer or Data & Analytics related career.Experience:Advanced English.Good understanding of Business analytics and reporting tools (Excel, Power BI Desktop, Power BI Service, etc.).Desirable using different source systems of data like SAP/BW, Teradata, EDW, Flat files etc.Intermediate or advanced skills on Microsoft Excel.Basic or intermediate skills on Power BI
