MSBI Developer

Clarity Consulting
  • Gurgaon
  • 10-15 lakh
  • 4-7 years
  • Views
  • 05 Jun 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Solve complex business problems using technical knowledge

- Deliver the application feature using shortest possible lead time

- Improve the overall code base of the applications by ensuring compliance to coding standards and guidelines.

- Candidate must have standard MSBI (SSAS, SSRS, SSIS) skills on SQL Server 2008R2 (BIDS as

an IDE) and higher version of SQL Server (SSDT SQL Server Data tools as an IDE) that relate

to one or more of the following wherein SSRS (SQL Server Reporting Services) and

knowledge of SSAS (SQL Server Analysis Services)/MDX is key:

Person will be involved in SSAS (Cube creation, Writing MDX), SSRS Report

development on OLAP schema primarily using MDX, SSIS package creation,

execution and deployment of SSAS, SSIS, SSRS objects in a multi-environment setup

Experience in SQL Server version with SSDT SQL Server Data tools as an IDE will be

required from code base migration and development perspective for migrating from

SQL Server 2008R2 (BIDS as an IDE) to higher version SQL Server 2016 (SSDT SQL

Server Data tools as an IDE)

In addition to standard MSBI stack, candidates having practical knowledge on a

dash-boarding tool(Power BI/Tableau) will be given preference over others for this

position having experience in

Creating customized and interactive dashboards using multi-dimensional

data sources (SSAS Cubes) as well as relational schema

Knowledge on Dashboard Server administration/support

- Technical Documentation (Low Level Design, Technical specification/approach, PoC/Spikes)

and scripted unit testing

- Creating customized and interactive dashboards using multi-dimensional data sources (SSAS

Cubes) as well as relational schema using Power BI and Tableau

Standard Microsoft BI skills (SSRS, SSAS, SSIS) on SQL Server 2008R2 and higher version along

with a dash-boarding tool experience with primary focus on SSRS (SQL Server Reporting

Services) and MDX/Cubes, SQL Server 2008R2 & higher, a Dashboard skill set

Substantial technology experience of more than 4 years on BI&DW (Business

Intelligence & Data Warehouse)

Should have experience in OLAP/MOLAP schemas and writing MDX queries

Should have experience in SQLSERVER 2008R2 and above

Experience in MS BI Tools SSRS, SSAS and SSIS (knowledge on SSDT SQL Server

Data Tools IDE will be an advantage)

Data warehousing experience using SSIS package

Creation and Integration of SSRS reports to SharePoint

Worked on performance optimization for MSBI tool set SQL Server (T-SQL), SSAS

(cubes), SSIS, SSRS

Experience in a dash-boarding tool from development perspective

An understanding of the range of "Visualisations" that are available and how they

add value to the business when displaying data

Dimensional Modelling Experience

Microsoft BI tool set certifications

Trouble shooting knowledge in BI applications from development support


Other Microsoft technology skills

Having basic knowledge of SharePoint and Power shell scripting

Competencies/Skill sets for this job

Unit Testing Sharepoint Scripting Sql Server 2008 Coding

Job Posted By

About Organisation

Clarity Consulting