Senior MSBI & SSAS Developer

Sonoma Consulting Inc.; Redmond (WA); On-site; USD 80,000 - 120,000; Full time

Job summary

A leading consulting firm in the United States seeks an experienced data modeler with expertise in Multidimensional and Tabular data modeling. The ideal candidate will have at least 5 years of experience in IT, with hands-on knowledge of MDX and DAX queries, as well as cube processing techniques. This is a Full-Time permanent opportunity, and applicants must be U.S. citizens or authorized to work independently in the U.S.

Qualifications

• Bachelor’s degree required or equivalent experience.
• At least 5 years in Information Technology experience.
• Hands-on experience with MSBI/SQL Server projects.

Responsibilities

• In-depth understanding of Multidimensional data modeling schemas.
• Experience in Tabular data modeling and rationale.
• Hands-on experience in writing MDX and DAX queries.
• Experience in applying cube partitioning and processing techniques.
• Experience in applying various data security aspects for a Cube.

Skills

MDX

DAX

Data modeling

Cube processing techniques

Data security aspects

MOLAP

ROLAP

HOLAP

SSAS cube deployment

T-SQL

Team collaboration

Analytical skills

Education

Bachelor’s degree or foreign equivalent

Tools

Microsoft SQL Server

DAX queries

MDX queries

Job description

A leading consulting firm in the United States seeks an experienced data modeler with expertise in Multidimensional and Tabular data modeling. The ideal candidate will have at least 5 years of experience in IT, with hands-on knowledge of MDX and DAX queries, as well as cube processing techniques. This is a Full-Time permanent opportunity, and applicants must be U.S. citizens or authorized to work independently in the U.S.