Data Warehouse Consultant

Our client, an energy provider located in Brussels, is looking for a DATA WAREHOUSE CONSULTANT to administrate a DATA WAREHOUSE that they are building. The DATA WAREHOUSE CONSULTANT will work at our client in Brussels for at least 6 months.

Scope of work:

Our client is currently building its DATA WAREHOUSE in order to facilitate and optimize its data collection processes and reports production. This DATA WAREHOUSE will also be used as the source for information for its new Transparency Web site part of the EU Regulation 715.

In order to build the system, our client has selected a system integrator and a consultant already on board since September 2013.

In order to prepare the transition from the project phase to the operation one, this document describes the tasks that will need to be fulfilled by the future tool administrator. These tasks aim at both:

- Reinforcing the project team to complete the project
- Facing needs related to data analysis and data warehouse expertise necessary to the administration and follow-up of the product after the go-live of the project

The detailed breakdown of tasks to be carried out is:

> During the course of the project:

§ Participate to the validation of test cases and corresponding

§ Participate to system/functional/performance testing of the Data Warehouse, its standard reports, cubes and other data analysis means

Administration of the Terms of Reference

§ Participate to the management of the Master and Reference Data

§ Review detailed functional specifications

§ Propose potential detailed functional specification enhancements

§ Enhance and document the data governance processes

§ Prepare the go-live

> Following project go-live:

§ Ensure post go-live support to system users

§ Manage master and reference data

§ Liaise with the system integrator in order to follow-up bug fixed and other system enhancements

§ Monitor functional errors and be the point of contact for TSOs integrated with the system

§ Develop new queries and reports for users

§ Train users to Microsoft BI suite mechanisms

§ Preliminary analysis of evolution need

Following the go-live, the administrator will work in close collaboration with the data analysts of both System Development and System Operations. In order to ensure continuous TSO involvement, a group of TSO IT Experts to be chaired by the administrator could be established.

Requirements:

- General IT knowledge and experience
- Knowledge of databases management and in particular Data Warehouse solutions
- Knowledge or experience in Microsoft BI suite (SSDB, SSIS, SSAS, SharePoint, PowerView)
- Knowledge of Excel tools including pivot tables
- Experience in data integration/B2B solutions
- Hands on skills in custom queries development and report development
- Knowledge in the energy sector, more preferably in the gas sector and moreover in the gas transmission area is a plus considering the complexity of the data model (complexity of gas network model and aggregation principles)

Keywords: BI, data warehouse, datawarehouse, SSIS, datawarehouse administrator