Period
to 21 January 2019

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 January 2019 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 Jan 2019
Same period 2018 Same period 2017
Rank 101 104 87
Rank change year-on-year +3 -17 -24
Contract jobs citing Data Warehouse 2,475 2,329 2,563
As % of all contract IT jobs advertised in the UK 2.50% 2.36% 2.67%
As % of the Database & Business Intelligence category 11.15% 10.72% 11.82%
Number of daily rates quoted 1,724 1,704 1,744
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% -
10th Percentile £325 £313 £300
90th Percentile £625 £600 £600
UK excluding London median daily rate £438 £413 £400
% change year-on-year +6.06% +3.13% -
Number of hourly rates quoted 27 26 31
UK median hourly rate £18.50 £26.80 £41.00
Median hourly rate % change year-on-year -30.96% -34.64% +27.13%
10th Percentile £12.50 £12.75 £21.69
90th Percentile £49.84 £53.00 £48.00
UK excluding London median hourly rate £17.91 £28.25 £40.50
% change year-on-year -36.61% -30.25% -5.81%

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,200 21,719 21,681
As % of all contract IT jobs advertised in the UK 22.46% 21.99% 22.57%
Number of daily rates quoted 15,300 15,116 14,454
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +2.41%
10th Percentile £319 £310 £288
90th Percentile £644 £625 £600
UK excluding London median daily rate £425 £400 £388
% change year-on-year +6.25% +3.23% +3.33%
Number of hourly rates quoted 243 250 313
UK median hourly rate £32.50 £30.63 £28.00
Median hourly rate % change year-on-year +6.12% +9.38% -6.67%
10th Percentile £13.34 £14.54 £10.00
90th Percentile £57.06 £55.72 £48.30
UK excluding London median hourly rate £32.75 £35.00 £26.50
% change year-on-year -6.43% +32.08% -8.62%

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 January 2019.

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 January 2019.

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 21 January 2019. 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 +5 2,289 £455 +1.11% 675
UK excluding London -8 1,259 £438 +6.06% 430
London +15 1,192 £500 +5.26% 294
South East -3 305 £450 +12.50% 115
North of England +9 301 £400 -5.88% 122
South West -27 186 £438 +2.94% 40
Midlands -8 167 £425 +6.25% 70
Yorkshire +13 151 £400 -5.88% 46
East of England +22 133 £450 +24.14% 34
North West -4 120 £400 -5.88% 71
Scotland -21 116 £425 +1.49% 41
West Midlands -29 94 £438 +2.94% 41
East Midlands +5 72 £400 +14.29% 29
Wales -7 47 £450 +44.69% 5
North East -1 32 £438 -4.89% 5
Northern Ireland +19 4 - - 3
Isle of Man -6 1 £475 +18.75%
Channel Islands - 1 - -

For the 6 months to 21 January 2019, 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 (59.07%) SQL
2 1,184 (47.84%) Business Intelligence
3 1,022 (41.29%) ETL
4 887 (35.84%) SQL Server
5 726 (29.33%) Agile Software Development
6 687 (27.76%) SQL Server Integration Services
7 684 (27.64%) Finance
8 569 (22.99%) Data Modelling
9 539 (21.78%) Analytics
10 522 (21.09%) SQL Server Reporting Services
11 519 (20.97%) Microsoft
12 480 (19.39%) Power BI
13 463 (18.71%) Microsoft Azure
14 430 (17.37%) Big Data
15 418 (16.89%) T-SQL
16 411 (16.61%) Oracle
17 388 (15.68%) SQL Server Analysis Services
18 317 (12.81%) Analytical Skills
19 305 (12.32%) Hadoop
20 298 (12.04%) Relational Database
21 291 (11.76%) Migration
22 270 (10.91%) Amazon AWS
23 262 (10.59%) Visualisation
23 262 (10.59%) Tableau
24 249 (10.06%) Data Lake
25 245 (9.90%) Scrum
26 241 (9.74%) Python
27 230 (9.29%) Data Analysis
28 228 (9.21%) Banking
29 224 (9.05%) Kimball Methodology

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 218 (8.81%) Apache Spark
2 77 (3.11%) SAS
3 45 (1.82%) Confluence
4 43 (1.74%) SharePoint
5 35 (1.41%) Apache
6 25 (1.01%) Apache Pig
7 23 (0.93%) IIS
8 16 (0.65%) Elasticsearch
9 8 (0.32%) Oracle SOA Suite
10 6 (0.24%) Apache Airflow
11 3 (0.12%) Apache Solr
11 3 (0.12%) BizTalk Server
11 3 (0.12%) Luigi
11 3 (0.12%) NServiceBus
11 3 (0.12%) SharePoint Server
12 2 (0.081%) JBoss
12 2 (0.081%) Oracle Application Server
12 2 (0.081%) PowerExchange
12 2 (0.081%) Tomcat
12 2 (0.081%) Umbraco
Applications
1 197 (7.96%) Microsoft Excel
2 45 (1.82%) Microsoft Office
3 32 (1.29%) MS Visio
4 18 (0.73%) Microsoft PowerPoint
5 11 (0.44%) Spreadsheet
6 10 (0.40%) Microsoft Project
7 5 (0.20%) SPSS
8 2 (0.081%) Stata
9 1 (0.040%) InfoPath
Business Applications
1 18 (0.73%) Dynamics CRM
2 14 (0.57%) Oracle EBS
2 14 (0.57%) SAP Oil and Gas
3 12 (0.48%) Markit EDM
4 10 (0.40%) Dynamics AX
5 7 (0.28%) Dynamics NAV
5 7 (0.28%) Oracle Procure-to-Pay
5 7 (0.28%) Unit4 Business World
6 6 (0.24%) Cognos Business Intelligence
6 6 (0.24%) Infor M3
7 5 (0.20%) Cognos TM1
7 5 (0.20%) HFM
7 5 (0.20%) Hyperion Planning
7 5 (0.20%) Oracle ERP
7 5 (0.20%) SAP S/4HANA
8 4 (0.16%) Endur
8 4 (0.16%) NetSuite
9 3 (0.12%) Oracle Applications
9 3 (0.12%) Oracle EBS R12
9 3 (0.12%) Oracle Financials
Cloud Services
1 463 (18.71%) Microsoft Azure
2 270 (10.91%) Amazon AWS
3 132 (5.33%) Azure Data Factory
4 65 (2.63%) Amazon S3
5 55 (2.22%) PaaS
6 54 (2.18%) Google Cloud Platform
7 40 (1.62%) Amazon EMR
8 39 (1.58%) Amazon EC2
8 39 (1.58%) Serverless
9 37 (1.49%) Data Lake Analytics
10 25 (1.01%) Office 365
11 23 (0.93%) IaaS
12 22 (0.89%) AWS Lambda
13 20 (0.81%) Cloud Computing
14 19 (0.77%) Google Analytics
15 15 (0.61%) Azure Machine Learning
15 15 (0.61%) SaaS
16 13 (0.53%) Amazon Kinesis
16 13 (0.53%) Dynamics 365
17 12 (0.48%) Cortana Intelligence Suite
Communications & Networking
1 12 (0.48%) Extranet
2 11 (0.44%) Firewall
3 10 (0.40%) FTP
3 10 (0.40%) Intranet
4 9 (0.36%) VPN
5 7 (0.28%) Internet
5 7 (0.28%) Kerberos
6 4 (0.16%) DNS
6 4 (0.16%) Network Security
7 3 (0.12%) LAN
7 3 (0.12%) MQTT
7 3 (0.12%) SAN
7 3 (0.12%) WAN
7 3 (0.12%) Wi-Fi
8 2 (0.081%) 3G
8 2 (0.081%) DHCP
8 2 (0.081%) OpenVPN
8 2 (0.081%) SSL
9 1 (0.040%) Fibre Channel
9 1 (0.040%) PABX
Database & Business Intelligence
1 887 (35.84%) SQL Server
2 687 (27.76%) SQL Server Integration Services
3 522 (21.09%) SQL Server Reporting Services
4 480 (19.39%) Power BI
5 430 (17.37%) Big Data
6 388 (15.68%) SQL Server Analysis Services
7 305 (12.32%) Hadoop
8 298 (12.04%) Relational Database
9 249 (10.06%) Data Lake
10 199 (8.04%) Apache Hive
11 186 (7.52%) OLAP
12 153 (6.18%) NoSQL
13 148 (5.98%) Azure SQL Data Warehouse
14 130 (5.25%) Enterprise Data Warehouse
15 128 (5.17%) Azure SQL Database
16 122 (4.93%) Oracle Database
17 111 (4.48%) SQL Server 2016
18 110 (4.44%) Star Schema
19 106 (4.28%) BusinessObjects
20 100 (4.04%) SQL Server 2014
Development Applications
1 108 (4.36%) JIRA
2 76 (3.07%) Jenkins
3 72 (2.91%) Team Foundation Server
4 71 (2.87%) Git (software)
5 59 (2.38%) Visual Studio
6 33 (1.33%) ERwin
7 29 (1.17%) Maven
7 29 (1.17%) Toad
8 28 (1.13%) Visual Studio Team System
9 22 (0.89%) SQL Server Management Studio (SSMS)
10 18 (0.73%) Selenium
11 17 (0.69%) Gradle
12 14 (0.57%) Ant
12 14 (0.57%) Apache Ivy
12 14 (0.57%) Oracle Forms
13 12 (0.48%) Subversion
14 11 (0.44%) Eclipse
15 10 (0.40%) Cucumber
15 10 (0.40%) RStudio
15 10 (0.40%) TeamCity
General
1 684 (27.64%) Finance
2 228 (9.21%) Banking
3 206 (8.32%) Retail
4 82 (3.31%) Marketing
5 70 (2.83%) Investment Banking
6 40 (1.62%) Front Office
7 32 (1.29%) Pharmaceutical
8 29 (1.17%) Publishing
8 29 (1.17%) Telecoms
9 28 (1.13%) Manufacturing
10 25 (1.01%) Legal
11 18 (0.73%) Back Office
11 18 (0.73%) Financial Institution
12 13 (0.53%) Advertising
12 13 (0.53%) Games
13 11 (0.44%) Law
14 10 (0.40%) Retail Banking
15 9 (0.36%) Electronics
16 7 (0.28%) Automotive
17 6 (0.24%) Billing
Job Titles
1 1,085 (43.84%) Developer
2 430 (17.37%) Analyst
3 315 (12.73%) SQL Developer
4 306 (12.36%) Business Intelligence Developer
5 302 (12.20%) Architect
6 203 (8.20%) Data Engineer
7 192 (7.76%) Data Architect
8 148 (5.98%) Business Analyst
9 147 (5.94%) ETL Developer
10 125 (5.05%) Data Analyst
11 121 (4.89%) Data Warehouse Developer
12 101 (4.08%) Consultant
13 93 (3.76%) SSIS Developer
14 84 (3.39%) Business Intelligence Analyst
15 82 (3.31%) Project Manager
16 71 (2.87%) Senior Developer
17 70 (2.83%) SQL BI Developer
18 65 (2.63%) Power BI Developer
19 61 (2.46%) SQL Analyst
20 59 (2.38%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 158 (6.38%) .NET
2 134 (5.41%) Kafka
3 123 (4.97%) Web Services
4 93 (3.76%) XML
5 66 (2.67%) JSON
5 66 (2.67%) MDX
6 50 (2.02%) RESTful
7 44 (1.78%) Node.js
8 43 (1.74%) SOAP
9 30 (1.21%) AngularJS
10 28 (1.13%) Spring
11 26 (1.05%) .NET Framework
11 26 (1.05%) Middleware
12 24 (0.97%) ASP.NET
12 24 (0.97%) HTML
13 23 (0.93%) REST
14 21 (0.85%) ASP.NET Web API
15 20 (0.81%) CSS
16 19 (0.77%) Entity Framework
17 18 (0.73%) XSD
Miscellaneous
1 317 (12.81%) Analytical Skills
2 98 (3.96%) Data Structures
3 76 (3.07%) NHS
4 67 (2.71%) Greenfield Project
5 58 (2.34%) Management Information System
6 51 (2.06%) Self-Motivation
7 35 (1.41%) Replication
8 32 (1.29%) Algorithms
8 32 (1.29%) Enterprise Software
9 29 (1.17%) Fixed Income
9 29 (1.17%) User Experience
10 23 (0.93%) Fintech
11 22 (0.89%) Reference Data
12 19 (0.77%) Derivative
13 18 (0.73%) Reinsurance
14 17 (0.69%) Equities
14 17 (0.69%) Private Cloud
15 16 (0.65%) Data Centre
16 12 (0.48%) Taxonomies
17 11 (0.44%) FMCG
Operating Systems
1 116 (4.69%) Unix
2 72 (2.91%) Linux
3 47 (1.90%) Windows
4 16 (0.65%) Windows Server
5 12 (0.48%) Android
5 12 (0.48%) Apple iOS
6 10 (0.40%) AIX
7 6 (0.24%) Windows 10
8 5 (0.20%) Solaris
8 5 (0.20%) VMS
9 4 (0.16%) Red Hat Enterprise Linux
10 2 (0.081%) Oracle Linux
10 2 (0.081%) Tru64
10 2 (0.081%) Windows 7
11 1 (0.040%) Debian
11 1 (0.040%) Ubuntu
11 1 (0.040%) Windows 8
11 1 (0.040%) Windows Server 2008
11 1 (0.040%) Windows XP
Processes & Methodologies
1 1,184 (47.84%) Business Intelligence
2 1,022 (41.29%) ETL
3 726 (29.33%) Agile Software Development
4 569 (22.99%) Data Modelling
5 539 (21.78%) Analytics
6 291 (11.76%) Migration
7 262 (10.59%) Visualisation
8 245 (9.90%) Scrum
9 230 (9.29%) Data Analysis
10 224 (9.05%) Kimball Methodology
11 215 (8.69%) Data Integration
12 196 (7.92%) Data Migration
13 187 (7.56%) Data Management
14 183 (7.39%) Dimensional Modelling
15 177 (7.15%) Problem-Solving
16 169 (6.83%) Data Architecture
16 169 (6.83%) Data Science
17 164 (6.63%) Performance Tuning
18 162 (6.55%) ETL Development
18 162 (6.55%) Stakeholder Management
Programming Languages
1 1,462 (59.07%) SQL
2 418 (16.89%) T-SQL
3 241 (9.74%) Python
4 185 (7.47%) C#
5 163 (6.59%) Java
6 136 (5.49%) PL/SQL
7 76 (3.07%) R
8 72 (2.91%) VBA
9 71 (2.87%) Shell Script
10 69 (2.79%) Scala
11 66 (2.67%) PowerShell
12 58 (2.34%) VB
13 54 (2.18%) Data Analysis Expressions (DAX)
14 47 (1.90%) JavaScript
15 33 (1.33%) VB.NET
16 31 (1.25%) Bash Shell
16 31 (1.25%) PHP
17 27 (1.09%) C
18 22 (0.89%) U-SQL
19 21 (0.85%) Perl
Qualifications
1 109 (4.40%) Degree
2 80 (3.23%) Security Cleared
3 59 (2.38%) SC Cleared
4 43 (1.74%) Computer Science Degree
5 18 (0.73%) Master's Degree
5 18 (0.73%) Microsoft Certification
6 15 (0.61%) ISTQB
7 14 (0.57%) BPSS Clearance
7 14 (0.57%) ISEB
8 12 (0.48%) PMP
9 9 (0.36%) TOGAF Certification
10 8 (0.32%) ISTQB Foundation Certification
10 8 (0.32%) MCSE
10 8 (0.32%) PhD
10 8 (0.32%) PMI Certification
11 7 (0.28%) ITIL Certification
11 7 (0.28%) MCSA
12 5 (0.20%) DV Cleared
13 4 (0.16%) DBS Check
13 4 (0.16%) Numerate Degree
Quality Assurance & Compliance
1 213 (8.61%) Data Quality
2 108 (4.36%) QA
3 54 (2.18%) PMO
4 40 (1.62%) GDPR
5 22 (0.89%) IFRS
6 8 (0.32%) IFRS 9
6 8 (0.32%) Solvency II
7 7 (0.28%) Basel III
8 6 (0.24%) SLA
9 4 (0.16%) EMIR
9 4 (0.16%) PCI DSS
10 3 (0.12%) ISO 9000
10 3 (0.12%) MiFID
10 3 (0.12%) WCAG
11 2 (0.081%) ISO 9001
11 2 (0.081%) ISO 9002
11 2 (0.081%) TickIT
12 1 (0.040%) GAMP
12 1 (0.040%) GxP
12 1 (0.040%) HL7
System Software
1 47 (1.90%) Apache Flume
2 44 (1.78%) Docker
3 27 (1.09%) Active Directory
4 26 (1.05%) HDFS
5 10 (0.40%) Oracle RAC
5 10 (0.40%) VMware Infrastructure
6 8 (0.32%) Virtual Machines
7 5 (0.20%) Apache ZooKeeper
7 5 (0.20%) Hyper-V
7 5 (0.20%) vSphere
8 2 (0.081%) NFS
9 1 (0.040%) Cronacle
9 1 (0.040%) Firmware
9 1 (0.040%) Veritas Volume Manager
9 1 (0.040%) VMware ESXi
Systems Management
1 64 (2.59%) Oozie
2 30 (1.21%) Kubernetes
3 19 (0.77%) Ansible
4 18 (0.73%) Puppet
5 16 (0.65%) Control-M
5 16 (0.65%) Opscode Chef
6 13 (0.53%) Terraform
7 12 (0.48%) Hadoop YARN
8 8 (0.32%) HP ALM
8 8 (0.32%) HP Quality Center
9 5 (0.20%) Single Sign-On
10 4 (0.16%) Grafana
10 4 (0.16%) Prometheus
10 4 (0.16%) Tivoli
11 3 (0.12%) Kibana
11 3 (0.12%) logstash
11 3 (0.12%) Oracle RMAN
11 3 (0.12%) Packer
12 2 (0.081%) FreeIPA
12 2 (0.081%) Mesos
Vendors
1 519 (20.97%) Microsoft
2 411 (16.61%) Oracle
3 262 (10.59%) Tableau
4 154 (6.22%) Informatica
5 145 (5.86%) SAP
6 90 (3.64%) Teradata
7 84 (3.39%) Google
8 82 (3.31%) Talend
9 69 (2.79%) Ab Initio
10 60 (2.42%) Cloudera
11 56 (2.26%) IBM
12 42 (1.70%) Cognos
13 38 (1.54%) Databricks
14 35 (1.41%) MicroStrategy
15 33 (1.33%) Alteryx
16 32 (1.29%) Netezza
17 31 (1.25%) Hortonworks
18 27 (1.09%) Salesforce.com
19 21 (0.85%) Citrix
20 16 (0.65%) Workday