Consultant, Advisory; Commercial Real Estate

Position: Consultant, Advisory (Commercial Real Estate)
Location: New York

Consultant, Advisory (Commercial Real Estate) page is loaded## Consultant, Advisory (Commercial Real Estate) locations:
New York, New Yorktime type:
Full time posted on:
Posted Todayjob requisition :
R0013011
** Job Category:
** Valuations & Appraisals
** Pay Grade Range:**$60,840.00 - $
** Disclaimer:
** The base salary range represents the low and high end of Altus Group’s “Pay Grade Range” for this position in the primary work location. Actual hiring salaries will vary depending on factors including but not limited to work experience, and geographic market data for the role. The Pay Grade Range listed above does not reflect Altus Group’s total compensation for employees.

Other rewards may include an annual bonus, flexible work arrangements, and region-specific benefits.
** Unlock your Altus Experience!
** If you’re looking to advance your career in data analytics, expertise, and technology for the rapidly growing global CRE market, there’s no better place than Altus Group. At Altus, our work is purposeful. Every day, our employees drive impact, innovate, and shape the global commercial real estate (CRE) and Prop Tech industry.

Our people-centric culture empowers you to deliver in a high trust, high performance culture, surrounded by an inclusive team that’s collaborating to modernize our industry. We invest in our people with training and growth opportunities designed to propel you further in your career while providing a flexible and progressive workplace that reflects our values and teams.
*
* Job Summary:

** Altus Group is currently looking for a new Real Estate Valuation Consultant to join our New York office in our Advisory, Altus Analytics division. In this position, the Consultant will be responsible for managing the daily workflow through interaction with clients, subordinates and supervisors. Responsibility includes the quarterly valuation process of institutional real estate funds, which includes managing all aspects of the appraisal management process & real estate investment vehicles.
*
* Key Responsibilities:

*** Requires advanced working knowledge of complex Excel tasks like VBA (Visual Basic for Applications) programming, data simulation, analytics, and advanced formula usage (such as Macros, Power Query, Pivot Tables, Power Pivot, Dynamic Name Range, etc.).
* Improve client deliverables through data visualization.  Includes presenting sets of primarily quantitative raw data in a schematic form. The visuals used are formats tables, charts and graphs, diagrams, plots, geospatial maps, figures, and correlation matrices, which sometimes will be combined in a dashboard.
* Interpreting client requests and communicating/delegating requests to team
* Managing projects/engagements to ensure delivery on time and on budget
* Review all work by junior staff before sending to clients or 3rd parties, coaching and mentoring junior staff
* Review third party appraisal reports as part of the valuation management process, discuss and resolve any concerns with the client and/or the 3rd party appraiser
* Review appraisal reports for compliance with USPAP and State regulations
* Manage client communications throughout the valuation management engagement; create or review portfolio metric presentations
* Develops relationships with equivalent level individuals in client firms
* Delivers the highest quality of service and technical excellence
** Key

Qualifications:

*** A university or college degree from an accredited university in Finance, Statistics, Data/Computer Science, Mathematics, or related field.
* ** Must have strong Excel proficiency and the ability to complete complex Excel tasks and experience with VBA (knowledge of the following is a plus: R or Python Statistical Programming, Structured Query Language (SQL), Tableau/Power BI, Snowflake)
*** Experience in Commercial Real Estate Valuation, Asset Management, Acquisitions, or Underwriting
* Expertise in financial analysist and experience with financial modelling for commercial property types (office, industrial, retail and/or multifamily) in ARGUS
* Proficiency in Excel
* Strong communication skills
* Strong project management skills: managing deadlines, creating plans…