HSBC is seeking a Consultant Specialist in Software Engineering with over 8 years of experience in software development, Trade data, Java, Apache Spark, Hadoop, GCP, Elastic Search, RDBMS, SQL, Unix scripting, and ETL processes. The role involves designing, implementing, and optimizing scalable solutions, mentoring the team, and staying updated with relevant technologies.