Senior MSBI Developer | 6 to 9 years | PAN India

Job Description

• 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