Avison Young provides analytical services and support for American Realty Advisors (ARA). The Assistant Vice President, Valuations will work on a portfolio of our client’s commercial real estate assets. This role is based in ARA’s downtown Los Angeles office, so the candidate will be expected to be a resident of Southern California and commute to the office.

ESSENTIAL BUSINESS EXPERIENCE AND TECHNICAL SKILLS:

• Bachelor’s degree in Finance, Real Estate, Economics, Statistics, or related field required.
• Approximately 10 years of experience in commercial real estate valuations or underwriting, with strong knowledge of real estate finance terms and formulas.
• Advanced skills in valuation, analytics, and Discounted Cash Flow modeling utilizing MS Excel and Argus Enterprise (AE) is required. Consideration given to Member of Appraisal Institute (MAI) or MAI Candidate, but not required.
• Strong financial and math skills, including the ability to calculate discounted cash flows, net present value, and internal rate of return.
• Solid understanding of accounting principles, including the ability to read and interpret accounting reports and statements.
• Experience working with Asset Management or Portfolio Management is a plus.
• Proficiency with software for word processing, spreadsheet and complex financial analysis. Advanced skills with Excel macros; SQL Database; MRI, Argus Enterprise modeling, AE Portfolio Reporting & Sensitivity Analysis, and XL4ADW are essential.
• Demonstrated ability to create detailed, dynamic, best-in-class reporting solutions to meet the complex needs of stakeholders.
• Experience with data visualization software (e.g., PowerBI, Power Pivot, Tableau) and business planning software (e.g., Anaplan). Knowledge of Python, SQL, robotic process automation (“RPA”) software is a plus.
• Capable of managing multiple tasks in a fast-paced environment and working independently and in teams.
• Highly organizational with strong time management and attention to detail.
• Excellent written and verbal communication skills.
• Familiarity with institutional real estate investment management environments and a quick learner of the company’s real estate investment products, goals and operations.

JOB SPECIFICATIONS:

• Work environment and physical demands: General office environment.
  Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
  Avison Young is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, national origin, ancestry, citizenship status, age, physical or mental disability, sex, gender, gender identity or expression (including transgender status), marital status, veteran status, sexual orientation, genetic information, or any other characteristic protected by applicable federal, state, or local laws. Madison Marquette is dedicated to this policy with respect to recruitment, hiring, placement, promotion, transfer, training, compensation, benefits, access to facilities and programs, and general treatment during employment.
  Avison Young considers for employment qualified applicants with criminal histories in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring Ordinance No. 184652

• Assist the EVP, Valuations with the management of the quarterly valuation process to ensure timely completion and delivery of documentation.
• Assist with internal quarterly valuations, including peer reviews, broker opinions of value reviews, disposition reviews, and internal file audits.
• Partner with Asset Management to review and analyze quarterly appraisals, providing appropriate feedback to the EVP, Valuations and third-party appraisers to ensure modeling consistency and compliance with ARA’s valuation policies and procedures.
• Gather property/market data for quarterly valuations and respond to valuation-related questions.
• Audit cash flow models and income statements used for valuations and sale offerings.
• Run portfolio valuation analytics and sensitivities. Present results clearly.
• Identify and resolve inconsistencies in data inputs from internal and external sources.
• Maintain and improve internal valuation models and systems.
• Assist the EVP, Valuations with the development and documentation valuation procedures and best practices.
• Collaborate with IT and others to optimize valuation-related software platforms.
• Audit Argus models for quality control against current policies and procedures.
• Provide modeling assistance and support for Argus Enterprise across departments.
• Conduct training sessions on valuation techniques, process, and software.
• Participate in mentoring and training to enhance technical and leadership skills.
• All other responsibilities that may be assigned from time to time.