Period
to 23 January 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 23 January 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
23 Jan 2018
Same period 2017 Same period 2016
Rank 103 85 62
Rank change year-on-year -18 -23 +3
Contract jobs citing Data Warehouse 2,372 2,559 3,362
As % of all contract IT jobs advertised in the UK 2.36% 2.66% 3.14%
As % of the Database & Business Intelligence category 10.73% 11.79% 13.62%
Number of daily rates quoted 1,731 1,740 2,455
UK median daily rate £450 £425 £425
Median daily rate % change year-on-year +5.88% - +1.80%
10th Percentile £313 £300 £300
90th Percentile £600 £600 £588
UK excluding London median daily rate £413 £400 £400
% change year-on-year +3.13% - +4.75%
Number of hourly rates quoted 26 31 21
UK median hourly rate £26.80 £41.00 £26.93
Median hourly rate % change year-on-year -34.64% +52.27% -36.27%
10th Percentile £12.75 £21.69 £15.93
90th Percentile £53.00 £48.00 £62.50
UK excluding London median hourly rate £28.25 £40.50 £43.00
% change year-on-year -30.25% -5.81% +8.86%

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,103 21,697 24,676
As % of all contract IT jobs advertised in the UK 21.98% 22.57% 23.06%
Number of daily rates quoted 15,383 14,473 16,462
UK median daily rate £455 £425 £415
Median daily rate % change year-on-year +7.06% +2.41% +3.75%
10th Percentile £310 £288 £275
90th Percentile £625 £600 £588
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.23% +3.33% +7.14%
Number of hourly rates quoted 254 312 427
UK median hourly rate £30.63 £28.18 £30.00
Median hourly rate % change year-on-year +8.68% -6.07% +9.09%
10th Percentile £14.54 £10.05 £12.00
90th Percentile £56.41 £48.71 £52.50
UK excluding London median hourly rate £35.00 £26.50 £29.00
% change year-on-year +32.08% -8.62% +11.54%

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 23 January 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 23 January 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 23 January 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 -18 2,147 £450 +2.86% 625
UK excluding London -13 1,236 £413 +3.13% 394
London -17 1,111 £475 +3.26% 274
South East -27 294 £400 -5.88% 85
North of England -12 255 £415 +10.67% 110
South West +17 192 £425 +13.33% 50
Midlands -16 187 £400 - 72
Scotland +8 149 £413 +3.13% 29
North West -12 125 £425 +6.25% 68
East of England +13 119 £375 -6.25% 32
Yorkshire -18 117 £425 +15.25% 35
West Midlands -5 113 £425 +6.25% 36
East Midlands -12 74 £350 -14.63% 36
Wales +8 40 £322 -13.56% 14
North East +36 28 £460 +22.67% 7
Northern Ireland -20 10 - - 2
Isle of Man - 8 £400 -

For the 6 months to 23 January 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,373 (57.88%) SQL
2 1,272 (53.63%) Business Intelligence
3 1,049 (44.22%) ETL
4 846 (35.67%) SQL Server
5 720 (30.35%) SQL Server Integration Services
6 668 (28.16%) Agile Software Development
7 625 (26.35%) Finance
8 549 (23.15%) Data Modelling
9 515 (21.71%) SQL Server Reporting Services
10 493 (20.78%) Analytics
11 482 (20.32%) Microsoft
12 448 (18.89%) Oracle
13 383 (16.15%) SQL Server Analysis Services
14 340 (14.33%) Big Data
15 335 (14.12%) T-SQL
16 310 (13.07%) Analytical Skills
17 287 (12.10%) Migration
18 284 (11.97%) Power BI
19 262 (11.05%) Tableau
20 256 (10.79%) Data Analysis
21 244 (10.29%) Hadoop
22 233 (9.82%) Banking
23 226 (9.53%) Python
24 222 (9.36%) Kimball Methodology
25 219 (9.23%) Visualisation
25 219 (9.23%) Microsoft Azure
26 208 (8.77%) Relational Database
27 191 (8.05%) Data Management
27 191 (8.05%) Data Quality
28 186 (7.84%) 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 161 (6.79%) Apache Spark
2 127 (5.35%) SAS
3 72 (3.04%) SharePoint
4 29 (1.22%) Apache Pig
5 28 (1.18%) Apache
6 16 (0.67%) Apache Airflow
7 14 (0.59%) Confluence
8 13 (0.55%) Tomcat
9 12 (0.51%) IIS
9 12 (0.51%) WebSphere
10 11 (0.46%) Apache Solr
10 11 (0.46%) ArcGIS
11 9 (0.38%) WebLogic
11 9 (0.38%) WebSphere Application Server
11 9 (0.38%) WildFly
12 8 (0.34%) JBoss
12 8 (0.34%) SharePoint Server
13 4 (0.17%) PowerExchange
13 4 (0.17%) SharePoint 2013
14 3 (0.13%) Oracle SOA Suite
Applications
1 131 (5.52%) Microsoft Excel
2 32 (1.35%) Microsoft PowerPoint
3 31 (1.31%) Microsoft Office
4 28 (1.18%) MS Visio
5 15 (0.63%) Microsoft Project
5 15 (0.63%) SPSS
6 14 (0.59%) Spreadsheet
7 6 (0.25%) Stata
Business Applications
1 31 (1.31%) Cognos Business Intelligence
2 18 (0.76%) Dynamics CRM
3 17 (0.72%) Markit EDM
4 8 (0.34%) Dynamics AX
4 8 (0.34%) Endur
5 7 (0.30%) NetSuite
6 6 (0.25%) Cognos TM1
6 6 (0.25%) Oracle EBS
7 5 (0.21%) Dynamics NAV
7 5 (0.21%) Oracle EBS R12
7 5 (0.21%) Oracle Receivables
7 5 (0.21%) Unit4 Business World
8 4 (0.17%) Dynamics GP
8 4 (0.17%) Infor CRM
8 4 (0.17%) Salesforce.com CRM
8 4 (0.17%) SAP MDG
9 3 (0.13%) Cognos Planning
9 3 (0.13%) SAP ERP
9 3 (0.13%) SAP IS-U
9 3 (0.13%) thinkFolio
Cloud Services
1 219 (9.23%) Microsoft Azure
2 126 (5.31%) Amazon AWS
3 54 (2.28%) Google Cloud Platform
4 37 (1.56%) Amazon S3
5 24 (1.01%) Azure Data Factory
6 22 (0.93%) Office 365
7 21 (0.89%) Amazon EMR
8 20 (0.84%) IaaS
9 19 (0.80%) SaaS
10 18 (0.76%) PaaS
11 16 (0.67%) Data Lake Analytics
12 15 (0.63%) GitHub
13 13 (0.55%) Amazon EC2
14 11 (0.46%) Amazon Kinesis
15 9 (0.38%) Azure Machine Learning
16 7 (0.30%) Cloud Computing
17 5 (0.21%) Bluemix
17 5 (0.21%) IBM Cloud
18 4 (0.17%) OneDrive
18 4 (0.17%) Serverless
Communications & Networking
1 17 (0.72%) Internet
2 13 (0.55%) Intranet
3 9 (0.38%) Firewall
3 9 (0.38%) SMS
4 6 (0.25%) SAN
5 5 (0.21%) DNS
5 5 (0.21%) TCP/IP
6 4 (0.17%) Kerberos
6 4 (0.17%) SSL
7 3 (0.13%) NAS
8 2 (0.084%) FTP
8 2 (0.084%) HTTP
8 2 (0.084%) Network Security
8 2 (0.084%) VLAN
8 2 (0.084%) Wireshark
9 1 (0.042%) DHCP
9 1 (0.042%) Extranet
9 1 (0.042%) LAN
9 1 (0.042%) VPN
9 1 (0.042%) WAN
Database & Business Intelligence
1 846 (35.67%) SQL Server
2 720 (30.35%) SQL Server Integration Services
3 515 (21.71%) SQL Server Reporting Services
4 383 (16.15%) SQL Server Analysis Services
5 340 (14.33%) Big Data
6 284 (11.97%) Power BI
7 244 (10.29%) Hadoop
8 208 (8.77%) Relational Database
9 140 (5.90%) QlikView
10 131 (5.52%) BusinessObjects
10 131 (5.52%) Oracle Database
11 122 (5.14%) OLAP
12 120 (5.06%) SQL Server 2016
13 116 (4.89%) Apache Hive
14 115 (4.85%) Data Lake
15 113 (4.76%) SQL Server 2008
16 105 (4.43%) SQL Server 2012
17 103 (4.34%) RDBMS
18 102 (4.30%) Enterprise Data Warehouse
19 96 (4.05%) NoSQL
Development Applications
1 86 (3.63%) Team Foundation Server
2 55 (2.32%) JIRA
3 49 (2.07%) Git (software)
4 45 (1.90%) Visual Studio
5 40 (1.69%) ERwin
6 37 (1.56%) Jenkins
7 27 (1.14%) SQL Server Management Studio (SSMS)
8 21 (0.89%) Subversion
9 16 (0.67%) PowerDesigner
9 16 (0.67%) Toad
10 15 (0.63%) Eclipse
11 12 (0.51%) TeamCity
12 10 (0.42%) JUnit
13 9 (0.38%) Maven
14 8 (0.34%) Selenium
15 7 (0.30%) SoapUI
15 7 (0.30%) XMLSpy
16 6 (0.25%) JMeter
17 4 (0.17%) LoadRunner
17 4 (0.17%) Octopus Deploy
General
1 625 (26.35%) Finance
2 233 (9.82%) Banking
3 102 (4.30%) Retail
4 96 (4.05%) Marketing
5 45 (1.90%) Manufacturing
6 41 (1.73%) Telecoms
7 38 (1.60%) Investment Banking
7 38 (1.60%) Retail Banking
8 34 (1.43%) Legal
9 22 (0.93%) Advertising
10 20 (0.84%) Publishing
11 18 (0.76%) Pharmaceutical
12 17 (0.72%) Games
13 16 (0.67%) Front Office
14 11 (0.46%) Electronics
14 11 (0.46%) Law
15 9 (0.38%) Back Office
15 9 (0.38%) Billing
15 9 (0.38%) Financial Institution
16 8 (0.34%) French Language
Job Titles
1 994 (41.91%) Developer
2 451 (19.01%) Analyst
3 361 (15.22%) Business Intelligence Developer
4 301 (12.69%) SQL Developer
5 278 (11.72%) Architect
6 197 (8.31%) Data Architect
7 159 (6.70%) SSIS Developer
8 153 (6.45%) Data Analyst
9 152 (6.41%) Business Analyst
9 152 (6.41%) Data Warehouse Developer
10 138 (5.82%) Data Engineer
11 122 (5.14%) Business Intelligence Analyst
12 119 (5.02%) Consultant
13 103 (4.34%) Project Manager
14 99 (4.17%) ETL Developer
15 96 (4.05%) SQL BI Developer
16 84 (3.54%) SSAS Developer
17 79 (3.33%) Business Developer
17 79 (3.33%) SSRS Developer
18 76 (3.20%) Data Warehouse Analyst
Libraries, Frameworks & Software Standards
1 168 (7.08%) .NET
2 114 (4.81%) XML
3 101 (4.26%) MDX
4 91 (3.84%) Web Services
5 68 (2.87%) Kafka
6 40 (1.69%) .NET Framework
7 38 (1.60%) ASP.NET
8 35 (1.48%) Entity Framework
9 34 (1.43%) HTML
10 33 (1.39%) CSS
11 32 (1.35%) SOAP
12 31 (1.31%) JMS
13 29 (1.22%) PySpark
13 29 (1.22%) XSD
14 27 (1.14%) AngularJS
15 26 (1.10%) REST
16 25 (1.05%) Spring
17 21 (0.89%) JSON
17 21 (0.89%) Middleware
18 20 (0.84%) XML Schema
Miscellaneous
1 310 (13.07%) Analytical Skills
2 93 (3.92%) Greenfield Project
3 82 (3.46%) Management Information System
4 60 (2.53%) Computer Science
5 54 (2.28%) NHS
6 43 (1.81%) Data Structures
7 28 (1.18%) Replication
8 26 (1.10%) User Experience
9 24 (1.01%) Algorithms
10 21 (0.89%) Data Centre
11 18 (0.76%) Credit Risk
12 17 (0.72%) Reinsurance
13 15 (0.63%) Reference Data
14 14 (0.59%) Equities
14 14 (0.59%) Fintech
14 14 (0.59%) N-Tier
15 13 (0.55%) Enterprise Software
15 13 (0.55%) Fixed Income
16 12 (0.51%) Mobile App
17 11 (0.46%) Social Media
Operating Systems
1 115 (4.85%) Unix
2 102 (4.30%) Linux
3 59 (2.49%) Windows
4 24 (1.01%) Windows Server
5 12 (0.51%) Red Hat Enterprise Linux
6 8 (0.34%) AIX
6 8 (0.34%) CentOS
7 5 (0.21%) Windows Server 2012
8 3 (0.13%) VMS
8 3 (0.13%) Windows Server 2008
9 2 (0.084%) Oracle Linux
9 2 (0.084%) Windows 7
9 2 (0.084%) Windows XP
9 2 (0.084%) zOS
10 1 (0.042%) Ubuntu
Processes & Methodologies
1 1,272 (53.63%) Business Intelligence
2 1,049 (44.22%) ETL
3 668 (28.16%) Agile Software Development
4 549 (23.15%) Data Modelling
5 493 (20.78%) Analytics
6 287 (12.10%) Migration
7 256 (10.79%) Data Analysis
8 222 (9.36%) Kimball Methodology
9 219 (9.23%) Visualisation
10 191 (8.05%) Data Management
11 186 (7.84%) Data Integration
12 184 (7.76%) Scrum
13 169 (7.12%) Stakeholder Management
14 157 (6.62%) Data Migration
15 142 (5.99%) Data Analytics
16 141 (5.94%) Data Architecture
17 138 (5.82%) Dimensional Modelling
17 138 (5.82%) ETL Development
18 130 (5.48%) Performance Tuning
19 118 (4.97%) SDLC
Programming Languages
1 1,373 (57.88%) SQL
2 335 (14.12%) T-SQL
3 226 (9.53%) Python
4 163 (6.87%) Java
5 154 (6.49%) C#
6 132 (5.56%) PL/SQL
7 91 (3.84%) R
8 77 (3.25%) Shell Script
9 67 (2.82%) JavaScript
10 50 (2.11%) PowerShell
11 44 (1.85%) Data Analysis Expressions (DAX)
12 42 (1.77%) VBA
13 38 (1.60%) Scala
14 26 (1.10%) Perl
15 24 (1.01%) Bash Shell
16 18 (0.76%) VB.NET
17 15 (0.63%) C
17 15 (0.63%) VBScript
18 14 (0.59%) VB
19 12 (0.51%) C++
Qualifications
1 114 (4.81%) Degree
2 88 (3.71%) Security Cleared
3 64 (2.70%) SC Cleared
4 22 (0.93%) Microsoft Certification
5 21 (0.89%) ISEB
6 19 (0.80%) Computer Science Degree
7 17 (0.72%) ISTQB
8 12 (0.51%) MCSE
9 11 (0.46%) BPSS Clearance
9 11 (0.46%) PMI Certification
10 9 (0.38%) MCSA
10 9 (0.38%) PMP
11 7 (0.30%) ISTQB Foundation Certification
12 6 (0.25%) Numerate Degree
13 5 (0.21%) ITIL Certification
13 5 (0.21%) PRINCE2 Practitioner
14 4 (0.17%) Oracle Certification
14 4 (0.17%) PhD
14 4 (0.17%) Postgraduate
14 4 (0.17%) PRINCE2 Certification
Quality Assurance & Compliance
1 191 (8.05%) Data Quality
2 96 (4.05%) QA
3 41 (1.73%) GDPR
4 17 (0.72%) PMO
5 14 (0.59%) MiFID
6 11 (0.46%) SLA
7 10 (0.42%) EMIR
8 9 (0.38%) Disclosure Scotland
9 8 (0.34%) IFRS
10 6 (0.25%) Solvency II
11 5 (0.21%) Actionable Recommendations
11 5 (0.21%) IFRS 9
12 4 (0.17%) ISO/IEC 20000
13 3 (0.13%) Dodd-Frank
13 3 (0.13%) GAAP
13 3 (0.13%) HL7
14 2 (0.084%) 21 CFR Part 11
14 2 (0.084%) GCP
14 2 (0.084%) ISO 20022
14 2 (0.084%) Sarbanes-Oxley
System Software
1 41 (1.73%) Apache Flume
2 39 (1.64%) HDFS
3 35 (1.48%) Docker
4 14 (0.59%) VMware Infrastructure
5 11 (0.46%) Active Directory
6 10 (0.42%) Virtual Machines
7 8 (0.34%) Oracle RAC
8 3 (0.13%) Apache ZooKeeper
8 3 (0.13%) Cronacle
8 3 (0.13%) Hyper-V
8 3 (0.13%) Tivoli Workload Scheduler
9 2 (0.084%) VMware ESXi
10 1 (0.042%) ISA Server
10 1 (0.042%) Terminal Services
10 1 (0.042%) VMware Server
10 1 (0.042%) vSphere
10 1 (0.042%) XenApp
10 1 (0.042%) XenDesktop
Systems Management
1 47 (1.98%) Oozie
2 21 (0.89%) Ansible
3 20 (0.84%) Ambari
4 19 (0.80%) Hadoop YARN
4 19 (0.80%) Puppet
5 18 (0.76%) Data Guard
6 14 (0.59%) Oracle RMAN
7 13 (0.55%) Control-M
7 13 (0.55%) Opscode Chef
7 13 (0.55%) Terraform
8 12 (0.51%) Oracle EDQ
9 11 (0.46%) Systems Management Server (SMS)
10 10 (0.42%) Kubernetes
11 3 (0.13%) Rundeck
11 3 (0.13%) Tivoli
12 2 (0.084%) Enterprise Manager Cloud Control
12 2 (0.084%) Mesos
12 2 (0.084%) Oracle Enterprise Manager
12 2 (0.084%) Packer
13 1 (0.042%) Failover Clustering
Vendors
1 482 (20.32%) Microsoft
2 448 (18.89%) Oracle
3 262 (11.05%) Tableau
4 160 (6.75%) Informatica
5 141 (5.94%) SAP
6 107 (4.51%) IBM
7 94 (3.96%) Cognos
8 89 (3.75%) Teradata
9 48 (2.02%) Salesforce.com
10 47 (1.98%) Google
11 42 (1.77%) Hortonworks
12 39 (1.64%) Netezza
13 35 (1.48%) Talend
14 34 (1.43%) Cloudera
15 32 (1.35%) MicroStrategy
16 22 (0.93%) VMware
17 20 (0.84%) Capita
18 19 (0.80%) MuleSoft
19 16 (0.67%) Ab Initio
19 16 (0.67%) Alteryx