Sr MSBI Developer

Sr MSBI Developer

ob Requirement 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 Exposure of any repository tool is good GitHub TFS Knowledge of Agile development its ceremonies Good communication and comprehension skills II 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 Skills SSAS SSIS DAX SQL Azure Data Factory ADF Power BI