Subject Matter Expert

JLL supports the Whole You, personally and professionally.
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 preparing real estate valuation models and forecasting models using microsoft excel. Also, provide support in market trend analysis and report writing.
Passion for global real estate
Working closely with analysts and stakeholders from various 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
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.
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, analyzing, and maintaining explanatory/predictive financial models in Excel.
Assist in managing and executing valuation modeling projects of large real estate portfolios of various property types across India.
Conduct detailed cash flow analysis, valuations, scenario analysis and sensitivity analysis to assess investment feasibility and performance.
Ensure standardization and accuracy of the valuation models and reports and take complete ownership of the projects undertaken or overseen.
Ensure compliance with international valuation standards and local regulations.
Contribute to process improvements and best practices within the team.
Assist in managing stakeholder relationships and addressing queries.
Stay updated with industry trends, market conditions, and best practices in the real estate industry
Audit Data Management and Data Archives for all Projects
Should have experience in understanding and handling complex models.
Understanding of VBA macros and power query will be an added advantage.
Strong communication skills, both written and verbal, with the ability to articulate complex financial concepts to non-financial stakeholders.
Superior problem-solving skills, self-motivation, and the capacity to work under pressure and ti