Liquid Credit, Portfolio Analytics / Portfolio Optimization (CLO) – Vice President / Principal

Responsibilities

• Portfolio monitoring & daily/weekly analytics
• Produce and maintain daily/weekly portfolio snapshots, dashboards, and KPI packs for PMs/traders (exposures, concentrations, collateral quality, tests, price/rating moves, watchlist signals).
• Reconcile inputs across trustee reports, internal systems, and market data; ensure data integrity and “one version of truth.”
• Track CLO compliance tests and structural triggers; proactively flag potential issues before they become binding constraints.
• Optimization, trade support & scenario analysis
• Run pro-forma / hypothetical trade analysis and communicate impacts on OC/IC tests, WARF/WAS/WARF cushion, concentrations, CCC buckets, and other indenture constraints.
• Partner with PMs and trading to propose optimization ideas (relative value, risk reduction, par build, liquidity management).
• Support new issue, reset, refi, and warehouse ramp processes with reporting/tie-outs and trade testing.
• Tooling, automation & data mining
• Build, enhance, and automate Excel-based portfolio tools (Power Query, Pivot/Power Pivot, advanced formulas, VBA where helpful) and/or integrate with BI dashboards.
• Design repeatable workflows for ingesting, cleaning, and mapping large datasets (loan terms, ratings, pricing, exposures, test data) and reducing manual steps.
• Peer / manager comparisons & investor analytics
• Create benchmarking views to compare portfolios vs peer managers/vehicles (risk posture, quality metrics, concentrations, tail risk, trading cadence, performance drivers) and respond to ad hoc investor and internal questions quickly with data.
• Stakeholder management
• Act as a connective hub across PMs, trading, operations/middle office, legal/structuring, and tech/data teams to ensure analytics are accurate, scalable, and decision-useful.

Qualifications

• 7+ years of total professional experience within structured finance, credit, or related fields.
• 3-7 years of direct CLO experience, ideally in a collateral manager, trustee, auditor, middle office, ratings, structuring/trading support, or valuation seat.
• Strong understanding of CLO structures and portfolio test mechanics; ability to interpret governing docs and translate into a model/checklist.
• Advanced Microsoft Excel: large dataset manipulation, modeling, automation (Power Query/Power Pivot preferred; VBA helpful).
• Utilized AI tools (e.g., Claude) to aggregate and analyze unstructured data, supporting portfolio construction, stress testing, and ongoing risk surveillance.
• Proven experience producing portfolio reporting (weekly/monthly/quarterly) and reconciling trustee / system outputs.
• Strong written/verbal communication—can synthesize complex trade/test impacts into clear “so what” recommendations.
• Hands-on with common CLO / loan / cashflow tooling (Intex, CDO Suite/Solvas, WSO, Nexus, Bloomberg data extraction).
• SQL and/or Python for data processing, automation, and repeatable analytics.
• Bi/dashboard experience (e.g., Power BI) and ability to publish executive-ready views and self-serve analytics.
• Experience building internal tools/reports specifically to facilitate daily monitoring, optimizations, and hypothetical tests in partnership with PMs/traders.

Pay

The base annual salary range for this Connecticut-based position will be $200,000 to $250,000. Actual salary offered will be based on the candidate’s skill, experience, and qualification for the role.

Schedule

The Role is in office Monday to Thursday.