miro Personalvermittlung is recruiting a Real Estate Financial Modeller & Controller for a boutique real estate private equity firm. You will expand the firm's financial capabilities by developing sophisticated models that drive investment decisions and asset management strategies across commercial and residential real estate portfolios.
What You'll Do
- Design and develop comprehensive real estate financial models for investment portfolios across CRE and residential assets.
- Create meticulous tenant-by-tenant cash flow projections with advanced lease modelling capabilities.
- Build sophisticated loan models including senior debt, mezzanine financing, capex facilities, refinancing scenarios, and various amortization structures.
- Develop detailed tax calculation modules covering EBITDA, book values, depreciation, tax loss carried forward accounts, and capital gains analysis.
- Model complex capital expenditure plans using S-curve methodologies.
- Create residual land appraisal models for development projects.
- Implement scenario and sensitivity analysis including Monte Carlo simulations with multi-variable data tables.
- Generate clear, presentation-ready output tables and dashboards for investment committee and external stakeholders.
- Potentially assist with actual reporting for banks and investors as the partnership develops.
What We're Looking For
- Advanced Excel proficiency with expert-level formula knowledge (3D references, sumproduct with multiple conditions, index match with multiple conditions).
- Proven experience in developing complex real estate financial models, particularly in commercial and residential sectors.
- Deep understanding of loan structures, financing terms, and debt modelling techniques.
- Comprehensive knowledge of key real estate performance metrics and how they are calculated (net initial yields, yield on cost, debt yield, DSCR ratios, IRR, equity multiples).
- Experience with tax modelling in real estate investments.
- Ability to create transparent, easy-to-follow models with clear documentation.
- Self-motivated with excellent communication skills.
- Fluent English.
Nice to Have
- Demonstrated expertise in several real estate markets (Germany, UK, and US experience a plus).
- German language skills.
- VBA and/or Python skills.
Technical Stack
- Excel
- VBA
- Python
Team & Environment
You will join a small, agile team where you will have direct impact and see your work drive decisions. The structure is flat with a focus on direct contribution.
Benefits & Compensation
- Completely remote work arrangement.
- Flexible hours that accommodate existing commitments.
- Direct impact in a small, agile team environment.
- Exposure to diverse real estate investment strategies.
- Opportunity to develop into a long-term partnership.
- Opportunity to contribute to the development of proprietary tools and systems.
Work Mode
This is a fully remote position open to candidates based in India.
miro Personalvermittlung and its client are equal opportunity employers.
