Database / Data Warehouse Engineer 80-100% (m/w) - Befristet auf 1 Jahr mit Option auf Verlängerung — Universitäts-Kinderspital Zürich

Full description

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 activities include linking source data and optimizing ETL processes. You can use data by connecting and providing APIs. In addition, you will implement CI/CD pipelines, DevOps processes and data-based testing to ensure data quality. The evaluation and implementation of data protection compliant, including AI-assisted, tools for building, optimization and monitoring of the DWH are also part of your task.

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