Multidimensional Microsoft SSAS Analysis Services Cubes, MDX (V. SQL Server 2008 Or Later)
Data Warehouse
Advanced T-SQL and Query Performance Tuning.
Microsoft SSRS Reports (SQL Server Reporting Service) (V. SQL Server 2008 Or later)
Job Description:
Designing, developing and deploying end-to-end complex ETL (Extract, Transform, Load) packages using Microsoft SQL Server Integration Services (SSIS)
Developing and supporting multi-dimensional Microsoft SSAS Cubes using Analysis Services and MDX
Developing, deploying and maintaining Business Intelligence (BI) Dashboard Solutions
Integrating BI solution components such as Power BI, Power Pivot, Excel spreadsheets, On-premise data sources, and Cloud services / Office 365
Strong T-SQL skills managing DDL, Views, Triggers, Stored Procs, Query Performance Tuning and other SQL objects. Implementation understanding in designing and deploying Data Mart (Data Warehouse) schema on SQL Server Platform (v. 2008 or later)
Designing and developing Microsoft SQL Server Reporting Services (SSRS) using SQL Server 2008 or later versions