Design, develop, and build Microsoft SQL Server BI solutions, including tabular models and dimensional cubes.
Write MDX and DAX queries and apply cube partitioning, processing, and security techniques.
Deploy SSAS cubes to production and consider storage modes, data relationships, hierarchies, and performance.
Conduct DW/BI design and architecture reviews and support development and maintenance across project life cycles.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
At least 2 years of hands-on experience in design, development, and build activities in MSBI–SQL Server projects
At least 4 years of experience in the software development life cycle
At least 2 years of experience with DW/BI technologies using Microsoft SQL Server
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
At least 5 years of experience in Information Technologies
Experience with multidimensional data modeling schemas
Experience in tabular data modeling and understanding when to use a tabular data model
Hands-on experience writing MDX and DAX queries
Experience applying cube partitioning and processing techniques
Experience applying data security for cubes
Experience developing custom visualizations using TypeScript, R Script, or M Query (preferred)
UX expertise in visualization and developing wireframes for different personas (preferred)
Education
Bachelor’s degree or foreign equivalent from an accredited institution; three years of progressive experience in the specialty may substitute for each year of education
Skills
Understanding of MOLAP, ROLAP, and HOLAP storage and processing techniques and when to use them
Knowledge of SSAS cube deployment methods in production scenarios, including XMLA
Other requirements
U.S. citizen or Green Card holder; must be authorized to work independently in the United States, as sponsorship is unavailable
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Sonsoft Inc’s careers site
Company 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.
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
Show full descriptionShow less
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.