Period
to 19 April 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 19 April 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
19 Apr 2018
Same period 2017 Same period 2016
Rank 100 92 74
Rank change year-on-year -8 -18 -15
Contract jobs citing Data Warehouse 2,483 2,347 2,981
As % of all contract IT jobs advertised in the UK 2.46% 2.53% 2.79%
As % of the Database & Business Intelligence category 10.97% 11.26% 12.46%
Number of daily rates quoted 1,812 1,620 2,204
UK median daily rate £450 £438 £425
Median daily rate % change year-on-year +2.86% +2.94% -
10th Percentile £313 £306 £306
90th Percentile £600 £600 £613
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.25% - -
Number of hourly rates quoted 24 19 18
UK median hourly rate £26.55 £38.75 £26.46
Median hourly rate % change year-on-year -31.49% +46.43% -33.01%
10th Percentile £12.65 £24.46 £19.77
90th Percentile £68.13 £43.00 £62.65
UK excluding London median hourly rate £18.23 £38.75 £43.00
% change year-on-year -52.95% -9.88% +14.67%

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 22,636 20,842 23,919
As % of all contract IT jobs advertised in the UK 22.39% 22.49% 22.41%
Number of daily rates quoted 15,705 13,959 16,081
UK median daily rate £470 £438 £425
Median daily rate % change year-on-year +7.43% +2.94% +6.25%
10th Percentile £312 £290 £280
90th Percentile £625 £613 £600
UK excluding London median daily rate £413 £390 £375
% change year-on-year +5.77% +4.00% +2.04%
Number of hourly rates quoted 244 266 395
UK median hourly rate £34.25 £27.50 £25.44
Median hourly rate % change year-on-year +24.55% +8.10% -15.20%
10th Percentile £14.65 £9.94 £12.08
90th Percentile £54.63 £49.38 £52.50
UK excluding London median hourly rate £37.50 £25.00 £24.50
% change year-on-year +50.00% +2.04% -14.60%

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 19 April 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 19 April 2018.

Contractor 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 19 April 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 -12 2,244 £450 +2.27% 518
UK excluding London -3 1,244 £425 +6.25% 306
London -7 1,217 £500 +11.11% 241
South East -39 277 £425 - 68
North of England -22 246 £413 +10.00% 79
Midlands +10 229 £400 +2.89% 66
South West +12 166 £425 +5.59% 31
Scotland -12 143 £400 - 21
Yorkshire -1 116 £413 +10.00% 32
West Midlands -12 115 £425 +6.25% 32
North West -38 115 £400 +6.67% 40
East Midlands +27 114 £360 -2.04% 34
East of England +20 114 £400 -3.32% 32
Wales +10 55 £335 -4.29% 4
North East +25 22 £475 +5.56% 7
Northern Ireland +9 18 £432 +13.11% 5
Isle of Man - 8 £400 -

For the 6 months to 19 April 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,452 (58.48%) SQL
2 1,274 (51.31%) Business Intelligence
3 1,070 (43.09%) ETL
4 843 (33.95%) SQL Server
5 798 (32.14%) Agile Software Development
6 684 (27.55%) SQL Server Integration Services
7 677 (27.27%) Finance
8 629 (25.33%) Analytics
9 595 (23.96%) Data Modelling
10 531 (21.39%) Microsoft
11 495 (19.94%) Oracle
12 485 (19.53%) SQL Server Reporting Services
13 458 (18.45%) Big Data
14 388 (15.63%) SQL Server Analysis Services
15 342 (13.77%) Hadoop
16 335 (13.49%) Power BI
17 331 (13.33%) T-SQL
18 329 (13.25%) Analytical Skills
19 315 (12.69%) Microsoft Azure
20 295 (11.88%) Python
21 272 (10.95%) Migration
22 270 (10.87%) Tableau
23 264 (10.63%) Data Analysis
24 255 (10.27%) Relational Database
25 251 (10.11%) Apache Spark
26 250 (10.07%) Data Quality
27 246 (9.91%) Visualisation
28 217 (8.74%) Amazon AWS
29 216 (8.70%) Kimball Methodology
30 215 (8.66%) Data Integration

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 251 (10.11%) Apache Spark
2 115 (4.63%) SAS
3 71 (2.86%) Apache
4 61 (2.46%) SharePoint
5 46 (1.85%) Apache Pig
6 35 (1.41%) Confluence
7 18 (0.72%) Apache Airflow
8 16 (0.64%) Elasticsearch
9 15 (0.60%) Oracle Workflow
10 12 (0.48%) Apache Solr
11 10 (0.40%) SharePoint Server
11 10 (0.40%) Tomcat
12 9 (0.36%) WebSphere
13 7 (0.28%) WebSphere Application Server
14 5 (0.20%) IIS
14 5 (0.20%) PowerExchange
15 4 (0.16%) MS Exchange
15 4 (0.16%) SharePoint 2013
15 4 (0.16%) WebLogic
16 3 (0.12%) JBoss
Applications
1 141 (5.68%) Microsoft Excel
2 53 (2.13%) Microsoft PowerPoint
3 32 (1.29%) Microsoft Office
4 30 (1.21%) MS Visio
5 21 (0.85%) Microsoft Project
5 21 (0.85%) SPSS
6 16 (0.64%) Stata
7 15 (0.60%) Spreadsheet
8 1 (0.040%) Shockwave
Business Applications
1 18 (0.72%) Cognos Business Intelligence
2 16 (0.64%) Dynamics CRM
3 12 (0.48%) Dynamics AX
4 8 (0.32%) NetSuite
5 7 (0.28%) Markit EDM
5 7 (0.28%) Unit4 Business World
6 6 (0.24%) Dynamics NAV
6 6 (0.24%) Infor CRM
6 6 (0.24%) SAP ERP
7 5 (0.20%) Endur
7 5 (0.20%) Oracle EBS R12
7 5 (0.20%) Oracle Retail
7 5 (0.20%) Salesforce.com CRM
8 4 (0.16%) Oracle Receivables
9 3 (0.12%) Cognos Planning
9 3 (0.12%) Oracle EBS
10 2 (0.081%) Cognos TM1
10 2 (0.081%) Oracle Applications
10 2 (0.081%) Retail-J
10 2 (0.081%) SAP SRM
Cloud Services
1 315 (12.69%) Microsoft Azure
2 217 (8.74%) Amazon AWS
3 71 (2.86%) Azure Data Factory
4 61 (2.46%) Amazon S3
5 53 (2.13%) Google Cloud Platform
6 37 (1.49%) Amazon EMR
7 36 (1.45%) PaaS
8 26 (1.05%) Amazon Kinesis
9 25 (1.01%) Amazon EC2
10 24 (0.97%) Data Lake Analytics
10 24 (0.97%) SaaS
11 23 (0.93%) Serverless
12 21 (0.85%) Office 365
13 19 (0.77%) IaaS
14 16 (0.64%) GitHub
15 14 (0.56%) AWS Lambda
15 14 (0.56%) Google Analytics
16 13 (0.52%) Azure Machine Learning
17 12 (0.48%) Cloud Computing
18 7 (0.28%) Dynamics 365
Communications & Networking
1 13 (0.52%) Intranet
2 9 (0.36%) Internet
3 8 (0.32%) DNS
3 8 (0.32%) SMS
4 7 (0.28%) SAN
4 7 (0.28%) SSL
5 6 (0.24%) Kerberos
6 5 (0.20%) Firewall
7 4 (0.16%) DSL
7 4 (0.16%) Network Security
7 4 (0.16%) TCP/IP
7 4 (0.16%) VPN
8 3 (0.12%) DHCP
8 3 (0.12%) FTP
8 3 (0.12%) NAS
9 2 (0.081%) HTTP
9 2 (0.081%) MQTT
10 1 (0.040%) OpenLDAP
10 1 (0.040%) Radio Access Network
10 1 (0.040%) Skype
Database & Business Intelligence
1 843 (33.95%) SQL Server
2 684 (27.55%) SQL Server Integration Services
3 485 (19.53%) SQL Server Reporting Services
4 458 (18.45%) Big Data
5 388 (15.63%) SQL Server Analysis Services
6 342 (13.77%) Hadoop
7 335 (13.49%) Power BI
8 255 (10.27%) Relational Database
9 194 (7.81%) Data Lake
10 179 (7.21%) Apache Hive
11 152 (6.12%) OLAP
12 142 (5.72%) NoSQL
13 141 (5.68%) Enterprise Data Warehouse
14 136 (5.48%) SQL Server 2016
15 133 (5.36%) Oracle Database
16 121 (4.87%) QlikView
17 114 (4.59%) BusinessObjects
18 113 (4.55%) Star Schema
19 102 (4.11%) Amazon Redshift
20 97 (3.91%) SQL Server 2012
Development Applications
1 99 (3.99%) JIRA
2 78 (3.14%) Team Foundation Server
3 75 (3.02%) Git (software)
4 61 (2.46%) Jenkins
5 60 (2.42%) Visual Studio
6 41 (1.65%) ERwin
7 32 (1.29%) SQL Server Management Studio (SSMS)
8 23 (0.93%) TeamCity
9 21 (0.85%) Visual Studio Team System
10 19 (0.77%) Toad
11 14 (0.56%) Subversion
12 13 (0.52%) SpecFlow
13 11 (0.44%) JUnit
13 11 (0.44%) Octopus Deploy
13 11 (0.44%) PowerDesigner
13 11 (0.44%) RStudio
14 10 (0.40%) Oracle APEX
14 10 (0.40%) tSQLt
15 9 (0.36%) Eclipse
15 9 (0.36%) ER Studio
General
1 677 (27.27%) Finance
2 211 (8.50%) Banking
3 158 (6.36%) Retail
4 86 (3.46%) Marketing
5 48 (1.93%) Manufacturing
6 37 (1.49%) Investment Banking
7 36 (1.45%) Telecoms
8 31 (1.25%) Legal
9 24 (0.97%) Retail Banking
10 20 (0.81%) Law
11 18 (0.72%) Back Office
12 17 (0.68%) Games
13 16 (0.64%) Front Office
14 15 (0.60%) Advertising
14 15 (0.60%) Billing
14 15 (0.60%) Publishing
15 12 (0.48%) Pharmaceutical
16 10 (0.40%) Corporate Banking
17 9 (0.36%) Aerospace
18 8 (0.32%) General Ledger
Job Titles
1 1,014 (40.84%) Developer
2 404 (16.27%) Analyst
3 332 (13.37%) Business Intelligence Developer
4 323 (13.01%) Architect
5 299 (12.04%) SQL Developer
6 217 (8.74%) Data Engineer
7 206 (8.30%) Data Architect
8 150 (6.04%) Data Warehouse Developer
9 135 (5.44%) Data Analyst
10 132 (5.32%) Business Analyst
11 129 (5.20%) Consultant
12 122 (4.91%) ETL Developer
13 118 (4.75%) SSIS Developer
14 108 (4.35%) Business Intelligence Analyst
15 97 (3.91%) Project Manager
16 78 (3.14%) SQL BI Developer
17 66 (2.66%) Senior Developer
18 64 (2.58%) Solutions Architect
19 63 (2.54%) SSAS Developer
20 60 (2.42%) SSRS Developer
Libraries, Frameworks & Software Standards
1 183 (7.37%) .NET
2 130 (5.24%) Kafka
3 114 (4.59%) XML
4 81 (3.26%) MDX
5 79 (3.18%) Web Services
6 45 (1.81%) HTML
7 43 (1.73%) JSON
8 39 (1.57%) CSS
9 36 (1.45%) ASP.NET
10 28 (1.13%) .NET Framework
11 27 (1.09%) Spark Streaming
12 24 (0.97%) jQuery
13 21 (0.85%) REST
13 21 (0.85%) SOAP
14 20 (0.81%) Entity Framework
14 20 (0.81%) XSD
15 18 (0.72%) Middleware
15 18 (0.72%) RESTful
16 17 (0.68%) JMS
16 17 (0.68%) XML Schema
Miscellaneous
1 329 (13.25%) Analytical Skills
2 85 (3.42%) NHS
3 79 (3.18%) Management Information System
4 78 (3.14%) Greenfield Project
5 74 (2.98%) Data Structures
6 57 (2.30%) Computer Science
7 43 (1.73%) Self-Motivation
8 35 (1.41%) Credit Risk
8 35 (1.41%) User Experience
9 27 (1.09%) Fintech
9 27 (1.09%) Replication
10 25 (1.01%) Algorithms
10 25 (1.01%) Data Centre
11 22 (0.89%) Private Cloud
12 20 (0.81%) Reference Data
13 17 (0.68%) Clustering
14 16 (0.64%) Fixed Income
14 16 (0.64%) Mainframe
15 14 (0.56%) Mobile App
15 14 (0.56%) Reinsurance
Operating Systems
1 130 (5.24%) Unix
2 101 (4.07%) Linux
3 62 (2.50%) Windows
4 33 (1.33%) Windows Server
5 8 (0.32%) Red Hat Enterprise Linux
6 7 (0.28%) Windows Server 2012
7 6 (0.24%) Windows Server 2008
8 5 (0.20%) AIX
8 5 (0.20%) VMS
8 5 (0.20%) Windows XP
9 4 (0.16%) Windows Server 2003
10 3 (0.12%) CentOS
10 3 (0.12%) Windows 7
11 2 (0.081%) Windows 8
11 2 (0.081%) zOS
12 1 (0.040%) Android
12 1 (0.040%) Apple iOS
12 1 (0.040%) Oracle Linux
12 1 (0.040%) Solaris
12 1 (0.040%) Ubuntu
Processes & Methodologies
1 1,274 (51.31%) Business Intelligence
2 1,070 (43.09%) ETL
3 798 (32.14%) Agile Software Development
4 629 (25.33%) Analytics
5 595 (23.96%) Data Modelling
6 272 (10.95%) Migration
7 264 (10.63%) Data Analysis
8 246 (9.91%) Visualisation
9 216 (8.70%) Kimball Methodology
10 215 (8.66%) Data Integration
11 194 (7.81%) Scrum
12 193 (7.77%) Data Architecture
13 185 (7.45%) Data Management
14 181 (7.29%) Data Analytics
15 179 (7.21%) Problem-Solving
16 174 (7.01%) ETL Development
17 171 (6.89%) Performance Tuning
18 170 (6.85%) Stakeholder Management
19 161 (6.48%) Data Migration
20 149 (6.00%) Dimensional Modelling
Programming Languages
1 1,452 (58.48%) SQL
2 331 (13.33%) T-SQL
3 295 (11.88%) Python
4 199 (8.01%) Java
5 185 (7.45%) C#
6 148 (5.96%) PL/SQL
7 101 (4.07%) R
8 83 (3.34%) JavaScript
9 82 (3.30%) Shell Script
10 77 (3.10%) Scala
11 57 (2.30%) Data Analysis Expressions (DAX)
12 56 (2.26%) PowerShell
13 45 (1.81%) VBA
14 34 (1.37%) VB.NET
15 31 (1.25%) Bash Shell
16 25 (1.01%) PHP
17 24 (0.97%) Perl
18 20 (0.81%) C
19 17 (0.68%) U-SQL
20 14 (0.56%) C++
Qualifications
1 120 (4.83%) Security Cleared
2 95 (3.83%) Degree
3 90 (3.62%) SC Cleared
4 31 (1.25%) Microsoft Certification
5 20 (0.81%) ISTQB
6 18 (0.72%) Computer Science Degree
6 18 (0.72%) ISEB
7 16 (0.64%) MCSE
8 15 (0.60%) DV Cleared
9 14 (0.56%) MCSA
10 11 (0.44%) PMP
10 11 (0.44%) TOGAF Certification
11 10 (0.40%) BPSS Clearance
11 10 (0.40%) PMI Certification
12 9 (0.36%) DBS Check
13 6 (0.24%) Oracle Certification
14 5 (0.20%) ISTQB Foundation Certification
14 5 (0.20%) MCSD
14 5 (0.20%) Numerate Degree
14 5 (0.20%) PhD
Quality Assurance & Compliance
1 250 (10.07%) Data Quality
2 86 (3.46%) QA
3 58 (2.34%) PMO
4 57 (2.30%) GDPR
5 14 (0.56%) GCP
6 10 (0.40%) Disclosure Scotland
6 10 (0.40%) SLA
7 7 (0.28%) EMIR
7 7 (0.28%) IFRS
7 7 (0.28%) MiFID
8 6 (0.24%) Sarbanes-Oxley
9 5 (0.20%) WCAG
10 4 (0.16%) IFRS 9
10 4 (0.16%) ISO/IEC 20000
10 4 (0.16%) PCI DSS
11 3 (0.12%) Dodd-Frank
11 3 (0.12%) HL7
12 2 (0.081%) GxP
12 2 (0.081%) ISO 9001
12 2 (0.081%) Solvency II
System Software
1 66 (2.66%) Apache Flume
2 64 (2.58%) Docker
3 40 (1.61%) HDFS
4 16 (0.64%) Active Directory
4 16 (0.64%) Apache ZooKeeper
5 14 (0.56%) VMware Infrastructure
6 10 (0.40%) Hyper-V
7 7 (0.28%) Virtual Machines
8 5 (0.20%) Tivoli Workload Scheduler
9 4 (0.16%) vSphere
10 3 (0.12%) Virtual Servers
11 1 (0.040%) GPFS
11 1 (0.040%) Oracle RAC
11 1 (0.040%) Veritas Cluster Server
11 1 (0.040%) VMware ESXi
11 1 (0.040%) Xen
11 1 (0.040%) XenApp
Systems Management
1 94 (3.79%) Oozie
2 23 (0.93%) Ansible
2 23 (0.93%) Puppet
3 22 (0.89%) Terraform
4 17 (0.68%) Opscode Chef
5 12 (0.48%) Control-M
5 12 (0.48%) Hadoop YARN
6 10 (0.40%) Kubernetes
6 10 (0.40%) Systems Management Server (SMS)
7 7 (0.28%) Tivoli
8 6 (0.24%) Failover Clustering
8 6 (0.24%) Oracle Flashback
9 5 (0.20%) Ambari
9 5 (0.20%) HP Quality Center
9 5 (0.20%) Kibana
10 4 (0.16%) Consul
10 4 (0.16%) HP ALM
10 4 (0.16%) Packer
11 2 (0.081%) Nessus
11 2 (0.081%) SCVMM
Vendors
1 531 (21.39%) Microsoft
2 495 (19.94%) Oracle
3 270 (10.87%) Tableau
4 198 (7.97%) Informatica
5 159 (6.40%) SAP
6 117 (4.71%) IBM
7 110 (4.43%) Cognos
8 88 (3.54%) Talend
9 86 (3.46%) Teradata
10 77 (3.10%) Cloudera
11 67 (2.70%) Google
12 58 (2.34%) Salesforce.com
13 50 (2.01%) Hortonworks
14 32 (1.29%) Ab Initio
15 29 (1.17%) MicroStrategy
16 28 (1.13%) Capita
17 21 (0.85%) MapR
18 20 (0.81%) Netezza
19 18 (0.72%) VMware
20 15 (0.60%) RedGate