Sales Analytics Assistant (Power BI & Segmentation)

PepsiCo Inc.; 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

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.