Cubes, Measures, Dimensions

Top Three Skills:

Cubes, Measures, Dimensions

Job Description:

This is an internal customer facing role.

• Create and manage data marts and OLAP cubes in Microsoft SSAS, using Multidimensional and Tabular models.

• Perform dimensional modeling, and define semantic layers and BI Metadata repositories to support reporting and analysis.
• Utilize dimension intelligence, and create dimensions, measures, MDX functions, KPIs, Perspectives, Partitions, Roles, and Actions.
• Implement dynamic security, and configure cube for use via Cognos, Excel and Power View reports.
• Monitor and fine-tune SSAS server configuration, and use aggregation design wizard to optimize space and performance.
• Create SSIS packages for ETL processing.
• Ideal candidate can take a cube and add measures/dimensions and reports.

• Tableau experience is a plus.

Additional Information:Work Environment: Team Environment.

Interview Information: Phone/F2F with managers and CIO

Who is the Internal/External Customer: http://rws.allegisgroup.com/RWS/images/callout_question.gif

Internal customers that seek reporting/BI

Impact to the Internal/External Customer: http://rws.allegisgroup.com/RWS/images/callout_question.gif

Without this role they can not make intelligent business decisions based on data.

Business Challenge: They are looking to strengthen their BI offerings internally... where do we send certain inventory? Last year vs. this year reports, etc.

EVP: http://rws.allegisgroup.com/RWS/images/callout_question.gif

Small environment, large growth opportunity.

Non-Technical Skills: Communication - customer facing.

Why is position open?: Growth

• Good comm skills are a big priority
• Duration: 6+ Months