Period
to 20 January 2018

The following table provides summary statistics for contract job vacancies with a requirement for Dimensional Modelling skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Dimensional Modelling over the 6 months to 20 January 2018 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.

Dimensional Modelling
UK
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 688 662 650
Rank change year-on-year -26 -12 -51
Contract jobs citing Dimensional Modelling 182 182 228
As % of all contract IT jobs advertised in the UK 0.18% 0.19% 0.21%
As % of the Processes & Methodologies category 0.22% 0.22% 0.26%
Number of daily rates quoted 128 102 154
UK median daily rate £450 £438 £445
Median daily rate % change year-on-year +2.86% -1.69% +4.71%
10th Percentile £325 £331 £334
90th Percentile £538 £526 £532
UK excluding London median daily rate £425 £420 £450
% change year-on-year +1.19% -6.67% +6.51%
Number of hourly rates quoted 0 1 0
UK median hourly rate - £30.00 -
UK excluding London median hourly rate - - -

Dimensional Modelling is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for process or methodology skills.

All Process and Methodology Skills
UK
Contract vacancies with a requirement for process or methodology skills 84,024 81,140 89,182
As % of all contract IT jobs advertised in the UK 84.51% 83.79% 82.46%
Number of daily rates quoted 56,267 53,737 57,879
UK median daily rate £450 £425 £425
Median daily rate % change year-on-year +5.88% - +6.25%
10th Percentile £285 £263 £263
90th Percentile £638 £613 £600
UK excluding London median daily rate £410 £400 £390
% change year-on-year +2.50% +2.56% +4.00%
Number of hourly rates quoted 1,958 2,261 2,720
UK median hourly rate £23.50 £24.50 £23.75
Median hourly rate % change year-on-year -4.08% +3.16% +18.75%
10th Percentile £11.32 £11.25 £11.25
90th Percentile £50.00 £48.75 £50.00
UK excluding London median hourly rate £24.00 £24.50 £25.00
% change year-on-year -2.04% -2.00% +24.22%

Dimensional Modelling
Job Vacancy Trend

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

Job vacancy trend for Dimensional Modelling in the UK

Dimensional Modelling
Contractor Daily Rate Trend

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

Contractor daily rate trend for Dimensional Modelling in the UK

Dimensional Modelling
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Dimensional Modelling over the 6 months to 20 January 2018.

Contractor daily rate histogram for Dimensional Modelling in the UK

Dimensional Modelling
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for Dimensional Modelling in the UK

Dimensional Modelling
Top 15 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Dimensional Modelling within the UK over the 6 months to 20 January 2018. 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 -11 169 £450 +2.86% 38
London -1 102 £470 +4.44% 20
UK excluding London -16 78 £425 +1.19% 23
South West +13 21 £425 +9.68% 2
South East -25 21 £438 - 5
North of England +7 15 £475 +13.10% 5
Midlands +6 9 £350 +3.70% 5
North West +4 8 £475 +8.57% 5
Scotland -17 6 £398 -6.47% 2
East Midlands +4 5 £340 +13.33% 3
Yorkshire -7 5 £475 +13.10%
Wales - 5 £350 - 1
West Midlands +20 4 £400 -5.88% 2
North East +48 3 £475 +26.67%
East of England -13 1 - - 1

For the 6 months to 20 January 2018, IT contractor jobs citing Dimensional Modelling 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 Dimensional Modelling.

1 149 (81.87%) Business Intelligence
2 137 (75.27%) Data Warehouse
3 126 (69.23%) SQL
4 103 (56.59%) ETL
5 97 (53.30%) SQL Server Integration Services
6 87 (47.80%) SQL Server
7 86 (47.25%) Data Modelling
8 79 (43.41%) Kimball Methodology
9 71 (39.01%) SQL Server Reporting Services
10 67 (36.81%) SQL Server Analysis Services
11 63 (34.62%) Agile Software Development
12 56 (30.77%) Finance
13 54 (29.67%) Power BI
14 48 (26.37%) Oracle
15 45 (24.73%) Microsoft
16 38 (20.88%) T-SQL
17 36 (19.78%) Data Management
18 34 (18.68%) Data Analysis
19 29 (15.93%) OLAP
20 28 (15.38%) MDX
20 28 (15.38%) Analytics
21 27 (14.84%) Microsoft Analysis Services
22 26 (14.29%) Tableau
23 25 (13.74%) Visualisation
24 24 (13.19%) Relational Database
25 23 (12.64%) SDLC
25 23 (12.64%) BusinessObjects
25 23 (12.64%) Scrum
25 23 (12.64%) Java
26 22 (12.09%) IBM

Dimensional Modelling
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 11 (6.04%) SAS
2 7 (3.85%) SharePoint
3 5 (2.75%) Apache Spark
4 2 (1.10%) SharePoint 2010
5 1 (0.55%) Apache Pig
5 1 (0.55%) CMS
Applications
1 17 (9.34%) MS Visio
2 4 (2.20%) Microsoft Excel
3 2 (1.10%) Microsoft Office
3 2 (1.10%) Spreadsheet
Business Applications
1 3 (1.65%) Oracle ERP
2 2 (1.10%) Oracle Retail
2 2 (1.10%) Oracle Utilities
3 1 (0.55%) Cognos Business Intelligence
3 1 (0.55%) Dynamics CRM
3 1 (0.55%) SAP Business One
Cloud Services
1 22 (12.09%) Microsoft Azure
2 4 (2.20%) Cloud Computing
2 4 (2.20%) GitHub
2 4 (2.20%) PaaS
2 4 (2.20%) SaaS
3 2 (1.10%) Amazon AWS
3 2 (1.10%) Azure Data Factory
4 1 (0.55%) Data Lake Analytics
4 1 (0.55%) Google Cloud Platform
Communications & Networking
1 2 (1.10%) Skype
2 1 (0.55%) NAS
Database & Business Intelligence
1 137 (75.27%) Data Warehouse
2 97 (53.30%) SQL Server Integration Services
3 87 (47.80%) SQL Server
4 71 (39.01%) SQL Server Reporting Services
5 67 (36.81%) SQL Server Analysis Services
6 54 (29.67%) Power BI
7 29 (15.93%) OLAP
8 27 (14.84%) Microsoft Analysis Services
9 24 (13.19%) Relational Database
10 23 (12.64%) BusinessObjects
11 22 (12.09%) QlikView
11 22 (12.09%) SQL Server 2016
12 16 (8.79%) Big Data
12 16 (8.79%) Data Mart
13 15 (8.24%) Azure SQL Database
13 15 (8.24%) Enterprise Data Warehouse
14 14 (7.69%) Data Mining
15 13 (7.14%) OLAP Cube
16 12 (6.59%) Oracle ODI
16 12 (6.59%) Oracle Reports
Development Applications
1 10 (5.49%) ERwin
1 10 (5.49%) Visual Studio
2 6 (3.30%) Subversion
2 6 (3.30%) Team Foundation Server
3 4 (2.20%) Jenkins
3 4 (2.20%) JIRA
4 2 (1.10%) Hudson
4 2 (1.10%) SQL Server Management Studio (SSMS)
5 1 (0.55%) PowerDesigner
General
1 56 (30.77%) Finance
2 17 (9.34%) Banking
3 11 (6.04%) Retail
4 8 (4.40%) Publishing
5 6 (3.30%) Marketing
6 5 (2.75%) Legal
6 5 (2.75%) Telecoms
7 3 (1.65%) Advertising
7 3 (1.65%) Investment Banking
7 3 (1.65%) Manufacturing
7 3 (1.65%) Pharmaceutical
7 3 (1.65%) Retail Banking
8 2 (1.10%) Billing
9 1 (0.55%) Automotive
9 1 (0.55%) Electronics
9 1 (0.55%) Front Office
Job Titles
1 114 (62.64%) Developer
2 65 (35.71%) Business Intelligence Developer
3 31 (17.03%) SQL Developer
4 26 (14.29%) Architect
5 23 (12.64%) SQL BI Developer
5 23 (12.64%) SSAS Developer
6 21 (11.54%) Data Architect
7 19 (10.44%) SSRS Developer
8 17 (9.34%) SSIS Developer
9 14 (7.69%) Data Warehouse Developer
10 13 (7.14%) Power BI Developer
11 12 (6.59%) ETL Developer
12 11 (6.04%) Analyst
12 11 (6.04%) Consultant
12 11 (6.04%) Data Modeller
13 8 (4.40%) Business Intelligence Analyst
14 7 (3.85%) Business Developer
14 7 (3.85%) Data Mart Developer
14 7 (3.85%) SQL Analyst
15 6 (3.30%) Solutions Architect
Libraries, Frameworks & Software Standards
1 28 (15.38%) MDX
2 12 (6.59%) Node.js
3 7 (3.85%) .NET
3 7 (3.85%) XML
4 5 (2.75%) JSON
5 4 (2.20%) HTML
5 4 (2.20%) XSD
6 3 (1.65%) ASP.NET
7 2 (1.10%) .NET Framework
7 2 (1.10%) Ajax
7 2 (1.10%) Oracle GoldenGate
7 2 (1.10%) RabbitMQ
7 2 (1.10%) WCF
7 2 (1.10%) WPF
7 2 (1.10%) XSL
7 2 (1.10%) XSLT
8 1 (0.55%) COM
8 1 (0.55%) iXBRL
8 1 (0.55%) Kafka
8 1 (0.55%) RESTful
Miscellaneous
1 22 (12.09%) Analytical Skills
2 7 (3.85%) Computer Science
3 6 (3.30%) Data Structures
4 5 (2.75%) Greenfield Project
5 4 (2.20%) Credit Risk
5 4 (2.20%) Equities
5 4 (2.20%) Management Information System
6 3 (1.65%) Reference Data
7 1 (0.55%) CMDB
7 1 (0.55%) Data Centre
7 1 (0.55%) Enterprise Software
7 1 (0.55%) Mainframe
7 1 (0.55%) Taxonomies
7 1 (0.55%) User Experience
Operating Systems
1 13 (7.14%) Unix
2 10 (5.49%) Linux
3 1 (0.55%) MVS
3 1 (0.55%) Windows
3 1 (0.55%) Windows Server
Processes & Methodologies
1 149 (81.87%) Business Intelligence
2 103 (56.59%) ETL
3 86 (47.25%) Data Modelling
4 79 (43.41%) Kimball Methodology
5 63 (34.62%) Agile Software Development
6 36 (19.78%) Data Management
7 34 (18.68%) Data Analysis
8 28 (15.38%) Analytics
9 25 (13.74%) Visualisation
10 23 (12.64%) Scrum
10 23 (12.64%) SDLC
11 19 (10.44%) Data Architecture
11 19 (10.44%) Data Governance
12 18 (9.89%) Performance Tuning
13 15 (8.24%) ETL Development
14 14 (7.69%) Data Integration
14 14 (7.69%) Logical Data Model
14 14 (7.69%) Migration
15 13 (7.14%) Data Analytics
15 13 (7.14%) Requirements Analysis
Programming Languages
1 126 (69.23%) SQL
2 38 (20.88%) T-SQL
3 23 (12.64%) Java
4 20 (10.99%) Data Analysis Expressions (DAX)
5 13 (7.14%) PL/SQL
6 12 (6.59%) Shell Script
7 11 (6.04%) C#
8 6 (3.30%) Python
9 4 (2.20%) R
10 3 (1.65%) C++
10 3 (1.65%) Perl
11 2 (1.10%) VBA
12 1 (0.55%) JavaScript
12 1 (0.55%) VB
Qualifications
1 15 (8.24%) Degree
2 9 (4.95%) Security Cleared
3 5 (2.75%) SC Cleared
4 4 (2.20%) Computer Science Degree
5 2 (1.10%) HNC
5 2 (1.10%) HND
6 1 (0.55%) BPSS Clearance
6 1 (0.55%) ISEB
6 1 (0.55%) Numerate Degree
Quality Assurance & Compliance
1 19 (10.44%) QA
2 17 (9.34%) Data Quality
3 3 (1.65%) GDPR
4 2 (1.10%) 21 CFR Part 11
4 2 (1.10%) CDISC
4 2 (1.10%) GxP
4 2 (1.10%) HL7
5 1 (0.55%) Disclosure Scotland
System Software
1 2 (1.10%) HDFS
1 2 (1.10%) Tivoli Workload Scheduler
2 1 (0.55%) Apache Flume
Systems Management
1 3 (1.65%) Rundeck
2 2 (1.10%) Control-M
2 2 (1.10%) Tivoli
Vendors
1 48 (26.37%) Oracle
2 45 (24.73%) Microsoft
3 26 (14.29%) Tableau
4 22 (12.09%) IBM
5 18 (9.89%) Teradata
6 16 (8.79%) Informatica
7 11 (6.04%) Netezza
8 6 (3.30%) Cognos
9 5 (2.75%) SAP
10 4 (2.20%) Ab Initio
10 4 (2.20%) CA
10 4 (2.20%) MicroStrategy
10 4 (2.20%) Salesforce.com
10 4 (2.20%) Talend
10 4 (2.20%) Vertica
11 3 (1.65%) Jaspersoft
11 3 (1.65%) MapR
12 2 (1.10%) Xamarin
13 1 (0.55%) Alteryx
13 1 (0.55%) Hortonworks