Back to search results

SQL BI/Web Development Specialist - Information Security

Chicago, Illinois;

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. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.

One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We’re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.

Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.

Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Position Summary

Work as part of a team developing methods to quickly reference systems of record (SOR’s), systems of origin (SOO’s) and other available data stores for a comprehensive reliable and timely view of the Bank’s attack surface and vulnerability exploitability potential, with the goal of enabling answers to the following three questions as quickly as possible.

  • Do we have it?
  • Are we vulnerable?
  • Is it exploitable?

The Attack Surface Visibility and Analysis team is responsible for data mining efforts to identify and understand the firms Attack Surface. You will leverage tools like Hadoop (Hive and Impala), Power BI, SQL Server, Cloudera, .NET and Python to design, create and prepare queries and visualizations for other Global Information Security groups, under the supervision of the Attack Surface Visibility and Analysis Manager. A successful candidate will be team oriented, collaborative, persistent, analytical, and detail oriented such that development efforts and deliverables meet deadlines, accuracy and specified purpose. Typically, 5-8 years of IT experience with a minimum of 3+ years of those focused on IT system development work with large data stores. Candidate must also be able to perform analysis against result sets to identify gaps, trends or actionable information. This position is being added to help the team expand it’s capabilities to include web development.

Skills:

  • Critical Thinking
  • Customer and Client Focus
  • Information Systems Management
  • Problem Solving
  • Cyber Security
  • Quality Assurance
  • Technology System Assessment
  • Business Acumen
  • Business Intelligence
  • Data and Trend Analysis

Qualifications:

  • 5+ years of professional experience writing queries and analyzing output or closely related role
  • Hands-on experience with large datasets and tools including data ingestion (batch & real time), transformation and delivery
  • Power BI report development experience
  • Web development with emphasis on UI/UX, and third party components, i.e. Telerik
  • SQL development experience
  • MS-Reporting Services (SSRS) experience
  • MS-Integration Services (SSIS) experience
  • ASP.NET experience
  • IIS (Internet Information Services) experience
  • Javascript experience
  • Excellent research skills – able to identify relevant data sources for information about bank technologies, gain an understanding of how things work and be willing to dig in and help identify usage throughout the firm
  • Strong analytical skills/problem solving/conceptual thinking. 

Desired 

  • Python development (front-and back-end)
  • Knowledge of information security concepts, research tools, and products
  • Ability to work with Technical and Non-Technical business owners
  • Hadoop (Hive and Impala) - highly preferred

Enterprise Role Overview:

This job is responsible for assessing the bank's technologies, applications, and overall security controls to identify potential risks and vulnerabilities that may impact Bank of America's information security. Key responsibilities include developing a better understanding of Bank of America's Global Information Security policy and relevant cyber security threats to complete security assessments. Job expectations include developing technical subject matter expertise to support partners, and adapting testing methods to emerging cyber security regulations and evolving threats.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-24021212

Manages People: No

Travel: Yes, 5% of the time

Colorado pay and benefits information

Colorado pay range:

$95,000 - $141,700 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

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.