Period
to 24 September 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 24 September 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
24 Sep 2018
Same period 2017 Same period 2016
Rank 100 100 88
Rank change year-on-year 0 -12 -34
Contract jobs citing Data Warehouse 2,555 2,429 2,722
As % of all contract IT jobs advertised in the UK 2.51% 2.49% 2.55%
As % of the Database & Business Intelligence category 11.02% 11.13% 11.45%
Number of daily rates quoted 1,830 1,699 1,923
UK median daily rate £450 £450 £430
Median daily rate % change year-on-year - +4.65% +1.18%
10th Percentile £325 £315 £300
90th Percentile £600 £592 £625
UK excluding London median daily rate £430 £425 £400
% change year-on-year +1.18% +6.25% +2.56%
Number of hourly rates quoted 16 9 29
UK median hourly rate £30.00 £27.00 £35.00
Median hourly rate % change year-on-year +11.11% -22.86% +7.69%
10th Percentile £10.10 £15.08 £14.25
90th Percentile £68.97 £50.60 £52.25
UK excluding London median hourly rate £18.50 £28.25 £32.50
% change year-on-year -34.51% -13.08% +8.33%

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,181 21,824 23,774
As % of all contract IT jobs advertised in the UK 22.74% 22.41% 22.28%
Number of daily rates quoted 16,250 14,569 15,912
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £305 £281
90th Percentile £638 £625 £599
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 235 273 386
UK median hourly rate £27.73 £30.00 £29.94
Median hourly rate % change year-on-year -7.57% +0.20% +1.49%
10th Percentile £13.35 £12.50 £11.25
90th Percentile £56.00 £53.75 £48.56
UK excluding London median hourly rate £26.90 £31.08 £29.01
% change year-on-year -13.44% +7.11% -2.48%

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 24 September 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 24 September 2018.

Contractor hourly rate histogram for Data Warehouse in the UK

Data Warehouse
Top 17 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 24 September 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 0 2,376 £450 - 641
UK excluding London -15 1,334 £430 +1.18% 393
London +3 1,202 £500 +5.26% 288
South East -30 344 £450 +5.88% 89
North of England -23 291 £400 -5.88% 113
South West 0 202 £438 +2.94% 48
Midlands +10 198 £413 +3.13% 65
Yorkshire +1 143 £423 -0.59% 31
East of England +16 139 £448 +5.29% 39
North West -44 125 £400 -11.11% 65
East Midlands +30 99 £394 -1.56% 40
West Midlands -11 97 £438 -2.78% 25
Scotland -57 84 £400 - 26
Wales +10 64 £430 +25.62% 11
North East -16 23 £390 -26.59% 17
Northern Ireland +45 16 £432 -1.37% 3
Channel Islands -1 2 - -

For the 6 months to 24 September 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,433 (56.09%) SQL
2 1,340 (52.45%) Business Intelligence
3 1,003 (39.26%) ETL
4 882 (34.52%) SQL Server
5 808 (31.62%) Agile Software Development
6 706 (27.63%) Finance
7 681 (26.65%) SQL Server Integration Services
8 589 (23.05%) Data Modelling
9 573 (22.43%) Microsoft
10 564 (22.07%) Analytics
11 491 (19.22%) Oracle
12 459 (17.96%) SQL Server Reporting Services
13 452 (17.69%) Big Data
14 411 (16.09%) Microsoft Azure
15 406 (15.89%) Power BI
16 393 (15.38%) T-SQL
17 385 (15.07%) SQL Server Analysis Services
18 322 (12.60%) Analytical Skills
19 319 (12.49%) Hadoop
20 305 (11.94%) Relational Database
21 289 (11.31%) Data Quality
22 278 (10.88%) Amazon AWS
23 273 (10.68%) Visualisation
24 264 (10.33%) Scrum
25 258 (10.10%) Tableau
26 254 (9.94%) Migration
27 248 (9.71%) Data Analysis
28 245 (9.59%) Python
29 238 (9.32%) Data Lake
30 227 (8.88%) Apache Spark

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 227 (8.88%) Apache Spark
2 96 (3.76%) SAS
3 56 (2.19%) Apache
4 53 (2.07%) SharePoint
5 29 (1.14%) Confluence
6 23 (0.90%) Apache Pig
7 22 (0.86%) IIS
8 21 (0.82%) Elasticsearch
9 15 (0.59%) Apache Solr
10 9 (0.35%) Tomcat
11 7 (0.27%) Alfresco
11 7 (0.27%) Apache Airflow
11 7 (0.27%) Liferay
12 6 (0.23%) JBoss
13 5 (0.20%) Documentum
14 4 (0.16%) Drupal
14 4 (0.16%) FileNet
14 4 (0.16%) LiveLink
14 4 (0.16%) Oracle Workflow
14 4 (0.16%) PowerExchange
Applications
1 167 (6.54%) Microsoft Excel
2 32 (1.25%) Microsoft Office
3 30 (1.17%) Microsoft PowerPoint
4 22 (0.86%) MS Visio
5 15 (0.59%) Microsoft Project
6 6 (0.23%) SPSS
7 4 (0.16%) Spreadsheet
7 4 (0.16%) Stata
8 1 (0.039%) Adobe Illustrator
8 1 (0.039%) Photoshop
8 1 (0.039%) Shockwave
Business Applications
1 12 (0.47%) HFM
2 11 (0.43%) Dynamics CRM
2 11 (0.43%) SAP S/4HANA
3 9 (0.35%) Markit EDM
3 9 (0.35%) Oracle EBS
4 8 (0.31%) Dynamics AX
4 8 (0.31%) Infor M3
4 8 (0.31%) Oracle ERP
5 7 (0.27%) Cognos Business Intelligence
5 7 (0.27%) Hyperion Planning
5 7 (0.27%) SAP Oil and Gas
6 6 (0.23%) JDE EnterpriseOne
7 4 (0.16%) Cognos TM1
7 4 (0.16%) FastStats
8 3 (0.12%) Adobe Campaign
8 3 (0.12%) Oracle Applications
8 3 (0.12%) Oracle Financials
8 3 (0.12%) SAP ERP
8 3 (0.12%) Summit
8 3 (0.12%) Unica
Cloud Services
1 411 (16.09%) Microsoft Azure
2 278 (10.88%) Amazon AWS
3 97 (3.80%) Azure Data Factory
4 64 (2.50%) PaaS
5 55 (2.15%) Amazon S3
6 40 (1.57%) Amazon EC2
7 36 (1.41%) Amazon EMR
8 31 (1.21%) Google Cloud Platform
8 31 (1.21%) Serverless
9 29 (1.14%) IaaS
10 24 (0.94%) Amazon Kinesis
11 23 (0.90%) AWS Lambda
12 21 (0.82%) Data Lake Analytics
13 20 (0.78%) SaaS
14 18 (0.70%) Azure Machine Learning
15 17 (0.67%) Cortana Intelligence Suite
15 17 (0.67%) Dynamics 365
15 17 (0.67%) Google Analytics
16 15 (0.59%) GitHub
17 13 (0.51%) Office 365
Communications & Networking
1 22 (0.86%) SMS
2 15 (0.59%) Firewall
3 13 (0.51%) Intranet
4 12 (0.47%) SAN
5 11 (0.43%) FTP
6 9 (0.35%) Extranet
6 9 (0.35%) VPN
7 8 (0.31%) Internet
7 8 (0.31%) Kerberos
8 6 (0.23%) SSL
9 5 (0.20%) WAN
10 4 (0.16%) Ethernet
10 4 (0.16%) HTTP
10 4 (0.16%) Profibus
10 4 (0.16%) SMTP
11 3 (0.12%) ASN.1
11 3 (0.12%) Cisco Firepower
11 3 (0.12%) LAN
11 3 (0.12%) MQTT
11 3 (0.12%) Radio Access Network
Database & Business Intelligence
1 882 (34.52%) SQL Server
2 681 (26.65%) SQL Server Integration Services
3 459 (17.96%) SQL Server Reporting Services
4 452 (17.69%) Big Data
5 406 (15.89%) Power BI
6 385 (15.07%) SQL Server Analysis Services
7 319 (12.49%) Hadoop
8 305 (11.94%) Relational Database
9 238 (9.32%) Data Lake
10 212 (8.30%) OLAP
11 183 (7.16%) Apache Hive
12 154 (6.03%) Enterprise Data Warehouse
13 146 (5.71%) NoSQL
14 140 (5.48%) Oracle Database
15 125 (4.89%) BusinessObjects
16 121 (4.74%) Star Schema
17 118 (4.62%) SQL Server 2008
18 114 (4.46%) SQL Server 2016
19 112 (4.38%) Azure SQL Data Warehouse
20 104 (4.07%) PostgreSQL
Development Applications
1 114 (4.46%) JIRA
2 87 (3.41%) Git (software)
3 81 (3.17%) Team Foundation Server
4 70 (2.74%) Jenkins
5 60 (2.35%) Visual Studio
6 46 (1.80%) ERwin
7 35 (1.37%) Visual Studio Team System
8 28 (1.10%) Toad
9 18 (0.70%) Subversion
10 17 (0.67%) TeamCity
11 16 (0.63%) Selenium
12 15 (0.59%) Maven
13 14 (0.55%) SQL Server Management Studio (SSMS)
14 13 (0.51%) Octopus Deploy
15 12 (0.47%) JUnit
16 10 (0.39%) Cucumber
16 10 (0.39%) GitLab
16 10 (0.39%) SoapUI
16 10 (0.39%) SonarQube
17 9 (0.35%) Spinnaker
General
1 706 (27.63%) Finance
2 220 (8.61%) Banking
2 220 (8.61%) Retail
3 70 (2.74%) Investment Banking
3 70 (2.74%) Marketing
4 57 (2.23%) Manufacturing
5 40 (1.57%) Telecoms
6 33 (1.29%) Legal
7 24 (0.94%) Front Office
7 24 (0.94%) Publishing
8 21 (0.82%) Law
9 20 (0.78%) Games
10 17 (0.67%) Automotive
10 17 (0.67%) Pharmaceutical
11 16 (0.63%) Financial Institution
12 13 (0.51%) Retail Banking
13 12 (0.47%) Billing
14 11 (0.43%) Electronics
15 9 (0.35%) Advertising
15 9 (0.35%) Back Office
Job Titles
1 1,103 (43.17%) Developer
2 379 (14.83%) Analyst
3 356 (13.93%) Business Intelligence Developer
4 313 (12.25%) SQL Developer
5 264 (10.33%) Architect
6 195 (7.63%) Data Engineer
7 166 (6.50%) ETL Developer
8 152 (5.95%) Business Analyst
8 152 (5.95%) Data Architect
9 140 (5.48%) Data Warehouse Developer
10 122 (4.77%) Consultant
11 120 (4.70%) Data Analyst
12 118 (4.62%) Project Manager
13 117 (4.58%) SSIS Developer
14 97 (3.80%) Business Intelligence Analyst
15 91 (3.56%) SQL BI Developer
16 78 (3.05%) Power BI Developer
17 77 (3.01%) Senior Developer
18 74 (2.90%) Hadoop Engineer
19 70 (2.74%) Big Data Engineer
Libraries, Frameworks & Software Standards
1 149 (5.83%) .NET
2 148 (5.79%) Kafka
3 136 (5.32%) Web Services
4 124 (4.85%) XML
5 65 (2.54%) MDX
6 53 (2.07%) JSON
7 50 (1.96%) HTML
8 44 (1.72%) RESTful
9 39 (1.53%) CSS
10 35 (1.37%) Node.js
11 26 (1.02%) AngularJS
11 26 (1.02%) Spring
12 25 (0.98%) Middleware
13 24 (0.94%) J2EE
13 24 (0.94%) SOAP
14 23 (0.90%) ASP.NET
15 22 (0.86%) HTML5
16 21 (0.82%) jQuery
17 20 (0.78%) .NET Framework
18 18 (0.70%) REST
Miscellaneous
1 322 (12.60%) Analytical Skills
2 110 (4.31%) NHS
3 88 (3.44%) Data Structures
4 75 (2.94%) Management Information System
5 64 (2.50%) Greenfield Project
6 50 (1.96%) Computer Science
7 43 (1.68%) User Experience
8 40 (1.57%) Private Cloud
8 40 (1.57%) Self-Motivation
9 37 (1.45%) Replication
10 29 (1.14%) Enterprise Software
11 28 (1.10%) Algorithms
12 26 (1.02%) Reference Data
12 26 (1.02%) Taxonomies
13 24 (0.94%) Fixed Income
14 23 (0.90%) Fintech
14 23 (0.90%) Reinsurance
15 21 (0.82%) Derivative
16 14 (0.55%) Credit Risk
16 14 (0.55%) Data Centre
Operating Systems
1 142 (5.56%) Unix
2 124 (4.85%) Linux
3 66 (2.58%) Windows
4 28 (1.10%) Windows Server
5 18 (0.70%) Apple iOS
6 15 (0.59%) Android
7 10 (0.39%) Red Hat Enterprise Linux
7 10 (0.39%) Solaris
7 10 (0.39%) Windows Server 2003
8 9 (0.35%) AIX
9 6 (0.23%) VMS
9 6 (0.23%) Windows Server 2012
10 2 (0.078%) Windows 10
10 2 (0.078%) Windows 7
10 2 (0.078%) Windows Server 2008
10 2 (0.078%) Windows XP
10 2 (0.078%) zOS
11 1 (0.039%) CentOS
11 1 (0.039%) HPUX
11 1 (0.039%) Ubuntu
Processes & Methodologies
1 1,340 (52.45%) Business Intelligence
2 1,003 (39.26%) ETL
3 808 (31.62%) Agile Software Development
4 589 (23.05%) Data Modelling
5 564 (22.07%) Analytics
6 273 (10.68%) Visualisation
7 264 (10.33%) Scrum
8 254 (9.94%) Migration
9 248 (9.71%) Data Analysis
10 221 (8.65%) Data Integration
11 204 (7.98%) Kimball Methodology
12 199 (7.79%) Dimensional Modelling
13 195 (7.63%) Problem-Solving
13 195 (7.63%) Project Management
14 186 (7.28%) Stakeholder Management
15 181 (7.08%) Data Science
16 174 (6.81%) ETL Development
17 173 (6.77%) Data Architecture
18 172 (6.73%) Data Management
19 159 (6.22%) Performance Tuning
Programming Languages
1 1,433 (56.09%) SQL
2 393 (15.38%) T-SQL
3 245 (9.59%) Python
4 187 (7.32%) Java
5 168 (6.58%) PL/SQL
6 155 (6.07%) C#
7 82 (3.21%) R
8 76 (2.97%) Scala
9 67 (2.62%) Data Analysis Expressions (DAX)
10 66 (2.58%) JavaScript
11 63 (2.47%) PowerShell
12 62 (2.43%) PHP
13 59 (2.31%) Shell Script
13 59 (2.31%) VBA
14 50 (1.96%) Bash Shell
15 44 (1.72%) VB
16 35 (1.37%) Perl
17 26 (1.02%) C
18 22 (0.86%) VB.NET
19 21 (0.82%) MATLAB
Qualifications
1 127 (4.97%) Security Cleared
2 103 (4.03%) SC Cleared
3 90 (3.52%) Degree
4 33 (1.29%) Computer Science Degree
5 19 (0.74%) Master's Degree
6 16 (0.63%) PMP
7 15 (0.59%) ISEB
7 15 (0.59%) PMI Certification
8 13 (0.51%) Microsoft Certification
9 11 (0.43%) BPSS Clearance
10 8 (0.31%) DBS Check
10 8 (0.31%) DV Cleared
10 8 (0.31%) ISTQB
11 7 (0.27%) TOGAF Certification
12 6 (0.23%) APMP
13 5 (0.20%) CISSP
13 5 (0.20%) Numerate Degree
13 5 (0.20%) PRINCE2 Certification
14 4 (0.16%) AWS Certification
15 3 (0.12%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 289 (11.31%) Data Quality
2 102 (3.99%) QA
3 94 (3.68%) PMO
4 69 (2.70%) GDPR
5 10 (0.39%) MiFID
5 10 (0.39%) PCI DSS
6 8 (0.31%) Solvency II
7 6 (0.23%) IFRS
8 4 (0.16%) Basel II
8 4 (0.16%) EMIR
8 4 (0.16%) WCAG
9 3 (0.12%) HL7
9 3 (0.12%) IFRS 9
9 3 (0.12%) ISO 9000
9 3 (0.12%) SLA
10 2 (0.078%) GAAP
10 2 (0.078%) ISO 9001
10 2 (0.078%) ISO 9002
10 2 (0.078%) ISO/IEC 27001
10 2 (0.078%) TickIT
System Software
1 58 (2.27%) Docker
2 35 (1.37%) Apache Flume
3 33 (1.29%) Active Directory
3 33 (1.29%) HDFS
4 19 (0.74%) VMware Infrastructure
5 12 (0.47%) Virtual Machines
6 9 (0.35%) Apache ZooKeeper
6 9 (0.35%) vSphere
7 8 (0.31%) VMware ESXi
8 5 (0.20%) Oracle RAC
9 4 (0.16%) Hyper-V
10 2 (0.078%) NFS
10 2 (0.078%) Veritas Volume Manager
11 1 (0.039%) GPFS
11 1 (0.039%) Tivoli Workload Scheduler
11 1 (0.039%) Veritas Cluster Server
11 1 (0.039%) VirtualBox
11 1 (0.039%) Xen
Systems Management
1 92 (3.60%) Oozie
2 27 (1.06%) Kubernetes
3 21 (0.82%) Terraform
4 18 (0.70%) Ansible
5 17 (0.67%) Puppet
6 14 (0.55%) Opscode Chef
7 12 (0.47%) HP Quality Center
8 11 (0.43%) Kibana
9 10 (0.39%) Hadoop YARN
10 7 (0.27%) Data Guard
11 6 (0.23%) Control-M
11 6 (0.23%) Failover Clustering
11 6 (0.23%) Oracle RMAN
11 6 (0.23%) Tivoli
12 5 (0.20%) HP ALM
12 5 (0.20%) Oracle Flashback
13 4 (0.16%) Consul
13 4 (0.16%) Packer
14 3 (0.12%) Microsoft Clustering
14 3 (0.12%) Prometheus
Vendors
1 573 (22.43%) Microsoft
2 491 (19.22%) Oracle
3 258 (10.10%) Tableau
4 176 (6.89%) Informatica
5 150 (5.87%) SAP
6 91 (3.56%) Teradata
7 87 (3.41%) IBM
8 83 (3.25%) Talend
9 60 (2.35%) Google
10 56 (2.19%) Cognos
11 51 (2.00%) Cloudera
12 48 (1.88%) Ab Initio
13 39 (1.53%) MicroStrategy
14 37 (1.45%) Zend
15 34 (1.33%) Netezza
16 33 (1.29%) Alteryx
17 31 (1.21%) Salesforce.com
18 30 (1.17%) Hortonworks
19 25 (0.98%) VMware
20 22 (0.86%) RedGate