Period
to 14 December 2017

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 14 December 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.

Dimensional Modelling
UK > England
6 months to
14 Dec 2017
Same period 2016 Same period 2015
Rank 671 660 618
Rank change year-on-year -11 -42 -39
Contract jobs citing Dimensional Modelling 193 189 253
As % of all contract IT jobs advertised in England 0.20% 0.20% 0.24%
As % of the Processes & Methodologies category 0.24% 0.23% 0.30%
Number of daily rates quoted 130 102 172
England median daily rate £450 £433 £450
Median daily rate % change year-on-year +4.05% -3.89% +5.57%
10th Percentile £325 £331 £330
90th Percentile £538 £536 £535
UK median daily rate £450 £435 £440
% change year-on-year +3.45% -1.14% +3.53%
Number of hourly rates quoted 0 0 0
England median hourly rate - - -
UK 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 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 80470 80635 85371
As % of all contract IT jobs advertised in England 84.69% 84.16% 82.32%
Number of daily rates quoted 54303 53686 56383
England median daily rate £450 £430 £425
Median daily rate % change year-on-year +4.65% +1.18% +6.25%
10th Percentile £288 £268 £263
90th Percentile £638 £613 £600
UK median daily rate £450 £425 £420
% change year-on-year +5.88% +1.19% +5.00%
Number of hourly rates quoted 1821 2142 2548
England median hourly rate £25.00 £24.41 £22.06
Median hourly rate % change year-on-year +2.42% +10.67% +16.09%
10th Percentile £11.44 £11.38 £11.25
90th Percentile £50.00 £48.28 £47.50
UK median hourly rate £25.00 £24.00 £22.50
% change year-on-year +4.17% +6.67% +18.42%

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 14 December 2017.

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 14 December 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
London +11 106 £470 +4.44% 13
South East +4 33 £456 +4.29% 4
South West +13 24 £425 +9.68% 1
North of England +12 17 £475 +13.10% 4
North West +5 11 £475 -13.64% 3
Midlands +14 8 £375 - 6
East Midlands +8 7 £350 +55.56% 1
Yorkshire -1 4 £275 -34.52% 1
East of England -23 4 - -
North East +53 2 - -
West Midlands +18 1 £400 -23.81% 5
Dimensional Modelling
UK

For the 6 months to 14 December 2017, 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 163 (84.46%) Data Warehouse
2 155 (80.31%) Business Intelligence
3 129 (66.84%) SQL
4 124 (64.25%) ETL
5 109 (56.48%) SQL Server Integration Services
6 97 (50.26%) Kimball Methodology
7 91 (47.15%) Data Modelling
8 89 (46.11%) SQL Server
9 81 (41.97%) SQL Server Reporting Services
10 71 (36.79%) Agile Software Development
11 67 (34.72%) SQL Server Analysis Services
12 63 (32.64%) Finance
13 59 (30.57%) Microsoft
14 56 (29.02%) Power BI
15 45 (23.32%) Oracle
16 39 (20.21%) T-SQL
17 35 (18.13%) OLAP
17 35 (18.13%) Data Management
18 31 (16.06%) MDX
19 27 (13.99%) Analytics
19 27 (13.99%) Tableau
20 26 (13.47%) BusinessObjects
21 25 (12.95%) Logical Data Model
22 24 (12.44%) SDLC
22 24 (12.44%) Scrum
22 24 (12.44%) Data Analysis
23 23 (11.92%) QlikView
23 23 (11.92%) Visualisation
23 23 (11.92%) Performance Tuning
24 22 (11.40%) Analytical Skills

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 11 (5.70%) SAS
2 9 (4.66%) SharePoint
3 5 (2.59%) Apache Spark
4 3 (1.55%) BizTalk Server
4 3 (1.55%) SharePoint 2010
5 1 (0.52%) Apache Pig
5 1 (0.52%) CMS
Applications
1 6 (3.11%) MS Visio
2 5 (2.59%) Microsoft Excel
3 2 (1.04%) Microsoft Office
3 2 (1.04%) Spreadsheet
Business Applications
1 3 (1.55%) Oracle ERP
2 2 (1.04%) Oracle Retail
2 2 (1.04%) Oracle Utilities
3 1 (0.52%) Dynamics CRM
3 1 (0.52%) SAP Business One
Cloud Services
1 20 (10.36%) Microsoft Azure
2 4 (2.07%) Cloud Computing
2 4 (2.07%) GitHub
2 4 (2.07%) PaaS
2 4 (2.07%) SaaS
3 3 (1.55%) Amazon AWS
4 2 (1.04%) Azure Data Factory
5 1 (0.52%) Azure Machine Learning
5 1 (0.52%) Data Lake Analytics
5 1 (0.52%) Google Cloud Platform
Communications & Networking
1 3 (1.55%) NAS
2 2 (1.04%) Skype
Database & Business Intelligence
1 163 (84.46%) Data Warehouse
2 109 (56.48%) SQL Server Integration Services
3 89 (46.11%) SQL Server
4 81 (41.97%) SQL Server Reporting Services
5 67 (34.72%) SQL Server Analysis Services
6 56 (29.02%) Power BI
7 35 (18.13%) OLAP
8 26 (13.47%) BusinessObjects
9 23 (11.92%) QlikView
10 22 (11.40%) SQL Server 2016
11 18 (9.33%) Microsoft Analysis Services
11 18 (9.33%) Relational Database
12 17 (8.81%) OLAP Cube
12 17 (8.81%) PowerPivot
13 15 (7.77%) Data Mining
13 15 (7.77%) Enterprise Data Warehouse
14 14 (7.25%) Big Data
14 14 (7.25%) Oracle ODI
14 14 (7.25%) SQL Server 2008
15 13 (6.74%) Azure SQL Database
Development Applications
1 11 (5.70%) Talend Open Studio
2 9 (4.66%) JIRA
2 9 (4.66%) Visual Studio
3 8 (4.15%) ERwin
3 8 (4.15%) Team Foundation Server
4 6 (3.11%) Subversion
5 4 (2.07%) Jenkins
6 2 (1.04%) SQL Server Management Studio (SSMS)
7 1 (0.52%) Eclipse
7 1 (0.52%) PowerDesigner
General
1 63 (32.64%) Finance
2 18 (9.33%) Banking
3 14 (7.25%) Legal
4 12 (6.22%) Retail
5 11 (5.70%) Publishing
6 7 (3.63%) Marketing
7 5 (2.59%) Pharmaceutical
8 4 (2.07%) Law
8 4 (2.07%) Retail Banking
8 4 (2.07%) Telecoms
9 3 (1.55%) Advertising
9 3 (1.55%) Investment Banking
10 2 (1.04%) Billing
10 2 (1.04%) Manufacturing
11 1 (0.52%) Automotive
11 1 (0.52%) Front Office
Job Titles
1 125 (64.77%) Developer
2 70 (36.27%) Business Intelligence Developer
3 30 (15.54%) SQL Developer
4 25 (12.95%) SSAS Developer
5 24 (12.44%) Data Warehouse Developer
6 23 (11.92%) ETL Developer
7 22 (11.40%) Architect
8 20 (10.36%) SQL BI Developer
8 20 (10.36%) SSIS Developer
9 19 (9.84%) Data Architect
10 17 (8.81%) Business Developer
11 14 (7.25%) Analyst
11 14 (7.25%) Power BI Developer
11 14 (7.25%) SSRS Developer
12 12 (6.22%) Data Modeller
13 10 (5.18%) Business Intelligence Analyst
13 10 (5.18%) Consultant
14 7 (3.63%) SQL Analyst
14 7 (3.63%) Teradata Developer
15 6 (3.11%) Talend Developer
Libraries, Frameworks & Software Standards
1 31 (16.06%) MDX
2 10 (5.18%) .NET
3 7 (3.63%) XML
4 5 (2.59%) JSON
5 4 (2.07%) COM
5 4 (2.07%) XSD
6 3 (1.55%) ASP.NET
7 2 (1.04%) .NET Framework
7 2 (1.04%) Ajax
7 2 (1.04%) D3.js
7 2 (1.04%) Node.js
7 2 (1.04%) Oracle GoldenGate
7 2 (1.04%) RabbitMQ
7 2 (1.04%) WCF
7 2 (1.04%) WPF
7 2 (1.04%) XSL
7 2 (1.04%) XSLT
8 1 (0.52%) iXBRL
8 1 (0.52%) Kafka
8 1 (0.52%) RESTful
Miscellaneous
1 22 (11.40%) Analytical Skills
2 7 (3.63%) Computer Science
3 6 (3.11%) Data Structures
4 5 (2.59%) Greenfield Project
5 4 (2.07%) Credit Risk
5 4 (2.07%) Equities
6 3 (1.55%) Mainframe
6 3 (1.55%) Management Information System
7 2 (1.04%) User Experience
8 1 (0.52%) CMDB
8 1 (0.52%) Data Centre
8 1 (0.52%) Reference Data
8 1 (0.52%) Taxonomies
Operating Systems
1 15 (7.77%) Unix
2 12 (6.22%) Linux
3 3 (1.55%) MVS
4 1 (0.52%) Windows
4 1 (0.52%) Windows Server
Processes & Methodologies
1 155 (80.31%) Business Intelligence
2 124 (64.25%) ETL
3 97 (50.26%) Kimball Methodology
4 91 (47.15%) Data Modelling
5 71 (36.79%) Agile Software Development
6 35 (18.13%) Data Management
7 27 (13.99%) Analytics
8 25 (12.95%) Logical Data Model
9 24 (12.44%) Data Analysis
9 24 (12.44%) Scrum
9 24 (12.44%) SDLC
10 23 (11.92%) Performance Tuning
10 23 (11.92%) Visualisation
11 22 (11.40%) Data Integration
12 19 (9.84%) Data Architecture
13 16 (8.29%) Physical Data Model
14 15 (7.77%) Data Governance
14 15 (7.77%) ETL Development
14 15 (7.77%) Migration
15 13 (6.74%) Stakeholder Management
Programming Languages
1 129 (66.84%) SQL
2 39 (20.21%) T-SQL
3 22 (11.40%) PL/SQL
4 20 (10.36%) Data Analysis Expressions (DAX)
5 14 (7.25%) C#
6 13 (6.74%) Shell Script
7 10 (5.18%) Java
8 6 (3.11%) Python
9 4 (2.07%) R
10 3 (1.55%) C++
10 3 (1.55%) JavaScript
10 3 (1.55%) Perl
11 2 (1.04%) VBA
12 1 (0.52%) VB
12 1 (0.52%) VB.NET
Qualifications
1 16 (8.29%) Degree
2 4 (2.07%) Computer Science Degree
2 4 (2.07%) Security Cleared
3 3 (1.55%) ISEB
4 2 (1.04%) HNC
4 2 (1.04%) HND
5 1 (0.52%) BPSS Clearance
5 1 (0.52%) Numerate Degree
5 1 (0.52%) SC Cleared
Quality Assurance & Compliance
1 18 (9.33%) QA
2 14 (7.25%) Data Quality
3 3 (1.55%) GDPR
4 2 (1.04%) 21 CFR Part 11
4 2 (1.04%) CDISC
4 2 (1.04%) GxP
4 2 (1.04%) HL7
System Software
1 3 (1.55%) Tivoli Workload Scheduler
2 2 (1.04%) HDFS
3 1 (0.52%) Apache Flume
Systems Management
1 3 (1.55%) Rundeck
1 3 (1.55%) Tivoli
2 2 (1.04%) Control-M
Vendors
1 59 (30.57%) Microsoft
2 45 (23.32%) Oracle
3 27 (13.99%) Tableau
4 21 (10.88%) IBM
5 16 (8.29%) Teradata
6 12 (6.22%) Informatica
7 11 (5.70%) Talend
8 10 (5.18%) Netezza
9 7 (3.63%) Cognos
9 7 (3.63%) SAP
10 4 (2.07%) Ab Initio
10 4 (2.07%) Salesforce.com
10 4 (2.07%) Vertica
11 3 (1.55%) CA
11 3 (1.55%) MapR
12 2 (1.04%) Xamarin
13 1 (0.52%) Alteryx
13 1 (0.52%) MicroStrategy
13 1 (0.52%) Salesforce Marketing Cloud
13 1 (0.52%) Sybase