MSBI 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

Mandatory

• In-depth understanding of the Multidimensional data modeling schemas
• Experience in Tabular data modeling and understanding of rationale to use tabular data model.
• Hands on experience in writing MDX, DAX queries
• Experience in applying the cube partitioning and cube processing techniques
• Experience in applying various data security aspects for a Cube
• Understanding of MOLAP, ROLAP and HOLAP data storage and processing technique when to use what
• Knowledge of SSAS cube deployment methods in various production scenarios (Knowledge of XMLA)
• In depth understanding of SSAS Skills including DAX queries, experience in building tabular model/dimensional cube etc
• Design consideration of hierarchy, facts, dimensions, relationships, and impact on cube performance
• Experience in applying DW/BI design concepts
• At least 2 years of hands on experience in Design, Development & Build activities in MSBI – SQL Server Projects
• At least 4 years of experience in Software development life cycle
• At least 2 years of experience in DW/BI related technologies using Microsoft SQL Server - MUST
• At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
• At least 2 years of experience in Design and Architecture review
• Hands‑on development mentality, with a willingness to troubleshoot and solve complex problems
• Ability to work in team in diverse/ multiple stakeholder environment
• Willingness to learn and work on new technologies
• Strong analytical skills
• Experience and desire to work in a Global delivery environment
• Experience in developing custom visualization using type scripting/R Script/M Query preferred
• UX Expert with knowledge of visualization. Develop wireframes by different person as preferred

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 5 years of experience in Information Technology.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
This is a Full-Time / Permanent job opportunity.
Visa: Only US Citizen,GCand GC-EADcan apply.
** All your information will be kept confidential according to EEO guidelines.