Consultant Specialist

Full-time Job Type
Hybrid Work Arrangement
Mid-Level Experience
Apply Now Posted 1 week ago

Hybrid role in Guangzhou, China for a mid-level Consultant Specialist at HSBC. The position focuses on designing and optimizing ETL processes and data pipelines using Google Cloud Platform (GCP) technologies.

Skills / Requirements

  • AI and Machine Learning
  • Apache Airflow
  • Apache Beam
  • BigQuery
  • Cloud Composer
  • Cloud Storage
  • Data Integration
  • Data Pipeline Optimization
  • Dataflow
  • DevOps
  • ETL Processes
  • GCP
  • Hadoop
  • Incident Management
  • Java
  • Kafka
  • Python
  • Site Reliability Engineering
  • Spark
  • SQL
  • Vibe Coding

Why Apply

This role is ideal for those adept at using AI tools like Vertex AI and Apache Beam for data processing and analysis. The position involves leveraging AI to enhance ETL automation and optimize data workflows.

What You'll Be Doing

Design and implement ETL processes on GCP, optimize data pipelines, and manage data integration from diverse sources. Collaborate with stakeholders to meet business needs and ensure data quality and consistency. Automate workflows and monitor system health.

Working in Guangzhou, China

  • Guangzhou is a major tech hub in China, offering numerous opportunities for IT professionals.
  • The city has a well-developed public transportation system, making commuting convenient.
  • Guangzhou's cost of living is generally lower than Beijing or Shanghai, providing a balanced lifestyle.
  • The city offers a vibrant cultural scene with numerous dining and entertainment options.

Pay and Career Growth

HSBC offers a collaborative environment with opportunities for professional development and career growth. The role includes working with cutting-edge GCP technologies, which can enhance your expertise in cloud-based solutions.

Benefits and Perks

  • Diverse workplace
  • Flexible Working
  • Inclusive environment
  • Professional Development

Is This Role Right for You?

Good fit if you...

  • Experienced in designing ETL processes and managing data pipelines.
  • Proficient in GCP and familiar with AI and machine learning applications.
  • Comfortable with incident management and system reliability strategies.

May not be for you if...

  • Lacks experience with cloud technologies, particularly GCP.
  • Unfamiliar with AI tools and their application in data processing.
  • Prefers roles with minimal collaboration or stakeholder interaction.

Original Job Description

Consultant Specialist

Brand: HSBC

Area of Interest: Technology

Location:

Guangzhou, GD, CN, 510620

Work style: Hybrid Worker

Date: 8 May 2026

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

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 requirements 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.

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