Period
to 19 September 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 19 September 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
19 Sep 2017
Same period 2016 Same period 2015
Rank 97 88 53
Rank change year-on-year -9 -35 +14
Contract jobs citing Data Warehouse 2459 2707 3913
As % of all contract IT jobs advertised in the UK 2.49% 2.53% 3.45%
As % of the Database & Business Intelligence category 11.09% 11.36% 14.83%
Number of daily rates quoted 1724 1919 2785
UK median daily rate £450 £425 £425
Median daily rate % change year-on-year +5.88% - +2.41%
10th Percentile £316 £300 £290
90th Percentile £588 £625 £599
UK excluding London median daily rate £425 £400 £390
% change year-on-year +6.25% +2.56% +4.00%
Number of hourly rates quoted 9 29 24
UK median hourly rate £27.00 £35.00 £32.75
Median hourly rate % change year-on-year -22.86% +6.87% -51.12%
10th Percentile £15.08 £14.25 £16.83
90th Percentile £50.60 £52.25 £57.50
UK excluding London median hourly rate £28.25 £32.50 £30.00
% change year-on-year -13.08% +8.33% -47.14%

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 22176 23820 26386
As % of all contract IT jobs advertised in the UK 22.47% 22.25% 23.27%
Number of daily rates quoted 14793 15997 17367
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +3.23%
10th Percentile £305 £281 £263
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 277 386 387
UK median hourly rate £29.50 £29.94 £28.50
Median hourly rate % change year-on-year -1.47% +5.05% +3.64%
10th Percentile £12.23 £11.25 £14.00
90th Percentile £53.75 £48.75 £52.80
UK excluding London median hourly rate £30.00 £28.50 £29.50
% change year-on-year +5.26% -3.39% +15.69%

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 September 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 19 September 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 19 September 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 -8 2271 £450 +2.86% 254
UK excluding London +10 1304 £425 +6.25% 156
London -10 1117 £475 - 121
South East +3 402 £438 +6.06% 28
North of England +25 303 £425 +9.68% 39
South West +10 179 £424 +16.97% 22
North West +30 175 £425 +9.68% 21
Midlands -32 159 £400 -6.98% 27
Scotland +15 126 £413 +3.13% 20
Yorkshire -17 114 £425 +6.25% 17
East of England -12 105 £450 - 16
West Midlands -29 95 £425 +3.66% 15
East Midlands -24 63 £400 -15.79% 12
Wales +2 27 £343 -8.67% 2
North East +58 26 £494 +39.08% 1
Northern Ireland -49 7 £438 +34.62% 1
Channel Islands - 1 £500 -

For the 6 months to 19 September 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 1364 (55.47%) SQL
2 1295 (52.66%) Business Intelligence
3 1056 (42.94%) ETL
4 757 (30.78%) SQL Server
5 696 (28.30%) Finance
6 674 (27.41%) Data Modelling
7 670 (27.25%) Agile Software Development
8 635 (25.82%) SQL Server Integration Services
9 498 (20.25%) SQL Server Reporting Services
10 489 (19.89%) Microsoft
11 479 (19.48%) Oracle
12 407 (16.55%) Analytics
13 367 (14.92%) SQL Server Analysis Services
14 345 (14.03%) T-SQL
15 326 (13.26%) Migration
16 302 (12.28%) Analytical Skills
17 296 (12.04%) Data Analysis
18 273 (11.10%) Big Data
19 268 (10.90%) Banking
20 243 (9.88%) Kimball Methodology
21 240 (9.76%) Power BI
22 231 (9.39%) Data Quality
23 226 (9.19%) Tableau
24 224 (9.11%) Hadoop
25 221 (8.99%) Data Management
26 218 (8.87%) Data Integration
27 205 (8.34%) Scrum
28 202 (8.21%) Visualisation
29 198 (8.05%) Relational Database
30 186 (7.56%) Data Migration

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 144 (5.86%) SAS
2 110 (4.47%) Apache Spark
3 58 (2.36%) SharePoint
4 37 (1.50%) Apache Pig
5 33 (1.34%) Apache
6 18 (0.73%) PowerExchange
7 17 (0.69%) Confluence
8 16 (0.65%) Oracle Workflow
9 14 (0.57%) Oracle SOA Suite
9 14 (0.57%) Tomcat
10 12 (0.49%) JBoss
11 10 (0.41%) ArcGIS
11 10 (0.41%) WildFly
12 9 (0.37%) Apache Solr
12 9 (0.37%) Oracle Coherence
12 9 (0.37%) WebLogic
13 8 (0.33%) Apache Airflow
13 8 (0.33%) Elasticsearch
13 8 (0.33%) IIS
13 8 (0.33%) WebSphere
Applications
1 126 (5.12%) Microsoft Excel
2 48 (1.95%) Microsoft Office
3 29 (1.18%) MS Visio
4 24 (0.98%) SPSS
5 15 (0.61%) Microsoft PowerPoint
6 14 (0.57%) Microsoft Project
7 13 (0.53%) Stata
8 11 (0.45%) Spreadsheet
9 2 (0.081%) Mingle
Business Applications
1 25 (1.02%) Cognos Business Intelligence
2 24 (0.98%) Markit EDM
3 11 (0.45%) Oracle EBS
4 9 (0.37%) Cognos TM1
4 9 (0.37%) Dynamics AX
5 8 (0.33%) Oracle BPM
5 8 (0.33%) SAP CRM
5 8 (0.33%) SAP IS-U
6 7 (0.28%) Eagle PACE
6 7 (0.28%) SAP ERP
7 6 (0.24%) Oracle Applications
8 5 (0.20%) Dynamics CRM
8 5 (0.20%) HFM
8 5 (0.20%) Oracle ERP
9 4 (0.16%) Dynamics GP
9 4 (0.16%) Oracle 11i
10 3 (0.12%) Hyperion Planning
10 3 (0.12%) Oracle Receivables
10 3 (0.12%) SAP BPC
10 3 (0.12%) thinkFolio
Cloud Services
1 181 (7.36%) Microsoft Azure
2 151 (6.14%) Amazon AWS
3 28 (1.14%) Amazon S3
4 22 (0.89%) Google Cloud Platform
5 18 (0.73%) Amazon EC2
5 18 (0.73%) Amazon EMR
6 17 (0.69%) Azure Data Factory
7 13 (0.53%) PaaS
8 12 (0.49%) SaaS
9 10 (0.41%) Amazon Kinesis
9 10 (0.41%) Google Analytics
9 10 (0.41%) IaaS
10 9 (0.37%) AWS Lambda
10 9 (0.37%) Data Lake Analytics
11 7 (0.28%) AWS CloudFormation
11 7 (0.28%) GitHub
12 6 (0.24%) Amazon SQS
13 5 (0.20%) Adobe Analytics
13 5 (0.20%) IBM Cloud
13 5 (0.20%) Office 365
Communications & Networking
1 18 (0.73%) Internet
2 8 (0.33%) LDAP
2 8 (0.33%) SMS
3 7 (0.28%) Kerberos
4 6 (0.24%) SAN
5 5 (0.20%) Firewall
5 5 (0.20%) MQTT
6 4 (0.16%) Intranet
6 4 (0.16%) Skype
7 3 (0.12%) DNS
7 3 (0.12%) HTTP
7 3 (0.12%) MVNO
7 3 (0.12%) NAS
7 3 (0.12%) VLAN
8 2 (0.081%) Extranet
8 2 (0.081%) FTP
8 2 (0.081%) TCP/IP
9 1 (0.041%) 4G
9 1 (0.041%) NetScaler
Database & Business Intelligence
1 757 (30.78%) SQL Server
2 635 (25.82%) SQL Server Integration Services
3 498 (20.25%) SQL Server Reporting Services
4 367 (14.92%) SQL Server Analysis Services
5 273 (11.10%) Big Data
6 240 (9.76%) Power BI
7 224 (9.11%) Hadoop
8 198 (8.05%) Relational Database
9 163 (6.63%) QlikView
10 157 (6.38%) Oracle Database
11 143 (5.82%) SQL Server 2012
12 140 (5.69%) BusinessObjects
13 123 (5.00%) Enterprise Data Warehouse
14 121 (4.92%) OLAP
15 111 (4.51%) SQL Server 2008
16 103 (4.19%) Oracle BI EE
17 101 (4.11%) RDBMS
18 100 (4.07%) Apache Hive
19 91 (3.70%) SQL Server 2014
19 91 (3.70%) SQL Server 2016
Development Applications
1 106 (4.31%) Team Foundation Server
2 88 (3.58%) JIRA
3 74 (3.01%) Talend Open Studio
4 49 (1.99%) Jenkins
5 48 (1.95%) Visual Studio
6 37 (1.50%) ERwin
7 33 (1.34%) Git (software)
8 31 (1.26%) Maven
9 27 (1.10%) JUnit
10 26 (1.06%) Eclipse
11 23 (0.94%) Toad
12 22 (0.89%) Subversion
13 18 (0.73%) Mockito
13 18 (0.73%) TeamCity
14 15 (0.61%) Oracle Forms
15 13 (0.53%) Octopus Deploy
15 13 (0.53%) SQL Server Management Studio (SSMS)
16 12 (0.49%) Selenium
17 10 (0.41%) Cucumber
17 10 (0.41%) PowerDesigner
General
1 696 (28.30%) Finance
2 268 (10.90%) Banking
3 136 (5.53%) Retail
4 96 (3.90%) Marketing
5 65 (2.64%) Investment Banking
6 64 (2.60%) Telecoms
7 47 (1.91%) Legal
8 39 (1.59%) Retail Banking
9 31 (1.26%) Publishing
10 26 (1.06%) Manufacturing
11 22 (0.89%) Front Office
12 20 (0.81%) Pharmaceutical
13 19 (0.77%) Back Office
14 18 (0.73%) Financial Institution
14 18 (0.73%) Games
15 13 (0.53%) Electronics
16 11 (0.45%) Advertising
16 11 (0.45%) Billing
17 8 (0.33%) Law
18 6 (0.24%) General Ledger
Job Titles
1 1012 (41.15%) Developer
2 481 (19.56%) Analyst
3 349 (14.19%) Business Intelligence Developer
4 288 (11.71%) SQL Developer
5 275 (11.18%) Architect
6 195 (7.93%) Data Architect
7 170 (6.91%) Data Warehouse Developer
8 160 (6.51%) Data Analyst
9 152 (6.18%) Business Analyst
10 142 (5.77%) SSIS Developer
11 141 (5.73%) ETL Developer
12 127 (5.16%) Consultant
13 103 (4.19%) Business Developer
14 102 (4.15%) Data Engineer
15 96 (3.90%) Business Intelligence Analyst
16 93 (3.78%) Project Manager
17 92 (3.74%) SQL BI Developer
18 91 (3.70%) SSRS Developer
19 71 (2.89%) Solutions Architect
20 68 (2.77%) Senior Developer
Libraries, Frameworks & Software Standards
1 127 (5.16%) .NET
2 114 (4.64%) MDX
3 108 (4.39%) XML
4 89 (3.62%) Web Services
5 45 (1.83%) Kafka
6 44 (1.79%) Entity Framework
7 43 (1.75%) .NET Framework
7 43 (1.75%) Spring
8 33 (1.34%) HTML
9 30 (1.22%) JSON
10 28 (1.14%) JMS
10 28 (1.14%) REST
11 26 (1.06%) J2EE
11 26 (1.06%) XSD
12 23 (0.94%) Hibernate
12 23 (0.94%) RESTful
13 21 (0.85%) WCF
14 18 (0.73%) AngularJS
14 18 (0.73%) ASP.NET
15 17 (0.69%) CSS
Miscellaneous
1 302 (12.28%) Analytical Skills
2 87 (3.54%) Management Information System
3 69 (2.81%) Computer Science
4 60 (2.44%) Algorithms
5 59 (2.40%) Data Structures
6 53 (2.16%) Greenfield Project
7 46 (1.87%) NHS
8 34 (1.38%) User Experience
9 33 (1.34%) Fixed Income
10 29 (1.18%) Private Cloud
11 26 (1.06%) Derivative
11 26 (1.06%) Replication
12 24 (0.98%) Equities
13 21 (0.85%) Enterprise Software
14 20 (0.81%) Credit Risk
15 15 (0.61%) Reinsurance
16 14 (0.57%) Data Centre
17 13 (0.53%) FMCG
18 12 (0.49%) Clustering
18 12 (0.49%) Reference Data
Operating Systems
1 117 (4.76%) Unix
2 106 (4.31%) Linux
3 78 (3.17%) Windows
4 25 (1.02%) Windows Server
5 12 (0.49%) Windows Server 2012
6 10 (0.41%) AIX
6 10 (0.41%) Red Hat Enterprise Linux
7 8 (0.33%) CentOS
8 6 (0.24%) Solaris
9 4 (0.16%) Oracle Linux
10 2 (0.081%) Windows Server 2008
11 1 (0.041%) Android
11 1 (0.041%) OpenVMS
11 1 (0.041%) VMS
11 1 (0.041%) Windows Vista
Processes & Methodologies
1 1295 (52.66%) Business Intelligence
2 1056 (42.94%) ETL
3 674 (27.41%) Data Modelling
4 670 (27.25%) Agile Software Development
5 407 (16.55%) Analytics
6 326 (13.26%) Migration
7 296 (12.04%) Data Analysis
8 243 (9.88%) Kimball Methodology
9 221 (8.99%) Data Management
10 218 (8.87%) Data Integration
11 205 (8.34%) Scrum
12 202 (8.21%) Visualisation
13 186 (7.56%) Data Migration
14 182 (7.40%) Stakeholder Management
15 181 (7.36%) Performance Tuning
16 165 (6.71%) Dimensional Modelling
17 138 (5.61%) Data Visualisation
18 136 (5.53%) Data Architecture
19 127 (5.16%) ETL Development
20 125 (5.08%) SDLC
Programming Languages
1 1364 (55.47%) SQL
2 345 (14.03%) T-SQL
3 175 (7.12%) Java
4 163 (6.63%) PL/SQL
5 144 (5.86%) Python
6 113 (4.60%) C#
7 71 (2.89%) R
8 66 (2.68%) Shell Script
9 61 (2.48%) JavaScript
10 59 (2.40%) PowerShell
11 57 (2.32%) Scala
12 46 (1.87%) Data Analysis Expressions (DAX)
13 30 (1.22%) VBA
14 28 (1.14%) C
15 26 (1.06%) Bash Shell
16 19 (0.77%) PHP
17 18 (0.73%) VBScript
18 17 (0.69%) SAS Macro
19 16 (0.65%) C++
20 14 (0.57%) MATLAB
Qualifications
1 138 (5.61%) Degree
2 88 (3.58%) Security Cleared
3 69 (2.81%) SC Cleared
4 36 (1.46%) ISEB
5 26 (1.06%) Computer Science Degree
6 24 (0.98%) ISTQB
7 15 (0.61%) Microsoft Certification
8 12 (0.49%) Master's Degree
9 11 (0.45%) MCITP
10 9 (0.37%) PMI Certification
10 9 (0.37%) PRINCE2 Certification
11 7 (0.28%) MCSE
12 6 (0.24%) CFA
12 6 (0.24%) Numerate Degree
13 5 (0.20%) HNC
13 5 (0.20%) HND
13 5 (0.20%) MCTS
14 4 (0.16%) CSQA
14 4 (0.16%) ISTQB Foundation Certification
14 4 (0.16%) PMP
Quality Assurance & Compliance
1 231 (9.39%) Data Quality
2 95 (3.86%) QA
3 23 (0.94%) GDPR
3 23 (0.94%) MiFID
4 18 (0.73%) EMIR
5 10 (0.41%) Disclosure Scotland
5 10 (0.41%) SLA
6 9 (0.37%) Actionable Recommendations
6 9 (0.37%) Solvency II
7 8 (0.33%) WCAG
8 5 (0.20%) GAAP
9 4 (0.16%) IFRS
9 4 (0.16%) PMO
10 3 (0.12%) Basel III
10 3 (0.12%) Dodd-Frank
10 3 (0.12%) FATCA
10 3 (0.12%) IFRS 9
11 2 (0.081%) ISO 20022
11 2 (0.081%) ISO/IEC 20000
11 2 (0.081%) PCI DSS
System Software
1 18 (0.73%) Apache Flume
2 14 (0.57%) Docker
3 11 (0.45%) HDFS
3 11 (0.45%) Oracle RAC
4 9 (0.37%) Active Directory
4 9 (0.37%) Virtual Machines
5 5 (0.20%) Tivoli Workload Scheduler
6 3 (0.12%) Cronacle
7 2 (0.081%) Hyper-V
7 2 (0.081%) VMware Infrastructure
7 2 (0.081%) XenApp
7 2 (0.081%) XenDesktop
8 1 (0.041%) ISA Server
8 1 (0.041%) Terminal Services
8 1 (0.041%) VMware ESXi
8 1 (0.041%) vSphere
Systems Management
1 31 (1.26%) Oozie
2 17 (0.69%) Hadoop YARN
3 16 (0.65%) Data Guard
4 14 (0.57%) Oracle RMAN
5 11 (0.45%) HP Quality Center
6 10 (0.41%) Control-M
7 9 (0.37%) Oracle EDQ
8 7 (0.28%) Puppet
9 6 (0.24%) Ansible
9 6 (0.24%) Opscode Chef
9 6 (0.24%) Terraform
10 5 (0.20%) Tivoli
11 4 (0.16%) Enterprise Manager Cloud Control
11 4 (0.16%) Failover Clustering
11 4 (0.16%) Oracle Enterprise Manager
12 3 (0.12%) Kubernetes
12 3 (0.12%) vRealize
13 2 (0.081%) Ambari
14 1 (0.041%) Kibana
14 1 (0.041%) Systems Management Server (SMS)
Vendors
1 489 (19.89%) Microsoft
2 479 (19.48%) Oracle
3 226 (9.19%) Tableau
4 180 (7.32%) Informatica
5 147 (5.98%) SAP
6 142 (5.77%) Teradata
7 94 (3.82%) IBM
8 92 (3.74%) Cognos
9 74 (3.01%) Talend
10 55 (2.24%) MicroStrategy
11 49 (1.99%) Netezza
12 36 (1.46%) Greenplum
13 30 (1.22%) Cloudera
13 30 (1.22%) Google
14 23 (0.94%) Hyperion
14 23 (0.94%) Salesforce.com
15 20 (0.81%) Hortonworks
15 20 (0.81%) HP
16 17 (0.69%) Ab Initio
17 16 (0.65%) Sybase