Senior Data Engineer
📝 Opis główny / Wstęp
HSBC Service Delivery (Polska) Sp. z o.o. is HSBC's global finance, operations, risk and technology centre. We use our unique expertise and capabilities to provide specialised services – our people range from technologists transforming the banking experience to operations professionals managing 1.7 trillion payments a year.
Our Purpose – Opening up a world of opportunity – explains why we exist. We are bringing together the people, ideas and capital that nurture progress and growth, helping to create a better world – for our customers, our people, our investors, our communities and the planet we all share.
HSBC Markets and Securities is an emerging markets-led and financing-focused investment banking and trading business that provides tailored financial solutions to major government, corporate and institutional clients worldwide.
In IT we provide HSBC with a genuine competitive advantage across the globe. Global Business Insights (GBI) provide critical metrics and reports to Markets and Securities Services Operations to enable them to monitor the health of their business and make data-driven decisions.
The GBI Transformation is a large and complex data integration program spanning all of MSS Ops globally. We serve a diverse audience of users and data visualisation requirements from Exco down, and over 80 data sources in multiple time-zones across Middle Office, Post-Trade and Securities Services IT and elsewhere. We are a critical enabler for the Rubix 2025 Strategy and the MSS control agenda, providing operational KPI and KRI metrics which allow senior management to measure the success of their BAU and CTB investment dollars.
The Opportunity:
We are looking for a GCP developer who can design, develop, test and deploy ETL/SQL pipelines connected to a variety of on-prem and Cloud data sources - both data stores and files. We will be using mainly GCP technologies like Cloud Store, BigQuery, and Data Fusion. You will also need to work with our devops tooling to deliver continuous integration/deployment capabilities, automated testing, security, and IT compliance.
What you’ll be doing:
• Design, build, test and deploy Google Cloud data models and transformations in BigQuery environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.).
• Create and manage ETl/ELT data pipelines to model raw/unstructured data into Data Vault universal model, enriching, transforming and optimizing data into for end-user consumption.
• Review and refine, interpret, and implement business and technical requirements.
• Ensure applications meet non-functional requirements, IT standards, and security, compliance, scalability, reliability, and cost-efficiency needs.
• Monitor and optimize data pipelines for failure, performance issues, and scalability, implementing fixes or improvements as needed.
• Integrate data from multiple sources, ensuring consistency and accuracy.
• Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.
• Address defects, enhance development, and transition knowledge, code, and support responsibilities to the support team.
You’re a great candidate if you have these:
• Proven (3+ years) hands-on experience in SQL querying and optimization of complex transformation in BigQuery, focusing on cost-efficiency, concurrency, and data integrity.
• Proven (3+ years) hands-on experience in SQL Data Transformation, ETL/ELT pipeline development, testing, and implementation, ideally in GCP Datafusion.
• Experience in Data Vault modelling and implementation.
• Hands on experience in Cloud Composer/Airflow, Cloud Run, and Pub/Sub.
• Development experience in Python, Terraform, including proficiency in Git for version control and CI/CD pipeline creation and maintenance using DevOps tools like Ansible/Jenkins for could-based applications (ideally GCP).
• Experience working in DataOps model and Agile environment with corresponding toolsets.
• Strong problem-solving, analytical, and organisational skills with the ability to adapt, learn, and develop technical and soft skills rapidly and independently.
• Collaborative team player who embraces teamwork and mutual support.
What you’ll get with us:
The pay range for this role is 17391 PLN - 26083 PLN (monthly, gross).
Variable pay is discretionary, but influenced by Group performance, business/function performance and individual performance.
We offer a comprehensive and competitive package of benefits covering healthcare, family friendly leaves, pension and life assurance, as well as many other benefits to support your wellbeing.
• Competitive salary
• Annual performance-based bonus
• Additional bonuses for recognition awards
• Multisport card
• Private medical care
• Life insurance
• One-time reimbursement of home office set-up (up to 800
PLN)
• Corporate parties & events
• CSR initiatives
• Nursery discounts
• Financial support with trainings and education
• Social fund
• Flexible working hours
• Free parking
You'll achieve more when you join HSBC.
If your CV meets our criteria, you should expect the following steps in the recruitment process:
• Online behavioural test
• Telephone screen
• Job interviews with the hiring managers
In case you would like to resign from participation in recruitment process or withdraw previously sent to us application, please email us at: hr.krakow.pl@hsbc.com.