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