Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Service Sales Representative Sales Representative Part Time Sales Sales Representative Service Sales Representative Product Tester at Home Customer Service - Work from Home Service Product Tester at Home Service Product Tester at Home Bilingual Customer Service - French and In-Home Usage Tester Customer Service - Work from Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Customer Service - Work from Home Sales Representative In-Home Usage Tester Service Bilingual Customer Service - French and In-Home Usage Tester Line Cook Customer Service - Work from Home Customer Service - Work from Home Service client In-Home Usage Tester Customer Service - Work from Home Product Tester at Home Product Tester at Home Product Tester at Home Customer Service - Work from Home Product Tester at Home In-Home Usage Tester In-Home Usage Tester Product Tester at Home In-Home Usage Tester Product Tester at Home In-Home Usage Tester In-Home Usage Tester Service client Product Tester at Home Bilingual Customer Service - French and In-Home Usage Tester Product Tester at Home Product Tester at Home Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Two Sigma WeWork Aecom Exact Media Aerotek Jane Street First Convenience Bank Doordash AsteroidX AT&T Shopify Insight Global Creative Circle Hatchways Clickworker Borrowell Square Vector Marketing Amazon Flex LowCostWebDesignFirm.com Walgreens Recovhub Instacart American Income Life Scotiabank 51talk TD Bank Akira Microsoft Paylocity UnitedHealth Group Top Hat CI&T mappedin Desjardins Checkout 51 Mobeewave The Youth Connection GoParkr Peel Regional Police Hootsuite autoTRADER.ca Xiaomi ScribbleLive SnapTravel 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