Data Warehouse Development Support

  • Data Warehouse Development Support

    For one of our customers we are currently recruiting a Data Warehouse Development Support for their location in Maastricht, the Netherlands.

Job overview

Our Client is an intergovernmental organisation with 41 Members and 2 Comprehensive Agreement States. They are committed to building, together with their partners, a Single European Sky that will deliver the Air Traffic Management (ATM) performance required for the twenty-first century and beyond.With more than 1,900 highly qualified professionals spread over four European countries, deploying their expertise to address ATM challenges. Their expertise is unrivalled: covering both operational and technical elements; advising on both civil and military aspects of ATM and having experience at bringing States with different needs together for a common goal.

For one of our customers we are currently recruiting a Data Warehouse Development Support for their location in Maastricht, the Netherlands.


Tasks & Responsibilities

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

Requirements

  • 5 years of practical experience with Oracle VLDB;
  • 5 years of practical professional experience of the staff offered with ODI;
  • 3 years of practical professional experience of the staff offered with ODI automation using ODI SDK;
  • Experience in manufactured technical and user-facing documentation of data modelling and transformation design;
  • Practical professional experience with Data Vault and, specifically, Data Vault 2.0, or else provide convincing arguments of being able to learn and then apply Data Vault 2.0 methodology within three months;
  • Practical professional experience in modelling and handling spatio-temporal data in a self-service BI context is desirable;
  • Prior knowledge in specifically modelling air traffic, sector and airspace configuration, staff rostering and allocation, flow measures, weather, delay, and/or occurrences is desirable.

What do we offer

ATG Europe offers excellent working conditions and provides you with all the necessary means to further your career. We believe that training and education, combined with regular assessments and a personal development plan, will create the best environment for growth. If needed we also assist you with settling in your new home or finding the right school for your children. ATG will help in any way it can, including a relocation budget that is applicable for ATG staff as well as employees working at one of our clients.