Your responsibilities, 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.

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 we offer, 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.

Benefits, sharing the costs of sports activities, private medical care, sharing the costs of professional training & courses, life insurance, remote work opportunities, flexible working time, integration events, corporate sports team, retirement pension plan, corporate library, no dress code, coffee / tea, parking space for employees, leisure zone, extra social benefits, employee referral program, opportunity to obtain permits and licenses, charity initiatives, family picnics, extra leave, In-office gym

Recruitment stages, Online assessment, Phone interview, Job interview, Welcome to HSBC!

HSBC Service Delivery (Polska) Sp. z o.o., HSBC is one of the world’s largest banking and financial services organisations. Our global businesses serve more than 40 million customers worldwide through a network that covers 63 countries and territories., , 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.

This is how we work,

About the project

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.

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.

About the project

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.

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.

Your responsibilities

• 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.

Recruitment stages

• Online assessment
• Phone interview
• Job interview
• Welcome to HSBC!

Benefits, sharing the costs of sports activities, private medical care, sharing the costs of professional training & courses, life insurance, remote work opportunities, flexible working time, integration events, corporate sports team, retirement pension plan, corporate library, no dress code, coffee / tea, parking space for employees, leisure zone, extra social benefits, employee referral program, opportunity to obtain permits and licenses, charity initiatives, family picnics, extra leave, In-office gym

Recruitment stages, Online assessment, Phone interview, Job interview, Welcome to HSBC!

HSBC Service Delivery (Polska) Sp. z o.o., HSBC is one of the world’s largest banking and financial services organisations. Our global businesses serve more than 40 million customers worldwide through a network that covers 63 countries and territories., , 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.

This is how we work,

About the project

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.

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.