Period
to 23 July 2017

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 23 July 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
6 months to
23 Jul 2017
Same period 2016 Same period 2015
Rank 672 661 603
Rank change year-on-year -11 -58 -15
Contract jobs citing Dimensional Modelling 181 229 289
As % of all contract IT jobs advertised in the UK 0.19% 0.21% 0.26%
As % of the Processes & Methodologies category 0.23% 0.25% 0.32%
Number of daily rates quoted 122 160 223
UK median daily rate £450 £413 £445
Median daily rate % change year-on-year +9.09% -7.30% +5.95%
10th Percentile £357 £313 £313
90th Percentile £550 £575 £550
UK excluding London median daily rate £450 £400 £425
% change year-on-year +12.50% -5.88% +5.59%
Number of hourly rates quoted 0 4 0
UK median hourly rate - £20.50 -
UK excluding London median hourly rate - £20.50 -

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

Contract Process & Methodology Skills
UK
Contract job vacancies with a requirement for process and methodology skills 80093 91859 91068
As % of all contract IT job vacancies advertised in the UK 84.22% 83.48% 80.58%
Number of daily rates quoted 52513 60584 57632
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% -
10th Percentile £275 £263 £258
90th Percentile £625 £600 £588
UK excluding London median daily rate £400 £400 £375
% change year-on-year - +6.67% +3.45%
Number of hourly rates quoted 2063 2196 2578
UK median hourly rate £25.00 £25.00 £22.00
Median hourly rate % change year-on-year - +13.64% +7.32%
10th Percentile £11.75 £11.50 £11.00
90th Percentile £52.50 £48.75 £47.83
UK excluding London median hourly rate £25.00 £26.00 £22.50
% change year-on-year -3.85% +15.56% +4.65%

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 23 July 2017.

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 23 July 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
England +21 167 £450 +9.09% 20
UK excluding London +36 109 £450 +12.50% 10
London +1 70 £475 +5.56% 13
South East +61 42 £475 +5.56% 5
South West +17 20 £400 -14.89%
North of England +13 15 £450 +28.57%
North West +25 14 £450 +9.09%
Midlands +13 11 £388 +3.33% 2
West Midlands +24 7 £375 +7.14% 1
East of England -8 7 £281 -22.41%
Scotland +23 6 £475 -5.00% 3
Wales +8 6 £500 +28.21%
East Midlands -12 4 £400 -3.03% 1
Northern Ireland - 2 £200 -
North East +42 1 - -

For the 6 months to 23 July 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 with a requirement for Dimensional Modelling.

1 151 (83.43%) Data Warehouse
2 141 (77.90%) Business Intelligence
3 113 (62.43%) SQL
4 111 (61.33%) Data Modelling
5 103 (56.91%) ETL
6 75 (41.44%) Oracle
7 74 (40.88%) Finance
8 73 (40.33%) Kimball Methodology
9 66 (36.46%) SQL Server Integration Services
10 61 (33.70%) SQL Server
11 57 (31.49%) Agile Software Development
12 52 (28.73%) SQL Server Reporting Services
13 40 (22.10%) PL/SQL
13 40 (22.10%) Microsoft
14 39 (21.55%) Oracle BI EE
15 38 (20.99%) Analytics
15 38 (20.99%) Performance Tuning
16 36 (19.89%) SQL Server Analysis Services
17 35 (19.34%) T-SQL
18 30 (16.57%) Data Management
19 28 (15.47%) Teradata
19 28 (15.47%) QlikView
19 28 (15.47%) Data Quality
19 28 (15.47%) Power BI
20 27 (14.92%) Data Analysis
21 26 (14.36%) Oracle Database
22 25 (13.81%) Talend
22 25 (13.81%) BusinessObjects
22 25 (13.81%) Talend Open Studio
23 24 (13.26%) SDLC

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 13 (7.18%) SAS
2 12 (6.63%) SharePoint
3 4 (2.21%) Apache Spark
4 3 (1.66%) BizTalk Server
5 2 (1.10%) SharePoint 2010
6 1 (0.55%) Apache Pig
6 1 (0.55%) Skype for Business
Applications
1 11 (6.08%) Microsoft Excel
2 7 (3.87%) MS Visio
3 2 (1.10%) Microsoft Office
Business Applications
1 5 (2.76%) Siebel CRM
2 2 (1.10%) Cognos Business Intelligence
2 2 (1.10%) Oracle Retail
3 1 (0.55%) Cognos TM1
3 1 (0.55%) Dynamics AX
3 1 (0.55%) HFM
3 1 (0.55%) Hyperion Planning
3 1 (0.55%) Lorenzo
3 1 (0.55%) Oracle EBS
3 1 (0.55%) Oracle Utilities
3 1 (0.55%) SAP BPC
3 1 (0.55%) SAP S/4HANA
Cloud Services
1 8 (4.42%) Amazon AWS
1 8 (4.42%) Microsoft Azure
2 2 (1.10%) Cloud Computing
2 2 (1.10%) GitHub
2 2 (1.10%) Google Cloud Platform
3 1 (0.55%) Amazon EMR
3 1 (0.55%) Azure Data Factory
3 1 (0.55%) Azure Machine Learning
3 1 (0.55%) PaaS
Communications & Networking
1 3 (1.66%) NAS
2 1 (0.55%) Skype
Database & Business Intelligence
1 151 (83.43%) Data Warehouse
2 66 (36.46%) SQL Server Integration Services
3 61 (33.70%) SQL Server
4 52 (28.73%) SQL Server Reporting Services
5 39 (21.55%) Oracle BI EE
6 36 (19.89%) SQL Server Analysis Services
7 28 (15.47%) Power BI
7 28 (15.47%) QlikView
8 26 (14.36%) Oracle Database
9 25 (13.81%) BusinessObjects
10 22 (12.15%) Relational Database
11 20 (11.05%) OLAP
12 19 (10.50%) Star Schema
13 17 (9.39%) Enterprise Data Warehouse
14 15 (8.29%) PowerPivot
15 13 (7.18%) Oracle Reports
16 12 (6.63%) Oracle Database 12c
16 12 (6.63%) SQL Server 2012
17 11 (6.08%) Oracle ODI
18 10 (5.52%) Oracle BI Publisher
Development Applications
1 25 (13.81%) Talend Open Studio
2 11 (6.08%) Team Foundation Server
3 9 (4.97%) ERwin
4 7 (3.87%) Oracle APEX
5 6 (3.31%) JIRA
6 5 (2.76%) Visual Studio
7 3 (1.66%) Git (software)
7 3 (1.66%) Jenkins
8 2 (1.10%) Subversion
8 2 (1.10%) Toad
9 1 (0.55%) Eclipse
9 1 (0.55%) Visual Studio Team System
General
1 74 (40.88%) Finance
2 15 (8.29%) Legal
3 12 (6.63%) Banking
4 11 (6.08%) Publishing
5 9 (4.97%) Retail
6 8 (4.42%) Marketing
7 6 (3.31%) Investment Banking
8 4 (2.21%) Law
9 2 (1.10%) Front Office
9 2 (1.10%) Pharmaceutical
9 2 (1.10%) Retail Banking
9 2 (1.10%) Telecoms
10 1 (0.55%) Automotive
10 1 (0.55%) Billing
10 1 (0.55%) Electronics
10 1 (0.55%) Local Government
10 1 (0.55%) Manufacturing
Job Titles
1 112 (61.88%) Developer
2 44 (24.31%) Business Intelligence Developer
3 42 (23.20%) Data Warehouse Developer
4 29 (16.02%) Analyst
5 26 (14.36%) SQL Developer
6 20 (11.05%) ETL Developer
7 19 (10.50%) Business Developer
8 16 (8.84%) Architect
9 13 (7.18%) Business Intelligence Analyst
9 13 (7.18%) OBIEE Developer
9 13 (7.18%) SSIS Developer
10 12 (6.63%) Data Analyst
11 11 (6.08%) Consultant
11 11 (6.08%) Power BI Developer
11 11 (6.08%) Talend Developer
12 10 (5.52%) Data Architect
13 9 (4.97%) SSAS Developer
14 8 (4.42%) SSRS Developer
15 7 (3.87%) Data Modeller
15 7 (3.87%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 23 (12.71%) MDX
2 8 (4.42%) D3.js
3 5 (2.76%) COM
4 4 (2.21%) XML
5 3 (1.66%) .NET
6 2 (1.10%) JSON
7 1 (0.55%) Apache Avro
7 1 (0.55%) Kafka
7 1 (0.55%) Oracle GoldenGate
Miscellaneous
1 13 (7.18%) Analytical Skills
2 12 (6.63%) Data Structures
3 6 (3.31%) Management Information System
4 3 (1.66%) Mainframe
5 2 (1.10%) Computer Science
6 1 (0.55%) Algorithms
6 1 (0.55%) Data Protection Act
6 1 (0.55%) NHS
6 1 (0.55%) Reference Data
6 1 (0.55%) User Experience
Operating Systems
1 6 (3.31%) Linux
1 6 (3.31%) Unix
2 3 (1.66%) MVS
Processes & Methodologies
1 141 (77.90%) Business Intelligence
2 111 (61.33%) Data Modelling
3 103 (56.91%) ETL
4 73 (40.33%) Kimball Methodology
5 57 (31.49%) Agile Software Development
6 38 (20.99%) Analytics
6 38 (20.99%) Performance Tuning
7 30 (16.57%) Data Management
8 27 (14.92%) Data Analysis
9 24 (13.26%) SDLC
10 23 (12.71%) Logical Data Model
11 21 (11.60%) Data Integration
12 18 (9.94%) Physical Data Model
12 18 (9.94%) Waterfall
13 17 (9.39%) Data Architecture
14 15 (8.29%) Software Engineering
15 13 (7.18%) Stakeholder Management
15 13 (7.18%) Validation
16 12 (6.63%) Migration
17 11 (6.08%) CRM
Programming Languages
1 113 (62.43%) SQL
2 40 (22.10%) PL/SQL
3 35 (19.34%) T-SQL
4 15 (8.29%) Data Analysis Expressions (DAX)
5 8 (4.42%) R
6 7 (3.87%) Python
7 6 (3.31%) C++
7 6 (3.31%) Shell Script
8 5 (2.76%) Java
9 4 (2.21%) JavaScript
10 3 (1.66%) C#
10 3 (1.66%) VBA
11 2 (1.10%) Tcl
12 1 (0.55%) Scala
12 1 (0.55%) VB.NET
Qualifications
1 20 (11.05%) Degree
2 7 (3.87%) HNC
2 7 (3.87%) HND
2 7 (3.87%) SC Cleared
2 7 (3.87%) Security Cleared
3 3 (1.66%) ISEB
4 1 (0.55%) Computer Science Degree
4 1 (0.55%) ISTQB
4 1 (0.55%) Master's Degree
4 1 (0.55%) Postgraduate
Quality Assurance & Compliance
1 28 (15.47%) Data Quality
2 4 (2.21%) QA
3 2 (1.10%) Solvency II
4 1 (0.55%) Basel II
4 1 (0.55%) GCP
4 1 (0.55%) ISO 9000
4 1 (0.55%) Sarbanes-Oxley
System Software
1 1 (0.55%) Tivoli Workload Scheduler
Systems Management
1 1 (0.55%) Tivoli
Vendors
1 75 (41.44%) Oracle
2 40 (22.10%) Microsoft
3 28 (15.47%) Teradata
4 25 (13.81%) Talend
5 23 (12.71%) Tableau
6 16 (8.84%) Informatica
7 12 (6.63%) Cognos
7 12 (6.63%) Netezza
8 9 (4.97%) Ab Initio
8 9 (4.97%) MicroStrategy
9 7 (3.87%) IBM
9 7 (3.87%) SAP
10 6 (3.31%) Sybase
11 5 (2.76%) Siebel
12 3 (1.66%) Vertica
13 2 (1.10%) Embarcadero
13 2 (1.10%) Google
13 2 (1.10%) Lavastorm
13 2 (1.10%) Salesforce.com
14 1 (0.55%) JD Edwards
London
Nigel Frank International
Rate: £550 - £600 per day
Posted: 3 days ago
Glasgow
Ampersand Consulting
Rate: £300 - £450 per day
Posted: 3 days ago