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 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

1.



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

Bounteous x Accolite makes the future faster for the world’s most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership. Bounteous x Accolite brings together 5,000+ employees spanning North America, APAC, and EMEA, and partnerships with leading technology providers. Through advanced digital engineering, technology solutions, and data-driven digital experiences, we create exceptional and efficient business impact and help our clients win.

For more information visit: www.accolite.com

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