Analyst, Senior Financial Planning

Analyst, Senior Financial Planning & Analysis page is loaded

Analyst, Senior Financial Planning & Analysis Apply locations Mexico City time type Full time posted on Posted 4 Days Ago job requisition id R-32031

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.

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).

About Us

Constellation Brands (NYSE: STZ) is a leading international producer and marketer of beer, wine, and spirits with operations in the U.S., Mexico, New Zealand, and Italy. Our mission is to build brands that people love because we believe elevating human connections is Worth Reaching For. It's worth our dedication, hard work, and calculated risks to anticipate market trends and deliver more for our consumers, shareholders, employees, and industry. This dedication is what has driven us to become one of the fastest-growing, large CPG companies in the U.S. at retail, and it drives our pursuit to deliver what's next.

Every day, people reach for our high-end, iconic imported beer brands such as those in the Corona brand family like the flagship Corona Extra, Modelo Especial and the flavorful lineup of Modelo Cheladas, Pacifico, and Victoria; our fine wine and craft spirits brands, including The Prisoner Wine Company, Robert Mondavi Winery, Casa Noble Tequila, and High West Whiskey; and our premium wine brands such as Kim Crawford and Meiomi.

As an agriculture-based company, we have a long history of operating sustainably and responsibly. Our ESG strategy is embedded into our business and our work focuses on serving as good stewards of the environment, enhancing social equity within our industry and communities, and promoting responsible beverage alcohol consumption. These commitments ground our aspirations beyond driving the bottom line as we work to create a future that is truly Worth Reaching For.

#J-18808-Ljbffr

---