About This Role

7 to 10 years of experience

Skills: SSAS, MDX, SQL Server, SSIS, SSRS, Power BI, DAX, Data Modelling, ETL, Dimensional Modelling, Star / Snowflake Schema, T-SQL, Azure Analysis Services, Performance Tuning, Agile

About the Role

We are looking for a Senior BI Developer with 7-10 years of experience and solid 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 strong 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 expertise in SSAS and MDX in production enterprise environments.
- Expert-level SSAS Multidimensional proficiency — cube design, dimension modelling, measure groups, partitions, aggregations, and KPI development.
- Strong MDX skills — complex calculated members, named sets, scoped assignments, and performance-optimised MDX expressions.
- Solid SSAS Tabular experience — DAX measures, relationships, and tabular model design alongside Multidimensional expertise.
- Advanced T-SQL and SQL Server skills — complex querying, stored procedures, and query performance tuning for BI and data warehouse workloads.
- Strong dimensional modelling expertise — star / snowflake schema design, slowly changing dimensions, and data warehouse best practices.
- Solid SSIS experience — ETL pipeline design, development, and performance optimisation for data warehouse loading.
- Good Power BI skills — report and dashboard development integrated with SSAS Tabular and Multidimensional data sources.
- Solid analytical and problem-solving skills — diagnosing SSAS performance issues, MDX query problems, and data quality defects.
- Good communication and stakeholder engagement skills — translating complex BI requirements into well-designed analytical solutions.

📌 BI Developer – SSAS & MDX (Gurugram)
🏢 Bounteous
📍 Gurugram