Description
Microsoft Datawarehouse Administrator - euro;500 - 6 months - Brussells
Microsoft datawarehouse administrator is required by our client who 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.
The project for the data warehouse and a new Transparency website. The project started in September 2013 is divided into several phases, the last one due at the end of September 2014.
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 our clients 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
Description of tasks and organization of work
As the difference with Transparency Platform the new website/TP project will be owned by our client(the integrator providing a level 2 support/maintenance) and covers a much wider range of features. Therefore our client will have to ensure the actual administration of the tool in order to fully use its potential.
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 new website
The role:
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 inside and potentially outside the business
Train users to Microsoft BI suite mechanisms
Preliminary analysis of the new websiteTP evolution need as defined by the clients Working Areas
The administrator will be under the General Area and will be part of the Project Team until the go-live.
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.
Necessary skills:
The completion of the tasks detailed above supposed that the administrator is familiar with the following tasks:
> 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)
Administration of the PDWS
MUST BE ABLE TO SPEAK FRENCH, DUTCH AND ENGLISH FLUENTLY!
If this is of interest please send your CV through.