Period
to 25 September 2018

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 25 September 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
Scotland > Edinburgh
6 months to
25 Sep 2018
Same period 2017 Same period 2016
Rank 91 56 62
Rank change year-on-year -35 +6 -30
Contract jobs citing Data Warehouse 52 79 77
As % of all contract IT jobs advertised in Edinburgh 1.75% 2.96% 3.26%
As % of the Database & Business Intelligence category 10.28% 15.08% 15.31%
Number of daily rates quoted 30 42 65
Edinburgh median daily rate £438 £408 £400
Median daily rate % change year-on-year +7.36% +1.88% +6.67%
10th Percentile £349 £313 £307
90th Percentile £588 £488 £525
Scotland median daily rate £400 £400 £400
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate £10.20 - -

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 506 524 503
As % of all contract IT jobs advertised in Edinburgh 17.05% 19.63% 21.28%
Number of daily rates quoted 275 280 277
Edinburgh median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% -
10th Percentile £313 £293 £259
90th Percentile £544 £538 £513
Scotland median daily rate £400 £388 £350
% change year-on-year +3.23% +10.71% -
Number of hourly rates quoted 1 3 3
Edinburgh median hourly rate £15.50 £43.39 £47.25
Median hourly rate % change year-on-year -64.28% -8.17% +45.72%
Scotland median hourly rate £16.25 £43.39 £36.00
% change year-on-year -62.55% +20.53% +11.03%

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 25 September 2018.

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 25 September 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 Edinburgh region with a requirement for Data Warehouse.

1 25 (48.08%) ETL
2 23 (44.23%) Oracle
3 22 (42.31%) SQL
4 17 (32.69%) Finance
5 15 (28.85%) SQL Server
5 15 (28.85%) ETL Development
6 13 (25.00%) Ab Initio
6 13 (25.00%) Migration
7 12 (23.08%) Teradata
8 11 (21.15%) Data Migration
9 10 (19.23%) Data Analysis
9 10 (19.23%) Business Intelligence
10 9 (17.31%) Agile Software Development
10 9 (17.31%) Banking
11 8 (15.38%) Stakeholder Management
12 7 (13.46%) Data Integration
12 7 (13.46%) Performance Tuning
13 6 (11.54%) Oracle Database
13 6 (11.54%) Stakeholder Engagement
13 6 (11.54%) Data Quality
13 6 (11.54%) QA
13 6 (11.54%) Data Modelling
14 5 (9.62%) SAS
14 5 (9.62%) Retail
14 5 (9.62%) Business Analysis
15 4 (7.69%) Big Data
15 4 (7.69%) Pentaho
15 4 (7.69%) Amazon AWS
15 4 (7.69%) PL/SQL
15 4 (7.69%) Oracle Flashback

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 5 (9.62%) SAS
Applications
1 2 (3.85%) Microsoft Excel
2 1 (1.92%) Adobe Illustrator
2 1 (1.92%) Photoshop
Business Applications
1 1 (1.92%) Dynamics AX
Cloud Services
1 4 (7.69%) Amazon AWS
2 2 (3.85%) Microsoft Azure
3 1 (1.92%) Adobe Creative Cloud
3 1 (1.92%) Amazon EMR
3 1 (1.92%) Amazon S3
3 1 (1.92%) Amazon SageMaker
3 1 (1.92%) Azure Data Factory
3 1 (1.92%) Data Lake Analytics
3 1 (1.92%) Google Cloud Platform
3 1 (1.92%) IaaS
3 1 (1.92%) PaaS
Communications & Networking
1 1 (1.92%) Firewall
1 1 (1.92%) Network Security
1 1 (1.92%) VPN
Database & Business Intelligence
1 15 (28.85%) SQL Server
2 6 (11.54%) Oracle Database
3 4 (7.69%) Big Data
3 4 (7.69%) Pentaho
4 3 (5.77%) Data Lake
4 3 (5.77%) MySQL
5 2 (3.85%) BusinessObjects
5 2 (3.85%) Enterprise Data Warehouse
5 2 (3.85%) Hadoop
5 2 (3.85%) OLAP
5 2 (3.85%) Power BI
5 2 (3.85%) SQL Server Reporting Services
6 1 (1.92%) Azure SQL Database
6 1 (1.92%) BusinessObjects XI
6 1 (1.92%) Oracle Database 10g
6 1 (1.92%) Oracle Database 11g
6 1 (1.92%) PowerCenter
6 1 (1.92%) RDBMS
6 1 (1.92%) SAS Enterprise Guide
6 1 (1.92%) SQL Server Integration Services
Development Applications
1 3 (5.77%) JIRA
2 1 (1.92%) Axure RP
2 1 (1.92%) HP UFT
2 1 (1.92%) Hudson
General
1 17 (32.69%) Finance
2 9 (17.31%) Banking
3 5 (9.62%) Retail
4 2 (3.85%) Financial Institution
5 1 (1.92%) Back Office
5 1 (1.92%) Front Office
5 1 (1.92%) Law
5 1 (1.92%) Legal
5 1 (1.92%) Manufacturing
Job Titles
1 25 (48.08%) Developer
2 12 (23.08%) Analyst
3 11 (21.15%) Ab Initio Developer
4 7 (13.46%) Data Analyst
5 4 (7.69%) ETL Developer
5 4 (7.69%) Project Manager
6 3 (5.77%) Business Analyst
6 3 (5.77%) Data Migration Analyst
6 3 (5.77%) Data Warehouse Manager
6 3 (5.77%) Data Warehouse Project Manager
6 3 (5.77%) Migration Analyst
6 3 (5.77%) SQL Analyst
6 3 (5.77%) Test Analyst
7 2 (3.85%) Business Intelligence Developer
7 2 (3.85%) Data Architect
7 2 (3.85%) Data Warehouse Analyst
7 2 (3.85%) Designer
7 2 (3.85%) Excel Developer
7 2 (3.85%) SQL Data Analyst
7 2 (3.85%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 3 (5.77%) ActiveMQ
1 3 (5.77%) JSON
1 3 (5.77%) SOAP
1 3 (5.77%) XML
2 1 (1.92%) Web Services
Miscellaneous
1 3 (5.77%) Data Structures
2 2 (3.85%) Greenfield Project
2 2 (3.85%) Private Cloud
3 1 (1.92%) Analytical Skills
3 1 (1.92%) Credit Risk
3 1 (1.92%) Data Centre
3 1 (1.92%) NHS
3 1 (1.92%) Reference Data
3 1 (1.92%) Self-Motivation
3 1 (1.92%) User Experience
Operating Systems
1 3 (5.77%) Unix
2 1 (1.92%) Linux
Processes & Methodologies
1 25 (48.08%) ETL
2 15 (28.85%) ETL Development
3 13 (25.00%) Migration
4 11 (21.15%) Data Migration
5 10 (19.23%) Business Intelligence
5 10 (19.23%) Data Analysis
6 9 (17.31%) Agile Software Development
7 8 (15.38%) Stakeholder Management
8 7 (13.46%) Data Integration
8 7 (13.46%) Performance Tuning
9 6 (11.54%) Data Modelling
9 6 (11.54%) Stakeholder Engagement
10 5 (9.62%) Business Analysis
11 3 (5.77%) Data Architecture
11 3 (5.77%) DevOps
11 3 (5.77%) Investment Management
11 3 (5.77%) Logical Data Model
11 3 (5.77%) Quality Management
11 3 (5.77%) Scorecard
11 3 (5.77%) User Acceptance Testing
Programming Languages
1 22 (42.31%) SQL
2 4 (7.69%) PL/SQL
3 3 (5.77%) Java
4 2 (3.85%) Shell Script
5 1 (1.92%) R
5 1 (1.92%) X++
Qualifications
1 1 (1.92%) Degree
Quality Assurance & Compliance
1 6 (11.54%) Data Quality
1 6 (11.54%) QA
2 1 (1.92%) Disclosure Scotland
2 1 (1.92%) GDPR
2 1 (1.92%) PMO
System Software
1 1 (1.92%) Virtual Machines
Systems Management
1 4 (7.69%) Oracle Flashback
2 3 (5.77%) HP Quality Center
Vendors
1 23 (44.23%) Oracle
2 13 (25.00%) Ab Initio
3 12 (23.08%) Teradata
4 2 (3.85%) Cognos
4 2 (3.85%) Informatica
4 2 (3.85%) Tableau
5 1 (1.92%) Adobe
5 1 (1.92%) Google
5 1 (1.92%) MapR
5 1 (1.92%) Microsoft