Project Lead - Financial Modeling (MENA Consulting)

Location: Gurugram, India

**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.

**Overview:**

• Taking complete ownership of the financial model of the real estate mega projects in the region.
• Financial modelling, cash flow projection and investment analysis for real estate projects using DCF method.
• Preparation of Financial Statements (CF, P&L and Balance Sheet) for real estate adhering to the relevant financial reporting standards and local/regional compliance.
• Calculation of return analysis and other financial performance indicators to prepare the investment memorandum.
• Run the various sensitivity and scenario analysis to mitigate the potential risk.
• Financial due diligence of real estate mega projects.
• Advanced Excel skills. VBA is added advantage.
• Excellent analytical skills.

**General Competencies**

• Strong leadership quality – able to lead a team of junior modelers and develop strong relationships with clients.
• Bright, intelligent, fast learner, enthusiastic, motivated.
• Clear communicator with strong presentation skills.
• Strong analytical background with attention to detail.
• Strong organizations skills with the ability to work on multiple tasks and prioritize.
• Show proof of rigor and autonomy when working.
• Ability to work to meet deadlines, even when timeframes are demanding.

**Professional Competencies**

• Create a dynamic real estate development model in MS Excel using DCF method. Prepare all financial statements with financial reporting standards.
• Excellent understanding and modelling skills of various development strategy for a masterplan megaproject (self-development, land sale and land lease to sub developer)
• Excellent understanding to run the optimal capital structure of a real estate investment including detailed financing structure with refinancing flexibility.
• Develop the various partnership models in real estate sector including JV with private developer (promote structure using cash flow waterfall model).
• Excellent understanding and modelling skills of a real estate fund model.
• Excellent Knowledge and understanding of various local/GCC compliance law (VAT modelling, escrow modelling for UAE and KSA).
• Able to run the sensitivity and scenario analysis of the real estate investment to mitigate the potential risks.

**Other Competencies**

• Excellent verbal and written communication skills in English.
• Corporate written communication.
• Willingness to take on new challenges.
• Efficiently use words to communicate complex ideas.
• Be capable of managing stress & accepting constructive feedback.

**Experience:**

• 4-6 years’ financial modelling experience in MS Excel for the regional projects.
• Previous technical background in real estate financial modelling.

**Education Qualifications:**

• Master’s degree in real estate / finance / business.
• FMVA certification is added advantage.

**Location:**

On-site –Gurugram, HR

**Scheduled Weekly Hours:**

40

**Job Tags:**

Real Estate Industry Knowledge

If this job description resonates with you, we encourage you to apply, even if you don’t meet all the requirements. We’re interested in getting to know you and what you bring to the table!

At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing.

***JLL Privacy Notice***

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.

For more information about how JLL processes your personal data, please view our [Candidate Privacy Statement](https://www.us.jll.com/en/careers/candidate-privacy-statement).

For additional details please see our career site pages for each country.

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 [HRSCLeaves@jll.com](mailto:HRSCLeaves@jll.com). This email is only to request an accommodation. Please direct any other general recruiting inquiries to our [Contact Us](https://www.us.jll.com/en/contact-us) page > I want to work for JLL.

Activate your [Personal Job Alerts](http://jll.wd1.myworkdayjobs.com/en-US/jllcareers/jobAlerts) now and receive opportunities as soon as they are advertised.

If you're a current JLL employee, please apply using the [Internal Career Site](https://www.myworkday.com/jll/d/task/1422$6913.htmld)

At JLL, we give you the opportunity, knowledge and tools to own your success, because we value what makes each of us unique. 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. For further information, visit [jll.com](https://www.jll.com).