Analyst, Investment Modeling

Overview

Analyst on the Debt Sizing team within JLL's Capital Markets Group, India, supporting debt sizing and financial modelling for multifamily and commercial properties.

What you'll do

• Evaluate multifamily and commercial properties to determine appropriate loan amounts.
• Create financial models that support sound lending decisions.
• Analyse operating statements, rent rolls and other operating data for multifamily and commercial properties for Debt Sizing.
• Perform data cleaning, preparation, interpretation and analysis, calculating key metrics including NOI, EGI, GPR and occupancy.
• Create, review and handle financial models.
• Work closely with analysts and stakeholders from global offices and support processes within the capital markets team.
• Work with leadership and business line heads to support existing processes and new business opportunities.
• Leverage industry research and pair it with external data sources to identify prospects and drive pipeline effectiveness.
• Work with management to improve processes.

What you'll need

• Master's degree in finance, real estate or related disciplines with excellent academic credentials, or an equivalent combination of education and experience.
• 2-4 years of work experience in the commercial real estate industry.
• Proficiency in performing preliminary loan sizing/underwriting for multifamily properties.
• Experience analysing Profit & Loss (P&L) statements and rent rolls, identifying key performance drivers and operational inefficiencies.
• Excellent verbal and written communication skills.
• Superior problem-solving skills, self-motivation, and capacity to work under pressure and tight deadlines.
• Personally strives to ensure data quality, consistency and accuracy in all work.
• Detail-oriented, with strong organisational skills and the ability to work independently and within a team under deadlines.
• Ready to adapt to changing business requirements.
• Computer proficiency including Microsoft Office (Excel, Word, PowerPoint).

Nice to have

• Understanding of commercial debt sizing for retail, office and industrial properties.
• Knowledge of narratives, sales and rent comps, quote matrix and other related products.
• Experience of direct client communication and project management.
• Financial modelling certifications.

Details

• Location: On-site, Gurugram, HR.
• Scheduled weekly hours: 40.