We are looking for an experienced Data Warehouse Software Engineer to work at our client in the beautiful south of the Netherlands.
We are looking for a Data Warehouse Software Engineer for our client located in Maastricht, The Netherlands who will be responsible for executing, database and software development to automate the ingestion of a number of data sources of varying complexity such that they
become available for self-service analytics.
Questions about this position?
Meet your new career coach
Tasks & Responsibilities
The successful candidate be working on the following:
Source analysis (with support by MUAC);
Reverse engineering and maintaining metadata for source systems and all layers of DWH enabling automation of loading patterns;
Modelling of the source data in Data Vault 2.0 standard;
Automation of Data Vault 2.0 loading patterns using SQL, Groovy, ODI SDK and ODI KM;
Development of an ODI configuration to automate ingestion of the source data into a staging area;
Improvements of a framework for automatic generation of ODI transformations of the data from staging area into the Raw Data Vault and further to some areas of Business Vault layer;
Development of transformations of the data from Raw Data Vault to Business Vault layer, including implementation of Soft Rules;
Development of transformations of the data to self-service presentation layer (including dimensional models, 3NF relational models and flat wide de-normalized reporting tables/views);
Development of historical data purging rules;
Technical and user-facing documentation of the data modelling design and transformation design;
Development, execution and reporting of integration and user acceptance tests, including example Tableau visualisations;
Mandatory educational requirements:
Bachelor degree in Computer Science with a specialisation on software development in a business intelligence database context, or equivalent. Mandatory Technical/Professional Qualification:
At least 5 years of practical professional experience with ODI and automation using ODI SDK.
At least 5 years of years of practical professional experience with Tableau or similar self-service tools;
At least 5 years of practical professional experience with Data Vault and, specifically, Data Vault 2.0 (if no experience, proof of ability to learn in three months)
At least 3 years of practical professional experience with VLDB;
At least 3 years of practical professional experience with data business modelling and provision in a self-service context;
Proven practical experience in previously successfully manufactured technical and user-facing documentation of data modelling and transformation design by the staff offered;
Proven practical experience in modelling and handling spatio-temporal data in a self-service BI context.
Knowledge of modelling air traffic, sector and airspace configuration, staff rostering and allocation, flow measures, weather, delay,
Proficiency in English, well spoken in technical and user facing circumstances, and in writing technical documents. Mandatory Experience/Skills:
Proven ability to work independently as well as part of a multi-cultural team;
Proven ability to accept different opinions with views to provide the best customer service and achieve customer satisfaction;
Proactive and positive personality with a hands-on approach and good commitment to getting a job done.