Job descriptionMust have experience in MSBI ArchitectureMust have experience in data analysis and business requirements gathering (experience in writing business-driven user stories will be an advantage)Experience in SSAS, SQL, and PowerBI (1-2 years in each of the skills) Preferably more experience in SQL, Stored Procs, Performance tuning, Query optimization, PowerBI reportingWorked on complex SSIS and DTS packages for ETLUsed T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, query writing, and SQL joinsPerformance Tuning, Handling Indexes, and Query OptimizationKnowledge in SSAS tabular model with partitions; created measures using DAX functions, MDX.Developed Power BI dashboards using Power BI desktop and publishing it in the Power BI Analytics serverKnowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP