Senior Financial Analyst (Z)

Blue Coding; Ciudad de México; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Descripción de la vacante

Blue Coding is seeking a Senior Financial Analyst in Mexico City to join a high-visibility FP&A function supporting a growing real estate private equity platform. You'll own budgets, forecasts, cash flow models, and investment analyses for operating companies, funds, and projects.

You will partner with accounting, development, and asset management teams to deliver decision-ready analyses for executives and investors, with exposure to senior leadership and lenders.

Formación

• Master's degree or MBA in a related field; CFA charter is a plus.
• 4–8+ years in FP&A, real estate investment, or related finance roles.
• Strong modeling, multi-entity structures, and investor-facing skills.

Responsabilidades

• Build annual budgets, long-term forecasts, and project budgets with hard/soft costs and financing.
• Manage rolling forecasts, reconciling versions and updating variances.
• Create consolidated cash flow forecasts and equity funding schedules.
• Develop project-level pro formas and fund-level models with waterfalls.
• Underwrite acquisitions and development opportunities with robust schedules.
• Run sensitivity and scenario analyses on macro and project drivers.
• Model debt structures including LTC/LTV and debt yield metrics.
• Produce monthly/quarterly reporting and add commentary on drivers and risks.
• Ensure data quality and reconcile reporting to GL; support lenders/investors.

Conocimientos

Advanced Excel

SQL/Azure

Power BI

Python

English communication

Attention to detail

Educación

Master's degree

MBA

CFA charter (nice to have)

Herramientas

Power Query

Tableau

Azure

Intuit Enterprise Suite

bill.com

Descripción del empleo

This position is open exclusively to candidates based in Mexico City.

Who are we?

At Blue Coding, we specialize in hiring excellent professionals and amazing people from all over Latin America and other parts of the world. For the past 12 years, we've helped cutting-edge companies in the United States and Canada build great teams and achieve their goals. Large multinationals, digital agencies, SaaS providers, and software consulting firms are just a few of our clients. Our team of over 150 professionals, including engineers, project managers, finance and accounting specialists, QA and UX/UI designers, and many more, is distributed across more than 10 countries in the Americas. We are a fully remote company working across a wide range of industries and disciplines, with expertise at every stage of the talent engagement process. Our team is highly connected, united, and culturally diverse, and our collaborators are involved in many initiatives around the world, from wildlife preservation to volunteering at local charities. We stand for honesty, fairness, respect, efficiency, hard work, and cooperation.

Our client is a real estate private equity firm that manages the full development lifecycle, from land acquisition and entitlements through vertical construction, stabilization, and long-term asset management.

What are we looking for?

We are looking for an experienced Senior Financial Analyst. The firm's active development pipeline comprises six communities across the US totaling more than 706 multifamily units and over $229M in total development budget, along with a hospitality project in Tucson.

If you pair institutional-quality financial modeling with genuine technical depth in data analytics and database work, and you're just as comfortable building the pro forma as writing the query that feeds it, this is a great fit for you.

What's unique about this job?

Reporting to the VP of Finance, you'll serve as the analytical engine behind a growing real estate private equity platform focused on ground-up development, build-to-rent communities, and value-add multifamily assets. You'll own the creation and ongoing maintenance of budgets and financial models at the operating company, fund, and project level, turning data from accounting, development, and asset management systems into decision-ready analysis for executive leadership and investors.

This is a high-visibility, high-ownership role with direct exposure to the VP of Finance, the CFO, and the Managing Partner, and a clear path to greater responsibility as the platform scales.

Here are some of the exciting day-to-day challenges you will face in this role:

• Build and maintain annual operating budgets, long-term forecasts, and project development budgets, including hard costs, soft costs, contingency, financing costs, and sources and uses
• Own the rolling re-forecast process, updating budgets monthly and quarterly and reconciling each version to the prior one
• Prepare consolidated and entity-level cash flow forecasts, including the rolling 13-week corporate cash forecast, 1- and 5-year forecasts, and capital call and equity funding schedules
• Build and maintain project-level development and operating pro formas, fund-level models with distribution waterfalls and carried interest calculations, and the operating company model
• Underwrite new acquisition and development opportunities and prepare investment committee analysis and supporting schedules
• Run sensitivity, scenario, and stress-test analyses on construction costs, rent growth, lease-up timing, interest rates, and exit cap rates
• Model debt and capital structure alternatives, including construction loan sizing, refinancing, and covenant metrics such as DSCR, debt yield, and LTC/LTV
• Produce monthly and quarterly reporting packages, perform variance analysis at the operating company, fund, and project level, and write concise commentary on drivers, risks, and recommended actions
• Track job cost and committed vs. incurred vs. remaining budget in partnership with accounting and development teams
• Build and maintain the data infrastructure supporting FP&A, write and optimize database queries, and automate recurring reporting using Microsoft Azure, Power Query, Power BI, Python, or comparable tools
• Own data quality, reconciling reporting data back to the general ledger and documenting sources and logic
• Partner with accounting, development, construction, and asset management teams, and support lender and investor requests

You will shine if you have:

• Master's degree or MBA from a top-tier institution and a CFA charter are nice to have
• 4–8+ years of progressive experience in FP&A, investment banking, private equity, real estate investment, or corporate finance; real estate development or multifamily exposure strongly preferred
• Advanced Excel skills, including complex multi-entity models built from scratch, dynamic scenario and sensitivity analysis, and waterfall and return calculations
• Advanced data analytics and database management skills, including strong SQL/Azure experience and hands-on work with BI and automation tools such as Power BI, Power Query, Tableau, or Python
• Working knowledge of US GAAP and real estate accounting concepts, including job cost accounting, capitalization, consolidations, and fund structures
• Familiarity with multi-entity structures, joint ventures, distribution waterfalls, and investor allocations
• Experience with Intuit Enterprise Suite, bill.com, or comparable accounting and AP platforms is a plus
• Exceptional attention to detail, intellectual curiosity, and the judgment to know when a number looks wrong
• Excellent verbal and written English communication skills, with the ability to translate detailed analysis into clear recommendations for executives and investors
• Ability to manage multiple priorities and deliver under deadline in a fast-paced, entrepreneurial environment

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.