Regular or Temporary:
English (Required)
1st shift (United States of America)Responsible for gathering, analyzing, documenting and maintaining all security data requirements related to the business applications, interfaces and reporting environments. Apply standards and best practices to ensure the Bank's data is accurate, complete, current, understandable and accessible. Work closely with internal clients, business analysts and development project teams to understand information flow and content issues. Develop or modify procedures to ingest, correlate and analyze system or application log data to produce user and system behavior baselines, and outliers to identify patterns of risk. Provide leadership in defining processes and standards that govern an effective security analytics program. Partner with data owners to understand business applications and associated data flows.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
- Gather, review, analyze, profile, validate and map system data into the data warehouse to meet cyber security reporting and analytical needs.
- Perform complex data analytics and troubleshooting on security data ingestion issues reported by production support and other teams.
- Develop solutions and recommendations for improving data integrity issues. Analyze data issues and work with development teams for problem resolutions. Identify problematic areas and conduct research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
- Determine and analyze line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
- Work with extract, transform and load (ETL) developers to test and validate data attributes and with other business analysts to ensure data is integrated consistently, regardless of the source system.
- Take ownership of issues through resolution, including close coordination between business representatives, IT staff, and data warehouse administrators.
- Translate high level business requirements into functional specifications for the IT organization and manage changes to such specifications.
- Work with source system business analysts to understand system and log nuances and resolve data issues.
- Conceptualize, design and develop dynamic and static dashboards or views to enhance risk awareness and internal intelligence availability for incident identification, investigation, and remediation.
Required Qualifications:
The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Bachelor’s degree in Information Technology, Information Systems, Computer Science or Business-related field, or equivalent education and related training
- Ten years in a role of data analytics, statistical analytics, data transformation, data reconciliation and/or sophisticated data presentation
- Experience in ETL development using standard tools
- Strong background and holistic understanding of the different components of an Information Security Program to successfully correlate disparate solution logs and cyber related data to accurately identify trends, behavior baselines, and outliers that represent possible risks
- Understanding of Enterprise Data Warehouse concepts and prior experience applying that understanding to query data in a Very Large Database (VLDB) environment
Preferred Qualifications:
- Understanding of cyber security intelligence and security analytical packages
- Previous experience with Securonix
- Banking or financial services experience
- Working knowledge of Statistical Analysis System (SAS) and other analytic tools
- Ability to recommend the growth, addition, and retirement of data analytics toolsets