Period
to 22 June 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 22 June 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
22 Jun 2018
Same period 2017 Same period 2016
Rank 48 70 39
Rank change year-on-year +22 -31 -16
Contract jobs citing Data Warehouse 94 42 115
As % of all contract IT jobs advertised in Edinburgh 3.25% 2.02% 3.99%
As % of the Database & Business Intelligence category 19.34% 10.74% 18.76%
Number of daily rates quoted 64 29 103
Edinburgh median daily rate £400 £400 £400
10th Percentile £303 £319 £307
90th Percentile £550 £490 £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 486 391 613
As % of all contract IT jobs advertised in Edinburgh 16.79% 18.78% 21.28%
Number of daily rates quoted 286 219 360
Edinburgh median daily rate £400 £375 £397
Median daily rate % change year-on-year +6.67% -5.42% +5.73%
10th Percentile £310 £269 £270
90th Percentile £528 £528 £525
Scotland median daily rate £400 £375 £375
% change year-on-year +6.67% - -
Number of hourly rates quoted 1 9 3
Edinburgh median hourly rate £111.50 £47.23 £15.00
Median hourly rate % change year-on-year +136.08% +214.87% -68.42%
10th Percentile £111.25 £42.16 £10.50
90th Percentile £111.75 £52.17 £38.10
Scotland median hourly rate £16.25 £43.39 £33.10
% change year-on-year -62.55% +31.08% -22.11%

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 22 June 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 22 June 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 51 (54.26%) SQL
1 51 (54.26%) ETL
2 44 (46.81%) Finance
3 39 (41.49%) Agile Software Development
4 37 (39.36%) Oracle
5 31 (32.98%) Business Intelligence
6 28 (29.79%) Data Modelling
7 22 (23.40%) Migration
8 21 (22.34%) Data Analysis
8 21 (22.34%) Informatica
8 21 (22.34%) Relational Database
9 20 (21.28%) Data Architecture
10 19 (20.21%) Data Integration
10 19 (20.21%) Unix
11 17 (18.09%) Banking
12 16 (17.02%) Stakeholder Management
12 16 (17.02%) Data Migration
13 15 (15.96%) SDLC
14 13 (13.83%) Oracle Database
14 13 (13.83%) TOGAF
14 13 (13.83%) RDBMS
15 12 (12.77%) Defect Management
15 12 (12.77%) Waterfall
16 11 (11.70%) ETL Development
16 11 (11.70%) Information Security
17 10 (10.64%) Teradata
17 10 (10.64%) PL/SQL
17 10 (10.64%) SQL Server
18 9 (9.57%) Data Lake
18 9 (9.57%) Test Automation

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 7 (7.45%) SAS
2 4 (4.26%) PowerExchange
3 1 (1.06%) Confluence
3 1 (1.06%) Tomcat
3 1 (1.06%) WebLogic
3 1 (1.06%) WebSphere
Applications
1 1 (1.06%) Adobe Illustrator
1 1 (1.06%) Microsoft Excel
1 1 (1.06%) Photoshop
Business Applications
1 4 (4.26%) Oracle EBS R12
2 1 (1.06%) Dynamics CRM
Cloud Services
1 3 (3.19%) Microsoft Azure
2 2 (2.13%) Amazon AWS
2 2 (2.13%) Google Cloud Platform
3 1 (1.06%) Adobe Creative Cloud
3 1 (1.06%) Azure Data Factory
3 1 (1.06%) Data Lake Analytics
3 1 (1.06%) IaaS
3 1 (1.06%) PaaS
Communications & Networking
1 1 (1.06%) Firewall
1 1 (1.06%) Network Security
1 1 (1.06%) VPN
Database & Business Intelligence
1 21 (22.34%) Relational Database
2 13 (13.83%) Oracle Database
2 13 (13.83%) RDBMS
3 10 (10.64%) SQL Server
4 9 (9.57%) Data Lake
5 8 (8.51%) Big Data
5 8 (8.51%) Hadoop
5 8 (8.51%) PowerCenter
5 8 (8.51%) SQL Server Integration Services
6 7 (7.45%) SQL Server Reporting Services
7 6 (6.38%) Enterprise Data Warehouse
8 4 (4.26%) MySQL
8 4 (4.26%) Pentaho
8 4 (4.26%) SQL Server Analysis Services
9 3 (3.19%) Microsoft Analysis Services
9 3 (3.19%) Oracle Reports
10 2 (2.13%) BusinessObjects
10 2 (2.13%) BusinessObjects XI
10 2 (2.13%) SAS Enterprise Guide
10 2 (2.13%) SQL Server 2008
Development Applications
1 5 (5.32%) JIRA
2 1 (1.06%) Axure RP
2 1 (1.06%) ERwin
2 1 (1.06%) Git (software)
2 1 (1.06%) HP UFT
2 1 (1.06%) Oracle APEX
2 1 (1.06%) Oracle Forms
General
1 44 (46.81%) Finance
2 17 (18.09%) Banking
3 4 (4.26%) Retail Banking
4 2 (2.13%) Retail
4 2 (2.13%) Telecoms
5 1 (1.06%) Back Office
5 1 (1.06%) Electronics
5 1 (1.06%) Financial Institution
5 1 (1.06%) Front Office
5 1 (1.06%) Investment Banking
5 1 (1.06%) Law
5 1 (1.06%) Legal
5 1 (1.06%) Manufacturing
5 1 (1.06%) Marketing
Job Titles
1 27 (28.72%) Developer
2 25 (26.60%) Analyst
3 18 (19.15%) Architect
4 12 (12.77%) Data Architect
5 11 (11.70%) Business Analyst
6 9 (9.57%) Data Analyst
6 9 (9.57%) ETL Developer
6 9 (9.57%) Tester
7 8 (8.51%) ETL Tester
7 8 (8.51%) Informatica Developer
7 8 (8.51%) Project Manager
8 7 (7.45%) Test Analyst
9 6 (6.38%) SQL Analyst
9 6 (6.38%) Technical Architect
10 5 (5.32%) Data Warehouse Manager
10 5 (5.32%) Data Warehouse Project Manager
10 5 (5.32%) Lead Developer
11 4 (4.26%) Business Intelligence Analyst
11 4 (4.26%) Business Intelligence Business Analyst
11 4 (4.26%) SQL Developer
Libraries, Frameworks & Software Standards
1 3 (3.19%) ActiveMQ
2 2 (2.13%) XML
3 1 (1.06%) XML Messaging
Miscellaneous
1 8 (8.51%) Analytical Skills
2 5 (5.32%) Mainframe
3 4 (4.26%) Greenfield Project
4 2 (2.13%) Data Structures
5 1 (1.06%) Credit Risk
5 1 (1.06%) Fixed Income
5 1 (1.06%) NHS
5 1 (1.06%) Private Cloud
5 1 (1.06%) User Experience
Operating Systems
1 19 (20.21%) Unix
2 4 (4.26%) Linux
Processes & Methodologies
1 51 (54.26%) ETL
2 39 (41.49%) Agile Software Development
3 31 (32.98%) Business Intelligence
4 28 (29.79%) Data Modelling
5 22 (23.40%) Migration
6 21 (22.34%) Data Analysis
7 20 (21.28%) Data Architecture
8 19 (20.21%) Data Integration
9 16 (17.02%) Data Migration
9 16 (17.02%) Stakeholder Management
10 15 (15.96%) SDLC
11 13 (13.83%) TOGAF
12 12 (12.77%) Defect Management
12 12 (12.77%) Waterfall
13 11 (11.70%) ETL Development
13 11 (11.70%) Information Security
14 9 (9.57%) Test Automation
14 9 (9.57%) Test Management
15 8 (8.51%) Open Source
16 6 (6.38%) Performance Tuning
Programming Languages
1 51 (54.26%) SQL
2 10 (10.64%) PL/SQL
3 4 (4.26%) Java
4 2 (2.13%) C#
4 2 (2.13%) T-SQL
5 1 (1.06%) R
Qualifications
1 8 (8.51%) ISTQB
2 2 (2.13%) BPSS Clearance
2 2 (2.13%) Security Cleared
2 2 (2.13%) TOGAF Certification
3 1 (1.06%) Degree
Quality Assurance & Compliance
1 7 (7.45%) Data Quality
2 4 (4.26%) Disclosure Scotland
3 3 (3.19%) QA
4 1 (1.06%) GDPR
4 1 (1.06%) PMO
System Software
1 1 (1.06%) Virtual Machines
Systems Management
1 5 (5.32%) HP Quality Center
2 4 (4.26%) Oracle Flashback
2 4 (4.26%) Puppet
3 1 (1.06%) HP ALM
Vendors
1 37 (39.36%) Oracle
2 21 (22.34%) Informatica
3 10 (10.64%) Teradata
4 6 (6.38%) Microsoft
5 2 (2.13%) Cognos
5 2 (2.13%) Google
5 2 (2.13%) SAP
6 1 (1.06%) Ab Initio
6 1 (1.06%) Adobe
6 1 (1.06%) CA
6 1 (1.06%) HP
6 1 (1.06%) IBM
6 1 (1.06%) MapR
6 1 (1.06%) Netezza
6 1 (1.06%) Salesforce.com
6 1 (1.06%) Sitecore
6 1 (1.06%) Tableau
6 1 (1.06%) Twitter