Period
to 20 August 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 20 August 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
20 Aug 2018
Same period 2017 Same period 2016
Rank 57 70 78
Rank change year-on-year +13 +8 -31
Contract jobs citing Data Warehouse 198 159 146
As % of all contract IT jobs advertised in the South West 3.60% 2.93% 2.49%
As % of the Database & Business Intelligence category 16.71% 15.14% 12.16%
Number of daily rates quoted 162 102 103
South West median daily rate £450 £419 £390
Median daily rate % change year-on-year +7.46% +7.37% +4.00%
10th Percentile £351 £308 £251
90th Percentile £550 £538 £573
England median daily rate £463 £450 £430
% change year-on-year +2.78% +4.65% +1.18%
Number of hourly rates quoted 2 1 7
South West median hourly rate £96.29 £13.25 £44.00
Median hourly rate % change year-on-year +626.70% -69.89% +46.67%
10th Percentile £57.70 £12.38 £28.15
90th Percentile £136.10 £14.13 £49.20
England median hourly rate £30.75 £19.50 £30.00
% change year-on-year +57.69% -35.00% -8.40%

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,185 1,050 1,201
As % of all contract IT jobs advertised in the South West 21.57% 19.35% 20.49%
Number of daily rates quoted 855 660 840
South West median daily rate £413 £400 £370
Median daily rate % change year-on-year +3.13% +8.11% -1.33%
10th Percentile £285 £275 £263
90th Percentile £538 £525 £538
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 13 26 27
South West median hourly rate £37.50 £39.50 £33.00
Median hourly rate % change year-on-year -5.06% +19.70% +6.45%
10th Percentile £17.42 £12.94 £12.00
90th Percentile £67.21 £49.38 £48.00
England median hourly rate £30.00 £30.00 £28.50
% change year-on-year - +5.26% +4.34%

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 20 August 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 20 August 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 20 August 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
Bristol -2 59 £450 +11.11% 4
Gloucestershire +12 55 £450 +5.88% 11
Wiltshire -2 38 £425 -8.11% 2
Somerset +24 20 £525 +105.88% 2
Devon +9 14 £375 +15.38% 8
Dorset -2 7 £413 -17.09% 4
Avon - 1 £400 -
Data Warehouse
England

For the 6 months to 20 August 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 106 (53.54%) SQL
2 102 (51.52%) Business Intelligence
3 87 (43.94%) Finance
4 65 (32.83%) Data Modelling
4 65 (32.83%) ETL
5 63 (31.82%) Agile Software Development
6 47 (23.74%) SQL Server
7 43 (21.72%) Analytical Skills
8 39 (19.70%) Analytics
9 38 (19.19%) Dimensional Modelling
10 37 (18.69%) Data Science
11 35 (17.68%) Data Quality
11 35 (17.68%) Enterprise Data Warehouse
12 33 (16.67%) SQL Server Integration Services
12 33 (16.67%) Oracle
13 32 (16.16%) Teradata
13 32 (16.16%) Problem-Solving
14 29 (14.65%) Big Data
15 27 (13.64%) Star Schema
15 27 (13.64%) Hadoop
16 26 (13.13%) Data Analysis
16 26 (13.13%) T-SQL
17 24 (12.12%) Visualisation
17 24 (12.12%) Microsoft Azure
17 24 (12.12%) Kimball Methodology
17 24 (12.12%) Relational Database
18 23 (11.62%) OLAP
19 22 (11.11%) Microsoft
19 22 (11.11%) Manufacturing
19 22 (11.11%) Apache Spark

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 22 (11.11%) Apache Spark
2 8 (4.04%) Confluence
2 8 (4.04%) SAS
3 3 (1.52%) SharePoint
4 1 (0.51%) Apache
4 1 (0.51%) MS Exchange
4 1 (0.51%) Tomcat
4 1 (0.51%) WebSphere
Applications
1 6 (3.03%) Microsoft Excel
2 3 (1.52%) Microsoft Office
3 2 (1.01%) MS Visio
4 1 (0.51%) Microsoft Project
Business Applications
1 1 (0.51%) Cognos Business Intelligence
1 1 (0.51%) Dynamics CRM
1 1 (0.51%) Oracle Financials
Cloud Services
1 24 (12.12%) Microsoft Azure
2 9 (4.55%) Amazon AWS
3 4 (2.02%) Azure Data Factory
4 1 (0.51%) Amazon S3
4 1 (0.51%) Cortana Intelligence Suite
4 1 (0.51%) Dynamics 365
4 1 (0.51%) GitHub
4 1 (0.51%) IaaS
4 1 (0.51%) Office 365
4 1 (0.51%) PaaS
4 1 (0.51%) Trello
Communications & Networking
1 2 (1.01%) Firewall
2 1 (0.51%) DHCP
2 1 (0.51%) DNS
2 1 (0.51%) Internet
Database & Business Intelligence
1 47 (23.74%) SQL Server
2 35 (17.68%) Enterprise Data Warehouse
3 33 (16.67%) SQL Server Integration Services
4 29 (14.65%) Big Data
5 27 (13.64%) Hadoop
5 27 (13.64%) Star Schema
6 24 (12.12%) Relational Database
7 23 (11.62%) OLAP
8 21 (10.61%) Apache Hive
8 21 (10.61%) IBM InfoSphere
8 21 (10.61%) OLAP Cube
8 21 (10.61%) Power BI
9 20 (10.10%) DataStage
10 19 (9.60%) Data Mining
11 17 (8.59%) BusinessObjects
12 15 (7.58%) RDBMS
13 14 (7.07%) SQL Server Reporting Services
14 9 (4.55%) SQL Server Analysis Services
15 8 (4.04%) Oracle ODI
16 7 (3.54%) DB2
Development Applications
1 13 (6.57%) JIRA
2 9 (4.55%) ERwin
3 7 (3.54%) Visual Studio
4 4 (2.02%) Git (software)
4 4 (2.02%) Team Foundation Server
5 3 (1.52%) GitLab
5 3 (1.52%) SQL Server Management Studio (SSMS)
6 2 (1.01%) Visual Studio Team System
7 1 (0.51%) Cucumber
7 1 (0.51%) Jenkins
7 1 (0.51%) Selenium
General
1 87 (43.94%) Finance
2 22 (11.11%) Manufacturing
3 19 (9.60%) Retail
4 18 (9.09%) Banking
5 14 (7.07%) Automotive
6 12 (6.06%) Retail Banking
7 3 (1.52%) Electronics
7 3 (1.52%) Marketing
7 3 (1.52%) Telecoms
8 1 (0.51%) Legal
Job Titles
1 55 (27.78%) Developer
2 49 (24.75%) Analyst
3 25 (12.63%) Business Intelligence Analyst
4 23 (11.62%) Data Engineer
5 22 (11.11%) ETL Developer
6 21 (10.61%) Business Analyst
6 21 (10.61%) Hadoop Engineer
7 19 (9.60%) Project Manager
8 18 (9.09%) Data Analyst
9 17 (8.59%) Business Intelligence Business Analyst
10 15 (7.58%) Architect
11 13 (6.57%) Big Data Engineer
12 12 (6.06%) Business Intelligence Developer
13 11 (5.56%) Data Warehouse Developer
13 11 (5.56%) SQL Developer
14 10 (5.05%) Consultant
15 9 (4.55%) DBA
16 8 (4.04%) Business Intelligence Manager
16 8 (4.04%) DataStage Developer
16 8 (4.04%) DataStage ETL Developer
Libraries, Frameworks & Software Standards
1 21 (10.61%) Kafka
2 5 (2.53%) .NET
3 4 (2.02%) XML
4 3 (1.52%) ASP.NET
5 2 (1.01%) ASP.NET Web API
5 2 (1.01%) Velocity
5 2 (1.01%) Web Services
6 1 (0.51%) Ajax
6 1 (0.51%) CSS
6 1 (0.51%) Doctrine
6 1 (0.51%) HTML
6 1 (0.51%) J2EE
6 1 (0.51%) JSON
6 1 (0.51%) MDX
6 1 (0.51%) REST
6 1 (0.51%) XHTML
6 1 (0.51%) XML Schema
Miscellaneous
1 43 (21.72%) Analytical Skills
2 10 (5.05%) NHS
3 6 (3.03%) Data Structures
3 6 (3.03%) Management Information System
4 5 (2.53%) Self-Motivation
5 4 (2.02%) Linked Data
6 2 (1.01%) Computer Science
6 2 (1.01%) Greenfield Project
7 1 (0.51%) Clustering
7 1 (0.51%) Derivative
7 1 (0.51%) Fintech
7 1 (0.51%) Hybrid Cloud
7 1 (0.51%) Reference Data
7 1 (0.51%) Replication
7 1 (0.51%) User Experience
Operating Systems
1 14 (7.07%) Unix
2 12 (6.06%) Linux
3 9 (4.55%) Windows
4 8 (4.04%) Windows Server
5 1 (0.51%) Red Hat Enterprise Linux
5 1 (0.51%) Windows 8
5 1 (0.51%) Windows Server 2008
5 1 (0.51%) Windows XP
Processes & Methodologies
1 102 (51.52%) Business Intelligence
2 65 (32.83%) Data Modelling
2 65 (32.83%) ETL
3 63 (31.82%) Agile Software Development
4 39 (19.70%) Analytics
5 38 (19.19%) Dimensional Modelling
6 37 (18.69%) Data Science
7 32 (16.16%) Problem-Solving
8 26 (13.13%) Data Analysis
9 24 (12.12%) Kimball Methodology
9 24 (12.12%) Visualisation
10 21 (10.61%) Machine Learning
10 21 (10.61%) SQL Optimisation
10 21 (10.61%) User Stories
11 19 (9.60%) Scrum
11 19 (9.60%) Stakeholder Management
12 16 (8.08%) Data Governance
12 16 (8.08%) People Management
13 15 (7.58%) Master Data Management
13 15 (7.58%) SDLC
Programming Languages
1 106 (53.54%) SQL
2 26 (13.13%) T-SQL
3 16 (8.08%) PL/SQL
4 10 (5.05%) Shell Script
5 6 (3.03%) Java
6 3 (1.52%) C
6 3 (1.52%) C#
6 3 (1.52%) PowerShell
6 3 (1.52%) R
7 2 (1.01%) JavaScript
8 1 (0.51%) Bash Shell
8 1 (0.51%) Data Analysis Expressions (DAX)
8 1 (0.51%) Korn
8 1 (0.51%) PHP
8 1 (0.51%) VB
8 1 (0.51%) VB.NET
8 1 (0.51%) VBA
Qualifications
1 20 (10.10%) Security Cleared
2 17 (8.59%) SC Cleared
3 3 (1.52%) TOGAF Certification
4 2 (1.01%) DBS Check
4 2 (1.01%) Degree
5 1 (0.51%) AWS Certification
5 1 (0.51%) BPSS Clearance
5 1 (0.51%) Computer Science Degree
5 1 (0.51%) Master's Degree
5 1 (0.51%) MCSA
5 1 (0.51%) MCSE
5 1 (0.51%) Microsoft Certification
5 1 (0.51%) PMI Certification
5 1 (0.51%) PMP
5 1 (0.51%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 35 (17.68%) Data Quality
2 10 (5.05%) PMO
3 7 (3.54%) QA
4 5 (2.53%) GDPR
5 1 (0.51%) IFRS
5 1 (0.51%) Solvency II
System Software
1 4 (2.02%) Docker
2 2 (1.01%) Active Directory
3 1 (0.51%) Hyper-V
3 1 (0.51%) VMware Infrastructure
Systems Management
1 21 (10.61%) Oozie
2 5 (2.53%) Kubernetes
3 4 (2.02%) Ansible
4 2 (1.01%) HP Quality Center
5 1 (0.51%) Data Guard
5 1 (0.51%) Oracle Enterprise Manager
5 1 (0.51%) Terraform
Vendors
1 33 (16.67%) Oracle
2 32 (16.16%) Teradata
3 22 (11.11%) Microsoft
4 19 (9.60%) IBM
5 12 (6.06%) Tableau
6 9 (4.55%) Cognos
7 8 (4.04%) SAP
8 7 (3.54%) Netezza
9 6 (3.03%) Talend
10 5 (2.53%) MicroStrategy
11 2 (1.01%) Informatica
11 2 (1.01%) Salesforce.com
12 1 (0.51%) Alteryx
12 1 (0.51%) DataFlux
12 1 (0.51%) HP
12 1 (0.51%) MuleSoft
12 1 (0.51%) Red Hat
12 1 (0.51%) Sybase
12 1 (0.51%) VMware
12 1 (0.51%) Zend