Project Lead - Financial Modeling (MENA Consulting)

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.