BI Data and Visualization Analyst

At PepsiCo, you’ll discover a place where our mission is to create smiles around the world. With a portfolio of more than 500 beloved brands including, Gatorade, Lay’s and Quaker, our work touches millions of people every day. 

At the heart of the company is a team of thinkers, creators, and problem-solvers who collaborate to innovate and turn ideas into action. Driven by innovation and a focus on creating joyful moments through food and drinks, our decisions are guided by consumer centricity, creating opportunities for our associates to do meaningful work and make a lasting impact in the communities we serve. 

Whatever your role, you’ll be part of a global community that values your ideas and empowers you to make an impact, on your career and on the world around you. 

This position is requested as a backfill to support the increasing volume of business demands from senior leaders that the current team is unable to address within expected timelines for LATAM Team (16 LATAM BU including Mexico & Brazil).

The role will be responsible for delivering and supporting reporting and analytics solutions using Power BI, Power Automate, and Power Apps, as well as partnering with business and IT stakeholders to gather requirements, coordinate testing, and ensure successful solution delivery within Supply Chain Team (Make, Move, Customer Service, Quality, Maintenance, etc.).

In addition, strong expertise in SAP BW and SAP BusinessObjects is critical, as these platforms continue to support key reporting and analytics processes across the organization. The resource will play a key role in maintaining service continuity, supporting ongoing SAP-related initiatives, and reducing the current delivery backlog and future projects.

Please help with below details for the role:

1.Please provide Expertise Level from the following (Medium/ Medium-High/ High): High.

2.Does this role having responsibilities of managing complex projects? (Eg. – Low Complexity/Intermediate/Moderate Complexity/High Complexity): Moderate Complexity and High Complexity.

3.Innovative Thinking - Please select any options from the following (Leverage & enhance existing technologies/Minor creations or deeper enhancements to tech/Creates and designs new technologies): Leverage & enhance existing technologies or Minor creations or deeper enhancements to tech. It is depend of the project.

4.Level of supervision required from direct manager – (Moderate supervision / Moderate level of decision-making autonomy)/(Low supervision / High level of decision-making autonomy): Moderate level of decision-making autonomy.

5.Does this role is responsible of working on projects which are having “critical impact” to the organization or “moderate” OR” significant” impact?: Significant Impact.

6.Does this role “support the project” or “leads a stream within the project” or “leads the full project”?: Support the project or Leads a stream within the project.

7.How many users are impacted by the work of this role (typically 3,000+ 5000+ etc.). How many reports and dashboards and platforms and programs managed by the proposed role. This role has been working on more than 15 dashboards connected to Oracle Database, SharePoint and Excel files and automated with Microsoft Power Automate and Power Apps. These dashboards were created to L09/L10/L11/LG1/LG2/LG3/LG4/LG5/LG6 (+1000 users).

8. Please confirm if this role manages Vendor, Third Party, Suppliers etc. If Yes, Please help us with the complexity of the vendor Management (Low, Medium, High): No, It is not.

9. How many users are impacted by the reporting manger, how many reports and dashboards and platforms and programs managed by the reporting manager role? This role has been working on more than 15 dashboards connected to Oracle Database, SharePoint and Excel files and automated with Microsoft Power Automate and Power Apps. These dashboards were created to L09/L10/L11/LG1/LG2/LG3/LG4/LG5/LG6 (+1000 users).

As Transformation Sr Analyst your responsibilities would consist of:

Reporting

• Support business requirements gathering, user testing (UAT), production deployments, and issue resolution.
• Performs dashboards and reports in Microsoft Power BI connected to different datasource (Oracle database, Databricks, Excel files, Flat files, etc.).
• Automation the data extraction and data loads with tools like Microsoft Power Automate.
• Responsible for daily monitoring of data loads and system performance.
• Coordinate sessions with the business teams, stakeholders and IT Teams to align requirements, follow up, testing and capacitation.

Identify new technologies and tools to bring support for business needs.

Apps

• Create customized tools and applications when required to handle specific reporting needs for business.
• Creates and maintains efficient and secure systems for processing and recording data and producing relevant documentation.
• Works with IT Team and Process Excellence Team to coordinate and raise system requirements necessaries to develop reporting and dashboards.

Education/Requirements

• Background in computer science preferred.
• 2-5 years of performance SAP BW.
• 2-5 years of performance measurement and/or reporting experience preferred.
• 100% fluent in English and Spanish (Written & Verbal skills).
• Advanced knowledge in SAP BW, Databricks, Microsoft Power Platforms (Power BI, Power Apps, Power Automate), Microsoft Office365 (Excel, Power Point, Word).
• Experience in computer database management preferred.

Competencies/Requirements

• Excellent interpersonal skills and ability to work directly with internal management
• Analytical Skills
• Action Oriented and Data-Driven
• Team player and highly collaborative
• Untouchable integrity and ethics
• Functional & Technical expertise to provide solutions
• Attention to detail and highly organized, ability to work independently to meet deadlines
• Excellent follow-up abilities
• Must be knowledgeable with performance analysis tasks and can work independently in handling equipment and system issues

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

• 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.