Utilize data exploration and advanced spreadsheet/technical skills to monitor portfolio performance and report results to senior management.
Summarize findings, develop recommendations and present analyses to management in a clear, concise, convincing, and actionable format.
Employ best practices of data analysis and validation to ensure data results are accurate.
Promote innovative ways to visualize and digest complex data.
Create and maintain organized, efficient, and repeatable processes for monitoring portfolio performance.
Proactively monitor and report relevant changes in portfolio performance to management.
Conduct ad hoc research projects incorporating project design, data collection and analysis, summarization of findings, and presentation of results.
Work directly with internal customers (management) to create/adjust reports to effectively communicate portfolio performance.
Requirements
Demonstrated understanding of data exploration, analysis and visualization, quantitative and analytical methods, and sophisticated reporting techniques.
Advanced with Microsoft Excel, PowerPoint, and Word.
Experience with data analysis and spreadsheet modeling and/or reporting.
Experience with coding (SAS or SQL preferred) for data exploration and transformation in a data warehouse environment.
Experience with data visualization software such as Power BI, Tableau, SAS Visual Analytics or Cognos Analytics is preferred.
Demonstrated quantitative skills.
Acute attention to detail.
Effective written and verbal presentation skills.
Capable of managing multiple projects, including ability to coordinate and balance numerous tasks in a time-sensitive environment, under pressure, meeting deadlines.
Ability to identify and understand business issues and map them into quantitative questions.
Understanding of the metrics utilized in monitoring the performance of a consumer lending portfolio is a plus.
Tech Stack
Cognos
SQL
Tableau
Benefits
401K matching
bonding leave for new parents (12 weeks, 100% paid)