Consultant Specialist, HSBC

HSBC

Location:
China, Xi'an

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

As a Senior Data Engineer / ETL Engineer, you will be instrumental in designing, developing, and optimizing data processing systems that support our organization's data initiatives. Your expertise in Data Stage, Data Flow, SQL, and Google Cloud Platform (GCP) will be essential in building robust ETL pipelines that transform raw data into actionable insights. You will collaborate with cross-functional teams to ensure that data is accurate, accessible, and valuable for decision-making.

Job Responsibility:

Design and Develop ETL Processes: Lead the design and implementation of ETL processes using Data Stage and other relevant 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
SQL Development: Write complex SQL queries 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
Data Governance and Security: Apply best practices for data governance, ensuring compliance with industry regulations (e.g., GDPR, HIPAA) and internal policies
Collaborate with security teams to implement data protection measures and address vulnerabilities
Documentation and Knowledge Sharing: Document ETL processes, data models, and architecture to facilitate knowledge sharing and onboarding of new team members
Conduct training sessions and workshops to share expertise and promote best practices within the team

Requirements:

Bachelor’s degree in Computer Science, Information Systems, or a related field
Minimum of 5 years of industry experience in data engineering or ETL development, with a strong focus on Data Stage and GCP
Proven experience in designing and managing ETL solutions, including data modeling, data warehousing, and SQL development
Proficiency in Data Stage and experience with data integration tools
Strong knowledge of GCP services (e.g., BigQuery, Dataflow, Cloud Storage) and their application in data engineering
Familiarity with Python for scripting and data manipulation, as well as Terraform for infrastructure as code (IaC)
Strong problem-solving skills with a keen attention to detail
Ability to analyze complex data sets and derive meaningful insights

What we offer:

Competitive salary and comprehensive benefits package
Opportunity to work in a dynamic and collaborative environment on cutting-edge data projects
Professional development opportunities to enhance your skills and advance your career

Additional Information:

Job Posted:
April 30, 2025

Expiration:
May 30, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Consultant Specialist

HSBC

Location:China, Xi'an

Category:IT - Software Development

Contract Type:Employment contract