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
• 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.
** 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.
Skills Required
- In-depth understanding of multidimensional data modeling schemas
- Experience in tabular data modeling and rationale for using tabular models
- Hands-on experience writing MDX and DAX queries
- Experience applying cube partitioning and cube processing techniques
- Experience applying data security aspects for SSAS cubes
- Understanding of MOLAP, ROLAP and HOLAP storage and processing techniques
- Knowledge of SSAS cube deployment methods in production scenarios (XMLA)
- Deep SSAS skills, including building tabular models and dimensional cubes
- Design consideration of hierarchy, facts, dimensions, relationships and performance impact
- Experience applying DW/BI design concepts
- At least 2 years hands-on experience in MSBI - SQL Server projects
- At least 4 years of experience in the software development life cycle
- At least 2 years experience in DW/BI technologies using Microsoft SQL Server (MUST)
- At least 4 years experience in project lifecycle activities on DW/BI development and maintenance projects
- At least 2 years experience in design and architecture review
- Hands-on development mentality and ability to troubleshoot complex problems
- Ability to work in a team with diverse/multiple stakeholders
- Willingness to learn and work on new technologies
- Strong analytical skills
- Experience and desire to work in a global delivery environment
- Experience developing custom visualizations using TypeScript, R Script, or M Query
- UX expertise with knowledge of visualization and ability to develop wireframes
- Bachelor's degree (or equivalent) or relevant progressive experience in lieu of education
- At least 5 years of experience in Information Technology
- Must be U.S. Citizen, Green Card holder, or GC-EAD (no visa sponsorship available)
What We Do
Sonoma Consulting Inc. is a national IT consulting and executive search firm founded in 2011 by Mark McGee. The company operates through two business divisions—IT Consulting Services and Executive Search—serving approximately 150 national clients that range from entrepreneurial start-ups to Global Fortune 500 companies. It specializes in harmonizing systems and application or infrastructure development projects.
