Hedge Fund SQL Data Analytics and Reporting Analyst

Analytic Recruiting - New York, NY

Full-time - Mid Level

New York, NY

Professional, Scientific, and Technical Services

About the position

This position is for a Fund Performance or Portfolio Reporting Analyst with a focus on generating financial data reports for private equity and credit funds. The role involves working with both SQL and Excel-based databases to create investment reports and respond to ad-hoc requests. The analyst will need to understand complex investments, perform performance analysis, and develop KPI dashboards to enhance fund performance analysis.

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.
• Work on performance analysis and reports, fund valuation, waterfall calculations, and fund fees.
• Collaborate with technology to develop KPI dashboards that provide 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 degree.
• Fund Accounting academic work is preferred.
• Strong statistical and data skills for insightful analysis.