BI Developer - SSAS & MDX

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