Period
to 4 August 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 4 August 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
4 Aug 2020
Same period 2019 Same period 2018
Rank 90 86 101
Rank change year-on-year -4 +15 +3
Contract jobs citing Data Warehouse 917 2,500 2,633
As % of all contract jobs advertised in the UK 2.56% 2.74% 2.54%
As % of the Database & Business Intelligence category 11.87% 12.40% 11.16%
Number of daily rates quoted 660 1,750 1,915
Median daily rate £484 £475 £450
Median daily rate % change year-on-year +1.84% +5.56% -
10th Percentile £330 £338 £325
90th Percentile £675 £644 £600
UK excluding London median daily rate £450 £450 £425
% change year-on-year - +5.88% +3.03%
Number of hourly rates quoted 7 18 15
Median hourly rate £59.00 £23.67 £26.50
Median hourly rate % change year-on-year +149.31% -10.70% -23.45%
10th Percentile £31.50 £14.20 £10.08
90th Percentile £69.75 £73.75 £105.00
UK excluding London median hourly rate £67.50 £19.31 £11.00
% change year-on-year +249.56% +75.55% -68.23%

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,728 20,155 23,588
As % of all contract IT jobs advertised in the UK 21.58% 22.11% 22.78%
Number of daily rates quoted 4,995 13,788 16,451
Median daily rate £500 £475 £463
Median daily rate % change year-on-year +5.26% +2.70% +2.78%
10th Percentile £325 £325 £313
90th Percentile £688 £650 £638
UK excluding London median daily rate £450 £435 £415
% change year-on-year +3.45% +4.82% +3.75%
Number of hourly rates quoted 163 260 242
Median hourly rate £35.00 £35.00 £32.00
Median hourly rate % change year-on-year - +9.38% +3.23%
10th Percentile £15.04 £14.07 £13.71
90th Percentile £54.80 £60.00 £54.88
Median hourly rate £35.00 £35.00 £33.50
% change year-on-year - +4.48% -1.47%

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 4 August 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 4 August 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 4 August 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 -1 866 £488 +2.63% 160
London -1 500 £510 +2.00% 61
UK excluding London -11 382 £450 - 122
South East +11 109 £533 +18.33% 11
North of England +8 89 £400 -6.98% 35
Work from Home +38 80 £500 +5.26% 26
Midlands -3 67 £400 -11.11% 30
North West +24 59 £383 -10.00% 24
West Midlands +6 51 £433 -3.89% 17
East of England +9 46 £444 -4.57% 18
South West +1 40 £450 +1.12% 5
Yorkshire +26 29 £525 +17.32% 10
Scotland +23 20 £375 -21.05% 15
East Midlands +17 15 £350 -17.65% 13
Wales +21 11 £375 +5.26% 7
North East +23 3 £450 +16.88% 1

For the 6 months to 4 August 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 576 (62.81%) SQL
2 479 (52.24%) Business Intelligence
3 360 (39.26%) ETL
4 346 (37.73%) Azure
5 276 (30.10%) SQL Server
6 264 (28.79%) Agile Software Development
7 254 (27.70%) Power Platform
8 241 (26.28%) Power BI
9 240 (26.17%) Data Modelling
10 236 (25.74%) Finance
11 216 (23.56%) SQL Server Integration Services
12 215 (23.45%) Microsoft
13 214 (23.34%) Analytics
14 196 (21.37%) DevOps
15 190 (20.72%) Python
16 173 (18.87%) Data Lake
17 172 (18.76%) Oracle
18 155 (16.90%) AWS
19 121 (13.20%) T-SQL
20 120 (13.09%) SQL Server Reporting Services
20 120 (13.09%) Big Data
21 114 (12.43%) Java
22 102 (11.12%) Banking
22 102 (11.12%) Kimball Methodology
23 99 (10.80%) Analytical Skills
24 95 (10.36%) Azure SQL Data Warehouse
25 91 (9.92%) .NET
25 91 (9.92%) SQL Server Analysis Services
26 90 (9.81%) Scrum
27 88 (9.60%) Azure Data Factory

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 46 (5.02%) Apache Spark
2 42 (4.58%) SAS
3 34 (3.71%) Apache
4 22 (2.40%) SharePoint
5 14 (1.53%) WebLogic
6 10 (1.09%) Confluence
7 8 (0.87%) Elasticsearch
8 7 (0.76%) IIS
9 6 (0.65%) Apache Airflow
9 6 (0.65%) Apache Pig
10 4 (0.44%) Apache ServiceMix
10 4 (0.44%) JBoss
10 4 (0.44%) Red Hat Fuse
11 3 (0.33%) Oracle Workflow
12 2 (0.22%) BizTalk Server
13 1 (0.11%) CMS
Applications
1 57 (6.22%) Microsoft Excel
2 8 (0.87%) Microsoft Office
3 6 (0.65%) Microsoft PowerPoint
4 3 (0.33%) MS Visio
4 3 (0.33%) Spreadsheet
4 3 (0.33%) SPSS
5 1 (0.11%) Chatbot
5 1 (0.11%) Microsoft Project
Business Applications
1 12 (1.31%) Oracle EBS
2 7 (0.76%) Dynamics CRM
2 7 (0.76%) SAP Oil and Gas
3 5 (0.55%) SAP S/4HANA
4 3 (0.33%) Salesforce.com CRM
4 3 (0.33%) SAP BPC
5 2 (0.22%) Endur
5 2 (0.22%) HFM
5 2 (0.22%) Markit EDM
5 2 (0.22%) NetSuite
5 2 (0.22%) Oracle Payroll
5 2 (0.22%) Primavera
5 2 (0.22%) Unit4 Business World
6 1 (0.11%) Cognos Business Intelligence
6 1 (0.11%) Oracle Financials
6 1 (0.11%) Oracle HRMS
6 1 (0.11%) Oracle iProcurement
6 1 (0.11%) SimCorp Dimension
6 1 (0.11%) Summit
6 1 (0.11%) thinkFolio
Cloud Services
1 346 (37.73%) Azure
2 254 (27.70%) Power Platform
3 155 (16.90%) AWS
4 88 (9.60%) Azure Data Factory
5 73 (7.96%) GCP
6 57 (6.22%) Serverless
7 40 (4.36%) AWS Lambda
8 37 (4.03%) PaaS
9 30 (3.27%) Amazon ECS
10 29 (3.16%) Amazon S3
11 19 (2.07%) Logic Apps
12 17 (1.85%) Amazon EC2
12 17 (1.85%) Apigee
13 14 (1.53%) IaaS
14 13 (1.42%) Azure Functions
14 13 (1.42%) SaaS
15 12 (1.31%) Azure Active Directory
16 10 (1.09%) Slack
17 9 (0.98%) Amazon EMR
17 9 (0.98%) GitHub
Communications & Networking
1 9 (0.98%) Firewall
2 7 (0.76%) Kerberos
3 6 (0.65%) 3G
3 6 (0.65%) 4G
3 6 (0.65%) 5G
3 6 (0.65%) SSL
4 4 (0.44%) FTP
4 4 (0.44%) HTTP
4 4 (0.44%) Internet
5 3 (0.33%) SSH
6 2 (0.22%) DNS
6 2 (0.22%) Network Security
6 2 (0.22%) Skype
7 1 (0.11%) MQTT
7 1 (0.11%) Reverse Proxy
7 1 (0.11%) VPN
Database & Business Intelligence
1 276 (30.10%) SQL Server
2 241 (26.28%) Power BI
3 216 (23.56%) SQL Server Integration Services
4 173 (18.87%) Data Lake
5 120 (13.09%) Big Data
5 120 (13.09%) SQL Server Reporting Services
6 95 (10.36%) Azure SQL Data Warehouse
7 91 (9.92%) SQL Server Analysis Services
8 84 (9.16%) Amazon Redshift
9 72 (7.85%) Azure SQL Database
10 67 (7.31%) Relational Database
11 63 (6.87%) MySQL
12 58 (6.32%) Hadoop
12 58 (6.32%) Snowflake Schema
13 53 (5.78%) Oracle Database
14 49 (5.34%) NoSQL
15 47 (5.13%) OLAP
16 46 (5.02%) PostgreSQL
17 36 (3.93%) BusinessObjects
18 31 (3.38%) RDBMS
Development Applications
1 70 (7.63%) Git (software)
2 55 (6.00%) Jenkins
3 41 (4.47%) JIRA
4 34 (3.71%) GitLab
5 29 (3.16%) Team Foundation Server
6 28 (3.05%) Artifactory
7 22 (2.40%) SQL Server Management Studio (SSMS)
8 18 (1.96%) Bitbucket
9 16 (1.74%) Visual Studio Team System
10 15 (1.64%) Maven
11 11 (1.20%) Visual Studio
12 10 (1.09%) ERwin
12 10 (1.09%) Subversion
13 7 (0.76%) Eclipse
13 7 (0.76%) NUnit
14 6 (0.65%) ProC
14 6 (0.65%) Selenium
14 6 (0.65%) TeamCity
15 5 (0.55%) JMeter
15 5 (0.55%) JUnit
General
1 236 (25.74%) Finance
2 102 (11.12%) Banking
3 48 (5.23%) Back Office
4 45 (4.91%) Public Sector
5 32 (3.49%) Retail
6 28 (3.05%) Marketing
7 23 (2.51%) Investment Banking
8 21 (2.29%) Law
9 12 (1.31%) Pharmaceutical
9 12 (1.31%) Telecoms
10 11 (1.20%) Legal
11 9 (0.98%) Advertising
11 9 (0.98%) Front Office
12 7 (0.76%) Billing
13 5 (0.55%) Manufacturing
13 5 (0.55%) Publishing
14 4 (0.44%) Automotive
15 3 (0.33%) Financial Institution
15 3 (0.33%) Games
15 3 (0.33%) General Ledger
Job Titles
1 312 (34.02%) Developer
2 161 (17.56%) Architect
3 112 (12.21%) Analyst
4 110 (12.00%) Data Engineer
5 109 (11.89%) Business Intelligence Developer
6 102 (11.12%) Data Architect
7 85 (9.27%) SQL Developer
8 55 (6.00%) Data Warehouse Developer
9 42 (4.58%) Consultant
10 39 (4.25%) Azure Engineer
11 36 (3.93%) Data Analyst
12 35 (3.82%) Power BI Developer
12 35 (3.82%) Senior Developer
13 34 (3.71%) Solutions Architect
14 31 (3.38%) Azure Developer
14 31 (3.38%) Project Manager
15 30 (3.27%) ETL Developer
16 29 (3.16%) Business Analyst
17 28 (3.05%) DBA
17 28 (3.05%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 91 (9.92%) .NET
2 49 (5.34%) Web Services
3 35 (3.82%) XML
4 33 (3.60%) JSON
5 30 (3.27%) gRPC
6 27 (2.94%) Kafka
7 20 (2.18%) HTML
8 19 (2.07%) Swagger
9 18 (1.96%) CSS
9 18 (1.96%) OAuth
10 17 (1.85%) .NET Framework
11 16 (1.74%) ASP.NET
11 16 (1.74%) PySpark
11 16 (1.74%) REST
12 14 (1.53%) MDX
13 12 (1.31%) WinForms
14 11 (1.20%) AngularJS
15 10 (1.09%) Middleware
15 10 (1.09%) SOAP
16 8 (0.87%) ADO.NET
Miscellaneous
1 99 (10.80%) Analytical Skills
2 39 (4.25%) Hedge funds
3 32 (3.49%) Greenfield Project
3 32 (3.49%) Management Information System
4 28 (3.05%) Data Structures
5 22 (2.40%) NHS
6 15 (1.64%) User Experience
7 13 (1.42%) Algorithms
7 13 (1.42%) Replication
8 11 (1.20%) Cloud Native
9 10 (1.09%) Self-Motivation
10 9 (0.98%) Enterprise Software
11 8 (0.87%) FMCG
11 8 (0.87%) Reference Data
12 7 (0.76%) Mobile App
13 6 (0.65%) Data Centre
14 4 (0.44%) Credit Risk
14 4 (0.44%) PKI
14 4 (0.44%) Virtual Team
15 3 (0.33%) Public Cloud
Operating Systems
1 44 (4.80%) Unix
2 43 (4.69%) Windows
3 32 (3.49%) Linux
4 17 (1.85%) VMS
5 10 (1.09%) Red Hat Enterprise Linux
6 7 (0.76%) Windows Server
7 6 (0.65%) Debian
7 6 (0.65%) Ubuntu
8 3 (0.33%) Solaris
9 2 (0.22%) AIX
9 2 (0.22%) Android
10 1 (0.11%) Apple iOS
10 1 (0.11%) Windows Vista
Processes & Methodologies
1 479 (52.24%) Business Intelligence
2 360 (39.26%) ETL
3 264 (28.79%) Agile Software Development
4 240 (26.17%) Data Modelling
5 214 (23.34%) Analytics
6 196 (21.37%) DevOps
7 102 (11.12%) Kimball Methodology
8 90 (9.81%) Scrum
9 84 (9.16%) Migration
10 73 (7.96%) Machine Learning
11 72 (7.85%) Data Engineering
12 70 (7.63%) Visualisation
13 69 (7.52%) Data Architecture
14 66 (7.20%) Mentoring
15 64 (6.98%) Software Engineering
16 63 (6.87%) Stakeholder Management
17 62 (6.76%) Microservices
18 58 (6.32%) Requirements Gathering
19 56 (6.11%) Data Integration
19 56 (6.11%) Problem-Solving
Programming Languages
1 576 (62.81%) SQL
2 190 (20.72%) Python
3 121 (13.20%) T-SQL
4 114 (12.43%) Java
5 85 (9.27%) C#
6 66 (7.20%) PL/SQL
7 60 (6.54%) PowerShell
8 38 (4.14%) JavaScript
9 31 (3.38%) R
10 28 (3.05%) Shell Script
11 25 (2.73%) Data Analysis Expressions (DAX)
12 23 (2.51%) Perl
13 21 (2.29%) Scala
13 21 (2.29%) VBA
14 16 (1.74%) VB
15 12 (1.31%) PHP
16 11 (1.20%) Go
16 11 (1.20%) SAS Macro
17 10 (1.09%) C++
18 9 (0.98%) VB.NET
Qualifications
1 59 (6.43%) Security Cleared
2 45 (4.91%) Degree
3 44 (4.80%) SC Cleared
4 17 (1.85%) Sun Certification
5 11 (1.20%) AWS Certification
6 10 (1.09%) Computer Science Degree
7 8 (0.87%) DV Cleared
8 7 (0.76%) TOGAF Certification
9 6 (0.65%) CESG Certified Professional
9 6 (0.65%) CISM
9 6 (0.65%) CISSP
9 6 (0.65%) CRISC
10 4 (0.44%) Master's Degree
10 4 (0.44%) PRINCE2 Practitioner
11 3 (0.33%) BPSS Clearance
11 3 (0.33%) PMI Certification
12 2 (0.22%) CIMA
12 2 (0.22%) ITIL Certification
12 2 (0.22%) PMP
12 2 (0.22%) PRINCE2 Certification
Quality Assurance & Compliance
1 59 (6.43%) QA
2 55 (6.00%) Data Quality
3 25 (2.73%) GDPR
4 9 (0.98%) Solvency II
5 4 (0.44%) SLA
6 3 (0.33%) PMO
7 1 (0.11%) IFRS
System Software
1 27 (2.94%) Docker
2 12 (1.31%) Active Directory
3 6 (0.65%) Oracle Clusterware
3 6 (0.65%) Oracle RAC
4 5 (0.55%) Virtual Machines
5 4 (0.44%) Apache Flume
6 3 (0.33%) GridGain
7 2 (0.22%) HDFS
7 2 (0.22%) VMware Infrastructure
8 1 (0.11%) Apache ZooKeeper
8 1 (0.11%) Virtual Desktop
Systems Management
1 47 (5.13%) Kubernetes
2 26 (2.84%) Terraform
3 17 (1.85%) Ansible
4 7 (0.76%) Data Guard
5 6 (0.65%) Oozie
5 6 (0.65%) Oracle RMAN
6 5 (0.55%) Control-M
6 5 (0.55%) Opscode Chef
7 4 (0.44%) HP ALM
8 1 (0.11%) HP Quality Center
8 1 (0.11%) Tivoli
Vendors
1 215 (23.45%) Microsoft
2 172 (18.76%) Oracle
3 84 (9.16%) Tableau
4 64 (6.98%) Google
5 60 (6.54%) Databricks
5 60 (6.54%) SAP
6 43 (4.69%) Informatica
7 27 (2.94%) Cloudera
8 22 (2.40%) Salesforce.com
9 21 (2.29%) Cognos
10 13 (1.42%) MicroStrategy
10 13 (1.42%) Red Hat
10 13 (1.42%) Teradata
11 12 (1.31%) IBM
11 12 (1.31%) Talend
12 9 (0.98%) MuleSoft
13 7 (0.76%) Pega
14 6 (0.65%) Alteryx
14 6 (0.65%) RedGate
14 6 (0.65%) Sun