Analista, Planeación y Análisis Financiero

Posted 20 Days Ago
Be an Early Applicant
Ciudad de México, Cuauhtémoc, Ciudad de México, MEX
In-Office
Junior
Food • Marketing Tech
The Role
Provide FP&A support for Mexico City, San Antonio, and Swiss support offices: forecasting, annual and periodic planning, variance analysis, P&L preparation, billings/shipments impact, reporting automation, dashboards, cost-saving initiatives, and acting as finance business partner to support functions.
Summary Generated by Built In

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.

Location

Ciudad de Mexico, Mexico

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

Skills Required

  • Minimum 2 years of experience in Financial Planning & Analysis, cost accounting, or accounting
  • Bachelor's degree in Finance, Accounting, Economics, or Business
  • Proficiency with SAP
  • Advanced Excel skills (pivot tables, lookup formulas, Power Pivot, Power Query)
  • Power BI experience including database management and DAX
  • PowerPoint presentation skills
  • Strong analytical skills, attention to detail, and ability to prepare variance analysis and financial bridges
  • Strong communication and presentation skills; ability to interact with VPs and finance/business partners
  • Ability to work independently and drive projects from inception to completion

Constellation Brands Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Constellation Brands and has not been reviewed or approved by Constellation Brands.

  • Healthcare Strength Healthcare coverage is described as comprehensive, spanning medical, dental, and vision offerings alongside wellness resources. Additional supports such as telemedicine and mental-health programs are positioned as part of the overall package.
  • Retirement Support Retirement benefits appear comparatively strong, with a 401(k) match structure and an added non-elective contribution described in the materials. Profit sharing and employee stock purchase access are also included in the broader financial-security toolkit.
  • Leave & Time Off Breadth Paid time off is framed as generous, covering vacation, holidays, and sick time, with some roles citing substantial starting PTO. Work–life supports such as flexible or hybrid arrangements and summer hours are also part of the offering for eligible roles.

Constellation Brands Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Victor, NY
5,837 Employees
Year Founded: 1945

What We Do

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. To learn more, visit www.cbrands.com and follow us on Twitter, Instagram, and LinkedIn

Similar Jobs

NBCUniversal Logo NBCUniversal

Sales Planner - (TEMP)

AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Remote or Hybrid
CDMX, Cuauhtémoc, Ciudad de México, MEX
68000 Employees

CrowdStrike Logo CrowdStrike

Regional Sales Manager

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
México
10000 Employees
150K-1M Annually

CrowdStrike Logo CrowdStrike

Senior Consultant

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
México
10000 Employees

CrowdStrike Logo CrowdStrike

Consultant

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
México
10000 Employees

Similar Companies Hiring

PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account