Period
to 29 February 2020

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 29 February 2020 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
29 Feb 2020
Same period 2019 Same period 2018
Rank 84 101 109
Rank change year-on-year +17 +8 -19
Contract jobs citing Data Warehouse 1,776 2,520 2,335
As % of all contract IT jobs advertised in the UK 2.65% 2.55% 2.30%
As % of the Database & Business Intelligence category 12.54% 11.39% 10.50%
Number of daily rates quoted 1,203 1,749 1,697
UK median daily rate £475 £454 £450
Median daily rate % change year-on-year +4.63% +0.89% +5.88%
10th Percentile £320 £325 £313
90th Percentile £675 £625 £600
UK excluding London median daily rate £450 £438 £413
% change year-on-year +2.86% +6.06% +3.13%
Number of hourly rates quoted 27 28 24
UK median hourly rate £35.00 £19.18 £26.80
Median hourly rate % change year-on-year +82.53% -28.44% -33.01%
10th Percentile £14.94 £12.63 £13.30
90th Percentile £68.75 £49.69 £54.40
UK excluding London median hourly rate £35.00 £17.91 £27.00
% change year-on-year +95.45% -33.68% -30.32%

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 14,160 22,118 22,241
As % of all contract IT jobs advertised in the UK 21.13% 22.39% 21.86%
Number of daily rates quoted 9,321 15,244 15,473
UK median daily rate £475 £475 £464
Median daily rate % change year-on-year - +2.48% +7.79%
10th Percentile £319 £323 £311
90th Percentile £663 £650 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% -
Number of hourly rates quoted 238 253 255
UK median hourly rate £32.50 £35.00 £35.00
Median hourly rate % change year-on-year -7.14% - +27.27%
10th Percentile £14.18 £13.34 £15.21
90th Percentile £55.75 £56.50 £55.36
UK excluding London median hourly rate £26.50 £35.00 £39.50
% change year-on-year -24.29% -11.39% +43.64%

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 29 February 2020.

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 29 February 2020.

Contractor hourly rate histogram for Data Warehouse in the UK

Data Warehouse
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 Data Warehouse within the UK over the 6 months to 29 February 2020. 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 +16 1,676 £478 +3.52% 610
UK excluding London +17 899 £450 +2.86% 397
London +11 847 £500 +2.56% 247
South East +49 252 £463 +2.78% 76
North of England +41 248 £438 +8.02% 116
Midlands +8 126 £400 -5.88% 107
North West +41 117 £425 - 67
East of England +8 102 £450 -2.70% 26
Yorkshire +20 99 £425 +6.25% 41
South West -11 94 £475 +8.57% 38
West Midlands +30 90 £425 +3.03% 63
Wales +37 41 £375 -16.67% 17
East Midlands -1 36 £388 -8.82% 43
Scotland -54 36 £505 +18.82% 16
North East +29 33 £450 +5.88% 8

For the 6 months to 29 February 2020, 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,057 (59.52%) SQL
2 898 (50.56%) Business Intelligence
3 708 (39.86%) ETL
4 546 (30.74%) SQL Server
5 535 (30.12%) Azure
6 515 (29.00%) Agile Software Development
7 493 (27.76%) SQL Server Integration Services
8 483 (27.20%) Power Platform
9 468 (26.35%) Power BI
10 466 (26.24%) Data Modelling
11 441 (24.83%) Microsoft
12 391 (22.02%) Analytics
13 362 (20.38%) Finance
14 304 (17.12%) SQL Server Reporting Services
15 301 (16.95%) Oracle
16 285 (16.05%) Data Lake
17 278 (15.65%) SQL Server Analysis Services
18 266 (14.98%) T-SQL
19 257 (14.47%) Python
20 243 (13.68%) Big Data
21 231 (13.01%) Analytical Skills
22 221 (12.44%) AWS
23 216 (12.16%) Migration
24 196 (11.04%) Tableau
25 187 (10.53%) Visualisation
26 185 (10.42%) Azure SQL Data Warehouse
27 178 (10.02%) Azure Data Factory
28 157 (8.84%) DevOps
29 154 (8.67%) Relational Database
29 154 (8.67%) Azure SQL Database

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 85 (4.79%) Apache Spark
2 43 (2.42%) Confluence
3 39 (2.20%) SAS
4 38 (2.14%) Apache Airflow
5 37 (2.08%) SharePoint
6 31 (1.75%) Apache
7 22 (1.24%) WebLogic
8 16 (0.90%) Elasticsearch
9 12 (0.68%) Tomcat
10 10 (0.56%) CMS
11 8 (0.45%) Oracle SOA Suite
11 8 (0.45%) Oracle Workflow
12 6 (0.34%) Anypoint
13 5 (0.28%) Apache ServiceMix
13 5 (0.28%) JBoss
14 4 (0.23%) Apache Pig
14 4 (0.23%) Red Hat Fuse
15 3 (0.17%) Apache Solr
15 3 (0.17%) IBM Domino
16 2 (0.11%) Oracle Coherence
Applications
1 118 (6.64%) Microsoft Excel
2 22 (1.24%) Microsoft Office
3 11 (0.62%) Microsoft PowerPoint
4 9 (0.51%) Spreadsheet
5 8 (0.45%) MS Visio
6 5 (0.28%) Microsoft Project
7 4 (0.23%) Chatbot
7 4 (0.23%) SPSS
8 1 (0.056%) GIMP
8 1 (0.056%) Photoshop
Business Applications
1 15 (0.84%) Oracle Applications
2 14 (0.79%) Oracle EBS
3 13 (0.73%) Dynamics CRM
4 11 (0.62%) Sparx Enterprise Architect
5 6 (0.34%) Markit EDM
5 6 (0.34%) SAP Oil and Gas
6 4 (0.23%) Adobe Campaign
6 4 (0.23%) Dynamics AX
6 4 (0.23%) Dynamics NAV
7 3 (0.17%) Oracle Payroll
7 3 (0.17%) SAP MM
8 2 (0.11%) Cognos Business Intelligence
8 2 (0.11%) Cognos TM1
8 2 (0.11%) NetSuite
8 2 (0.11%) Primavera
8 2 (0.11%) Salesforce.com CRM
8 2 (0.11%) SAP BPC
8 2 (0.11%) SAP ERP
8 2 (0.11%) SystmOne
9 1 (0.056%) SAP LE
Cloud Services
1 535 (30.12%) Azure
2 483 (27.20%) Power Platform
3 221 (12.44%) AWS
4 178 (10.02%) Azure Data Factory
5 93 (5.24%) GCP
6 48 (2.70%) Amazon S3
7 45 (2.53%) PaaS
8 40 (2.25%) Serverless
9 26 (1.46%) Amazon EMR
9 26 (1.46%) AWS Lambda
10 25 (1.41%) SaaS
11 24 (1.35%) Data Lake Analytics
12 21 (1.18%) IaaS
13 18 (1.01%) Dynamics 365
14 16 (0.90%) Azure Machine Learning
15 15 (0.84%) GitHub
16 14 (0.79%) Amazon SQS
17 11 (0.62%) Amazon EC2
17 11 (0.62%) Amazon Kinesis
17 11 (0.62%) Slack
Communications & Networking
1 13 (0.73%) Firewall
2 9 (0.51%) HTTP
3 8 (0.45%) 3G
4 7 (0.39%) 4G
4 7 (0.39%) 5G
4 7 (0.39%) FTP
5 4 (0.23%) Internet
5 4 (0.23%) MQTT
5 4 (0.23%) VPN
6 3 (0.17%) SAN
6 3 (0.17%) SSL
7 2 (0.11%) DHCP
7 2 (0.11%) DNS
7 2 (0.11%) Intranet
7 2 (0.11%) Kerberos
7 2 (0.11%) Radio Access Network
7 2 (0.11%) Skype
8 1 (0.056%) Extranet
8 1 (0.056%) PuTTY
8 1 (0.056%) Wi-Fi
Database & Business Intelligence
1 546 (30.74%) SQL Server
2 493 (27.76%) SQL Server Integration Services
3 468 (26.35%) Power BI
4 304 (17.12%) SQL Server Reporting Services
5 285 (16.05%) Data Lake
6 278 (15.65%) SQL Server Analysis Services
7 243 (13.68%) Big Data
8 185 (10.42%) Azure SQL Data Warehouse
9 154 (8.67%) Azure SQL Database
9 154 (8.67%) Relational Database
10 151 (8.50%) Hadoop
11 94 (5.29%) Amazon Redshift
12 90 (5.07%) NoSQL
13 84 (4.73%) Snowflake Schema
14 82 (4.62%) Oracle Database
15 66 (3.72%) BigQuery
16 64 (3.60%) MySQL
17 59 (3.32%) Enterprise Data Warehouse
17 59 (3.32%) Microsoft Analysis Services
18 57 (3.21%) OLAP
Development Applications
1 104 (5.86%) JIRA
2 93 (5.24%) Git (software)
3 56 (3.15%) Jenkins
4 43 (2.42%) Team Foundation Server
5 33 (1.86%) SQL Server Management Studio (SSMS)
6 26 (1.46%) Visual Studio
7 20 (1.13%) Selenium
8 19 (1.07%) Subversion
8 19 (1.07%) Visual Studio Team System
9 16 (0.90%) ERwin
10 14 (0.79%) Oracle APEX
11 11 (0.62%) Maven
12 10 (0.56%) ER Studio
13 9 (0.51%) Bugzilla
14 8 (0.45%) Bitbucket
14 8 (0.45%) PowerDesigner
14 8 (0.45%) Sonatype Nexus
15 7 (0.39%) Artifactory
15 7 (0.39%) Toad
16 6 (0.34%) JMeter
General
1 362 (20.38%) Finance
2 121 (6.81%) Public Sector
3 99 (5.57%) Retail
4 81 (4.56%) Banking
5 47 (2.65%) Marketing
6 31 (1.75%) Law
7 28 (1.58%) Legal
8 25 (1.41%) Telecoms
9 24 (1.35%) Pharmaceutical
10 22 (1.24%) Manufacturing
11 19 (1.07%) Front Office
12 17 (0.96%) Back Office
13 10 (0.56%) Investment Banking
14 9 (0.51%) Advertising
14 9 (0.51%) Billing
15 8 (0.45%) Electronics
15 8 (0.45%) Publishing
16 7 (0.39%) Automotive
17 6 (0.34%) Financial Institution
18 5 (0.28%) Games
Job Titles
1 650 (36.60%) Developer
2 277 (15.60%) Architect
3 260 (14.64%) Analyst
4 255 (14.36%) Business Intelligence Developer
5 188 (10.59%) Data Engineer
6 182 (10.25%) Data Architect
7 144 (8.11%) SQL Developer
8 116 (6.53%) Data Analyst
9 107 (6.02%) Consultant
10 84 (4.73%) Data Warehouse Developer
11 81 (4.56%) Power BI Developer
12 76 (4.28%) ETL Developer
13 64 (3.60%) Azure Developer
13 64 (3.60%) Business Analyst
14 59 (3.32%) Azure Engineer
14 59 (3.32%) Business Intelligence Analyst
15 53 (2.98%) SQL BI Developer
16 49 (2.76%) Project Manager
17 46 (2.59%) Data Consultant
18 44 (2.48%) Senior Developer
Libraries, Frameworks & Software Standards
1 90 (5.07%) XML
2 75 (4.22%) .NET
3 54 (3.04%) Web Services
4 49 (2.76%) Kafka
5 45 (2.53%) JSON
6 42 (2.36%) MDX
7 34 (1.91%) REST
8 31 (1.75%) PySpark
9 30 (1.69%) HTML
10 26 (1.46%) SOAP
11 25 (1.41%) Middleware
12 20 (1.13%) JDBC
13 15 (0.84%) CSS
14 12 (0.68%) XSLT
15 11 (0.62%) Node.js
16 10 (0.56%) ASP.NET
17 9 (0.51%) .NET Framework
18 8 (0.45%) Pandas
18 8 (0.45%) scikit-learn
19 7 (0.39%) OAuth
Miscellaneous
1 231 (13.01%) Analytical Skills
2 77 (4.34%) Data Structures
3 63 (3.55%) NHS
4 60 (3.38%) Management Information System
5 50 (2.82%) Greenfield Project
6 26 (1.46%) Reference Data
7 24 (1.35%) Enterprise Software
8 19 (1.07%) Derivative
8 19 (1.07%) Replication
8 19 (1.07%) User Experience
9 17 (0.96%) Public Cloud
10 16 (0.90%) Algorithms
11 15 (0.84%) Data Centre
12 12 (0.68%) FMCG
13 11 (0.62%) Mobile App
14 9 (0.51%) Reinsurance
14 9 (0.51%) Self-Motivation
15 8 (0.45%) Client/Server
15 8 (0.45%) EPoS
16 7 (0.39%) Hedge funds
Operating Systems
1 60 (3.38%) Linux
2 45 (2.53%) Unix
3 40 (2.25%) Windows
4 17 (0.96%) AIX
5 14 (0.79%) Oracle Linux
6 11 (0.62%) Windows Server
7 6 (0.34%) Windows 10
8 4 (0.23%) Windows 7
8 4 (0.23%) Windows Server 2008
9 3 (0.17%) Android
9 3 (0.17%) Solaris
9 3 (0.17%) Windows Server 2012
10 2 (0.11%) Apple iOS
10 2 (0.11%) Ubuntu
11 1 (0.056%) CentOS
11 1 (0.056%) Red Hat Enterprise Linux
11 1 (0.056%) VME
Processes & Methodologies
1 898 (50.56%) Business Intelligence
2 708 (39.86%) ETL
3 515 (29.00%) Agile Software Development
4 466 (26.24%) Data Modelling
5 391 (22.02%) Analytics
6 216 (12.16%) Migration
7 187 (10.53%) Visualisation
8 157 (8.84%) DevOps
9 152 (8.56%) Data Analysis
9 152 (8.56%) Scrum
10 142 (8.00%) Data Architecture
11 140 (7.88%) Kimball Methodology
12 138 (7.77%) Data Management
13 115 (6.48%) Data Science
14 114 (6.42%) Data Analytics
14 114 (6.42%) Data Integration
15 112 (6.31%) Data Visualisation
15 112 (6.31%) Stakeholder Management
16 109 (6.14%) Data Migration
17 105 (5.91%) Dimensional Modelling
Programming Languages
1 1,057 (59.52%) SQL
2 266 (14.98%) T-SQL
3 257 (14.47%) Python
4 120 (6.76%) Java
5 109 (6.14%) PL/SQL
6 107 (6.02%) C#
7 73 (4.11%) PowerShell
8 67 (3.77%) Scala
9 52 (2.93%) Data Analysis Expressions (DAX)
9 52 (2.93%) JavaScript
10 37 (2.08%) R
11 31 (1.75%) Shell Script
12 21 (1.18%) VBA
13 19 (1.07%) VB
14 18 (1.01%) Perl
15 17 (0.96%) Ruby
16 16 (0.90%) VB.NET
17 14 (0.79%) C
18 13 (0.73%) Go
19 9 (0.51%) PHP
Qualifications
1 135 (7.60%) Security Cleared
2 121 (6.81%) SC Cleared
3 70 (3.94%) Degree
4 16 (0.90%) Computer Science Degree
5 13 (0.73%) Microsoft Certification
6 10 (0.56%) BPSS Clearance
7 9 (0.51%) PMI Certification
7 9 (0.51%) PMP
8 8 (0.45%) AWS Certification
9 7 (0.39%) TOGAF Certification
10 6 (0.34%) ISEB
11 5 (0.28%) MCITP
12 4 (0.23%) ISTQB
12 4 (0.23%) Master's Degree
13 3 (0.17%) APMP
13 3 (0.17%) DBS Check
13 3 (0.17%) PRINCE2 Certification
14 2 (0.11%) ITIL Certification
14 2 (0.11%) Postgraduate
15 1 (0.056%) PhD
Quality Assurance & Compliance
1 136 (7.66%) Data Quality
2 59 (3.32%) QA
3 23 (1.30%) GDPR
4 20 (1.13%) PMO
5 11 (0.62%) SLA
6 9 (0.51%) IFRS
7 7 (0.39%) Disclosure Scotland
8 6 (0.34%) Solvency II
9 4 (0.23%) RMADS
10 1 (0.056%) Basel III
10 1 (0.056%) BS7799
10 1 (0.056%) COBIT
10 1 (0.056%) GAAP
10 1 (0.056%) Government Security Classifications
10 1 (0.056%) GxP
10 1 (0.056%) IFRS 9
10 1 (0.056%) MiFID
10 1 (0.056%) NCSC
10 1 (0.056%) SNOMED CT
10 1 (0.056%) WCAG
System Software
1 28 (1.58%) Docker
2 25 (1.41%) Apache Flume
3 21 (1.18%) HDFS
4 12 (0.68%) Tivoli Workload Scheduler
5 11 (0.62%) Active Directory
6 10 (0.56%) Virtual Machines
7 7 (0.39%) VMware Infrastructure
8 6 (0.34%) Oracle RAC
9 4 (0.23%) Hyper-V
10 1 (0.056%) Apache ZooKeeper
10 1 (0.056%) iptables
10 1 (0.056%) KVM
10 1 (0.056%) Oracle Clusterware
10 1 (0.056%) VMware ESXi
Systems Management
1 45 (2.53%) Terraform
2 28 (1.58%) Kubernetes
3 24 (1.35%) Ansible
4 13 (0.73%) Tivoli
5 5 (0.28%) Oracle RMAN
6 4 (0.23%) Control-M
6 4 (0.23%) HP ALM
6 4 (0.23%) Oozie
7 3 (0.17%) Puppet
8 2 (0.11%) Hadoop YARN
8 2 (0.11%) Oracle Enterprise Manager
8 2 (0.11%) Single Sign-On
9 1 (0.056%) Automic
9 1 (0.056%) Data Guard
9 1 (0.056%) Failover Clustering
9 1 (0.056%) HP Fortify
9 1 (0.056%) Kibana
9 1 (0.056%) Kubeflow
9 1 (0.056%) Oracle Flashback
9 1 (0.056%) SCCM
Vendors
1 441 (24.83%) Microsoft
2 301 (16.95%) Oracle
3 196 (11.04%) Tableau
4 112 (6.31%) SAP
5 109 (6.14%) Databricks
6 80 (4.50%) Informatica
7 57 (3.21%) Google
8 47 (2.65%) Talend
9 44 (2.48%) IBM
10 35 (1.97%) Cognos
11 29 (1.63%) MicroStrategy
12 26 (1.46%) Cloudera
12 26 (1.46%) Teradata
13 23 (1.30%) Salesforce.com
14 18 (1.01%) Alteryx
15 15 (0.84%) Ab Initio
16 12 (0.68%) MapR
17 11 (0.62%) Hortonworks
17 11 (0.62%) VMware
18 10 (0.56%) Adobe