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.Some travel may be required.The role will be accountable for the following:

-Designing, developing, implementing, and supporting all the ETL process

-Defining and implementing data structures, system designs and patterns

-Developing tools and scripts for large volumes of data transition btw different systems

-Perform Data analyst to make sure the data quality

-Identifying bottlenecks and improving the ETL efficiency

-Troubleshooting and bug fixing

-Ensuring that issues raised in their area are solved and followed to conclusion

-Writing technical documents to support items that have been developed and delivered by the team.

-Proposing new technologies and techniques to quickly and comprehensively identify vulnerable infrastructure and platforms

-Collaborating with stakeholders at various levels across Cybersecurity and other IT teams, to develop solutions that protect HSBC

-Designing and driving the implementation of service offerings, capability uplifts, and process improvements to protect HSBC from a continuously changing threat landscape

-Acting as a coach and mentor for other team members

-Previous experience as a Data Engineer in an agile, DevSecOps environment

-5+ years experience of Data Engineer/ETL (Python is a plus)

-5+ years experience of Debugging (e.g. stack traces, log files and other system outputs)

-5+ years experience of SQL (e.g. MySQL, DB2, Oracle, MongoDB, PostgreSQL)

-5+ years experience of System Administration (e.g. configuring /managing servers, Linux /Windows)

-Experience on 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 mind-set

-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 team

-Willingness to continuously learn and share learnings with others