Data 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

The role is primarily to act as an internal consultant, driving continuous improvement and efficiency across the entire financial planning function landscape. This role ensures that financial processes are standardized, streamlined, and leverage the latest technology to deliver accurate, timely, and actionable financial insights across various markets and business units. The Process Excellence Analyst focuses on optimizing the how and what of financial planning, moving beyond just reporting the numbers.

Your Impact

As Process Excellence Analyst your responsibilities would consist of:

1. Process Optimization and Re-engineering
a) Identify Inefficiencies: Map out current, end-to-end financial processes (e.g., Annual Operating Plan (AOP), quarterly forecasting, month-end close, performance reporting) to identify bottlenecks, non-value-added steps, and opportunities for simplification.
b) Implement Methodologies: Apply continuous improvement methodologies like Lean (minimizing waste) and Six Sigma (reducing variability/defects) to redesign and re-engineer critical financial workflows.
c) Standardization: Drive the standardization of financial processes, reports, and ways of working (WoW) across different countries, regions, or business units to ensure consistency and facilitate global comparisons.

2. Digitalization and Automation
a) Technology Enablement: Select, test, and implement financial systems and tools (Financial Planning Models in excel, Power BI Dashboards, Python, Power Apps, Power Automate, Power Query, Macros etc).
b) Hyper-Automation: Identify tasks ripe for automation, particularly in repetitive areas like data collection, report generation, and reconciliations, leveraging technologies like Robotic Process Automation (RPA) and Gen AI.
c) Data Integrity: Maintain and monitor data linkages, master data mappings, and system logic to ensure the accuracy and integrity of financial data flowing between various systems.

3. Analytics and Insight Generation
a) Process Analytics: Leverage on advanced tools like Process Mining (e.g., Celonis) to analyze event logs from financial systems, providing data-driven insights into process performance and variation.
b) Performance Metrics: Establish and monitor Key Performance Indicators (KPIs) for financial processes (e.g., cycle time, accuracy rate, cost per transaction) to measure the success of excellence initiatives.
c) Stakeholder Storytelling: Present data-driven findings and proposed solutions to senior leadership and cross-functional partners using compelling visual representations and clear business cases.

Who Are We Looking For?

Education

Industrial Engineering, Finance or Accounting, Economics, Business Administration

Experience

1. Experience:
Business Process Improvement/Re-engineering, Management Consulting (Finance transformation projects), Finance, Global Business Services (GBS) or Shared Services environment is a strong plus.

2. Technical & Systems Skills:
Process Methodology: Lean (Value Stream Mapping, Kaizen) and Six Sigma (DMAIC) methodologies.
Financial Systems: Advanced knowledge and hands-on experience with major ERP and financial planning systems (e.g., SAP FI/CO, Hyperion Financial Management (HFM), SAP Business Planning and Consolidation (BPC), or TM1/Cognos).
Data Analytics: Proficiency in SQL (to query large datasets), advanced Microsoft Excel (including Power Query/VBA), and strong experience with Data Visualization/BI tools (e.g., Power BI or Tableau).
Automation: Exposure to or direct experience with Robotic Process Automation (RPA) tools (e.g., UiPath, Automation Anywhere) and Power Automation
Power Apps
Python

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.