Commercial Reporting 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. In PepsiCo Mexico is one of the most important consumer products 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 Role of Commercial reporting Analyst has the objective of supporting the LATAM business teams by creating, executing, and populating the information related to the commercial area with standards reports and BI tools.

Point of contact between the business and the technology teams as troubleshooting for any data or performance issues.

As the Commercial Reporting Analyst, it will be necessary to work through requirements gathering with functional teams of LATAM, being able to document needs, manage themselves with setting appropriate activities.  

 

Your Impact

 

As Analista Asoc de Des de Ventas Campo • Sales your functions would consist of:

·  Capable to analyze a request or issue and provide a solution either with existing reporting tools or by enhancing new functionalities.
·  Able to optimize process by leveraging best practices
·  Establish process to identify, track, escalate, resolve, and report customer problems
·  Ensure appropriate customer escalations and ticket assignment with different teams including sustain
·  Oversees on-boarding of new reports and services by training end user’s community
·  Participate in fine tuning activities to improve performance and/or ensure the SLA
·  Consistently attending meeting with the client subject matter expert to acquire functional business requirements.
·  Participate the continues improvements meeting
·  Responsible of Business Intelligence functional specs documents and the assessment of the project.
·  Execute reports according to SLAs (Service level agreement)
Qualifications

Who Are We Looking For?

·  Business Administration, Engineer or Data & Analytics related career
·  Good understanding of Business analytics and reporting tools (Power BI Desktop, Oracle, Nielsen Answers, Teradata, Power BI Service, etc.)
·  Expertise using different source systems of data like SAP/BW, Teradata, EDW, Flat files etc.
·  Intermediated or advanced skills on Microsoft Excel
·  Advanced skills on Power BI
·  Knowledge of data governance models and Customer/Material hierarchies
·  Proficient on creating dynamics Dashboards and Reports at different levels of details using the PepsiCo standards reporting tools (e.g. Power BI, Business Objects, MicroStrategy, etc.)
·  Intermediated or Avanced English

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.