Period
to 24 November 2017

The following table provides summary statistics for contract job vacancies advertised in England 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 24 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 > England
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 104 85 59
Rank change year-on-year -19 -26 +8
Contract jobs citing Data Warehouse 2226 2650 3507
As % of all contract IT jobs advertised in England 2.35% 2.72% 3.35%
As % of the Database & Business Intelligence category 10.63% 12.03% 14.33%
Number of daily rates quoted 1617 1826 2541
England median daily rate £450 £438 £425
Median daily rate % change year-on-year +2.86% +2.94% +1.19%
10th Percentile £313 £308 £294
90th Percentile £613 £600 £588
UK median daily rate £450 £430 £425
% change year-on-year +4.65% +1.18% +3.03%
Number of hourly rates quoted 20 26 18
England median hourly rate £27.50 £40.38 £26.47
Median hourly rate % change year-on-year -31.89% +52.53% -42.14%
10th Percentile £14.48 £15.47 £15.05
90th Percentile £53.20 £52.25 £36.10
UK median hourly rate £27.50 £40.38 £25.44
% change year-on-year -31.89% +58.71% -45.29%

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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Contract vacancies with a requirement for database or business intelligence skills 20938 22027 24466
As % of all contract IT jobs advertised in England 22.08% 22.58% 23.38%
Number of daily rates quoted 14493 14745 16282
England median daily rate £460 £425 £413
Median daily rate % change year-on-year +8.24% +3.03% +3.13%
10th Percentile £313 £290 £275
90th Percentile £638 £600 £588
UK median daily rate £450 £425 £401
% change year-on-year +5.88% +6.12% +1.04%
Number of hourly rates quoted 261 324 390
England median hourly rate £32.00 £27.75 £27.64
Median hourly rate % change year-on-year +15.32% +0.40% +12.82%
10th Percentile £14.54 £11.25 £12.00
90th Percentile £56.75 £48.00 £52.17
UK median hourly rate £31.41 £28.00 £28.13
% change year-on-year +12.16% -0.44% +12.50%

Data Warehouse
Job Vacancy Trend in England

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in England.

Job vacancy trend for Data Warehouse in England

Data Warehouse
Contractor Daily Rate Trend in England

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Warehouse in England.

Contractor daily rate trend for Data Warehouse in England

Data Warehouse
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing Data Warehouse in England over the 6 months to 24 November 2017.

Contractor daily rate histogram for Data Warehouse in England

Data Warehouse
Contractor Hourly Rate Trend in England

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Warehouse in England.

Contractor hourly rate trend for Data Warehouse in England

Data Warehouse
Contractor Hourly Rate Histogram in England

The hourly rate distribution of IT jobs citing Data Warehouse in England over the 6 months to 24 November 2017.

Contractor hourly rate histogram for Data Warehouse in England

Data Warehouse
Contract Job Locations in England

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 England region over the 6 months to 24 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
London -27 1081 £475 - 104
South East -12 369 £425 +2.41% 41
North of England +8 292 £425 +11.84% 55
South West +21 198 £425 +13.33% 16
Midlands -30 161 £400 -3.03% 16
North West +4 156 £438 +12.90% 25
East of England 0 128 £375 -9.64% 19
Yorkshire -7 121 £425 +12.58% 22
West Midlands -27 93 £450 +10.77% 13
East Midlands -26 68 £375 -9.09% 3
North East +51 33 £475 +26.67% 8
Data Warehouse
UK

For the 6 months to 24 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 across the England region with a requirement for Data Warehouse.

1 1297 (58.27%) SQL
2 1250 (56.15%) Business Intelligence
3 962 (43.22%) ETL
4 786 (35.31%) SQL Server
5 675 (30.32%) SQL Server Integration Services
6 615 (27.63%) Agile Software Development
7 602 (27.04%) Finance
8 559 (25.11%) Data Modelling
9 498 (22.37%) SQL Server Reporting Services
10 454 (20.40%) Microsoft
11 418 (18.78%) Oracle
12 400 (17.97%) Analytics
13 380 (17.07%) SQL Server Analysis Services
14 337 (15.14%) T-SQL
15 290 (13.03%) Analytical Skills
16 275 (12.35%) Power BI
17 273 (12.26%) Big Data
18 266 (11.95%) Migration
19 244 (10.96%) Kimball Methodology
20 240 (10.78%) Tableau
21 232 (10.42%) Data Analysis
22 216 (9.70%) Banking
23 209 (9.39%) Data Management
24 199 (8.94%) Hadoop
25 193 (8.67%) Data Quality
26 192 (8.63%) Data Integration
27 191 (8.58%) Visualisation
28 184 (8.27%) Relational Database
29 181 (8.13%) Python
29 181 (8.13%) Scrum

Data Warehouse
Co-occurring IT Skills in England 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 134 (6.02%) Apache Spark
2 120 (5.39%) SAS
3 50 (2.25%) SharePoint
4 25 (1.12%) Apache Pig
5 22 (0.99%) Apache
6 17 (0.76%) IIS
7 16 (0.72%) Confluence
8 15 (0.67%) Apache Airflow
9 12 (0.54%) PowerExchange
9 12 (0.54%) Tomcat
10 11 (0.49%) Apache Solr
10 11 (0.49%) ArcGIS
10 11 (0.49%) WebLogic
10 11 (0.49%) WebSphere
11 10 (0.45%) Oracle Workflow
12 9 (0.40%) JBoss
12 9 (0.40%) Oracle SOA Suite
12 9 (0.40%) WildFly
13 7 (0.31%) WebSphere Application Server
14 5 (0.22%) Elasticsearch
Applications
1 122 (5.48%) Microsoft Excel
2 33 (1.48%) Microsoft Office
3 27 (1.21%) MS Visio
4 14 (0.63%) Microsoft PowerPoint
5 13 (0.58%) Spreadsheet
6 10 (0.45%) Microsoft Project
7 9 (0.40%) SPSS
8 4 (0.18%) Stata
9 1 (0.045%) Mingle
Business Applications
1 33 (1.48%) Cognos Business Intelligence
2 21 (0.94%) Markit EDM
3 12 (0.54%) Dynamics CRM
4 8 (0.36%) Cognos TM1
4 8 (0.36%) Dynamics AX
4 8 (0.36%) SAP CRM
5 7 (0.31%) Oracle EBS
5 7 (0.31%) SAP IS-U
6 6 (0.27%) Oracle BPM
7 5 (0.22%) Oracle Receivables
8 4 (0.18%) Dynamics GP
8 4 (0.18%) Endur
8 4 (0.18%) Oracle ERP
8 4 (0.18%) Oracle iProcurement
8 4 (0.18%) SAP ERP
9 3 (0.13%) Cognos Planning
9 3 (0.13%) Dynamics NAV
9 3 (0.13%) HFM
9 3 (0.13%) Oracle 11i
9 3 (0.13%) Oracle Applications
Cloud Services
1 180 (8.09%) Microsoft Azure
2 129 (5.80%) Amazon AWS
3 44 (1.98%) Google Cloud Platform
4 30 (1.35%) Amazon S3
5 27 (1.21%) Amazon EMR
6 21 (0.94%) Azure Data Factory
6 21 (0.94%) IaaS
7 19 (0.85%) PaaS
8 17 (0.76%) Amazon Kinesis
9 16 (0.72%) Amazon EC2
9 16 (0.72%) SaaS
10 15 (0.67%) Data Lake Analytics
11 14 (0.63%) GitHub
12 10 (0.45%) Office 365
13 7 (0.31%) Azure Machine Learning
14 6 (0.27%) IBM Cloud
15 5 (0.22%) AWS CloudFormation
15 5 (0.22%) AWS Lambda
15 5 (0.22%) Bluemix
15 5 (0.22%) Serverless
Communications & Networking
1 16 (0.72%) Internet
2 11 (0.49%) SMS
3 9 (0.40%) Firewall
4 7 (0.31%) Intranet
4 7 (0.31%) SAN
5 4 (0.18%) DNS
5 4 (0.18%) HTTP
5 4 (0.18%) Kerberos
5 4 (0.18%) LDAP
5 4 (0.18%) TCP/IP
6 3 (0.13%) NAS
6 3 (0.13%) VLAN
7 2 (0.090%) Extranet
7 2 (0.090%) FTP
7 2 (0.090%) Network Security
7 2 (0.090%) Wireshark
8 1 (0.045%) MQTT
8 1 (0.045%) NetScaler
8 1 (0.045%) SSL
Database & Business Intelligence
1 786 (35.31%) SQL Server
2 675 (30.32%) SQL Server Integration Services
3 498 (22.37%) SQL Server Reporting Services
4 380 (17.07%) SQL Server Analysis Services
5 275 (12.35%) Power BI
6 273 (12.26%) Big Data
7 199 (8.94%) Hadoop
8 184 (8.27%) Relational Database
9 145 (6.51%) OLAP
10 134 (6.02%) QlikView
11 133 (5.97%) BusinessObjects
12 128 (5.75%) Oracle Database
13 122 (5.48%) SQL Server 2012
14 113 (5.08%) Apache Hive
14 113 (5.08%) SQL Server 2016
15 108 (4.85%) SQL Server 2008
16 99 (4.45%) SQL Server 2014
17 95 (4.27%) Enterprise Data Warehouse
18 92 (4.13%) RDBMS
19 89 (4.00%) Oracle BI EE
Development Applications
1 88 (3.95%) Team Foundation Server
2 62 (2.79%) JIRA
3 54 (2.43%) Talend Open Studio
4 53 (2.38%) Visual Studio
5 38 (1.71%) Git (software)
6 37 (1.66%) Jenkins
7 35 (1.57%) ERwin
8 25 (1.12%) Subversion
9 21 (0.94%) Eclipse
10 15 (0.67%) Toad
11 13 (0.58%) Maven
11 13 (0.58%) SQL Server Management Studio (SSMS)
12 10 (0.45%) PowerDesigner
12 10 (0.45%) TeamCity
13 9 (0.40%) Octopus Deploy
14 8 (0.36%) JUnit
14 8 (0.36%) Selenium
15 7 (0.31%) Oracle APEX
15 7 (0.31%) Oracle Forms
16 6 (0.27%) XMLSpy
General
1 602 (27.04%) Finance
2 216 (9.70%) Banking
3 93 (4.18%) Retail
4 90 (4.04%) Marketing
5 47 (2.11%) Telecoms
6 46 (2.07%) Investment Banking
7 43 (1.93%) Legal
8 29 (1.30%) Retail Banking
9 25 (1.12%) Manufacturing
9 25 (1.12%) Pharmaceutical
9 25 (1.12%) Publishing
10 17 (0.76%) Advertising
11 16 (0.72%) Front Office
12 15 (0.67%) Games
13 14 (0.63%) Back Office
13 14 (0.63%) Financial Institution
14 10 (0.45%) Electronics
15 9 (0.40%) Law
16 7 (0.31%) General Ledger
17 5 (0.22%) Billing
Job Titles
1 937 (42.09%) Developer
2 423 (19.00%) Analyst
3 355 (15.95%) Business Intelligence Developer
4 289 (12.98%) SQL Developer
5 257 (11.55%) Architect
6 189 (8.49%) Data Architect
7 155 (6.96%) SSIS Developer
8 141 (6.33%) Data Analyst
9 140 (6.29%) Business Analyst
10 135 (6.06%) Data Warehouse Developer
11 116 (5.21%) ETL Developer
12 115 (5.17%) Business Intelligence Analyst
13 113 (5.08%) Data Engineer
14 110 (4.94%) Consultant
15 98 (4.40%) Project Manager
16 96 (4.31%) SQL BI Developer
17 85 (3.82%) SSAS Developer
18 83 (3.73%) Business Developer
19 78 (3.50%) SSRS Developer
20 69 (3.10%) SQL Analyst
Libraries, Frameworks & Software Standards
1 139 (6.24%) .NET
2 124 (5.57%) MDX
3 108 (4.85%) XML
4 91 (4.09%) Web Services
5 67 (3.01%) Kafka
6 40 (1.80%) .NET Framework
7 35 (1.57%) Entity Framework
7 35 (1.57%) REST
8 32 (1.44%) HTML
8 32 (1.44%) JMS
9 31 (1.39%) PySpark
9 31 (1.39%) Spring
10 30 (1.35%) AngularJS
11 28 (1.26%) CSS
11 28 (1.26%) JSON
12 25 (1.12%) ASP.NET
12 25 (1.12%) SOAP
13 23 (1.03%) Hibernate
14 20 (0.90%) RESTful
15 18 (0.81%) XSD
Miscellaneous
1 290 (13.03%) Analytical Skills
2 84 (3.77%) Management Information System
3 72 (3.23%) Greenfield Project
4 50 (2.25%) Computer Science
5 45 (2.02%) Data Structures
6 40 (1.80%) Algorithms
7 35 (1.57%) NHS
8 29 (1.30%) Equities
8 29 (1.30%) Fixed Income
8 29 (1.30%) User Experience
9 24 (1.08%) Replication
10 23 (1.03%) Credit Risk
11 20 (0.90%) Derivative
12 19 (0.85%) Enterprise Software
13 18 (0.81%) Data Centre
14 16 (0.72%) Reinsurance
15 12 (0.54%) Fintech
15 12 (0.54%) Reference Data
16 11 (0.49%) N-Tier
17 9 (0.40%) Clustering
Operating Systems
1 101 (4.54%) Unix
2 98 (4.40%) Linux
3 60 (2.70%) Windows
4 15 (0.67%) Windows Server
5 13 (0.58%) Red Hat Enterprise Linux
6 11 (0.49%) AIX
7 9 (0.40%) CentOS
8 4 (0.18%) Oracle Linux
9 3 (0.13%) VMS
9 3 (0.13%) Windows Server 2012
10 2 (0.090%) Windows Server 2008
11 1 (0.045%) Android
11 1 (0.045%) OpenVMS
Processes & Methodologies
1 1250 (56.15%) Business Intelligence
2 962 (43.22%) ETL
3 615 (27.63%) Agile Software Development
4 559 (25.11%) Data Modelling
5 400 (17.97%) Analytics
6 266 (11.95%) Migration
7 244 (10.96%) Kimball Methodology
8 232 (10.42%) Data Analysis
9 209 (9.39%) Data Management
10 192 (8.63%) Data Integration
11 191 (8.58%) Visualisation
12 181 (8.13%) Scrum
13 169 (7.59%) Dimensional Modelling
14 162 (7.28%) Stakeholder Management
15 151 (6.78%) Performance Tuning
16 144 (6.47%) Data Migration
17 133 (5.97%) Data Architecture
18 124 (5.57%) SDLC
19 116 (5.21%) ETL Development
20 109 (4.90%) CRM
Programming Languages
1 1297 (58.27%) SQL
2 337 (15.14%) T-SQL
3 181 (8.13%) Python
4 171 (7.68%) Java
5 149 (6.69%) PL/SQL
6 143 (6.42%) C#
7 76 (3.41%) Shell Script
8 68 (3.05%) R
9 62 (2.79%) Data Analysis Expressions (DAX)
10 61 (2.74%) JavaScript
11 56 (2.52%) PowerShell
12 40 (1.80%) Scala
13 33 (1.48%) VBA
14 19 (0.85%) SAS Macro
14 19 (0.85%) VBScript
15 17 (0.76%) Bash Shell
15 17 (0.76%) Perl
16 16 (0.72%) C
17 15 (0.67%) AWK
18 14 (0.63%) sed
Qualifications
1 100 (4.49%) Degree
2 88 (3.95%) Security Cleared
3 61 (2.74%) SC Cleared
4 33 (1.48%) ISEB
5 22 (0.99%) Microsoft Certification
6 19 (0.85%) ISTQB
7 13 (0.58%) Computer Science Degree
7 13 (0.58%) MCSE
8 11 (0.49%) PMI Certification
9 10 (0.45%) MCITP
10 9 (0.40%) PMP
11 7 (0.31%) Master's Degree
12 6 (0.27%) BPSS Clearance
12 6 (0.27%) CFA
12 6 (0.27%) PRINCE2 Certification
13 4 (0.18%) ISTQB Foundation Certification
13 4 (0.18%) ITIL Certification
13 4 (0.18%) MCSA
13 4 (0.18%) MCTS
13 4 (0.18%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 193 (8.67%) Data Quality
2 76 (3.41%) QA
3 42 (1.89%) GDPR
4 20 (0.90%) MiFID
5 10 (0.45%) Solvency II
6 9 (0.40%) Actionable Recommendations
6 9 (0.40%) EMIR
6 9 (0.40%) SLA
7 5 (0.22%) Disclosure Scotland
7 5 (0.22%) GAAP
7 5 (0.22%) IFRS
8 4 (0.18%) IFRS 9
9 3 (0.13%) PMO
10 2 (0.090%) 21 CFR Part 11
10 2 (0.090%) Dodd-Frank
10 2 (0.090%) GCP
10 2 (0.090%) GxP
10 2 (0.090%) HL7
10 2 (0.090%) ISO 20022
10 2 (0.090%) ISO/IEC 20000
System Software
1 29 (1.30%) Apache Flume
2 28 (1.26%) HDFS
3 16 (0.72%) Docker
4 14 (0.63%) Virtual Machines
5 11 (0.49%) Active Directory
5 11 (0.49%) VMware Infrastructure
6 9 (0.40%) Oracle RAC
7 4 (0.18%) Tivoli Workload Scheduler
8 3 (0.13%) Cronacle
9 2 (0.090%) VMware ESXi
9 2 (0.090%) XenApp
9 2 (0.090%) XenDesktop
10 1 (0.045%) Apache ZooKeeper
10 1 (0.045%) Hyper-V
10 1 (0.045%) ISA Server
10 1 (0.045%) Terminal Services
10 1 (0.045%) VMware Server
Systems Management
1 46 (2.07%) Oozie
2 20 (0.90%) Ambari
2 20 (0.90%) Data Guard
2 20 (0.90%) Hadoop YARN
3 14 (0.63%) Control-M
3 14 (0.63%) Oracle RMAN
4 12 (0.54%) Oracle EDQ
5 9 (0.40%) Ansible
6 8 (0.36%) Systems Management Server (SMS)
6 8 (0.36%) Terraform
7 7 (0.31%) Kubernetes
7 7 (0.31%) Puppet
8 5 (0.22%) HP Quality Center
8 5 (0.22%) Opscode Chef
9 4 (0.18%) Tivoli
10 3 (0.13%) Enterprise Manager Cloud Control
10 3 (0.13%) Failover Clustering
10 3 (0.13%) Oracle Enterprise Manager
10 3 (0.13%) Rundeck
11 2 (0.090%) Mesos
Vendors
1 454 (20.40%) Microsoft
2 418 (18.78%) Oracle
3 240 (10.78%) Tableau
4 140 (6.29%) Informatica
5 114 (5.12%) SAP
6 104 (4.67%) IBM
7 90 (4.04%) Teradata
8 89 (4.00%) Cognos
9 54 (2.43%) Talend
10 47 (2.11%) Salesforce.com
11 40 (1.80%) Netezza
12 38 (1.71%) Google
13 29 (1.30%) MicroStrategy
14 23 (1.03%) Hortonworks
15 21 (0.94%) HP
16 19 (0.85%) Greenplum
17 18 (0.81%) Cloudera
17 18 (0.81%) VMware
18 17 (0.76%) Hyperion
19 15 (0.67%) Capita