Experience Minimum 3 years of direct work experience
Knowledgeable in the design, construction and management of Data Warehouse and Business Intelligence solutions
Knowledge of problem analysis, structured analysis
, and design and programming techniques.
Good grounding in development best practice skills, including requirements definition; analysis; design; testing; implementation; documentation and support.
Must have strong skills in Microsoft SQL Server 2005/2008 including.
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
SQL Server Reporting Services (SSRS)
Experienced in developing Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft SSRS, SSAS, and MDX in a data warehousing environment.
Experience in the design and implementation of ETL processes;
Experience developing and running MDX queries
Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
Advanced knowledge of and OLAP/MOLAP technologies and dimensional modelling, including applicability to various reporting problems.
Knowledge of any of the following would be advantageous
BI Tools including ProClarity, MS Performance Point and SPSS Clementine
MS Visual Studio;
Cubes and Data marts
Data Warehousing methodologies especially Kimball;
Previous experience in consumer and marketing data, analysis and reporting