SSAS Developer – Affiliate Marketer Job
Design, develop, implement, and maintain complex multidimensional and tabular models using SQL Server Analysis Services (SSAS)
Develop and write efficient MDX and DAX queries for complex data analysis and retrieval
Collaborate with data warehouse developers and business analysts to understand data requirements and translate them into effective SSAS models
Optimize SSAS model performance for efficient data processing and querying
Implement robust security measures for role-based access control (RBAC) within SSAS models
Automate SSAS cube processing and deployment using SQL Server Integration Services (SSIS) or other scripting languages
Troubleshoot and resolve SSAS related issues to ensure optimal system performance
Provide ongoing support and guidance to business users on how to utilize SSAS models for data analysis
Document all SSAS models, queries, and processes for future reference and maintenance
Qualifications:
8+ years of experience in data warehousing and business intelligence solutions
3+ years of hands-on experience developing and implementing SSAS models (tabular and multidimensional)
Proven expertise in writing complex MDX and DAX queries for data analysis and manipulation
Strong understanding of data modeling concepts, including star schema design and dimensional hierarchies
Experience with relational databases, preferably Microsoft SQL Server
Hourly Range: $15.00-$50.00
Posted On: April 08, 2024 13:26 UTC
Category: Full Stack Development
Skills:SQL, Microsoft SQL Server, SQL Server Integration Services, Microsoft SQL Server Reporting Services, Microsoft SQL Server Programming, Microsoft SQL SSAS
Country: India
click to apply