• Must have experience in MSBI Architecture
• Must 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 reporting
• Worked on complex SSIS and DTS packages for ETL
• Used T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, query writing, and SQL joins
• Performance Tuning, Handling Indexes, and Query Optimization
• Knowledge 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 server
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP