Job description
The intern will support Altus’ European Advisory team consisting of around 20 people based in Luxembourg and London. Their primary role will be to provide support to the appraisal review process of commercial real estate portfolios located across Europe. Each quarter, the intern will assist in the review and update of ARGUS and/or MS-Excel models for all property types, as well as assist in the preparation of client deliverables.
- Assisting in the appraisal management process for clients such as major banks, pension funds, insurance companies and Real Estate funds.
- Analyzing and reviewing ARGUS and MS-Excel valuations models for accuracy and reasonableness.
- Assisting in gathering quarterly market research.
- Tracking changes between valuations from quarter to quarter.
- Providing assistance in researching and understanding inconsistencies and discrepancies in appraisal reports.
- Preparing portfolio metric presentations.
- Gaining an understanding of the standard appraisal methods applied.
- Understanding key fundamentals of the real estate industry in order to calculate industry key ratios.
- Languages: Fluency in English. Additional European languages are an advantage.
- Currently in the 4th or final year of a degree from a University, an Engineering school or a Business school (in economics or finance).
- Strong financial modelling skills in order to model and analyse complex assets in ARGUS and MS-Excel.
- Appraisal experience or prior exposure in appraisal is a plus.
- Interest in property risk management.
- Willingness to support teammates in tackling the group’s workload.
- Willingness to provide administrative support to team members as need be.
- Willingness to integrate a fast growing and global Group.
- Excellent computer skills (MS Office).
- Proficient in Excel (Pivot tables, VLOOKUP, modelling's, macro, etc.).
- Basic understanding of Argus software is an asset.
- An understanding of the concepts of Present Value and Future Value. Knowledge of real estate valuation techniques is a plus.
- High attention to detail.
- Strong written and oral communication skills.
- Ability to multi-task and prioritise projects and portfolios; strong time-management skills.
- High level of integrity and intellectual curiosity.