Period
to 16 October 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 16 October 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
16 Oct 2018
Same period 2017 Same period 2016
Rank 60 59 73
Rank change year-on-year -1 +14 -26
Contract jobs citing Data Warehouse 215 188 159
As % of all contract IT jobs advertised in the South West 3.56% 3.41% 2.74%
As % of the Database & Business Intelligence category 16.45% 17.26% 12.67%
Number of daily rates quoted 171 126 101
South West median daily rate £438 £425 £363
Median daily rate % change year-on-year +2.94% +17.24% -9.38%
10th Percentile £325 £325 £240
90th Percentile £550 £538 £475
England median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 3 1 9
South West median hourly rate £22.00 £13.25 £44.00
Median hourly rate % change year-on-year +66.04% -69.89% +46.67%
10th Percentile £21.00 £12.38 £23.85
90th Percentile £49.43 £14.13 £51.12
England median hourly rate £22.00 £27.00 £38.75
% change year-on-year -18.52% -30.32% +29.17%

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,307 1,089 1,255
As % of all contract IT jobs advertised in the South West 21.61% 19.77% 21.65%
Number of daily rates quoted 915 696 872
South West median daily rate £425 £400 £350
Median daily rate % change year-on-year +6.25% +14.29% -6.67%
10th Percentile £299 £288 £256
90th Percentile £560 £534 £513
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 22 26 29
South West median hourly rate £38.75 £37.25 £32.50
Median hourly rate % change year-on-year +4.03% +14.62% -
10th Percentile £17.29 £14.25 £12.00
90th Percentile £66.35 £54.38 £48.00
England median hourly rate £32.24 £30.50 £28.50
% change year-on-year +5.70% +7.02% +3.64%

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 16 October 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 16 October 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 16 October 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 +2 66 £450 +7.14% 11
Bristol -21 51 £425 +3.03% 8
Wiltshire -11 46 £425 -8.11% 16
Somerset +19 25 £525 +10.53% 1
Devon +12 10 £450 +39.53% 4
Dorset +4 9 £413 +13.79% 12
Cornwall - 2 £500 -
Avon - 1 £400 -
Data Warehouse
England

For the 6 months to 16 October 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 117 (54.42%) Business Intelligence
2 104 (48.37%) SQL
3 92 (42.79%) Finance
4 68 (31.63%) ETL
5 63 (29.30%) Agile Software Development
6 62 (28.84%) SQL Server
7 56 (26.05%) Data Modelling
8 54 (25.12%) Analytical Skills
9 45 (20.93%) Dimensional Modelling
10 43 (20.00%) Data Science
11 38 (17.67%) Data Quality
12 37 (17.21%) Enterprise Data Warehouse
12 37 (17.21%) Problem-Solving
13 34 (15.81%) Analytics
13 34 (15.81%) SQL Server Integration Services
14 32 (14.88%) Visualisation
15 31 (14.42%) Microsoft Azure
15 31 (14.42%) Teradata
15 31 (14.42%) Oracle
15 31 (14.42%) Power BI
16 30 (13.95%) Big Data
16 30 (13.95%) T-SQL
17 27 (12.56%) Data Analysis
17 27 (12.56%) User Stories
18 26 (12.09%) Hadoop
18 26 (12.09%) Manufacturing
19 25 (11.63%) OLAP
19 25 (11.63%) Data Mining
20 24 (11.16%) Kimball Methodology
20 24 (11.16%) 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 24 (11.16%) Apache Spark
2 8 (3.72%) SAS
3 4 (1.86%) SharePoint
4 1 (0.47%) Apache
4 1 (0.47%) Tomcat
4 1 (0.47%) WebSphere
Applications
1 9 (4.19%) Microsoft Excel
2 4 (1.86%) Microsoft Office
3 1 (0.47%) Microsoft Project
3 1 (0.47%) MS Visio
Business Applications
1 2 (0.93%) Dynamics CRM
2 1 (0.47%) Cognos Business Intelligence
2 1 (0.47%) Oracle Financials
Cloud Services
1 31 (14.42%) Microsoft Azure
2 11 (5.12%) Amazon AWS
3 5 (2.33%) PaaS
4 4 (1.86%) Dynamics 365
5 3 (1.40%) Azure Data Factory
5 3 (1.40%) IaaS
6 2 (0.93%) Office 365
7 1 (0.47%) Amazon S3
7 1 (0.47%) Cortana Intelligence Suite
7 1 (0.47%) GitHub
7 1 (0.47%) SaaS
7 1 (0.47%) Trello
Communications & Networking
1 2 (0.93%) Firewall
2 1 (0.47%) VPN
Database & Business Intelligence
1 62 (28.84%) SQL Server
2 37 (17.21%) Enterprise Data Warehouse
3 34 (15.81%) SQL Server Integration Services
4 31 (14.42%) Power BI
5 30 (13.95%) Big Data
6 26 (12.09%) Hadoop
7 25 (11.63%) Data Mining
7 25 (11.63%) OLAP
8 23 (10.70%) Apache Hive
8 23 (10.70%) Star Schema
9 22 (10.23%) IBM InfoSphere
10 21 (9.77%) OLAP Cube
11 19 (8.84%) Relational Database
12 17 (7.91%) RDBMS
12 17 (7.91%) SQL Server Reporting Services
13 16 (7.44%) DataStage
14 15 (6.98%) BusinessObjects
15 12 (5.58%) SQL Server Analysis Services
16 8 (3.72%) SQL Server 2016
17 7 (3.26%) Oracle ODI
Development Applications
1 8 (3.72%) ERwin
2 7 (3.26%) Visual Studio
3 5 (2.33%) JIRA
4 4 (1.86%) Git (software)
4 4 (1.86%) Team Foundation Server
5 3 (1.40%) GitLab
5 3 (1.40%) Visual Studio Team System
6 2 (0.93%) Cucumber
6 2 (0.93%) Jenkins
6 2 (0.93%) Selenium
7 1 (0.47%) Oracle Forms
7 1 (0.47%) SQL Server Management Studio (SSMS)
General
1 92 (42.79%) Finance
2 26 (12.09%) Manufacturing
3 19 (8.84%) Retail
4 14 (6.51%) Automotive
5 13 (6.05%) Banking
6 8 (3.72%) Retail Banking
7 5 (2.33%) Electronics
7 5 (2.33%) Marketing
7 5 (2.33%) Telecoms
8 2 (0.93%) Legal
9 1 (0.47%) Billing
9 1 (0.47%) Investment Banking
9 1 (0.47%) Publishing
Job Titles
1 58 (26.98%) Analyst
2 51 (23.72%) Developer
3 33 (15.35%) Business Analyst
4 28 (13.02%) Business Intelligence Analyst
5 22 (10.23%) Business Intelligence Business Analyst
5 22 (10.23%) Hadoop Engineer
5 22 (10.23%) Project Manager
6 21 (9.77%) Data Engineer
7 20 (9.30%) Architect
7 20 (9.30%) Data Analyst
8 17 (7.91%) ETL Developer
9 16 (7.44%) Business Intelligence Developer
10 13 (6.05%) Big Data Engineer
11 11 (5.12%) Business Intelligence Manager
12 10 (4.65%) Consultant
13 9 (4.19%) Business Intelligence Project Manager
13 9 (4.19%) DBA
13 9 (4.19%) SQL Developer
14 8 (3.72%) Data Architect
14 8 (3.72%) DataStage ETL Developer
Libraries, Frameworks & Software Standards
1 21 (9.77%) Kafka
2 7 (3.26%) .NET
3 4 (1.86%) ASP.NET
4 3 (1.40%) ASP.NET Web API
4 3 (1.40%) XML
5 2 (0.93%) J2EE
5 2 (0.93%) Web Services
6 1 (0.47%) .NET Framework
6 1 (0.47%) Doctrine
6 1 (0.47%) JSON
6 1 (0.47%) MDX
6 1 (0.47%) OAuth
6 1 (0.47%) OAuth2
6 1 (0.47%) REST
6 1 (0.47%) SAML
Miscellaneous
1 54 (25.12%) Analytical Skills
2 12 (5.58%) NHS
3 10 (4.65%) Management Information System
4 7 (3.26%) Data Structures
5 3 (1.40%) Computer Science
5 3 (1.40%) Reference Data
5 3 (1.40%) Self-Motivation
6 2 (0.93%) Data Centre
6 2 (0.93%) Greenfield Project
6 2 (0.93%) Mainframe
6 2 (0.93%) Taxonomies
7 1 (0.47%) Clustering
7 1 (0.47%) Derivative
7 1 (0.47%) Fintech
7 1 (0.47%) Hybrid Cloud
7 1 (0.47%) Private Cloud
7 1 (0.47%) Replication
7 1 (0.47%) User Experience
Operating Systems
1 14 (6.51%) Linux
2 13 (6.05%) Unix
3 8 (3.72%) Windows
4 7 (3.26%) Windows Server
5 1 (0.47%) Red Hat Enterprise Linux
Processes & Methodologies
1 117 (54.42%) Business Intelligence
2 68 (31.63%) ETL
3 63 (29.30%) Agile Software Development
4 56 (26.05%) Data Modelling
5 45 (20.93%) Dimensional Modelling
6 43 (20.00%) Data Science
7 37 (17.21%) Problem-Solving
8 34 (15.81%) Analytics
9 32 (14.88%) Visualisation
10 27 (12.56%) Data Analysis
10 27 (12.56%) User Stories
11 24 (11.16%) Kimball Methodology
12 22 (10.23%) People Management
12 22 (10.23%) Stakeholder Management
13 21 (9.77%) Machine Learning
13 21 (9.77%) Scrum
13 21 (9.77%) SQL Optimisation
14 20 (9.30%) Data Management
15 18 (8.37%) Migration
16 17 (7.91%) Data Integration
Programming Languages
1 104 (48.37%) SQL
2 30 (13.95%) T-SQL
3 9 (4.19%) PL/SQL
4 7 (3.26%) Shell Script
5 5 (2.33%) PowerShell
6 4 (1.86%) Java
6 4 (1.86%) R
6 4 (1.86%) VBA
7 3 (1.40%) C
7 3 (1.40%) C#
7 3 (1.40%) Data Analysis Expressions (DAX)
8 2 (0.93%) Bash Shell
9 1 (0.47%) JavaScript
9 1 (0.47%) PHP
9 1 (0.47%) VB
9 1 (0.47%) VB.NET
Qualifications
1 15 (6.98%) Security Cleared
2 14 (6.51%) SC Cleared
3 3 (1.40%) Degree
3 3 (1.40%) TOGAF Certification
4 2 (0.93%) Computer Science Degree
4 2 (0.93%) PMI Certification
4 2 (0.93%) PMP
4 2 (0.93%) PRINCE2 Practitioner
5 1 (0.47%) AWS Certification
5 1 (0.47%) BPSS Clearance
5 1 (0.47%) Master's Degree
Quality Assurance & Compliance
1 38 (17.67%) Data Quality
2 12 (5.58%) PMO
3 5 (2.33%) QA
4 4 (1.86%) GDPR
5 1 (0.47%) IFRS
5 1 (0.47%) Solvency II
System Software
1 5 (2.33%) Docker
2 2 (0.93%) Active Directory
2 2 (0.93%) HDFS
3 1 (0.47%) Virtual Machines
Systems Management
1 21 (9.77%) Oozie
2 5 (2.33%) Kubernetes
3 4 (1.86%) Ansible
4 3 (1.40%) HP Quality Center
5 1 (0.47%) Data Guard
5 1 (0.47%) NetIQ Identity Manager
5 1 (0.47%) Oracle Enterprise Manager
5 1 (0.47%) Single Sign-On
5 1 (0.47%) Terraform
Vendors
1 31 (14.42%) Oracle
1 31 (14.42%) Teradata
2 22 (10.23%) Microsoft
3 15 (6.98%) Tableau
4 11 (5.12%) IBM
5 8 (3.72%) SAP
6 7 (3.26%) MicroStrategy
6 7 (3.26%) Netezza
7 2 (0.93%) Cognos
7 2 (0.93%) Hortonworks
7 2 (0.93%) Informatica
7 2 (0.93%) Salesforce.com
8 1 (0.47%) Alteryx
8 1 (0.47%) DataFlux
8 1 (0.47%) MuleSoft
8 1 (0.47%) NetIQ
8 1 (0.47%) Red Hat
8 1 (0.47%) Sybase
8 1 (0.47%) Talend
8 1 (0.47%) Zend