Period
to 16 December 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 16 December 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
16 Dec 2018
Same period 2017 Same period 2016
Rank 63 54 48
Rank change year-on-year -9 -6 -1
Contract jobs citing Data Warehouse 77 91 70
As % of all contract IT jobs advertised in Edinburgh 2.73% 3.10% 3.55%
As % of the Database & Business Intelligence category 14.53% 16.98% 16.47%
Number of daily rates quoted 51 45 41
Edinburgh median daily rate £475 £425 £400
Median daily rate % change year-on-year +11.76% +6.25% -4.19%
10th Percentile £338 £322 £310
90th Percentile £588 £500 £525
Scotland median daily rate £406 £413 £400
% change year-on-year -1.52% +3.13% +6.67%
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate £11.00 - -

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 530 536 425
As % of all contract IT jobs advertised in Edinburgh 18.77% 18.24% 21.56%
Number of daily rates quoted 294 290 217
Edinburgh median daily rate £415 £400 £363
Median daily rate % change year-on-year +3.75% +10.34% -9.38%
10th Percentile £313 £311 £268
90th Percentile £544 £510 £513
Scotland median daily rate £400 £388 £350
% change year-on-year +3.23% +10.71% -6.67%
Number of hourly rates quoted 3 0 9
Edinburgh median hourly rate £30.00 - £52.00
10th Percentile £18.40 - £44.25
90th Percentile £34.00 - £52.03
Scotland median hourly rate £31.25 £33.00 £42.25
% change year-on-year -5.30% -21.89% +69.00%

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 16 December 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 16 December 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 54 (70.13%) ETL
2 42 (54.55%) SQL
3 34 (44.16%) Oracle
4 30 (38.96%) SQL Server
4 30 (38.96%) Ab Initio
5 26 (33.77%) Business Intelligence
6 24 (31.17%) Teradata
7 20 (25.97%) Unix
7 20 (25.97%) Data Integration
8 19 (24.68%) Shell Script
9 18 (23.38%) Retail
9 18 (23.38%) ETL Development
10 17 (22.08%) Finance
11 16 (20.78%) Migration
12 14 (18.18%) QA
12 14 (18.18%) User Acceptance Testing
12 14 (18.18%) Data Migration
13 13 (16.88%) Banking
14 10 (12.99%) OLAP
14 10 (12.99%) Metadata Management
15 9 (11.69%) Data Modelling
15 9 (11.69%) Agile Software Development
15 9 (11.69%) Data Analysis
15 9 (11.69%) Big Data
16 8 (10.39%) Investment Management
16 8 (10.39%) Informatica
16 8 (10.39%) Oracle Database
17 6 (7.79%) Tableau
17 6 (7.79%) Business Analysis
18 5 (6.49%) SQL Server Reporting Services

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:

Applications
1 2 (2.60%) Microsoft Excel
2 1 (1.30%) Adobe Illustrator
2 1 (1.30%) Photoshop
Business Applications
1 1 (1.30%) Dynamics AX
1 1 (1.30%) Markit EDM
Cloud Services
1 4 (5.19%) Amazon AWS
2 2 (2.60%) Amazon S3
3 1 (1.30%) Adobe Creative Cloud
3 1 (1.30%) Amazon EMR
3 1 (1.30%) Amazon SageMaker
Database & Business Intelligence
1 30 (38.96%) SQL Server
2 10 (12.99%) OLAP
3 9 (11.69%) Big Data
4 8 (10.39%) Oracle Database
5 5 (6.49%) SQL Server Reporting Services
6 4 (5.19%) BusinessObjects
6 4 (5.19%) Power BI
6 4 (5.19%) RDBMS
6 4 (5.19%) Relational Database
6 4 (5.19%) SAP Data Services
6 4 (5.19%) SQL Server Integration Services
7 3 (3.90%) MySQL
7 3 (3.90%) Oracle Exadata
8 2 (2.60%) Data Mining
8 2 (2.60%) DataStage
8 2 (2.60%) Hadoop
8 2 (2.60%) Oracle OLAP
8 2 (2.60%) SQL Server Analysis Services
9 1 (1.30%) Data Mart
9 1 (1.30%) Oracle Database 10g
Development Applications
1 3 (3.90%) Hudson
2 2 (2.60%) Visual Studio
3 1 (1.30%) Axure RP
3 1 (1.30%) ER Studio
3 1 (1.30%) ERwin
3 1 (1.30%) HP UFT
General
1 18 (23.38%) Retail
2 17 (22.08%) Finance
3 13 (16.88%) Banking
4 2 (2.60%) Corporate Banking
4 2 (2.60%) Financial Institution
4 2 (2.60%) Retail Banking
5 1 (1.30%) Manufacturing
Job Titles
1 43 (55.84%) Developer
2 28 (36.36%) Ab Initio Developer
3 14 (18.18%) Analyst
4 8 (10.39%) Data Analyst
5 6 (7.79%) Consultant
5 6 (7.79%) SQL Developer
6 5 (6.49%) Architect
6 5 (6.49%) Data Architect
7 4 (5.19%) SQL Analyst
8 3 (3.90%) Business Analyst
8 3 (3.90%) Business Intelligence Consultant
8 3 (3.90%) Data Migration Analyst
8 3 (3.90%) Migration Analyst
8 3 (3.90%) SQL Data Analyst
9 2 (2.60%) ETL Consultant
9 2 (2.60%) Excel Developer
9 2 (2.60%) Oracle Analyst
9 2 (2.60%) Project Manager
9 2 (2.60%) SQL Server Developer
9 2 (2.60%) Technical Analyst
Libraries, Frameworks & Software Standards
1 3 (3.90%) JSON
1 3 (3.90%) SOAP
1 3 (3.90%) XML
2 2 (2.60%) .NET
3 1 (1.30%) Web Services
Miscellaneous
1 3 (3.90%) Data Structures
2 1 (1.30%) Analytical Skills
2 1 (1.30%) Data Centre
2 1 (1.30%) NHS
2 1 (1.30%) Private Cloud
2 1 (1.30%) Reference Data
2 1 (1.30%) Self-Motivation
2 1 (1.30%) User Experience
Operating Systems
1 20 (25.97%) Unix
2 1 (1.30%) Linux
Processes & Methodologies
1 54 (70.13%) ETL
2 26 (33.77%) Business Intelligence
3 20 (25.97%) Data Integration
4 18 (23.38%) ETL Development
5 16 (20.78%) Migration
6 14 (18.18%) Data Migration
6 14 (18.18%) User Acceptance Testing
7 10 (12.99%) Metadata Management
8 9 (11.69%) Agile Software Development
8 9 (11.69%) Data Analysis
8 9 (11.69%) Data Modelling
9 8 (10.39%) Investment Management
10 6 (7.79%) Business Analysis
11 5 (6.49%) Asset Management
11 5 (6.49%) Dimensional Modelling
11 5 (6.49%) Kimball Methodology
11 5 (6.49%) Performance Tuning
11 5 (6.49%) Stakeholder Engagement
11 5 (6.49%) Stakeholder Management
12 4 (5.19%) Analytics
Programming Languages
1 42 (54.55%) SQL
2 19 (24.68%) Shell Script
3 5 (6.49%) PL/SQL
4 2 (2.60%) C#
4 2 (2.60%) Python
5 1 (1.30%) C
5 1 (1.30%) R
5 1 (1.30%) X++
Quality Assurance & Compliance
1 14 (18.18%) QA
2 4 (5.19%) Data Quality
3 1 (1.30%) Disclosure Scotland
3 1 (1.30%) PMO
Systems Management
1 1 (1.30%) HP Quality Center
Vendors
1 34 (44.16%) Oracle
2 30 (38.96%) Ab Initio
3 24 (31.17%) Teradata
4 8 (10.39%) Informatica
5 6 (7.79%) Tableau
6 4 (5.19%) SAP
7 2 (2.60%) Microsoft
8 1 (1.30%) Adobe
8 1 (1.30%) IBM