Investment Analyst - Berlin

Position: Investment Analyst

Salary: Up to 65,000 Euros plus bonus + benefits

Location: Berlin, Germany

Capstone are delighted to be working in partnership with a pan-European industrial platform, headquartered in London, focused on urban/infill industrial and logistics properties in the UK, France, Germany, Benelux, Spain and Italy.

Founded in 2016, our client is a full-service development management and investment business with offices in London, Paris and Berlin. Today the Company manages a 100+ asset portfolio totalling ~1.3 million square meters and c. €4bn of AUM.

The team of analysts and investment professionals relies on advanced financial modelling and deep market insight to make data-driven decisions. We are searching for an exceptional Investment Analyst, based in Berlin, to provide best-in-class financial modelling skills and analytical expertise.

About you:

• Bachelor's, Master's or PhD degree in Finance, Economics, Mathematics, Statistics, Engineering, or a related field, with a strong academic record in quantitative courses.
• Exceptional Excel-based financial modelling skills with a demonstrated ability to design, adapt, and manage complex, scenario-driven models for investment and project appraisal.
• Strong quantitative and analytical abilities, with a deep understanding of financial metrics such as IRR, NPV, cash flow forecasts, sensitivity analysis, and ROI.
• Solid understanding of the real estate investment and development lifecycle, including acquisition underwriting, due diligence, property valuation, and financial performance metrics.
• Excellent written and verbal communication skills, with the ability to synthesize complex financial information and present it clearly to senior management and external stakeholders.
• Previous experience in real estate investment, development, or finance within the German market.
• Familiarity with financial modelling and data visualization tools such as Argus, Power BI, or Tableau.
• Proficiency in both German and English to support communication with local stakeholders and international teams.
• High level of attention to detail, ensuring accuracy, precision, and consistency in all financial models, reports, and analyses.

About the role, main responsibilities include:

• Design, adapt, and maintain sophisticated Excel-based financial models that evaluate the viability, profitability, and risk of real estate investment and development projects.
• Conduct comprehensive financial assessments, including cash flow projections, return on investment (ROI) analysis, and internal rate of return (IRR) calculations.
• Generate clear, accurate, and insightful outputs from financial models, translating complex data into concise reports and visual summaries suitable for executive and board-level presentations.
• Utilize advanced financial modelling techniques to conduct scenario and sensitivity analysis, examining how various market conditions, financing terms, and property assumptions impact project and portfolio performance.
• Perform detailed financial analysis and modelling for potential investment opportunities, creating scenario-driven models that reveal risks and strategic opportunities.
• Assist in preparing high-quality reports and presentations for the Board and Executive Committee, ensuring that financial insights are clearly communicated and aligned with corporate strategy.
• Develop and maintain an integrated financial model to project the firm's long-term financial performance, supporting annual strategic reviews and capital planning processes.
• Work closely with teams to create detailed project budgets, monitoring and adjusting forecasts as projects evolve to ensure alignment with business objectives.
• Gather insights from various internal and external stakeholders to strengthen model assumptions, validate underwriting, and ensure investment recommendations are data-driven and robust.
• Play a key role in the due diligence process by rigorously analysing financial data, assessing market conditions, and evaluating potential risks associated with acquisitions.
• Maintain a comprehensive database of deal flow, tracking historical performance, financial outcomes, and strategic insights to support ongoing investment strategies.
• Regularly analyse deal data and investment performance, transforming this information into actionable insights that enhance portfolio optimization and strategic planning.