Database Developer (SSAS)

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

Job summary

MedSynergies is seeking a Database Developer (SSAS) to design and maintain data marts and OLAP cubes in a SQL Server environment. You will perform dimensional modeling, create MDX measures, and configure security for BI reporting across Cognos, Excel, and Power View.

The role requires strong data warehousing knowledge, 5+ years on SQL Server 2008+, and collaboration with cross-functional teams in a fast-paced setting. Contract options include Contract, CTH, or DP.

Qualifications

• Bachelor's degree in Computer Science or Information Systems or related field.
• Minimum 5 years related experience with SQL Server 2008 or above.
• Strong knowledge of data warehousing concepts and SSAS in SQL Server.
• Experience with SSIS, SSRS and related BI tools is preferred.
• Healthcare industry experience is a plus.

Responsibilities

• Create and manage data marts and OLAP cubes using SSAS in SQL Server.
• Perform dimensional modeling and define semantic layers for BI reporting.
• Develop MDX, KPIs, Perspectives, and cube security configurations.
• Build ETL packages with SSIS and optimize SSAS/ETL performance.
• Collaborate with analysts and developers on multiple projects.

Skills

SSAS

Cubes

Measures/Dimensions

Data-Warehousing concepts

SQL Server experience

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science or Information Systems

Tools

SQL Server

SSIS

SSRS

SharePoint

Cognos

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
3. Phone then a face to face interview
4. Contract, CTH or DP – client is open to all options