Period
to 25 May 2019

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 May 2019 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 May 2019
Same period 2018 Same period 2017
Rank 86 95 93
Rank change year-on-year +9 -2 -12
Contract jobs citing Data Warehouse 2,481 2,552 2,265
As % of all contract IT jobs advertised in the UK 2.71% 2.51% 2.51%
As % of the Database & Business Intelligence category 12.09% 11.20% 11.11%
Number of daily rates quoted 1,750 1,861 1,563
UK median daily rate £475 £463 £438
Median daily rate % change year-on-year +2.70% +5.71% +2.94%
10th Percentile £338 £315 £305
90th Percentile £630 £600 £588
UK excluding London median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 21 19 12
UK median hourly rate £18.19 £23.00 £38.00
Median hourly rate % change year-on-year -20.91% -39.47% +43.60%
10th Percentile £13.25 £10.16 £30.42
90th Percentile £47.56 £84.00 £43.00
UK excluding London median hourly rate £16.34 £14.28 £38.00
% change year-on-year +14.43% -62.42% -1.94%

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 20,515 22,782 20,393
As % of all contract IT jobs advertised in the UK 22.39% 22.44% 22.56%
Number of daily rates quoted 14,044 15,878 13,645
UK median daily rate £475 £473 £438
Median daily rate % change year-on-year +0.53% +8.00% +2.94%
10th Percentile £325 £313 £295
90th Percentile £650 £625 £613
UK excluding London median daily rate £425 £415 £390
% change year-on-year +2.41% +6.41% +4.00%
Number of hourly rates quoted 253 232 247
UK median hourly rate £35.00 £33.50 £29.82
Median hourly rate % change year-on-year +4.48% +12.36% +6.48%
10th Percentile £14.00 £14.00 £9.25
90th Percentile £57.50 £53.50 £50.00
UK excluding London median hourly rate £30.00 £33.75 £29.00
% change year-on-year -11.11% +16.38% +5.45%

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 25 May 2019.

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 25 May 2019.

Contractor 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 25 May 2019. 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 +9 2,330 £475 - 284
London +11 1,295 £490 -2.00% 119
UK excluding London -1 1,156 £450 +5.88% 187
South East +24 349 £450 - 23
North of England +33 242 £435 +2.35% 72
Midlands -1 201 £438 +6.06% 29
East of England +24 137 £463 +8.82% 17
West Midlands +15 135 £450 +5.88% 14
Yorkshire +22 120 £425 - 26
South West -58 102 £450 +2.86% 24
North West +11 96 £450 +12.50% 40
Scotland -11 90 £450 +12.50% 12
East Midlands -19 61 £375 +4.17% 15
North East +16 26 £370 -22.11% 6
Wales -19 26 £400 +3.90% 10
Northern Ireland -1 9 £325 -24.68%

For the 6 months to 25 May 2019, 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,462 (58.93%) SQL
2 1,142 (46.03%) Business Intelligence
3 986 (39.74%) ETL
4 820 (33.05%) SQL Server
5 734 (29.58%) Agile Software Development
6 657 (26.48%) Data Modelling
7 651 (26.24%) Finance
8 631 (25.43%) Analytics
9 599 (24.14%) SQL Server Integration Services
10 593 (23.90%) Microsoft Azure
11 552 (22.25%) Big Data
12 549 (22.13%) Microsoft
13 487 (19.63%) Power BI
13 487 (19.63%) Power Platform
14 458 (18.46%) Oracle
15 428 (17.25%) T-SQL
16 418 (16.85%) SQL Server Reporting Services
17 363 (14.63%) Python
18 346 (13.95%) Hadoop
19 337 (13.58%) Amazon AWS
20 324 (13.06%) SQL Server Analysis Services
21 311 (12.54%) Apache Spark
22 294 (11.85%) Migration
23 287 (11.57%) Analytical Skills
24 281 (11.33%) Data Lake
25 261 (10.52%) Visualisation
26 255 (10.28%) C#
27 249 (10.04%) Scrum
28 244 (9.83%) Relational Database
29 235 (9.47%) Data Analysis

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 311 (12.54%) Apache Spark
2 71 (2.86%) SharePoint
3 65 (2.62%) SAS
4 60 (2.42%) Apache
5 53 (2.14%) Confluence
6 34 (1.37%) Apache Airflow
7 23 (0.93%) IIS
8 20 (0.81%) Apache Pig
8 20 (0.81%) Elasticsearch
9 15 (0.60%) Luigi
10 8 (0.32%) Apache Solr
10 8 (0.32%) NServiceBus
11 7 (0.28%) SharePoint 2013
12 6 (0.24%) CMS
13 4 (0.16%) ArcGIS
13 4 (0.16%) Oracle SOA Suite
13 4 (0.16%) Oracle Workflow
14 3 (0.12%) BizTalk Server
14 3 (0.12%) JBoss
14 3 (0.12%) Jupyter
Applications
1 160 (6.45%) Microsoft Excel
2 35 (1.41%) Microsoft PowerPoint
3 34 (1.37%) MS Visio
4 26 (1.05%) Microsoft Office
5 13 (0.52%) Spreadsheet
6 10 (0.40%) Microsoft Project
7 4 (0.16%) InfoPath
8 2 (0.081%) SPSS
9 1 (0.040%) Chatbot
9 1 (0.040%) Stata
Business Applications
1 37 (1.49%) Dynamics CRM
2 21 (0.85%) Dynamics AX
2 21 (0.85%) Oracle EBS
3 17 (0.69%) Oracle EBS R12
4 15 (0.60%) Markit EDM
5 14 (0.56%) Oracle Applications
5 14 (0.56%) SAP Oil and Gas
6 12 (0.48%) Dynamics NAV
7 9 (0.36%) Unit4 Business World
8 7 (0.28%) Oracle General Ledger
9 6 (0.24%) Cognos Business Intelligence
10 5 (0.20%) Cognos TM1
10 5 (0.20%) HFM
10 5 (0.20%) SAP S/4HANA
11 4 (0.16%) Lorenzo
11 4 (0.16%) NetSuite
12 3 (0.12%) Oracle Procure-to-Pay
12 3 (0.12%) SAP BPC
13 2 (0.081%) Oracle Retail
13 2 (0.081%) thinkFolio
Cloud Services
1 593 (23.90%) Microsoft Azure
2 487 (19.63%) Power Platform
3 337 (13.58%) Amazon AWS
4 163 (6.57%) Azure Data Factory
5 93 (3.75%) Google Cloud Platform
6 73 (2.94%) Amazon S3
7 71 (2.86%) PaaS
8 66 (2.66%) Serverless
9 58 (2.34%) Amazon EMR
10 36 (1.45%) Amazon EC2
11 34 (1.37%) Data Lake Analytics
11 34 (1.37%) Dynamics 365
12 33 (1.33%) Amazon Kinesis
12 33 (1.33%) AWS Lambda
12 33 (1.33%) IaaS
13 30 (1.21%) SaaS
14 27 (1.09%) Cloud Computing
15 25 (1.01%) GitHub
16 24 (0.97%) Office 365
17 23 (0.93%) Azure Functions
Communications & Networking
1 16 (0.64%) FTP
2 13 (0.52%) Firewall
3 12 (0.48%) MQTT
4 6 (0.24%) Internet
4 6 (0.24%) VPN
4 6 (0.24%) WAN
5 5 (0.20%) DNS
5 5 (0.20%) Kerberos
6 3 (0.12%) 3G
7 2 (0.081%) BGP
7 2 (0.081%) DHCP
7 2 (0.081%) Ethernet
7 2 (0.081%) Intranet
7 2 (0.081%) LAN
7 2 (0.081%) RFID
7 2 (0.081%) SAN
7 2 (0.081%) SMTP
7 2 (0.081%) SSL
7 2 (0.081%) TCP/IP
7 2 (0.081%) Wi-Fi
Database & Business Intelligence
1 820 (33.05%) SQL Server
2 599 (24.14%) SQL Server Integration Services
3 552 (22.25%) Big Data
4 487 (19.63%) Power BI
5 418 (16.85%) SQL Server Reporting Services
6 346 (13.95%) Hadoop
7 324 (13.06%) SQL Server Analysis Services
8 281 (11.33%) Data Lake
9 244 (9.83%) Relational Database
10 212 (8.54%) Apache Hive
11 188 (7.58%) Azure SQL Data Warehouse
12 165 (6.65%) Oracle Database
13 162 (6.53%) OLAP
14 160 (6.45%) NoSQL
15 139 (5.60%) Star Schema
16 118 (4.76%) Azure SQL Database
17 112 (4.51%) MySQL
18 111 (4.47%) Enterprise Data Warehouse
19 110 (4.43%) Amazon Redshift
20 97 (3.91%) PostgreSQL
Development Applications
1 131 (5.28%) JIRA
2 124 (5.00%) Git (software)
3 109 (4.39%) Jenkins
4 60 (2.42%) Team Foundation Server
5 59 (2.38%) Visual Studio
6 52 (2.10%) Selenium
7 46 (1.85%) Maven
8 43 (1.73%) Visual Studio Team System
9 39 (1.57%) SQL Server Management Studio (SSMS)
10 34 (1.37%) SpecFlow
11 32 (1.29%) ERwin
12 28 (1.13%) Cucumber
13 27 (1.09%) Oracle Forms
14 22 (0.89%) ER Studio
14 22 (0.89%) Gradle
15 21 (0.85%) TeamCity
16 20 (0.81%) Octopus Deploy
17 19 (0.77%) Ant
17 19 (0.77%) Apache Ivy
18 16 (0.64%) Toad
General
1 651 (26.24%) Finance
2 182 (7.34%) Banking
3 161 (6.49%) Retail
4 64 (2.58%) Marketing
5 41 (1.65%) Legal
6 38 (1.53%) Back Office
6 38 (1.53%) Investment Banking
7 34 (1.37%) Telecoms
8 33 (1.33%) Manufacturing
9 16 (0.64%) Pharmaceutical
9 16 (0.64%) Publishing
10 11 (0.44%) Law
11 10 (0.40%) Advertising
12 9 (0.36%) Financial Institution
13 8 (0.32%) Games
13 8 (0.32%) General Ledger
14 7 (0.28%) Electronics
14 7 (0.28%) Retail Banking
15 6 (0.24%) French Language
15 6 (0.24%) Front Office
Job Titles
1 909 (36.64%) Developer
2 377 (15.20%) Analyst
3 302 (12.17%) Data Engineer
4 296 (11.93%) Architect
5 272 (10.96%) Business Intelligence Developer
6 263 (10.60%) SQL Developer
7 187 (7.54%) Data Architect
8 121 (4.88%) Business Analyst
8 121 (4.88%) Data Warehouse Developer
9 117 (4.72%) ETL Developer
10 114 (4.59%) Data Analyst
11 101 (4.07%) DBA
12 99 (3.99%) Consultant
13 75 (3.02%) Power BI Developer
14 74 (2.98%) SQL BI Developer
15 72 (2.90%) Project Manager
16 69 (2.78%) Business Intelligence Analyst
17 64 (2.58%) .NET Developer
18 63 (2.54%) Solutions Architect
19 62 (2.50%) C# Developer
Libraries, Frameworks & Software Standards
1 180 (7.26%) Kafka
2 176 (7.09%) .NET
3 84 (3.39%) XML
4 82 (3.31%) Web Services
5 65 (2.62%) JSON
6 56 (2.26%) WinForms
7 53 (2.14%) MDX
8 44 (1.77%) RESTful
9 42 (1.69%) ASP.NET Web API
10 40 (1.61%) Middleware
10 40 (1.61%) SOAP
11 34 (1.37%) REST
12 33 (1.33%) Oracle Fusion
13 32 (1.29%) WPF
14 31 (1.25%) PySpark
15 30 (1.21%) WCF
16 29 (1.17%) .NET Framework
17 28 (1.13%) AngularJS
18 27 (1.09%) HTML
19 26 (1.05%) Entity Framework
Miscellaneous
1 287 (11.57%) Analytical Skills
2 96 (3.87%) Data Structures
3 88 (3.55%) Management Information System
4 77 (3.10%) Greenfield Project
5 56 (2.26%) NHS
6 52 (2.10%) Self-Motivation
7 41 (1.65%) Replication
8 27 (1.09%) Algorithms
8 27 (1.09%) User Experience
9 18 (0.73%) Fintech
9 18 (0.73%) Linux Command Line
10 16 (0.64%) Data Centre
11 15 (0.60%) Enterprise Software
11 15 (0.60%) Life Science
12 13 (0.52%) Reference Data
13 12 (0.48%) Data Protection Act
14 11 (0.44%) Hedge funds
15 10 (0.40%) Reinsurance
15 10 (0.40%) Virtual Team
16 9 (0.36%) Credit Risk
Operating Systems
1 125 (5.04%) Unix
2 109 (4.39%) Linux
3 56 (2.26%) Windows
4 27 (1.09%) Windows Server
5 25 (1.01%) AIX
6 14 (0.56%) Oracle Linux
7 11 (0.44%) Red Hat Enterprise Linux
8 7 (0.28%) Solaris
8 7 (0.28%) SUSE
9 5 (0.20%) Windows Server 2008
10 4 (0.16%) Windows 10
11 3 (0.12%) CentOS
11 3 (0.12%) Windows Server 2012
12 2 (0.081%) Tru64
12 2 (0.081%) VMS
12 2 (0.081%) Windows 7
13 1 (0.040%) Apple iOS
13 1 (0.040%) Ubuntu
13 1 (0.040%) Windows 8
13 1 (0.040%) Windows XP
Processes & Methodologies
1 1,142 (46.03%) Business Intelligence
2 986 (39.74%) ETL
3 734 (29.58%) Agile Software Development
4 657 (26.48%) Data Modelling
5 631 (25.43%) Analytics
6 294 (11.85%) Migration
7 261 (10.52%) Visualisation
8 249 (10.04%) Scrum
9 235 (9.47%) Data Analysis
10 206 (8.30%) Kimball Methodology
11 195 (7.86%) Data Integration
11 195 (7.86%) Data Migration
12 189 (7.62%) Problem-Solving
13 187 (7.54%) Data Science
14 183 (7.38%) Data Architecture
15 179 (7.21%) Data Analytics
16 172 (6.93%) Data Management
17 163 (6.57%) DevOps
18 159 (6.41%) Stakeholder Management
19 152 (6.13%) Performance Tuning
Programming Languages
1 1,462 (58.93%) SQL
2 428 (17.25%) T-SQL
3 363 (14.63%) Python
4 255 (10.28%) C#
5 197 (7.94%) PL/SQL
6 175 (7.05%) Java
7 97 (3.91%) Scala
8 77 (3.10%) Shell Script
9 76 (3.06%) VB.NET
10 73 (2.94%) JavaScript
11 71 (2.86%) PowerShell
12 68 (2.74%) R
12 68 (2.74%) VBA
13 55 (2.22%) VB
14 48 (1.93%) Data Analysis Expressions (DAX)
15 31 (1.25%) Perl
16 24 (0.97%) Bash Shell
17 20 (0.81%) C
17 20 (0.81%) U-SQL
18 16 (0.64%) Ruby
Qualifications
1 127 (5.12%) Security Cleared
2 117 (4.72%) Degree
3 97 (3.91%) SC Cleared
4 33 (1.33%) Computer Science Degree
5 31 (1.25%) ISTQB
6 29 (1.17%) ISEB
7 20 (0.81%) BPSS Clearance
8 17 (0.69%) DV Cleared
8 17 (0.69%) Microsoft Certification
9 13 (0.52%) Master's Degree
9 13 (0.52%) TOGAF Certification
10 12 (0.48%) MCSE
11 10 (0.40%) MCSA
11 10 (0.40%) PhD
12 9 (0.36%) ISTQB Foundation Certification
13 5 (0.20%) AWS Certification
13 5 (0.20%) ITIL Certification
13 5 (0.20%) PMP
13 5 (0.20%) PRINCE2 Certification
14 4 (0.16%) ISTQB Advanced Certification
Quality Assurance & Compliance
1 198 (7.98%) Data Quality
2 85 (3.43%) QA
3 49 (1.98%) GDPR
4 39 (1.57%) PMO
5 9 (0.36%) IFRS
5 9 (0.36%) SLA
6 8 (0.32%) Solvency II
7 3 (0.12%) PCI DSS
8 2 (0.081%) 21 CFR Part 11
8 2 (0.081%) Basel III
8 2 (0.081%) Disclosure Scotland
8 2 (0.081%) EMIR
8 2 (0.081%) GAMP
8 2 (0.081%) MiFID
9 1 (0.040%) GAAP
9 1 (0.040%) GMP
9 1 (0.040%) IFRS 9
9 1 (0.040%) ISO/IEC 27001
9 1 (0.040%) ISO/IEC 27002 (supersedes ISO/IEC 17799)
9 1 (0.040%) Sarbanes-Oxley
System Software
1 63 (2.54%) Apache Flume
2 49 (1.98%) Docker
3 35 (1.41%) Oracle RAC
4 32 (1.29%) Active Directory
5 28 (1.13%) HDFS
6 12 (0.48%) Virtual Machines
7 6 (0.24%) VMware Infrastructure
8 4 (0.16%) VMware ESXi
9 2 (0.081%) Firmware
9 2 (0.081%) NFS
10 1 (0.040%) Apache ZooKeeper
10 1 (0.040%) Hyper-V
10 1 (0.040%) Postfix
10 1 (0.040%) Veritas Volume Manager
10 1 (0.040%) VMware Server
Systems Management
1 70 (2.82%) Oozie
2 44 (1.77%) Kubernetes
3 32 (1.29%) Terraform
4 24 (0.97%) Opscode Chef
5 19 (0.77%) Ansible
5 19 (0.77%) Puppet
6 18 (0.73%) Oracle RMAN
7 16 (0.64%) Control-M
7 16 (0.64%) HP ALM
8 14 (0.56%) Oracle Enterprise Manager
9 13 (0.52%) Hadoop YARN
10 6 (0.24%) logstash
10 6 (0.24%) Microsoft Clustering
11 3 (0.12%) Rundeck
12 2 (0.081%) Enterprise Manager Cloud Control
12 2 (0.081%) Grafana
12 2 (0.081%) Kibana
12 2 (0.081%) Mesos
12 2 (0.081%) Prometheus
12 2 (0.081%) ZABBIX
Vendors
1 549 (22.13%) Microsoft
2 458 (18.46%) Oracle
3 234 (9.43%) Tableau
4 149 (6.01%) Informatica
5 119 (4.80%) Google
6 112 (4.51%) SAP
7 97 (3.91%) Talend
8 82 (3.31%) Databricks
9 60 (2.42%) Teradata
10 56 (2.26%) Cloudera
11 55 (2.22%) IBM
11 55 (2.22%) MicroStrategy
12 48 (1.93%) Netezza
13 36 (1.45%) Cognos
14 35 (1.41%) Salesforce.com
15 29 (1.17%) Ab Initio
16 26 (1.05%) Atlassian
17 25 (1.01%) Alteryx
18 22 (0.89%) Citrix
19 20 (0.81%) HP