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