Senior Associates, Portfolio Insights
Glocap Search, New York, NY, United States
Our client is a private equity firm headquartered in New York City specializing in secondary, primary and co-investment transactions.
They are seeking a Senior Associate to join their Portfolio Insights team. The team supports data integrity and reconciliation, internal and external reporting, cash and NAV projections, and the development of the Firm’s data lakehouse project and automation initiative, including process improvement and AI applications.
Reporting & Data Management:
Prepare and maintain recurring internal reports and dashboards related to portfolio performance, exposure, pacing, and liquidity. Support quarterly and ad hoc investor reporting packages, including IRR, TVPI, DPI, and cash flow summaries. Aggregate and reconcile capital account data across fund investments, GP-led deals, and structured transactions. Assist in the preparation of fund-level performance tracking and benchmarking materials. Operational Support & Cross-Functional Coordination
Work closely with investment, IR, and technology teams to ensure alignment on portfolio data, fund metrics, and investor deliverables. Participate in systems integration, data warehousing, and digital transformation initiatives. Automation & Process Enhancement
Design and implement automated solutions to reduce manual processes in reporting, reconciliation, and data validation. Collaborate with internal teams to migrate data into centralized platforms and enhance data accessibility (e.g., Power BI dashboards). Maintain and enhance workflows that connect data sources such as Investran, eFront, and fund admin reports. Build dynamic Excel models and reporting templates using VBA, Power Query, and/or Python. Qualifications
3-5 years of experience in fund accounting, reporting, fund administration, or alternative asset operations. Advanced Excel skills, including Power Query, pivot tables, and complex formula design. Preferred hands-on experience or demonstrated interest in automating reporting processes using Power BI, VBA, Python, or SQL. Strong understanding of accounting, performance reporting, and private equity fund mechanics. Detail-oriented with a strong ownership mindset and ability to manage multiple tasks. Demonstrated ability to work both independently and collaboratively within a team environment. Excellent analytical and problem-solving skills with significant attention to detail
#J-18808-Ljbffr
Prepare and maintain recurring internal reports and dashboards related to portfolio performance, exposure, pacing, and liquidity. Support quarterly and ad hoc investor reporting packages, including IRR, TVPI, DPI, and cash flow summaries. Aggregate and reconcile capital account data across fund investments, GP-led deals, and structured transactions. Assist in the preparation of fund-level performance tracking and benchmarking materials. Operational Support & Cross-Functional Coordination
Work closely with investment, IR, and technology teams to ensure alignment on portfolio data, fund metrics, and investor deliverables. Participate in systems integration, data warehousing, and digital transformation initiatives. Automation & Process Enhancement
Design and implement automated solutions to reduce manual processes in reporting, reconciliation, and data validation. Collaborate with internal teams to migrate data into centralized platforms and enhance data accessibility (e.g., Power BI dashboards). Maintain and enhance workflows that connect data sources such as Investran, eFront, and fund admin reports. Build dynamic Excel models and reporting templates using VBA, Power Query, and/or Python. Qualifications
3-5 years of experience in fund accounting, reporting, fund administration, or alternative asset operations. Advanced Excel skills, including Power Query, pivot tables, and complex formula design. Preferred hands-on experience or demonstrated interest in automating reporting processes using Power BI, VBA, Python, or SQL. Strong understanding of accounting, performance reporting, and private equity fund mechanics. Detail-oriented with a strong ownership mindset and ability to manage multiple tasks. Demonstrated ability to work both independently and collaboratively within a team environment. Excellent analytical and problem-solving skills with significant attention to detail
#J-18808-Ljbffr