Consultant Specialist

Some careers have more impact than others. If you’re looking for a career where you can make a real impression, join HSBC and discover how valued you’ll be. We are currently seeking an experienced professional to join our team in the role of Consultant Specialist. Business: CTO Data Technology Job ID：63316 Principal responsibilities • Design and Develop ETL Processes: • Lead the design and implementation of ETL processes using all kinds of batch/streaming tools to extract, transform, and load data from various sources into GCP. • Collaborate with stakeholders to gather

and ensure that ETL solutions meet business needs.• Data Pipeline Optimization:• Optimize data pipelines for performance, scalability, and reliability, ensuring efficient data processing workflows.• Monitor and troubleshoot ETL processes, proactively addressing issues and bottlenecks. • Data Integration and Management: • Integrate data from diverse sources, including databases, APIs, and flat files, ensuring data quality and consistency. • Manage and maintain data storage solutions in GCP (e.g., BigQuery, Cloud Storage) to support analytics and reporting. • GCP Dataflow Development: • Write Apache Beam based Dataflow Job for data extraction, transformation, and analysis, ensuring optimal performance and accuracy. • Collaborate with data analysts and data scientists to prepare data for analysis and reporting. • Automation and Monitoring: • Implement automation for ETL workflows using tools like Apache Airflow or Cloud Composer, enhancing efficiency and reducing manual intervention. • Set up monitoring and alerting mechanisms to ensure the health of data pipelines and compliance with SLAs. • Reliability Strategy: Develop and implement strategies to improve the reliability and performance of applications and infrastructure, focusing on service level objectives (SLOs) and service level indicators (SLIs). • Incident Management: Oversee incident response processes, ensuring timely resolution of incidents and minimizing downtime. Conduct post-mortem analyses to identify root causes and implement preventive measures. • Automation and Tooling: Drive the automation of operational tasks and processes, leveraging tools and technologies to enhance efficiency and reduce manual intervention. • Monitoring and Alerting: Establish comprehensive monitoring and alerting systems to proactively identify and address performance issues, ensuring system health and availability. • Documentation: Maintain clear and comprehensive documentation of systems, processes, and procedures to facilitate knowledge sharing and compliance. • Security and Compliance: Ensure that all systems and processes adhere to security best practices and regulatory requirements, collaborating with security teams as needed. • Continuous Improvement: Identify opportunities for process improvements and lead initiatives to enhance the overall reliability and performance of systems and services. Requirements • Bachelor's degree in Computer Science, Information Technology, or a related field. • Proven experience in designing and managing ETL solutions, including data modeling, data warehousing, and SQL development. • Proven experience in Site Reliability Engineering, DevOps, or a related field, with a strong understanding of system architecture and cloud technologies.• Experience of cloud-based solutions, especially in GCP, cloud certified candidate is preferred.• Experience and knowledge of Bigdata data processing in batch mode and streaming mode, proficient in Bigdata eco systems, e.g. Hadoop, HBase, Hive, MapReduce, Kafka, Flink, Spark, etc.• Familiarity with Java & Python for data manipulation on Cloud/Bigdata platform. • Experience with incident management and response, including post-mortem analysis and root cause identification. • Excellent problem-solving skills and the ability to work under pressure in a fast-paced environment. • Strong communication skills, both verbal and written, with the ability to convey technical concepts to diverse audiences. • Proven experience in AI and machine learning, preferably in the banking or financial services industry What additional skills will be good to have? • Experience with CI/CD pipelines and tools (e.g., Jenkins, GitLab CI, CircleCI). • GenAI prompt engineering, Infra as code, containerization and orchestration, IAM, compliance awareness, design for scalability, cost optimization, multi-cloud and hybrid strategies. • Cloud certifications (GCP Professional Data Engineer / Cloud Architect) are a plus.• Experience the IT application controls & compliance requirements• Experience with Vertex AI, model deployment, feature stores, vector search, embeddings.• Experience with streaming (Dataflow/Beam, Kafka) and container platforms (GKE/Cloud Run). • Experience with open-source Iceberg, Trino, etc. and evaluation tooling. • Experience with vibe coding to solve business problem. /WX You’ll achieve more when you join HSBC. HSBC is an equal opportunity employer committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and, opportunities to grow within an inclusive and diverse environment. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website. ***Issued By HSBC Software Development (GuangDong) Limited*** HSBC China currently utilizes AJINGA, a third party recruitment management system, to process job applications. Please watch out for emails, SMS, and/or WeChat messages from AJINGA. Note that AJINGA will only send notices from the following email, and will not ask you to provide any personal data by responding to the message directly. · E-mail: hsbcrecruiting@mail.ajinga.com