Analista, Planeación y Análisis Financiero

Description du poste:

Job Description
Ciudad de México

Nivel de Estudios
Bachelor's Degree in finance, accounting, economics, or business preferred.

Experiencia Requerida
From 2 years of experience in Finance Planning and Analysis, cost and accounting.

Habilidades
* Self-driven and results-oriented individual who excels in a dynamic environment, strong communication skills, both written and verbal; proven analytical skills, attention to detail, aptitude to set priorities while managing multiple tasks, as well as proficiency for follow-up.
* Individual eager to learn 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.
Hard Skills:
* SAP
* Excel (pivot tables, filtering, look-up formulas, Power Pivot, Power Query)
* Power BI (Database management, DAX)
* PowerPoint

Resumen
Forecasting and reporting for all expenses incurred by the Mexico City, San Antonio, and Swiss offices.
Provide financial information & analysis to the Beer Supply Chain & the FP&A departments.
Propose office-wide savings initiatives.
Assist with analysis and report enhancements across Supply Chain Finance teams.
Coordinate Billings / Shipment analysis and its impact on the P&L.

Responsabilidades
1. Planning and Forecasting
* Coordinate and prepare the Annual Plan/Latest Estimates for G&A Mexico, San Antonio, and Swiss 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.
* 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 backup schedules to support the analysis.
* Obtain/prepare Profit & Loss Financials by entity and Ledger for all the related accounts for the support offices.
* Responsible for loading and reconciling the information in the Planning Application by detail (account, entity, business unit, currency, etc.) for the support offices.
2. Monthly Reporting & Analysis
* Obtain/prepare detailed monthly variance analysis of Actuals vs LE, 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 meetings with VP heads of the business unit to track problem spending areas for the support offices.
* Identify and communicate potential risks and opportunities for the support offices to the business.
* Ad Hoc Analysis as required.
3. Continuous improvement
* Analyze the current state of account/system settings, reports, and analysis of the different Supply Chain Finance teams and identify opportunity areas.
* Prepare executive COGS reports focusing on automation and Cost per Case view.
* Assist with the enhancement of current analysis tools to a more state-of-the-art tools.
* Assist with the creation of new automatic consolidated analyses and reports for the FP&A and other financial teams.
4. Billings/Shipments tracking
* Track monthly variances versus forecasts.
* Meet with all stakeholders to calculate & determine the financial impact that these variances are having on our bottom line.
5. 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.

LocationCiudad de Mexico, Mexico

Additional Locations

Job TypeFull time

Job AreaFinance & 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)