Period
to 3 June 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 3 June 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
3 Jun 2020
Same period 2019 Same period 2018
Rank 87 88 101
Rank change year-on-year +1 +13 -3
Contract jobs citing Data Warehouse 1,172 2,452 2,528
As % of all contract jobs advertised in the UK 2.59% 2.73% 2.50%
As % of the Database & Business Intelligence category 12.20% 12.22% 11.13%
Number of daily rates quoted 788 1,734 1,859
Median daily rate £475 £468 £463
Median daily rate % change year-on-year +1.50% +1.19% +5.71%
10th Percentile £325 £326 £318
90th Percentile £675 £630 £600
UK excluding London median daily rate £450 £450 £425
% change year-on-year - +5.88% +6.25%
Number of hourly rates quoted 15 16 17
Median hourly rate £35.00 £20.30 £23.00
Median hourly rate % change year-on-year +72.41% -11.74% -34.29%
10th Percentile £28.75 £14.00 £10.12
90th Percentile £68.75 £41.28 £94.25
UK excluding London median hourly rate £50.25 £16.72 £14.21
% change year-on-year +200.54% +17.64% -59.39%

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 9,605 20,065 22,723
As % of all contract IT jobs advertised in the UK 21.25% 22.32% 22.48%
Number of daily rates quoted 6,286 13,713 15,800
Median daily rate £490 £475 £473
Median daily rate % change year-on-year +3.16% +0.53% +8.00%
10th Percentile £325 £325 £313
90th Percentile £675 £650 £625
UK excluding London median daily rate £450 £430 £415
% change year-on-year +4.65% +3.68% +5.00%
Number of hourly rates quoted 190 247 239
Median hourly rate £35.00 £35.00 £34.50
Median hourly rate % change year-on-year - +1.45% +15.71%
10th Percentile £16.00 £14.18 £14.00
90th Percentile £53.08 £57.50 £53.55
Median hourly rate £35.00 £32.50 £35.00
% change year-on-year +7.69% -7.14% +20.69%

Data Warehouse
Job Vacancy Trend

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

Job vacancy trend for Data Warehouse in the UK

Data Warehouse
Contractor Daily Rate Trend

3-month moving average daily rate quoted in jobs citing Data Warehouse.

Daily rate trend for Data Warehouse in the UK

Data Warehouse
Daily Rate Histogram

Daily rate distribution for jobs citing Data Warehouse over the 6 months to 3 June 2020.

Daily rate histogram for Data Warehouse in the UK

Data Warehouse
Contractor Hourly Rate Trend

3-month moving average hourly rates quoted in jobs citing Data Warehouse.

Hourly rate trend for Data Warehouse in the UK

Data Warehouse
Hourly Rate Histogram

Hourly rate distribution of jobs citing Data Warehouse over the 6 months to 3 June 2020.

Hourly rate histogram for Data Warehouse in the UK

Data Warehouse
Top 16 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 3 June 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 +2 1,105 £475 - 172
UK excluding London 0 580 £450 - 142
London +3 567 £500 +3.09% 40
South East +33 180 £500 +11.11% 26
North of England +22 145 £473 +6.48% 33
Midlands +1 86 £400 -8.57% 39
North West +38 76 £406 -9.83% 28
West Midlands +7 62 £450 - 37
South West +15 60 £450 - 15
East of England -1 57 £438 -5.66% 22
Yorkshire +14 56 £575 +35.29% 3
Work from Home +13 38 £500 +26.58% 25
Wales +24 27 £340 -15.00% 3
Scotland -18 25 £450 - 7
East Midlands +8 23 £375 - 2
North East +24 14 £475 +15.15% 2

For the 6 months to 3 June 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 704 (60.07%) SQL
2 600 (51.19%) Business Intelligence
3 480 (40.96%) ETL
4 391 (33.36%) Azure
5 367 (31.31%) SQL Server
6 341 (29.10%) Agile Software Development
7 311 (26.54%) SQL Server Integration Services
7 311 (26.54%) Power Platform
8 297 (25.34%) Power BI
9 289 (24.66%) Data Modelling
10 286 (24.40%) Microsoft
11 264 (22.53%) Finance
12 247 (21.08%) Analytics
13 219 (18.69%) Oracle
14 205 (17.49%) Python
15 194 (16.55%) Data Lake
16 185 (15.78%) DevOps
17 173 (14.76%) T-SQL
18 169 (14.42%) AWS
19 165 (14.08%) Big Data
20 162 (13.82%) SQL Server Analysis Services
21 155 (13.23%) SQL Server Reporting Services
22 146 (12.46%) Analytical Skills
23 137 (11.69%) Migration
24 129 (11.01%) Kimball Methodology
25 109 (9.30%) Azure Data Factory
26 108 (9.22%) Java
27 104 (8.87%) Tableau
27 104 (8.87%) Azure SQL Data Warehouse
28 103 (8.79%) Visualisation

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 50 (4.27%) Apache Spark
2 39 (3.33%) SAS
3 28 (2.39%) Apache
4 19 (1.62%) Confluence
4 19 (1.62%) SharePoint
4 19 (1.62%) WebLogic
5 10 (0.85%) Apache Airflow
6 8 (0.68%) Elasticsearch
6 8 (0.68%) IIS
7 6 (0.51%) Apache ServiceMix
7 6 (0.51%) CMS
7 6 (0.51%) JBoss
7 6 (0.51%) Oracle Workflow
8 5 (0.43%) Apache Pig
8 5 (0.43%) Red Hat Fuse
8 5 (0.43%) Tomcat
9 4 (0.34%) Anypoint
9 4 (0.34%) Oracle SOA Suite
10 3 (0.26%) Apache Pulsar
11 2 (0.17%) EPiServer
Applications
1 77 (6.57%) Microsoft Excel
2 9 (0.77%) Microsoft Office
3 6 (0.51%) Spreadsheet
4 5 (0.43%) Microsoft PowerPoint
5 3 (0.26%) Microsoft Project
5 3 (0.26%) MS Visio
6 2 (0.17%) Chatbot
7 1 (0.085%) SPSS
Business Applications
1 14 (1.19%) Oracle EBS
2 6 (0.51%) Oracle Applications
3 4 (0.34%) Dynamics CRM
4 3 (0.26%) Markit EDM
4 3 (0.26%) Oracle Payroll
4 3 (0.26%) Salesforce.com CRM
4 3 (0.26%) SAP Oil and Gas
5 2 (0.17%) HFM
5 2 (0.17%) SAP S/4HANA
6 1 (0.085%) Bloomberg AIM
6 1 (0.085%) Cognos Business Intelligence
6 1 (0.085%) NetSuite
6 1 (0.085%) SAP CO
6 1 (0.085%) SAP FI/CO
6 1 (0.085%) SAP LE
6 1 (0.085%) SAP SCM
6 1 (0.085%) SimCorp Dimension
6 1 (0.085%) Sparx Enterprise Architect
6 1 (0.085%) Summit
6 1 (0.085%) SystmOne
Cloud Services
1 391 (33.36%) Azure
2 311 (26.54%) Power Platform
3 169 (14.42%) AWS
4 109 (9.30%) Azure Data Factory
5 70 (5.97%) GCP
6 41 (3.50%) Serverless
7 35 (2.99%) Amazon S3
8 34 (2.90%) PaaS
9 29 (2.47%) AWS Lambda
10 17 (1.45%) Logic Apps
11 16 (1.37%) Amazon EC2
11 16 (1.37%) Amazon ECS
11 16 (1.37%) SaaS
12 15 (1.28%) Amazon EMR
12 15 (1.28%) IaaS
13 10 (0.85%) Amazon CloudWatch
13 10 (0.85%) Slack
14 9 (0.77%) Azure Functions
15 8 (0.68%) Apigee
15 8 (0.68%) GitHub
Communications & Networking
1 17 (1.45%) Firewall
2 8 (0.68%) 3G
2 8 (0.68%) 4G
2 8 (0.68%) 5G
3 7 (0.60%) HTTP
4 6 (0.51%) FTP
4 6 (0.51%) Kerberos
5 5 (0.43%) SSL
6 4 (0.34%) DNS
7 3 (0.26%) Internet
8 2 (0.17%) MQTT
8 2 (0.17%) Skype
8 2 (0.17%) VPN
9 1 (0.085%) DHCP
9 1 (0.085%) Network Security
9 1 (0.085%) Radio Access Network
9 1 (0.085%) Reverse Proxy
9 1 (0.085%) SAN
9 1 (0.085%) SSH
Database & Business Intelligence
1 367 (31.31%) SQL Server
2 311 (26.54%) SQL Server Integration Services
3 297 (25.34%) Power BI
4 194 (16.55%) Data Lake
5 165 (14.08%) Big Data
6 162 (13.82%) SQL Server Analysis Services
7 155 (13.23%) SQL Server Reporting Services
8 104 (8.87%) Azure SQL Data Warehouse
9 103 (8.79%) Relational Database
10 97 (8.28%) Azure SQL Database
11 82 (7.00%) Hadoop
12 73 (6.23%) Amazon Redshift
13 65 (5.55%) Oracle Database
14 60 (5.12%) NoSQL
15 59 (5.03%) MySQL
16 57 (4.86%) Snowflake Schema
17 53 (4.52%) OLAP
18 46 (3.92%) RDBMS
19 45 (3.84%) Microsoft Analysis Services
20 42 (3.58%) PostgreSQL
Development Applications
1 75 (6.40%) Git (software)
2 54 (4.61%) JIRA
3 48 (4.10%) Jenkins
4 35 (2.99%) Team Foundation Server
5 24 (2.05%) SQL Server Management Studio (SSMS)
6 23 (1.96%) GitLab
7 22 (1.88%) Visual Studio Team System
8 19 (1.62%) Artifactory
9 18 (1.54%) Bitbucket
10 15 (1.28%) Maven
11 14 (1.19%) Visual Studio
12 11 (0.94%) Subversion
13 10 (0.85%) ERwin
14 7 (0.60%) Eclipse
14 7 (0.60%) Oracle APEX
14 7 (0.60%) Toad
15 6 (0.51%) PowerBuilder
16 5 (0.43%) JMeter
16 5 (0.43%) Octopus Deploy
16 5 (0.43%) ProC
General
1 264 (22.53%) Finance
2 90 (7.68%) Banking
3 76 (6.48%) Public Sector
4 51 (4.35%) Retail
5 36 (3.07%) Back Office
6 29 (2.47%) Law
7 27 (2.30%) Marketing
8 21 (1.79%) Investment Banking
9 17 (1.45%) Telecoms
10 16 (1.37%) Legal
11 9 (0.77%) Billing
11 9 (0.77%) Pharmaceutical
12 7 (0.60%) Front Office
12 7 (0.60%) Manufacturing
13 6 (0.51%) Automotive
13 6 (0.51%) Financial Institution
14 5 (0.43%) Advertising
14 5 (0.43%) Publishing
15 3 (0.26%) General Ledger
15 3 (0.26%) Multimedia
Job Titles
1 413 (35.24%) Developer
2 184 (15.70%) Architect
3 153 (13.05%) Analyst
4 148 (12.63%) Data Engineer
5 141 (12.03%) Business Intelligence Developer
6 110 (9.39%) Data Architect
7 108 (9.22%) SQL Developer
8 69 (5.89%) Consultant
9 68 (5.80%) Data Warehouse Developer
10 64 (5.46%) Data Analyst
11 53 (4.52%) Azure Engineer
12 47 (4.01%) Power BI Developer
13 45 (3.84%) ETL Developer
14 40 (3.41%) Business Analyst
15 39 (3.33%) Senior Developer
16 37 (3.16%) Azure Developer
16 37 (3.16%) DBA
17 34 (2.90%) Project Manager
18 32 (2.73%) SQL BI Developer
19 27 (2.30%) Oracle Developer
Libraries, Frameworks & Software Standards
1 94 (8.02%) .NET
2 60 (5.12%) XML
3 50 (4.27%) Web Services
4 43 (3.67%) JSON
5 30 (2.56%) Kafka
6 25 (2.13%) PySpark
7 20 (1.71%) REST
8 19 (1.62%) HTML
9 16 (1.37%) gRPC
9 16 (1.37%) MDX
10 15 (1.28%) .NET Framework
11 14 (1.19%) ASP.NET
12 13 (1.11%) OAuth
13 12 (1.02%) CSS
13 12 (1.02%) SOAP
14 11 (0.94%) AngularJS
14 11 (0.94%) Middleware
15 10 (0.85%) JDBC
15 10 (0.85%) Swagger
15 10 (0.85%) WinForms
Miscellaneous
1 146 (12.46%) Analytical Skills
2 44 (3.75%) Data Structures
3 33 (2.82%) NHS
4 32 (2.73%) Greenfield Project
5 31 (2.65%) Management Information System
6 25 (2.13%) Hedge funds
7 21 (1.79%) Enterprise Software
8 16 (1.37%) Replication
8 16 (1.37%) User Experience
9 14 (1.19%) Data Centre
10 13 (1.11%) Algorithms
11 12 (1.02%) FMCG
11 12 (1.02%) Reference Data
12 10 (0.85%) Public Cloud
13 8 (0.68%) Self-Motivation
14 7 (0.60%) Cloud Native
14 7 (0.60%) Derivative
14 7 (0.60%) Mobile App
15 6 (0.51%) PKI
15 6 (0.51%) Reinsurance
Operating Systems
1 42 (3.58%) Unix
2 39 (3.33%) Linux
3 35 (2.99%) Windows
4 17 (1.45%) VMS
5 10 (0.85%) Windows Server
6 6 (0.51%) AIX
6 6 (0.51%) Oracle Linux
6 6 (0.51%) Red Hat Enterprise Linux
7 4 (0.34%) Ubuntu
8 3 (0.26%) Solaris
9 2 (0.17%) Android
9 2 (0.17%) Debian
10 1 (0.085%) Apple iOS
10 1 (0.085%) CentOS
10 1 (0.085%) VME
Processes & Methodologies
1 600 (51.19%) Business Intelligence
2 480 (40.96%) ETL
3 341 (29.10%) Agile Software Development
4 289 (24.66%) Data Modelling
5 247 (21.08%) Analytics
6 185 (15.78%) DevOps
7 137 (11.69%) Migration
8 129 (11.01%) Kimball Methodology
9 103 (8.79%) Visualisation
10 96 (8.19%) Scrum
11 93 (7.94%) Data Architecture
12 88 (7.51%) Data Analysis
13 86 (7.34%) Data Engineering
14 80 (6.83%) Data Analytics
15 78 (6.66%) Stakeholder Management
16 74 (6.31%) Requirements Gathering
17 71 (6.06%) Data Visualisation
18 70 (5.97%) Machine Learning
19 66 (5.63%) Data Integration
19 66 (5.63%) Mentoring
Programming Languages
1 704 (60.07%) SQL
2 205 (17.49%) Python
3 173 (14.76%) T-SQL
4 108 (9.22%) Java
5 96 (8.19%) C#
6 93 (7.94%) PL/SQL
7 71 (6.06%) PowerShell
8 40 (3.41%) Scala
9 39 (3.33%) JavaScript
10 31 (2.65%) R
11 30 (2.56%) Data Analysis Expressions (DAX)
11 30 (2.56%) Shell Script
12 25 (2.13%) VB
13 19 (1.62%) Perl
13 19 (1.62%) VBA
14 16 (1.37%) VB.NET
15 14 (1.19%) Go
16 10 (0.85%) SAS Macro
17 9 (0.77%) Ruby
18 8 (0.68%) PHP
Qualifications
1 98 (8.36%) Security Cleared
2 81 (6.91%) SC Cleared
3 45 (3.84%) Degree
4 11 (0.94%) AWS Certification
5 9 (0.77%) Computer Science Degree
6 8 (0.68%) Microsoft Certification
6 8 (0.68%) Sun Certification
7 7 (0.60%) DV Cleared
8 6 (0.51%) CESG Certified Professional
8 6 (0.51%) CISM
8 6 (0.51%) CISSP
8 6 (0.51%) CRISC
9 5 (0.43%) PMI Certification
10 4 (0.34%) BPSS Clearance
10 4 (0.34%) Master's Degree
10 4 (0.34%) PMP
11 3 (0.26%) Postgraduate
11 3 (0.26%) PRINCE2 Certification
11 3 (0.26%) PRINCE2 Practitioner
11 3 (0.26%) TOGAF Certification
Quality Assurance & Compliance
1 63 (5.38%) Data Quality
2 54 (4.61%) QA
3 29 (2.47%) GDPR
4 9 (0.77%) Solvency II
5 8 (0.68%) PMO
6 6 (0.51%) SLA
7 5 (0.43%) IFRS
8 2 (0.17%) RMADS
9 1 (0.085%) COBIT
9 1 (0.085%) Government Security Classifications
9 1 (0.085%) NCSC
System Software
1 22 (1.88%) Docker
2 15 (1.28%) Apache Flume
3 12 (1.02%) HDFS
4 10 (0.85%) Virtual Machines
5 5 (0.43%) Active Directory
6 4 (0.34%) Oracle Clusterware
6 4 (0.34%) Oracle RAC
7 2 (0.17%) VMware Infrastructure
8 1 (0.085%) Apache ZooKeeper
8 1 (0.085%) GridGain
8 1 (0.085%) iptables
8 1 (0.085%) KVM
8 1 (0.085%) Virtual Desktop
8 1 (0.085%) VMware ESXi
Systems Management
1 35 (2.99%) Terraform
2 33 (2.82%) Kubernetes
3 21 (1.79%) Ansible
4 6 (0.51%) Oracle RMAN
5 5 (0.43%) Control-M
5 5 (0.43%) Data Guard
5 5 (0.43%) Oozie
5 5 (0.43%) Opscode Chef
6 3 (0.26%) HP ALM
7 2 (0.17%) Oracle Enterprise Manager
8 1 (0.085%) Ambari
8 1 (0.085%) Hadoop YARN
8 1 (0.085%) Kibana
8 1 (0.085%) MIIS
8 1 (0.085%) Puppet
8 1 (0.085%) Single Sign-On
8 1 (0.085%) Tivoli
8 1 (0.085%) yum
8 1 (0.085%) ZABBIX
Vendors
1 286 (24.40%) Microsoft
2 219 (18.69%) Oracle
3 104 (8.87%) Tableau
4 80 (6.83%) Databricks
5 63 (5.38%) SAP
6 55 (4.69%) Informatica
7 54 (4.61%) Google
8 26 (2.22%) Cloudera
8 26 (2.22%) Talend
9 20 (1.71%) Salesforce.com
10 18 (1.54%) MicroStrategy
11 17 (1.45%) Cognos
12 16 (1.37%) IBM
13 11 (0.94%) Alteryx
13 11 (0.94%) MapR
13 11 (0.94%) Red Hat
14 10 (0.85%) Hortonworks
15 9 (0.77%) Teradata
16 8 (0.68%) Sybase
17 7 (0.60%) Trillium