Description
Responsibilities- Helps design, implement and build a new BI and Data Warehouse environment utilizing SSAS, SSRS and SharePoint.
- Handles complex cube designs and MDX calculations, performance tuning MDX and SQL processes, SSRS Reports design, development and Performance Point Dashboards.
SKILLS
Must have at least four (4) years of experience in SQL Server 2008. Expert knowledge of SQL Server Analysis Services (SSAS) (5+ years) is required, as is expert knowledge of Multidimensional Expressions (MDX) (4+ years). Expert knowledge of Structured Query Language (SQL) (5+ years) is essential. Must have expert knowledge of SharePoint 2010 BI capabilities (2+ years) and strong knowledge of Performance Point Services (3+ years). Strong knowledge of SQL Server Reporting Services (SSRS) (4+ years) is needed. Working knowledge of Transact-SQL programming (stored procedures, triggers, views) is also necessary. Must have experience working with Microsoft Visual Studio and TFS, as well as experience architecting and developing data warehouses, data marts and analytical cubes. Working knowledge of database theory and design (logical & physical design) required. Skills with SQL Server 2012 BI and SharePoint Enterprise 2013 are highly desirable.
Synectics is an Equal Opportunity Employer.