Job description
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
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.
• 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
• Education:
Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Experience:
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.
• Technical Skills:
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).
• Analytical Skills:
Strong problem-solving skills with a keen attention to detail.
Ability to analyze complex data sets and derive meaningful insights.
• Benefits:
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.
If you are a passionate data engineer with expertise in ETL processes and a desire to make a significant impact within our organization, we encourage you to apply for this exciting opportunity!
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***