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: Enterprise Technology L3
Principal responsibilities
- Design, develop, and optimize data pipelines using Azure Databricks, PySpark, and Prophesy.
- Implement and maintain ETL/ELT pipelines using Azure Data Factory (ADF) and Apache Airflow for orchestration.
- Develop and optimize complex SQL queries and Python-based data transformation logic.
- Work with version control systems (GitHub, Azure DevOps) to manage code and deployment processes.
- Automate deployment of data pipelines using CI/CD practices in Azure DevOps.
- Ensure data quality, security, and compliance with best practices.
- Monitor and troubleshoot performance issues in data pipelines.
- Collaborate with cross-functional teams to define data requirements and strategies.
Requirements
- 5+ years of experience in data engineering, working with Azure Databricks, PySpark, and SQL.
- Hands-on experience with Prophesy for data pipeline development.
- Hands-on experience with SQL for data analysis, data warehousing
- Proficiency in Python for data processing and transformation.
- Experience with Apache Airflow for workflow orchestration.
- Strong expertise in Azure Data Factory (ADF) for building and managing ETL processes.
- Familiarity and experience with GitHub and Azure DevOps for version control and CI/CD automation.
- Solid understanding of data modelling, warehousing, and performance optimization.
- Ability to work in an agile environment and manage multiple priorities effectively.
- Excellent problem-solving skills and attention to detail.
Preferred Qualifications
- Experience with Delta Lake and Lakehouse architecture.
- Understanding of machine learning workflows in a data engineering context.
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***