Consultant, Advisory

Altus Group • Atlanta, GA

2d

About The Position

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.

Requirements

• 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 and evaluating results, communicating at-risk tasks
• Experience with client deliverable life cycle and proven record of successful management of client deliverables

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

Benefits

• Rewarding performance: competitive compensation, incentive and bonus plans, and a total rewards package prioritizing mental, physical, and financial well-being.
• Growth and development: we invest in your professional learning. Our Altus Intelligence Academy offers over 150,000 hours of learning content.
• Flexible work model: our Activity-Based Work model provides flexibility to align your work location to the needs of the work — use the office for collaboration and remote work for focused tasks.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees