CRA Senior Officer - Reporting Analyst (SQL Queries)

Job Description:

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.

Required Skills

• 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

Desired Skills 

• 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

Enterprise Description

Applies knowledge and expertise of risk/regulatory programs, industry practices, and the business unit to one or more functions within the business group. Independently conducts assigned responsibilities within the context of the business unit enterprise-wide regulatory/operational risk program.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Pay Transparency details

US - IL - Chicago - 135 S La Salle St - The Field (IL4135), US - NJ - Pennington - 1500 American Blvd - Hopewell Bldg 5 (NJ2150)

Pay and benefits information

Pay range

$83,700.00 - $128,700.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

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.

Benefits