Quick overview
Job description
The Financial Data Analyst owns the ongoing integrity of the financial and performance data CIM relies on for investor reporting, internal decision-making, and business planning. To start, the scope of data for this position will include investment performance across CIM’s funds, separately managed accounts, and co-investment vehicles, and will extend over time to other financial analytics such as FP&A, forecasting, and fund accounting outputs. Metrics are produced through automated processes; the Financial Data Analyst is accountable for every reporting cycle’s controls that keep them accurate. This role will continuously improve control coverage and automation as funds, methodologies, and the data platform evolve. The Financial Data Analyst owns validation logic and control operation and will partner closely with Data Engineering as the primary owners of pipeline infrastructure. This is a hands-on, analytical and technical role for someone with expertise in financial and performance data in alternative investments and an explicit interest in leading ongoing governance and controls.
KEY RESPONSIBILITIES:
- Own automated validation of performance metrics (IRR, TWR, MOIC, DPI, RVPI, TVPI) across funds, SMAs, and co-investment vehicles, running and monitoring controls every reporting cycle.
- Extend the control framework to additional financial analytics — including budgets, forecasts, cash projections, and fund accounting outputs.
- Maintain validation rules and tolerances — reasonableness checks, variance thresholds, cross-metric consistency (for example, DPI + RVPI = TVPI), and independent recalculation — and recalibrate them as exception patterns and structures change.
- Operate automated reconciliations to NAV, general ledger, and capital accounts; manage exceptions to resolution and fix the root causes of recurring issues.
- 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.
- 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.
- 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.
Data Validation & Continuous Control Improvement
Governance & Controls
Financial Analysis & Reporting Support
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.
- A variety of Medical, dental, and vision benefit plans
- Health Savings Account with a generous employer contribution
- Company paid life and disability insurance
- 401(k) savings plan, with company match
- Comprehensive paid time off, including: vacation days, 10 designated holidays, sick time, and bereavement leave
- Up to 16 hours of volunteer time off
- Up to 16 weeks of Paid Parental Leave
- Ongoing professional development programs
- Wellness program, including monthly and quarterly prizes
- And more!
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
