Subject Matter Expert (SME), Investment Modeling

• Supporting the business in the form of financial modeling, and template creation of all operating and development properties using Microsoft Excel
• Working closely with analysts and stakeholders from various global offices and supporting on the various process within the capital market team
• Working with our leadership and business line heads to support the existing process and new business opportunities
• 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
• Working with management to improve our processes
• Attend meetings with global team members for delivering excellent service
• Play a crucial role in the development of financial models from scratch
• Construction, maintenance, and validation of both primary and secondary data sources
• Extracting key insights from a diverse range of public data sources, including macroeconomic trends, industry developments, company financials, and competitive landscapes
• Data cleaning, preparation, interpretation, and analysis, utilizing advanced statistical techniques and tools such as Excel, our internal CRM database, and other data management systems
• Create, review and handle complex financial models
• Collate information into cohesive presentations with proper slide layout / design

• 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
• 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
• 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)

• Understanding of VBA macros and power query
• Have completed CFA certification but not mandatory
• Good to have financial modeling certifications

We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package