CRA Senior Officer - Reporting Analyst (SQL Queries)

Bank of America • Chicago, IL

12d • 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

Responsibilities

• Conducting activities in support of the Community Reinvestment Act (CRA)
• Conducting assigned responsibilities for scope of enterprise wide CRA program / policy
• Assesses bank performance for low and moderate income (LMI) individuals and in LMI areas to determine CRA applicability / performance test conclusions
• 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

Benefits

• This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.
• This role is currently benefits eligible.
• We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.
• Bank of America is committed to help employees through the transition period when they’re displaced as a result of a workforce reduction, realignment or similar measure.

What This Job Offers

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