Cyber Security Research & Analysis Specialist, SQL, Python

Bank of America

. Create SQL and python scripts within Qualys, Tanium and BladeLogic to query datasets, to support attack surface visibility and vulnerability analysis .

Posted 4/27/2026full-timeDenver • Colorado, District of Columbia, Illinois • 🇺🇸 United StatesMid-LevelSenior💰 $100,000 - $141,300 per yearWebsite

Tech Stack

Tools & technologies

ETLPythonSQLSSISSwitching

About the role

Key responsibilities & impact

Create SQL and python scripts within Qualys, Tanium and BladeLogic to query datasets, to support attack surface visibility and vulnerability analysis
Perform hands on analysis of large scale datasets to correlate to security and vulnerabilities
Use Python and SQL to automate data ingestion, transformation, enrichment, and quality validation (ETL)
Develop and maintain visualizations and reports in Power BI or MS-Reporting Services (SSRS) MS-Integration Services (SSIS) that support operational teams, cyber leadership, and risk stakeholders
Understands the Bank’s Data network and architecture to work in a team to answer: Do we have it? Are we vulnerable? Is it exploitable?
Clearly communicate findings through written analysis and live discussions, including executive‑level summaries.

Requirements

What you’ll need

Experience with SQL Server Integration Services (SSIS), including: DevOps integration, C# script tasks, Packaging, deployment, and conditional workflows
Python development experience used for automation, data processing, and integration (not statistical or ML modeling)
SQL database and Python development experience used for automation, data processing, and integration (not statistical or ML modeling): Strong experience with SQL Server development, including: Indexes, constraints, table switching, Transaction management, error handling, and activity logging
Strong analytical, problem‑solving, and conceptual thinking skills
Self‑motivated, detail‑oriented, and able to manage work independently
Strong verbal and written communication skills, with the ability to clearly explain technical findings in meetings and documentation
Hands‑on experience with data ingestion and ETL pipelines (batch and near‑real‑time)
Experience with SSRS, including subscriptions, report management, Tablix, matrix, and cascading parameters
Basic Understanding of networked infrastructure, including: Servers, switches, load balancers, and related components, basic network segmentation and exposure concepts
Excellent research skills with the ability to: Identify relevant data sources related to enterprise technologies, understand how systems operate and are used across the firm, persistently investigate and validate findings.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonETLData ingestionData processingData transformationData validationSQL ServerSSISSSRS

Soft Skills

Analytical skillsProblem-solvingConceptual thinkingSelf-motivatedDetail-orientedIndependent workVerbal communicationWritten communicationResearch skillsTechnical explanation