Must include 5 years of experience in each of the following:Analyzing structured credit portfolios including ABS, CLO and RMBS to assess risk, exposure, and performance trends using Excel VBA and SQL to identify credit deterioration, monitor covenant compliance;Writing complex queries to aggregate loan-level data and generate insights for senior management using SQL to support portfolio management, risk reporting, and regulatory deliverables;Automating reporting workflows for portfolio, and compliance deliverables using tools like Excel VBA to streamline recurring tasks, reduce manual errors and improve turnaround time for internal and external reporting;Assessing business needs and translating them into technical specifications, testing system enhancements, and implementing process improvements to support credit portfolio management in collaboration with multiple cross-functional teams;Applying advanced Excel techniques including Power Query, Macros, and Pivot Tables for data analysis, modeling, and reporting, including building dynamic dashboards, scenario analysis tools, and automated templates for portfolio monitoring; and,Integrating data across multiple systems by leveraging common identifiers including loan or facility ID to unify disparate data attributes and risk metrics, enabling a complete and consistent dataset for accurate portfolio analysis, reporting, and decision-making. Interface with Credit Officers and the ABS business to ensure that key features, trends, and risks in the ABS lending portfolio are reflected in the reporting framework, including reviewing loan tapes and repline data.