DWH Functional Analyst

Description de la mission

We are searching for a DWH Fuctional Analyst for our client on assurance industry. 

ASAP

Duration : 12 months 

Brussels centre 

Min. 3 years of professional experience in analysis of Business requirements and set up of detailed IT requirements

Knowledge of functional aspects of data warehousing and reporting

Expert knowledge of

Data modeling :

Kimball dimensional modeling o SQL

Very good knowledge of Microsoft Office tools (Word, Excel, Visio)

Good knowledge Power BI Desktop/Online

Preferable : 

SQL Server Database

SQL Server Integration Services

SQL Server Analysis Services – Tabular

PowerBI Report Server

Git

SAS Base / Enterprise Guide

SAS Data Integration Studio

DB2 (Only DML for analysis purposes)

Basic COBOL, exclusively for extracting data

Translate the business requirements into functional requirements, adhering to the architecture in place. Pro-active communication and collaboration with power users.

Guide and support business users in the adoption and usage of the reporting environment.

Create and maintain the dimensional models

Manage the functional documentation

Coordinate the development and acceptance activities.

Functional testing the deliverables.