Commercial Planning Data Analyst

PepsiCo; Ciudad de México; On-site; MXN 360,000 - 540,000; Full time

Benefits offered by this job

Learning platforms and development

Career development programs

Recognition programs for achievement

Financial wellness resources

Flexible work options and family-benef

Job summary

PepsiCo is seeking a Commercial Planning Master Data Analyst to support BP data and master data accuracy across systems. You will work with R&D, Marketing, Finance and PMO to ensure proposals align with PepsiCo strategy.

You will manage UPC creation, pricing attributes, and data integrity feeding 200+ downstream systems. This role emphasizes analytics, cross-functional collaboration, and rigorous execution in a fast-paced environment.

Qualifications

• Bachelor’s degree in Business, Supply Chain, Engineering, Business Analytics or similar field required.
• Fluent English written and verbal skills required.
• 0-2 years of professional experience in Commercialization, Master Data with analytical/project-based experience required.
• Intermediate to Advanced Excel skills for data extracts, analysis and reporting required.
• Working knowledge of Power BI, SAP, Oracle is preferred.
• Ability to manage time-sensitive projects with minimum guidance.
• Detail and results oriented with strong execution skills.
• Adaptive in an agile environment with frequent changes.
• Strong verbal and written communication across levels.
• Shows ability to influence and collaborate in cross-functional teams.

Responsibilities

• Ensure Flawless Execution of Business Proposals into Sales & Supply Chain Systems.
• Provide analytical expertise on product master data to support each BP idea.
• Identify when to create new UPCs and manage price areas and packaging attributes.
• Maintain data integrity through clean-up.
• Oversee Code Verification process to ensure quality.
• Own the Packaging Graphics Requisition process and UPC management.
• Prioritize tasks to meet in-store dates and collaborate with cross-functional partners.
• Collaborate with cross-functional teams to review BP needs and obtain regional participation in launches.

Skills

Fluent English

Task prioritization

Cross-functional collaboration

Detail oriented

Adaptability

Strong execution

Education

Bachelor’s degree in Business, Supply Chain, Engineering, Business Analytics or similar field

Tools

Power BI

Excel

SAP

Oracle

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

TheOpportunity

The Commercial Planning Master Data Analyst, who has daily interactions with vertical and cross-functional teams such as R&D, Marketing, Finance and PMO to ensure Business Proposals meet expectations according to customer and PepsiCo commercial strategy.

The primary accountabilities relate to product master data decisions by understanding the critical details of the Business Proposal needs, ensuring quality of deliverables as the information flows directly to different systems across PepsiCo.

The Commercial Planning Master Data Analyst will have an assigned mix of higher complexity brands / customers / channels to support and will complete an estimated 100-150 Business Proposals per year. Master Data accuracy is essential, as it feeds over 200 downstream systems, impacting Demand Planning, Operations, Sales and Financial transactions.

YourImpact

As Commercial Planning Data Analyst your functions would consist of:

Ensure Flawless Execution of Business Proposals into Sales & Supply Chain Systems.

IDEA CONTEXT:

• Determine if the Business Proposal (BP) request is clear.
• Identify missing details required to define timelines or assess master data needs.
• Work proactively with Cross Functional teams to close gaps through identification and iterations of process improvements in continuous team learning.

MASTER DATA:

• Provide analytical expertise and decision making on product master data required to support each Business Proposal idea. This includes identifying when to create new UPCs (SKUs) and internal product codes, managing price areas, tying to correct packaging / case pack / code date attribute data and maintaining data integrity through clean-up.
• Responsible for Code Verification process to ensure quality.

PACKAGING SUPPORT:

• Own the Packaging Graphics Requisition process to capture all non-design attributes, including UPC management, brandmark routing, cross functional spec and regulatory input, and oversight of schedule hand-off to Packaging Pre-Press Vendor.

EFFICIENCY:

Ensure completion of assigned tasks on schedule. Task Prioritization to ensure schedule in-store date is met. Attend task force with Cross Functional Partners to remove obstacles, raise concerns and follow ups. Identify and provide solutions on how to make processes more productive.

COLLABORATION:

• Assist with reviewing for BP needs across teams to support timely approval.
• Reach out for specific region/zone participation in innovation launch programs to identify unique product code/pricing needs.

Qualifications

WhoAreWeLookingFor?

Education

• Minimum Bachelor’s Degree in Business, Supply Chain, Engineering, Business Analytics or similar field required.

Experience

- Fluent English written and verbal skills required.

- 0-2 years of professional experience in Commercialization, Master Data with demonstrated experience in an analytical and/or project based role required

- Intermediate to Advance Excel skills for data extracts, analysis and reporting required

- Working knowledge of PowerBi, SAP, Oracle is preferred

- Task Prioritization by effectively managing time-sensitive projects and competing priorities with minimum guidance

- Must be detail and results oriented with strong execution skills

- Possess adaptive style to navigate in an agile environment with frequent change

- Strong verbal and written communication skills to effectively interact across levels

- Shows a strong ability to influence and collaborate in a cross functional team environment

What can you expect from us:

• Opportunitiestolearnanddevelopeverydaythroughawiderangeofprograms.
• Internaldigitalplatformsthatpromoteself-learning.
• DevelopmentprogramsaccordingtoLeadershipskills.
• Specializedtrainingaccordingtotherole.
• Learningexperienceswithinternalandexternalproviders.
• Welovetocelebratesuccess,whichiswhywehaverecognitionprogramsforseniority,behavior,leadership,momentsoflife,amongothers.
• Financialwellnessprogramsthatwillhelpyoureachyourgoalsinallstagesoflife.
• Aflexibilityprogramthatwillallowyoutobalanceyourpersonalandworklife,adaptingyourworkingdaytoyourlifestyle.
• Andbecauseyourfamilyisalsoimportanttous,theycanalsoenjoybenefitssuchasourWellnessLine,thousandsofAgreementsandDiscounts,Scholarshipprogramsforyourchildren,AidPlansfordifferentmomentsoflife,amongothers.

Weareanequalopportunityemployerandvaluediversityatourcompany.Wedonotdiscriminatebasedonrace,religion,color,nationalorigin,gender,sexualorientation,age,maritalstatus,veteranstatus,ordisabilitystatus.Werespectandvaluediversityasaworkforceandinnovationfortheorganization.