We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.
In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.
We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.
Job DescriptionTop 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
Additional Information- Good comm skills are a big priority
- Duration: 6+ Months
Skills Required
- 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
- Create dimensions, measures, MDX functions, KPIs, Perspectives, Partitions, Roles, and Actions
- Implement dynamic security and configure cubes for use via Cognos, Excel and Power View
- Monitor and fine-tune SSAS server configuration and use aggregation design wizard to optimize performance
- Create SSIS packages for ETL processing
- Ability to take an existing cube and add measures/dimensions and build reports
- Tableau experience
- Strong communication and customer-facing skills
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
.jpeg)
