Sales Asst Analyst

PepsiCo; Ciudad de México; On-site; MXN 420,000 - 640,000; Full time

Benefits offered by this job

Flexible schedule

Wellness program

Scholarship programs for children

Discounts and offers

Job summary

PepsiCo Inc. seeks a Perfect Store Jr. Analyst to support segmentation, rack census, and digital execution platforms across SOCO markets (Chile, Argentina, Uruguay, Paraguay).

You’ll transform data into actionable insights, validate information quality, and build Power BI dashboards to monitor progress and performance. The role requires strong analytical mindset, detail orientation, and cross-functional collaboration with Sales, DX, and market teams.

Qualifications

• Bachelor's degree in a related field.
• 1–2 years analytics, reporting, BI, sales ops, or commercial support experience.
• Experience with large datasets and reporting processes preferred.
• Basic–to–intermediate Power BI skills.
• Advanced Microsoft Excel knowledge.
• Experience with Salesforce, SAP, Forms, or Power Platform is a plus.
• Strong data management and data visualization practices.

Responsibilities

• Support segmentation and rack census initiatives across SOCO markets.
• Extract, consolidate, cleanse, and validate data from multiple sources.
• Develop and maintain Power BI dashboards for process progress and data quality.
• Generate recurring operational and performance reports for stakeholders.
• Perform QA and data validation to ensure accuracy and reliability.
• Monitor fieldwork progress and identify data gaps and risks.
• Provide insights to DX regional teams and local market stakeholders.
• Coordinate monthly updates of surveys for Chile and Argentina.
• Configure, test, and validate survey content before deployment.
• Track KPIs and support performance reviews for Perfect Store initiatives.
• Collaborate with Sales, Commercial Excellence, DX teams for alignment.
• Identify opportunities to automate reporting and improve data visualization.

Skills

Power BI, dashboards

Microsoft Excel

Data validation

Data analysis

Salesforce experience

SAP experience

Power Platform tools

Education

Bachelor's degree in Business Administration, Engineering, Data Analytics, Information Systems, Statistics, Economics, or related field

Tools

Salesforce

SAP

Excel

Power BI

Job description

Overview

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

As Sales Asst Analyst your functions would consist of…

• 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.