The senior BI Developer / Analyst should have an in-depth knowledge and experience with the Microsoft BI Stack (SQL Server, SSAS, SSIS and SSRS)
Mandatory Skills
• Good communication and analysis skills.
• Ability to work independently
• 5+ years’ experience in Microsoft Business Intelligence Tools
• Strong knowledge of database design with SQL Server database with experience in query optimization / performance tuning / trouble shooting
• Strong SQL development (T-SQL) experience showing ability to write complex stored procedures / functions / triggers
• Strong experience is developing Multidimensional models with in-depth understanding of MDX, Tabular models and DAX
• Experience in developing solutions using SQL Server Analysis Server (SSAS) using different storage models
• Strong experience developing, configuring and deploying complex, data driven SSIS packages
• Report / dashboard development using SSRS / Power BI / Excel with data from SQL Server Database / Analytics Cube
• Experience in design, development and implementation of data warehouse solutions
• Data gathering, research and analytical abilities to develop insightful solutions to address Business requirements
Desirable Skills
• Any certification in the MSBI stack is a plus.
• Knowledge of a programming language / framework (like C# / .Net / Angular) is an additional advantage
• Retail domain background is an advantage.
• Power BI / Azure Analysis services / Basic DBA