Job Description :
Responsible for database logical and physical design and performance tuning on queries, optimize execution efficiency in MS SQL Server Environment. Develop Power BI reports, dashboards, implement complex hierarchical row level security, publish reports to power bi service and establish gate way refresh schedules. Implement Calculations, Perspectives, hierarchy structures, score cards and Key Performance Indicators KPI with outstanding visualizations using DAX, T-SQL. Work on Microsoft BI analytics stack (SSIS, SSAS) and work on investigating new tools, tool capabilities and engage with Business to propose, manage, implement solutions. Develop SSAS tabular models utilizing complex DAX functions and SQL queries, stored procedures using T-SQL, CTE, XMLA, PowerShell scripts. Architecting/Developing BI reporting from multiple database platforms SQL Server, Cloudera, SAP HANA, perform data mapping, data integration and understand business rule complexities