Period
to 6 April 2020

The following table provides summary statistics for permanent job vacancies with a requirement for MDX skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited MDX over the 6 months to 6 April 2020 with a comparison to the same period in the previous 2 years.

Multidimensional Expressions (MDX)
UK
6 months to
6 Apr 2020
Same period 2019 Same period 2018
Rank 838 846 913
Rank change year-on-year +8 +67 -122
Permanent jobs citing MDX 141 283 293
As % of all permanent jobs advertised in the UK 0.12% 0.19% 0.17%
As % of the Libraries, Frameworks & Software Standards category 0.31% 0.48% 0.41%
Number of salaries quoted 136 251 245
Median annual salary £63,250 £52,500 £48,000
Median salary % change year-on-year +20.48% +9.38% -8.57%
10th Percentile £42,500 £38,250 £34,931
90th Percentile £80,000 £75,000 £77,500
UK excluding London median annual salary £61,500 £45,000 £45,000
% change year-on-year +36.67% - -

MDX is in the Software Libraries and Frameworks category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for technical specification, industry standards, software libraries and framework skills.

All Software Libraries and Frameworks
UK
Permanent vacancies with a requirement for technical specification, industry standards, software libraries and framework skills 46,009 58,652 72,258
As % of all permanent IT jobs advertised in the UK 39.33% 39.30% 40.71%
Number of salaries quoted 37,846 48,085 61,140
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,250
90th Percentile £90,000 £85,000 £78,750
UK excluding London median annual salary £47,500 £45,000 £43,500
% change year-on-year +5.56% +3.45% +2.35%

MDX
Job Vacancy Trend

Job postings citing MDX as a proportion of all IT jobs advertised.

Job vacancy trend for MDX in the UK

MDX
Salary Trend

3-month moving average salary quoted in jobs citing MDX.

Salary trend for MDX in the UK

MDX
Salary Histogram

Salary distribution for jobs citing MDX over the 6 months to 6 April 2020.

Salary histogram for MDX in the UK

MDX
Top 13 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing MDX within the UK over the 6 months to 6 April 2020. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +2 137 £65,000 +23.81% 16
UK excluding London +34 73 £61,500 +36.67% 10
London +30 64 £70,000 +16.67% 6
North of England +86 32 £72,500 +72.62% 1
North West +57 29 £72,500 +81.25% 1
Work from Home +23 20 £61,500 +17.14% 1
Midlands +5 19 £55,000 +15.79% 3
South West +55 15 £61,500 -1.60% 1
East Midlands -2 14 £50,000 +14.94% 2
East of England +39 5 £47,500 +5.56%
West Midlands +37 5 £72,500 +45.00% 1
Yorkshire +45 3 £73,750 +40.48%
South East +28 2 £47,500 -5.00% 5

For the 6 months to 6 April 2020, IT jobs citing MDX also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for MDX.

1 133 (94.33%) Business Intelligence
2 125 (88.65%) SQL Server Analysis Services
3 122 (86.52%) SQL
4 119 (84.40%) SQL Server Integration Services
5 111 (78.72%) Microsoft
6 109 (77.30%) Data Warehouse
7 107 (75.89%) SQL Server
8 103 (73.05%) Power BI
8 103 (73.05%) Power Platform
9 87 (61.70%) Analytics
10 82 (58.16%) Azure
10 82 (58.16%) SQL Server Reporting Services
11 75 (53.19%) ETL
12 72 (51.06%) Data Analysis Expressions (DAX)
13 63 (44.68%) T-SQL
14 61 (43.26%) Data Modelling
15 55 (39.01%) Finance
16 39 (27.66%) Data Analytics
16 39 (27.66%) Azure Data Factory
17 38 (26.95%) Python
18 37 (26.24%) Microsoft Excel
18 37 (26.24%) Agile Software Development
19 35 (24.82%) Data Lake
19 35 (24.82%) Azure SQL Database
20 33 (23.40%) Visualisation
21 32 (22.70%) Databricks
22 31 (21.99%) C#
22 31 (21.99%) OLAP
23 29 (20.57%) Snowflake Schema
23 29 (20.57%) Data Visualisation

MDX
Co-occurring IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 4 (2.84%) SharePoint
2 2 (1.42%) Apache Spark
Applications
1 37 (26.24%) Microsoft Excel
2 3 (2.13%) Microsoft Office
3 2 (1.42%) MS Visio
Business Applications
1 2 (1.42%) Dynamics AX
1 2 (1.42%) NetSuite
Cloud Services
1 103 (73.05%) Power Platform
2 82 (58.16%) Azure
3 39 (27.66%) Azure Data Factory
4 17 (12.06%) SaaS
5 11 (7.80%) Dynamics 365
6 7 (4.96%) AWS
7 3 (2.13%) Data Lake Analytics
8 2 (1.42%) Azure Functions
8 2 (1.42%) GCP
8 2 (1.42%) IBM Cloud
8 2 (1.42%) Office 365
8 2 (1.42%) PowerApps
8 2 (1.42%) Serverless
9 1 (0.71%) PaaS
Database & Business Intelligence
1 125 (88.65%) SQL Server Analysis Services
2 119 (84.40%) SQL Server Integration Services
3 109 (77.30%) Data Warehouse
4 107 (75.89%) SQL Server
5 103 (73.05%) Power BI
6 82 (58.16%) SQL Server Reporting Services
7 35 (24.82%) Azure SQL Database
7 35 (24.82%) Data Lake
8 31 (21.99%) OLAP
9 29 (20.57%) PowerPivot
9 29 (20.57%) Snowflake Schema
10 14 (9.93%) Microsoft Analysis Services
11 12 (8.51%) BusinessObjects
12 10 (7.09%) OLTP
12 10 (7.09%) QlikView
12 10 (7.09%) SQL Server 2016
13 9 (6.38%) Azure SQL Data Warehouse
14 7 (4.96%) OLAP Cube
14 7 (4.96%) Star Schema
15 6 (4.26%) SQL Server 2008
Development Applications
1 13 (9.22%) SQL Server Management Studio (SSMS)
1 13 (9.22%) Team Foundation Server
2 12 (8.51%) Visual Studio
3 2 (1.42%) JIRA
4 1 (0.71%) Visual Studio Team System
General
1 55 (39.01%) Finance
2 11 (7.80%) Marketing
3 10 (7.09%) Legal
4 7 (4.96%) Law
4 7 (4.96%) Retail
5 2 (1.42%) Banking
6 1 (0.71%) Financial Institution
6 1 (0.71%) Investment Banking
6 1 (0.71%) Publishing
Job Titles
1 63 (44.68%) Developer
2 47 (33.33%) Business Intelligence Developer
3 23 (16.31%) SQL Developer
4 22 (15.60%) Data Engineer
5 20 (14.18%) Business Intelligence Specialist
6 19 (13.48%) Azure Engineer
7 16 (11.35%) Business Intelligence Lead
7 16 (11.35%) Data Manager
8 15 (10.64%) Business Intelligence Manager
8 15 (10.64%) Business Manager
8 15 (10.64%) SQL BI Developer
9 11 (7.80%) SSIS Developer
10 10 (7.09%) Report Manager
11 9 (6.38%) SSAS Developer
11 9 (6.38%) Technical Leader
12 8 (5.67%) Analyst
12 8 (5.67%) Report Specialist
12 8 (5.67%) T-SQL Developer
13 7 (4.96%) Senior Developer
13 7 (4.96%) Senior Manager
Libraries, Frameworks & Software Standards
1 11 (7.80%) .NET
2 8 (5.67%) J2EE
2 8 (5.67%) JSP
2 8 (5.67%) Servlets
3 2 (1.42%) JSON
3 2 (1.42%) REST
3 2 (1.42%) Web Services
4 1 (0.71%) RESTful
4 1 (0.71%) SOAP
Miscellaneous
1 23 (16.31%) Analytical Skills
2 20 (14.18%) Greenfield Project
3 10 (7.09%) Private Cloud
4 9 (6.38%) Data Centre
5 8 (5.67%) Self-Motivation
6 2 (1.42%) Data Structures
7 1 (0.71%) Management Information System
Operating Systems
1 3 (2.13%) Windows
1 3 (2.13%) Windows Server
1 3 (2.13%) Windows Server 2008
1 3 (2.13%) Windows Server 2016
Processes & Methodologies
1 133 (94.33%) Business Intelligence
2 87 (61.70%) Analytics
3 75 (53.19%) ETL
4 61 (43.26%) Data Modelling
5 39 (27.66%) Data Analytics
6 37 (26.24%) Agile Software Development
7 33 (23.40%) Visualisation
8 29 (20.57%) Data Visualisation
9 26 (18.44%) Data Engineering
10 23 (16.31%) Kimball Methodology
11 21 (14.89%) Data Analysis
11 21 (14.89%) DevOps
12 20 (14.18%) Machine Learning
13 15 (10.64%) Dimensional Modelling
13 15 (10.64%) Migration
14 14 (9.93%) CRM
14 14 (9.93%) Fintech
15 13 (9.22%) Actionable Insight
15 13 (9.22%) Stakeholder Management
16 12 (8.51%) Data Science
Programming Languages
1 122 (86.52%) SQL
2 72 (51.06%) Data Analysis Expressions (DAX)
3 63 (44.68%) T-SQL
4 38 (26.95%) Python
5 31 (21.99%) C#
6 26 (18.44%) R
7 15 (10.64%) PowerShell
8 10 (7.09%) Java
9 3 (2.13%) VBA
10 1 (0.71%) JavaScript
Qualifications
1 14 (9.93%) Degree
2 3 (2.13%) MCP
2 3 (2.13%) Postgraduate
3 2 (1.42%) Microsoft Certification
Quality Assurance & Compliance
1 6 (4.26%) Data Quality
2 3 (2.13%) GDPR
2 3 (2.13%) PCI DSS
3 2 (1.42%) QA
3 2 (1.42%) SLA
System Software
1 6 (4.26%) Virtual Machines
Systems Management
1 2 (1.42%) Kubernetes
Vendors
1 111 (78.72%) Microsoft
2 32 (22.70%) Databricks
3 15 (10.64%) Tableau
4 12 (8.51%) RedGate
5 5 (3.55%) Cognos
6 2 (1.42%) Bloomberg
6 2 (1.42%) Capita
6 2 (1.42%) Google
6 2 (1.42%) IBM
6 2 (1.42%) JD Edwards
6 2 (1.42%) SAP
6 2 (1.42%) Snow
7 1 (0.71%) Alteryx
7 1 (0.71%) Oracle