SSAS, Cubes, Measures/Dimensions / Database developer

Top Three Skills SSAS, Cubes, Measures/Dimensions Position Database Developer (SSAS) Develop and maintain data marts and SSAS cubes in a Microsoft SQL Server 2012 environment. Position Responsibilities 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. Assist with database optimization and basic database/SSIS administration. Architect the system for efficiency, and implement best practices. Participate in design sessions with other developers in the development team. Analyze data and provide recommendations on new metrics and functionality. Assist business analyst with documentation as needed. Work on multiple projects simultaneously in a fast paced environment. Communicate effectively with different groups, and work as a team-player. Perform on-going research to explore new features, versions, and related technologies, and provide recommendations to enhance our offerings. Knowledge / Skills / Abilities Very strong knowledge of Data‑Warehousing concepts. Very strong experience using SSAS in SQL Server 2008 or above. Good experience with SSIS. Very good analytical and problem solving skills. Proficient in data validation, interpreting and displaying data. Ability to work and deliver in an environment with little supervision. Strong interpersonal skills and ability to communicate effectively. Strong desire to explore new features and product capabilities. Position Qualifications (Required) Bachelor's degree in Computer Science or Information Systems or a related field from an accredited college/university. Minimum 5 years related experience in SQL Server 2008 or above. Position Qualifications (Preferred) Experience within the healthcare industry. Knowledge of SSRS, SharePoint, or Cognos is a huge plus. MSI is an equal opportunities employer; we value diversity at all levels of our organization. EOE/AA/M/F/D/V Additional Information Good communication skills are a big priority. Duration: 6+ Months. #J-18808-Ljbffr Intelligence and National Security Alliance