Portfolio Management Analytics Analyst (San Antonio, TX) Full Time

The Real Estate Portfolio Management Analytics (“PMA”) Analyst will support all aspects of portfolio management’s analytical and reporting platform across Affinius Capital’s global real estate equity and debt investments. The role is based in San Antonio. The successful candidate will possess advanced analytical skills and competency working in Excel with large datasets, exceptional attention to detail, process and change management acumen, and the ability to work cross-functionally. The proprietary tools produced by the role will deliver accurate information that inform strategic decision making for the business across various property types, including industrial, multifamily, data centers, retail, and office, across the risk spectrum from ground-up development to core acquisitions. This is a critical role that reports directly to the PMA-San Antonio Lead, and works closely with the Chief of Staff, members of Portfolio Management, Asset Management, Capital Markets, Development, and Corporate Finance.

Essential Duties:

• Support the production of all investment, fund, fund of fund, and investor Excel-based, proprietary models. This support includes oversight of (i) the production of the quarterly analytical calendar, (ii) the management of the population of investments, (iii) the initialization of the current quarter’s proprietary models, and (iv) the orchestration of business processes across multiple departments and regional offices of Affinius Capital necessary to bring about the quarterly reforecasts.
• Support the ongoing modeling needs of PMA and the broader platform and act as a subject matter expert in supporting all proprietary models and tools. This requires working closely with members of (i) IT who assist with model automation and connectivity to data sources, (ii) Asset Management and its Model Advisory Group who collectively act as primary user of investment models, (iii) members of PMA and portfolio managers who produce and use the fund and fund of fund models, and (iv) Corporate Finance and its Investor Service and Reporting and Performance Reporting teams that produce all track records and other corporate reporting.
• Continually assess the need for improvement across proprietary models and build additional Excel-based models and related tools as required. These builds require proven knowledge of and experience in using Excel macros and VBA, advanced formulas, conditional formatting, pivot tables, and data simulations.
• In addition to supporting the quarterly oversight of the production of all proprietary models, the role will respond to ad-hoc requests from portfolio managers, Corporate Finance, officers of the company, and investors, all of whom may require sensitivities and scenarios be performed.
• Define, publish, and reconcile the company’s population of investments, adjusting for new and sold investments as such transactions arise, and ensure all investments are accounted for in the analytics performed.
• Provide thought-leadership around the design of all analytical tools and the supporting infrastructure that connects those tools with external data sources and systems.
• Help design and implement reporting solutions that meet the needs of business consumers, including portfolio managers, development heads, investors and corporate leadership by leveraging existing PowerBI capabilities and exploring alternative reporting solutions at the appropriate time.
• Embrace team-oriented culture and exercise partnership skills in liaising with stakeholders across departments and regional offices.
• Coordinate with members of the Compliance team to establish and maintain necessary disclosures around analytical work product.
• Additional duties as assigned.

Requirements

• Bachelors degree from an accredited university, preferably with an emphasis in a quantitative field of study, such as Finance, Mathematics, Data Science, or related field.
• 0-3 years of relevant experience developing Excel-based financial models.
• Advanced proficiency and proven experience in Excel (macros, VBA, advanced formulas, pivot tables, conditional formatting, data simulations).
• Attention to detail is a must, as are strong communication skills and a high degree of emotional intelligence.
• Strong organizational skills are required.
• Self-starter; capable of developing and meeting deadlines in a fast-paced environment.
• Willing to work onsite full-time.
• Qualifications may warrant placement in a different job title.

Key Competencies:

• Ability to prioritize assignments to meet several deadlines.
• Excellent analytical, quantitative, and problem-solving skills.
• Exceptional written and verbal communication skills.
• Advanced skill in Excel and Word applications.
• Experience with Yardi, Argus, and Chatham is a plus.
• Working knowledge of Power BI and Data Analysis Expressions (DAX) is a plus.

Source: Affinius Capital’s Career Page

Tagged as: Life Insurance Company, REPE Firm