Bank Of America SQL BI/Web Development Specialist - Information Security 

United States, Illinois, Chicago 

387615671

Job Description:

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

1st shift (United States of America)