Associate, Portfolio Analytics - Pipeline

The candidate conducts reporting services on behalf of assigned clients on complex real estate funds including aggregation of both financial and non-financial data. Responsibilities include extracting and analyzing performance attribution on both levered and unlevered basis, fund diversification including but not limited to regional, sector and risk profile levels and tenant related reporting. Effective at extracting specific data elements from various source files into specific client based templates and databases in an efficient and streamlined manner. Responsible for the coordination of data between portfolio analytics, accounting, client services and the client.

In addition, the candidate needs to possess strong technical skills. Current reporting is performed using excel and our initiative is to automate all the reporting across all funds. The candidate is responsible for executing project work streams as agreed with the stakeholders and team management. You will work closely with the Real Estate stakeholder teams to successfully automate business processes and calculation models using modern technology and languages. We are in the infancy stage of this initiative therefor this candidate will be empowered to bring ideas that will help shape the automation.

Responsibilities Include:

• Coordinate project tasks and streams, developing and maintain project timelines and management updates

• Document business requirements for reporting and processing changes

• Design, build and implement the most efficient solution based on the business requirements gathered

• Identify opportunities for process efficiency improvements

• Drive and coordinate user testing activities and providing training to end users

• Plan and execute data migration tasks

• Reconcile and validate migrated data and reports

• Provide functional user support on a day-to-day basis during implementation

• Act as a system “super user” helping others to leverage systems more effectively and establishing best practices across processes

Qualifications:

• Bachelor’s degree in accounting, finance or the equivalent combination of education and experience is required.
• 1-3 years of total work experience strongly preferred
• Strong Excel skills required with working knowledge of advanced excel functionality
• Real estate fund experience preferred

Please be advised that this is a pipeline requisition. Applying to this position demonstrates interest in current and future openings within the real estate portfolio analytics team.