Period
to 20 October 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 October 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 Oct 2018
Same period 2017 Same period 2016
Rank 592 665 676
Rank change year-on-year +73 +11 -66
Contract jobs citing Dimensional Modelling 264 177 208
As % of all contract IT jobs advertised in England 0.28% 0.19% 0.21%
As % of the Processes & Methodologies category 0.33% 0.23% 0.25%
Number of daily rates quoted 195 122 128
England median daily rate £450 £450 £420
Median daily rate % change year-on-year - +7.14% -6.67%
10th Percentile £356 £363 £321
90th Percentile £675 £573 £538
UK median daily rate £450 £450 £420
% change year-on-year - +7.14% -6.67%
Number of hourly rates quoted 0 0 4
England median hourly rate - - £20.50
UK median hourly rate - - £20.50

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 80,674 78,512 84,023
As % of all contract IT jobs advertised in England 86.25% 85.92% 85.35%
Number of daily rates quoted 53,852 52,528 55,964
England median daily rate £473 £450 £425
Median daily rate % change year-on-year +5.00% +5.88% +3.03%
10th Percentile £300 £283 £263
90th Percentile £645 £631 £606
UK median daily rate £451 £450 £425
% change year-on-year +0.11% +5.88% +3.16%
Number of hourly rates quoted 2,158 1,850 2,225
England median hourly rate £21.00 £24.82 £22.50
Median hourly rate % change year-on-year -15.39% +10.31% +3.52%
10th Percentile £11.25 £11.25 £11.39
90th Percentile £50.00 £50.00 £47.93
UK median hourly rate £21.00 £24.93 £22.50
% change year-on-year -15.75% +10.78% +3.45%

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 October 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 October 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 +26 121 £525 +10.53% 20
South West +6 53 £425 - 5
South East -15 32 £520 +10.93% 10
North of England -12 25 £375 -25.00% 12
Midlands -5 22 £413 +3.13% 7
North West -6 19 £375 -25.00% 6
East Midlands +16 16 £425 +21.43% 5
East of England +13 11 £444 +36.54% 11
West Midlands -14 6 £400 - 2
Yorkshire -15 6 £675 - 6
Dimensional Modelling
UK

For the 6 months to 20 October 2018, IT contractor jobs citing Dimensional Modelling also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the England region with a requirement for Dimensional Modelling.

1 200 (75.76%) Business Intelligence
2 188 (71.21%) Data Warehouse
3 165 (62.50%) SQL
4 127 (48.11%) Data Modelling
5 112 (42.42%) SQL Server
6 109 (41.29%) Agile Software Development
7 105 (39.77%) ETL
8 98 (37.12%) Finance
9 94 (35.61%) Visualisation
10 78 (29.55%) SQL Server Integration Services
11 77 (29.17%) Microsoft
12 73 (27.65%) Power BI
13 71 (26.89%) Relational Database
14 69 (26.14%) Kimball Methodology
15 64 (24.24%) Hadoop
16 59 (22.35%) Analytical Skills
17 57 (21.59%) Oracle
18 53 (20.08%) SQL Server Reporting Services
19 51 (19.32%) SQL Server Analysis Services
20 50 (18.94%) Logical Data Model
21 46 (17.42%) Big Data
22 45 (17.05%) Apache Spark
23 43 (16.29%) Physical Data Model
24 41 (15.53%) Analytics
25 40 (15.15%) T-SQL
25 40 (15.15%) JSON
26 39 (14.77%) Microsoft Azure
26 39 (14.77%) Tableau
26 39 (14.77%) Data Science
27 38 (14.39%) Microsoft Excel

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 45 (17.05%) Apache Spark
2 21 (7.95%) SAS
3 12 (4.55%) Apache
4 8 (3.03%) Apache Pig
5 5 (1.89%) Confluence
6 4 (1.52%) IIS
7 2 (0.76%) Luigi
8 1 (0.38%) PowerExchange
Applications
1 38 (14.39%) Microsoft Excel
2 3 (1.14%) Microsoft PowerPoint
2 3 (1.14%) MS Visio
3 1 (0.38%) Spreadsheet
Business Applications
1 3 (1.14%) Dynamics AX
1 3 (1.14%) Dynamics CRM
Cloud Services
1 39 (14.77%) Microsoft Azure
2 17 (6.44%) Amazon AWS
3 13 (4.92%) Azure Data Factory
4 5 (1.89%) Google Analytics
5 4 (1.52%) Amazon S3
6 3 (1.14%) Data Lake Analytics
7 1 (0.38%) Amazon EC2
7 1 (0.38%) Amazon EMR
7 1 (0.38%) AWS Lambda
7 1 (0.38%) Azure Machine Learning
7 1 (0.38%) Cloud Computing
7 1 (0.38%) iPaaS
7 1 (0.38%) Office 365
7 1 (0.38%) PaaS
7 1 (0.38%) Serverless
Communications & Networking
1 1 (0.38%) Internet
Database & Business Intelligence
1 188 (71.21%) Data Warehouse
2 112 (42.42%) SQL Server
3 78 (29.55%) SQL Server Integration Services
4 73 (27.65%) Power BI
5 71 (26.89%) Relational Database
6 64 (24.24%) Hadoop
7 53 (20.08%) SQL Server Reporting Services
8 51 (19.32%) SQL Server Analysis Services
9 46 (17.42%) Big Data
10 32 (12.12%) Impala
11 30 (11.36%) Data Lake
12 26 (9.85%) Data Mining
12 26 (9.85%) OLAP
13 25 (9.47%) BusinessObjects
13 25 (9.47%) Enterprise Data Warehouse
14 24 (9.09%) SQL Server 2014
15 22 (8.33%) RDBMS
16 21 (7.95%) Apache Hive
17 20 (7.58%) Oracle Database
18 19 (7.20%) SQL Server 2012
Development Applications
1 16 (6.06%) JIRA
2 11 (4.17%) Git (software)
2 11 (4.17%) Subversion
3 6 (2.27%) ERwin
3 6 (2.27%) Visual Studio
4 4 (1.52%) Atlassian Bamboo
4 4 (1.52%) Cucumber
4 4 (1.52%) FishEye
4 4 (1.52%) jMock
4 4 (1.52%) JUnit
4 4 (1.52%) Maven
5 3 (1.14%) Jenkins
5 3 (1.14%) Visual Studio Team System
6 1 (0.38%) ER Studio
6 1 (0.38%) Team Foundation Server
General
1 98 (37.12%) Finance
2 29 (10.98%) Front Office
3 27 (10.23%) Banking
4 21 (7.95%) Retail
5 15 (5.68%) Manufacturing
6 11 (4.17%) Automotive
7 10 (3.79%) Investment Banking
8 7 (2.65%) Games
9 6 (2.27%) Legal
10 2 (0.76%) Telecoms
11 1 (0.38%) Advertising
11 1 (0.38%) Law
11 1 (0.38%) Marketing
Job Titles
1 122 (46.21%) Developer
2 50 (18.94%) Business Intelligence Developer
3 49 (18.56%) Analyst
4 38 (14.39%) Business Intelligence Analyst
5 32 (12.12%) Business Analyst
6 31 (11.74%) Data Modeller
7 30 (11.36%) Business Intelligence Business Analyst
8 29 (10.98%) Architect
9 28 (10.61%) SQL Developer
10 27 (10.23%) ETL Developer
11 21 (7.95%) Data Architect
12 18 (6.82%) Data Analyst
13 17 (6.44%) Data Warehouse Developer
13 17 (6.44%) SQL BI Developer
14 15 (5.68%) Report Developer
15 13 (4.92%) Big Data Architect
16 12 (4.55%) SSAS Developer
17 11 (4.17%) Data Engineer
18 8 (3.03%) Informatica Developer
19 7 (2.65%) Oracle Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 40 (15.15%) JSON
2 27 (10.23%) JSON Schema
2 27 (10.23%) XSD
3 23 (8.71%) XML
4 20 (7.58%) MDX
5 15 (5.68%) Web Services
6 13 (4.92%) Kafka
7 9 (3.41%) RabbitMQ
8 8 (3.03%) Spark Streaming
9 7 (2.65%) FIX Protocol
9 7 (2.65%) FpML
10 6 (2.27%) Oracle GoldenGate
11 4 (1.52%) J2EE
11 4 (1.52%) PySpark
12 2 (0.76%) HTML
12 2 (0.76%) Velocity
13 1 (0.38%) .NET
13 1 (0.38%) ASP.NET
13 1 (0.38%) JDBC
13 1 (0.38%) LDAP
Miscellaneous
1 59 (22.35%) Analytical Skills
2 13 (4.92%) Greenfield Project
3 12 (4.55%) Computer Science
4 9 (3.41%) Data Structures
5 8 (3.03%) Fixed Income
5 8 (3.03%) Replication
6 7 (2.65%) Enterprise Software
6 7 (2.65%) Management Information System
7 2 (0.76%) Self-Motivation
8 1 (0.38%) NHS
8 1 (0.38%) Reference Data
8 1 (0.38%) Reinsurance
8 1 (0.38%) TM Forum
Operating Systems
1 10 (3.79%) Linux
2 9 (3.41%) Unix
3 4 (1.52%) Windows
3 4 (1.52%) Windows Server
Processes & Methodologies
1 200 (75.76%) Business Intelligence
2 127 (48.11%) Data Modelling
3 109 (41.29%) Agile Software Development
4 105 (39.77%) ETL
5 94 (35.61%) Visualisation
6 69 (26.14%) Kimball Methodology
7 50 (18.94%) Logical Data Model
8 43 (16.29%) Physical Data Model
9 41 (15.53%) Analytics
10 39 (14.77%) Data Science
11 36 (13.64%) Data Integration
12 35 (13.26%) Scrum
12 35 (13.26%) Translating Business Requirements
13 34 (12.88%) Problem-Solving
14 31 (11.74%) User Stories
15 28 (10.61%) Technical Analysis
16 27 (10.23%) Stakeholder Management
17 26 (9.85%) Data Visualisation
18 24 (9.09%) Data Analysis
18 24 (9.09%) Performance Tuning
Programming Languages
1 165 (62.50%) SQL
2 40 (15.15%) T-SQL
3 26 (9.85%) Java
4 25 (9.47%) Data Analysis Expressions (DAX)
5 20 (7.58%) Python
6 14 (5.30%) R
7 13 (4.92%) C#
8 11 (4.17%) Java 8
8 11 (4.17%) Scala
9 10 (3.79%) PowerShell
10 6 (2.27%) VBA
11 5 (1.89%) PL/SQL
12 4 (1.52%) Shell Script
13 2 (0.76%) C
13 2 (0.76%) Go
14 1 (0.38%) Bash Shell
14 1 (0.38%) Clojure
14 1 (0.38%) JavaScript
14 1 (0.38%) Ruby
14 1 (0.38%) Tcl
Qualifications
1 16 (6.06%) Degree
2 15 (5.68%) Security Cleared
3 10 (3.79%) Computer Science Degree
4 8 (3.03%) Master's Degree
4 8 (3.03%) SC Cleared
5 4 (1.52%) DV Cleared
6 3 (1.14%) BPSS Clearance
6 3 (1.14%) ISEB
7 2 (0.76%) PMI Certification
7 2 (0.76%) PMP
7 2 (0.76%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 23 (8.71%) Data Quality
2 8 (3.03%) QA
3 6 (2.27%) GDPR
4 5 (1.89%) PCI DSS
System Software
1 12 (4.55%) HDFS
2 9 (3.41%) Apache Flume
3 8 (3.03%) Apache ZooKeeper
4 2 (0.76%) Docker
Systems Management
1 1 (0.38%) Chronos
1 1 (0.38%) Kubernetes
1 1 (0.38%) Marathon
1 1 (0.38%) Mesos
1 1 (0.38%) Single Sign-On
1 1 (0.38%) Terraform
Vendors
1 77 (29.17%) Microsoft
2 57 (21.59%) Oracle
3 39 (14.77%) Tableau
4 28 (10.61%) Cloudera
5 27 (10.23%) SAP
6 20 (7.58%) Teradata
7 18 (6.82%) Informatica
8 15 (5.68%) IBM
8 15 (5.68%) Netezza
9 12 (4.55%) MicroStrategy
10 9 (3.41%) MapR
11 8 (3.03%) Hortonworks
12 6 (2.27%) EXASOL
13 5 (1.89%) Google
13 5 (1.89%) Sybase
14 4 (1.52%) Atlassian
15 2 (0.76%) Cognos
15 2 (0.76%) Greenplum
15 2 (0.76%) Jaspersoft
16 1 (0.38%) Alteryx