Minimum Requirement (10+ years experience must)
Knowledge of SQL to write complex, highly optimized queries across large volumes of data
Successful work experience in MS SQL programming, database design, data warehouse design, query performance tuning and writing stored procedures.
Minimum 10 years of experience on MS BI tools (SSIS, SSRS, SSAS, Power BI, Azure Analysis Services)
Experience with development of Snowflake SQL procedures and views
Notable Responsibilities
Backlog Management, Project and Support Deliverables, Adoption
Develop, deploy, maintain, and debug Snowflake SQL procedures and views
Develop, deploy, maintain, and debug Power Bi Datasets and reports
Develop, deploy, maintain, and debug Power Bi Report Builder Reports
Experience with using Visual Studio for development of SSRS or Power BI paginated reports
Experience with Azure Dev Ops and source control
Investigate and resolve problems of data accuracy and availability Participate in design and code reviews.
Identify architectural issues and propose alternative solutions.
Develop and maintain data warehouse documentation.
