The team is working (Agile) to build out a new Enterprise Data Warehouse: IVL (information supply layer). This is built according to modern architectural principles and works with Data Vault Modeling (for connecting sources) and with dimensional modeling (for off-takes). The focus is on ETL (with Vaultspeed as an automation tool) & Data Vault modeling, with occasional dimensional modeling.

Ideal Profile

• Coming up with solutions obv analyses.

• Building a logical and physical data model to support the solution.

• Perform impact analyses and prepare technical analyses for coding.

• Formulate improvement proposals, e.g. around the use of the ETL tool.

• Maintain all documentation and processes and track relevant evolutions within own domain to contribute to the development and professionalization of the team.

• At least 5 years of experience in similar assignments

• Excellent knowledge of Data Vault modeling and 3NF modeling, and good knowledge of dimensional modeling.

• Good knowledge of SQL

• High seniority in DWH environments.

• Good knowledge ODI

Strengths

• Extensive experience with an ETL automation tool is a plus.

• Experience with or knowledge of Tortoise SVN and/or GIT.

• Knowledge of Oracle Exadata, Oracle Golden Gate, Oracle Enterprise Metadata Management or OBI