Period
to 20 November 2018

The following table provides summary statistics for contract job vacancies advertised in Scotland 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 November 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
UK > Scotland
6 months to
20 Nov 2018
Same period 2017 Same period 2016
Rank 96 72 58
Rank change year-on-year -24 -14 -14
Contract jobs citing Data Warehouse 110 132 135
As % of all contract IT jobs advertised in Scotland 2.08% 2.65% 3.14%
As % of the Database & Business Intelligence category 10.11% 13.28% 13.15%
Number of daily rates quoted 68 68 84
Scotland median daily rate £425 £413 £400
Median daily rate % change year-on-year +3.03% +3.13% +4.92%
10th Percentile £332 £313 £302
90th Percentile £579 £506 £525
UK median daily rate £450 £450 £433
% change year-on-year - +4.05% +1.76%
Number of hourly rates quoted 1 0 0
Scotland median hourly rate £11.00 - -
UK median hourly rate £18.50 £27.50 £42.00
% change year-on-year -32.73% -34.52% +65.09%

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

All Database and Business Intelligence Skills
Scotland
Contract vacancies with a requirement for database or business intelligence skills 1,088 994 1,027
As % of all contract IT jobs advertised in Scotland 20.53% 19.98% 23.91%
Number of daily rates quoted 614 542 568
Scotland median daily rate £400 £396 £350
Median daily rate % change year-on-year +0.95% +13.21% -6.67%
10th Percentile £305 £290 £261
90th Percentile £543 £525 £475
UK median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 7 14 19
Scotland median hourly rate £32.50 £42.70 £42.00
Median hourly rate % change year-on-year -23.88% +1.65% +46.28%
10th Percentile £13.70 £15.11 £9.37
90th Percentile £35.00 £195.00 £52.00
UK median hourly rate £33.50 £31.15 £28.18
% change year-on-year +7.54% +10.54% -2.83%

Data Warehouse
Job Vacancy Trend in Scotland

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

Job vacancy trend for Data Warehouse in Scotland

Data Warehouse
Contractor Daily Rate Trend in Scotland

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

Contractor daily rate trend for Data Warehouse in Scotland

Data Warehouse
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing Data Warehouse in Scotland over the 6 months to 20 November 2018.

Contractor daily rate histogram for Data Warehouse in Scotland

Data Warehouse
Contractor Hourly Rate Trend in Scotland

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

Contractor hourly rate trend for Data Warehouse in Scotland

Data Warehouse
Contract Job Locations in Scotland

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 Scotland region over the 6 months to 20 November 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
Edinburgh -13 74 £475 +13.43% 7
Glasgow -14 33 £375 -9.09% 19
Lanarkshire - 1 - -
Data Warehouse
UK

For the 6 months to 20 November 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 Scotland region with a requirement for Data Warehouse.

1 72 (65.45%) ETL
2 65 (59.09%) SQL
3 48 (43.64%) SQL Server
4 47 (42.73%) Business Intelligence
5 36 (32.73%) Oracle
6 30 (27.27%) Ab Initio
7 26 (23.64%) Agile Software Development
7 26 (23.64%) Data Modelling
8 25 (22.73%) Power BI
9 24 (21.82%) Teradata
9 24 (21.82%) Finance
9 24 (21.82%) SQL Server Reporting Services
10 23 (20.91%) Retail
10 23 (20.91%) SQL Server Integration Services
11 20 (18.18%) Unix
12 19 (17.27%) Microsoft
12 19 (17.27%) Shell Script
12 19 (17.27%) Big Data
13 18 (16.36%) ETL Development
13 18 (16.36%) Migration
14 17 (15.45%) SQL Server Analysis Services
14 17 (15.45%) Data Integration
15 16 (14.55%) User Acceptance Testing
16 15 (13.64%) Data Migration
17 14 (12.73%) Hadoop
17 14 (12.73%) Tableau
17 14 (12.73%) Banking
17 14 (12.73%) QA
18 13 (11.82%) Analytics
18 13 (11.82%) Microsoft Azure

Data Warehouse
Co-occurring IT Skills in Scotland 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 2 (1.82%) Apache Spark
2 1 (0.91%) SAS
Applications
1 4 (3.64%) Microsoft Excel
2 1 (0.91%) Adobe Illustrator
2 1 (0.91%) Photoshop
Business Applications
1 3 (2.73%) Dynamics CRM
2 2 (1.82%) Dynamics AX
3 1 (0.91%) Cognos Business Intelligence
3 1 (0.91%) Cognos TM1
3 1 (0.91%) Markit EDM
Cloud Services
1 13 (11.82%) Microsoft Azure
2 10 (9.09%) Azure Data Factory
3 9 (8.18%) Dynamics 365
3 9 (8.18%) PaaS
4 5 (4.55%) Amazon AWS
5 3 (2.73%) Office 365
6 2 (1.82%) Amazon S3
7 1 (0.91%) Adobe Creative Cloud
7 1 (0.91%) Amazon EMR
7 1 (0.91%) Amazon SageMaker
7 1 (0.91%) Google Cloud Platform
Database & Business Intelligence
1 48 (43.64%) SQL Server
2 25 (22.73%) Power BI
3 24 (21.82%) SQL Server Reporting Services
4 23 (20.91%) SQL Server Integration Services
5 19 (17.27%) Big Data
6 17 (15.45%) SQL Server Analysis Services
7 14 (12.73%) Hadoop
8 12 (10.91%) OLAP
9 11 (10.00%) Data Lake
9 11 (10.00%) Microsoft Analysis Services
10 9 (8.18%) Azure SQL Database
10 9 (8.18%) HDInsight
10 9 (8.18%) Oracle Database
10 9 (8.18%) Relational Database
11 8 (7.27%) RDBMS
12 5 (4.55%) BusinessObjects
13 3 (2.73%) BusinessObjects Web Intelligence
13 3 (2.73%) MySQL
13 3 (2.73%) NoSQL
13 3 (2.73%) Pentaho
Development Applications
1 3 (2.73%) Hudson
1 3 (2.73%) Visual Studio
2 1 (0.91%) Axure RP
2 1 (0.91%) ER Studio
2 1 (0.91%) ERwin
2 1 (0.91%) HP UFT
2 1 (0.91%) JIRA
General
1 24 (21.82%) Finance
2 23 (20.91%) Retail
3 14 (12.73%) Banking
4 4 (3.64%) Manufacturing
5 3 (2.73%) Telecoms
6 2 (1.82%) Corporate Banking
6 2 (1.82%) Financial Institution
6 2 (1.82%) Marketing
6 2 (1.82%) Retail Banking
7 1 (0.91%) Electronics
Job Titles
1 68 (61.82%) Developer
2 28 (25.45%) Ab Initio Developer
3 18 (16.36%) Analyst
4 12 (10.91%) ETL Developer
5 11 (10.00%) SQL Developer
6 10 (9.09%) Data Analyst
7 8 (7.27%) Business Intelligence Developer
8 7 (6.36%) Architect
8 7 (6.36%) Data Architect
9 6 (5.45%) Consultant
9 6 (5.45%) SQL Analyst
10 5 (4.55%) Business Developer
10 5 (4.55%) SQL Data Analyst
11 4 (3.64%) SAP BusinessObjects (BO) Developer
12 3 (2.73%) Business Analyst
12 3 (2.73%) Data Migration Analyst
12 3 (2.73%) Data Warehouse Analyst
12 3 (2.73%) Migration Analyst
12 3 (2.73%) Oracle Developer
12 3 (2.73%) Test Analyst
Libraries, Frameworks & Software Standards
1 3 (2.73%) JSON
1 3 (2.73%) SOAP
1 3 (2.73%) XML
2 2 (1.82%) .NET
3 1 (0.91%) AngularJS
3 1 (0.91%) Ext JS
3 1 (0.91%) HTML
3 1 (0.91%) HTML5
3 1 (0.91%) JMS
3 1 (0.91%) React
3 1 (0.91%) Spring
3 1 (0.91%) Web Services
Miscellaneous
1 5 (4.55%) Analytical Skills
2 3 (2.73%) Data Structures
2 3 (2.73%) NHS
3 2 (1.82%) AS400
3 2 (1.82%) Management Information System
3 2 (1.82%) Self-Motivation
4 1 (0.91%) Data Centre
4 1 (0.91%) Greenfield Project
4 1 (0.91%) Private Cloud
4 1 (0.91%) Reference Data
4 1 (0.91%) Replication
4 1 (0.91%) User Experience
Operating Systems
1 20 (18.18%) Unix
2 1 (0.91%) Linux
Processes & Methodologies
1 72 (65.45%) ETL
2 47 (42.73%) Business Intelligence
3 26 (23.64%) Agile Software Development
3 26 (23.64%) Data Modelling
4 18 (16.36%) ETL Development
4 18 (16.36%) Migration
5 17 (15.45%) Data Integration
6 16 (14.55%) User Acceptance Testing
7 15 (13.64%) Data Migration
8 13 (11.82%) Analytics
9 12 (10.91%) Visualisation
10 11 (10.00%) Data Analysis
11 10 (9.09%) Metadata Management
12 9 (8.18%) Machine Learning
13 8 (7.27%) Investment Management
14 7 (6.36%) Data Strategy
14 7 (6.36%) Digital Transformation Programme
14 7 (6.36%) Service Design
15 6 (5.45%) Business Analysis
15 6 (5.45%) Performance Tuning
Programming Languages
1 65 (59.09%) SQL
2 19 (17.27%) Shell Script
3 11 (10.00%) T-SQL
4 2 (1.82%) C#
4 2 (1.82%) PL/SQL
4 2 (1.82%) Python
4 2 (1.82%) X++
5 1 (0.91%) C
5 1 (0.91%) Java
5 1 (0.91%) Java 8
5 1 (0.91%) R
5 1 (0.91%) Scala
5 1 (0.91%) VBA
Qualifications
1 2 (1.82%) Security Cleared
2 1 (0.91%) BC Cleared
2 1 (0.91%) BPSS Clearance
2 1 (0.91%) Degree
Quality Assurance & Compliance
1 14 (12.73%) QA
2 5 (4.55%) Data Quality
3 3 (2.73%) PMO
4 1 (0.91%) GDPR
System Software
1 1 (0.91%) HDFS
Systems Management
1 2 (1.82%) SCCM
2 1 (0.91%) HP Quality Center
Vendors
1 36 (32.73%) Oracle
2 30 (27.27%) Ab Initio
3 24 (21.82%) Teradata
4 19 (17.27%) Microsoft
5 14 (12.73%) Tableau
6 9 (8.18%) Informatica
7 4 (3.64%) SAP
8 2 (1.82%) IBM
8 2 (1.82%) Sybase
8 2 (1.82%) Talend
9 1 (0.91%) Adobe
9 1 (0.91%) Cognos