2 days ago
Kraków, PolandSenior
Responsibilities
- Design, write, and optimize production T-SQL across ODS and DWH layers in Azure SQL.
- Model and evolve data warehouse structures, including dimensions, facts, historisation, soft-delete, and metadata columns.
- Build and maintain Azure Data Factory ingestion and orchestration pipelines with parameterization, retries, and monitoring.
- Develop Power BI reports and semantic models using DAX, Power Query/M, row-level security, and paginated reports.
- Build and maintain SSRS reports and migrate existing SSRS and paginated reporting to the target platform.
- Analyze and migrate legacy SSIS packages and on-premises SQL Server logic into Azure-native pipelines and procedures.
- Maintain SSDT database code and deliver schema changes through DACPAC deployments and Azure DevOps CI/CD pipelines.
- Develop Databricks notebooks and jobs using SQL and PySpark for data warehouse and analytics workloads.
Requirements
- Substantial commercial experience in data engineering, business intelligence, or database development.
- Expert SQL and T-SQL skills with strong performance-tuning experience involving execution plans, indexing, and partitioning.
- Proven MSSQL and Azure SQL experience, including schema design and database-first development with SSDT and DACPAC deployments.
- Experience with ODS, staging, and DWH layering; dimensional modeling; and incremental and full-load patterns.
- Experience building and supporting Azure Data Factory pipelines with datasets, linked services, triggers, parameterization, and monitoring.
- Experience developing production Power BI solutions with semantic or tabular modeling, DAX, Power Query/M, workspaces, and dataset refresh.
- Experience building and maintaining SSRS reports and debugging and migrating SSIS packages.
- Effective English communication skills for technical work.
Benefits
- Monthly gross pay range of 18359 PLN to 27542 PLN, with discretionary variable pay influenced by company, function, and individual performance.
- Healthcare, family-friendly leave, pension, life assurance, private medical care, and life insurance.
- Additional recognition-award bonuses, a Multisport card, cafeteria platform, employee assistance program, and additional PPK contributions.
- One-time reimbursement of home-office setup costs up to 800 PLN.
- Flexible working hours, free parking, nursery discounts, social fund support, and financial assistance for training and education.
- Corporate events, CSR initiatives, and an inclusive workplace with recruitment accommodations available upon request.
- Recruitment process includes an online behavioral test and telephone screen for external candidates, followed by a hiring-manager interview.
About HSBC
HSBC is a global bank that provides retail, commercial and investment banking, payments, and wealth management to individuals, SMEs, and multinationals. It earns fees, interest income, and trading revenues through branches and digital platforms across major markets. Headquartered in London, it serves over 40 million customers in 58 countries and is listed in London, Hong Kong, New York, and Bermuda.