Data & Analytics 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  

 

·  As a Data & Analytics analyst you will act as key contributor to the department’s reporting and analytics strategy. You will be responsible for working closely with IBP Demand planning and statistical modeling leads to transform reporting requirements into fully thought-out technical data implementations using various reporting platforms and tools. The role will require working in accordance with PBNA data standards and MRAs Self service reporting framework.
·  This position requires a person with a strong understanding of DSD IBP, and Supply Chain as well as good interpersonal skills. The candidate should also be able to navigate a technical environment for non-technical business partners.

 

Your Impact 

 

As Data & Analytics Analyst your responsibilities would consist of

 

·  Own existing Self service reporting within Tableau and Power BI. This includes
·  Managing SLAs, and data quality for business users
·  Enhancing existing dashboards  
·  ​Maintaining and updating front end logic 
·  ​Lead End User Training 
·  Work with data providers to trouble shoot data delays and data quality issues.
·  Partner with IBP Demand planning, Forecasting analytics, and Process Leads to develop new analytical reporting within Power BI, Tableau, and SAC to support the entire IBP Process
·  Convert legacy Tableau reporting to Power BI and newer platforms
·  Work in accordance with PBNA data standards and MRAs Self service reporting framework.
·  Partner with PBNA D&A and SC E2E Analytics Engineering team to ensure data pipelines and data models are set up to enable reporting
·  Own SQL and DAX logic used with in reporting tools
·  ​Own KPIs and metrics used for IBP 
Qualifications

Who Are We Looking For?  

 

·  Fluent in English is a must
·  ​​Bachelor's degree required; concentration in Supply Chain, Statistics, Engineering, Economics or Business preferred
·  ​2-3 years professional experience in Analytics (Data management, Data Analytics)
·  Advanced understanding of Power BI and Tableau visualization tools (must)
·  ​Beginner to intermediate SQL programming capabilities, comfortable reading SQL code and writing basic queries (must) 
·  ​Proven interest in Data Science and Statistical Forecasting
·  ​Familiar with the concepts of Demand planning and Supply chain
·  ​High proficiency with MS Office products particularly Excel, PowerPoint and Outlook
·  ​Strong interpersonal skills, ability to influence others​
·  Demonstrated ability to leveraging system and tools

 

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.