Period
to 21 November 2017

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 21 November 2017 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
21 Nov 2017
Same period 2016 Same period 2015
Rank 103 86 55
Rank change year-on-year -17 -31 +10
Contract jobs citing Data Warehouse 2431 2844 3782
As % of all contract IT jobs advertised in the UK 2.36% 2.72% 3.33%
As % of the Database & Business Intelligence category 10.67% 12.02% 14.31%
Number of daily rates quoted 1726 1954 2704
UK median daily rate £450 £433 £425
Median daily rate % change year-on-year +4.05% +1.76% +2.41%
10th Percentile £313 £305 £289
90th Percentile £600 £600 £588
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.25% - +6.67%
Number of hourly rates quoted 20 27 19
UK median hourly rate £27.50 £42.00 £25.44
Median hourly rate % change year-on-year -34.52% +65.09% -45.29%
10th Percentile £14.48 £15.71 £15.34
90th Percentile £53.20 £52.25 £35.74
UK excluding London median hourly rate £35.00 £35.00 £28.75
% change year-on-year - +21.74% -30.93%

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 22785 23660 26437
As % of all contract IT jobs advertised in the UK 22.09% 22.59% 23.28%
Number of daily rates quoted 15575 15682 17425
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +0.63%
10th Percentile £310 £285 £269
90th Percentile £625 £600 £575
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 288 368 408
UK median hourly rate £31.23 £28.00 £28.50
Median hourly rate % change year-on-year +11.54% -1.75% +14.00%
10th Percentile £14.00 £10.00 £12.00
90th Percentile £57.44 £52.05 £52.47
UK excluding London median hourly rate £35.00 £28.00 £30.00
% change year-on-year +25.00% -6.67% +31.32%

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 21 November 2017.

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 21 November 2017.

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 21 November 2017. 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 -19 2222 £450 +2.86% 271
UK excluding London -11 1315 £425 +6.25% 176
London -26 1081 £475 - 115
South East -13 369 £413 -0.60% 38
North of England 0 294 £425 +13.33% 68
South West +16 194 £425 +13.33% 15
Midlands -34 162 £400 -3.03% 17
North West +9 159 £444 +14.52% 31
Scotland -8 135 £413 +3.13% 22
East of England -1 126 £375 -7.98% 15
Yorkshire -13 120 £425 +13.33% 27
West Midlands -24 94 £450 +10.77% 14
East Midlands -26 68 £375 -9.09% 3
Wales +4 39 £322 -14.13% 1
North East +53 33 £475 +26.67% 10
Northern Ireland -39 9 £306 -
Channel Islands - 1 £500 -

For the 6 months to 21 November 2017, IT contractor jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for Data Warehouse.

1 1404 (57.75%) SQL
2 1323 (54.42%) Business Intelligence
3 1055 (43.40%) ETL
4 842 (34.64%) SQL Server
5 719 (29.58%) SQL Server Integration Services
6 679 (27.93%) Agile Software Development
7 658 (27.07%) Finance
8 602 (24.76%) Data Modelling
9 529 (21.76%) SQL Server Reporting Services
10 497 (20.44%) Microsoft
11 481 (19.79%) Oracle
12 417 (17.15%) Analytics
13 401 (16.50%) SQL Server Analysis Services
14 366 (15.06%) T-SQL
15 310 (12.75%) Analytical Skills
16 306 (12.59%) Migration
17 293 (12.05%) Big Data
18 283 (11.64%) Power BI
19 262 (10.78%) Kimball Methodology
20 260 (10.70%) Data Analysis
21 256 (10.53%) Banking
22 248 (10.20%) Tableau
23 221 (9.09%) Hadoop
24 213 (8.76%) Data Management
25 207 (8.52%) Data Integration
26 203 (8.35%) Data Quality
27 200 (8.23%) Scrum
28 199 (8.19%) Visualisation
29 198 (8.14%) Relational Database
30 195 (8.02%) Microsoft Azure

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 138 (5.68%) Apache Spark
2 132 (5.43%) SAS
3 55 (2.26%) SharePoint
4 26 (1.07%) Apache Pig
5 23 (0.95%) Apache
6 17 (0.70%) Confluence
6 17 (0.70%) IIS
7 15 (0.62%) Apache Airflow
8 14 (0.58%) PowerExchange
9 11 (0.45%) Apache Solr
9 11 (0.45%) ArcGIS
9 11 (0.45%) Tomcat
9 11 (0.45%) WebLogic
10 10 (0.41%) Oracle SOA Suite
10 10 (0.41%) Oracle Workflow
10 10 (0.41%) WebSphere
11 9 (0.37%) JBoss
11 9 (0.37%) WildFly
12 6 (0.25%) Elasticsearch
12 6 (0.25%) WebSphere Application Server
Applications
1 124 (5.10%) Microsoft Excel
2 34 (1.40%) Microsoft Office
3 31 (1.28%) MS Visio
4 12 (0.49%) Microsoft PowerPoint
5 10 (0.41%) Microsoft Project
5 10 (0.41%) Spreadsheet
5 10 (0.41%) SPSS
6 3 (0.12%) Stata
7 1 (0.041%) Mingle
Business Applications
1 35 (1.44%) Cognos Business Intelligence
2 22 (0.90%) Markit EDM
3 13 (0.53%) Dynamics CRM
4 8 (0.33%) Cognos TM1
4 8 (0.33%) Dynamics AX
4 8 (0.33%) Oracle EBS
4 8 (0.33%) SAP CRM
5 7 (0.29%) SAP IS-U
6 6 (0.25%) Oracle BPM
7 5 (0.21%) Oracle ERP
7 5 (0.21%) Oracle Receivables
8 4 (0.16%) Dynamics GP
8 4 (0.16%) Endur
8 4 (0.16%) Oracle iProcurement
8 4 (0.16%) SAP ERP
9 3 (0.12%) Cognos Planning
9 3 (0.12%) Dynamics NAV
9 3 (0.12%) Eagle PACE
9 3 (0.12%) Oracle 11i
9 3 (0.12%) thinkFolio
Cloud Services
1 195 (8.02%) Microsoft Azure
2 137 (5.64%) Amazon AWS
3 43 (1.77%) Google Cloud Platform
4 31 (1.28%) Amazon S3
5 27 (1.11%) Amazon EMR
6 22 (0.90%) Azure Data Factory
7 21 (0.86%) IaaS
8 19 (0.78%) PaaS
9 17 (0.70%) Amazon EC2
10 16 (0.66%) Amazon Kinesis
10 16 (0.66%) SaaS
11 14 (0.58%) Data Lake Analytics
11 14 (0.58%) GitHub
12 12 (0.49%) Office 365
13 7 (0.29%) Azure Machine Learning
14 6 (0.25%) AWS CloudFormation
14 6 (0.25%) IBM Cloud
15 5 (0.21%) AWS Lambda
15 5 (0.21%) Bluemix
15 5 (0.21%) Serverless
Communications & Networking
1 17 (0.70%) Internet
2 11 (0.45%) SMS
3 9 (0.37%) Firewall
4 7 (0.29%) Intranet
4 7 (0.29%) SAN
5 5 (0.21%) LDAP
6 4 (0.16%) DNS
6 4 (0.16%) HTTP
6 4 (0.16%) Kerberos
6 4 (0.16%) TCP/IP
7 3 (0.12%) NAS
7 3 (0.12%) VLAN
8 2 (0.082%) Extranet
8 2 (0.082%) FTP
8 2 (0.082%) Network Security
8 2 (0.082%) Wireshark
9 1 (0.041%) MQTT
9 1 (0.041%) NetScaler
9 1 (0.041%) SSL
Database & Business Intelligence
1 842 (34.64%) SQL Server
2 719 (29.58%) SQL Server Integration Services
3 529 (21.76%) SQL Server Reporting Services
4 401 (16.50%) SQL Server Analysis Services
5 293 (12.05%) Big Data
6 283 (11.64%) Power BI
7 221 (9.09%) Hadoop
8 198 (8.14%) Relational Database
9 149 (6.13%) Oracle Database
10 146 (6.01%) QlikView
11 141 (5.80%) OLAP
12 136 (5.59%) BusinessObjects
12 136 (5.59%) SQL Server 2012
13 118 (4.85%) Apache Hive
13 118 (4.85%) SQL Server 2008
14 114 (4.69%) SQL Server 2016
15 107 (4.40%) SQL Server 2014
16 101 (4.15%) Enterprise Data Warehouse
16 101 (4.15%) RDBMS
17 97 (3.99%) Oracle BI EE
Development Applications
1 100 (4.11%) Team Foundation Server
2 68 (2.80%) JIRA
3 61 (2.51%) Talend Open Studio
4 51 (2.10%) Visual Studio
5 43 (1.77%) Git (software)
6 42 (1.73%) Jenkins
7 40 (1.65%) ERwin
8 29 (1.19%) Subversion
9 24 (0.99%) Eclipse
10 20 (0.82%) Maven
10 20 (0.82%) SQL Server Management Studio (SSMS)
11 17 (0.70%) Toad
12 15 (0.62%) JUnit
13 11 (0.45%) PowerDesigner
13 11 (0.45%) TeamCity
14 10 (0.41%) Mockito
15 9 (0.37%) Octopus Deploy
16 8 (0.33%) Selenium
17 7 (0.29%) Ant
17 7 (0.29%) Oracle APEX
General
1 658 (27.07%) Finance
2 256 (10.53%) Banking
3 93 (3.83%) Marketing
4 92 (3.78%) Retail
5 50 (2.06%) Investment Banking
6 49 (2.02%) Retail Banking
6 49 (2.02%) Telecoms
7 41 (1.69%) Legal
8 26 (1.07%) Manufacturing
9 25 (1.03%) Pharmaceutical
9 25 (1.03%) Publishing
10 18 (0.74%) Back Office
10 18 (0.74%) Games
11 16 (0.66%) Advertising
11 16 (0.66%) Front Office
12 14 (0.58%) Financial Institution
13 11 (0.45%) Electronics
14 9 (0.37%) Law
15 7 (0.29%) General Ledger
16 5 (0.21%) Private Banking
Job Titles
1 1014 (41.71%) Developer
2 463 (19.05%) Analyst
3 371 (15.26%) Business Intelligence Developer
4 322 (13.25%) SQL Developer
5 279 (11.48%) Architect
6 210 (8.64%) Data Architect
7 166 (6.83%) SSIS Developer
8 157 (6.46%) Data Analyst
9 151 (6.21%) Business Analyst
10 146 (6.01%) Data Warehouse Developer
11 135 (5.55%) Consultant
12 129 (5.31%) ETL Developer
13 116 (4.77%) Data Engineer
14 114 (4.69%) Business Intelligence Analyst
15 102 (4.20%) Project Manager
15 102 (4.20%) SQL BI Developer
16 91 (3.74%) Business Developer
17 87 (3.58%) SSAS Developer
18 83 (3.41%) SSRS Developer
19 74 (3.04%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 146 (6.01%) .NET
2 126 (5.18%) MDX
2 126 (5.18%) XML
3 97 (3.99%) Web Services
4 67 (2.76%) Kafka
5 43 (1.77%) .NET Framework
6 37 (1.52%) Entity Framework
7 36 (1.48%) Spring
8 34 (1.40%) HTML
8 34 (1.40%) REST
9 32 (1.32%) JMS
10 31 (1.28%) PySpark
11 30 (1.23%) AngularJS
12 29 (1.19%) XSD
13 28 (1.15%) CSS
14 27 (1.11%) JSON
15 26 (1.07%) ASP.NET
16 24 (0.99%) Hibernate
16 24 (0.99%) SOAP
17 19 (0.78%) RESTful
Miscellaneous
1 310 (12.75%) Analytical Skills
2 86 (3.54%) Management Information System
3 77 (3.17%) Greenfield Project
4 51 (2.10%) Data Structures
5 50 (2.06%) Computer Science
6 46 (1.89%) Algorithms
7 41 (1.69%) NHS
8 30 (1.23%) Fixed Income
9 29 (1.19%) Equities
9 29 (1.19%) User Experience
10 24 (0.99%) Replication
11 23 (0.95%) Credit Risk
12 20 (0.82%) Derivative
13 19 (0.78%) Enterprise Software
14 18 (0.74%) Data Centre
15 16 (0.66%) Reinsurance
16 14 (0.58%) Reference Data
17 13 (0.53%) N-Tier
18 12 (0.49%) Clustering
18 12 (0.49%) Fintech
Operating Systems
1 114 (4.69%) Unix
2 110 (4.52%) Linux
3 70 (2.88%) Windows
4 18 (0.74%) Windows Server
5 13 (0.53%) Red Hat Enterprise Linux
6 11 (0.45%) AIX
7 9 (0.37%) CentOS
8 4 (0.16%) Oracle Linux
8 4 (0.16%) Windows Server 2012
9 3 (0.12%) VMS
10 2 (0.082%) Windows Server 2008
11 1 (0.041%) Android
11 1 (0.041%) OpenVMS
Processes & Methodologies
1 1323 (54.42%) Business Intelligence
2 1055 (43.40%) ETL
3 679 (27.93%) Agile Software Development
4 602 (24.76%) Data Modelling
5 417 (17.15%) Analytics
6 306 (12.59%) Migration
7 262 (10.78%) Kimball Methodology
8 260 (10.70%) Data Analysis
9 213 (8.76%) Data Management
10 207 (8.52%) Data Integration
11 200 (8.23%) Scrum
12 199 (8.19%) Visualisation
13 179 (7.36%) Dimensional Modelling
14 173 (7.12%) Stakeholder Management
15 165 (6.79%) Data Migration
16 157 (6.46%) Performance Tuning
17 139 (5.72%) Data Architecture
18 135 (5.55%) SDLC
19 129 (5.31%) ETL Development
20 117 (4.81%) Business Analysis
Programming Languages
1 1404 (57.75%) SQL
2 366 (15.06%) T-SQL
3 187 (7.69%) Python
4 176 (7.24%) Java
5 158 (6.50%) PL/SQL
6 146 (6.01%) C#
7 75 (3.09%) Shell Script
8 67 (2.76%) R
9 65 (2.67%) PowerShell
10 62 (2.55%) JavaScript
11 61 (2.51%) Data Analysis Expressions (DAX)
12 43 (1.77%) Scala
13 35 (1.44%) VBA
14 23 (0.95%) Bash Shell
15 20 (0.82%) VBScript
16 19 (0.78%) SAS Macro
17 18 (0.74%) C
18 17 (0.70%) Perl
19 15 (0.62%) C++
20 14 (0.58%) AWK
Qualifications
1 109 (4.48%) Degree
2 88 (3.62%) Security Cleared
3 62 (2.55%) SC Cleared
4 35 (1.44%) ISEB
5 25 (1.03%) ISTQB
6 18 (0.74%) Microsoft Certification
7 16 (0.66%) Computer Science Degree
8 11 (0.45%) PMI Certification
9 10 (0.41%) MCITP
10 9 (0.37%) MCSE
10 9 (0.37%) PMP
11 7 (0.29%) BPSS Clearance
11 7 (0.29%) CFA
11 7 (0.29%) ISTQB Foundation Certification
11 7 (0.29%) Master's Degree
11 7 (0.29%) PRINCE2 Certification
12 5 (0.21%) Postgraduate
13 4 (0.16%) ITIL Certification
13 4 (0.16%) MCTS
14 3 (0.12%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 203 (8.35%) Data Quality
2 79 (3.25%) QA
3 42 (1.73%) GDPR
4 20 (0.82%) MiFID
5 11 (0.45%) Solvency II
6 9 (0.37%) Actionable Recommendations
6 9 (0.37%) Disclosure Scotland
6 9 (0.37%) EMIR
6 9 (0.37%) SLA
7 5 (0.21%) GAAP
7 5 (0.21%) IFRS
8 4 (0.16%) IFRS 9
9 3 (0.12%) FATCA
10 2 (0.082%) 21 CFR Part 11
10 2 (0.082%) Dodd-Frank
10 2 (0.082%) GCP
10 2 (0.082%) GxP
10 2 (0.082%) ISO 20022
10 2 (0.082%) PMO
10 2 (0.082%) WCAG
System Software
1 30 (1.23%) Apache Flume
2 29 (1.19%) HDFS
3 18 (0.74%) Docker
4 14 (0.58%) Virtual Machines
5 12 (0.49%) Active Directory
6 11 (0.45%) VMware Infrastructure
7 10 (0.41%) Oracle RAC
8 5 (0.21%) Tivoli Workload Scheduler
9 3 (0.12%) Cronacle
10 2 (0.082%) VMware ESXi
10 2 (0.082%) XenApp
10 2 (0.082%) XenDesktop
11 1 (0.041%) Apache ZooKeeper
11 1 (0.041%) Hyper-V
11 1 (0.041%) ISA Server
11 1 (0.041%) Terminal Services
11 1 (0.041%) VMware Server
Systems Management
1 52 (2.14%) Oozie
2 20 (0.82%) Ambari
2 20 (0.82%) Data Guard
2 20 (0.82%) Hadoop YARN
3 16 (0.66%) Control-M
4 14 (0.58%) Oracle RMAN
5 12 (0.49%) Ansible
5 12 (0.49%) Oracle EDQ
6 9 (0.37%) Puppet
6 9 (0.37%) Systems Management Server (SMS)
7 8 (0.33%) Terraform
8 7 (0.29%) Kubernetes
8 7 (0.29%) Opscode Chef
9 5 (0.21%) HP Quality Center
9 5 (0.21%) Tivoli
10 3 (0.12%) Enterprise Manager Cloud Control
10 3 (0.12%) Failover Clustering
10 3 (0.12%) Oracle Enterprise Manager
10 3 (0.12%) Rundeck
11 2 (0.082%) Mesos
Vendors
1 497 (20.44%) Microsoft
2 481 (19.79%) Oracle
3 248 (10.20%) Tableau
4 171 (7.03%) Informatica
5 128 (5.27%) SAP
6 121 (4.98%) Teradata
7 117 (4.81%) IBM
8 96 (3.95%) Cognos
9 61 (2.51%) Talend
10 52 (2.14%) Netezza
11 46 (1.89%) Salesforce.com
12 38 (1.56%) Google
12 38 (1.56%) MicroStrategy
13 26 (1.07%) Cloudera
14 24 (0.99%) HP
15 23 (0.95%) Hortonworks
16 22 (0.90%) Greenplum
17 19 (0.78%) VMware
18 16 (0.66%) Hyperion
19 15 (0.62%) Ab Initio