Microsoft DWH Administrator

Brussel  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

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.

Start date
ASAP
Duration
6 months
From
Templeton and Partners
Published at
02.07.2014
Project ID:
735373
Contract type
Freelance
To apply to this project you must log in.
Register