Our Client is one of the leading investment banks in the world, and for their growing professional team we are looking for a Security Data Specialist.
Develop and maintain transactional and dimensional databases/warehouse with further expansion to big data and other products if necessary.
Develop and maintain ETL and data load jobs (Talend).
Act as data owner for the team. Create and maintain data models and ontology, participate in the organization’s data governance.
Develop and manage program metrics and performance through tracking/reporting and active engagement with stakeholders for continuous service improvement.
Develop horizontal view of risk posture across multiple technology domains.
Work with various risk and information security teams in presenting recommendations for improvement to technology subject matter experts and management.
Engage with cross sector, global and risk teams in the review and reengineering of key controls and processes to effectively and efficiently manage IS issues.
Work with vulnerability lifecycle managers, operations and application support teams and the SSM team to analyze requirements, design and develop specs and manage data which supplies information to all vulnerability threat reporting and analysis.
Expert level Microsoft T-SQL knowledge and experience with other business analytics software
Experienced in designing data / reporting systems from the ground up.
Advanced knowledge of complex query for data analysis.
Strong understanding of performance tuning and optimization (analyzing query execution plans, implementing and maintaining indexes, etc.)
Technical background in RDBMS, Windows/Unix Operating systems, security technologies, and network architectures.
Experience with CI/CD type development
Experience with Atlassian suite (JIRA, Confluence, BitBucket)
Experience with at least one coding language (PowerShell, Python, C#, etc.)
BA/BS degree or equivalent experience preferred.
Prior experience includes 3+ years in information security
5+ years as a database developer