Overview:
**We Are PepsiCo**
Join PepsiCo and Dare for Better! 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.
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 more: PepsiCoJobs
Join PepsiCo, dare for better.
**Responsibilities**:
**The Opportunity**:
The Role of Commercial reporting Analyst has the objective of supporting the LAB 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 PMF, being able to document needs, manage themselves with setting appropriate activities.
**Your Impact**:
As Commercial Reporting Analyst your responsibilities 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
- Creating dynamics Dashboards and Reports at various levels of details using the PepsiCo standards reporting tools (e.g. Power BI, Teradata, Business Objects, MicroStrategy, etc
- 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
- 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?**
**Education**
- Business Administration, Engineer or Data & Analytics related field.
**Experience**
- Good understanding of Business analytics and reporting tools (Alteryx, Teradata, Denod, Power BI Servie, Azure)
- At least 2 years of experience using different source systems of data like Teradata, EDW, Flat files etc.
- ** Power BI is a must to have at least intermediate level**:
- English at least intermediate level
- Database Managment
- Knowledge of data governance models and Customer/Material hierarchies
- Proficient on creating dynamics Dashboards and Reports at various levels of details using the PepsiCo standards reporting tools (e.g. Power BI, Teradata, Business Objects, MicroStrategy, etc.)
**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.