SUMMARYThe CRA Data Analyst will assist in the execution of the Banks Compliance Program with an emphasis on Community Reinvestment Act CRA data collection analysis and reporting.ESSENTIAL DUTIES AND RESPONSIBILITIESinclude 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 andor 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 andor 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 Banks CRA Officer Fair Lending Officer and applicable project management teams in support of project work to implement new andor revised federal regulations.Creates and maintains data governance documentation for all reporting produced including but not limited to documented proceduresworkflows.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.EDUCATIONCollege degree preferably in management information systems MIS or related field of study requiredEXPERIENCE1-2 years in an analytics role with a financial institution or regulator1-2 years of regulatory compliance experience preferably in CRAKNOWLEDGE SKILLS AND ABILITIESStrong quantitative and technical skills.Advanced Microsoft Excel and PowerPoint skills required.Familiarity with database management systems and reporting tools Power BI OBIEE RiskExec Kadince or similar preferred.ADDITIONAL INFORMATIONCandidates residing in locations within BankUniteds footprint may be given preference.