Fundamentals Capital Structure Analyst
Core
Build and maintain Excel-based capital structure models for debt issuers, calculate credit metrics, and ensure data quality across the coverage universe.
Role type
Junior IC financial data analyst (capital structures)
Builds
Excel-based capital structure models and credit metrics
Domain
Financial services / Credit markets
Required skills
Financial statement analysis, Capital structure mechanics, Credit metrics calculation, Excel modeling, Data quality assurance
Preferred skills
AI tool usage for workflow automation, Ad hoc data improvement projects
Technologies
Excel
Responsibilities
Analyze financial reporting documents (earnings reports, offering memorandums, credit agreements), Prepare detailed financial models focusing on debt instruments and facility terms, Build and maintain capital structures quarterly or monthly, Participate in ad hoc projects to improve data quality
