About the Role
We are looking for a Senior BI Developer with 7-10 years of experience and strong hands-on expertise in SSAS and MDX to design, build, and maintain enterprise-grade business intelligence solutions. You will combine deep SSAS Multidimensional and Tabular model expertise with robust MDX and DAX skills — delivering high-performance analytical solutions that support business decision-making across the organisation.
Key Responsibilities
- Design, develop, and maintain SSAS Multidimensional and Tabular models — building enterprise-grade analytical cubes and models aligned to business reporting requirements.
- Write and optimise complex MDX queries and calculations — calculated members, named sets, KPIs, and performance-tuned MDX expressions across SSAS Multidimensional solutions.
- Develop DAX measures and calculated columns for SSAS Tabular models and Power BI — ensuring accurate, performant, and reusable analytical calculations.
- Design and maintain dimensional data models — star and snowflake schemas — aligned to data warehouse and BI best practices.




- Build and maintain ETL pipelines using SSIS — data extraction, transformation, and loading from source systems into the data warehouse and SSAS models.
- Develop SSRS reports and Power BI dashboards — delivering clear, accurate, and actionable business insights from SSAS data sources.
- Conduct SSAS performance tuning — cube partition design, aggregation optimisation, MDX query tuning, and processing performance improvement.
- Collaborate with business stakeholders — gathering reporting requirements and translating them into well-designed SSAS and BI solutions.
- Support SSAS model upgrades and migrations — including migration from Multidimensional to Tabular or Azure Analysis Services where applicable.
- Produce clear technical documentation — cube design documents, MDX calculation guides, and ETL specifications.

What We're Looking For
- 7-10 years of BI development experience with deep, demonstrable ex

📌 BI Developer – SSAS (Gurugram)
🏢 Accolite Digital India
📍 Gurugram