Microsoft Business Intelligence

Sonsoft Inc

Apply to this job
Redmond, WA, us on site Until 8/21/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 2026
Job description

SonSoft Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. SonSoft Inc is growing at a steady pace specializing in the fields of Software Development, Software Consultancy, and Information Technology Enabled Services.

  • 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 personas preferred
  • 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 within the Information Technologies.

Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)


** 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.

Note:-

  1. This is a Full-Time & Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder can apply.
  3. Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Design, develop, and maintain MSBI solutions including SSAS cubes and data models.

Job title

Microsoft Business Intelligence

Experience level

5+ years

Industry

software

Location requirements

Redmond, WA, US; remote not specified

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

MDXDAXcube partitioningcube processingSSASXMLASQL Server

Preferred skills

scriptingR scriptvisualizationwireframes

Specializations

multidimensional data modelingtabular data modelingMDXDAXcube processing
Locations

Structured locations inferred from the posting.

Redmond, WA, USA

On-site City