Senior Community Reinvestment Act Analyst

Company	Bank of Montreal
Location	Washington, USA, Kansas, USA, Pennsylvania, USA, North Dakota, USA, Delaware, USA, Iowa, USA, Vermont, USA, Wyoming, USA, Los Angeles, CA, USA, Texas, USA, Jackson Township, NJ, USA, Florida, USA, Waterbury, CT, USA, Nevada, USA, South Carolina, USA, South Dakota, USA, Georgia, USA, Arizona, USA, Concord, NH, USA, Tennessee, USA, Virginia, USA, Arkansas, USA, Colorado, USA, Nebraska, USA, Rhode Island, USA, Utah, USA, Kentucky, USA, West Virginia, USA, Wisconsin, USA, Maine, USA, North Carolina, USA, Oklahoma, USA, Montebello, CA, USA, Ohio, USA, Alaska, USA, Illinois, USA, United States
Salary	$74000 – $138000
Type	Full-Time
Degrees	Bachelor’s
Experience Level	Senior

Deep knowledge of the Community Reinvestment Act (CRA)
Knowledge of external data sources including government data bases
Experience using CRA Wiz SaaS software a plus
Knowledge of Microsoft products including Excel, PowerPoint and Word
Knowledge of database management including Access, SQL, JSON
Experience working on a CRA exam helpful
Excellent communication skills
Analytical and problem-solving skills
Collaboration and team skills
Typically between 5 – 7 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience

Build various reporting dashboards using the most appropriate data extraction, data cleaning and data visualisation techniques to develop, maintain, and enhance CRA scorecards for the Lending, Investment, and Services Tests
Develop reports that allow the audience to quickly understand CRA results and recommendations, so they act upon them and make data driven decisions which includes closing any line of business gaps to achieve CRA goals
Identify, analyze and interpret trends or patterns in complex data to provide answers to business questions as well as provide recommendations for CRA action planning
Collaborate with business partners to prioritize requests/needs
Provide quantitative analysis and insights to support CRA performance context including extracting data from well known public data sources to help show the impact being made in low-to moderate-income communities
Maintain current record of all branches and ATMs and changes to the service network
Provide reporting and analysis on alternative delivery systems (ADS) that shows the usage of such systems by low-and moderate-income audiences
Assist with CRA examination preparation which includes creating tables for CRA small business and HMDA loan data
Manage relationship with external vendor on analytics solutions for streamlining analysis
Works independently and regularly handles non-routine situations
Broader work or accountabilities may be assigned as needed