Junior Sales Finance Analyst – FP&A & Insights

PepsiCo; Ciudad de México; Presencial; MXN 180.000 - 360.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Wellness programs

Flexible working arrangements

Learning & development programs

Recognition programs

Descripción de la vacante

PepsiCo in Mexico City is seeking a Sales Finance Associate Analyst to partner with the Canadian Beverages Sales Finance Team. You will deliver actionable financial analysis, support performance reporting, forecasting, and the Annual Operating Plan.

You will consolidate data from Mosaic, TPM, Power BI, and Excel and reconcile deductions to provide actionable insights. You will communicate results to Sales and Stakeholders, support continuous improvement, and ensure deliverables meet deadlines in

Formación

• 1+ years of experience in finance and planning.
• Experience in financial analysis, data integrity maintenance and ERP systems.
• Power BI knowledge.
• Strong Excel skills.
• Excellent communication skills; proficiency in English.
• Ability to work independently and manage multiple priorities.

Responsabilidades

• Prepare and update weekly sales results and performance presentations.
• Analyze volume, net revenue, and other key performance drivers.
• Maintain promotional and settlement files across LCL banners.
• Reconcile customer deductions by matching transactions with supporting promotional information.
• Perform periodic true-up reconciliations using scanned sales and promotional data.
• Consolidate information from Mosaic, TPM, Power BI and Excel.
• Validate data accuracy, investigate variances, and resolve reporting discrepancies.
• Communicate results, risks, pending items, and actionable insights to Sales and Stakeholders.
• Maintain clear process documentation and support continuous improvement initiatives.
• Complete recurring deliverables accurately and within established deadlines.

Conocimientos

Power BI

Excel

P&L management

Cross-functional collaboration

Financial analysis

ERP systems

English proficiency

Herramientas

Mosaic

TPM

Descripción del empleo

PepsiCo in Mexico City is seeking a Sales Finance Associate Analyst to partner with the Canadian Beverages Sales Finance Team. You will deliver actionable financial analysis, support performance reporting, forecasting, and the Annual Operating Plan.

You will consolidate data from Mosaic, TPM, Power BI, and Excel and reconcile deductions to provide actionable insights. You will communicate results to Sales and Stakeholders, support continuous improvement, and ensure deliverables meet deadlines in