Assistant Manager, Investment Modeling

JLL empowers you to shape a brighter way Our people at JLL and JLL Technologies 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 Assistant Manager AM 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 and reporting directly to the team head You will be supporting the business in the form of financial modeling and excel model 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 5-10 years of work experience in commercial real estate industry with proficiency in creating analysing and maintaining explanatory predictive financial models in Excel Possess technical skills in the commercial real estate and excel modeling domain Should have people management experience in the past and must have been involved in performance review of the team Multi-tasking and able to handle multiple projects with multiple clients Should able to manage client calls independently 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 guide review and create financial models from scratch for operating properties recreational properties land development energy projects infra projects and REIT 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 Apply today Location On-site -Gurugram HR Scheduled Weekly Hours 40 Job Tags JBS 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 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 For additional details please see our career site pages for each country For candidates in the United States please see a full copy of our Equal Employment Opportunity policy 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 accomodationrequest am jll com This email is only to request an accommodation Please direct any other general recruiting inquiries to our page I want to work for JLL