T-SQL Power BI Tech Lead

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.