# Consultant Specialist

**Company**: HSBC Software Development (GuangDong) Limited
**Location**: Guangzhou
**Work arrangement**: onsite
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Finance

**Apply**: https://portal.careers.hsbc.com/careers/job/563774611303521?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_dcff4455-374

## Description

We are seeking an experienced professional to join our team in the role of Consultant Specialist. As a Consultant Specialist, you will play a key role in designing and building data processing systems, collaborating with cross-functional teams to understand data requirements and implementing efficient data pipelines using GCP services such as BigQuery, Dataflow, and Pub/Sub.

Your primary responsibilities will include:

Designing and building data processing systems to meet business requirements Collaborating with cross-functional teams to understand data requirements and implement efficient data pipelines Implementing data ingestion, transformation, and enrichment processes using GCP services Ensuring scalability, reliability, and performance of data processing workflows Collecting and ingesting data from various sources into GCP Cleaningse, validating, and transforming raw data to ensure its quality and consistency Optimizing data processing for speed and efficiency Choosing appropriate storage solutions based on data characteristics and access patterns Creating and managing data warehouses, databases, and data lakes Defining data retention policies and archival strategies Preparing data for downstream analytics, reporting, and machine learning Collaborating with data scientists and analysts to understand their requirements Ensuring data is accessible, well-organized, and properly documented Automating data workflows using tools like Apache Airflow or Cloud Composer Monitoring data pipelines, troubleshooting issues, and proactively addressing bottlenecks Implementing alerting mechanisms for data anomalies Applying security best practices to protect sensitive data Ensuring compliance with industry regulations and internal policies Collaborating with security teams to address vulnerabilities Documenting data pipelines, architecture, and processes Sharing knowledge with team members through documentation, training sessions, and workshops

Requirements:

Bachelor's degree in Computer Science, Information Systems, or a related field Minimum of 5 years of industry experience, cloud experience is a plus Familiarity with GCP services (BigQuery, Dataflow, Pub/Sub, etc.) and related technologies Experience with data modeling, ETL processes, and data warehousing, SQL Previous work in highly regulated or complex organisations is a plus Strong problem-solving skills and attention to detail Proficiency in Python & Bash for data manipulation and scripting Proficiency in SQL for querying and manipulating data Knowledge of Terraform for infrastructure as code (IaC) Familiarity with Jenkins for continuous integration and deployment Knowledge of Cloud platform, GCP is a plus

## Skills

### Required
- GCP services
- BigQuery
- Dataflow
- Pub/Sub
- Python
- Bash
- SQL
- Terraform
- Jenkins
- Cloud platform

---

Source: [Apply at portal.careers.hsbc.com](https://portal.careers.hsbc.com/careers/job/563774611303521?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)