Period
to 18 January 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 18 January 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
18 Jan 2018
Same period 2017 Same period 2016
Rank 52 71 45
Rank change year-on-year +19 -26 +13
Contract jobs citing Data Warehouse 195 152 247
As % of all contract IT jobs advertised in the South West 3.69% 2.84% 3.97%
As % of the Database & Business Intelligence category 18.21% 12.56% 17.07%
Number of daily rates quoted 133 105 193
South West median daily rate £425 £375 £420
Median daily rate % change year-on-year +13.33% -10.71% +10.34%
10th Percentile £327 £263 £313
90th Percentile £538 £494 £500
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 1 16 0
South West median hourly rate £13.25 £41.00 -
Median hourly rate % change year-on-year -67.68% - -
England median hourly rate £26.80 £41.00 £26.00
% change year-on-year -34.64% +57.69% -34.18%

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,071 1,210 1,447
As % of all contract IT jobs advertised in the South West 20.28% 22.58% 23.29%
Number of daily rates quoted 689 851 1,097
South West median daily rate £415 £370 £375
Median daily rate % change year-on-year +12.16% -1.33% -
10th Percentile £284 £263 £263
90th Percentile £550 £525 £500
England median daily rate £470 £428 £425
% change year-on-year +9.88% +0.65% +6.25%
Number of hourly rates quoted 17 34 32
South West median hourly rate £30.00 £40.00 £41.50
Median hourly rate % change year-on-year -25.00% -3.61% +36.07%
10th Percentile £15.00 £12.00 £12.50
90th Percentile £57.55 £47.05 £56.53
England median hourly rate £31.31 £28.00 £30.00
% change year-on-year +11.82% -6.67% +4.57%

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 18 January 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
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 18 January 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 +34 65 £423 +1.81% 9
Bristol +17 59 £425 +30.77% 19
Wiltshire +28 46 £469 +25.00% 4
Somerset -9 6 £456 +32.25% 1
Dorset -5 4 £400 -11.11% 5
Cornwall -6 2 - -
Devon -14 2 £425 +30.77% 2
Data Warehouse
England

For the 6 months to 18 January 2018, 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 South West region with a requirement for Data Warehouse.

1 117 (60.00%) Business Intelligence
2 103 (52.82%) ETL
3 100 (51.28%) SQL
4 72 (36.92%) Finance
5 61 (31.28%) Agile Software Development
6 55 (28.21%) SQL Server
7 52 (26.67%) SQL Server Integration Services
8 41 (21.03%) Data Modelling
9 35 (17.95%) Oracle
10 33 (16.92%) Analytical Skills
11 32 (16.41%) SQL Server Reporting Services
11 32 (16.41%) Teradata
12 31 (15.90%) Tableau
12 31 (15.90%) Kimball Methodology
13 30 (15.38%) Banking
14 29 (14.87%) SQL Server Analysis Services
15 28 (14.36%) Data Analysis
15 28 (14.36%) Microsoft
16 27 (13.85%) SAS
17 25 (12.82%) Scrum
18 24 (12.31%) Analytics
19 23 (11.79%) SAP
20 22 (11.28%) Power BI
21 21 (10.77%) T-SQL
21 21 (10.77%) Stakeholder Management
21 21 (10.77%) Amazon AWS
22 19 (9.74%) Dimensional Modelling
22 19 (9.74%) BusinessObjects
22 19 (9.74%) Amazon Redshift
23 18 (9.23%) DevOps

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 27 (13.85%) SAS
2 7 (3.59%) Apache Pig
3 4 (2.05%) Confluence
3 4 (2.05%) SharePoint
3 4 (2.05%) WebLogic
3 4 (2.05%) WebSphere
4 1 (0.51%) Apache Spark
4 1 (0.51%) CMS
Applications
1 7 (3.59%) Microsoft Excel
2 1 (0.51%) Microsoft PowerPoint
2 1 (0.51%) Microsoft Project
2 1 (0.51%) MS Visio
2 1 (0.51%) Spreadsheet
Business Applications
1 5 (2.56%) Cognos Business Intelligence
2 4 (2.05%) Oracle BPM
3 2 (1.03%) Salesforce.com CRM
4 1 (0.51%) Cognos TM1
4 1 (0.51%) Oracle EBS
4 1 (0.51%) SAP BPC
Cloud Services
1 21 (10.77%) Amazon AWS
2 13 (6.67%) Amazon S3
2 13 (6.67%) Microsoft Azure
3 1 (0.51%) Azure Data Factory
3 1 (0.51%) Google Cloud Platform
3 1 (0.51%) IaaS
3 1 (0.51%) PaaS
Communications & Networking
1 1 (0.51%) Intranet
1 1 (0.51%) SMS
Database & Business Intelligence
1 55 (28.21%) SQL Server
2 52 (26.67%) SQL Server Integration Services
3 32 (16.41%) SQL Server Reporting Services
4 29 (14.87%) SQL Server Analysis Services
5 22 (11.28%) Power BI
6 19 (9.74%) Amazon Redshift
6 19 (9.74%) BusinessObjects
7 17 (8.72%) BusinessObjects Business Intelligence
7 17 (8.72%) SAS EBI
8 15 (7.69%) IBM InfoSphere
9 14 (7.18%) SQL Server 2016
10 13 (6.67%) Big Data
10 13 (6.67%) Oracle ODI
10 13 (6.67%) Relational Database
11 12 (6.15%) DataStage
12 11 (5.64%) Hadoop
13 10 (5.13%) Enterprise Data Warehouse
14 9 (4.62%) Oracle BI EE
14 9 (4.62%) QlikView
14 9 (4.62%) SQL Server 2012
Development Applications
1 8 (4.10%) JIRA
2 4 (2.05%) ERwin
2 4 (2.05%) JMeter
2 4 (2.05%) LoadRunner
2 4 (2.05%) Selenium
2 4 (2.05%) SoapUI
2 4 (2.05%) Team Foundation Server
3 2 (1.03%) Git (software)
3 2 (1.03%) ProC
4 1 (0.51%) Visual Studio
General
1 72 (36.92%) Finance
2 30 (15.38%) Banking
3 13 (6.67%) Retail Banking
4 7 (3.59%) Marketing
5 4 (2.05%) Investment Banking
5 4 (2.05%) Retail
6 2 (1.03%) Billing
6 2 (1.03%) Law
6 2 (1.03%) Manufacturing
6 2 (1.03%) Telecoms
7 1 (0.51%) Advertising
7 1 (0.51%) Automotive
7 1 (0.51%) Financial Institution
Job Titles
1 102 (52.31%) Developer
2 34 (17.44%) Business Intelligence Developer
3 28 (14.36%) Analyst
4 19 (9.74%) Data Warehouse Developer
5 16 (8.21%) Architect
6 15 (7.69%) SQL Developer
7 12 (6.15%) Business Developer
7 12 (6.15%) Business Intelligence Analyst
8 11 (5.64%) SSIS Developer
9 10 (5.13%) ETL Developer
10 9 (4.62%) Consultant
10 9 (4.62%) Data Architect
11 8 (4.10%) Data Analyst
11 8 (4.10%) DataStage Developer
12 7 (3.59%) AWS Specialist
12 7 (3.59%) Redshift Specialist
12 7 (3.59%) SAP BusinessObjects (BO) Developer
12 7 (3.59%) SAS Developer
13 6 (3.08%) Power BI Developer
13 6 (3.08%) SSAS Developer
Libraries, Frameworks & Software Standards
1 6 (3.08%) .NET
2 5 (2.56%) XML
3 4 (2.05%) JSON
3 4 (2.05%) SOAP
3 4 (2.05%) XSD
4 3 (1.54%) CSS
4 3 (1.54%) Entity Framework
4 3 (1.54%) Web Services
5 2 (1.03%) ASP.NET
5 2 (1.03%) Django
5 2 (1.03%) jQuery
5 2 (1.03%) Matplotlib
6 1 (0.51%) HTML
6 1 (0.51%) Kafka
Miscellaneous
1 33 (16.92%) Analytical Skills
2 8 (4.10%) Greenfield Project
3 7 (3.59%) Management Information System
4 4 (2.05%) Data Structures
5 2 (1.03%) Public Cloud
6 1 (0.51%) Computer Science
6 1 (0.51%) EPoS
6 1 (0.51%) SCADA
6 1 (0.51%) Social Media
Operating Systems
1 9 (4.62%) Unix
2 5 (2.56%) Linux
3 4 (2.05%) AIX
4 1 (0.51%) Windows
4 1 (0.51%) Windows Server
Processes & Methodologies
1 117 (60.00%) Business Intelligence
2 103 (52.82%) ETL
3 61 (31.28%) Agile Software Development
4 41 (21.03%) Data Modelling
5 31 (15.90%) Kimball Methodology
6 28 (14.36%) Data Analysis
7 25 (12.82%) Scrum
8 24 (12.31%) Analytics
9 21 (10.77%) Stakeholder Management
10 19 (9.74%) Dimensional Modelling
11 18 (9.23%) DevOps
12 16 (8.21%) Migration
13 15 (7.69%) Continuous Integration
14 13 (6.67%) SDLC
15 11 (5.64%) Data Management
15 11 (5.64%) Data Migration
16 10 (5.13%) Data Architecture
16 10 (5.13%) Data Integration
17 9 (4.62%) Business Analysis
18 8 (4.10%) Visualisation
Programming Languages
1 100 (51.28%) SQL
2 21 (10.77%) T-SQL
3 13 (6.67%) PL/SQL
4 11 (5.64%) Shell Script
5 9 (4.62%) Python
6 5 (2.56%) VBA
7 4 (2.05%) C
7 4 (2.05%) C#
7 4 (2.05%) C++
7 4 (2.05%) Java
7 4 (2.05%) R
8 2 (1.03%) JavaScript
8 2 (1.03%) PROC SQL
9 1 (0.51%) Scala
Qualifications
1 14 (7.18%) Security Cleared
2 9 (4.62%) SC Cleared
3 6 (3.08%) MCSA
3 6 (3.08%) MCSE
3 6 (3.08%) Microsoft Certification
4 5 (2.56%) Degree
5 2 (1.03%) HNC
5 2 (1.03%) HND
6 1 (0.51%) BC Cleared
6 1 (0.51%) Computer Science Degree
6 1 (0.51%) ISEB
6 1 (0.51%) ISTQB
6 1 (0.51%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 10 (5.13%) Data Quality
2 7 (3.59%) GDPR
3 3 (1.54%) IFRS
3 3 (1.54%) IFRS 9
4 1 (0.51%) Disclosure Scotland
4 1 (0.51%) QA
4 1 (0.51%) SLA
System Software
1 2 (1.03%) Hyper-V
1 2 (1.03%) VMware Infrastructure
2 1 (0.51%) ISA Server
Vendors
1 35 (17.95%) Oracle
2 32 (16.41%) Teradata
3 31 (15.90%) Tableau
4 28 (14.36%) Microsoft
5 23 (11.79%) SAP
6 16 (8.21%) MuleSoft
7 14 (7.18%) IBM
8 7 (3.59%) Informatica
9 6 (3.08%) Netezza
10 5 (2.56%) Cognos
11 3 (1.54%) Salesforce.com
12 2 (1.03%) MicroStrategy
12 2 (1.03%) Nintex
12 2 (1.03%) Talend
12 2 (1.03%) VMware
13 1 (0.51%) Anaplan
13 1 (0.51%) Capita
13 1 (0.51%) CODA
13 1 (0.51%) HP
13 1 (0.51%) Hyperion