Sales Reporting & Analytics Analyst (Miguel Hidalgo)

Overview

The Sales Reporting & Analytics Analyst supports LATAM business teams by creating, executing, and populating commercial reports using standard reporting and BI tools.

Responsibilities

• Analyze requests or issues and provide solutions using existing reporting tools or new functionalities.
• Optimize processes by leveraging best practices.
• Establish a process to identify, track, escalated, resolve, and report customer problems.
• Ensure appropriate customer escalations and ticket assignment across teams.
• Oversee onboarding of new reports and services by training end‑user community.
• Participate in fine‑tuning activities to improve performance and ensure SLA compliance.
• Attend continuous improvement meetings.
• Prepare Business Intelligence functional specification documents and project assessments.
• Execute reports according to SLAs.

Qualifications

• Business Administration, Engineering, or Data & Analytics related degree.
• Good understanding of business analytics and reporting tools; intermediate‑advanced Power BI and basic Power Query.
• Experience with source systems such as SAP.
• Intermediate or advanced Microsoft Excel skills.
• Proficiency in creating dynamic dashboards and reports at various detail levels using PepsiCo reporting tools (Power BI, Business Objects, MicroStrategy, etc.).
• Intermediate or advanced English proficiency.

Benefits

• Opportunities to learn and develop through a wide range of programs.
• Internal digital platforms for self‑learning.
• Leadership development programs.
• Specialized training for the role.
• Learning experiences with internal and external providers.
• Recognition programs for seniority, behavior, leadership, and life moments.
• Financial wellness programs.
• Flexibility program to balance personal and work life.
• Family benefits including wellness line, agreements and discounts, scholarship programs, and aid plans.

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 workforce and innovation for the organization.