Business Intelligence Analyst

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.

The Opportunity

We are seeking a Business Intelligence Analyst to support data-driven decision-making by developing reports, dashboards, and insights that drive business performance. This role involves working with large datasets, building visualizations, and collaborating with stakeholders to optimize reporting processes. The ideal candidate has strong analytical skills, proficiency in Power BI and Excel, and the ability to translate data into actionable insights.

Your Impact

As Business Intelligence Analyst your responsibilities would consist of:

• Work collaboratively across the Digital Product & Applications team along with key business partners in S&T (finance, vendor management, etc.)
• Analyze large datasets, identify trends, and create meaningful visualizations using Power BI and Excel to support business strategies.
• Build and maintain interactive dashboards and automated reports, ensuring accurate and timely data presentation.
• Work closely with business leaders, finance teams, and other departments to understand reporting needs and provide insights.
• Develop dynamic reports using advanced Excel functions (VLOOKUP, SUMIFS, PivotTables, Power Query) to support financial and operational analysis.
• Create dashboards with DAX calculations, data modeling, and interactive filtering to enhance business insights.
• Identify opportunities for automation and optimization of reporting workflows, ensuring efficiency and accuracy.
• Use SQL to extract, clean, and manipulate data from various sources for reporting and analysis.
• Leverage Power Automate to automate reporting processes and integrate data across applications.

Who Are We Looking For?

Experience required:

• Bachelor’s degree required
• Minimum 1-3 years of relevant experience either internally or with a Top-Tier consulting firm
• Proficiency in Power BI: Ability to develop complex reports and dashboards, including DAX calculations and data modeling.
• Advanced Excel Skills: Expertise in Excel formulas (including VLOOKUP, SUMIFS, etc.) and experience with Power Query for data transformation and modeling.
• SharePoint Knowledge: Experience in configuring SharePoint sites, lists, libraries, and workflows.
• Automation Skills: Familiarity with Power Automate (formerly Microsoft Flow) for workflow automation and integration across different applications.
• SQL Proficiency: Strong SQL skills for querying databases, performing data manipulation, and basic database administration tasks.
• Coding Abilities: Ability to write and optimize SQL queries and scripts for data extraction, transformation, and loading (ETL).
• The candidate selected for this position will be a self-motivated, high-energy individual who can easily function in a high demand, performance-driven environment. He/she must be accustomed to working on multiple tasks in parallel.
• This professional must be analytical and persuasive in their relationships and be able to gain and hold the respect of key stakeholders within the company.
• Problem-solving Orientation: Proven ability to troubleshoot issues, propose solutions, and implement enhancements to improve data quality and reporting efficiency.
• Communication Skills: Strong verbal and written communication skills with the ability to interact effectively with stakeholders across different levels of the organization.
• Team Collaboration: Experience working in cross-functional teams and collaborating with business analysts, developers, and other stakeholders to deliver solutions that meet business needs.
• Business Case Solutioning: Experience in understanding business requirements and translating them into technical solutions, including developing business cases and recommendations.
• Data Analysis and Visualization: Skills in analyzing large datasets, identifying trends, and presenting insights effectively using tools like Power BI and Excel.

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.