TM1 Finance Support Analyst

PepsiCo; Ciudad de México; Presencial; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A global food and beverage company in Ciudad de México is seeking a TM1 Finance Support Analyst to support planning processes and enhance tools. Responsibilities include partnering with stakeholders, providing expert support, and delivering training. Ideal candidates will have strong analytical skills and experience with IBM Planning Analytics or TM1 tools. The role offers opportunities for professional development and a focus on work-life balance.

Servicios

Opportunities for learning and development

Financial wellness programs

Flexibility program for work-life balance

Formación

• Minimum of 3 years in data analyst, business data analyst, business intelligence or business architect roles.
• Ability to build and refine DDL constructs adapting to business requirements.
• Solid understanding of enterprise systems.

Responsabilidades

• Support core planning processes through data collection and processing.
• Partner with Finance and Non-Finance stakeholders for effective solutions.
• Act as a Subject Matter Expert for Mosaic-related topics.
• Deliver training to end-users.

Conocimientos

Advanced English

Data Definition Language (DDL)

IBM Planning Analytics or TM1 tools

Microsoft Office applications

Analytical tools

ERP / Financial Systems (SAP, HFM)

Data & Analytics Tools (Alteryx, Power BI)

Programming Languages (Python, R)

Descripción del empleo

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

Join the Digital Planning team and play a key role in ensuring the continuous stability, optimization, and enhancement of the Mosaic tools and processes (IBM Planning Analytics & Alteryx). The ideal candidate will support—or have experience in—writing, modifying, and testing code and scripts that enable the Mosaic system to function effectively. The Coordinator will interact daily with PepsiCo Beverages North America end-users, providing guidance and assistance during planning activities and ensuring the Mosaic system evolves in line with business needs.

Your Impact

As a TM1 Finance Support Analyst, your main responsibilities will include:

• Supporting core planning processes (month-end close, forecasting, budgeting, etc.) through data collection, verification, and processing to ensure timely submissions to GBS and the Sector, while driving automation, digitalization, and process efficiency.
• Partnering with Finance and Non-Finance stakeholders (Sales Finance, Supply Chain Finance, FP&A, Control, etc.) to ensure robust and effective solutions across PBNA.
• Acting as a Subject Matter Expert (SME) for all Mosaic-related topics — serving as the first line of support for end-users.
• Identifying and resolving issues
• Delivering training to end-users (ranging from L8 to LG2 levels).
• Managing IT and consulting vendors to obtain necessary fixes, test system updates, and drive enhancements.
• Ensuring the continuous stability, correction, and enhancement of Mosaic tools and processes.
• Supporting and maintaining code and script development, including writing, modifying, and testing to ensure optimal Mosaic system performance.

Qualifications

Who Are We Looking For?

Experience

• Minimum of 3 years operating in a data analyst, business data analyst or business intelligence, or business architect role.
• Advanced English
• Ability to build and refine Data Definition Language (DDL) constructs iteratively, incorporating feedback from data engineers and adapting to evolving business requirements.
• Proficiency in IBM Planning Analytics or TM1 tools.
• Advanced proficiency in Microsoft Office applications, particularly Excel and PowerPoint.
• Solid understanding and hands‑on experience with enterprise systems and analytical tools such as:

• ERP / Financial Systems: SAP, HFM
• Data & Analytics Tools: Alteryx, Power BI, Trifacta, Azure Data Factory
• Databases: Teradata, Oracle, SQL Server, DB2
• Cloud & Big Data Platforms: Azure Data Lake, Hive, Presto, Synapse
• Programming Languages: Python, R

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.

Equal Opportunity Statement

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 workforce and innovation for the organization.