SSAS, Cubes, Measures/Dimensions / Database developer

Intelligence and National Security Alliance; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

MedSynergies in Dallas, TX, seeks a Database Developer to design and maintain SSAS data marts and cubes in a Microsoft SQL Server environment. You will use multidimensional and tabular models, build semantic layers, and support reporting and analysis.

Ideal candidates have strong data-warehousing knowledge and 5+ years of SQL Server SSAS/SSIS experience, with the ability to collaborate on multiple projects in a fast-paced setting.

Qualifications

• 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.
• Position Qualifications (Required)
• Minimum 5 years related experience in SQL Server 2008 or above.

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

Skills

SSAS

Cubes

Measures/Dimensions

SSIS

Data Warehousing

Education

Bachelor's degree in Computer Science or Information Systems

Tools

SSIS

SSRS

Cognos

SharePoint

Job description

Company Description

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.

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.

Additional Information

1. Good comm skills are a big priority
2. Duration: 6+ Months