CRA Data Analyst

Job description

SUMMARY: The CRA Data Analyst will assist in the execution of the Bank's Compliance Program, with an emphasis on Community Reinvestment Act (CRA) data collection, analysis, and reporting. ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned. - Extracts CRA-related data from multiple bank data sources, including lending, deposit, and investment systems. Uses specialized software (RiskExec and Kadince) to organize and manage large datasets. - Maintains CRA-related data in an automated compliance database system and uses the system to produce multi-dimensional (time series and geographical) tables and graphs in support of CRA performance and CRA public file data. - Creates and maintains clear and effective reports, spreadsheets, dashboards, and data visualizations for internal committees, senior management, and regulators using Excel, Tableau, Power BI, and/or PowerPoint. - Assists with compilation of CRA-related data requests in support of external regulatory exams, internal audits and requests from supporting business partners. - Performs ongoing analysis of CRA activity against targeted goals and identifies potential perform...