Skip to main contentA logo with &quat;the muse&quat; in dark blue text.
Constellation Brands

Analyst, Senior Financial Planning & Analysis

Mexico City, Mexico

Job Description

Ciudad de Mexico

Nivel de Estudios

Bachelor's Degree in finance, accounting, economics or business preferred

Idioma

Inglés Avanzado

Experiencia Requerida

5 años

Habilidades

Habilidades

Self-driven and results oriented individual who excels in a dynamic environment, strong communications skills, both written and verbal; proven analytical skills, attention to details, and a solid knowledge of key finance and accounting concepts, aptitude to set priorities while managing multiple tasks, as well as proficiency for follow-up. Individual who can take a project from inception to completion without extensive supervision is ideally suited to this position. Strong presentation skills and ability to communicate clearly to all levels in the organization including a broad base of finance and business partners.

Want more jobs like this?

Get Software Engineering jobs in Mexico City, Mexico delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


Habilidades Técnicas

SAP required / Excel Macros required/ PowerPoint proficiency

Resumen

Forecasting and reporting for all the expenses incurred by the Mexico City office, San Antonio office, and Luxembourg office. Provide financial information & analysis to the Beer Operations & the FP&A departments. Propose office-wide savings initiatives. Implement SmartSpend to ensure all spending follows corporate policies. Assist with vendor and invoicing approval for the Mexico office. Coordinate Billings/Depletion/Shipment analysis and its impact on the P&L.

Responsabilidades

Planning and Forecasting

Coordinate and prepare the Annual Plan/Latest Estimates for G&A Mexico, San Antonio, and Luxembourg offices; Statutory and Management. Inputs will be received from all business partners (HR, Breweries, FSS, Tax, FP&A, and Treasury).

Prepare consolidated spend per case for the support offices. o Coordinate the completion of the Strategic (Long-Range) Plan for the support offices.

Prepare periodic forecasts (Monthly, Quarterly, etc.) for the support offices.

Analyze plan/forecast figures and prepare monthly bridges/waterfalls vs PY/prior forecasts for the main P&L drivers (headcount, merit, travel & expenses, spend, STI,etc.) & by business unit (Engineering, Procurement, etc.) for the support offices.

Obtain/prepare the necessary back up schedules to support the analysis. o Prepare a constant currency analysis to evaluate the impact of FX rate in the results for the support offices.

Model the spending and variances to present a COGS segment view of the main drivers/variances (taking profit in inventory into account) for the support offices.

Obtain/prepare Profit & Loss Financials by entity and Ledger for all the related accounts for the support offices.

Responsible to load and reconcile the information in the Planning Application by detail (account, entity, business unit, currency, etc.) for the support offices.

Identify and communicate potential risks and opportunities to the business for the support offices.

Tax structure planning- model all intercompany COGS & sales relationships determined by the tax team. Ensure all activity is eliminated and the proper markups are established for the support offices.

Monthly Reporting & Analysis O Obtain/prepare detailed monthly variance analysis of Actuals vs LE/PF, Plan, PY for the main P&L drivers (headcount, merit, travel & expenses, spend, STI, etc.) of the Segment in a MTD, QTD and YTD view for the support offices.

Prepare a Constant Currency analysis to evaluate the impact of FX rate in the results in every bridge for the support offices.

Prepare benchmark analysis between corporate offices & identify areas of opportunity.

Elaborate graphics and waterfalls to explain the main variances in the monthly management deck for the support offices.

Lead monthly meeting with VP heads of the business unit to track problem spend areas for the support offices.

Ad Hoc Analysis as required. 3 Initiatives

Tracks and consolidates savings initiatives and its progress by area of responsibility for more informed decision making & accountability.

Designs, proposes, and tracks policies to align corporate needs to spending strategies and requests.

Office Expenses Approval & Recording o Ensures office expenses are following Company policies- travel expenses, AMEX, auto.

Records expenses in Concur in a timely manner.

Bilings/Shipments/Depletions tracking o Track monthly variances versus forecasts.

Meet with all stakeholders to calculate & determine the financial impact that these variances are having on our bottom line.

This initiative will push the Company to have a more accurate forecast. 6 Finance Business Partner for the support function

Acts as a liaison between Finance & all divisions in regards to support expenses- Legal, External Affairs, Communications, Tax, Capital Programs, Operations, HR, Controlling, Project Management, Logistics, etc.

Meet with VPs from all divisions to support expense approval, projects & analysis.

Location
Mexico City

Additional Locations

Job Type
Full time

Job Area
Finance & Accounting

Equal Opportunity

Constellation Brands is committed to a continuing program of equal employment opportunity. All persons have equal employment opportunities with Constellation Brands, regardless of their sex, race, color, age, religion, creed, sexual orientation, national origin or citizenship, ancestry, physical or mental disability, medical condition (cancer or genetic characteristics), marital status, gender (including gender identity or gender expression), familial status, military or veteran status, genetic information, pregnancy, childbirth, breastfeeding, or related conditions (or any other group or category within the framework of the applicable discrimination laws and regulations).

Client-provided location(s): Mexico City, CDMX, Mexico
Job ID: Constellation_Brands-R-32031
Employment Type: Full Time