Commercial Reporting Sr Analyst

Overview:**We Are PepsiCo**Join PepsiCo and Dare for BetterWe 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 GCC Commercial Reporting Analyst is supporting the PBNA 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, being able to document needs, manage themselves in setting appropriate activities.**Your Impact**:As **Commercial Reporting Sr Analyst** **your responsibilities would consist:- Capable to analyze a request or issue and provide a solution either with existing reporting tools or by enhancing new functionalities- Role will leverage PowerBI data and update reporting on weekly basis- Own Risk Assessment Dashboard, which includes pulling data, refreshing dashboard, and ensuring data quality on a weekly basis- Refreshes data for monthly updating of Perfect Store Dashboard- Establish process to identify, track, escalate, resolve, and report customer problems- Participate in weekly Commercial Team meeting if/as needed- Responsible of Business Intelligence functional specs documents and the assessment of the projectQualifications:**Who Are We Looking For?****Education**- Business Administration, Engineer or Data & Analytics related career**Experience**- Fluent English- Advanced Excel knowledge- 1-2 years of data management experience- Knowledge of data governance models and Customer/Material hierarchies- Proficient in creating dynamics Dashboards and Reports at various levels of details**Skills**- Cross-Functional point of contact- Attention to detail and strong follow-through skills- Must be collaborative team player- Proficient oral and written communication skills- Organizational skills, and service oriented**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.