CRA Senior Officer - Reporting Analyst (SQL Queries)

Bank of America • Charlotte, NC

11d • Onsite

About The Position

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day. Being a Great Place to Work is core to how we drive Responsible Growth. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve. Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations. At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us! Line of Business Description This job is responsible for conducting activities in support of the Community Reinvestment Act (CRA) and conducting assigned responsibilities for scope of enterprise wide CRA program / policy. Key responsibilities include the ability to assesses bank performance for low and moderate income (LMI) individuals and in LMI areas to determine CRA applicability / performance test conclusions. Job expectations include an ability to manage, mine, analyze and draw conclusions on volumes of industry and internal data to create meaningful analysis in support of business strategy and decision-making. Provide data management and reporting expertise required to comply with the new OCC CRA rule. Provide system research, reconciliation and analysis in support of the bank's CRA program. Work with CRA team, Technology and business partners to develop the new CRA requirements and the new CRA application. Support the technology remediation testing for the existing CRA application.

Requirements

• Expert knowledge of SQL queries
• Microsoft Excel and Access database expertise
• Strong analytical thinking and problem solving
• Excellent communication and organizational skills
• Strong bias for action; results oriented with an ability to manage to deadlines
• Ability to manipulate data across systems
• Liaison between LOBs and Technology
• Data reconciliations
• Ability to translate business requirements for Technology application
• Ability to adapt to a fast paced, rapidly changing environment
• Able to perform tasks autonomously with guidance provided in more complex situations
• Continuously seeks process improvement
• Ability to perform primary responsibilities as well as ability to support a collaborative team environment

Nice To Haves

• Working knowledge of Tableau, Microstrategy, SAS
• Technical knowledge of CRA and HMDA regulations and use of CRAWiz a plus
• For internal employees; participation in a work from home posture does not make you ineligible to post, however, may require to meet the workplace excellence policy
• Internet Service Provider at home (no public WiFi or Internet)
• Sufficient room to set up a laptop, monitor, keyboard and mouse
• Comfortable space to work for a full shift
• Quiet, private and SECURE space in which to work

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed