Overview
The organization is seeking a detail-oriented Data & Accounting Contractor to support the onboarding of historical investment data following the acquisition of a large client. This role will focus on cleaning, organizing, reconciling, and migrating historical data while developing Excel-based reporting and tracking tools.
Responsibilities
- Clean, organize, and reconcile historical private equity investment data.
- Map historical capital calls, distributions, valuations, and investment cash activity for migration into AltPro.
- Reconcile historical data to fund administration records and financial statement support.
- Import and validate data within AltPro.
- Roll forward historical activity through September 2026.
- Build and maintain Excel workbooks to track expenses, variances, NAV activity, cash projections, and management/incentive fees.
- Create templates and reporting tools using formulas, Power Query, and potentially VBA/macros.
- Identify and resolve data discrepancies, gaps, and inconsistencies.
- Maintain clear documentation and audit trails throughout the onboarding process.
- Follow all applicable data security, NDA, and SOC 2 requirements.
Requirements
- Experience working with private equity investment data or investment management is required.
- Strong accounting and financial data reconciliation skills.
- Advanced Excel skills, including SUMIF/lookup formulas, Power Query, and data manipulation.
- Experience building a complex workbook or financial model from scratch.
- Strong attention to detail and the ability to work with large, disorganized datasets.
- Ability to work independently and troubleshoot data issues.
Preferred Qualifications
- VBA/macro experience is a plus, but not required.
- Investran experience is highly preferred but not required.