# Microsoft Business Intelligence — SonsoftInc

- Location: Redmond, WA
- Posted: May 5, 2017
- Status: open (checked Nov 20, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/115367919
- Employer record: https://visajobs.io/company/sonsoft.md

## Sponsorship history
- Tier: Employer history only
- Occupation (SOC): Data Scientists (15-2051)
- Employer's certified LCAs for this occupation in WA, FY2024–FY2026: 0
- …in the whole US: 0
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $86k / $118k
- Staffing / consulting firm: 100% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
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
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 within the Information Technologies .
Additional Information
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:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen , Green Card Holder can apply.
Please mention your Visa Status in your email or resume .
** All your information will be kept confidential according to EEO guidelines.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
