Senior Portfolio Analyst
Hilco Real Estate Finance · Northbrook, IL · 1 mo ago
Sales$110k–$120k/yrFull-time
Responsibilities
- Lead the completion of Investment Onboarding Templates, coordinating with deal teams, accounting, and operations to obtain required approvals and ensure accurate setup of new investments within portfolio management and reporting systems.
- Own the ongoing maintenance and governance of the Security Master and Data Tape, including onboarding new investment attributes, maintaining data integrity, and documenting support for key portfolio changes such as risk ratings, accrual status, performance metrics, and profitability updates.
- Partner with IT and data teams to manage portfolio data architecture across Microsoft Lakehouse, Allvue, Oxane, and other systems, ensuring data mapping, business logic, and queries are properly configured and validated to support accurate portfolio-level and asset-level reporting.
- Collaborate with the Portfolio Reporting Team to support month-end, quarter-end, and year-end reporting processes, including position reporting, performance reporting, investor reporting, and ad hoc management reporting, while driving automation and process efficiencies.
- Own the Global Track Record reporting process, ensuring timely, accurate, and consistent performance reporting across all investment strategies and reporting cycles.
- Support monthly borrowing base reporting and collaborate with accounting on waterfall calculations and related fund reporting activities.
- Develop and maintain sophisticated financial models to support portfolio analytics, investment performance analysis, scenario modeling, forecasting, capital allocation decisions, and strategic initiatives.
- Perform complex financial, operational, and portfolio analyses to support business planning, risk management, investment decision-making, and executive reporting.
- Lead special projects and strategic initiatives as assigned by senior management, including process improvement efforts, system implementations, reporting enhancements, and cross-functional business initiatives.
Qualifications
- Bachelor’s degree in finance, Accounting, Data Science, Economics, or a related field.
- CFA preferred.
- 6+ years of finance and analytics experience with at least 2 years in the private credit sector.
- Minimum 2–3 years' experience with Microsoft Lakehouse, SQL Server, Power Query or similar systems, including query development.
- Advanced Excel and financial modeling capabilities.
- Must be familiar with financial models and tools used to determine project financial benefits and profitability such as: Net Present Value (NPV), Internal Rate of Return (IRR), Return on Investment (ROI).
- Experience with portfolio management, accounting, and reporting systems (e.g., Allvue, Oxane, Lakehouse environments, Power BI).
Pay
Annual base salary gross: $110,000 - 120,000.
Schedule
N/A
Benefits
Available benefits are based on eligibility. Our Total Rewards package includes a variety of medical and dental plans, vision coverage, disability and life insurance, 401(k) plans, and a robust suite of personal well-being benefits to support your mental health.