Period
to 16 July 2018

The following table provides summary statistics for contract job vacancies with a requirement for Data Warehouse skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Warehouse over the 6 months to 16 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.

Data Warehousing
UK
6 months to
16 Jul 2018
Same period 2017 Same period 2016
Rank 100 98 87
Rank change year-on-year -2 -11 -30
Contract jobs citing Data Warehouse 2,611 2,386 2,866
As % of all contract IT jobs advertised in the UK 2.52% 2.51% 2.60%
As % of the Database & Business Intelligence category 11.09% 11.19% 11.80%
Number of daily rates quoted 1,870 1,649 2,065
UK median daily rate £450 £450 £430
Median daily rate % change year-on-year - +4.65% +1.18%
10th Percentile £325 £313 £306
90th Percentile £600 £588 £638
UK excluding London median daily rate £425 £400 £407
% change year-on-year +6.25% -1.72% +5.71%
Number of hourly rates quoted 15 7 23
UK median hourly rate £26.50 £35.00 £23.00
Median hourly rate % change year-on-year -24.29% +52.17% -31.34%
10th Percentile £10.08 £28.84 £14.25
90th Percentile £104.50 £46.70 £52.25
UK excluding London median hourly rate £14.28 £35.00 £23.00
% change year-on-year -59.20% +52.17% -28.35%

Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 23,541 21,317 24,291
As % of all contract IT jobs advertised in the UK 22.69% 22.46% 22.06%
Number of daily rates quoted 16,409 14,149 16,288
UK median daily rate £463 £450 £425
Median daily rate % change year-on-year +2.78% +5.88% +6.25%
10th Percentile £313 £300 £280
90th Percentile £634 £614 £600
UK excluding London median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% +3.45%
Number of hourly rates quoted 236 271 377
UK median hourly rate £33.00 £31.00 £28.50
Median hourly rate % change year-on-year +6.45% +8.77% +14.00%
10th Percentile £14.00 £11.17 £11.85
90th Percentile £55.00 £52.50 £51.00
UK excluding London median hourly rate £34.00 £32.00 £29.25
% change year-on-year +6.25% +9.40% +17.00%

Data Warehouse
Job Vacancy Trend

Job postings citing Data Warehouse as a percentage of all IT jobs advertised.

Job vacancy trend for Data Warehouse in the UK

Data Warehouse
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Warehouse.

Contractor daily rate trend for Data Warehouse in the UK

Data Warehouse
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Data Warehouse over the 6 months to 16 July 2018.

Contractor daily rate histogram for Data Warehouse in the UK

Data Warehouse
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Warehouse.

Contractor hourly rate trend for Data Warehouse in the UK

Data Warehouse
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing Data Warehouse over the 6 months to 16 July 2018.

Contractor hourly rate histogram for Data Warehouse in the UK

Data Warehouse
Top 18 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Warehouse within the UK over the 6 months to 16 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
England -1 2,378 £463 +2.78% 611
UK excluding London -5 1,325 £425 +6.25% 355
London 0 1,266 £500 +5.26% 296
South East -31 324 £464 +9.12% 80
North of England -33 257 £425 +6.25% 100
Midlands +16 225 £410 +5.13% 59
South West +12 178 £440 +6.67% 46
Scotland -26 131 £400 - 21
East of England +44 127 £428 +0.59% 28
Yorkshire +4 126 £425 +9.68% 44
East Midlands +29 117 £388 +2.65% 31
North West -55 113 £400 +3.23% 50
West Midlands -1 106 £425 +6.25% 28
Wales 0 63 £410 +17.14% 16
Northern Ireland +35 23 £432 -1.37% 4
North East +4 21 £475 -9.52% 6
Channel Islands -2 1 - - 1
Isle of Man - 1 £400 -

For the 6 months to 16 July 2018, IT contractor jobs citing Data Warehouse 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 with a requirement for Data Warehouse.

1 1,446 (55.38%) SQL
2 1,352 (51.78%) Business Intelligence
3 1,079 (41.33%) ETL
4 858 (32.86%) Agile Software Development
5 827 (31.67%) SQL Server
6 749 (28.69%) Finance
7 662 (25.35%) SQL Server Integration Services
8 638 (24.44%) Data Modelling
9 621 (23.78%) Analytics
10 576 (22.06%) Microsoft
11 532 (20.38%) Oracle
12 492 (18.84%) Big Data
13 463 (17.73%) SQL Server Reporting Services
14 392 (15.01%) Microsoft Azure
15 390 (14.94%) SQL Server Analysis Services
16 382 (14.63%) Hadoop
17 355 (13.60%) Power BI
18 352 (13.48%) T-SQL
19 327 (12.52%) Analytical Skills
20 297 (11.37%) Relational Database
21 294 (11.26%) Python
22 279 (10.69%) Data Quality
23 278 (10.65%) Migration
24 274 (10.49%) Amazon AWS
25 272 (10.42%) Apache Spark
26 260 (9.96%) Data Analysis
27 252 (9.65%) Data Integration
27 252 (9.65%) Tableau
28 250 (9.57%) Visualisation
29 248 (9.50%) Data Lake

Data Warehouse
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 272 (10.42%) Apache Spark
2 108 (4.14%) SAS
3 79 (3.03%) Apache
4 62 (2.37%) SharePoint
5 48 (1.84%) Apache Pig
6 41 (1.57%) Confluence
7 28 (1.07%) Elasticsearch
8 21 (0.80%) Apache Solr
9 16 (0.61%) Oracle Workflow
10 15 (0.57%) IIS
11 13 (0.50%) Apache Airflow
12 9 (0.34%) Tomcat
13 7 (0.27%) Alfresco
13 7 (0.27%) JBoss
13 7 (0.27%) Liferay
14 6 (0.23%) PowerExchange
15 5 (0.19%) Documentum
16 4 (0.15%) FileNet
16 4 (0.15%) LiveLink
16 4 (0.15%) MS Exchange
Applications
1 155 (5.94%) Microsoft Excel
2 41 (1.57%) Microsoft PowerPoint
3 33 (1.26%) Microsoft Office
4 29 (1.11%) MS Visio
5 18 (0.69%) Microsoft Project
6 11 (0.42%) Stata
7 8 (0.31%) SPSS
8 7 (0.27%) Spreadsheet
9 2 (0.077%) Shockwave
10 1 (0.038%) Adobe Illustrator
10 1 (0.038%) Photoshop
Business Applications
1 15 (0.57%) Dynamics AX
2 10 (0.38%) Dynamics CRM
3 9 (0.34%) Cognos Business Intelligence
3 9 (0.34%) SAP S/4HANA
4 8 (0.31%) Markit EDM
5 6 (0.23%) HFM
5 6 (0.23%) JDE EnterpriseOne
5 6 (0.23%) Oracle ERP
6 5 (0.19%) Cognos TM1
6 5 (0.19%) Oracle Financials
6 5 (0.19%) SAP Oil and Gas
7 4 (0.15%) Oracle EBS
7 4 (0.15%) SAP ERP
8 3 (0.11%) Hyperion Planning
8 3 (0.11%) Infor CRM
8 3 (0.11%) NetSuite
8 3 (0.11%) Oracle Applications
8 3 (0.11%) Oracle Retail
8 3 (0.11%) Unica
8 3 (0.11%) Unit4 Business World
Cloud Services
1 392 (15.01%) Microsoft Azure
2 274 (10.49%) Amazon AWS
3 101 (3.87%) Azure Data Factory
4 65 (2.49%) PaaS
5 58 (2.22%) Amazon S3
6 42 (1.61%) Google Cloud Platform
7 38 (1.46%) Amazon EMR
8 36 (1.38%) Amazon Kinesis
8 36 (1.38%) Serverless
9 31 (1.19%) Amazon EC2
10 30 (1.15%) IaaS
10 30 (1.15%) SaaS
11 24 (0.92%) AWS Lambda
11 24 (0.92%) Data Lake Analytics
12 21 (0.80%) Google Analytics
13 20 (0.77%) Cortana Intelligence Suite
13 20 (0.77%) Dynamics 365
13 20 (0.77%) GitHub
14 15 (0.57%) Azure Machine Learning
14 15 (0.57%) Office 365
Communications & Networking
1 22 (0.84%) SMS
2 15 (0.57%) Firewall
3 13 (0.50%) SAN
4 11 (0.42%) FTP
5 9 (0.34%) Intranet
5 9 (0.34%) VPN
6 8 (0.31%) SSL
7 7 (0.27%) Internet
7 7 (0.27%) Kerberos
8 6 (0.23%) DNS
9 4 (0.15%) DSL
9 4 (0.15%) HTTP
10 3 (0.11%) ASN.1
10 3 (0.11%) Ethernet
10 3 (0.11%) NAS
10 3 (0.11%) Network Security
10 3 (0.11%) Profibus
10 3 (0.11%) SMTP
10 3 (0.11%) TCP/IP
10 3 (0.11%) WAN
Database & Business Intelligence
1 827 (31.67%) SQL Server
2 662 (25.35%) SQL Server Integration Services
3 492 (18.84%) Big Data
4 463 (17.73%) SQL Server Reporting Services
5 390 (14.94%) SQL Server Analysis Services
6 382 (14.63%) Hadoop
7 355 (13.60%) Power BI
8 297 (11.37%) Relational Database
9 248 (9.50%) Data Lake
10 202 (7.74%) Apache Hive
11 169 (6.47%) OLAP
12 151 (5.78%) Enterprise Data Warehouse
13 147 (5.63%) Oracle Database
14 143 (5.48%) NoSQL
15 130 (4.98%) Star Schema
16 113 (4.33%) SQL Server 2016
17 112 (4.29%) BusinessObjects
18 108 (4.14%) Amazon Redshift
18 108 (4.14%) PostgreSQL
19 106 (4.06%) Azure SQL Data Warehouse
Development Applications
1 121 (4.63%) JIRA
2 92 (3.52%) Git (software)
3 80 (3.06%) Team Foundation Server
4 63 (2.41%) Jenkins
5 62 (2.37%) Visual Studio
6 47 (1.80%) ERwin
7 36 (1.38%) Visual Studio Team System
8 25 (0.96%) Toad
9 23 (0.88%) SQL Server Management Studio (SSMS)
10 22 (0.84%) Subversion
11 21 (0.80%) TeamCity
12 15 (0.57%) Oracle APEX
13 13 (0.50%) GitLab
13 13 (0.50%) Octopus Deploy
13 13 (0.50%) RStudio
13 13 (0.50%) SpecFlow
14 11 (0.42%) JUnit
14 11 (0.42%) Maven
15 10 (0.38%) tSQLt
16 9 (0.34%) ER Studio
General
1 749 (28.69%) Finance
2 234 (8.96%) Banking
3 220 (8.43%) Retail
4 67 (2.57%) Marketing
5 55 (2.11%) Investment Banking
6 51 (1.95%) Manufacturing
7 45 (1.72%) Telecoms
8 41 (1.57%) Legal
9 23 (0.88%) Law
10 21 (0.80%) Retail Banking
11 18 (0.69%) Games
11 18 (0.69%) Publishing
12 16 (0.61%) Back Office
13 15 (0.57%) Billing
13 15 (0.57%) Pharmaceutical
14 14 (0.54%) Front Office
15 13 (0.50%) Automotive
16 11 (0.42%) Corporate Banking
16 11 (0.42%) General Ledger
17 8 (0.31%) Financial Institution
Job Titles
1 1,058 (40.52%) Developer
2 383 (14.67%) Analyst
3 337 (12.91%) Business Intelligence Developer
4 328 (12.56%) Architect
5 300 (11.49%) SQL Developer
6 221 (8.46%) Data Engineer
7 194 (7.43%) Data Architect
8 167 (6.40%) ETL Developer
9 133 (5.09%) Data Warehouse Developer
10 131 (5.02%) Business Analyst
11 128 (4.90%) Consultant
12 124 (4.75%) Project Manager
13 123 (4.71%) Data Analyst
14 113 (4.33%) SSIS Developer
15 91 (3.49%) Business Intelligence Analyst
16 77 (2.95%) SQL BI Developer
17 72 (2.76%) Oracle Developer
17 72 (2.76%) Solutions Architect
18 69 (2.64%) Senior Developer
19 67 (2.57%) Hadoop Engineer
Libraries, Frameworks & Software Standards
1 166 (6.36%) Kafka
2 158 (6.05%) .NET
3 135 (5.17%) XML
4 130 (4.98%) Web Services
5 62 (2.37%) JSON
5 62 (2.37%) MDX
6 59 (2.26%) HTML
7 46 (1.76%) CSS
8 35 (1.34%) RESTful
9 29 (1.11%) REST
10 26 (1.00%) Spark Streaming
11 25 (0.96%) jQuery
12 23 (0.88%) AngularJS
12 23 (0.88%) J2EE
12 23 (0.88%) React
13 22 (0.84%) HTML5
14 21 (0.80%) Middleware
14 21 (0.80%) SOAP
15 20 (0.77%) ASP.NET
15 20 (0.77%) Spring
Miscellaneous
1 327 (12.52%) Analytical Skills
2 120 (4.60%) NHS
3 87 (3.33%) Management Information System
4 85 (3.26%) Data Structures
5 58 (2.22%) Greenfield Project
6 44 (1.69%) Self-Motivation
7 43 (1.65%) User Experience
8 41 (1.57%) Computer Science
9 37 (1.42%) Fintech
10 35 (1.34%) Algorithms
11 34 (1.30%) Private Cloud
12 32 (1.23%) Credit Risk
13 26 (1.00%) Reference Data
13 26 (1.00%) Replication
14 25 (0.96%) Taxonomies
15 22 (0.84%) Data Centre
16 20 (0.77%) Fixed Income
16 20 (0.77%) Reinsurance
17 19 (0.73%) Derivative
18 17 (0.65%) Clustering
Operating Systems
1 159 (6.09%) Unix
2 132 (5.06%) Linux
3 86 (3.29%) Windows
4 41 (1.57%) Windows Server
5 10 (0.38%) Windows Server 2003
5 10 (0.38%) Windows Server 2012
6 9 (0.34%) Solaris
7 7 (0.27%) Apple iOS
7 7 (0.27%) Red Hat Enterprise Linux
7 7 (0.27%) Windows Server 2008
8 6 (0.23%) Android
8 6 (0.23%) VMS
9 5 (0.19%) AIX
10 4 (0.15%) Windows XP
11 3 (0.11%) CentOS
11 3 (0.11%) Windows 7
12 2 (0.077%) Windows 8
13 1 (0.038%) Ubuntu
13 1 (0.038%) Windows 10
13 1 (0.038%) zOS
Processes & Methodologies
1 1,352 (51.78%) Business Intelligence
2 1,079 (41.33%) ETL
3 858 (32.86%) Agile Software Development
4 638 (24.44%) Data Modelling
5 621 (23.78%) Analytics
6 278 (10.65%) Migration
7 260 (9.96%) Data Analysis
8 252 (9.65%) Data Integration
9 250 (9.57%) Visualisation
10 239 (9.15%) Scrum
11 214 (8.20%) Data Architecture
12 211 (8.08%) Kimball Methodology
12 211 (8.08%) Problem-Solving
13 193 (7.39%) Project Management
14 187 (7.16%) Data Management
14 187 (7.16%) Stakeholder Management
15 175 (6.70%) Performance Tuning
16 173 (6.63%) Dimensional Modelling
17 166 (6.36%) Data Science
17 166 (6.36%) ETL Development
Programming Languages
1 1,446 (55.38%) SQL
2 352 (13.48%) T-SQL
3 294 (11.26%) Python
4 216 (8.27%) Java
5 186 (7.12%) PL/SQL
6 163 (6.24%) C#
7 93 (3.56%) Scala
8 90 (3.45%) R
9 83 (3.18%) JavaScript
10 65 (2.49%) Shell Script
11 59 (2.26%) PowerShell
12 56 (2.14%) Data Analysis Expressions (DAX)
13 53 (2.03%) PHP
14 44 (1.69%) Bash Shell
15 41 (1.57%) VBA
16 34 (1.30%) Perl
17 30 (1.15%) VB.NET
18 23 (0.88%) C
19 22 (0.84%) VB
20 18 (0.69%) Korn
Qualifications
1 136 (5.21%) Security Cleared
2 105 (4.02%) SC Cleared
3 86 (3.29%) Degree
4 25 (0.96%) Computer Science Degree
5 21 (0.80%) ISEB
5 21 (0.80%) Microsoft Certification
6 19 (0.73%) DV Cleared
6 19 (0.73%) ISTQB
7 17 (0.65%) PMP
8 14 (0.54%) PMI Certification
9 13 (0.50%) DBS Check
10 8 (0.31%) BPSS Clearance
11 7 (0.27%) MCSE
11 7 (0.27%) TOGAF Certification
12 6 (0.23%) AWS Certification
12 6 (0.23%) MCSA
13 5 (0.19%) PRINCE2 Certification
14 4 (0.15%) APMP
14 4 (0.15%) ITIL Certification
14 4 (0.15%) Oracle Certification
Quality Assurance & Compliance
1 279 (10.69%) Data Quality
2 101 (3.87%) PMO
3 89 (3.41%) QA
4 71 (2.72%) GDPR
5 18 (0.69%) GCP
6 12 (0.46%) MiFID
7 8 (0.31%) PCI DSS
8 6 (0.23%) EMIR
8 6 (0.23%) IFRS
8 6 (0.23%) Solvency II
9 5 (0.19%) Basel II
9 5 (0.19%) IFRS 9
9 5 (0.19%) Sarbanes-Oxley
10 4 (0.15%) Disclosure Scotland
10 4 (0.15%) SLA
10 4 (0.15%) WCAG
11 3 (0.11%) HL7
12 2 (0.077%) GAAP
12 2 (0.077%) ISO 9001
12 2 (0.077%) ISO/IEC 20000
System Software
1 71 (2.72%) Apache Flume
1 71 (2.72%) Docker
2 46 (1.76%) HDFS
3 28 (1.07%) Active Directory
4 22 (0.84%) VMware Infrastructure
5 16 (0.61%) Apache ZooKeeper
6 14 (0.54%) Virtual Machines
7 11 (0.42%) Hyper-V
8 8 (0.31%) vSphere
9 7 (0.27%) VMware ESXi
10 5 (0.19%) Tivoli Workload Scheduler
11 3 (0.11%) Virtual Servers
12 2 (0.077%) NFS
12 2 (0.077%) Oracle RAC
12 2 (0.077%) Veritas Volume Manager
13 1 (0.038%) GPFS
13 1 (0.038%) Veritas Cluster Server
13 1 (0.038%) Xen
13 1 (0.038%) XenApp
Systems Management
1 112 (4.29%) Oozie
2 29 (1.11%) Terraform
3 20 (0.77%) Ansible
3 20 (0.77%) Puppet
4 17 (0.65%) Kubernetes
5 15 (0.57%) Opscode Chef
6 13 (0.50%) Hadoop YARN
7 12 (0.46%) Control-M
8 11 (0.42%) Failover Clustering
9 8 (0.31%) HP Quality Center
9 8 (0.31%) Kibana
9 8 (0.31%) Tivoli
10 7 (0.27%) Consul
10 7 (0.27%) Data Guard
10 7 (0.27%) Packer
11 6 (0.23%) Oracle Flashback
11 6 (0.23%) Oracle RMAN
12 4 (0.15%) HP ALM
12 4 (0.15%) Microsoft Clustering
12 4 (0.15%) Systems Management Server (SMS)
Vendors
1 576 (22.06%) Microsoft
2 532 (20.38%) Oracle
3 252 (9.65%) Tableau
4 198 (7.58%) Informatica
5 151 (5.78%) SAP
6 113 (4.33%) Talend
7 111 (4.25%) IBM
8 96 (3.68%) Cognos
9 92 (3.52%) Teradata
10 74 (2.83%) Google
11 72 (2.76%) Cloudera
12 46 (1.76%) Salesforce.com
13 38 (1.46%) Ab Initio
14 37 (1.42%) Hortonworks
15 32 (1.23%) MicroStrategy
16 28 (1.07%) Netezza
17 27 (1.03%) VMware
18 25 (0.96%) Alteryx
19 24 (0.92%) Zend
20 21 (0.80%) RedGate