BI Developer- SSAS Developer- SSAS/MDX- Wiltshire

BI DEVELOPER/BUSINESS INTELLIGENCE DEVELOPER/DATA WAREHOUSE DEVELOPER (SSAS MDX)REQUIRED TO WORK FOR OUR CLIENT BASED NEAR TO SALISBURY, WILTSHIRE, SOUTH WEST.

Looking for someone with a minimum of 5 YEARS EXPERIENCE AS A DATA WAREHOUSE DEVELOPER USING THE MICROSOFT 2012 STACK

Significant experience in SSAS and MDX is essential and candidates will be expected to demonstrate design and development of a number of cubes from scratch and a sound knowledge of cube administration, performance tuning and optimisation. Experience of SSAS Tabular 2012 and DAX is desirable.

The role is for an end to end full life cycle data warehouse implementation and requires experience in every aspect from requirements documentation through design and development to Testing/UAT and User Training and deploying to a production environment. The successful candidate WILL BE FLUENT IN ETL DESIGN AND DEVELOPMENT USING SSIS AS WELL AS HAVING A COMPHRENSIVE UNDERSTANDING OF THE DQS, MDS AND SQL SERVER 2012 SSIS FEATURES.

Being able to demonstrate dimensional modelling expertise is essential (Kimball); experience of using Datamodelling tools is desirable.

KEY EXPERIENCE REQUIRED:

Demonstrate using SSIS frameworks is essential; experience of using ETL tools is desirable.

Demonstrate dimensional modelling expertise is essential (Kimball); experience of using Datamodelling tools is desirable.

TECHNOLOGY TOOLS REQUIRED:SQL Server 2012 (2008R2 may be considered) SSIS (Framework/BI Express) (VB.NET/C# preferred) SSAS (Multidimensional MDX Essential: Tabular DMX/DAX would be a bonus) SSRS SharePoint 2010/2013 (BI)o PowerPivot o PowerViewo PerformancePoint TFS BI Express (Preferred) ER Win/Talend (Preferred)

DEVELOPMENT LANGUAGES:T-SQL (Expert) MDX (Essential) DAX (Including many-to-many relationships) desirable (VB.NET/C#) desirable

DATA-WAREHOUSE KNOWLEDGE/SKILLS:Requirements Gathering and documenting Dimensional Modelling Kimball ETL design and developmento Data qualityo Transformationso Loading Meta Data management Cube design and development Cube optimisation and performance tuning Best practice in SSIS and SSAS Data-warehouse management/administration Report/Dashboard design ITIL/Agile environments Documentation and knowledge transfer Experience of deployment to production environments

For further information please apply online in the first instance.

- SmartSourcing provides services as an Employment Agency and welcomes applications from all suitably qualified people regardless of age, race, religion, disability, age, gender or sexual orientation.