Period
to 26 October 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 26 October 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
26 Oct 2020
Same period 2019 Same period 2018
Rank 90 82 109
Rank change year-on-year -8 +27 -5
Contract jobs citing Data Warehouse 813 2,317 2,552
As % of all contract jobs advertised in the UK 2.53% 2.75% 2.47%
As % of the Database & Business Intelligence category 11.17% 12.59% 10.81%
Number of daily rates quoted 651 1,636 1,824
Median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% -
10th Percentile £313 £325 £325
90th Percentile £663 £650 £601
UK excluding London median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 0 29 16
Median hourly rate - £27.50 £22.00
Median hourly rate % change year-on-year - +25.00% -23.48%
UK excluding London median hourly rate - £19.31 £18.50
% change year-on-year - +4.38% -52.26%

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 7,276 18,403 23,616
As % of all contract IT jobs advertised in the UK 22.62% 21.82% 22.82%
Number of daily rates quoted 4,640 12,536 16,480
Median daily rate £481 £475 £475
Median daily rate % change year-on-year +1.21% - +5.56%
10th Percentile £313 £320 £313
90th Percentile £665 £656 £638
UK excluding London median daily rate £435 £438 £425
% change year-on-year -0.57% +2.94% +6.25%
Number of hourly rates quoted 156 267 231
Median hourly rate £35.00 £31.00 £28.00
Median hourly rate % change year-on-year +12.90% +10.71% -6.67%
10th Percentile £14.00 £12.70 £12.46
90th Percentile £51.75 £60.00 £56.00
Median hourly rate £31.25 £30.00 £32.00
% change year-on-year +4.17% -6.25% -4.48%

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 26 October 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
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 26 October 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 -8 733 £500 +5.26% 244
London -3 452 £525 +5.00% 108
UK excluding London -20 286 £450 - 164
Work from Home +32 184 £475 - 44
North of England +5 86 £400 -5.88% 56
South East +14 80 £500 +11.11% 24
North West +19 61 £400 -5.88% 37
Midlands -16 35 £310 -24.85% 32
East of England +11 28 £400 -15.79% 13
South West +3 28 £463 +3.93% 10
West Midlands -19 25 £288 -34.29% 25
Scotland +49 22 £308 -15.03% 15
Yorkshire +11 20 £344 -19.12% 13
East Midlands +4 10 £365 +4.14% 7
North East +31 7 £440 -4.86% 6
Wales +24 6 £375 +7.14% 4
Northern Ireland +9 2 - - 10

For the 6 months to 26 October 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 442 (54.37%) SQL
2 386 (47.48%) Business Intelligence
3 301 (37.02%) Azure
4 274 (33.70%) ETL
5 232 (28.54%) Data Modelling
6 229 (28.17%) SQL Server
7 220 (27.06%) Agile Software Development
8 209 (25.71%) Power Platform
9 208 (25.58%) Power BI
10 193 (23.74%) Finance
11 191 (23.49%) Microsoft
12 175 (21.53%) Python
13 167 (20.54%) Data Lake
14 157 (19.31%) DevOps
15 151 (18.57%) Analytics
16 134 (16.48%) SQL Server Integration Services
17 127 (15.62%) AWS
18 120 (14.76%) Oracle
19 105 (12.92%) Java
20 101 (12.42%) Migration
21 95 (11.69%) Analytical Skills
22 90 (11.07%) Banking
23 89 (10.95%) SQL Server Reporting Services
24 88 (10.82%) Azure Data Factory
25 85 (10.46%) T-SQL
25 85 (10.46%) GCP
26 82 (10.09%) Big Data
27 78 (9.59%) Azure SQL Data Warehouse
28 77 (9.47%) SQL Server Analysis Services
29 75 (9.23%) Google

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 52 (6.40%) Apache
2 34 (4.18%) Apache Spark
3 19 (2.34%) SharePoint
4 15 (1.85%) Confluence
5 12 (1.48%) SAS
6 10 (1.23%) Apache Airflow
7 5 (0.62%) Elasticsearch
8 4 (0.49%) Apache Pig
8 4 (0.49%) Oracle Workflow
9 3 (0.37%) Tomcat
9 3 (0.37%) WebSphere
10 2 (0.25%) Apache Synapse
10 2 (0.25%) IIS
11 1 (0.12%) CMS
11 1 (0.12%) MQSeries
11 1 (0.12%) Oracle SOA Suite
11 1 (0.12%) Skype for Business
Applications
1 32 (3.94%) Microsoft Excel
2 11 (1.35%) Microsoft Office
3 9 (1.11%) MS Visio
4 7 (0.86%) Microsoft PowerPoint
5 6 (0.74%) SPSS
6 1 (0.12%) Microsoft Project
6 1 (0.12%) Stata
Business Applications
1 8 (0.98%) Sparx Enterprise Architect
2 6 (0.74%) Dynamics CRM
3 4 (0.49%) Primavera
3 4 (0.49%) SAP Oil and Gas
3 4 (0.49%) SAP S/4HANA
4 3 (0.37%) Endur
4 3 (0.37%) NetSuite
4 3 (0.37%) Oracle EBS
4 3 (0.37%) thinkFolio
5 2 (0.25%) Markit EDM
5 2 (0.25%) OPENHousing
5 2 (0.25%) SAP BPC
5 2 (0.25%) SimCorp Dimension
5 2 (0.25%) Unit4 Business World
6 1 (0.12%) Bloomberg AIM
6 1 (0.12%) HiPortfolio
6 1 (0.12%) Infor SunSystems
6 1 (0.12%) Salesforce.com CRM
6 1 (0.12%) SAP FI
6 1 (0.12%) SAP MM
Cloud Services
1 301 (37.02%) Azure
2 209 (25.71%) Power Platform
3 127 (15.62%) AWS
4 88 (10.82%) Azure Data Factory
5 85 (10.46%) GCP
6 66 (8.12%) Serverless
7 56 (6.89%) AWS Lambda
8 42 (5.17%) Amazon ECS
9 25 (3.08%) Apigee
10 22 (2.71%) Amazon S3
11 16 (1.97%) Logic Apps
12 14 (1.72%) Dynamics 365
13 13 (1.60%) Azure Active Directory
14 12 (1.48%) PaaS
14 12 (1.48%) PowerApps
15 11 (1.35%) GitHub
16 10 (1.23%) Amazon EC2
16 10 (1.23%) AWS Fargate
17 8 (0.98%) Azure Functions
17 8 (0.98%) SaaS
Communications & Networking
1 11 (1.35%) Kerberos
2 8 (0.98%) SSL
3 5 (0.62%) Firewall
3 5 (0.62%) SSH
4 4 (0.49%) DNS
4 4 (0.49%) Internet
5 3 (0.37%) HTTP
5 3 (0.37%) LAN
6 2 (0.25%) TCP/IP
6 2 (0.25%) VPN
6 2 (0.25%) WAN
6 2 (0.25%) Wi-Fi
7 1 (0.12%) 3G
7 1 (0.12%) 4G
7 1 (0.12%) 5G
7 1 (0.12%) Network Security
7 1 (0.12%) Skype
7 1 (0.12%) VLAN
Database & Business Intelligence
1 229 (28.17%) SQL Server
2 208 (25.58%) Power BI
3 167 (20.54%) Data Lake
4 134 (16.48%) SQL Server Integration Services
5 89 (10.95%) SQL Server Reporting Services
6 82 (10.09%) Big Data
7 78 (9.59%) Azure SQL Data Warehouse
8 77 (9.47%) SQL Server Analysis Services
9 75 (9.23%) Relational Database
10 72 (8.86%) Azure SQL Database
10 72 (8.86%) MySQL
11 69 (8.49%) Amazon Redshift
12 61 (7.50%) Tableau
13 49 (6.03%) PostgreSQL
14 43 (5.29%) NoSQL
14 43 (5.29%) Oracle Database
15 39 (4.80%) Snowflake Schema
16 30 (3.69%) Hadoop
17 27 (3.32%) Microsoft Analysis Services
18 26 (3.20%) Enterprise Data Warehouse
Development Applications
1 46 (5.66%) Jenkins
2 35 (4.31%) GitLab
3 28 (3.44%) Git (software)
3 28 (3.44%) JIRA
4 25 (3.08%) Artifactory
5 13 (1.60%) Selenium
6 12 (1.48%) Maven
6 12 (1.48%) SQL Server Management Studio (SSMS)
7 10 (1.23%) Visual Studio Team System
8 8 (0.98%) ERwin
9 7 (0.86%) NUnit
9 7 (0.86%) ProC
9 7 (0.86%) Visual Studio
10 6 (0.74%) CircleCI
11 5 (0.62%) Cypress.io
11 5 (0.62%) JUnit
11 5 (0.62%) Postman
11 5 (0.62%) PowerBuilder
11 5 (0.62%) Team Foundation Server
12 4 (0.49%) kappa
General
1 193 (23.74%) Finance
2 90 (11.07%) Banking
3 47 (5.78%) Back Office
4 40 (4.92%) Public Sector
5 31 (3.81%) Marketing
6 22 (2.71%) Investment Banking
7 21 (2.58%) Retail
8 15 (1.85%) Pharmaceutical
9 13 (1.60%) Advertising
10 12 (1.48%) Law
11 10 (1.23%) Front Office
11 10 (1.23%) Telecoms
12 9 (1.11%) Manufacturing
13 5 (0.62%) Electronics
13 5 (0.62%) Legal
13 5 (0.62%) Publishing
14 4 (0.49%) Local Government
15 3 (0.37%) Housing Association
15 3 (0.37%) Retail Banking
16 2 (0.25%) General Ledger
Job Titles
1 235 (28.91%) Developer
2 163 (20.05%) Architect
3 114 (14.02%) Data Architect
3 114 (14.02%) Data Engineer
4 98 (12.05%) Analyst
5 79 (9.72%) Business Intelligence Developer
6 62 (7.63%) Solutions Architect
7 44 (5.41%) Business Analyst
8 42 (5.17%) SQL Developer
9 34 (4.18%) Data Warehouse Developer
10 32 (3.94%) Azure Architect
10 32 (3.94%) Cloud Architect
10 32 (3.94%) Consultant
10 32 (3.94%) Power BI Developer
11 29 (3.57%) Azure Engineer
11 29 (3.57%) DBA
12 27 (3.32%) Senior Developer
13 26 (3.20%) AWS Architect
13 26 (3.20%) Cloud Solutions Architect
13 26 (3.20%) Java Solutions Architect
Libraries, Frameworks & Software Standards
1 62 (7.63%) .NET
2 55 (6.77%) Web Services
3 48 (5.90%) Kafka
4 36 (4.43%) gRPC
5 35 (4.31%) XML
6 32 (3.94%) REST
7 28 (3.44%) OAuth
8 27 (3.32%) JSON
9 25 (3.08%) Swagger
10 22 (2.71%) PySpark
11 11 (1.35%) .NET Framework
11 11 (1.35%) SOAP
12 10 (1.23%) ASP.NET
12 10 (1.23%) CSS
12 10 (1.23%) HTML
12 10 (1.23%) RESTful
13 9 (1.11%) MDX
14 8 (0.98%) Middleware
14 8 (0.98%) Spring
15 7 (0.86%) Apache Beam
Miscellaneous
1 95 (11.69%) Analytical Skills
2 40 (4.92%) Hedge funds
3 37 (4.55%) Data Structures
4 36 (4.43%) Greenfield Project
4 36 (4.43%) NHS
5 35 (4.31%) Management Information System
6 18 (2.21%) User Experience
7 10 (1.23%) Cloud Native
7 10 (1.23%) FMCG
8 9 (1.11%) Self-Motivation
9 8 (0.98%) Algorithms
10 5 (0.62%) Data Centre
10 5 (0.62%) Enterprise Software
10 5 (0.62%) Life Science
10 5 (0.62%) Reference Data
11 4 (0.49%) Credit Risk
11 4 (0.49%) Public Cloud
11 4 (0.49%) SWIFT
12 3 (0.37%) Mobile App
12 3 (0.37%) Mobile Banking
Operating Systems
1 38 (4.67%) Linux
2 37 (4.55%) Windows
3 23 (2.83%) Unix
4 8 (0.98%) Red Hat Enterprise Linux
5 5 (0.62%) AIX
5 5 (0.62%) Windows Server
6 4 (0.49%) Debian
6 4 (0.49%) Ubuntu
6 4 (0.49%) Windows Server 2016
7 3 (0.37%) Windows Server 2019
7 3 (0.37%) zOS
8 2 (0.25%) VMS
9 1 (0.12%) Android
9 1 (0.12%) Apple iOS
9 1 (0.12%) Windows Server 2008
9 1 (0.12%) Windows Vista
Processes & Methodologies
1 386 (47.48%) Business Intelligence
2 274 (33.70%) ETL
3 232 (28.54%) Data Modelling
4 220 (27.06%) Agile Software Development
5 157 (19.31%) DevOps
6 151 (18.57%) Analytics
7 101 (12.42%) Migration
8 75 (9.23%) Microservices
9 73 (8.98%) Data Architecture
10 71 (8.73%) Scrum
10 71 (8.73%) Visualisation
11 67 (8.24%) Data Analysis
12 66 (8.12%) Mentoring
13 64 (7.87%) Data Migration
14 62 (7.63%) Performance Tuning
15 57 (7.01%) Kimball Methodology
16 56 (6.89%) Data Engineering
16 56 (6.89%) Problem-Solving
17 52 (6.40%) Stakeholder Management
18 51 (6.27%) Dimensional Modelling
Programming Languages
1 442 (54.37%) SQL
2 175 (21.53%) Python
3 105 (12.92%) Java
4 85 (10.46%) T-SQL
5 48 (5.90%) C#
6 40 (4.92%) PL/SQL
7 35 (4.31%) PowerShell
8 29 (3.57%) JavaScript
9 26 (3.20%) Data Analysis Expressions (DAX)
10 18 (2.21%) R
10 18 (2.21%) Shell Script
11 14 (1.72%) Scala
12 12 (1.48%) Bash Shell
13 11 (1.35%) C
13 11 (1.35%) VBA
14 8 (0.98%) C++
15 7 (0.86%) PHP
16 6 (0.74%) Go
16 6 (0.74%) VB
17 5 (0.62%) Perl
Qualifications
1 40 (4.92%) Security Cleared
2 28 (3.44%) Degree
3 25 (3.08%) Sun Certification
4 24 (2.95%) SC Cleared
5 10 (1.23%) AWS Certification
6 8 (0.98%) TOGAF Certification
7 7 (0.86%) Computer Science Degree
7 7 (0.86%) DV Cleared
8 4 (0.49%) CTC Cleared
8 4 (0.49%) ITIL Certification
9 3 (0.37%) ISTQB
10 2 (0.25%) BPSS Clearance
10 2 (0.25%) ISEB
10 2 (0.25%) ISTQB Foundation Certification
10 2 (0.25%) ITIL Foundation Certificate
10 2 (0.25%) PRINCE2 Practitioner
11 1 (0.12%) ACCA
11 1 (0.12%) CFA
11 1 (0.12%) CIMA
11 1 (0.12%) Microsoft Certification
Quality Assurance & Compliance
1 67 (8.24%) Data Quality
2 66 (8.12%) QA
3 11 (1.35%) GDPR
4 4 (0.49%) IFRS
5 3 (0.37%) PMO
5 3 (0.37%) SLA
6 2 (0.25%) ISO/IEC 20000
6 2 (0.25%) SNOMED CT
7 1 (0.12%) MiFID
7 1 (0.12%) Sarbanes-Oxley
7 1 (0.12%) Solvency II
System Software
1 39 (4.80%) Docker
2 14 (1.72%) Active Directory
3 11 (1.35%) Oracle RAC
4 10 (1.23%) Oracle Clusterware
5 4 (0.49%) Virtual Machines
6 3 (0.37%) GridGain
6 3 (0.37%) HDFS
6 3 (0.37%) VMware Infrastructure
7 2 (0.25%) Apache Flume
7 2 (0.25%) Apache ZooKeeper
8 1 (0.12%) Hyper-V
Systems Management
1 51 (6.27%) Kubernetes
2 11 (1.35%) Terraform
3 10 (1.23%) Data Guard
3 10 (1.23%) Oracle RMAN
4 6 (0.74%) Opscode Chef
5 5 (0.62%) Oozie
6 4 (0.49%) Ansible
7 3 (0.37%) Control-M
7 3 (0.37%) HP ALM
8 2 (0.25%) Puppet
9 1 (0.12%) Enterprise Manager Cloud Control
9 1 (0.12%) Foglight
9 1 (0.12%) Hadoop YARN
9 1 (0.12%) HP Quality Center
9 1 (0.12%) Istio
9 1 (0.12%) Single Sign-On
Vendors
1 191 (23.49%) Microsoft
2 120 (14.76%) Oracle
3 75 (9.23%) Google
4 72 (8.86%) Databricks
5 44 (5.41%) SAP
6 33 (4.06%) Informatica
7 22 (2.71%) IBM
8 12 (1.48%) Cloudera
8 12 (1.48%) Salesforce.com
8 12 (1.48%) Talend
9 11 (1.35%) Teradata
10 10 (1.23%) Cognos
11 9 (1.11%) MicroStrategy
12 8 (0.98%) Sparx
12 8 (0.98%) Sybase
13 7 (0.86%) MuleSoft
13 7 (0.86%) Red Hat
14 5 (0.62%) Splunk
14 5 (0.62%) TIBCO
15 4 (0.49%) HP