Senior MSBI Developer 6 to 9 years PAN India

Will be responsible for analyzing the data feeds and design a data warehouse in third normal form.

Responsible for the end-to-end implementation of data warehouse, data marts and semantic layer in accordance with the defined architecture.

Responsible for implementing the semantic layer using the SSAS tabular model with row level data security.

Creation of measures and implementing the advanced computations using DAX and maintaining the traceability matrix for the same.

Overall documentation of the data warehouse and semantic layers.

Administering the data warehouse and ensure the data security and encryptions wherever applicable.

Implementation and Support of SSIS packages and SSRS repots.

Master in SQL and data warehouse concepts.

Good understanding in Azure architecture and implementation.

Understanding of Azure fundamentals, Data Lake and Synapse implementation.

Primary Skills

At least 2 years of experience in SSIS packages - Design, Develop & deployment

Extensive experience SQL Server 2016, 2019 - stored procedures, views, indexes, CTE, optimizing SQL

Good knowledge of SSAS - Tabular model, portioning, perspective

Experience in writing and optimizing and DAX queries

Hands on experience in Azure Data factory - design and implementation

Secondary Skills

Exposure of any repository tool is good - GitHub, TFS

Knowledge of Agile development & its ceremonies

Good communication and comprehension skills

Full time