Portfolio Management Analytics Associate -or- Senior Associate Full Time

The Associate -or- Senior Associate will support all aspects of portfolio management’s analytical and reporting platform. The role is based in San Antonio and resides in the Portfolio Management Analytics (PMA) group that supports members of portfolio management across Affinius Capital’s corporate and regional offices. The role requires 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 to produce accurate information and proprietary tools that inform strategic decision making for the business. This is a critical role, reporting directly to the Head of Analytics/Portfolio Management Analytics and working closely with regional PMA team leads and members of Portfolio Management, Asset Management, Capital Markets, Development, and Corporate Finance.

Essential Duties:

• Support the Head of Analytics/Portfolio Management Analytics in managing the quarterly production of all investment, fund, and investor proprietary models and related historical and forward cash flows and metrics of the portfolio. This oversight includes (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 act as a subject matter expert in supporting the modeling requirements of the company broadly. 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 produce investment models, (iii) members of PMA and portfolio managers who produce fund models, and (iv) Corporate Finance and its Investor Service and Reporting and Performance Reporting teams that produce fund and investor track records and other corporate reporting.
• Enhance existing 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.
• 3-5 years of relevant experience developing Excel-based financial models for an institutional manager, preferably in private equity real estate.
• 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 Data Analysis Expressions (DAX) is a plus.

Source: Affinius Capital’s Career Page

Tagged as: Life Insurance Company, REPE Firm