Summary
Seeking a Portfolio Reporting Associate to join our client’s Private Debt Operations Team!
Company Information:
Our client is a leading Alternative Investment Manager!
Job Description:
- Maintain and improve data integrity, run regular data screens, and educate team members across departments to ensure adherence to data entry best practices
- Coordinate projects with IT to develop reports and workflows to improve quality and control of data for reporting and analysis
- Identify and implement operational improvement opportunities to maximize efficiency and build a scalable foundation for growth
- Utilize current portfolio reporting systems and models to execute data extraction, aggregation and standardization
- Assist in data consolidation and migration for system implementations
- Facilitate new reporting requests that help to monitor the performance of the portfolio
- Collaborate with investment team to identify and define relevant data metrics
- Execute operational improvements. Coordinate with finance, and IT to refine centralized databases and business intelligence processes to improve quality and control of data for reporting and analysis.
- Analyze investment performance and draft reports to prospective and existing limited partners in response to due diligence requests
- Compile investment data to complete templates requested by investors
- Support preparation of quarterly/annual investment updates and portfolio company write-ups for communication to investors
- Gross and net portfolio return attribution and comparative benchmark analysis
- Update monthly return and performance metric files for internal and external reporting
- Develop and convey executive level summaries and recommendations as needed
- Prepare and execute weekly and monthly reporting packages
Requirements / Qualifications:
- 3-6 Years Data Analysis or Transformation Experience
- SQL, Python, PowerBI, Snowflake, Anaplan, BMS, ilevel, Dynamo, or Tabular Experience is Required
- Experience with data warehouses, semantic modeling and business intelligence a plus
- CPA or CFA is a plus (not required)
