Portfolio Management Analytics Analyst (San Antonio, TX) - Affinius Capital

Along with its affiliate companies, Affinius Capital invests across the risk spectrum for a global client base, managing over $64 billion in gross assets under management within a diversified portfolio across North America and Europe. Affinius Capital provides strategic equity and debt capital, including to capitalize on the accelerating demand for technology-driven real estate assets, to meet the critical need for housing solutions, and for other market and capital structure opportunities exhibiting compelling risk-return characteristics. For more information, visit affiniuscapital.com.

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.

• 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.

Affinius Capital complies with laws and regulations that permit certain requests related to your data in our files, including, but not limited to, the California Consumer Privacy Act (the “CCPA”). The Company's privacy policy and contact information for questions regarding your data or the policy may be found here. 

At Affinius Capital our employees enjoy generous benefits packages including comprehensive medical, dental and vision plans, 401k, educational and professional designation assistance, business casual dress attire and much more! Qualified applicants must successfully complete a pre-employment background 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.

Affinius Capital is an Equal Opportunity Employer. Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.