Period
to 19 November 2017

The following table provides summary statistics for contract job vacancies advertised in Edinburgh 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 19 November 2017 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
Scotland > Edinburgh
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 57 51 37
Rank change year-on-year -6 -14 -8
Contract jobs citing Data Warehouse 84 76 119
As % of all contract IT jobs advertised in Edinburgh 2.91% 3.56% 3.71%
As % of the Database & Business Intelligence category 15.76% 16.34% 21.40%
Number of daily rates quoted 40 56 68
Edinburgh median daily rate £419 £400 £418
Median daily rate % change year-on-year +4.69% -4.19% +4.38%
10th Percentile £325 £303 £290
90th Percentile £489 £525 £538
Scotland median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% -2.28%
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate - - -

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

All Database and Business Intelligence Skills
Edinburgh
Contract vacancies with a requirement for database or business intelligence skills 533 465 556
As % of all contract IT jobs advertised in Edinburgh 18.44% 21.80% 17.34%
Number of daily rates quoted 287 244 311
Edinburgh median daily rate £400 £365 £400
Median daily rate % change year-on-year +9.59% -8.75% +6.67%
10th Percentile £308 £263 £275
90th Percentile £530 £513 £538
Scotland median daily rate £395 £350 £375
% change year-on-year +12.86% -6.67% +4.90%
Number of hourly rates quoted 2 8 5
Edinburgh median hourly rate £43.39 £49.63 £32.43
Median hourly rate % change year-on-year -12.56% +53.05% +31.01%
Scotland median hourly rate £42.70 £42.00 £28.71
% change year-on-year +1.65% +46.28% +4.41%

Data Warehouse
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Data Warehouse in Edinburgh

Data Warehouse
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for Data Warehouse in Edinburgh

Data Warehouse
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing Data Warehouse in Edinburgh over the 6 months to 19 November 2017.

Contractor daily rate histogram for Data Warehouse in Edinburgh

Data Warehouse
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for Data Warehouse in Edinburgh

For the 6 months to 19 November 2017, 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 Edinburgh region with a requirement for Data Warehouse.

1 37 (44.05%) SQL
2 36 (42.86%) Finance
3 33 (39.29%) ETL
4 28 (33.33%) Oracle
5 27 (32.14%) Banking
6 26 (30.95%) Agile Software Development
7 22 (26.19%) Business Intelligence
8 19 (22.62%) Migration
9 18 (21.43%) Teradata
10 17 (20.24%) Informatica
11 16 (19.05%) SQL Server
12 14 (16.67%) Hadoop
13 13 (15.48%) Big Data
13 13 (15.48%) Retail Banking
13 13 (15.48%) Microsoft
14 12 (14.29%) T-SQL
15 11 (13.10%) SQL Server Reporting Services
16 10 (11.90%) SQL Server Analysis Services
17 9 (10.71%) SAS
17 9 (10.71%) PowerCenter
17 9 (10.71%) Data Migration
17 9 (10.71%) Analytical Skills
18 8 (9.52%) Data Integration
18 8 (9.52%) Amazon AWS
19 7 (8.33%) Stakeholder Management
19 7 (8.33%) Data Modelling
19 7 (8.33%) SharePoint
19 7 (8.33%) Data Analysis
19 7 (8.33%) SQL Server 2012
20 6 (7.14%) Cloudera

Data Warehouse
Co-occurring IT Skills in Edinburgh 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 9 (10.71%) SAS
2 7 (8.33%) SharePoint
Applications
1 2 (2.38%) Microsoft Excel
2 1 (1.19%) Microsoft Project
2 1 (1.19%) MS Visio
2 1 (1.19%) Spreadsheet
Business Applications
1 1 (1.19%) Dynamics CRM
1 1 (1.19%) Markit EDM
Cloud Services
1 8 (9.52%) Amazon AWS
2 2 (2.38%) Microsoft Azure
3 1 (1.19%) Amazon S3
3 1 (1.19%) Google Cloud Platform
3 1 (1.19%) Office 365
Communications & Networking
1 1 (1.19%) Internet
Database & Business Intelligence
1 16 (19.05%) SQL Server
2 14 (16.67%) Hadoop
3 13 (15.48%) Big Data
4 11 (13.10%) SQL Server Reporting Services
5 10 (11.90%) SQL Server Analysis Services
6 9 (10.71%) PowerCenter
7 7 (8.33%) SQL Server 2012
8 6 (7.14%) Oracle Database
8 6 (7.14%) Oracle Reports
8 6 (7.14%) PowerPivot
8 6 (7.14%) SQL Server Integration Services
9 5 (5.95%) Power BI
10 4 (4.76%) Oracle BI EE
11 3 (3.57%) BusinessObjects XI
11 3 (3.57%) Enterprise Data Warehouse
11 3 (3.57%) GIS
11 3 (3.57%) Spatial Data
11 3 (3.57%) SQL Server 2008
12 2 (2.38%) PostgreSQL
12 2 (2.38%) SAP BW
Development Applications
1 6 (7.14%) Team Foundation Server
2 2 (2.38%) ERwin
3 1 (1.19%) Talend Open Studio
3 1 (1.19%) Toad
General
1 36 (42.86%) Finance
2 27 (32.14%) Banking
3 13 (15.48%) Retail Banking
4 2 (2.38%) Investment Banking
Job Titles
1 26 (30.95%) Developer
2 25 (29.76%) Analyst
3 15 (17.86%) SQL Developer
4 12 (14.29%) Architect
4 12 (14.29%) Data Architect
5 9 (10.71%) Business Intelligence Developer
5 9 (10.71%) Data Analyst
6 8 (9.52%) Consultant
7 7 (8.33%) Informatica Developer
7 7 (8.33%) Test Analyst
8 6 (7.14%) Business Analyst
8 6 (7.14%) Data Warehouse Analyst
8 6 (7.14%) Migration Architect
8 6 (7.14%) Oracle Developer
9 5 (5.95%) Financial Analyst
9 5 (5.95%) SQL BI Developer
9 5 (5.95%) SQL Server Developer
10 4 (4.76%) Data Consultant
10 4 (4.76%) Senior Test Analyst
10 4 (4.76%) Service Analyst
Libraries, Frameworks & Software Standards
1 2 (2.38%) PostGIS
1 2 (2.38%) Web Services
2 1 (1.19%) Middleware
Miscellaneous
1 9 (10.71%) Analytical Skills
2 2 (2.38%) Greenfield Project
2 2 (2.38%) Management Information System
3 1 (1.19%) N-Tier
3 1 (1.19%) Smart City
Operating Systems
1 6 (7.14%) Unix
2 2 (2.38%) Linux
2 2 (2.38%) Windows
Processes & Methodologies
1 33 (39.29%) ETL
2 26 (30.95%) Agile Software Development
3 22 (26.19%) Business Intelligence
4 19 (22.62%) Migration
5 9 (10.71%) Data Migration
6 8 (9.52%) Data Integration
7 7 (8.33%) Data Analysis
7 7 (8.33%) Data Modelling
7 7 (8.33%) Stakeholder Management
8 5 (5.95%) Analytics
8 5 (5.95%) Asset Management
8 5 (5.95%) Customer Engagement
8 5 (5.95%) Data Architecture
8 5 (5.95%) TOGAF
8 5 (5.95%) User Acceptance Testing
9 4 (4.76%) Project Management
9 4 (4.76%) Test Scripting
9 4 (4.76%) Visualisation
10 3 (3.57%) Scrum
10 3 (3.57%) Workflow
Programming Languages
1 37 (44.05%) SQL
2 12 (14.29%) T-SQL
3 5 (5.95%) PowerShell
4 3 (3.57%) PL/SQL
4 3 (3.57%) Python
5 2 (2.38%) Bash Shell
5 2 (2.38%) C++
6 1 (1.19%) COBOL
6 1 (1.19%) Data Analysis Expressions (DAX)
6 1 (1.19%) JCL
6 1 (1.19%) R
6 1 (1.19%) VBA
Qualifications
1 4 (4.76%) Degree
2 3 (3.57%) Postgraduate
3 2 (2.38%) ISTQB
3 2 (2.38%) ISTQB Advanced Certification
4 1 (1.19%) APMP
Quality Assurance & Compliance
1 3 (3.57%) Data Quality
1 3 (3.57%) FATCA
2 2 (2.38%) GDPR
2 2 (2.38%) QA
3 1 (1.19%) BS7666
3 1 (1.19%) Disclosure Scotland
3 1 (1.19%) PCI DSS
3 1 (1.19%) SLA
3 1 (1.19%) Solvency II
System Software
1 2 (2.38%) Docker
Systems Management
1 2 (2.38%) Ansible
Vendors
1 28 (33.33%) Oracle
2 18 (21.43%) Teradata
3 17 (20.24%) Informatica
4 13 (15.48%) Microsoft
5 6 (7.14%) Cloudera
6 5 (5.95%) SAP
6 5 (5.95%) Tableau
7 3 (3.57%) HP
8 2 (2.38%) Alteryx
8 2 (2.38%) Cognos
8 2 (2.38%) Netezza
9 1 (1.19%) Ab Initio
9 1 (1.19%) Google
9 1 (1.19%) IBM
9 1 (1.19%) Talend
9 1 (1.19%) Twitter