Senior Associate in Portfolio Analytics

Position Senior Associate in Portfolio Analytics

Company Confidential

Location Texas

Reporting Relationship Senior Director, Portfolio Management, Analytics

Website

Company Background

The Company is the real estate investment management arm of a leading financial services company. By acquiring, developing, financing and managing quality real estate investments, the Company provides superior returns investing across the risk spectrum, with expertise in office, industrial, multi-family, retail and hotel assets.

Key Responsibilities

As an integral member of the Portfolio Analytics team, the Associate or Sr. Associate will work closely with the Company’s portfolio management, asset management, investor relations, and accounting teams, as well as senior leadership, to facilitate the investment decision making and operational processes. This position will be responsible for creating and maintaining various investment and fund-level models for insightful analytics, ongoing portfolio monitoring, forecasting, and ad-hoc support for multiple real estate private equity funds. Key responsibilities include:

• Review the deals and fees structures through terms sheet and model the deals and fees for investor presentations.
• Review historical performance against projections and present the reasons for variances.
• Assist with creation of department policies, procedures, and process documentation.
• Assist Performance Measurement, Attribution and Reporting (“PAR”) team with review of final quarterly performance calculations, populating data warehouses for asset and fund-level reporting, and performance attribution analysis.
• Closely interact with and assist the PAR and Global Investors Group (“GIG”) units in responding in a timely and accurate manner to ad-hoc client requests.
• Corroborate with the other team members on automations, efficiency improvement and thought leadership initiatives.
• Assist in preparation of white papers, thought leaderships and other publication material.
• Create, enhance, and maintain detailed fund models used for capturing historical asset and fund-level performance, projecting forward-looking operational performance, ensuring compliance with leverage restrictions, and calculating asset and fund-level metrics used in the investment decision making process.
• Provide new investment impact analysis (accretion/dilution of projected fund returns, leverage impact, distribution yield, etc.) to portfolio management team during the acquisition underwriting process.
• Create, enhance, and maintain fund-specific dashboards to summarize current portfolio positioning, historical performance, capacity for additional investment, and forward-looking operational and performance projections.
• Coordinate with accounting, treasury, asset management, portfolio management and legal teams to facilitate the operation of funds and separate accounts. Oversee cash management process, short-term borrowings and quarterly distribution process, among other things.
• Maintain upcoming “sources and uses” schedule of cash activity to ensure appropriate liquidity is maintained while keeping cash balances to a minimum. Keep portfolio management up to date on cash position and upcoming sources and uses.
• Review quarterly asset valuations and waterfall calculations; communicate performance impact of changes in asset valuations to portfolio management team.
• Provide quality control over financial transactions and financial reporting to ensure compliance with GAAP, tax, and necessary regulatory reporting requirements

Professional Experience/Qualifications

• Bachelor’s degree (BA/BS), in Finance/Economics/Business Administration/Accounting or related field.
• 3+ years of applicable hands-on professional experience, in a quantitative or analytic-based role.
• Real estate private equity, fund modelling, deal structuring, fees structuring, or private equity product control experience.
• Advanced Excel skills; experience creating forecasting and waterfall models with minimal supervision.
• Demonstrated ability to create detailed and dynamic forecast models, summarize the results, and effectively communicate to senior leadership and external clients.
• Progress towards or willingness to pursue the CFA or CAIA designations.
• Ability to work extended hours as needed.
• Ability to work in a highly collaborative team environment to achieve broader organizational goals.
• Strong project management and interpersonal skills, attention to detail and the ability to multi-task under recurring time constraints.
• Exceptional verbal and written communication skills.
• Highly proficient in Office applications, particularly Excel.
• Strong understanding of private equity fund structures and operations.
• Willingness and ability to take initiative and leadership role on key projects.
• Ability to prioritize assignments to meet numerous deadlines.
• Excellent analytical, quantitative and problem-solving skills.
• Anaplan, Hyperion, Alteryx, MS- BI or other Cognitive Software modelling and working knowledge preferred.
• Data Visualization skills in MS Power BI, Tableau etc. preferred.
• Qualifications may warrant placement in different job title.