Period
to 15 December 2018

The following table provides summary statistics for contract job vacancies advertised in the South West 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 15 December 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
England > South West
6 months to
15 Dec 2018
Same period 2017 Same period 2016
Rank 66 57 69
Rank change year-on-year -9 +12 -23
Contract jobs citing Data Warehouse 222 199 153
As % of all contract IT jobs advertised in the South West 3.43% 3.58% 2.72%
As % of the Database & Business Intelligence category 15.32% 18.58% 12.34%
Number of daily rates quoted 180 132 101
South West median daily rate £431 £425 £375
Median daily rate % change year-on-year +1.47% +13.33% -6.54%
10th Percentile £325 £319 £263
90th Percentile £538 £538 £488
England median daily rate £450 £450 £438
% change year-on-year - +2.86% +2.94%
Number of hourly rates quoted 3 1 14
South West median hourly rate £22.00 £13.25 £42.00
Median hourly rate % change year-on-year +66.04% -68.45% +40.00%
10th Percentile £21.00 £12.38 £35.80
90th Percentile £49.43 £14.13 £48.00
England median hourly rate £18.50 £27.00 £41.00
% change year-on-year -31.48% -34.15% +62.57%

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 the South West with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
South West
Contract vacancies with a requirement for database or business intelligence skills 1,449 1,071 1,240
As % of all contract IT jobs advertised in the South West 22.37% 19.28% 22.04%
Number of daily rates quoted 990 678 846
South West median daily rate £425 £400 £375
Median daily rate % change year-on-year +6.25% +6.67% -
10th Percentile £310 £279 £263
90th Percentile £575 £527 £525
England median daily rate £475 £463 £425
% change year-on-year +2.70% +8.82% +1.19%
Number of hourly rates quoted 33 20 35
South West median hourly rate £40.00 £32.50 £38.00
Median hourly rate % change year-on-year +23.08% -14.47% -
10th Percentile £18.59 £13.39 £12.00
90th Percentile £64.13 £58.75 £46.90
England median hourly rate £32.50 £33.00 £28.00
% change year-on-year -1.52% +17.86% +2.30%

Data Warehouse
Job Vacancy Trend in the South West

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in the South West.

Job vacancy trend for Data Warehouse in the South West

Data Warehouse
Contractor Daily Rate Trend in the South West

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

Contractor daily rate trend for Data Warehouse in the South West

Data Warehouse
Contractor Daily Rate Histogram in the South West

The daily rate distribution of IT jobs citing Data Warehouse in the South West over the 6 months to 15 December 2018.

Contractor daily rate histogram for Data Warehouse in the South West

Data Warehouse
Contractor Hourly Rate Trend in the South West

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

Contractor hourly rate trend for Data Warehouse in the South West

Data Warehouse
Contractor Hourly Rate Histogram in the South West

The hourly rate distribution of IT jobs citing Data Warehouse in the South West over the 6 months to 15 December 2018.

Contractor hourly rate histogram for Data Warehouse in the South West

Data Warehouse
Contract Job Locations in the South West

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 South West region over the 6 months to 15 December 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
Gloucestershire -5 66 £450 +6.51% 4
Bristol -17 64 £425 - 15
Wiltshire -27 44 £425 -9.33% 6
Somerset +8 22 £525 +15.07% 2
Dorset +7 10 £425 +17.24% 6
Devon -2 4 £226 -46.76% 7
Cornwall - 2 £500 - 1
Avon - 1 £400 -
Data Warehouse
England

For the 6 months to 15 December 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 across the South West region with a requirement for Data Warehouse.

1 127 (57.21%) Business Intelligence
2 120 (54.05%) SQL
3 95 (42.79%) Finance
4 73 (32.88%) SQL Server
5 67 (30.18%) ETL
5 67 (30.18%) Agile Software Development
6 57 (25.68%) Data Modelling
6 57 (25.68%) Analytical Skills
7 48 (21.62%) Dimensional Modelling
8 46 (20.72%) Power BI
9 42 (18.92%) SQL Server Integration Services
10 39 (17.57%) Visualisation
10 39 (17.57%) Data Science
11 37 (16.67%) Teradata
12 36 (16.22%) Oracle
12 36 (16.22%) Enterprise Data Warehouse
12 36 (16.22%) Data Quality
13 35 (15.77%) Problem-Solving
14 31 (13.96%) SQL Server Reporting Services
14 31 (13.96%) T-SQL
14 31 (13.96%) Kimball Methodology
15 30 (13.51%) Microsoft Azure
16 27 (12.16%) Microsoft
17 26 (11.71%) Hadoop
17 26 (11.71%) Big Data
18 25 (11.26%) IBM InfoSphere
18 25 (11.26%) User Stories
18 25 (11.26%) SQL Server Analysis Services
18 25 (11.26%) Data Analysis
19 24 (10.81%) Stakeholder Management

Data Warehouse
Co-occurring IT Skills in the South West 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 23 (10.36%) Apache Spark
2 10 (4.50%) SAS
3 6 (2.70%) SharePoint
4 1 (0.45%) MS Exchange
Applications
1 10 (4.50%) Microsoft Excel
2 4 (1.80%) Microsoft Office
3 1 (0.45%) Microsoft Project
Business Applications
1 2 (0.90%) Dynamics CRM
2 1 (0.45%) Cognos Business Intelligence
2 1 (0.45%) Maximo
Cloud Services
1 30 (13.51%) Microsoft Azure
2 12 (5.41%) Amazon AWS
3 7 (3.15%) Dynamics 365
3 7 (3.15%) PaaS
4 5 (2.25%) IaaS
4 5 (2.25%) Office 365
5 3 (1.35%) Amazon EMR
5 3 (1.35%) Amazon Kinesis
5 3 (1.35%) Amazon S3
5 3 (1.35%) AWS Lambda
5 3 (1.35%) Serverless
6 1 (0.45%) SaaS
Communications & Networking
1 2 (0.90%) Firewall
2 1 (0.45%) DHCP
2 1 (0.45%) DNS
2 1 (0.45%) VPN
Database & Business Intelligence
1 73 (32.88%) SQL Server
2 46 (20.72%) Power BI
3 42 (18.92%) SQL Server Integration Services
4 36 (16.22%) Enterprise Data Warehouse
5 31 (13.96%) SQL Server Reporting Services
6 26 (11.71%) Big Data
6 26 (11.71%) Hadoop
7 25 (11.26%) IBM InfoSphere
7 25 (11.26%) SQL Server Analysis Services
8 24 (10.81%) Relational Database
9 23 (10.36%) Apache Hive
10 22 (9.91%) Data Mining
10 22 (9.91%) OLAP
10 22 (9.91%) Star Schema
11 21 (9.46%) RDBMS
12 19 (8.56%) DataStage
13 18 (8.11%) BusinessObjects
13 18 (8.11%) OLAP Cube
14 11 (4.95%) DB2
15 8 (3.60%) Oracle ODI
Development Applications
1 8 (3.60%) ERwin
2 7 (3.15%) Visual Studio Team System
3 6 (2.70%) Visual Studio
4 4 (1.80%) JIRA
4 4 (1.80%) Team Foundation Server
5 1 (0.45%) Cucumber
5 1 (0.45%) Jenkins
5 1 (0.45%) Oracle Forms
5 1 (0.45%) Selenium
5 1 (0.45%) SQL Server Management Studio (SSMS)
General
1 95 (42.79%) Finance
2 18 (8.11%) Manufacturing
2 18 (8.11%) Retail
3 12 (5.41%) Banking
4 10 (4.50%) Automotive
5 6 (2.70%) Retail Banking
6 4 (1.80%) Electronics
6 4 (1.80%) Marketing
6 4 (1.80%) Telecoms
7 3 (1.35%) Financial Institution
7 3 (1.35%) Legal
8 2 (0.90%) Corporate Banking
9 1 (0.45%) Aerospace
9 1 (0.45%) Billing
9 1 (0.45%) Investment Banking
9 1 (0.45%) Publishing
Job Titles
1 71 (31.98%) Developer
2 59 (26.58%) Analyst
3 33 (14.86%) Business Analyst
4 32 (14.41%) Business Intelligence Developer
5 27 (12.16%) Business Intelligence Analyst
6 22 (9.91%) Data Analyst
7 20 (9.01%) Business Intelligence Business Analyst
8 19 (8.56%) Hadoop Engineer
9 18 (8.11%) Data Engineer
10 15 (6.76%) ETL Developer
10 15 (6.76%) Project Manager
11 14 (6.31%) Architect
12 13 (5.86%) SQL Developer
13 11 (4.95%) Consultant
14 10 (4.50%) Big Data Engineer
14 10 (4.50%) Business Intelligence Manager
15 9 (4.05%) Data Architect
15 9 (4.05%) Power BI Developer
16 8 (3.60%) DBA
17 7 (3.15%) Administrator
Libraries, Frameworks & Software Standards
1 18 (8.11%) Kafka
2 5 (2.25%) .NET
2 5 (2.25%) Web Services
3 4 (1.80%) MDX
4 3 (1.35%) ASP.NET
4 3 (1.35%) ASP.NET Web API
4 3 (1.35%) XML
5 2 (0.90%) OAuth
5 2 (0.90%) OAuth2
5 2 (0.90%) OpenID
5 2 (0.90%) SAML
6 1 (0.45%) .NET Framework
6 1 (0.45%) J2EE
Miscellaneous
1 57 (25.68%) Analytical Skills
2 13 (5.86%) Management Information System
3 6 (2.70%) Data Structures
3 6 (2.70%) NHS
4 5 (2.25%) Self-Motivation
5 2 (0.90%) Data Centre
5 2 (0.90%) Mainframe
5 2 (0.90%) Reference Data
5 2 (0.90%) Taxonomies
6 1 (0.45%) Clustering
6 1 (0.45%) Derivative
6 1 (0.45%) Fintech
6 1 (0.45%) Private Cloud
Operating Systems
1 17 (7.66%) Linux
2 16 (7.21%) Unix
3 12 (5.41%) Windows
4 11 (4.95%) Windows Server
5 1 (0.45%) Windows 8
5 1 (0.45%) Windows Server 2008
5 1 (0.45%) Windows XP
Processes & Methodologies
1 127 (57.21%) Business Intelligence
2 67 (30.18%) Agile Software Development
2 67 (30.18%) ETL
3 57 (25.68%) Data Modelling
4 48 (21.62%) Dimensional Modelling
5 39 (17.57%) Data Science
5 39 (17.57%) Visualisation
6 35 (15.77%) Problem-Solving
7 31 (13.96%) Kimball Methodology
8 25 (11.26%) Data Analysis
8 25 (11.26%) User Stories
9 24 (10.81%) Analytics
9 24 (10.81%) Stakeholder Management
10 22 (9.91%) Data Management
11 21 (9.46%) Scrum
12 20 (9.01%) Migration
12 20 (9.01%) People Management
13 18 (8.11%) Machine Learning
13 18 (8.11%) SDLC
13 18 (8.11%) SQL Optimisation
Programming Languages
1 120 (54.05%) SQL
2 31 (13.96%) T-SQL
3 12 (5.41%) Shell Script
4 11 (4.95%) PL/SQL
5 8 (3.60%) Java
6 5 (2.25%) PowerShell
7 4 (1.80%) C
7 4 (1.80%) Python
8 3 (1.35%) Data Analysis Expressions (DAX)
8 3 (1.35%) R
8 3 (1.35%) Scala
8 3 (1.35%) VBA
9 2 (0.90%) Bash Shell
10 1 (0.45%) C#
10 1 (0.45%) VB
10 1 (0.45%) VB.NET
Qualifications
1 15 (6.76%) Security Cleared
2 14 (6.31%) SC Cleared
3 4 (1.80%) Degree
4 3 (1.35%) PMI Certification
4 3 (1.35%) PMP
5 2 (0.90%) Computer Science Degree
5 2 (0.90%) PRINCE2 Practitioner
6 1 (0.45%) BPSS Clearance
6 1 (0.45%) DBS Check
6 1 (0.45%) DV Cleared
6 1 (0.45%) Master's Degree
6 1 (0.45%) MCSA
6 1 (0.45%) MCSE
6 1 (0.45%) Microsoft Certification
Quality Assurance & Compliance
1 36 (16.22%) Data Quality
2 6 (2.70%) PMO
3 5 (2.25%) QA
4 1 (0.45%) GDPR
4 1 (0.45%) IFRS
4 1 (0.45%) Solvency II
System Software
1 3 (1.35%) Active Directory
2 2 (0.90%) HDFS
3 1 (0.45%) Docker
3 1 (0.45%) Hyper-V
3 1 (0.45%) Virtual Machines
3 1 (0.45%) VMware Infrastructure
Systems Management
1 18 (8.11%) Oozie
2 3 (1.35%) HP Quality Center
3 2 (0.90%) NetIQ Identity Manager
3 2 (0.90%) Single Sign-On
Vendors
1 37 (16.67%) Teradata
2 36 (16.22%) Oracle
3 27 (12.16%) Microsoft
4 24 (10.81%) Tableau
5 16 (7.21%) IBM
6 11 (4.95%) Netezza
7 8 (3.60%) SAP
8 7 (3.15%) MicroStrategy
9 3 (1.35%) Cognos
10 2 (0.90%) Hortonworks
10 2 (0.90%) Informatica
10 2 (0.90%) NetIQ
10 2 (0.90%) Salesforce.com
11 1 (0.45%) Alteryx
11 1 (0.45%) DataFlux
11 1 (0.45%) HP
11 1 (0.45%) PeopleSoft
11 1 (0.45%) Sybase
11 1 (0.45%) Talend
11 1 (0.45%) VMware