BI- SSAS developer

Sonoma Consulting is seeking a Senior BI Developer to design and develop complete BI solutions using SSAS, SSIS, and T-SQL. The role requires strong knowledge of relational and multidimensional databases, as well as excellent communication and project management skills.

Requirements

• 10+ years of experience in Microsoft BI development using SSAS
• 5+ years of experience in writing T-SQL scripts on various versions of SQL server
• 5+ years of experience with complete SDLC lifecycle in BI development
• 3+ years of experience in SSIS for data integration/ETL technologies
• 3+ years of design and development experience in SSRS
• 3+ years of experience in using SSMS for design of tables, views, common table expressions, foreign key constraints, and stored procedures
• 2+ years of experience in SQL server 2012 is required, SQL server 2014 is preferred
• 2+ years of experience in MDX, DAX language is highly required
• Exposure to Power BI and Tabular reporting is preferred