Sales Reporting

Overview:**We Are PepsiCo**Join PepsiCo and dare to transform 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. PepsiCo Mexico is one of the most significant consumer product companies in the country. 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 a little more**: PepsiCoJobsJoin PepsiCo, dare to transform.**Responsibilities**:**The** **Opportunity**The role of Sales Reporting & Analytics 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.**Your Impact**As Sales Reporting & 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- 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:**Who Are We Looking For?**- Business Administration, Engineer or Data & Analytics related career- Good understanding of Business analytics and reporting tools, intermediate-advanced Power BI and basic Power Query.- Expertise using different source systems of data like SAP.- Intermediated or advanced skills on Microsoft Excel- Proficient on creating dynamics Dashboards and Reports at different levels of details using the PepsiCo standards reporting tools (e.g. Power BI, Business Objects, MicroStrategy, etc.)- Intermediated or Avanced English**What can you expect from us**:- Opportunities to learn and develop every day through a wide range of programs.- Internal digital platforms that promote self-learning.- Development programs according to Leadership skills.- Specialized training according to the role.- Learning experiences with internal and external providers.- We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.- Financial wellness programs that will help you reach your goals in all stages of life.- A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.- And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.