Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Accountant I Accounting Clerk Retirement Accountant Accounting Specialist 2 Accountant I STAFF ACCOUNTANT Entry Level Accounting Associate Senior Accountant General Accountant Accounting Clerk - Villa Florence Staff Accountant General Accountant III Finance Clerk Accounting Technician I Accounting Specialist - Accounting Accounting Associate Auditor Accounting Analyst Staff Accountant Associate Financial Analyst Associate Financial Analyst Financial Assistant - UMHC-Sylvester ACCOUNTANT II - 64051015 Senior Accounts Payable Specialist Senior Tax Records Specialist Staff Accountant General Accountant II STAFF ACCOUNTANT III Accounting Assoc A Staff Accountant Accountant Staff Accountant Accountant IV Supervisory Accountant Accountant Staff Accountant Accounting Manager Staff Accountant Budget Analyst II Entry Level Cost Accountant Property Accountant Accountant CONTROLLER-ASSISTANT Controller Accountant Accountant Accountant 1 TDHCA - Staff Accountant Senior Accountant - Grants Accountant-MTG Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Two Sigma Aecom WeWork Exact Media Aerotek Jane Street Doordash First Convenience Bank AsteroidX Shopify Insight Global AT&T Hatchways Creative Circle Borrowell Square Amazon Flex Clickworker Instacart Vector Marketing Recovhub Walgreens LowCostWebDesignFirm.com American Income Life Scotiabank 51talk TD Bank Microsoft Akira UnitedHealth Group Paylocity Top Hat CI&T Desjardins mappedin Checkout 51 Mobeewave GoParkr The Youth Connection Peel Regional Police Hootsuite autoTRADER.ca ScribbleLive SnapTravel Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Portfolio Analyst, Real Estate At AIMCo Canada

Location: Edmonton, Alberta

Job Description

This Portfolio Analyst Position will support the Manager, Portfolio Management on the real estate portfolio management functions within the real estate team, covering both internal and external investments, direct, co-investments, equity, debt and fund real estate investment assets. The Portfolio Analyst will support the broader Real Estate Investment Team by completing investment management reports through:

  • Electronic platforms such as YARDI Voyager, YARDI VoyagerPlus (Orion BI, InvestorPlus, and Orion Document Management), ARGUS Enterprise and Developer, and Microsoft Power BI
  • YSR or SSIS generated excel templates for MSCI Benchmark & IRIS reporting; Investment Asset and Portfolio level reporting; and
  • AIMCo Board and/or Client Real Estate Reports
  • Unlocking insights from both internal and external real estate data sources into actionable information/intelligence to enhance real estate team investment management decisions


Additionally, the Portfolio Analyst will manage Liquidity Forecast and provide information supporting FX program for the Foreign Real Estate program.

Responsibilities Include:

  • Developing real estate investment management & performance metrics, investment reporting and investment data analytics to support a multi platform (such as MS Power BI, Orion BI and InvestorPlus) real estate BI level dashboards by geography, investment type, Investment Management team, Asset Manager, Strategy, and Pool to be updated on a monthly, quarterly and annual basis
  • YARDI Orion document management that includes all property closing digital documents along with Financing digital document details associated with each property accessible through the property level dashboard
  • Populating current and historical data series into YARDI Voyager for VoyagerPlus (Orion BI and InvestorPlus) using Excel VBA macro generated ETLs, SSIS package produced ETLs, and ARES & manually developed/populated ETLs via FTP
  • Using ARGUS Enterprise property and portfolio information to update YARDI Voyager for the VoyagerPlus platform
  • Updating YARDI Voyager property and investment level Entities & Attributes as required and setup/execute YSR or SSRS generated excel based reports as required
  • Real Estate data analytics for actionable information/intelligence and insights
  • Quarterly MSCI REALpac and MSCI IRIS submissions, review and signoff; and reports
  • Liquidity management and FX exposure
Our Ideal Candidate
  • Strong academic credentials from a leading University; Bachelor’s Degree in Business, Mathematics, Finance, Real Estate or related field
  • Minimum of 2-3 years’ experience in a similar role at a leading real estate organization, private equity fund or investment bank
  • Ability to autonomously prepare and present reports and presentations in an articulate manner to senior management
  • Experience with YARDI, Excel VBA macros, SSIS, SSRS/YSR, SQL, ARGUS Enterprise and SImCorp (SCD)/DataMart
  • High degree of attention to details and ease with large data sets
  • Creative problem solving and ability to translate data patterns into real estate business insights, cause/effect relationships and variables to increase predictive power of current and new models
  • Strong Real Estate acumen
Application Instructions

NOTE: Final candidates will be asked to undergo a security screening, which includes a credit bureau and a criminal record investigation, the results of which must be acceptable to AIMCo.

We thank all applicants in advance; however, only individuals selected for interviews will be contacted.

For more information and to apply, visit the careers section of AIMCo’s website at www.aimco.alberta.ca