Portfolio Data Analyst

Overview

• Collaborate with stakeholders to translate complex data insights into actionable intelligence for credit decisions and portfolio management.
• Leverage expertise in asset-based lending and borrowing base mechanics to support structured finance transactions and facility management.
• Generate comprehensive portfolio performance reports, borrowing base calculations, and covenant compliance analyses for financial facilities.
• Query large datasets using SQL and Python to identify portfolio trends and performance drivers.
• Develop ad-hoc analyses to support credit decisions and portfolio optimization initiatives.
• Collaborate with cross-functional teams to enhance cashflow models and portfolio monitoring processes.
• Identify opportunities to streamline reporting processes and improve stakeholder communication through automation.
• Foster a collaborative, team-driven culture built on integrity and accountability.

Key Responsibilities & Duties

• Generate portfolio performance reports, borrowing base calculations, and covenant compliance analyses for financial facilities.
• Provide analytical support for structured finance transactions, including securitizations and warehouse lending arrangements.
• Calculate and maintain accurate borrowing base positions across multiple facilities, ensuring compliance with eligibility criteria.
• Interface with lenders, rating agencies, auditors, and servicers to provide data-driven insights and facilitate reporting requirements.
• Query large datasets using SQL and Python to identify portfolio trends and performance drivers.
• Partner with Credit & Structuring teams to enhance cashflow models and portfolio monitoring processes.
• Support Operations team with borrowing base reconciliations and facility management activities.
• Identify opportunities to streamline reporting processes and improve stakeholder communication through automation.

Job Requirements

• Bachelor’s degree in Finance, Economics, Data Analytics, or related field; advanced degree preferred.
• Minimum 5 years of experience in asset-based lending, structured finance, or portfolio management.
• Proficiency in SQL, Python, and Excel for complex data querying and analysis.
• Experience with cloud data warehouses and data transformation tools.
• Strong understanding of borrowing base mechanics and securitization processes.
• Proven track record managing relationships with lenders, rating agencies, and external financial counterparties.
• Excellent communication skills to present complex data insights effectively.
• Commitment to data accuracy and regulatory compliance in reporting contexts.