Period
to 23 July 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 23 July 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
23 Jul 2018
Same period 2017 Same period 2016
Rank 644 654 671
Rank change year-on-year +10 +17 -72
Contract jobs citing Dimensional Modelling 217 167 205
As % of all contract IT jobs advertised in England 0.23% 0.19% 0.20%
As % of the Processes & Methodologies category 0.27% 0.22% 0.24%
Number of daily rates quoted 159 113 143
England median daily rate £450 £450 £413
Median daily rate % change year-on-year - +9.09% -8.33%
10th Percentile £330 £363 £313
90th Percentile £617 £550 £575
UK median daily rate £450 £450 £413
% change year-on-year - +9.09% -7.30%
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,841 74,601 85,797
As % of all contract IT jobs advertised in England 85.83% 85.15% 84.43%
Number of daily rates quoted 53,787 49,146 57,198
England median daily rate £463 £450 £425
Median daily rate % change year-on-year +2.78% +5.88% +4.94%
10th Percentile £300 £281 £269
90th Percentile £638 £625 £613
UK median daily rate £450 £450 £425
% change year-on-year - +5.88% +6.25%
Number of hourly rates quoted 2,234 1,927 2,034
England median hourly rate £22.50 £24.50 £23.75
Median hourly rate % change year-on-year -8.16% +3.16% +10.47%
10th Percentile £11.25 £11.39 £11.72
90th Percentile £50.67 £51.25 £48.75
UK median hourly rate £22.00 £25.00 £24.00
% change year-on-year -12.00% +4.17% +11.63%

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 23 July 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 23 July 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 -23 90 £480 +1.05% 24
South West +19 39 £425 +6.25% 8
South East -9 37 £530 +11.58% 7
North of England 0 22 £375 -16.67% 8
Midlands -9 16 £385 -0.65% 5
North West -19 16 £344 -23.61% 1
East of England +1 13 £425 +51.11% 4
East Midlands +9 8 £360 -10.00% 4
West Midlands -23 8 £500 +33.33% 1
Yorkshire - 5 £500 - 6
Dimensional Modelling
UK

For the 6 months to 23 July 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 172 (79.26%) Data Warehouse
2 151 (69.59%) Business Intelligence
3 128 (58.99%) SQL
4 103 (47.47%) Data Modelling
5 93 (42.86%) ETL
6 87 (40.09%) SQL Server
7 76 (35.02%) Agile Software Development
8 69 (31.80%) Finance
9 68 (31.34%) SQL Server Integration Services
10 62 (28.57%) Kimball Methodology
11 60 (27.65%) Visualisation
12 57 (26.27%) Microsoft
13 56 (25.81%) Analytics
13 56 (25.81%) Power BI
14 49 (22.58%) SQL Server Reporting Services
15 48 (22.12%) SQL Server Analysis Services
16 47 (21.66%) Big Data
17 42 (19.35%) Analytical Skills
18 41 (18.89%) Relational Database
19 40 (18.43%) Data Integration
20 37 (17.05%) Oracle
21 35 (16.13%) Microsoft Azure
22 34 (15.67%) Data Architecture
23 33 (15.21%) Data Analysis
24 30 (13.82%) Data Management
24 30 (13.82%) Hadoop
25 28 (12.90%) Stakeholder Management
25 28 (12.90%) Logical Data Model
26 25 (11.52%) T-SQL
26 25 (11.52%) SAP

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 17 (7.83%) Apache Spark
2 11 (5.07%) SAS
3 7 (3.23%) Apache
4 5 (2.30%) Apache Pig
5 4 (1.84%) SharePoint
6 2 (0.92%) Luigi
7 1 (0.46%) Confluence
7 1 (0.46%) IIS
7 1 (0.46%) PowerExchange
Applications
1 20 (9.22%) Microsoft Excel
2 10 (4.61%) MS Visio
3 2 (0.92%) Microsoft Office
3 2 (0.92%) Microsoft PowerPoint
Business Applications
1 2 (0.92%) Dynamics CRM
2 1 (0.46%) Demantra
2 1 (0.46%) Dynamics AX
2 1 (0.46%) Hyperion Planning
2 1 (0.46%) Oracle Financials
2 1 (0.46%) Oracle Retail
2 1 (0.46%) Retail-J
2 1 (0.46%) SAP BPC
Cloud Services
1 35 (16.13%) Microsoft Azure
2 11 (5.07%) Amazon AWS
3 10 (4.61%) Azure Data Factory
4 8 (3.69%) Google Analytics
5 4 (1.84%) Data Lake Analytics
6 3 (1.38%) Cloud Computing
7 2 (0.92%) Azure Machine Learning
7 2 (0.92%) GitHub
8 1 (0.46%) Amazon EC2
8 1 (0.46%) Amazon EMR
8 1 (0.46%) Amazon S3
8 1 (0.46%) AWS Lambda
8 1 (0.46%) Office 365
8 1 (0.46%) PaaS
8 1 (0.46%) Serverless
Communications & Networking
1 1 (0.46%) Internet
Database & Business Intelligence
1 172 (79.26%) Data Warehouse
2 87 (40.09%) SQL Server
3 68 (31.34%) SQL Server Integration Services
4 56 (25.81%) Power BI
5 49 (22.58%) SQL Server Reporting Services
6 48 (22.12%) SQL Server Analysis Services
7 47 (21.66%) Big Data
8 41 (18.89%) Relational Database
9 30 (13.82%) Hadoop
10 22 (10.14%) BusinessObjects
11 19 (8.76%) OLAP
12 18 (8.29%) Enterprise Data Warehouse
12 18 (8.29%) SQL Server 2016
13 16 (7.37%) SQL Server 2014
14 14 (6.45%) Data Mart
14 14 (6.45%) Data Mining
14 14 (6.45%) Microsoft Analysis Services
15 13 (5.99%) NoSQL
15 13 (5.99%) RDBMS
15 13 (5.99%) Star Schema
Development Applications
1 17 (7.83%) JIRA
2 7 (3.23%) Visual Studio
3 5 (2.30%) ERwin
4 3 (1.38%) ER Studio
4 3 (1.38%) SQL Server Management Studio (SSMS)
4 3 (1.38%) Toad
5 2 (0.92%) Git (software)
5 2 (0.92%) Jenkins
5 2 (0.92%) Subversion
5 2 (0.92%) Visual Studio Team System
6 1 (0.46%) StarTeam
General
1 69 (31.80%) Finance
2 17 (7.83%) Retail
3 13 (5.99%) Banking
3 13 (5.99%) Manufacturing
4 9 (4.15%) Automotive
5 8 (3.69%) Front Office
6 6 (2.76%) Legal
7 4 (1.84%) Games
7 4 (1.84%) Marketing
8 3 (1.38%) Investment Banking
9 2 (0.92%) Digital Economy
9 2 (0.92%) Publishing
10 1 (0.46%) Law
Job Titles
1 99 (45.62%) Developer
2 46 (21.20%) Business Intelligence Developer
3 39 (17.97%) Analyst
4 32 (14.75%) Architect
5 26 (11.98%) Business Analyst
5 26 (11.98%) Business Intelligence Analyst
5 26 (11.98%) SQL Developer
6 25 (11.52%) Data Architect
7 23 (10.60%) ETL Developer
8 20 (9.22%) Business Intelligence Business Analyst
9 18 (8.29%) Data Warehouse Developer
10 14 (6.45%) Data Modeller
11 12 (5.53%) Data Analyst
11 12 (5.53%) SQL BI Developer
12 10 (4.61%) Power BI Developer
13 9 (4.15%) Big Data Architect
14 8 (3.69%) Consultant
14 8 (3.69%) Report Developer
14 8 (3.69%) SSAS Developer
15 7 (3.23%) Senior Developer
Libraries, Frameworks & Software Standards
1 19 (8.76%) MDX
2 8 (3.69%) JSON
2 8 (3.69%) JSON Schema
2 8 (3.69%) Kafka
2 8 (3.69%) XSD
3 6 (2.76%) Node.js
3 6 (2.76%) RabbitMQ
4 5 (2.30%) .NET
4 5 (2.30%) Spark Streaming
5 3 (1.38%) ASP.NET
5 3 (1.38%) HTML
5 3 (1.38%) Software Packaging
5 3 (1.38%) XML
6 2 (0.92%) FIX Protocol
6 2 (0.92%) FpML
6 2 (0.92%) LDAP
7 1 (0.46%) JMS
7 1 (0.46%) ODBC
7 1 (0.46%) PySpark
7 1 (0.46%) SAP XI
Miscellaneous
1 42 (19.35%) Analytical Skills
2 12 (5.53%) Data Structures
3 9 (4.15%) Self-Motivation
4 7 (3.23%) Management Information System
5 6 (2.76%) Greenfield Project
6 3 (1.38%) FMCG
7 2 (0.92%) Computer Science
7 2 (0.92%) Enterprise Software
7 2 (0.92%) Fixed Income
7 2 (0.92%) User Experience
8 1 (0.46%) Data Protection Act
Operating Systems
1 12 (5.53%) Unix
2 5 (2.30%) Linux
2 5 (2.30%) Windows
2 5 (2.30%) Windows Server
3 1 (0.46%) AIX
3 1 (0.46%) Windows Server 2012
Processes & Methodologies
1 151 (69.59%) Business Intelligence
2 103 (47.47%) Data Modelling
3 93 (42.86%) ETL
4 76 (35.02%) Agile Software Development
5 62 (28.57%) Kimball Methodology
6 60 (27.65%) Visualisation
7 56 (25.81%) Analytics
8 40 (18.43%) Data Integration
9 34 (15.67%) Data Architecture
10 33 (15.21%) Data Analysis
11 30 (13.82%) Data Management
12 28 (12.90%) Logical Data Model
12 28 (12.90%) Stakeholder Management
13 23 (10.60%) Data Governance
14 22 (10.14%) Physical Data Model
14 22 (10.14%) Problem-Solving
15 20 (9.22%) Data Science
15 20 (9.22%) User Stories
16 19 (8.76%) Master Data Management
16 19 (8.76%) SDLC
Programming Languages
1 128 (58.99%) SQL
2 25 (11.52%) T-SQL
3 20 (9.22%) Java
4 15 (6.91%) Data Analysis Expressions (DAX)
5 12 (5.53%) Python
6 10 (4.61%) PL/SQL
7 8 (3.69%) C#
7 8 (3.69%) Scala
8 7 (3.23%) R
8 7 (3.23%) Shell Script
9 3 (1.38%) VBA
10 2 (0.92%) C
10 2 (0.92%) Java 8
10 2 (0.92%) VB.NET
11 1 (0.46%) Clojure
11 1 (0.46%) Go
11 1 (0.46%) JavaScript
11 1 (0.46%) Ruby
11 1 (0.46%) XMLA
Qualifications
1 4 (1.84%) Degree
1 4 (1.84%) ISEB
1 4 (1.84%) Security Cleared
2 2 (0.92%) DV Cleared
2 2 (0.92%) Microsoft Certification
Quality Assurance & Compliance
1 21 (9.68%) Data Quality
2 9 (4.15%) GDPR
3 7 (3.23%) PCI DSS
4 1 (0.46%) Basel II
4 1 (0.46%) ISO 9001
4 1 (0.46%) Sarbanes-Oxley
System Software
1 6 (2.76%) Apache Flume
2 5 (2.30%) Apache ZooKeeper
2 5 (2.30%) HDFS
3 1 (0.46%) Docker
3 1 (0.46%) Tivoli Workload Scheduler
Systems Management
1 2 (0.92%) Single Sign-On
2 1 (0.46%) Chronos
2 1 (0.46%) Marathon
2 1 (0.46%) Mesos
2 1 (0.46%) Oracle Flashback
2 1 (0.46%) Tivoli
Vendors
1 57 (26.27%) Microsoft
2 37 (17.05%) Oracle
3 25 (11.52%) SAP
4 21 (9.68%) Tableau
5 13 (5.99%) Teradata
6 12 (5.53%) Cloudera
7 10 (4.61%) IBM
8 8 (3.69%) Google
8 8 (3.69%) Informatica
8 8 (3.69%) MicroStrategy
9 6 (2.76%) Netezza
10 5 (2.30%) Hortonworks
10 5 (2.30%) MapR
11 4 (1.84%) Talend
12 3 (1.38%) Cognos
12 3 (1.38%) Jaspersoft
13 2 (0.92%) Greenplum
13 2 (0.92%) Hyperion
14 1 (0.46%) Micro Focus
14 1 (0.46%) Sybase