Job description

Top Three Skills: SSAS, Cubes, Measures/Dimensions Job Description: • 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 in 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: MedSynergies partners with health care organizations and physicians to improve the way healthcare is delivered in the communities they serve. Recently named one of the fastest growing companies in Dallas and one of the ?five who will thrive? by the Dallas Business Journal, MedSynergies is a recognized national leader in revenue cycle management and hospital-physician alignment solutions. • Good comm skills are a big priority • Duration: 6+ Months

Requirements

Must-haves

SSAS, Cubes, Measures/Dimensions
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.

Nice-to-haves

Position Qualifications (Preferred)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

Vision