6+ years of overall experience with majority experience in multiple tools of the MSBI
suite of products (SSIS/SSRS/SSAS/Power BI, Power View, Power Pivot, Power Query,
Power Map)/ PerformancePoint (on Share Point)/MDS/DQS/Data Mining)
Experience in the UN/UNHCR is an asset
Excellent oral and written communication skills
Computer Science or related degree
Experience with Microsoft Business intelligence Platform:
Microsoft SQL Server Business Intelligence toolset, especially Integration Services and
Analysis Services in SQL Server 2008 / 2012 or later.
Data warehouse and data mart design including logical design (dimensional
modelling), physical design, data quality and ETL.
Deep understanding of, relational database design, multidimensional database
design, OLTP, OLAP, KPIs, Scorecards, and Dashboards.
Experience developing database solutions using TSQL language.
Experience with MDX.
Experience developing presentation layer using Reporting Services.
Application Lifecycle management for BI solutions.
Nice to have:
Experience with Power Pivot and Power View.
Experience with SharePoint BI components (Excel Services, PerformancePoint
Services, Power Pivot Services, Reporting Services in SharePoint).
Knowledge in Windows Network and Security concepts.