Job Description

The role of Sr. Analyst in Valuations and Portfolio Reporting will provide valuation and analytical support and performance reporting as follows:

• Supports the quarterly internal valuation support cycles together with Customer and in turn, Client.
• Manages and maintains robust Argus cash flow models to be exported into excel valuation models.
• Effectively obtains property-level information from various source systems or portfolio companies in order to routinely update cash flow models with actual leasing or changes in market leasing assumptions, other income, operating expenses or capital expenditures.
• Provides critical analysis of changes at the property- or investment-level in order to report on the cash-flow and valuation changes.  Analysis of property- or investment-level changes is at the equity value.
• Analyzes market conditions from sales comparable and other sources in order to drive assumptions and assess the value of the assets.

• Supports the entire valuation reporting process with Customer and in turn Client stakeholders and revise valuation models based on feedback.
• Assists in ad hoc requests or special projects at the request of the Customer or at the request of Client or portfolio companies, most notably data and analytics for real estate valuations.
• Continues to collaborate and enhance processes and procedures to deliver best in class service. 

͏

Qualifications
What you should have:
•    Bachelor’s degree in business, finance, or accounting.
•    A minimum of three (3) to five (5) years (analyst/sr. analyst level) work experience in FP&A and/or financial reporting within a commercial real estate firm.
•    A strong work ethic, the strength to thrive in a dynamic and demanding work environment, and an ability to meet critical deadlines.
•    Intelligence with a keen focus on details.
•    Excellence with Excel and PowerPoint: efficient database sourcing, utilization of standard Excel functions (sumif/s, sumproduct, index/match, indirect, pivot tables, data tables, filters, and keyboard shortcuts) to aggregate and summarize data, creation of graphs in proper context of data presented, use of best practices for insuring data integrity, design of executive/board level presentation quality outputs. Experience with Yardi and/or data analytics is a plus.
•    Excellent oral and written communication skills since interaction with personnel at all levels will be required.