Sales Asst Analyst

PepsiCo Inc.; Colonia Tajín; On-site; MXN 420,000 - 620,000; Full time

Job summary

PepsiCo Inc. is seeking a Junior Perfect Store Analyst to support segmentation, data collection, and dashboard development across our SOCO markets. You will work with multiple data sources and help drive data-driven decisions for pantry and store execution.

The role emphasizes analytical thinking, attention to detail, and collaboration with Sales, DX, and regional teams to improve reporting processes and platform performance.

Qualifications

• 1-2 years of analytics, reporting, BI or sales ops experience.
• Basic to intermediate Power BI skills.
• Advanced Excel knowledge.
• Experience with Salesforce, SAP or similar apps is a plus.

Responsibilities

• Support annual Segmentation and Rack Census initiatives across SOCO markets.
• Extract, consolidate, cleanse, and validate data from multiple sources.
• Develop and maintain Power BI dashboards to monitor progress and data quality.
• Generate recurring reports for regional and local stakeholders.

Skills

Power BI

Excel

Salesforce

SAP

Education

Bachelor's degree

Tools

Power Platform

Job description

Overview

CAREERS TO SMILE ABOUT

At PepsiCo, you’ll discover a place where our mission is to create smiles around the world. With a portfolio of more than 500 beloved brands including, Gatorade, Lay’s and Quaker, our work touches millions of people every day.

At the heart of the company is a team of thinkers, creators, and problem-solvers who collaborate to innovate and turn ideas into action. Driven by innovation and a focus on creating joyful moments through food and drinks, our decisions are guided by consumer centricity, creating opportunities for our associates to do meaningful work and make a lasting impact in the communities we serve.

Whatever your role, you’ll be part of a global community that values your ideas and empowers you to make an impact, on your career and on the world around you.

Responsibilities

The Opportunity

The Perfect Store Jr. Analyst supports the execution, monitoring, and continuous improvement of key Perfect Store capabilities across the SOCO region (Chile, Argentina, Uruguay, and Paraguay).

This role is responsible for supporting the annual Segmentation and Rack Census processes by managing data collection activities, validating information quality, transforming data into actionable insights, and developing analytical dashboards that provide visibility into project progress and performance. The position also supports the maintenance and administration of digital execution platforms used to measure Perfect Store compliance across multiple channels and markets.

The role requires a strong analytical mindset, attention to detail, and the ability to collaborate with cross-functional teams.

Your Impact

• Support the execution of annual Segmentation and Rack Census initiatives across SOCO markets.
• Extract, consolidate, cleanse, and validate data from multiple sources including Salesforce, SAP, Excel, and other business platforms.
• Develop, maintain, and enhance Power BI dashboards to monitor process progress, census completion rates, data quality, and project performance.
• Generate recurring operational and performance reports for regional and local stakeholders.
• Perform quality assurance and data validation activities to ensure accuracy, consistency, and reliability of reported information.
• Monitor segmentation fieldwork progress and proactively identify data gaps, risks, and improvement opportunities.
• Support DX regional teams by providing analytical insights and performance visibility throughout segmentation projects.
• Manage and maintain digital execution platforms used to measure Perfect Store compliance and execution standards.
• Coordinate monthly updates of Perfect Store surveys for Traditional Trade and Other Trade channels in Chile and Argentina
• Configure, test, and validate survey content before deployment to local execution platforms.
• Track execution KPIs and support performance reviews related to Perfect Store implementation and adoption.
• Collaborate with Sales, Commercial Excellence, DX teams, and local market stakeholders to ensure alignment and timely delivery of initiatives.
• Identify opportunities to automate reporting, improve processes, and enhance data visualization capabilities.

Qualifications

Who Are We Looking For?

• Bachelor's degree in Business Administration, Engineering, Data Analytics, Information Systems, Statistics, Economics, or a related field.
• 1-2 years of experience in analytics, reporting, business intelligence, sales operations, or commercial support functions.
• Experience working with large datasets and business reporting processes is preferred.
• Basic to Intermediate Power BI skills.
• Advanced Microsoft Excel knowledge.
• Desired experience working with Salesforce, SAP, Forms, Power Platform tools, or similar business applications.
• Strong data management, data validation, and reporting capabilities.Understanding of business intelligence and data visualization best practices.
• Ability to work with multiple data sources and transform information into actionable insights.

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.