Hedge Fund Data Analytics and Reporting Analyst

$140,000 - $175,000/Yr

Analytic Recruiting - New York, NY

Full-time - Mid Level

New York, NY

Professional, Scientific, and Technical Services

About the position

The Investment Data Analytics and Reporting Analyst position at a Manhattan-based hedge fund focuses on generating and analyzing financial data reports for private equity and credit funds. This role involves working with both SQL and Excel databases to support the Investor Relations and Investment Teams by providing insights into fund performance, risk exposure, and investment positions. The analyst will play a crucial role in enhancing the firm's data analytics and reporting capabilities.

Responsibilities

• Create and generate monthly and quarterly financial data reports for private equity and credit funds
• Work with a new SQL-based database and a legacy Excel-based database to generate investment reports and respond to ad-hoc requests for investment information
• Understand all aspects of the firm's complex investments (bank loans) to create reports covering performance attribution, sector concentration, investment positions, and IRR analysis
• Respond to Investor Relations requests for risk exposure, performance attribution, and concentration risk
• Conduct performance analysis and reports, fund valuation, waterfall calculations, and fund fees
• Collaborate with technology to develop KPI dashboards for timely analysis of fund performance
• Improve (automate) legacy Excel reporting processes to respond to investors' requests for data and performance details

Requirements

• 5+ years working as a fund performance or portfolio reporting analyst with a firm that has complex and illiquid private equity and credit investments
• Deep understanding of how a complex credit investment fund works
• Proven experience working with both SQL and Excel-based financial information databases
• Data analysis technical skills: Excel, VBA, SQL, Python
• Advanced Excel skills and experience with financial reporting software
• Experience using business intelligence and data visualization tools, such as Tableau and Looker

Nice-to-haves

• Master's degree in a quantitative field, statistics, or finance
• Strong statistical and data skills for insightful analysis