This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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.
Job Responsibility:
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
Requirements:
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 Microsoft Excel (Excel, Power Point, etc.) is a must
Nice to have:
Proficiency with Mosaic Tech, IBM Planning or TM1 Tool is a nice to have
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
What we offer:
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