SQL Server Analysis Services (SSAS) Technical Specialist

Experience: Not Available to Not Available years

Location: Bangalore, India

Skills: SQL Server Analysis Services (SSAS), tabular model, multidimensional model, data warehousing concepts, ETL processes, MDX, DAX, Power BI, Tableau, problem-solving skills, collaboration abilities

Job Summary
The Technical Specialist (SQL Server Analysis Services) at HCL will be responsible for overseeing the design, development, and maintenance of SSAS solutions. The primary goal is to optimize data analysis and reporting processes for productive decision-making within the organization.

Key Responsibilities
Collaborate with stakeholders to understand data requirements and translate them into SSAS solutions.
Design and develop SSAS cubes, dimensions, and measures based on business needs.
Optimize SSAS models for improved query performance and data accessibility.
Troubleshoot and resolve issues related to SSAS solutions and data discrepancies.




Implement security measures to ensure data integrity and confidentiality.
Provide technical support and guidance to end-users on SSAS functionalities.
Stay updated on the latest SSAS features and recommend enhancements for existing systems.

Skill Requirements
Proficiency in SQL Server Analysis Services (SSAS) including tabular model and multidimensional model.
Robust understanding of data warehousing concepts and ETL processes.
Experience in optimizing SSAS cubes for performance enhancements.
Ability to write complex MDX and DAX queries for data analysis.
Familiarity with data visualization tools such as Power BI or Tableau.
Excellent problem-solving skills and attention to detail.
Robust communication and collaboration abilities to work effectively with cross-functional teams.

Other Requirements
Microsoft Certified
Data Analyst Associate or similar SSAS-related certifications are a plus.

📌 Sql Server Analysis Services Ssas Technical Specialist Bengaluru
🏢 HCL Technologies
📍 Bengaluru