Period
to 20 November 2017

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 20 November 2017 with a comparison to the same period in the previous 2 years.

Multidimensional Expressions (MDX)
UK
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 827 757 628
Rank change year-on-year -70 -129 +115
Permanent jobs citing MDX 378 491 854
As % of all permanent IT jobs advertised in the UK 0.21% 0.26% 0.39%
As % of the Libraries, Frameworks & Software Standards category 0.52% 0.67% 1.03%
Number of salaries quoted 304 423 696
UK median annual salary £52,500 £52,500 £52,500
10th Percentile £35,000 £35,000 £37,500
90th Percentile £75,000 £75,000 £72,500
UK excluding London median annual salary £45,000 £50,000 £50,000
% change year-on-year -10.00% - +17.65%

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 72189 72861 83089
As % of all permanent IT jobs advertised in the UK 40.16% 38.95% 37.99%
Number of salaries quoted 60006 63236 71019
UK median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% +1.12%
10th Percentile £29,750 £28,750 £27,500
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £42,000 £40,000
% change year-on-year +1.19% +5.00% -

MDX
Job Vacancy Trend

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

Job vacancy trend for MDX in the UK

MDX
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing MDX.

Salary trend for MDX in the UK

MDX
Salary Histogram

The salary distribution of IT jobs citing MDX over the 6 months to 20 November 2017.

Salary histogram for MDX in the UK

MDX
Top 14 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 20 November 2017. 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 -25 374 £52,500 -4.55% 14
London -27 200 £60,000 - 4
UK excluding London -45 168 £45,000 -10.00% 10
North of England +11 49 £38,750 -8.82% 3
South East -14 44 £45,000 -14.29% 5
Midlands +25 41 £45,000 -5.26% 1
North West -10 29 £32,500 -21.21% 3
East of England +2 27 £55,000 +1.85% 1
West Midlands +16 23 £40,000 - 1
East Midlands +29 16 £48,750 -
Yorkshire +5 13 £70,000 +61.85%
South West -5 5 £40,000 -20.00%
Scotland -25 2 £48,750 -
North East -2 1 £31,000 -

For the 6 months to 20 November 2017, IT jobs citing MDX also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for MDX.

1 350 (92.59%) Business Intelligence
2 342 (90.48%) SQL
3 309 (81.75%) SQL Server Analysis Services
4 308 (81.48%) SQL Server Integration Services
5 307 (81.22%) SQL Server
6 256 (67.72%) Microsoft
7 246 (65.08%) SQL Server Reporting Services
8 244 (64.55%) T-SQL
9 225 (59.52%) Data Warehouse
10 220 (58.20%) ETL
11 180 (47.62%) Power BI
12 163 (43.12%) OLAP
13 142 (37.57%) Kimball Methodology
14 121 (32.01%) Tableau
15 111 (29.37%) Agile Software Development
16 100 (26.46%) Finance
17 95 (25.13%) Data Modelling
17 95 (25.13%) Analytics
18 88 (23.28%) QlikView
19 83 (21.96%) Data Analysis Expressions (DAX)
20 80 (21.16%) Dimensional Modelling
21 77 (20.37%) .NET
22 76 (20.11%) Microsoft Azure
23 75 (19.84%) C#
24 73 (19.31%) OLAP Cube
25 68 (17.99%) Performance Tuning
26 64 (16.93%) SQL Server 2008
27 61 (16.14%) SQL Server 2012
27 61 (16.14%) Microsoft Analysis Services
28 59 (15.61%) SQL Server 2016

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 57 (15.08%) SharePoint
2 15 (3.97%) WebSphere
3 12 (3.17%) JBoss
3 12 (3.17%) Tomcat
3 12 (3.17%) WebLogic
4 8 (2.12%) NetWeaver
5 5 (1.32%) SharePoint 2013
6 2 (0.53%) IBM Domino
7 1 (0.26%) Apache Spark
7 1 (0.26%) MS Exchange
7 1 (0.26%) Oracle SOA Suite
7 1 (0.26%) SAS
Applications
1 30 (7.94%) Microsoft Excel
2 10 (2.65%) MS Visio
3 2 (0.53%) Microsoft Office
Business Applications
1 8 (2.12%) SAP BPC
2 3 (0.79%) Cognos Business Intelligence
2 3 (0.79%) Dynamics AX
2 3 (0.79%) Dynamics CRM
3 2 (0.53%) Cognos TM1
4 1 (0.26%) NetSuite
Cloud Services
1 76 (20.11%) Microsoft Azure
2 17 (4.50%) Amazon AWS
3 14 (3.70%) Azure Data Factory
4 8 (2.12%) Office 365
5 4 (1.06%) Cloud Computing
5 4 (1.06%) PaaS
5 4 (1.06%) SaaS
6 3 (0.79%) Dynamics 365
6 3 (0.79%) Mimecast
7 1 (0.26%) IaaS
Communications & Networking
1 14 (3.70%) DNS
1 14 (3.70%) Firewall
2 12 (3.17%) HTTP
2 12 (3.17%) LDAP
2 12 (3.17%) SSL
3 2 (0.53%) Kerberos
4 1 (0.26%) SMS
Database & Business Intelligence
1 309 (81.75%) SQL Server Analysis Services
2 308 (81.48%) SQL Server Integration Services
3 307 (81.22%) SQL Server
4 246 (65.08%) SQL Server Reporting Services
5 225 (59.52%) Data Warehouse
6 180 (47.62%) Power BI
7 163 (43.12%) OLAP
8 88 (23.28%) QlikView
9 73 (19.31%) OLAP Cube
10 64 (16.93%) SQL Server 2008
11 61 (16.14%) Microsoft Analysis Services
11 61 (16.14%) SQL Server 2012
12 59 (15.61%) SQL Server 2016
13 50 (13.23%) Relational Database
13 50 (13.23%) SQL Server 2014
14 46 (12.17%) Big Data
15 44 (11.64%) BusinessObjects
16 35 (9.26%) PowerPivot
17 27 (7.14%) Data Lake
18 24 (6.35%) Enterprise Data Warehouse
Development Applications
1 46 (12.17%) Team Foundation Server
2 22 (5.82%) Visual Studio
3 13 (3.44%) Talend Open Studio
4 7 (1.85%) Maven
4 7 (1.85%) Octopus Deploy
5 6 (1.59%) Eclipse
6 5 (1.32%) JIRA
6 5 (1.32%) JUnit
7 2 (0.53%) MSTest
7 2 (0.53%) NSubstitute
7 2 (0.53%) Rhino Mocks
7 2 (0.53%) Visual Studio Tools for Office
8 1 (0.26%) Bitbucket
8 1 (0.26%) Git (software)
8 1 (0.26%) Selenium
8 1 (0.26%) SQL Server Management Studio (SSMS)
8 1 (0.26%) TeamCity
8 1 (0.26%) Visual Studio Team System
General
1 100 (26.46%) Finance
2 36 (9.52%) Banking
3 32 (8.47%) Legal
4 17 (4.50%) Advertising
4 17 (4.50%) Publishing
5 16 (4.23%) Marketing
6 15 (3.97%) Retail
7 11 (2.91%) Retail Banking
8 7 (1.85%) Investment Banking
9 6 (1.59%) Financial Institution
9 6 (1.59%) Law
10 4 (1.06%) Front Office
Job Titles
1 235 (62.17%) Developer
2 179 (47.35%) Business Intelligence Developer
3 109 (28.84%) SQL Developer
4 77 (20.37%) SQL BI Developer
5 56 (14.81%) Consultant
6 52 (13.76%) SSIS Developer
7 51 (13.49%) SSAS Developer
8 42 (11.11%) SSRS Developer
9 37 (9.79%) Business Developer
10 31 (8.20%) Architect
11 30 (7.94%) SQL Server Developer
12 29 (7.67%) Business Intelligence Consultant
13 27 (7.14%) ETL Developer
13 27 (7.14%) Microsoft BI Developer
13 27 (7.14%) T-SQL Developer
14 24 (6.35%) Analyst
15 23 (6.08%) Tableau Developer
16 21 (5.56%) Microsoft Developer
17 19 (5.03%) Data Warehouse Developer
17 19 (5.03%) Senior Consultant
Libraries, Frameworks & Software Standards
1 77 (20.37%) .NET
2 34 (8.99%) Web Services
3 19 (5.03%) Spring
3 19 (5.03%) XML
4 17 (4.50%) HTML
4 17 (4.50%) SOAP
5 16 (4.23%) REST
6 15 (3.97%) ASP.NET
7 14 (3.70%) JSP
7 14 (3.70%) XSLT
8 12 (3.17%) Spring Security
9 6 (1.59%) .NET Framework
10 3 (0.79%) CSS
10 3 (0.79%) Entity Framework
10 3 (0.79%) HTML5
11 2 (0.53%) ASP.NET MVC
11 2 (0.53%) J2SE
11 2 (0.53%) jQuery
11 2 (0.53%) RESTful
12 1 (0.26%) WCF
Miscellaneous
1 33 (8.73%) Enterprise Software
2 31 (8.20%) Analytical Skills
3 28 (7.41%) Management Information System
4 11 (2.91%) Fintech
5 10 (2.65%) Computer Science
6 7 (1.85%) Credit Risk
6 7 (1.85%) iPhone
7 6 (1.59%) User Experience
8 5 (1.32%) Equities
8 5 (1.32%) NHS
9 3 (0.79%) Hedge funds
9 3 (0.79%) N-Tier
10 2 (0.53%) Greenfield Project
11 1 (0.26%) Data Structures
11 1 (0.26%) Marketing Technology
11 1 (0.26%) Replication
Operating Systems
1 19 (5.03%) Linux
1 19 (5.03%) Windows
2 12 (3.17%) Solaris
3 7 (1.85%) Unix
4 6 (1.59%) Windows Server
5 1 (0.26%) HPUX
5 1 (0.26%) Red Hat Enterprise Linux
5 1 (0.26%) Windows Server 2003
5 1 (0.26%) Windows Server 2008
Processes & Methodologies
1 350 (92.59%) Business Intelligence
2 220 (58.20%) ETL
3 142 (37.57%) Kimball Methodology
4 111 (29.37%) Agile Software Development
5 95 (25.13%) Analytics
5 95 (25.13%) Data Modelling
6 80 (21.16%) Dimensional Modelling
7 68 (17.99%) Performance Tuning
8 49 (12.96%) Visualisation
9 44 (11.64%) Data Integration
10 41 (10.85%) Data Visualisation
10 41 (10.85%) Migration
11 40 (10.58%) Data Management
12 36 (9.52%) Mentoring
13 33 (8.73%) Scrum
14 29 (7.67%) Business Analytics
14 29 (7.67%) Unit Testing
15 26 (6.88%) ETL Development
15 26 (6.88%) Inmon Methodology
16 22 (5.82%) Stakeholder Management
Programming Languages
1 342 (90.48%) SQL
2 244 (64.55%) T-SQL
3 83 (21.96%) Data Analysis Expressions (DAX)
4 75 (19.84%) C#
5 40 (10.58%) PowerShell
6 32 (8.47%) VBA
7 31 (8.20%) Java
8 21 (5.56%) VB.NET
9 14 (3.70%) JavaScript
10 8 (2.12%) ABAP
10 8 (2.12%) PL/SQL
11 6 (1.59%) R
12 5 (1.32%) VBScript
13 4 (1.06%) C
14 3 (0.79%) Python
15 1 (0.26%) XPath
15 1 (0.26%) XQuery
Qualifications
1 38 (10.05%) Degree
2 24 (6.35%) Microsoft Certification
3 7 (1.85%) MCITP
3 7 (1.85%) MCSE
4 4 (1.06%) MBA
4 4 (1.06%) Security Cleared
5 2 (0.53%) Numerate Degree
5 2 (0.53%) PRINCE2 Practitioner
5 2 (0.53%) SC Cleared
6 1 (0.26%) APMP
6 1 (0.26%) Computer Science Degree
6 1 (0.26%) Master's Degree
Quality Assurance & Compliance
1 30 (7.94%) Data Quality
2 6 (1.59%) QA
3 3 (0.79%) Cyber Essentials
3 3 (0.79%) ISO/IEC 27001
System Software
1 14 (3.70%) Active Directory
2 3 (0.79%) VMware Infrastructure
3 1 (0.26%) Hyper-V
Systems Management
1 1 (0.26%) Systems Management Server (SMS)
Vendors
1 256 (67.72%) Microsoft
2 121 (32.01%) Tableau
3 52 (13.76%) Cognos
4 39 (10.32%) Oracle
5 25 (6.61%) MicroStrategy
6 24 (6.35%) SAP
7 23 (6.08%) IBM
8 17 (4.50%) Informatica
9 14 (3.70%) TIBCO
10 13 (3.44%) Talend
11 12 (3.17%) Intel
11 12 (3.17%) Jaspersoft
11 12 (3.17%) Vertica
12 11 (2.91%) RedGate
13 3 (0.79%) Alteryx
13 3 (0.79%) Nintex
13 3 (0.79%) VMware
14 2 (0.53%) Hyperion
14 2 (0.53%) JD Edwards
14 2 (0.53%) Lotus