Portfolio Management and Analytics Associate (New York)

USAA Real Estate, in a strategic partnership with Square Mile Capital Management, LLC, is seeking to hire a full-time Associate in their Portfolio Management and Analytics team in the New York office.

As an integral member of the Portfolio Management and Analytics team, the Associate will work closely with USAA Real Estate's and Square Mile's portfolio management, asset management, investor relations, accounting and the senior leadership to facilitate the investment decision making and operational processes. This position will be responsible for the product control, finance, and operations of the funds by 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, with a primary focus on the Square Mile series of opportunistic and credit funds.  

Essential Duties:

• Create, enhance, and maintain detailed fund models used for capturing historical asset, fund-level and investor-level performance, projecting forward-looking operational performance, ensuring compliance with leverage restrictions, and calculating investment and fund-level waterfalls and metrics used in the investment decision making process.
• Coordinate with accounting, treasury, asset management, loan servicing, capital markets, 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 through maintaining upcoming “sources and uses” schedule of cash activity to ensure appropriate liquidity is maintained while keeping cash balances to a minimum.
• Assist with investment modeling for complex structured transactions. 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.
• Preparation of final quarterly performance calculations, populating data warehouses for asset and fund-level reporting, and performance attribution analysis.
• Review quarterly asset valuations and waterfall calculations; communicate performance impact of changes in asset valuations to portfolio management team.
• 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.

• Bachelor’s degree (BA/BS), preferably in Finance/Economics/Business Administration/Accounting or related field.
• 3+ years of applicable hands-on professional experience, preferably in a quantitative or analytic-based role. Real estate private equity, fund modelling, deal structuring, or fees structuring experience required. 
• 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.
• Must be able to legally work in the U.S. without requiring sponsorship from the employer. 

Key Competencies:

• Ability to work in a highly collaborative team environment to achieve broader organizational goals.
• Strong project management skills and interpersonal, 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.
• Qualifications may warrant placement in different job title.

Physical Requirements:

• Regularly required to sit for extended periods of time; frequently required to stand, walk, and use business equipment daily such as computer, copier, fax, telephone, etc.; frequently required to reach overhead, bend, and lift objects of up to 25 lbs.
• Ability to handle stress caused by multiple priorities, and other unforeseen situations associated with the organization.
• Eyesight and hearing must be correctable to standard level.

At USAA Real Estate our employees enjoy generous benefits packages including comprehensive medical, dental and vision plans, 401k, USAA Membership eligibility, educational and professional designation assistance, business casual dress attire and much more! Qualified applicants must successfully complete a pre-employment background and drug screen.  The above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.

USAA Real Estate is an Equal Opportunity and Affirmative Action Employer of Females, Minorities, Veterans and Disabled.