Description
My client in a leading Swiss bank based in Basel which is looking to hire an experienced Data Warehouse Developer for an 8 months assigment to be based in Basel.Job requirements:
- Good knowledge on Microsoft BI technology (MS SQL Server, SSIS, SSAS)
- Hands on experience on coding, code design, strong debugging skills, he/she should have the expertise to dig into the parameters of the code or database when required to debug performance issue
- Proven several years of professional experience, in-depth knowledge of database and DWH development (T-SQL)
- Multidimensional data modelling skills (Data Vault, Star Schema)
- Building Data Vault Modelling automation by
- creating various design patterns to modernisation of existing and legacy structures
- using metadata driven BIML scripts to create and maintain database objects and SSIS packages
- Well versed on change management processes using TFS and promoting code between environments Dev/UAT/Production.
- Experience using Azure DevOps and continuously detect data issues in the delivery pipeline and increase data validation coverage
- Business Dashboard performance improvement by tuning the cubes, partitions, loading patterns, query optimizations, indexing etc.
- Any experience with Kafka messaging is considered advantageous.
- Understanding of banking BI solutions, either in launching new features or redesigning existing systems.
Please get in touch for further information.
Michael Bailey International is acting as an Employment Business in relation to this vacancy.