Analyst, Investment Modeling – Investment Modeling

Job Description

Analyst, Investment Modeling | Jones Lang LaSalle

The Tone:
This is a full-time role at Jones Lang LaSalle, located in Gurugram, India. JLL is shaping the future of real estate for a better world through world-class services, advisory, and technology. This role supports the business by offering comprehensive analytical and financial services, which involves evaluating multifamily and commercial properties to determine appropriate loan amounts and creating financial models that support sound lending decisions. You will be integral in helping the business grow its share within the capital markets space.

The TL;DR
• Role: Full Time
• Type: Full-time
• Location: In-person – Gurugram, HR, India

• Team: Debt Sizing team, part of the Capital Markets Group, India, which sits within the larger CMG global team.
• Mission: Evaluate multifamily and commercial properties to determine appropriate loan amounts and create financial models that support sound lending decisions.
• Tech Stack: Microsoft Office (Excel, Word, PowerPoint), other data management systems.

What You’ll Actually Do
• Debt Sizing: Support the business by offering comprehensive analytical and financial services for multifamily and commercial properties.
• Financial Modeling: Evaluate multifamily and commercial properties to determine appropriate loan amounts and create financial models that support sound lending decisions.
• Data Analysis: Analyze operating statements, rent rolls, and other operating data for multifamily and commercial properties for the purpose of Debt Sizing.
• Data Interpretation: Clean, prepare, interpret, and analyze data utilizing advanced statistical techniques and tools to calculate key metrics including NOI, EGI, GPR, and Occupancy.
• Collaboration & Improvement: Work closely with leadership, business line heads, and global offices to support existing processes, new business opportunities, and improve overall processes.

The Must-Haves
• Background: Master’s degree in finance, Real Estate, or related disciplines with excellent academic credentials, or an equivalent combination of education and experience.
• Experience: 2-4 years of work experience in the commercial real estate industry with proficiency in performing Preliminary Loan Sizing/Underwriting for Multifamily properties. Experience in analyzing Profit & Loss (P&L) statements and Rent Roll, identifying key performance drivers and operational inefficiencies.
• Skills: Strong analytical skills; ability to create, review, and handle financial models; excellent verbal and written communication skills; superior problem-solving skills.
• Bonus: Understanding of Commercial Debt Sizing for Retail, Office, and Industrial properties; knowledge of Narratives, Sales and Rent Comps, Quote Matrix, and various other related products; financial modeling certifications; experience of direct client communication and project management.