Senior Consultant Specialist

We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist in Cybersecurity.

The role will report to the Development lead, working within an agile, DevSecOps environment. The role will be responsible for designing, developing, implementing, and supporting all the ETL process across global cybersecurity vulnerability management systems.

Key responsibilities:

• Design, develop, implement, and support ETL processes
• Define and implement data structures, system designs, and patterns
• Develop tools and scripts for large volumes of data transition between different systems
• Perform data analysis to ensure data quality
• Identify bottlenecks and improve ETL efficiency
• Troubleshoot and fix bugs
• Ensure issues raised in their area are solved and followed to conclusion
• Write technical documents to support items developed and delivered by the team
• Propose new technologies and techniques to quickly and comprehensively identify vulnerable infrastructure and platforms
• Collaborate with stakeholders across Cybersecurity and other IT teams to develop solutions that protect HSBC
• Design and drive the implementation of service offerings, capability uplifts, and process improvements to protect HSBC from a continuously changing threat landscape
• Act as a coach and mentor for other team members

Requirements:

• Previous experience as a Data Engineer in an agile, DevSecOps environment
• 5+ years of experience in Data Engineering/ETL (Python is a plus)
• 5+ years of experience in debugging (e.g., stack traces, log files, and other system outputs)
• 5+ years of experience with SQL (e.g., MySQL, DB2, Oracle, MongoDB, PostgreSQL)
• 5+ years of experience in System Administration (e.g., configuring/managing servers, Linux/Windows)
• Experience with Airflow is a plus
• Knowledge of Vulnerability Scanning/Pen Testing/Red Teaming and associated scanning and consolidation products
• Knowledge of working with application security tools (e.g., SAST, DAST, MAST)
• Knowledge of Governance, Risk & Compliance processes
• Knowledge of Patch Management processes
• Automation and Orchestration driven mindset
• Good verbal and written communication skills
• Ability to work and lead in a fast-paced, team-focused environment with a proven track record of delivering and completing assigned tasks as an individual and as a team
• Willingness to continuously learn and share learnings with others