Consultant, Advisory (Commercial Real Estate) New York, New York

Job Category: Valuations & Appraisals Pay Grade Range: $60,840.00 - $141,960.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 PropTech 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 and evaluating results, communicating at-risk tasks
• Experience with client deliverable life cycle and proven record of successful management of client deliverables

What Altus Group offers:

• Rewarding performance: We are pleased to be able to provide employees competitive compensation, incentive and bonus plans, and a total rewards package that prioritizes their mental, physical and overall financial health.
• Growth and development: As a destination for top industry talent, we’re investing in you to meet the evolving needs of our clients and deliver on your professional goals. Our Altus Intelligence Academy offers over 150,000 hours of learning materials catering to diverse stages of an employee’s career journey.
• Flexible work model: We’re modernizing our employee programs to reflect the new world of work. Our Activity-Based Work model provides you with flexibility to align your work location to the work being performed - office for connecting and collaborating, and remote for focused work.

Altus Group is committed to fostering an inclusive work environment where all clients and employees feel welcomed, accepted and valued. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. Applicants with disabilities may contact Altus Group to request and arrange for accommodations. If you need accommodation, please contact us at [email protected] or +1 888 692 7487. We appreciate all applicants who take the time to apply to Altus Group. Please note that only those who are selected to move forward in the process will be contacted. Thank you. Apply tot his job Apply To this Job