li>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. If interested apply online at www.bankofamerica.com/careers or email your resume to
bofajobs@bofa.com.