Track control performance — exception rates, false positives, resolution time, and automation coverage — and use it to prioritize ongoing improvements.
Maintain data lineage from reported figures to source systems.
Apply documented performance methodologies as testable logic, and propose a recommended treatment for edge cases (such as DPI netting, broken deals, and recycled capital) for the methodology owner’s decision.
Perform variance analysis and attribution, and explain the drivers of results in clear, documented narratives.
Governance & Controls
Run governance and control routines each reporting cycle, test their effectiveness periodically, and refine control design based on the results.
Maintain a living control inventory — what is checked, how often, and who is accountable — with supporting evidence.
Contribute to the Track Record Policy Change Operating Process, and update validation rules and regression tests for each approved change.
Work with Data Engineering on pipeline enhancements, test coverage, and release controls.
Partner with Compliance and Legal to support regulatory requirements for track record presentations, including the SEC Marketing Rule.
Maintain audit-ready documentation for internal reviews, external audits, DDQ responses, and LP inquiries.
Financial Analysis & Reporting Support
Provide the financial analysis behind investor reporting and DDQ responses, keeping figures and disclosures consistent across materials.
Maintain analytical models, reconciliations, and templates, and convert manual, repetitive steps into controlled, repeatable processes.
- Partner with Fund Accounting, FP&A, Portfolio Oversight, Investments, and Investor Relations to resolve discrepancies and align reported figures.
- REQUIRED QUALIFICATIONS:
- 3–6 years in performance measurement, fund accounting, FP&A, investment analytics, controls, or financial analysis. Experience in alternative investments is strongly preferred.
Working knowledge of performance metrics and methodologies, including IRR, TWR, MOIC, DPI, RVPI, TVPI, and attribution.
Proficiency in SQL for querying source data, reconciling outputs, and building automated validation checks.
Experience operating and improving automated reconciliation, data quality, or controls frameworks, or testing financial calculations.
Demonstrated ability to own a recurring reporting cycle (such as quarter-close) alongside a standing improvement backlog.
Strong financial analysis skills and advanced Excel.
- Attention to detail, a skeptical mindset, and clear communication — including explaining why a number moved.
- PREFERRED QUALIFICATIONS:
- Python or PySpark for validation logic; Databricks or a comparable lakehouse platform; Domo or another BI tool for control reporting.
Familiarity with version control, code review, and automated testing.
Alternatives, real estate, or infrastructure asset management experience, including quarter-close and investor-reporting cycles.
Exposure to FP&A, forecasting, or budgeting processes.
Familiarity with GIPS, NCREIF / PREA, INREV, ILPA, the SEC Marketing Rule, and DDQ processes.
- CFA Level I or II passed, or the CAIA designation (in progress or completed).
- EDUCATION:
- Bachelor’s degree in Finance, Accounting, Economics, or a related field.