Job Title: Data Investment Analyst
Job Description
- Prepare and maintain monthly investment reports, including account allocation reports and data mart files, ensuring accuracy and timely delivery.
- Perform data reconciliations by validating and reconciling investment, portfolio, and financial data across multiple systems to ensure completeness, consistency, and accuracy.
- Analyze investment portfolio data by monitoring actual investment exposure against target allocations and identifying variances.
- Reconcile private investment portfolio data, including balances, commitments, unfunded commitments, credit spreads, and other key financial metrics.
- Collect, validate, and consolidate large volumes of data from multiple internal and external sources, including investment management systems, loan administrator statements, and Excel-based reports.
- Develop and maintain reports, dashboards, and data models using Advanced Excel and Power BI to support investment analysis and business decision-making.
- Investigate and resolve data discrepancies while ensuring data integrity and compliance with internal reporting standards.
- Identify reporting inefficiencies and recommend process improvements through automation and data analytics.
- Collaborate with investment, finance, operations, and other cross-functional teams to support reporting requirements and improve data quality.
Qualifications
- Bachelor's degree in Accounting, Finance, Economics, Mathematics, Statistics, Data Analytics, or a related field.
- Minimum of 5 years of experience in investment data analysis, financial analysis, investment operations, asset management, private equity, investment banking, or a similar analytical role.
- Strong experience in data reconciliation, financial data validation, and investment reporting.
- Advanced proficiency in Microsoft Excel, including PivotTables, Power Query, Power Pivot, XLOOKUP, INDEX-MATCH, and complex formulas.
- Hands-on experience with Power BI, including dashboard development, data modeling, and visualization.
- Experience working with investment platforms such as Aladdin, Wall Street Office (WSO), Bloomberg, or similar investment systems is highly preferred.
- Strong analytical, problem-solving, and critical thinking skills with exceptional attention to detail.
- Excellent communication and stakeholder management skills with the ability to work in a fast-paced, data-driven environment.
- Proven ability to work with large datasets, perform complex reconciliations, and transform financial data into meaningful business insights.
