Subject Matter Expert (SME), Investment Modeling

Jones Lang LaSalle Incorporated; Gurugram District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Jones Lang LaSalle Incorporated (JLL) is seeking a Subject Matter Expert (SME) in Investment Modeling based in Gurugram, India. You will develop and maintain complex financial models for operating and development properties, leveraging Excel and internal data systems while collaborating with global teams.

You will analyze macroeconomic trends, company financials, and market data to support investment decisions and pipeline development in a fast-paced, international environment.

Qualifications

• Bachelor’s or Master’s degree in finance, real estate, or related disciplines with excellent academic credentials.
• Advanced proficiency in Excel and financial modeling.
• CFA certification is a plus but not mandatory.

Responsibilities

• Develop financial models from scratch for operating properties, development projects, and other real estate assets.
• Construct, maintain, and validate data sources supporting modeling.
• Extract insights from public data sources including macroeconomic trends and company financials.
• Clean, prepare, interpret, and analyze data using Excel and internal data systems.
• Collaborate with global teams and stakeholders to support pipeline and opportunities.

Skills

Financial modeling

Excel

Real estate domain

Analytical thinking

Data interpretation

Self-motivation

Education

Bachelor’s or Master’s in finance/real estate

Tools

CRM database

Microsoft Office

Job description

JLL empowers you to shape a brighter way. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.

Subject Matter Expert (SME), Investment Modeling (CMG JBS India - Gurugram)

What this job involves:

• You will be part of the Investment modeling team that sits within the Business line Capital Market.
• You will be supporting the business in the form of financial modeling, and template creation of all operating and development properties using Microsoft Excel.
• Passion for global real estate Working closely with analysts and stakeholders from various global offices and supporting on the various process within the capital market team.
• This will help enhance the skill and global real estate knowledge.
• Team work Working with our leadership and business line heads to support the existing process and new business opportunities.
• You will be working closely with our team and global offices to leverage existing industry research and pair with external data sources to identify prospects and drive pipeline effectiveness.
• On top of this, you will also be working with management to improve our processes.
• Delivering excellent service You will attend meetings with global team members for delivering excellent service which are essential for fostering collaboration, gaining valuable insights, and continuously improving our service offerings.
• This will enable us to leverage our diverse talent pool, adapt to the real estate market dynamics, and provide exceptional service tailored to the needs of our clients across the globe.

Sound like you? Energetic Individual

Are you bursting with energy and ready to hit the road running? Your passion in fostering the real estate knowledge will be integral in helping the business grow its share. A go-getter at heart, you aim to excel in this competitive space while creating an impression in the market.

Inquisitive

Are you interested to acquire more knowledge about global real estate? You will be part of a global business and international team. We are happy to bring on enthusiastic candidates with a flair in developing the knowledge in the real estate asset classes such as multifamily, retail, office, hotel, or industrial spaces and providing the opportunity to develop the career.

Team player

While you will be required to work independently while chasing your own leads, we work closely within the global team to service international clients. You can learn the best industry practice and pick up the global real estate skills required to know how of your clients’ needs in the long run.

Great communicator

Can you put your ideas across to your clients clearly both verbally and in writing? JLL is the leading real estate solutions provider therefore we pride ourselves to be able to present our proposed commercial spaces and negotiated terms clearly to the various stakeholders within our clients’ organization. Excellent communication skill is imperative in this case and you will need to manage your schedule well in order to juggle your existing tenants as well as sourcing for new ones.

To apply you need to be:

• Being Analytical You will play a crucial role in the development of financial models from scratch.
• Your responsibilities will encompass the construction, maintenance, and validation of both primary and secondary data sources.
• You will be extracting key insights from a diverse range of public data sources, including macroeconomic trends, industry developments, company financials, and competitive landscapes.
• Your expertise will be essential in data cleaning, preparation, interpretation, and analysis, utilizing advanced statistical techniques and tools such as Excel, our internal CRM database, and other data management systems.
• This position requires a keen eye for detail, strong analytical skills, and the ability to create, review and handle complex financial models.
• Meticulous You must pay attention to detail and have excellent problem-solving skills.
• Possess the ability to collate information into cohesive presentations with proper slide layout / design.
• Skills required 4-7 years of work experience in commercial real estate industry with proficiency in creating, analysing, and maintaining explanatory/predictive financial models in Excel.
• Possess skills at subject matter expert level in real estate domain.
• Strong quantitative orientation, with knowledge of real estate property valuations, including Discounted Cash Flow, IRR, NPV, Time Value of Money, Return on Equity, Debt Returns, Three Statement Analysis, Sensitivity Analysis, Scenario Analysis etc.
• Knowledge of advance excel, and financial modeling.
• Ability to create financial models from scratch for operating properties, recreational properties, land development, energy projects, infra projects, 3 statements, REIT, JV Structure and waterfall models.
• Should have experience in understanding and handling complex models.
• Understanding of VBA macros and power query will be an added advantage.
• Excellent verbal and written communication skills.
• Superior problem-solving skills, self-motivation, and the capacity to work under pressure and tight deadlines.
• Personally, strives to ensure data quality, consistency, and accuracy in all work.
• A desire to work within a diverse, collaborative, and driven professional environment.
• Have experience of direct client communication and project management.
• Ready to adapt as per the changing requirement of the business.
• Self-motivating individual who is detail-oriented, has strong organizational skills, and the ability to work independently and within a team under deadlines.

Qualification required

Bachelor’s or Master’s degree in finance, Real Estate, or related disciplines with excellent academic credentials or an equivalent combination of education and experience. Advanced proficiency in Excel and financial modeling. Computer proficiency including Microsoft office (excel, word, power point). Have completed CFA certification but not mandatory. Good to have financial modeling certifications.

What we can do for you:

At JLL, our purpose is to shape the future of real estate for a better world. We make sure that you become the best version of yourself by helping you realise your full potential in an entrepreneurial and inclusive work environment. We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package.

Location: On-site -Gurugram, HR Scheduled Weekly Hours: 40

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services.

Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may email us at [e-mail].

For further information please see our career site pages for each country.

We help our people thrive, grow meaningful careers and find a place where they belong. Together, we strive to be exceptional and shape a better world. For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500® company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM.

JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated.