Commercial Planning Master Data Analyst

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

Job summary

PepsiCo is seeking a Commercial Planning Master Data Analyst to collaborate with R&D, Marketing, Finance, and PMO to ensure business proposals align with PepsiCo's commercial strategy. The role focuses on product master data decisions, UPC management, and accurate data feeding over 200 downstream systems affecting Demand Planning, Operations, Sales, and Finance.

You will handle a mix of higher complexity brands and customers, completing an estimated 100-150 Business Proposals per year,

Qualifications

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

Responsibilities

• Ensure Flawless Execution of Business Proposals into Sales & Supply Chain Systems.
• 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.
• 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

Skills

Fluent English

Education

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

Tools

Excel

Power BI

SAP

Oracle

Job description

PepsiCo is seeking a Commercial Planning Master Data Analyst to collaborate with R&D, Marketing, Finance, and PMO to ensure business proposals align with PepsiCo's commercial strategy. The role focuses on product master data decisions, UPC management, and accurate data feeding over 200 downstream systems affecting Demand Planning, Operations, Sales, and Finance.

You will handle a mix of higher complexity brands and customers, completing an estimated 100-150 Business Proposals per year,