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 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
PepsiCo strategy include focused efforts to digitalize the company and build capabilities across the company. These capabilities are: Innovate/Market, Plan, Make, Sell and Deliver.
Inside the Plan capability, one of the main enablers is Mosaic Planning, for becoming more capable, more agile and more efficient. Mosaic is a global, integrated, and predictive planning tool aligned to the FP&A module of PepsiCo’s Global Template that is currently operating in certain OUs (Europe, AMESA, APAC and North America) and will be rolled-out across every Sector.
This role will ensure the continuous stability, correction, and enhancement/programming of the Mosaic tools, , and processes (IBM Planning analytics & Alteryx). The person should be able to support or have experience with the writing, modifying, and testing code and scripts that allow Mosaic system to function properly. The coordinator will interact with PepsiCo Beverages North America, PepsiCo Foods North America & PepsiCo Foods Mexico end-users of Mosaic daily, guiding and helping them conduct planning activities on Mosaic; and ensuring Mosaic system is upgraded accordingly business needs.
Your Impact
As Finance FP - MOSAIC Finance Analyst your responsibilities would consist of:
Support core planning processes (Month-end closing, forecast, budget, etc.) through data collection, verification, and processing, to ensure timely submission to GBS and Sector, looking for automation, digitalization and streamlining of current processes.- Partner with Finance and Non-Finance stakeholders (Sales Finance, Supply Chain Finance, FP&A, Control, etc.) guiding them to ensuring a robust and working solution across PBNA, PMF & PFNA.
- Act as Subject Matter Expert on any topic related to Mosaic – first line of defense in front of end-users.
- Identifies issues and define action plans in response to findings and ensure timely resolution – Escalate issues if needed.
- Deliver training to end-users (population ranging from L8 to LG2)
- Manage IT/consulting houses to get the required fixes in the solution, test the system and drive enhancement.
- Ensure the continuous stability, correction, and enhancement/programming of the Mosaic tools, and processes.
- Support or have experience with the writing, modifying, and testing code and scripts that allow Mosaic system to function properly.
Qualifications:
Who Are We Looking For?
Experience
At least 2 or 3 + of experience in Food & Beverage industry or massive consumption market "CPG" and Consulting.- Minimum of 3 to 5 years' experience operating in a data analyst or business data analyst or business intelligence or business architect role.
- 100% English language proficiency both oral and written.
- Build Data Definition Language (DDL) constructs iteratively based on feedback from data engineers and evolving business requirements.
- Proficiency with Mosaic Tech, IBM Planning or TM1 Tool is a nice to have.
- Proficiency with Microsoft Excel (Excel, Power Point, etc.) is a must.
- Knowledge of systems (SAP, HFM, Alteryx, Power BI, Teradata, Oracle, SQL Server, DB2, Azure Data Lake, Hive, Presto, Synapse, Python, R, Trifacta, Alteryx, Azure Data Factory) Nice to have.
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.
