DWH functional Analyst

Description de la mission

We are searching for a DWH functional Analyst for out client in insurance. 

The business line (IS) Life is looking for a Functional Analyst to reinforce the IS LIFE DWH team. In this team, you will work with other analysts to deliver both business and regulatory project scope in the data warehouse. 

Mission period 

Expected Start date: ASAP

Duration: 24 months

(Depending on project evolution, extension is possible) 

Localisation 

Brussels centre 

Mandatory 

• Capable of working autonomously and in a team 
• Excellent interpersonal & negotiation skills 
• Excellent conceptual analysis skills (schema, graphs) 
• Excellent planning & prioritization skills 
• Critical thinker 
• Strongly motivated to work with Business & IT 
• Dynamic, pragmatic, diplomatic 
• Problem solving attitude 
• Someone who goes “all the way” in his/her work 

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 

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