Developer (SQL, SQL Server, ETL) for Cyber Platform (m/f/d)

We are one of the leading international recruitment agencies for the procurement of highly qualified experts in fields such as IT lifecycle management, SAP, engineering, commerce and specialist consultancy.

For our client we are currently looking for a

Developer (SQL, SQL Server, ETL) for Cyber Platform (m/f/d)

General information
Reference: 168457
Location: Remote (+ maybe Munich)
Start: 03.06.2024
Volume: flexible / min. 50%
Duration: 30.09.2024
Languages: English and German (nice to have)

Your Skills
- Min. 8 years experience in developing and knowledge in cyber platforms
- Very good knowledge in MS SQL Server setup, development activities, ETL pipelines, partitioning and optimiezed index settings
- Know-how in stored procedures to transform de-normalized input into the target model (incl. insert, update, delete of dimensional tables and filling in IDs in fact tables)
- Experience with Azure DevOps
- SCRUM knowledge
- Nice to have: Experience in CDC or an easy-to-implement alternative to prepare incremental updates to a) a SSAS model and b) a DWH model
- Language skills: English must have, German nice to have

Your Tasks
- This Cyber Platform project aims at creating a centralized platform for risk assessment and premium calculation.
- The platform will utilize pre-calculated data features and criticality indicators to provide more accurate and efficient risk assessments, reducing response times and improving the overall customer experience.
- Implement a kind of a Star Schema Model (i.e., not fuzlly de-normalized, but also not fully normalized)
- MS SQL Server setup and development activities, ETL pipelines, partitioning, optimized index settings
- Stored Procedures to transform de-normalized input into the target model (incl. insert, update, delete of dimensional tables and filling in IDs in fact tables)
- Optional: CDC or an easy-to-implement alternative to prepare incremental updates to a) a SSAS model and b) a DWH model
- Support regarding data pipelines
- Create data migration model

Interested?
We look forward to receiving your application documents in electronic form.