Period
to 18 November 2018

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 18 November 2018 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
18 Nov 2018
Same period 2017 Same period 2016
Rank 105 103 87
Rank change year-on-year -2 -16 -30
Contract jobs citing Data Warehouse 2,511 2,410 2,865
As % of all contract IT jobs advertised in the UK 2.45% 2.36% 2.71%
As % of the Database & Business Intelligence category 10.90% 10.68% 11.99%
Number of daily rates quoted 1,763 1,709 1,974
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% -
10th Percentile £325 £313 £301
90th Percentile £612 £600 £600
UK excluding London median daily rate £425 £425 £400
% change year-on-year - +6.25% -
Number of hourly rates quoted 16 20 27
UK median hourly rate £20.25 £27.50 £42.00
Median hourly rate % change year-on-year -26.36% -34.52% +65.09%
10th Percentile £10.91 £14.48 £15.71
90th Percentile £61.47 £53.20 £52.25
UK excluding London median hourly rate £18.50 £35.00 £35.00
% change year-on-year -47.14% - +21.74%

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 23,031 22,557 23,901
As % of all contract IT jobs advertised in the UK 22.49% 22.09% 22.62%
Number of daily rates quoted 16,016 15,404 15,873
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £310 £285
90th Percentile £638 £625 £600
UK excluding London median daily rate £425 £400 £378
% change year-on-year +6.25% +5.96% +0.67%
Number of hourly rates quoted 236 285 369
UK median hourly rate £33.25 £31.15 £28.18
Median hourly rate % change year-on-year +6.74% +10.54% -2.83%
10th Percentile £13.47 £14.00 £10.00
90th Percentile £57.50 £58.00 £52.03
UK excluding London median hourly rate £35.00 £35.00 £28.18
% change year-on-year - +24.20% -6.07%

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 18 November 2018.

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 18 November 2018.

Contractor hourly rate histogram for Data Warehouse in the UK

Data Warehouse
Top 18 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 18 November 2018. 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 2,314 £450 - 661
UK excluding London -12 1,318 £425 - 399
London +17 1,171 £475 - 310
North of England -11 312 £400 -5.88% 115
South East -36 303 £450 +12.43% 72
South West -5 223 £425 - 57
Midlands -6 169 £419 +4.69% 64
Yorkshire +16 155 £400 -5.88% 31
East of England +7 131 £450 +20.00% 45
North West -32 129 £395 -10.99% 66
Scotland -28 109 £425 +3.03% 33
West Midlands -16 94 £425 -5.56% 37
East Midlands +15 73 £400 +6.67% 27
Wales +4 61 £450 +35.44% 13
North East -7 30 £444 -6.58% 18
Northern Ireland +31 8 £430 +40.41% 2
Channel Islands -1 3 - -
Isle of Man - 1 £475 -

For the 6 months to 18 November 2018, 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.22%) SQL
2 1,305 (51.97%) Business Intelligence
3 1,027 (40.90%) ETL
4 928 (36.96%) SQL Server
5 762 (30.35%) Agile Software Development
6 730 (29.07%) SQL Server Integration Services
7 704 (28.04%) Finance
8 541 (21.55%) Data Modelling
9 539 (21.47%) Microsoft
10 526 (20.95%) SQL Server Reporting Services
11 482 (19.20%) Analytics
12 469 (18.68%) Power BI
13 439 (17.48%) Oracle
14 420 (16.73%) Microsoft Azure
15 403 (16.05%) T-SQL
16 402 (16.01%) SQL Server Analysis Services
17 383 (15.25%) Big Data
18 328 (13.06%) Analytical Skills
19 312 (12.43%) Relational Database
20 295 (11.75%) Migration
21 271 (10.79%) Scrum
22 269 (10.71%) Tableau
23 266 (10.59%) Visualisation
24 265 (10.55%) Hadoop
25 241 (9.60%) Data Analysis
26 239 (9.52%) Amazon AWS
26 239 (9.52%) Banking
27 237 (9.44%) Data Lake
28 226 (9.00%) Kimball Methodology
29 224 (8.92%) Python

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 173 (6.89%) Apache Spark
2 87 (3.46%) SAS
3 46 (1.83%) SharePoint
4 35 (1.39%) Confluence
5 32 (1.27%) Apache
6 27 (1.08%) IIS
7 17 (0.68%) Apache Pig
8 15 (0.60%) Elasticsearch
9 7 (0.28%) Liferay
9 7 (0.28%) Oracle SOA Suite
9 7 (0.28%) Tomcat
10 6 (0.24%) Alfresco
10 6 (0.24%) Apache Solr
11 5 (0.20%) Apache Airflow
11 5 (0.20%) Documentum
12 4 (0.16%) Adobe Experience Manager
12 4 (0.16%) Drupal
12 4 (0.16%) FileNet
12 4 (0.16%) LiveCycle
12 4 (0.16%) LiveLink
Applications
1 202 (8.04%) Microsoft Excel
2 49 (1.95%) Microsoft Office
3 24 (0.96%) MS Visio
4 17 (0.68%) Microsoft PowerPoint
5 12 (0.48%) Microsoft Project
6 7 (0.28%) Spreadsheet
7 5 (0.20%) SPSS
8 2 (0.080%) Stata
9 1 (0.040%) Adobe Illustrator
9 1 (0.040%) InfoPath
9 1 (0.040%) Photoshop
9 1 (0.040%) Shockwave
Business Applications
1 16 (0.64%) Oracle EBS
2 13 (0.52%) Dynamics CRM
3 11 (0.44%) HFM
3 11 (0.44%) SAP Oil and Gas
4 9 (0.36%) Infor M3
4 9 (0.36%) SAP S/4HANA
5 8 (0.32%) Markit EDM
6 7 (0.28%) Cognos Business Intelligence
6 7 (0.28%) Dynamics AX
6 7 (0.28%) Hyperion Planning
6 7 (0.28%) Oracle ERP
7 6 (0.24%) Oracle Procure-to-Pay
8 4 (0.16%) Cognos TM1
8 4 (0.16%) Dynamics NAV
8 4 (0.16%) Oracle Applications
8 4 (0.16%) Oracle Financials
9 3 (0.12%) Endur
9 3 (0.12%) JDE EnterpriseOne
9 3 (0.12%) Oracle EBS R12
9 3 (0.12%) Summit
Cloud Services
1 420 (16.73%) Microsoft Azure
2 239 (9.52%) Amazon AWS
3 107 (4.26%) Azure Data Factory
4 60 (2.39%) PaaS
5 56 (2.23%) Amazon S3
6 41 (1.63%) Amazon EC2
7 36 (1.43%) Amazon EMR
8 33 (1.31%) Google Cloud Platform
9 30 (1.19%) Serverless
10 27 (1.08%) Data Lake Analytics
11 25 (1.00%) AWS Lambda
12 24 (0.96%) IaaS
13 21 (0.84%) Amazon Kinesis
13 21 (0.84%) Office 365
14 20 (0.80%) Dynamics 365
15 17 (0.68%) Google Analytics
16 12 (0.48%) Azure Machine Learning
17 11 (0.44%) GitHub
18 9 (0.36%) AWS CloudFormation
18 9 (0.36%) SaaS
Communications & Networking
1 17 (0.68%) Firewall
2 14 (0.56%) Intranet
2 14 (0.56%) SMS
3 11 (0.44%) Extranet
4 9 (0.36%) VPN
5 7 (0.28%) Internet
6 6 (0.24%) Kerberos
7 5 (0.20%) DNS
7 5 (0.20%) SAN
8 4 (0.16%) Ethernet
8 4 (0.16%) LAN
8 4 (0.16%) Profibus
8 4 (0.16%) SMTP
8 4 (0.16%) WAN
9 3 (0.12%) DHCP
9 3 (0.12%) FTP
9 3 (0.12%) MQTT
9 3 (0.12%) Network Security
10 2 (0.080%) PABX
10 2 (0.080%) Radio Access Network
Database & Business Intelligence
1 928 (36.96%) SQL Server
2 730 (29.07%) SQL Server Integration Services
3 526 (20.95%) SQL Server Reporting Services
4 469 (18.68%) Power BI
5 402 (16.01%) SQL Server Analysis Services
6 383 (15.25%) Big Data
7 312 (12.43%) Relational Database
8 265 (10.55%) Hadoop
9 237 (9.44%) Data Lake
10 171 (6.81%) OLAP
11 154 (6.13%) Apache Hive
12 150 (5.97%) NoSQL
13 130 (5.18%) Oracle Database
14 122 (4.86%) SQL Server 2016
15 118 (4.70%) SQL Server 2008
16 116 (4.62%) Azure SQL Data Warehouse
17 110 (4.38%) Enterprise Data Warehouse
18 109 (4.34%) Azure SQL Database
19 108 (4.30%) BusinessObjects
20 99 (3.94%) RDBMS
Development Applications
1 99 (3.94%) JIRA
2 87 (3.46%) Team Foundation Server
3 79 (3.15%) Git (software)
3 79 (3.15%) Jenkins
4 58 (2.31%) Visual Studio
5 30 (1.19%) Toad
6 29 (1.15%) Visual Studio Team System
7 27 (1.08%) ERwin
8 24 (0.96%) Subversion
9 23 (0.92%) Maven
10 19 (0.76%) Selenium
11 15 (0.60%) TeamCity
12 13 (0.52%) Ant
13 12 (0.48%) Gradle
14 11 (0.44%) Cucumber
14 11 (0.44%) Eclipse
14 11 (0.44%) JUnit
14 11 (0.44%) Octopus Deploy
15 10 (0.40%) SoapUI
15 10 (0.40%) SonarQube
General
1 704 (28.04%) Finance
2 239 (9.52%) Banking
3 215 (8.56%) Retail
4 77 (3.07%) Marketing
5 76 (3.03%) Investment Banking
6 43 (1.71%) Manufacturing
7 42 (1.67%) Telecoms
8 40 (1.59%) Front Office
9 34 (1.35%) Publishing
10 26 (1.04%) Legal
11 22 (0.88%) Pharmaceutical
12 19 (0.76%) Financial Institution
13 18 (0.72%) Law
14 14 (0.56%) Games
15 13 (0.52%) Advertising
15 13 (0.52%) Automotive
16 11 (0.44%) Billing
17 10 (0.40%) Electronics
18 9 (0.36%) Back Office
18 9 (0.36%) Retail Banking
Job Titles
1 1,156 (46.04%) Developer
2 426 (16.97%) Analyst
3 378 (15.05%) Business Intelligence Developer
4 324 (12.90%) SQL Developer
5 251 (10.00%) Architect
6 169 (6.73%) ETL Developer
7 162 (6.45%) Data Engineer
8 160 (6.37%) Business Analyst
9 144 (5.73%) Data Architect
10 140 (5.58%) Data Warehouse Developer
11 133 (5.30%) Data Analyst
12 124 (4.94%) SSIS Developer
13 120 (4.78%) Consultant
14 104 (4.14%) Project Manager
15 96 (3.82%) Business Intelligence Analyst
16 93 (3.70%) SQL BI Developer
17 89 (3.54%) Senior Developer
18 75 (2.99%) Power BI Developer
19 64 (2.55%) SSRS Developer
20 60 (2.39%) Oracle Developer
Libraries, Frameworks & Software Standards
1 154 (6.13%) .NET
2 148 (5.89%) Web Services
3 119 (4.74%) XML
4 103 (4.10%) Kafka
5 66 (2.63%) JSON
6 59 (2.35%) MDX
7 58 (2.31%) RESTful
8 48 (1.91%) Node.js
9 39 (1.55%) SOAP
10 38 (1.51%) HTML
11 31 (1.23%) CSS
12 30 (1.19%) Spring
13 28 (1.12%) Middleware
14 26 (1.04%) AngularJS
15 22 (0.88%) REST
16 20 (0.80%) jQuery
16 20 (0.80%) React
16 20 (0.80%) XSD
17 19 (0.76%) HTML5
17 19 (0.76%) J2EE
Miscellaneous
1 328 (13.06%) Analytical Skills
2 97 (3.86%) NHS
3 89 (3.54%) Data Structures
4 66 (2.63%) Computer Science
5 64 (2.55%) Management Information System
6 63 (2.51%) Greenfield Project
7 48 (1.91%) Self-Motivation
8 38 (1.51%) Replication
9 33 (1.31%) Fixed Income
10 32 (1.27%) Algorithms
10 32 (1.27%) Enterprise Software
11 31 (1.23%) Reference Data
12 30 (1.19%) Fintech
13 28 (1.12%) User Experience
14 27 (1.08%) Derivative
15 25 (1.00%) Private Cloud
16 23 (0.92%) Reinsurance
16 23 (0.92%) Taxonomies
17 20 (0.80%) Equities
18 13 (0.52%) Hedge funds
Operating Systems
1 139 (5.54%) Unix
2 100 (3.98%) Linux
3 59 (2.35%) Windows
4 20 (0.80%) Windows Server
5 18 (0.72%) Apple iOS
6 17 (0.68%) Android
7 10 (0.40%) AIX
8 9 (0.36%) Solaris
9 8 (0.32%) Red Hat Enterprise Linux
10 5 (0.20%) VMS
11 4 (0.16%) Windows Server 2012
12 2 (0.080%) Oracle Linux
12 2 (0.080%) Windows 8
12 2 (0.080%) Windows Server 2008
12 2 (0.080%) Windows XP
12 2 (0.080%) zOS
13 1 (0.040%) Debian
13 1 (0.040%) Ubuntu
13 1 (0.040%) Windows 7
13 1 (0.040%) Windows Server 2003
Processes & Methodologies
1 1,305 (51.97%) Business Intelligence
2 1,027 (40.90%) ETL
3 762 (30.35%) Agile Software Development
4 541 (21.55%) Data Modelling
5 482 (19.20%) Analytics
6 295 (11.75%) Migration
7 271 (10.79%) Scrum
8 266 (10.59%) Visualisation
9 241 (9.60%) Data Analysis
10 226 (9.00%) Kimball Methodology
11 204 (8.12%) Data Integration
12 203 (8.08%) Problem-Solving
13 186 (7.41%) Project Management
14 183 (7.29%) Dimensional Modelling
15 174 (6.93%) Data Migration
16 168 (6.69%) Stakeholder Management
17 166 (6.61%) Data Management
18 161 (6.41%) ETL Development
19 160 (6.37%) Performance Tuning
20 147 (5.85%) Data Architecture
Programming Languages
1 1,462 (58.22%) SQL
2 403 (16.05%) T-SQL
3 224 (8.92%) Python
4 181 (7.21%) Java
5 169 (6.73%) C#
6 136 (5.42%) PL/SQL
7 75 (2.99%) R
8 74 (2.95%) PowerShell
9 73 (2.91%) VBA
10 72 (2.87%) Shell Script
11 68 (2.71%) Scala
12 56 (2.23%) Data Analysis Expressions (DAX)
13 52 (2.07%) JavaScript
14 50 (1.99%) VB
15 49 (1.95%) PHP
16 42 (1.67%) Bash Shell
17 34 (1.35%) Perl
18 28 (1.12%) MATLAB
19 27 (1.08%) C
20 24 (0.96%) VB.NET
Qualifications
1 104 (4.14%) Security Cleared
2 99 (3.94%) Degree
3 84 (3.35%) SC Cleared
4 38 (1.51%) Computer Science Degree
5 19 (0.76%) Master's Degree
5 19 (0.76%) Microsoft Certification
6 17 (0.68%) ISEB
7 16 (0.64%) PMP
8 14 (0.56%) ISTQB
9 13 (0.52%) BPSS Clearance
10 11 (0.44%) PMI Certification
11 10 (0.40%) ISTQB Foundation Certification
12 8 (0.32%) DBS Check
12 8 (0.32%) MCSE
13 6 (0.24%) CISSP
13 6 (0.24%) DV Cleared
13 6 (0.24%) MCSA
14 4 (0.16%) ITIL Certification
14 4 (0.16%) Numerate Degree
14 4 (0.16%) TOGAF Certification
Quality Assurance & Compliance
1 207 (8.24%) Data Quality
2 113 (4.50%) QA
3 79 (3.15%) PMO
4 46 (1.83%) GDPR
5 17 (0.68%) IFRS
6 11 (0.44%) Solvency II
7 7 (0.28%) PCI DSS
8 6 (0.24%) IFRS 9
9 5 (0.20%) Basel III
10 3 (0.12%) EMIR
10 3 (0.12%) ISO 9000
10 3 (0.12%) MiFID
10 3 (0.12%) WCAG
11 2 (0.080%) HL7
11 2 (0.080%) ISO 9001
11 2 (0.080%) ISO 9002
11 2 (0.080%) SLA
11 2 (0.080%) TickIT
12 1 (0.040%) ISO/IEC 27001
12 1 (0.040%) Sarbanes-Oxley
System Software
1 41 (1.63%) Docker
2 38 (1.51%) Apache Flume
3 32 (1.27%) Active Directory
3 32 (1.27%) HDFS
4 19 (0.76%) VMware Infrastructure
5 9 (0.36%) Virtual Machines
6 8 (0.32%) Oracle RAC
6 8 (0.32%) VMware ESXi
6 8 (0.32%) vSphere
7 5 (0.20%) Apache ZooKeeper
7 5 (0.20%) Hyper-V
8 2 (0.080%) NFS
8 2 (0.080%) Veritas Volume Manager
9 1 (0.040%) Cronacle
9 1 (0.040%) VirtualBox
Systems Management
1 52 (2.07%) Oozie
2 19 (0.76%) Kubernetes
3 15 (0.60%) Ansible
4 14 (0.56%) Puppet
5 10 (0.40%) HP Quality Center
5 10 (0.40%) Opscode Chef
5 10 (0.40%) Terraform
6 9 (0.36%) Hadoop YARN
6 9 (0.36%) HP ALM
7 6 (0.24%) Control-M
7 6 (0.24%) Data Guard
8 5 (0.20%) Oracle RMAN
9 4 (0.16%) Kibana
9 4 (0.16%) Packer
9 4 (0.16%) Single Sign-On
10 3 (0.12%) Failover Clustering
10 3 (0.12%) Grafana
10 3 (0.12%) Microsoft Clustering
10 3 (0.12%) Prometheus
10 3 (0.12%) SCCM
Vendors
1 539 (21.47%) Microsoft
2 439 (17.48%) Oracle
3 269 (10.71%) Tableau
4 158 (6.29%) Informatica
5 144 (5.73%) SAP
6 116 (4.62%) Teradata
7 67 (2.67%) Talend
8 65 (2.59%) Ab Initio
9 60 (2.39%) Google
10 59 (2.35%) IBM
11 46 (1.83%) Cognos
12 44 (1.75%) MicroStrategy
13 41 (1.63%) Cloudera
14 33 (1.31%) Alteryx
15 32 (1.27%) Netezza
16 29 (1.15%) Salesforce.com
17 27 (1.08%) VMware
18 25 (1.00%) Hortonworks
18 25 (1.00%) Zend
19 22 (0.88%) Sybase