Risk & Reporting Analyst – Alternative Investments, Portfolio Analytics & Excel/SQL
Core
Analyze portfolio data, calculate alternative-investment performance metrics, and prepare reporting outputs for private credit and private equity funds.
Role type
Senior IC Risk & Reporting Analyst (Alternative Investments)
Builds
Recurring investor reports, portfolio analytics dashboards, and performance attribution outputs.
Domain
Asset Management / Alternative Investments
Required skills
Excel (Power Query, pivot tables), SQL, Power BI, Data Validation, Investment Reporting Workflows
Preferred skills
Python, GenAI Prompt Engineering, Azure/Microsoft Fabric, Jira/Confluence, eFront-style platforms
Technologies
Excel, SQL, Power BI, Python, Azure, Microsoft Fabric, Jira, Confluence, eFront
Responsibilities
Prepare and validate recurring investment reporting outputs; Analyze portfolio exposure and performance metrics (TWR, IRR, MOIC); Investigate data exceptions and calculation differences; Maintain reporting logic and control documentation; Support portfolio analytics across private credit and equity; Collaborate with investment, operations, and risk teams.