The Data Warehouse is a Terabyte in size and is composed of Support
Site data, surveys, and various other customer data built on SQL
2005. They use SSAS to generate reports from the DW, Excel pivot
tables and SSRS. They don’t have anyone creating great reports, so
just using SSRS.

They have a separate metadata ETL framework with data being brought in
using SSIS, which has a set of properties defined in SQL tables
(Attributes, objects, etc.).

Responsibilities and examples of what we would want the candidate to
have done in the past, at a minimum, would be:

* Consolidate the dimensions & measure groups from two SSAS databases
into a single SSAS database

* Deliver framework for using XMLA to add/alter existing SSAS objects
without the need for re-processing dimensions and partitions.
Instruct other developers on the use of the above framework.

* Use MDX to script calculated measures.

* Set parameters in the mdmsrv.ini file to optimize dimension/
partition processing and query performance.

* Implement usage-based aggregations in production cubes.

* Recommend other SSAS optimizations as necessary.

Qualifications

* Strong DB / OLAP Developer with cradle to grave experience with Data
Warehouses and OLAP, from analysis to implementation and optimization.
Currently, some of the queries take hours to run because they were
written by intermediate level devs, so the Sr. Dev needs to optimize
the query to get it to run much faster.

* Must be able to write MDX queries and experience with aggregates and
measures

* Ability to review DW data model and suggest performance
improvements, or be able to redesign it if necessary.

* Complex query optimization experience is required

* Must be able to build OLAP cubes from whatever sources they receive
data

APPLY ONLINE:
http://agilerecruiter.solutionsiq.com/agilecan/starthere.php?job=2218

/j99908