Require 5years of experience in MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
Good awareness on DW architecture and design using MSBI
Strong knowledge of Dimension Modeling
Proficient in creating different types of cubes/schemas in Analysis Services
Proficient in creating and testing new KPI's, perspectives and calculations
Experience in creating SSRS reports from cubes
Experience in PowerPivot and its Integration with SharePoint
MDX Query writing experience
Coordinate with customer, vendor and onsite/offshore folks
Knowledge of Data Warehousing and Data Modeling concepts, specifically designing and populating normalized data warehouses and star schema based data marts
Experience and understanding of in Production support and performance engineering