Software Engineer

Some careers shine brighter than others. If you're looking for a career that will help you stand out, join HSBC, and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

Your career opportunity Hilda 2.0 is a modernisation programme migrating a portfolio of legacy HILDA applications from on-premises into a modular, cloud-native Azure architecture. As a Software Engineer, you'll work on building and evolving the data platform that supports Israeli regulatory and financial reporting for internal HSBC users.

Responsibilities:

• Design, write and optimise production T-SQL across ODS and DWH layers in Azure SQL
• Model and evolve warehouse structures including dimensions, facts, historisation, soft-delete and metadata columns
• Build and maintain Azure Data Factory pipelines for ingestion and orchestration
• Develop and maintain Power BI reports and semantic models
• Build and maintain SSRS reports and migrate existing SSRS and paginated reporting into the target platform
• Analyse and migrate legacy SSIS packages and on-premises SQL Server logic into Azure-native pipelines and procedures
• Maintain database code in SSDT projects and deliver schema changes via DACPAC through Azure DevOps CI/CD
• Develop Databricks notebooks and jobs using SQL and PySpark for data warehouse and analytics workloads

Requirements:

• Substantial commercial experience in software engineering, data engineering, BI or database development with expert SQL and T-SQL
• Strong performance tuning across execution plans, indexing and partitioning
• Proven MSSQL and Azure SQL experience
• Established data warehousing approaches
• Build and support Azure Data Factory pipelines
• Develop production Power BI solutions
• Build and maintain SSRS reports and work with SSIS packages
• Communicate effectively in English for technical work

Benefits:

• The pay range for this role is 18359 PLN - 27542 PLN (monthly, gross)
• Variable pay is discretionary
• Comprehensive and competitive package of benefits covering healthcare, family friendly leaves, pension and life assurance
• Additional bonuses for recognition awards
• Multisport card
• Private medical care
• Life insurance
• One-time reimbursement of home office set-up (up to 800 PLN)
• Cafeteria platform
• Employee assistance program
• Additional contributions to PPK scheme
• Corporate parties & events
• CSR initiatives
• Nursery discounts
• Financial support with trainings and education
• Social fund
• Flexible working hours
• Free parking