Period
to 25 July 2021

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 25 July 2021 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
25 Jul 2021
Same period 2020 Same period 2019
Rank 79 88 89
Rank change year-on-year +9 +1 +12
Contract jobs citing Data Warehouse 2,084 973 2,515
As % of all contract jobs advertised in the UK 2.94% 2.59% 2.74%
As % of the Database & Business Intelligence category 13.83% 11.75% 12.09%
Number of daily rates quoted 1,426 696 1,769
10th Percentile £331 £322 £325
25th Percentile £414 £392 £400
Median daily rate (50th Percentile) £500 £475 £475
Median % change year-on-year +5.26% - +5.56%
75th Percentile £600 £588 £563
90th Percentile £675 £676 £638
UK excluding London median daily rate £475 £450 £450
% change year-on-year +5.56% - +5.88%
Number of hourly rates quoted 29 5 15
10th Percentile £8.00 £38.55 £14.11
25th Percentile £19.50 £57.00 £17.13
Median hourly rate £27.00 £67.50 £22.83
Median % change year-on-year -60.00% +195.66% +2.61%
75th Percentile £38.75 £68.75 £45.66
90th Percentile £50.00 £70.25 £73.75
UK excluding London median hourly rate £23.95 £67.50 £19.31
% change year-on-year -64.53% +249.56% +75.55%

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 15,072 8,278 20,804
As % of all contract IT jobs advertised in the UK 21.30% 22.06% 22.65%
Number of daily rates quoted 10,344 5,730 14,380
10th Percentile £338 £325 £325
25th Percentile £413 £406 £400
Median daily rate (50th Percentile) £500 £500 £475
Median % change year-on-year - +5.26% +2.70%
75th Percentile £611 £600 £575
90th Percentile £700 £688 £650
UK excluding London median daily rate £450 £450 £433
% change year-on-year - +3.93% +4.40%
Number of hourly rates quoted 217 114 257
10th Percentile £11.71 £12.63 £13.45
25th Percentile £19.00 £17.77 £17.63
Median hourly rate £27.00 £22.50 £30.00
Median % change year-on-year +20.00% -25.00% -
75th Percentile £45.18 £43.12 £50.00
90th Percentile £62.00 £63.79 £60.00
UK excluding London median hourly rate £26.00 £21.57 £30.00
% change year-on-year +20.54% -28.10% +4.35%

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 25 July 2021.

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 25 July 2021.

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 25 July 2021. 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,695 £513 +5.94% 474
London +1 989 £540 +8.00% 220
UK excluding London +14 656 £475 +5.56% 269
Work from Home +10 653 £500 - 79
South East -10 166 £525 - 47
North of England +11 150 £475 +18.75% 69
Midlands 0 116 £430 +7.50% 71
South West +36 95 £500 +11.11% 25
West Midlands -3 83 £450 +5.88% 52
North West -4 83 £463 +33.09% 44
Scotland -12 66 £463 +12.12% 21
Yorkshire +8 60 £475 +11.76% 14
East of England -18 46 £369 -15.71% 36
East Midlands +4 33 £425 +37.10% 19
Wales -5 17 £425 +13.33%
North East -2 7 £500 -4.76% 11
Isle of Man - 1 £750 -

For the 6 months to 25 July 2021, 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,165 (55.90%) SQL
2 952 (45.68%) Business Intelligence
3 769 (36.90%) Azure
4 736 (35.32%) ETL
5 726 (34.84%) Data Modelling
6 616 (29.56%) Analytics
7 603 (28.93%) Agile Software Development
8 500 (23.99%) Power Platform
9 492 (23.61%) Power BI
10 466 (22.36%) Finance
11 463 (22.22%) Social Skills
12 462 (22.17%) Python
13 426 (20.44%) SQL Server
14 408 (19.58%) Microsoft
15 390 (18.71%) Data Lake
16 340 (16.31%) Big Data
17 336 (16.12%) SQL Server Integration Services
18 331 (15.88%) AWS
19 327 (15.69%) DevOps
20 324 (15.55%) Oracle
21 319 (15.31%) Migration
22 270 (12.96%) Azure Data Factory
23 269 (12.91%) Databricks
24 250 (12.00%) Analytical Skills
25 231 (11.08%) Data Pipeline
26 227 (10.89%) SQL Server Reporting Services
27 220 (10.56%) Scrum
28 219 (10.51%) Data Architecture
29 216 (10.36%) Visualisation
29 216 (10.36%) Data Engineering

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 170 (8.16%) Apache Spark
2 68 (3.26%) SAS
3 66 (3.17%) Apache Airflow
4 56 (2.69%) Apache
5 44 (2.11%) SharePoint
6 25 (1.20%) Jupyter
7 24 (1.15%) Confluence
8 19 (0.91%) Elasticsearch
9 13 (0.62%) IIS
10 12 (0.58%) Apache Pig
11 10 (0.48%) Tomcat
11 10 (0.48%) WebLogic
12 7 (0.34%) Luigi
13 6 (0.29%) Oracle SOA Suite
13 6 (0.29%) Oracle Workflow
14 5 (0.24%) Mule
15 2 (0.096%) CMS
15 2 (0.096%) OpenStack
15 2 (0.096%) Oracle Coherence
16 1 (0.048%) Oracle Application Server
Applications
1 113 (5.42%) Microsoft Excel
2 27 (1.30%) Microsoft PowerPoint
3 22 (1.06%) Microsoft Office
4 7 (0.34%) MS Visio
5 6 (0.29%) Microsoft Project
5 6 (0.29%) SPSS
6 5 (0.24%) Spreadsheet
7 2 (0.096%) Oracle Smart View
8 1 (0.048%) InfoPath
Business Applications
1 31 (1.49%) Oracle EBS
2 17 (0.82%) SAP S/4HANA
3 9 (0.43%) Dynamics CRM
4 8 (0.38%) HFM
4 8 (0.38%) Markit EDM
5 5 (0.24%) Sparx Enterprise Architect
6 4 (0.19%) Cognos Business Intelligence
6 4 (0.19%) SAP IS-U
6 4 (0.19%) UltiPro
6 4 (0.19%) Unit4 Business World
7 3 (0.14%) Adobe Campaign
7 3 (0.14%) Cerner Millennium
7 3 (0.14%) Lorenzo
7 3 (0.14%) NetSuite
7 3 (0.14%) Salesforce.com CRM
7 3 (0.14%) SAP MDG
7 3 (0.14%) thinkFolio
8 2 (0.096%) Eagle PACE
8 2 (0.096%) Oracle EBS R12
8 2 (0.096%) Oracle General Ledger
Cloud Services
1 769 (36.90%) Azure
2 500 (23.99%) Power Platform
3 331 (15.88%) AWS
4 270 (12.96%) Azure Data Factory
5 177 (8.49%) GCP
6 138 (6.62%) Azure Synapse Analytics
7 133 (6.38%) Snowflake
8 126 (6.05%) Serverless
9 80 (3.84%) Amazon S3
10 57 (2.74%) AWS Lambda
11 55 (2.64%) Azure Cosmos DB
12 54 (2.59%) Azure Functions
13 50 (2.40%) Azure Storage
14 41 (1.97%) PaaS
15 37 (1.78%) Dynamics 365
16 29 (1.39%) Azure Logic Apps
17 28 (1.34%) GitHub
18 27 (1.30%) Amazon EMR
19 25 (1.20%) Amazon EC2
20 23 (1.10%) IaaS
Communications & Networking
1 26 (1.25%) HTTP
2 16 (0.77%) FTP
2 16 (0.77%) WAN
3 15 (0.72%) LAN
4 14 (0.67%) PBX
4 14 (0.67%) VoIP
5 13 (0.62%) RTP
6 11 (0.53%) DNS
6 11 (0.53%) SMTP
7 9 (0.43%) Firewall
8 8 (0.38%) Kerberos
9 7 (0.34%) MQTT
10 5 (0.24%) Internet
11 4 (0.19%) Network Security
11 4 (0.19%) SSH
11 4 (0.19%) SSL
11 4 (0.19%) VPN
11 4 (0.19%) Wi-Fi
12 3 (0.14%) Cisco Firepower
13 2 (0.096%) Unified Communications
Database & Business Intelligence
1 492 (23.61%) Power BI
2 426 (20.44%) SQL Server
3 390 (18.71%) Data Lake
4 340 (16.31%) Big Data
5 336 (16.12%) SQL Server Integration Services
6 227 (10.89%) SQL Server Reporting Services
7 202 (9.69%) SQL Server Analysis Services
8 177 (8.49%) Azure SQL Data Warehouse
8 177 (8.49%) Relational Database
9 166 (7.97%) Tableau
10 146 (7.01%) Hadoop
11 139 (6.67%) Azure SQL Database
12 124 (5.95%) Amazon Redshift
13 116 (5.57%) BigQuery
14 105 (5.04%) NoSQL
14 105 (5.04%) PostgreSQL
15 95 (4.56%) Metadata
16 87 (4.17%) Oracle Database
17 80 (3.84%) Enterprise Data Warehouse
18 71 (3.41%) Star Schema
Development Applications
1 104 (4.99%) JIRA
2 96 (4.61%) Git (software)
3 44 (2.11%) Jenkins
4 35 (1.68%) Visual Studio
5 31 (1.49%) ERwin
6 27 (1.30%) Bitbucket
7 23 (1.10%) PowerDesigner
8 22 (1.06%) ER Studio
8 22 (1.06%) kappa
8 22 (1.06%) SQL Server Management Studio (SSMS)
8 22 (1.06%) Team Foundation Server
9 18 (0.86%) Cucumber
10 17 (0.82%) Maven
11 16 (0.77%) Subversion
12 14 (0.67%) LoadRunner
12 14 (0.67%) SpecFlow
13 13 (0.62%) GitLab
14 12 (0.58%) Eclipse
14 12 (0.58%) Oracle APEX
14 12 (0.58%) Selenium
General
1 466 (22.36%) Finance
2 463 (22.22%) Social Skills
3 250 (12.00%) Analytical Skills
4 146 (7.01%) Banking
5 127 (6.09%) Public Sector
6 62 (2.98%) Retail
7 59 (2.83%) Presentation Skills
8 57 (2.74%) Investment Banking
9 55 (2.64%) Marketing
10 35 (1.68%) Front Office
10 35 (1.68%) Telecoms
11 26 (1.25%) Documentation Skills
12 22 (1.06%) Back Office
12 22 (1.06%) Organisational Skills
13 20 (0.96%) Influencing Skills
14 16 (0.77%) Manufacturing
15 15 (0.72%) Publishing
16 14 (0.67%) Pharmaceutical
17 12 (0.58%) Legal
18 11 (0.53%) Retail Banking
Job Titles
1 447 (21.45%) Developer
2 399 (19.15%) Data Engineer
3 337 (16.17%) Architect
4 302 (14.49%) Analyst
5 225 (10.80%) Data Architect
6 163 (7.82%) Business Intelligence Developer
7 135 (6.48%) Data Analyst
8 134 (6.43%) Azure Engineer
9 113 (5.42%) Consultant
10 103 (4.94%) SQL Developer
11 90 (4.32%) Solutions Architect
12 83 (3.98%) Business Analyst
13 77 (3.69%) Project Manager
14 65 (3.12%) Data Warehouse Developer
15 62 (2.98%) Azure Architect
16 56 (2.69%) Power BI Developer
17 54 (2.59%) Business Intelligence Analyst
18 51 (2.45%) Data Modeller
19 45 (2.16%) AWS Engineer
19 45 (2.16%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 108 (5.18%) Kafka
2 82 (3.93%) .NET
2 82 (3.93%) XML
3 60 (2.88%) JSON
4 52 (2.50%) PySpark
4 52 (2.50%) REST
5 43 (2.06%) SOAP
6 38 (1.82%) Web Services
7 36 (1.73%) Node.js
8 31 (1.49%) .NET Framework
9 30 (1.44%) HTML
10 29 (1.39%) Spring
11 28 (1.34%) RESTful
12 23 (1.10%) Spark Streaming
13 22 (1.06%) Oracle GoldenGate
14 21 (1.01%) MDX
15 20 (0.96%) ASP.NET
16 19 (0.91%) AngularJS
17 17 (0.82%) Apache Avro
17 17 (0.82%) D3.js
Miscellaneous
1 96 (4.61%) Management Information System
2 75 (3.60%) Data Structures
3 68 (3.26%) NHS
4 43 (2.06%) Algorithms
5 37 (1.78%) Greenfield Project
6 36 (1.73%) Legacy Systems
7 31 (1.49%) Self-Motivation
8 30 (1.44%) Credit Risk
9 27 (1.30%) Cloud Native
9 27 (1.30%) Enterprise Software
10 26 (1.25%) Virtual Team
11 23 (1.10%) Legacy Applications
12 21 (1.01%) Social Media
13 19 (0.91%) Replication
14 18 (0.86%) Public Cloud
14 18 (0.86%) Reference Data
15 17 (0.82%) Data Protection Act
16 15 (0.72%) Mobile App
16 15 (0.72%) User Experience
17 14 (0.67%) Data Centre
Operating Systems
1 76 (3.65%) Unix
2 60 (2.88%) Linux
3 49 (2.35%) Windows
4 10 (0.48%) Red Hat Enterprise Linux
5 6 (0.29%) Apple iOS
5 6 (0.29%) Debian
5 6 (0.29%) Ubuntu
6 4 (0.19%) Android
6 4 (0.19%) VMS
7 3 (0.14%) AIX
7 3 (0.14%) Windows Server 2012
8 2 (0.096%) Oracle Linux
8 2 (0.096%) Windows Server
9 1 (0.048%) HPUX
9 1 (0.048%) Solaris
9 1 (0.048%) Windows 10
9 1 (0.048%) Windows 7
9 1 (0.048%) Windows Server 2003
9 1 (0.048%) Windows Server 2008
9 1 (0.048%) Windows XP
Processes & Methodologies
1 952 (45.68%) Business Intelligence
2 736 (35.32%) ETL
3 726 (34.84%) Data Modelling
4 616 (29.56%) Analytics
5 603 (28.93%) Agile Software Development
6 327 (15.69%) DevOps
7 319 (15.31%) Migration
8 231 (11.08%) Data Pipeline
9 220 (10.56%) Scrum
10 219 (10.51%) Data Architecture
11 216 (10.36%) Data Engineering
11 216 (10.36%) Visualisation
12 209 (10.03%) Data Management
13 196 (9.40%) Data Integration
14 187 (8.97%) Problem-Solving
15 186 (8.93%) Data Analysis
16 169 (8.11%) Stakeholder Management
17 163 (7.82%) Data Migration
18 161 (7.73%) Data Governance
19 147 (7.05%) Data Analytics
Programming Languages
1 1,165 (55.90%) SQL
2 462 (22.17%) Python
3 208 (9.98%) T-SQL
4 201 (9.64%) Java
5 99 (4.75%) PL/SQL
6 95 (4.56%) Scala
7 84 (4.03%) C#
8 78 (3.74%) Data Analysis Expressions (DAX)
9 61 (2.93%) PowerShell
10 59 (2.83%) R
11 42 (2.02%) VBA
12 40 (1.92%) JavaScript
13 38 (1.82%) Shell Script
14 25 (1.20%) Bash Shell
15 21 (1.01%) Perl
16 18 (0.86%) VB
17 15 (0.72%) PHP
18 14 (0.67%) C
18 14 (0.67%) Go
18 14 (0.67%) Java 8
Qualifications
1 150 (7.20%) Security Cleared
2 121 (5.81%) SC Cleared
3 112 (5.37%) Degree
4 38 (1.82%) Computer Science Degree
5 16 (0.77%) ISEB
6 15 (0.72%) DV Cleared
7 14 (0.67%) PMP
8 13 (0.62%) Microsoft Certification
9 12 (0.58%) PMI Certification
9 12 (0.58%) TOGAF Certification
10 10 (0.48%) AWS Certification
11 8 (0.38%) ISTQB
11 8 (0.38%) ITIL Certification
12 7 (0.34%) Master's Degree
13 6 (0.29%) BPSS Clearance
13 6 (0.29%) CISSP
13 6 (0.29%) SAS Certification
14 4 (0.19%) CISM
15 3 (0.14%) BC Cleared
15 3 (0.14%) CISA
Quality Assurance & Compliance
1 172 (8.25%) Data Quality
2 68 (3.26%) QA
3 40 (1.92%) GDPR
4 13 (0.62%) PMO
5 6 (0.29%) Solvency II
6 5 (0.24%) SLA
7 4 (0.19%) Accessibility
7 4 (0.19%) NCSC
7 4 (0.19%) Sarbanes-Oxley
8 3 (0.14%) GRC
8 3 (0.14%) IFRS
9 2 (0.096%) COBIT
9 2 (0.096%) Cyber Essentials
9 2 (0.096%) HL7
9 2 (0.096%) PCI DSS
9 2 (0.096%) PSD2
10 1 (0.048%) Actionable Recommendations
10 1 (0.048%) GAAP
10 1 (0.048%) ISO/IEC 27001
10 1 (0.048%) NIST
System Software
1 54 (2.59%) Docker
2 53 (2.54%) Active Directory
3 26 (1.25%) HDFS
4 8 (0.38%) Oracle RAC
5 4 (0.19%) Oracle Clusterware
6 3 (0.14%) Virtual Machines
7 1 (0.048%) Apache Flume
7 1 (0.048%) Apache ZooKeeper
7 1 (0.048%) Tivoli Workload Scheduler
7 1 (0.048%) Virtual Desktop
7 1 (0.048%) VMware Infrastructure
Systems Management
1 83 (3.98%) Kubernetes
2 52 (2.50%) Terraform
3 27 (1.30%) Ansible
4 15 (0.72%) Control-M
5 14 (0.67%) Kibana
6 13 (0.62%) Opscode Chef
6 13 (0.62%) Puppet
6 13 (0.62%) Single Sign-On
7 10 (0.48%) Oozie
8 9 (0.43%) logstash
8 9 (0.43%) Oracle RMAN
9 8 (0.38%) Data Guard
10 5 (0.24%) Docker Swarm
10 5 (0.24%) Grafana
11 3 (0.14%) Hadoop YARN
12 2 (0.096%) HP Quality Center
12 2 (0.096%) Mesos
12 2 (0.096%) Rancher
13 1 (0.048%) Microsoft Intune
13 1 (0.048%) SCOM
Vendors
1 408 (19.58%) Microsoft
2 324 (15.55%) Oracle
3 269 (12.91%) Databricks
4 146 (7.01%) Google
5 120 (5.76%) Informatica
6 119 (5.71%) SAP
7 51 (2.45%) Salesforce.com
8 42 (2.02%) Talend
9 35 (1.68%) Alteryx
10 33 (1.58%) IBM
11 32 (1.54%) Teradata
12 29 (1.39%) MuleSoft
13 22 (1.06%) BiZZdesign
14 20 (0.96%) Cloudera
15 19 (0.91%) Ab Initio
15 19 (0.91%) Cognos
16 17 (0.82%) StreamSets
17 14 (0.67%) ServiceNow
17 14 (0.67%) SolarWinds
17 14 (0.67%) Splunk