Commercial Planning Master Data Analyst

Job description

Overview

We Are PepsiCo  

 

Join PepsiCo and dare to transform! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place. 

 

Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries. PepsiCo Mexico is one of the most significant consumer product companies in the country. Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years. 

 

A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world. 

 

Know a little more: PepsiCoJobs  

Join PepsiCo, dare to transform. 

 

Responsibilities

The Opportunity  

 

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.

 

Your Impact 

 

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.

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

Who Are We Looking For?  

 

- 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 

 

 

If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements. 

 

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.