Database / Data Warehouse Engineer 80-100% (m/f) - Fixed for 1 Year with Option to Extend — Universitäts-Kinderspital Zürich
CHF 79'000 - 134'500
Universitäts-Kinderspital Zürich · Zürich (ZH)
- Location
- Zürich
- Contract
- part-time
- Posted
- 42 days ago
SalaryCHF 79'000 - 134'500
Role overview
Your tasks Your focus is on the technical design and performance tuning of our DWH.
You analyze and optimize our existing data pipelines based on MSSQL.
You are responsible for the operation and monitoring of the data flows as well as the expansion of the monitoring capabilities (load peaks, data accesses, authorizations, etc.) and you are consulting the technical documentation.
- Your tasks Your focus is on the technical design and performance tuning of our DWH.
- You analyze and optimize our existing data pipelines based on MSSQL.
- Closed higher education in computer science, medical informatics, data science or related areas Multiannual experience with MSSQL servers focusing on performance tuning (Query Optimizer, Resource Governor, Index Strategies incl.
- Columnstore, Snapshot Isolation etc.) with very good knowledge of SQL/T-SQL knowledge in building and operating a data warehouse as well as knowledge of Python, Power BI, PowerShell, dbt, Docker, REST-APIs and event streaming solutions of advantage knowledge of clinical and administrative hospital processes and data are of advantage High motivation and flexibility for work in a multidisciplinary environment The largest of the "Kispi" are the small ones: Up to 100'000 patients are supplied annually, in 47 areas we do everything for their well-being.
Key requirements
- Closed higher education in computer science, medical informatics, data science or related areas Multiannual experience with MSSQL servers focusing on performance tuning (Query Optimizer, Resource Governor, Index Strategies incl.
- Columnstore, Snapshot Isolation etc.) with very good knowledge of SQL/T-SQL knowledge in building and operating a data warehouse as well as knowledge of Python, Power BI, PowerShell, dbt, Docker, REST-APIs and event streaming solutions of advantage knowledge of clinical and administrative hospital processes and data are of advantage High motivation and flexibility for work in a multidisciplinary environment The largest of the "Kispi" are the small ones: Up to 100'000 patients are supplied annually, in 47 areas we do everything for their well-being.
- Not only the most modern devices and the highest quality in the treatment are written large on the Kispi, but also a good sense of interpersonality.
- In addition to the whole range of child-medical and child-surgical, the children's hospital also offers a unique rehabilitation centre and a research centre.
- Completed higher education in Computer Science, Medical Informatics, Data Science, or related fields
- Several years of experience with MSSQL Server and performance tuning Knowledge of SQL/T-SQL
- Experience in building and operating a Data Warehouse
- Knowledge of Python, Power BI, PowerShell, dbt, Docker, REST APIs
- Knowledge of clinical and administrative hospital processes and data High motivation and flexibility
- Good communication skills in German and English
Additional details
- Your profile Closed higher education in computer science, medical informatics, data science or related areas Multiannual experience with MSSQL servers focusing on performance tuning (Query Optimizer, Resource Governor, Index Strategies incl.
