Deliver advanced data mining and analytics to identify, measure, and interpret the firm’s attack surface
Responsible for designing, developing, and delivering high‑quality queries, datasets, and visualizations that support Global Information Security stakeholders
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

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

Discretionary incentive eligible
Paid time off
Industry-leading benefits
Resources and support for employee wellness

Applicant Tracking System Keywords

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

Hard Skills & Tools

SQL DevelopmentLarge Volume Database ManagementSQL Server DevelopmentSQL Server IntegrationETLPython developmentMS-Reporting ServicesMS-Integration ServicesData miningAnalytics

Soft Skills

Research skillsAnalytical skillsProblem solvingConceptual thinkingSelf-motivatingSelf-drive