Hybrid Attack Surface Network and Vulnerability Data Analytics Analyst – SQL, Python, Advanced Data Mining

at Bank of America

• Job title: Attack Surface Network and Vulnerability Data Analytics Analyst – SQL, Python, Advanced Data Mining
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $100,000 - $141,300 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Python, SQL, SSIS, Switching, .NET
• Location requirements: Hybrid, Denver, United States

About the role

• Analyst delivering advanced data mining and analytics for attack surface management at Bank of America. Focus on designing high-quality queries, datasets, and visualizations for security stakeholders.

Responsibilities

• The Attack Surface Research and Analysis team delivers advanced data mining and analytics to identify, measure, and interpret the firm’s attack surface.
• This role is responsible for designing, developing, and delivering high‑quality queries, datasets, and visualizations that support Global Information Security stakeholders, using technologies such as Hue (Hive and Impala), Power BI, SQL Server, Cloudera, .NET, and Python.
• The successful candidate will be highly collaborative, analytical, detail‑oriented, and persistent, ensuring insights are accurate, actionable, and delivered on time.
• 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?

Requirements

• SQL Development - 5+ years of professional experience writing queries and analyzing output or closely related role
• Large Volume Database Management and Maintenance - millions of rows data flow per update
• SQL Server Development: Indexes, constraints, table switching, transaction management, error handling, & activity logs
• SQL Server Integration: Services Dev Ops, C# script task, packaging, deployment conditional predecessor/successors
• Hands-on experience with large datasets and tools including data ingestion (batch & real time), transformation and delivery -ETLs
• Python development (front-and back-end)
• MS-Reporting Services (SSRS)
• MS-Integration Services (SSIS): subscriptions, report management, Tablix, matrix, cascading parameters
• 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.
• Self-Motivating and Self-Drive

Benefits

• 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.