Period
to 19 October 2017

The following table provides summary statistics for contract job vacancies with a requirement for MDX skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited MDX over the 6 months to 19 October 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Multidimensional Expressions (MDX)
UK
6 months to
19 Oct 2017
Same period 2016 Same period 2015
Rank 696 698 514
Rank change year-on-year +2 -184 +91
Contract jobs citing MDX 175 201 416
As % of all contract IT jobs advertised in the UK 0.18% 0.19% 0.36%
As % of the Libraries, Frameworks & Software Standards category 0.55% 0.63% 1.30%
Number of daily rates quoted 128 152 345
UK median daily rate £450 £406 £418
Median daily rate % change year-on-year +10.77% -2.69% -1.76%
10th Percentile £329 £307 £313
90th Percentile £588 £543 £595
UK excluding London median daily rate £350 £355 £369
% change year-on-year -1.41% -3.73% +7.66%
Number of hourly rates quoted 4 0 3
UK median hourly rate £21.50 - £33.00
10th Percentile £20.75 - £20.70
90th Percentile £22.25 - £34.90
UK excluding London median hourly rate - - £33.00

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

All Software Libraries and Frameworks
UK
Contract vacancies with a requirement for technical specification, industry standards, software libraries and framework skills 31822 31988 31908
As % of all contract IT jobs advertised in the UK 32.02% 30.06% 27.95%
Number of daily rates quoted 22328 22259 21754
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% -
10th Percentile £313 £298 £275
90th Percentile £625 £588 £588
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.23% +3.33% +7.14%
Number of hourly rates quoted 365 374 528
UK median hourly rate £40.00 £37.00 £37.50
Median hourly rate % change year-on-year +8.11% -1.33% +8.70%
10th Percentile £18.20 £13.50 £14.25
90th Percentile £52.50 £50.70 £55.00
UK excluding London median hourly rate £40.50 £36.00 £37.50
% change year-on-year +12.50% -4.00% +10.74%

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
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing MDX.

Contractor daily rate trend for MDX in the UK

MDX
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing MDX over the 6 months to 19 October 2017.

Contractor daily rate histogram for MDX in the UK

MDX
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing MDX.

Contractor hourly rate trend for MDX in the UK

MDX
Top 12 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing MDX within the UK over the 6 months to 19 October 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +17 174 £450 +9.09% 24
London +47 110 £475 +5.56% 13
UK excluding London -16 64 £350 -1.41% 11
South East +18 26 £350 -9.68% 2
North of England +69 20 £350 - 4
Midlands +3 13 £404 +24.23% 3
Yorkshire +29 12 £350 +2.94%
North West +25 8 £363 -27.50% 4
West Midlands +2 7 £388 +19.23% 1
East Midlands +3 6 £408 +42.98% 2
East of England -26 4 £325 -18.75% 1
Scotland +16 1 £450 +63.64%

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

1 143 (81.71%) SQL Server Integration Services
2 138 (78.86%) SQL
3 137 (78.29%) Business Intelligence
4 136 (77.71%) SQL Server Analysis Services
5 131 (74.86%) SQL Server Reporting Services
6 128 (73.14%) SQL Server
7 107 (61.14%) Microsoft
7 107 (61.14%) Data Warehouse
8 103 (58.86%) ETL
9 89 (50.86%) T-SQL
10 75 (42.86%) Power BI
11 68 (38.86%) Data Analysis Expressions (DAX)
12 64 (36.57%) OLAP
13 62 (35.43%) Finance
14 57 (32.57%) Kimball Methodology
15 42 (24.00%) Data Modelling
16 39 (22.29%) SQL Server 2016
17 36 (20.57%) Microsoft Analysis Services
18 34 (19.43%) PowerPivot
19 33 (18.86%) SQL Server 2012
20 31 (17.71%) Tableau
20 31 (17.71%) SQL Server 2008
20 31 (17.71%) Dimensional Modelling
21 30 (17.14%) SQL Server 2014
21 30 (17.14%) OLAP Cube
22 29 (16.57%) Performance Tuning
23 27 (15.43%) Agile Software Development
24 26 (14.86%) Analytics
24 26 (14.86%) ETL Development
25 22 (12.57%) Microsoft Azure

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 15 (8.57%) SharePoint
2 3 (1.71%) SAS
3 2 (1.14%) SharePoint 2010
4 1 (0.57%) Apache Pig
4 1 (0.57%) Apache Spark
4 1 (0.57%) Exchange Server 2007
4 1 (0.57%) Exchange Server 2013
4 1 (0.57%) MS Exchange
4 1 (0.57%) Oracle 10gAS
4 1 (0.57%) Oracle Application Server
Applications
1 20 (11.43%) Microsoft Excel
2 2 (1.14%) Microsoft Office
2 2 (1.14%) MS Visio
3 1 (0.57%) Microsoft PowerPoint
3 1 (0.57%) Microsoft Project
3 1 (0.57%) SPSS
Business Applications
1 4 (2.29%) Dynamics AX
2 1 (0.57%) Cognos Business Intelligence
2 1 (0.57%) Cognos TM1
2 1 (0.57%) Infor M3
2 1 (0.57%) Lorenzo
Cloud Services
1 22 (12.57%) Microsoft Azure
2 12 (6.86%) Amazon AWS
3 2 (1.14%) Cloud Computing
4 1 (0.57%) Cortana Intelligence Suite
Database & Business Intelligence
1 143 (81.71%) SQL Server Integration Services
2 136 (77.71%) SQL Server Analysis Services
3 131 (74.86%) SQL Server Reporting Services
4 128 (73.14%) SQL Server
5 107 (61.14%) Data Warehouse
6 75 (42.86%) Power BI
7 64 (36.57%) OLAP
8 39 (22.29%) SQL Server 2016
9 36 (20.57%) Microsoft Analysis Services
10 34 (19.43%) PowerPivot
11 33 (18.86%) SQL Server 2012
12 31 (17.71%) SQL Server 2008
13 30 (17.14%) OLAP Cube
13 30 (17.14%) SQL Server 2014
14 17 (9.71%) QlikView
15 13 (7.43%) Data Mining
16 11 (6.29%) Data Mart
16 11 (6.29%) OLTP
17 10 (5.71%) Star Schema
18 9 (5.14%) Big Data
Development Applications
1 18 (10.29%) Team Foundation Server
2 12 (6.86%) Visual Studio
3 6 (3.43%) Octopus Deploy
4 4 (2.29%) Git (software)
4 4 (2.29%) JIRA
5 2 (1.14%) SQL Server Management Studio (SSMS)
5 2 (1.14%) TeamCity
6 1 (0.57%) Bitbucket
6 1 (0.57%) Eclipse
6 1 (0.57%) MSTest
6 1 (0.57%) NSubstitute
6 1 (0.57%) Rhino Mocks
6 1 (0.57%) Subversion
6 1 (0.57%) Toad
6 1 (0.57%) Visual Studio Tools for Office
General
1 62 (35.43%) Finance
2 21 (12.00%) Banking
3 19 (10.86%) Legal
4 14 (8.00%) Retail
5 7 (4.00%) Investment Banking
6 6 (3.43%) Publishing
7 5 (2.86%) Law
7 5 (2.86%) Retail Banking
8 3 (1.71%) Front Office
8 3 (1.71%) Marketing
9 2 (1.14%) Manufacturing
9 2 (1.14%) Pharmaceutical
9 2 (1.14%) Telecoms
10 1 (0.57%) Local Government
10 1 (0.57%) Private Banking
Job Titles
1 143 (81.71%) Developer
2 92 (52.57%) Business Intelligence Developer
3 39 (22.29%) SSAS Developer
4 36 (20.57%) SQL Developer
5 29 (16.57%) SSIS Developer
6 28 (16.00%) Business Developer
7 21 (12.00%) Power BI Developer
8 20 (11.43%) SSRS Developer
9 16 (9.14%) ETL Developer
10 15 (8.57%) SQL BI Developer
11 14 (8.00%) SQL Server Developer
12 10 (5.71%) Business Intelligence Consultant
12 10 (5.71%) Consultant
13 9 (5.14%) Analyst
13 9 (5.14%) Data Warehouse Developer
14 7 (4.00%) Lead Developer
14 7 (4.00%) Microsoft BI Developer
14 7 (4.00%) Microsoft Developer
15 6 (3.43%) Lead SQL Server Developer
15 6 (3.43%) Report Developer
Libraries, Frameworks & Software Standards
1 11 (6.29%) .NET
2 10 (5.71%) COM
3 7 (4.00%) Web Services
4 6 (3.43%) JSON
5 5 (2.86%) CSS
5 5 (2.86%) SOAP
5 5 (2.86%) XML
6 4 (2.29%) CSS3
6 4 (2.29%) Ext JS
7 3 (1.71%) HTML
8 2 (1.14%) ASP.NET
8 2 (1.14%) HTML5
9 1 (0.57%) .NET Framework
9 1 (0.57%) ASP.NET MVC
9 1 (0.57%) D3.js
9 1 (0.57%) Entity Framework
9 1 (0.57%) jQuery
9 1 (0.57%) Reactive Extensions
9 1 (0.57%) REST
9 1 (0.57%) WPF
Miscellaneous
1 18 (10.29%) Analytical Skills
2 9 (5.14%) Greenfield Project
3 4 (2.29%) Management Information System
3 4 (2.29%) Reference Data
4 2 (1.14%) FMCG
4 2 (1.14%) Market Risk
4 2 (1.14%) Replication
5 1 (0.57%) Computer Science
5 1 (0.57%) Credit Risk
5 1 (0.57%) Data Structures
5 1 (0.57%) Foreign Exchange (FX)
5 1 (0.57%) NHS
5 1 (0.57%) Reinsurance
5 1 (0.57%) Taxonomies
5 1 (0.57%) User Experience
Operating Systems
1 7 (4.00%) Linux
2 3 (1.71%) Unix
3 2 (1.14%) Windows
3 2 (1.14%) Windows Server
4 1 (0.57%) HPUX
4 1 (0.57%) Red Hat Enterprise Linux
4 1 (0.57%) Windows 10
4 1 (0.57%) Windows 7
4 1 (0.57%) Windows Server 2003
4 1 (0.57%) Windows Server 2008
4 1 (0.57%) Windows Server 2012
Processes & Methodologies
1 137 (78.29%) Business Intelligence
2 103 (58.86%) ETL
3 57 (32.57%) Kimball Methodology
4 42 (24.00%) Data Modelling
5 31 (17.71%) Dimensional Modelling
6 29 (16.57%) Performance Tuning
7 27 (15.43%) Agile Software Development
8 26 (14.86%) Analytics
8 26 (14.86%) ETL Development
9 18 (10.29%) Logical Data Model
9 18 (10.29%) Physical Data Model
10 17 (9.71%) Migration
11 11 (6.29%) Stakeholder Management
11 11 (6.29%) Visualisation
12 9 (5.14%) Asset Management
12 9 (5.14%) SDLC
12 9 (5.14%) Test Automation
13 8 (4.57%) Dashboard Development
13 8 (4.57%) Scrum
13 8 (4.57%) Unit Testing
Programming Languages
1 138 (78.86%) SQL
2 89 (50.86%) T-SQL
3 68 (38.86%) Data Analysis Expressions (DAX)
4 14 (8.00%) C#
5 13 (7.43%) PowerShell
6 10 (5.71%) R
7 8 (4.57%) JavaScript
8 5 (2.86%) VBA
9 4 (2.29%) Java
9 4 (2.29%) Python
10 2 (1.14%) PL/SQL
10 2 (1.14%) VB.NET
11 1 (0.57%) C++
11 1 (0.57%) MATLAB
11 1 (0.57%) PHP
11 1 (0.57%) XMLA
Qualifications
1 6 (3.43%) MCITP
1 6 (3.43%) MCSE
1 6 (3.43%) Microsoft Certification
2 5 (2.86%) Degree
3 1 (0.57%) CFA
Quality Assurance & Compliance
1 6 (3.43%) Data Quality
2 4 (2.29%) QA
3 3 (1.71%) Solvency II
4 1 (0.57%) Cyber Essentials
4 1 (0.57%) Cyber Essentials PLUS
System Software
1 1 (0.57%) Hyper-V
1 1 (0.57%) VMware Infrastructure
Systems Management
1 1 (0.57%) Oracle RMAN
1 1 (0.57%) Symantec Enterprise Vault
Vendors
1 107 (61.14%) Microsoft
2 31 (17.71%) Tableau
3 8 (4.57%) Informatica
4 7 (4.00%) RedGate
5 4 (2.29%) InterSystems
5 4 (2.29%) Oracle
5 4 (2.29%) Sencha
6 3 (1.71%) SAP
7 2 (1.14%) Cognos
7 2 (1.14%) JD Edwards
8 1 (0.57%) Cerner
8 1 (0.57%) Citrix
8 1 (0.57%) Cloudera
8 1 (0.57%) Hortonworks
8 1 (0.57%) IBM
8 1 (0.57%) MicroStrategy
8 1 (0.57%) Red Hat
8 1 (0.57%) Symantec
8 1 (0.57%) VMware