Hedge Fund Data and Reporting Analyst
Analytic Recruiting Inc. - new york city, NY
Apply NowJob Description
A Manhattan-based hedge fund is seeking an Investment Reporting Data Analyst. It's a Data AnalystReporting role that will work with the firm's existing database and currenthistorical fund information (mostly in Excel) to generate reports for the firm's Investor Relations Team (largely for investor consumption) and for the Investment Team (for their internal reports - e.g., exposure, etc.). CANDIDATES MUST HAVE 5+ YEARS OF HEDGE FUND OR CREDIT FUND EXPERIENCEResponsibilities:Create and generate monthly and quarterly financial data reports for private equity and credit fundsWill work with a new SQL-based database and a legacy Excel-based database to generate investment reports as well as responding to ad-hoc requests for investment informationUnderstand all aspects of the firms' complex investments (bank loans) to create reports that cover: performance attribution, sector concentration, investment positions, IRR analysisRespond to Investor Relations requests for risk exposure, performance attribution, and concentration riskWill work on performance analysis and reports, fund valuation, waterfall calculations, and fund feesWill work with technology to develop KPI dashboards that provide timely analysis of fund performanceWork with technology to improve (automate) legacy Excel reporting processes to respond to investors' requests for data and performance detailsRequirements:Must have 5+ years working as a fund performance or portfolio reporting analyst with a firm that has complex and illiquid private equity and credit investmentsMust have domain knowledge: deep understanding of how a complex credit investment fund worksMust have proven experience working with both SQL and Excel-based financial information databasesMust have data analysis technical skills: Excel, VBA, SQL, PythonMust have advanced Excel skills and experience with financial reporting softwareMust have experience using business intelligence and data visualization tools, Tableau. LookerPrefer a master's degree in a quantitative field, statistics, or finance degree. Fund Accounting academic work is preferredPreference will be given to candidates who have strong statistical and data skills for insightful analysisThe role requires superior oral and written communication skills and the ability to deliver complex information in written and oral presentation forms.Keywords: Bank Loans, Domain Knowledge, Data Engineer, Data Process, Fund Performance, Excel, VBA, SQL Query, Python, Reporting, DashboardsPlease send your resume to Jim Geiger
Created: 2024-10-05