T-SQL Power BI Tech Lead

Job Description

Must have, 5-9 Years of experience in the Design and Development of E2E BI & Analytics projects in a global enterprise environment. Strong T-SQL Experience (Defect triaging, Build T-SQL procedures, TVF, Views, Ragged hierarchy, Cursors, Loops, Working with local/global parameters, Reports. ability to review an existing T-SQL code block, ETL load issues, identify performance bottlenecks and tune where required. Articulate the changes and root-cause to the manager) Good knowledge of database performance and tuning, troubleshooting and query optimization. Proficient in Data warehouse design and BI application development Deep understanding of writing SQL code. Nice to have , Experience in Power BI, SSAS tabular modelling, Azure Data Factory and DAX on Azure Platform is good to have. Experience in Cloud Platforms, Azure technologies like Azure Analysis Services, etc. is good to have. Experience in CRM systems like sales force is good to have. Experience working with dataset ingestion, data model creation, reports, dashboards, etc is good to have. Experience in other reporting tools is good to have. Demonstrated Ability to use GIT, Jenkins and other change management tools is good to have. Good knowledge of database performance and tuning, troubleshooting and query optimization.