Sonoma Consulting Inc. Logo

Sonoma Consulting Inc.

MSBI Developer

Posted 17 Days Ago
Be an Early Applicant
In-Office
Redmond, WA, USA
Senior level
In-Office
Redmond, WA, USA
Senior level
Design, develop, and maintain MSBI/SQL Server DW/BI solutions including SSAS tabular and multidimensional models. Build and optimize cubes (partitioning, processing), write MDX/DAX, apply cube security, perform design and architecture reviews, deploy via XMLA, troubleshoot performance, and create/customize visualizations (TypeScript, R, M). Collaborate in global delivery teams and follow DW/BI design concepts.
The summary above was generated by AI
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, GC and GC-EAD can apply.
** All your information will be kept confidential according to EEO guidelines.

Similar Jobs

12 Days Ago
In-Office
Redmond, WA, USA
Mid level
Mid level
Information Technology • Professional Services • Software • Consulting
Design, develop and maintain DW/BI solutions using MSBI and Microsoft SQL Server. Perform architecture and design reviews, build ETL/ELT frameworks, troubleshoot complex issues, and collaborate with global stakeholders. Power BI reporting knowledge desired.
Top Skills: EltETLMicrosoft Sql ServerMsbiPower BI
12 Days Ago
In-Office
Redmond, WA, USA
Mid level
Mid level
Information Technology • Professional Services • Software • Consulting
Design, develop and maintain data warehouse/BI solutions using MSBI and Microsoft SQL Server. Build ETL/ELT frameworks, perform design and architecture reviews, create SQL Server projects, and support report creation (PowerBI desired). Troubleshoot complex issues, collaborate with global stakeholders, and follow DW/BI best practices throughout project lifecycles.
Top Skills: Data WarehousingEltETLMicrosoft Sql ServerMsbiPower BI
12 Days Ago
In-Office
Redmond, WA, USA
Mid level
Mid level
Information Technology • Professional Services • Software • Consulting
Design, develop and maintain Microsoft BI solutions (SSAS cubes, tabular models). Write MDX/DAX, apply cube partitioning/processing and security, perform design and architecture reviews, and support DW/BI implementation and performance consideration.
Top Skills: DaxHolapMdxMicrosoft Sql ServerMolapMsbiMultidimensional ModelingRolapSsasTabular ModelXmla

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account