Power Bi Developer

Bounteous; Gurugram District; On-site; INR 3,000,000 - 4,200,000; Full time

Job summary

Bounteous in India seeks a Senior BI Developer with 7-10 years of experience to design, build, and maintain enterprise BI solutions leveraging SSAS Multidimensional and Tabular, MDX, and DAX.

You will develop complex MDX queries, implement DAX measures, design dimensional models (star/snowflake), and build ETL pipelines with SSIS to feed data warehouses and SSAS models. Strong Power BI reporting, performance tuning, and collaboration with stakeholders are essential.

Qualifications

• 7-10 years of BI development experience in enterprise environments.
• Expert proficiency in SSAS Multidimensional and Tabular, including cube design and measures.
• Strong MDX and DAX skills for complex calculations and reporting.

Responsibilities

• Design, develop, and maintain SSAS Multidimensional and Tabular models.
• Write and optimise MDX calculations, named sets, KPIs, and performance-tuned expressions.
• Develop DAX measures and calculated columns for SSAS and Power BI.
• Design star and snowflake dimensional models for data warehousing.
• Build ETL pipelines using SSIS to populate data warehouses and BI models.
• Develop SSRS reports and Power BI dashboards.
• Conduct SSAS performance tuning and partition design.
• Collaborate with stakeholders to translate requirements into BI solutions.
• Support upgrades and migrations from Multidimensional to Tabular or Azure Analysis Services.
• Produce technical design and ETL documentation.

Skills

SSAS Multidimensional

MDX

DAX

SSAS Tabular

Power BI

SSIS

T-SQL/SQL Server

Dimensional Modelling

ETL pipelines

Tools

SSAS

Power BI

Job description

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. Strong analytical and problem-solving skills — diagnosing SSAS performance issues, MDX query problems, and data quality defects.
10. Good communication ​​..