Period
to 5 December 2019

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 5 December 2019 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
5 Dec 2019
Same period 2018 Same period 2017
Rank 84 106 106
Rank change year-on-year +22 0 -18
Contract jobs citing Data Warehouse 2,212 2,604 2,432
As % of all contract IT jobs advertised in the UK 2.70% 2.49% 2.35%
As % of the Database & Business Intelligence category 12.70% 11.05% 10.68%
Number of daily rates quoted 1,541 1,836 1,735
UK median daily rate £475 £450 £450
Median daily rate % change year-on-year +5.56% - +4.65%
10th Percentile £313 £325 £313
90th Percentile £650 £613 £601
UK excluding London median daily rate £440 £425 £421
% change year-on-year +3.53% +0.89% +5.31%
Number of hourly rates quoted 27 26 22
UK median hourly rate £30.00 £19.25 £27.00
Median hourly rate % change year-on-year +55.84% -28.70% -34.15%
10th Percentile £14.94 £10.91 £14.54
90th Percentile £73.75 £58.02 £53.00
UK excluding London median hourly rate £25.02 £18.41 £32.25
% change year-on-year +35.94% -42.92% -19.12%

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 17,412 23,575 22,778
As % of all contract IT jobs advertised in the UK 21.27% 22.53% 22.04%
Number of daily rates quoted 11,726 16,447 15,587
UK median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £319 £313 £310
90th Percentile £656 £638 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% +5.26%
Number of hourly rates quoted 259 250 279
UK median hourly rate £32.50 £32.50 £30.50
Median hourly rate % change year-on-year - +6.56% +8.93%
10th Percentile £13.06 £13.65 £14.00
90th Percentile £65.00 £57.50 £57.25
UK excluding London median hourly rate £30.00 £35.00 £35.00
% change year-on-year -14.29% - +27.27%

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 5 December 2019.

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 5 December 2019.

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 5 December 2019. 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 +20 2,108 £475 +5.56% 570
London +22 1,103 £500 +4.17% 238
UK excluding London +14 1,069 £440 +3.53% 373
South East +37 289 £450 - 94
North of England +9 255 £420 +5.00% 117
Midlands +46 173 £400 - 62
South West -15 164 £450 +5.88% 33
North West +13 133 £388 -3.13% 73
West Midlands +59 123 £400 -5.88% 49
East of England +7 109 £463 +2.78% 26
Yorkshire -2 100 £425 +6.25% 37
East Midlands +10 50 £426 +6.56% 13
Scotland -37 47 £438 +4.48% 15
Wales -1 28 £375 -12.79% 23
North East +7 22 £450 +5.88% 7
Isle of Man +7 3 - -
Northern Ireland +2 2 £325 -7.80% 3

For the 6 months to 5 December 2019, 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,323 (59.81%) SQL
2 1,075 (48.60%) Business Intelligence
3 878 (39.69%) ETL
4 718 (32.46%) SQL Server
5 657 (29.70%) Azure
6 648 (29.29%) Agile Software Development
7 630 (28.48%) SQL Server Integration Services
8 562 (25.41%) Power Platform
9 561 (25.36%) Power BI
10 557 (25.18%) Data Modelling
11 548 (24.77%) Microsoft
12 512 (23.15%) Finance
13 503 (22.74%) Analytics
14 414 (18.72%) SQL Server Reporting Services
15 349 (15.78%) SQL Server Analysis Services
16 334 (15.10%) Data Lake
17 333 (15.05%) Oracle
18 327 (14.78%) Python
19 324 (14.65%) Big Data
20 314 (14.20%) Migration
21 287 (12.97%) T-SQL
22 267 (12.07%) AWS
23 255 (11.53%) Tableau
24 248 (11.21%) Analytical Skills
25 228 (10.31%) Visualisation
26 220 (9.95%) Azure SQL Data Warehouse
27 213 (9.63%) Azure Data Factory
28 191 (8.63%) Scrum
29 189 (8.54%) Data Quality
30 187 (8.45%) C#

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 148 (6.69%) Apache Spark
2 51 (2.31%) SharePoint
3 46 (2.08%) Apache
4 43 (1.94%) Confluence
5 41 (1.85%) SAS
6 35 (1.58%) Apache Airflow
7 19 (0.86%) Elasticsearch
8 16 (0.72%) WebLogic
9 10 (0.45%) CMS
10 7 (0.32%) IIS
10 7 (0.32%) Tomcat
11 6 (0.27%) Apache Solr
11 6 (0.27%) MS Exchange
11 6 (0.27%) Pachyderm
11 6 (0.27%) WebLogic Integration
12 4 (0.18%) Oracle SOA Suite
13 3 (0.14%) Exchange Server 2010
13 3 (0.14%) Exchange Server 2013
13 3 (0.14%) IBM Domino
13 3 (0.14%) Oracle Workflow
Applications
1 145 (6.56%) Microsoft Excel
2 29 (1.31%) Microsoft Office
3 23 (1.04%) Microsoft PowerPoint
4 16 (0.72%) MS Visio
5 6 (0.27%) Spreadsheet
6 4 (0.18%) Microsoft Project
6 4 (0.18%) SPSS
7 2 (0.090%) Chatbot
8 1 (0.045%) GIMP
8 1 (0.045%) Photoshop
8 1 (0.045%) S-PLUS
8 1 (0.045%) Stata
Business Applications
1 26 (1.18%) Dynamics CRM
2 13 (0.59%) Dynamics NAV
2 13 (0.59%) Sparx Enterprise Architect
3 11 (0.50%) SAP ERP
3 11 (0.50%) SAP Oil and Gas
4 10 (0.45%) Dynamics AX
5 9 (0.41%) Oracle Applications
5 9 (0.41%) Oracle EBS
6 6 (0.27%) Adobe Campaign
6 6 (0.27%) Oracle Financials
6 6 (0.27%) Unit4 Business World
7 5 (0.23%) Markit EDM
7 5 (0.23%) Oracle FAH
8 4 (0.18%) NetSuite
8 4 (0.18%) Oracle Assets
8 4 (0.18%) Oracle Cash Management
8 4 (0.18%) Oracle General Ledger
8 4 (0.18%) Oracle Internet Expenses
8 4 (0.18%) Oracle iProcurement
8 4 (0.18%) Oracle Receivables
Cloud Services
1 657 (29.70%) Azure
2 562 (25.41%) Power Platform
3 267 (12.07%) AWS
4 213 (9.63%) Azure Data Factory
5 114 (5.15%) GCP
6 63 (2.85%) PaaS
7 61 (2.76%) Serverless
8 53 (2.40%) Amazon S3
9 46 (2.08%) IaaS
10 43 (1.94%) Data Lake Analytics
10 43 (1.94%) GitHub
11 38 (1.72%) Amazon EMR
11 38 (1.72%) SaaS
12 30 (1.36%) AWS Lambda
13 28 (1.27%) Dynamics 365
14 23 (1.04%) Azure Machine Learning
15 22 (0.99%) Office 365
16 17 (0.77%) AWS CloudFormation
17 16 (0.72%) iPaaS
18 13 (0.59%) Amazon EC2
Communications & Networking
1 26 (1.18%) Internet
2 8 (0.36%) VPN
3 7 (0.32%) Firewall
4 6 (0.27%) DHCP
4 6 (0.27%) SAN
4 6 (0.27%) Skype
4 6 (0.27%) WAN
5 5 (0.23%) 3G
5 5 (0.23%) DNS
6 4 (0.18%) 4G
6 4 (0.18%) 5G
6 4 (0.18%) Cisco ASA
6 4 (0.18%) Cisco IOS
6 4 (0.18%) VLAN
7 3 (0.14%) FTP
7 3 (0.14%) HTTP
8 2 (0.090%) Intranet
8 2 (0.090%) LAN
8 2 (0.090%) MQTT
8 2 (0.090%) SSL
Database & Business Intelligence
1 718 (32.46%) SQL Server
2 630 (28.48%) SQL Server Integration Services
3 561 (25.36%) Power BI
4 414 (18.72%) SQL Server Reporting Services
5 349 (15.78%) SQL Server Analysis Services
6 334 (15.10%) Data Lake
7 324 (14.65%) Big Data
8 220 (9.95%) Azure SQL Data Warehouse
9 182 (8.23%) Azure SQL Database
10 175 (7.91%) Hadoop
11 173 (7.82%) Relational Database
12 132 (5.97%) Amazon Redshift
13 118 (5.33%) Oracle Database
14 96 (4.34%) BusinessObjects
14 96 (4.34%) Star Schema
15 85 (3.84%) Snowflake Schema
16 83 (3.75%) Enterprise Data Warehouse
17 76 (3.44%) NoSQL
18 75 (3.39%) SQL Server 2012
19 70 (3.16%) MySQL
Development Applications
1 115 (5.20%) JIRA
2 112 (5.06%) Git (software)
3 69 (3.12%) Jenkins
4 51 (2.31%) Visual Studio
5 39 (1.76%) Team Foundation Server
6 31 (1.40%) Visual Studio Team System
7 26 (1.18%) ERwin
7 26 (1.18%) Selenium
7 26 (1.18%) SQL Server Management Studio (SSMS)
8 16 (0.72%) ER Studio
9 14 (0.63%) PowerDesigner
10 12 (0.54%) Cucumber
10 12 (0.54%) Maven
10 12 (0.54%) Subversion
11 11 (0.50%) Atlassian Bamboo
11 11 (0.50%) Bitbucket
11 11 (0.50%) Sonatype Nexus
12 10 (0.45%) Oracle APEX
13 9 (0.41%) Bugzilla
13 9 (0.41%) TeamCity
General
1 512 (23.15%) Finance
2 134 (6.06%) Banking
3 129 (5.83%) Public Sector
4 126 (5.70%) Retail
5 54 (2.44%) Marketing
6 38 (1.72%) Legal
7 37 (1.67%) Front Office
8 36 (1.63%) Telecoms
9 27 (1.22%) Manufacturing
9 27 (1.22%) Pharmaceutical
10 25 (1.13%) Back Office
10 25 (1.13%) Investment Banking
11 19 (0.86%) Advertising
12 16 (0.72%) Financial Institution
13 15 (0.68%) Law
14 14 (0.63%) Electronics
15 10 (0.45%) Billing
16 8 (0.36%) Local Government
17 7 (0.32%) Publishing
18 6 (0.27%) Games
Job Titles
1 795 (35.94%) Developer
2 326 (14.74%) Analyst
3 307 (13.88%) Architect
4 296 (13.38%) Business Intelligence Developer
5 215 (9.72%) Data Architect
6 202 (9.13%) SQL Developer
7 201 (9.09%) Data Engineer
8 151 (6.83%) Data Analyst
9 121 (5.47%) Consultant
10 92 (4.16%) ETL Developer
11 87 (3.93%) Data Warehouse Developer
12 86 (3.89%) Business Analyst
13 82 (3.71%) Power BI Developer
14 78 (3.53%) Azure Developer
15 71 (3.21%) SQL BI Developer
16 67 (3.03%) Business Intelligence Analyst
17 65 (2.94%) Azure Architect
18 61 (2.76%) Project Manager
19 55 (2.49%) DBA
20 52 (2.35%) Data Modeller
Libraries, Frameworks & Software Standards
1 115 (5.20%) .NET
2 104 (4.70%) XML
3 79 (3.57%) MDX
4 68 (3.07%) Web Services
5 66 (2.98%) JSON
6 56 (2.53%) Kafka
7 45 (2.03%) REST
8 41 (1.85%) PySpark
9 35 (1.58%) SOAP
10 34 (1.54%) Middleware
11 27 (1.22%) HTML
12 25 (1.13%) WinForms
13 18 (0.81%) CSS
14 17 (0.77%) Node.js
14 17 (0.77%) Pandas
15 11 (0.50%) ASP.NET
16 10 (0.45%) .NET Framework
16 10 (0.45%) ADO.NET
16 10 (0.45%) Gherkin
16 10 (0.45%) JDBC
Miscellaneous
1 248 (11.21%) Analytical Skills
2 81 (3.66%) Data Structures
3 80 (3.62%) Management Information System
4 62 (2.80%) Greenfield Project
5 59 (2.67%) NHS
6 29 (1.31%) Self-Motivation
7 28 (1.27%) Data Centre
8 23 (1.04%) Algorithms
8 23 (1.04%) User Experience
9 21 (0.95%) Replication
10 20 (0.90%) Reference Data
11 15 (0.68%) Derivative
11 15 (0.68%) Enterprise Software
11 15 (0.68%) Equities
11 15 (0.68%) Linux Command Line
12 14 (0.63%) Clustering
12 14 (0.63%) Virtual Team
13 13 (0.59%) Private Cloud
13 13 (0.59%) Public Cloud
14 12 (0.54%) Client/Server
Operating Systems
1 76 (3.44%) Linux
2 73 (3.30%) Windows
3 69 (3.12%) Unix
4 25 (1.13%) Windows Server
5 15 (0.68%) AIX
6 9 (0.41%) Windows 10
7 8 (0.36%) Oracle Linux
8 7 (0.32%) VMS
9 6 (0.27%) Windows Server 2008
10 5 (0.23%) Windows Server 2012
11 4 (0.18%) Windows 7
12 3 (0.14%) Solaris
13 2 (0.090%) Android
13 2 (0.090%) Apple iOS
13 2 (0.090%) CentOS
13 2 (0.090%) Red Hat Enterprise Linux
14 1 (0.045%) Debian
Processes & Methodologies
1 1,075 (48.60%) Business Intelligence
2 878 (39.69%) ETL
3 648 (29.29%) Agile Software Development
4 557 (25.18%) Data Modelling
5 503 (22.74%) Analytics
6 314 (14.20%) Migration
7 228 (10.31%) Visualisation
8 191 (8.63%) Scrum
9 181 (8.18%) Stakeholder Management
10 177 (8.00%) DevOps
11 173 (7.82%) Data Science
12 169 (7.64%) Data Integration
13 161 (7.28%) Data Migration
14 155 (7.01%) Data Management
15 154 (6.96%) Data Architecture
16 152 (6.87%) Data Analysis
17 145 (6.56%) Dimensional Modelling
18 139 (6.28%) Kimball Methodology
19 136 (6.15%) Data Analytics
20 134 (6.06%) Problem-Solving
Programming Languages
1 1,323 (59.81%) SQL
2 327 (14.78%) Python
3 287 (12.97%) T-SQL
4 187 (8.45%) C#
5 129 (5.83%) Java
6 113 (5.11%) PL/SQL
7 77 (3.48%) Data Analysis Expressions (DAX)
8 71 (3.21%) PowerShell
9 70 (3.16%) Scala
10 67 (3.03%) R
11 54 (2.44%) JavaScript
12 38 (1.72%) VBA
13 35 (1.58%) VB.NET
14 25 (1.13%) Shell Script
15 21 (0.95%) VB
16 17 (0.77%) Perl
17 15 (0.68%) C
18 14 (0.63%) Go
18 14 (0.63%) U-SQL
19 13 (0.59%) Bash Shell
Qualifications
1 122 (5.52%) Security Cleared
2 103 (4.66%) SC Cleared
3 102 (4.61%) Degree
4 27 (1.22%) Computer Science Degree
5 14 (0.63%) ISEB
6 12 (0.54%) BPSS Clearance
6 12 (0.54%) Microsoft Certification
7 10 (0.45%) DBS Check
7 10 (0.45%) PMP
8 9 (0.41%) ISTQB
9 8 (0.36%) PMI Certification
10 7 (0.32%) AWS Certification
10 7 (0.32%) TOGAF Certification
11 6 (0.27%) MCITP
12 5 (0.23%) ACCA
12 5 (0.23%) CIMA
12 5 (0.23%) DV Cleared
12 5 (0.23%) Master's Degree
13 4 (0.18%) CFA
13 4 (0.18%) PhD
Quality Assurance & Compliance
1 189 (8.54%) Data Quality
2 85 (3.84%) QA
3 30 (1.36%) PMO
4 26 (1.18%) GDPR
5 16 (0.72%) SLA
6 11 (0.50%) MiFID
7 9 (0.41%) Dodd-Frank
7 9 (0.41%) EMIR
8 8 (0.36%) Disclosure Scotland
9 7 (0.32%) IFRS
9 7 (0.32%) ISO/IEC 27001
10 3 (0.14%) IFRS 9
10 3 (0.14%) NCSC
11 2 (0.090%) RMADS
12 1 (0.045%) Basel III
12 1 (0.045%) GxP
12 1 (0.045%) HL7
12 1 (0.045%) SNOMED CT
12 1 (0.045%) Solvency II
12 1 (0.045%) WCAG
System Software
1 52 (2.35%) Docker
2 29 (1.31%) Active Directory
3 18 (0.81%) HDFS
4 17 (0.77%) Tivoli Workload Scheduler
5 15 (0.68%) Apache Flume
5 15 (0.68%) VMware Infrastructure
6 11 (0.50%) Oracle RAC
7 7 (0.32%) Hyper-V
7 7 (0.32%) Virtual Machines
8 2 (0.090%) Cronacle
8 2 (0.090%) Veritas File System
8 2 (0.090%) Veritas Volume Manager
9 1 (0.045%) Apache ZooKeeper
9 1 (0.045%) Oracle Clusterware
Systems Management
1 49 (2.22%) Terraform
2 47 (2.12%) Kubernetes
3 30 (1.36%) Ansible
4 17 (0.77%) Tivoli
5 9 (0.41%) HP ALM
5 9 (0.41%) Puppet
6 8 (0.36%) Opscode Chef
7 7 (0.32%) Single Sign-On
8 6 (0.27%) Hadoop YARN
8 6 (0.27%) Kubeflow
8 6 (0.27%) Oracle RMAN
8 6 (0.27%) SCCM
9 5 (0.23%) Oozie
10 4 (0.18%) Data Guard
10 4 (0.18%) FortiGate
10 4 (0.18%) Microsoft Intune
11 2 (0.090%) Control-M
11 2 (0.090%) HP Quality Center
11 2 (0.090%) Nessus
12 1 (0.045%) ZABBIX
Vendors
1 548 (24.77%) Microsoft
2 333 (15.05%) Oracle
3 255 (11.53%) Tableau
4 150 (6.78%) Databricks
5 145 (6.56%) SAP
6 95 (4.29%) Informatica
7 85 (3.84%) Google
8 57 (2.58%) Talend
9 48 (2.17%) IBM
10 47 (2.12%) Teradata
11 41 (1.85%) Cognos
12 33 (1.49%) Salesforce.com
13 31 (1.40%) MicroStrategy
14 29 (1.31%) Alteryx
15 25 (1.13%) Cloudera
16 20 (0.90%) VMware
17 13 (0.59%) Citrix
18 12 (0.54%) Ab Initio
18 12 (0.54%) Adobe
18 12 (0.54%) MapR