CRA Data Analyst

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 performance gaps. Provides recommendations for areas of improvement related to lending and investments within low- and moderate-income communities.
• Assists the CRA Officer with the development of the annual CRA Plan by analyzing CRA performance to generate appropriate goals. In addition, performs necessary updates to reporting spreadsheets to capture new assigned goals and / or assessment areas affecting the exam scope period.
• Performs annual peer bank data assessment for CRA reporting. Identifies best practices and industry trends.
• Works with the Bank's CRA Officer, Fair Lending Officer, and applicable project management teams in support of project work to implement new and / or revised federal regulations.
• Creates and maintains data governance documentation for all reporting produced, including but not limited to, documented procedures / workflows.
• Ensures the integrity of all reports by performing any necessary reconciliation of data.
• Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
• Adheres to Bank policies and procedures and completes required training.
• Identifies and reports suspicious activity.

EDUCATION

College degree, preferably in management information systems (MIS) or related field of study required

EXPERIENCE

KNOWLEDGE, SKILLS AND ABILITIES

ADDITIONAL INFORMATION