Period
to 20 January 2018

The following table provides summary statistics for contract job vacancies advertised in England 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 > England
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 668 657 624
Rank change year-on-year -11 -33 -19
Contract jobs citing Dimensional Modelling 169 174 216
As % of all contract IT jobs advertised in England 0.18% 0.19% 0.22%
As % of the Processes & Methodologies category 0.22% 0.23% 0.26%
Number of daily rates quoted 121 99 146
England median daily rate £450 £438 £450
Median daily rate % change year-on-year +2.86% -2.78% -
10th Percentile £325 £329 £333
90th Percentile £538 £529 £533
UK median daily rate £450 £438 £445
% change year-on-year +2.86% -1.69% +4.71%
Number of hourly rates quoted 0 1 0
England median hourly rate - £30.00 -
UK median hourly rate - £30.00 -

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 advertised in England with a requirement for process or methodology skills.

All Process and Methodology Skills
England
Contract vacancies with a requirement for process or methodology skills 77,453 75,596 81,978
As % of all contract IT jobs advertised in England 84.60% 84.04% 82.66%
Number of daily rates quoted 52,346 50,436 53,969
England median daily rate £450 £433 £425
Median daily rate % change year-on-year +4.05% +1.76% +6.12%
10th Percentile £293 £269 £263
90th Percentile £638 £619 £600
UK median daily rate £450 £425 £425
% change year-on-year +5.88% - +6.25%
Number of hourly rates quoted 1,783 2,059 2,503
England median hourly rate £24.00 £25.00 £23.00
Median hourly rate % change year-on-year -4.00% +8.70% +15.00%
10th Percentile £11.35 £11.34 £11.25
90th Percentile £50.00 £48.75 £49.50
UK median hourly rate £23.50 £24.50 £23.75
% change year-on-year -4.08% +3.16% +18.75%

Dimensional Modelling
Job Vacancy Trend in England

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

Job vacancy trend for Dimensional Modelling in England

Dimensional Modelling
Contractor Daily Rate Trend in England

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

Contractor daily rate trend for Dimensional Modelling in England

Dimensional Modelling
Contractor Daily Rate Histogram in England

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

Contractor daily rate histogram for Dimensional Modelling in England

Dimensional Modelling
Contractor Hourly Rate Trend in England

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

Contractor hourly rate trend for Dimensional Modelling in England

Dimensional Modelling
Contract Job Locations in England

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 England region 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
London -1 102 £470 +4.44% 20
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
East Midlands +4 5 £340 +13.33% 3
Yorkshire -7 5 £475 +13.10%
West Midlands +20 4 £400 -5.88% 2
North East +48 3 £475 +26.67%
East of England -13 1 - - 1
Dimensional Modelling
UK

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 across the England region with a requirement for Dimensional Modelling.

1 144 (85.21%) Business Intelligence
2 128 (75.74%) Data Warehouse
3 122 (72.19%) SQL
4 99 (58.58%) ETL
5 95 (56.21%) SQL Server Integration Services
6 83 (49.11%) Data Modelling
6 83 (49.11%) SQL Server
7 74 (43.79%) Kimball Methodology
8 69 (40.83%) SQL Server Reporting Services
9 65 (38.46%) SQL Server Analysis Services
10 58 (34.32%) Agile Software Development
11 52 (30.77%) Power BI
12 51 (30.18%) Finance
13 45 (26.63%) Microsoft
14 42 (24.85%) Oracle
15 35 (20.71%) T-SQL
16 34 (20.12%) Data Management
17 31 (18.34%) Data Analysis
18 29 (17.16%) OLAP
19 28 (16.57%) MDX
20 26 (15.38%) Analytics
21 25 (14.79%) Tableau
21 25 (14.79%) Microsoft Analysis Services
21 25 (14.79%) Visualisation
22 23 (13.61%) BusinessObjects
22 23 (13.61%) Java
22 23 (13.61%) Relational Database
22 23 (13.61%) SDLC
23 22 (13.02%) Analytical Skills
23 22 (13.02%) QlikView

Dimensional Modelling
Co-occurring IT Skills in England 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 10 (5.92%) SAS
2 6 (3.55%) SharePoint
3 5 (2.96%) Apache Spark
4 2 (1.18%) SharePoint 2010
5 1 (0.59%) Apache Pig
5 1 (0.59%) CMS
Applications
1 16 (9.47%) MS Visio
2 4 (2.37%) Microsoft Excel
3 2 (1.18%) Microsoft Office
3 2 (1.18%) Spreadsheet
Business Applications
1 3 (1.78%) Oracle ERP
2 2 (1.18%) Oracle Retail
2 2 (1.18%) Oracle Utilities
3 1 (0.59%) Dynamics CRM
3 1 (0.59%) SAP Business One
Cloud Services
1 20 (11.83%) Microsoft Azure
2 4 (2.37%) Cloud Computing
2 4 (2.37%) GitHub
2 4 (2.37%) PaaS
2 4 (2.37%) SaaS
3 2 (1.18%) Amazon AWS
3 2 (1.18%) Azure Data Factory
4 1 (0.59%) Data Lake Analytics
4 1 (0.59%) Google Cloud Platform
Communications & Networking
1 2 (1.18%) Skype
2 1 (0.59%) NAS
Database & Business Intelligence
1 128 (75.74%) Data Warehouse
2 95 (56.21%) SQL Server Integration Services
3 83 (49.11%) SQL Server
4 69 (40.83%) SQL Server Reporting Services
5 65 (38.46%) SQL Server Analysis Services
6 52 (30.77%) Power BI
7 29 (17.16%) OLAP
8 25 (14.79%) Microsoft Analysis Services
9 23 (13.61%) BusinessObjects
9 23 (13.61%) Relational Database
10 22 (13.02%) QlikView
11 21 (12.43%) SQL Server 2016
12 16 (9.47%) Big Data
13 15 (8.88%) Data Mart
14 14 (8.28%) Data Mining
15 13 (7.69%) Azure SQL Database
15 13 (7.69%) Enterprise Data Warehouse
15 13 (7.69%) OLAP Cube
16 12 (7.10%) Oracle ODI
17 11 (6.51%) Star Schema
Development Applications
1 9 (5.33%) ERwin
2 8 (4.73%) Visual Studio
3 6 (3.55%) Subversion
4 4 (2.37%) Jenkins
4 4 (2.37%) JIRA
4 4 (2.37%) Team Foundation Server
5 2 (1.18%) Hudson
5 2 (1.18%) SQL Server Management Studio (SSMS)
6 1 (0.59%) PowerDesigner
General
1 51 (30.18%) Finance
2 17 (10.06%) Banking
3 11 (6.51%) Retail
4 8 (4.73%) Publishing
5 6 (3.55%) Marketing
6 5 (2.96%) Legal
6 5 (2.96%) Telecoms
7 3 (1.78%) Advertising
7 3 (1.78%) Investment Banking
7 3 (1.78%) Manufacturing
7 3 (1.78%) Pharmaceutical
7 3 (1.78%) Retail Banking
8 2 (1.18%) Billing
9 1 (0.59%) Automotive
9 1 (0.59%) Electronics
9 1 (0.59%) Front Office
Job Titles
1 104 (61.54%) Developer
2 65 (38.46%) Business Intelligence Developer
3 29 (17.16%) SQL Developer
4 25 (14.79%) Architect
5 23 (13.61%) SQL BI Developer
5 23 (13.61%) SSAS Developer
6 20 (11.83%) Data Architect
7 19 (11.24%) SSRS Developer
8 17 (10.06%) SSIS Developer
9 14 (8.28%) Data Warehouse Developer
10 13 (7.69%) Power BI Developer
11 12 (7.10%) ETL Developer
12 11 (6.51%) Consultant
13 10 (5.92%) Analyst
13 10 (5.92%) Data Modeller
14 8 (4.73%) Business Intelligence Analyst
15 7 (4.14%) Business Developer
15 7 (4.14%) Data Mart Developer
15 7 (4.14%) SQL Analyst
16 6 (3.55%) Solutions Architect
Libraries, Frameworks & Software Standards
1 28 (16.57%) MDX
2 12 (7.10%) Node.js
3 7 (4.14%) .NET
3 7 (4.14%) XML
4 5 (2.96%) JSON
5 4 (2.37%) HTML
5 4 (2.37%) XSD
6 3 (1.78%) ASP.NET
7 2 (1.18%) .NET Framework
7 2 (1.18%) Ajax
7 2 (1.18%) Oracle GoldenGate
7 2 (1.18%) RabbitMQ
7 2 (1.18%) WCF
7 2 (1.18%) WPF
7 2 (1.18%) XSL
7 2 (1.18%) XSLT
8 1 (0.59%) COM
8 1 (0.59%) iXBRL
8 1 (0.59%) Kafka
8 1 (0.59%) RESTful
Miscellaneous
1 22 (13.02%) Analytical Skills
2 7 (4.14%) Computer Science
3 5 (2.96%) Data Structures
3 5 (2.96%) Greenfield Project
4 4 (2.37%) Credit Risk
4 4 (2.37%) Equities
5 3 (1.78%) Management Information System
6 1 (0.59%) CMDB
6 1 (0.59%) Data Centre
6 1 (0.59%) Enterprise Software
6 1 (0.59%) Mainframe
6 1 (0.59%) Reference Data
6 1 (0.59%) Taxonomies
6 1 (0.59%) User Experience
Operating Systems
1 13 (7.69%) Unix
2 10 (5.92%) Linux
3 1 (0.59%) MVS
3 1 (0.59%) Windows
3 1 (0.59%) Windows Server
Processes & Methodologies
1 144 (85.21%) Business Intelligence
2 99 (58.58%) ETL
3 83 (49.11%) Data Modelling
4 74 (43.79%) Kimball Methodology
5 58 (34.32%) Agile Software Development
6 34 (20.12%) Data Management
7 31 (18.34%) Data Analysis
8 26 (15.38%) Analytics
9 25 (14.79%) Visualisation
10 23 (13.61%) SDLC
11 20 (11.83%) Scrum
12 18 (10.65%) Data Architecture
12 18 (10.65%) Data Governance
13 16 (9.47%) Performance Tuning
14 15 (8.88%) ETL Development
15 14 (8.28%) Migration
16 13 (7.69%) Data Analytics
16 13 (7.69%) Data Integration
16 13 (7.69%) Requirements Analysis
17 12 (7.10%) Logical Data Model
Programming Languages
1 122 (72.19%) SQL
2 35 (20.71%) T-SQL
3 23 (13.61%) Java
4 20 (11.83%) Data Analysis Expressions (DAX)
5 13 (7.69%) PL/SQL
6 12 (7.10%) Shell Script
7 11 (6.51%) C#
8 6 (3.55%) Python
9 4 (2.37%) R
10 3 (1.78%) C++
10 3 (1.78%) Perl
11 2 (1.18%) VBA
12 1 (0.59%) JavaScript
12 1 (0.59%) VB
Qualifications
1 15 (8.88%) Degree
2 7 (4.14%) Security Cleared
3 4 (2.37%) Computer Science Degree
4 3 (1.78%) SC Cleared
5 2 (1.18%) HNC
5 2 (1.18%) HND
6 1 (0.59%) BPSS Clearance
6 1 (0.59%) ISEB
6 1 (0.59%) Numerate Degree
Quality Assurance & Compliance
1 19 (11.24%) QA
2 15 (8.88%) Data Quality
3 3 (1.78%) GDPR
4 2 (1.18%) 21 CFR Part 11
4 2 (1.18%) CDISC
4 2 (1.18%) GxP
4 2 (1.18%) HL7
System Software
1 2 (1.18%) HDFS
1 2 (1.18%) Tivoli Workload Scheduler
2 1 (0.59%) Apache Flume
Systems Management
1 3 (1.78%) Rundeck
2 2 (1.18%) Control-M
2 2 (1.18%) Tivoli
Vendors
1 45 (26.63%) Microsoft
2 42 (24.85%) Oracle
3 25 (14.79%) Tableau
4 20 (11.83%) IBM
5 16 (9.47%) Teradata
6 12 (7.10%) Informatica
7 10 (5.92%) Netezza
8 5 (2.96%) Cognos
8 5 (2.96%) SAP
9 4 (2.37%) Ab Initio
9 4 (2.37%) CA
9 4 (2.37%) Salesforce.com
9 4 (2.37%) Vertica
10 3 (1.78%) Jaspersoft
10 3 (1.78%) MapR
10 3 (1.78%) Talend
11 2 (1.18%) Xamarin
12 1 (0.59%) Alteryx
12 1 (0.59%) Cloudera
12 1 (0.59%) Hortonworks