Period
to 23 June 2018

The following table provides summary statistics for contract job vacancies advertised in Edinburgh with a requirement for Data Lake skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Lake over the 6 months to 23 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 Lakes
Scotland > Edinburgh
6 months to
23 Jun 2018
Same period 2017 Same period 2016
Rank 109 105 135
Rank change year-on-year -4 +30 -
Contract jobs citing Data Lake 19 6 7
As % of all contract IT jobs advertised in Edinburgh 0.66% 0.29% 0.24%
As % of the Database & Business Intelligence category 3.91% 1.53% 1.15%
Number of daily rates quoted 13 6 4
Edinburgh median daily rate £475 £475 £400
Median daily rate % change year-on-year - +18.75% -
Scotland median daily rate £463 £475 £400
% change year-on-year -2.63% +18.75% -
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate - - -

Data Lake 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 392 607
As % of all contract IT jobs advertised in Edinburgh 16.79% 18.74% 21.14%
Number of daily rates quoted 286 218 357
Edinburgh median daily rate £400 £375 £400
Median daily rate % change year-on-year +6.67% -6.25% +6.67%
10th Percentile £310 £268 £270
90th Percentile £528 £529 £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 Lake
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Data Lake in Edinburgh

Data Lake
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for Data Lake in Edinburgh

Data Lake
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing Data Lake in Edinburgh over the 6 months to 23 June 2018.

Contractor daily rate histogram for Data Lake in Edinburgh

For the 6 months to 23 June 2018, IT contractor jobs citing Data Lake 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 Lake.

1 13 (68.42%) Finance
1 13 (68.42%) Teradata
2 12 (63.16%) SQL
3 11 (57.89%) Banking
3 11 (57.89%) Hadoop
4 10 (52.63%) Enterprise Data Warehouse
5 9 (47.37%) Microsoft Azure
5 9 (47.37%) Migration
5 9 (47.37%) Data Warehouse
5 9 (47.37%) Business Intelligence
6 7 (36.84%) Power BI
7 6 (31.58%) ETL
7 6 (31.58%) Data Analysis
7 6 (31.58%) Visualisation
7 6 (31.58%) Data Visualisation
8 5 (26.32%) Oracle Database
8 5 (26.32%) ETL Development
8 5 (26.32%) Data Migration
8 5 (26.32%) SAS
8 5 (26.32%) Oracle
8 5 (26.32%) Informatica
8 5 (26.32%) PowerCenter
8 5 (26.32%) Mainframe
9 4 (21.05%) PowerExchange
9 4 (21.05%) Unix
9 4 (21.05%) SAS Enterprise Guide
9 4 (21.05%) Analytics
10 3 (15.79%) Data Structures
10 3 (15.79%) Private Cloud
10 3 (15.79%) Agile Software Development

Data Lake
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 (26.32%) SAS
2 4 (21.05%) PowerExchange
Cloud Services
1 9 (47.37%) Microsoft Azure
2 3 (15.79%) Amazon AWS
2 3 (15.79%) Amazon EC2
3 1 (5.26%) Azure Data Factory
3 1 (5.26%) Data Lake Analytics
3 1 (5.26%) IaaS
3 1 (5.26%) PaaS
Communications & Networking
1 3 (15.79%) Firewall
2 1 (5.26%) Network Security
2 1 (5.26%) VPN
Database & Business Intelligence
1 11 (57.89%) Hadoop
2 10 (52.63%) Enterprise Data Warehouse
3 9 (47.37%) Data Warehouse
4 7 (36.84%) Power BI
5 5 (26.32%) Oracle Database
5 5 (26.32%) PowerCenter
6 4 (21.05%) SAS Enterprise Guide
7 1 (5.26%) Azure SQL Database
7 1 (5.26%) Big Data
7 1 (5.26%) Parquet
Development Applications
1 1 (5.26%) ERwin
General
1 13 (68.42%) Finance
2 11 (57.89%) Banking
3 3 (15.79%) Retail Banking
4 1 (5.26%) Legal
Job Titles
1 15 (78.95%) Developer
2 6 (31.58%) Business Intelligence Developer
2 6 (31.58%) Power BI Developer
3 5 (26.32%) Informatica Developer
4 4 (21.05%) Lead Developer
4 4 (21.05%) SAS Developer
5 2 (10.53%) Azure Engineer
5 2 (10.53%) Platform Engineer
6 1 (5.26%) Analyst
6 1 (5.26%) Azure Consultant
6 1 (5.26%) Build Engineer
6 1 (5.26%) Consultant
6 1 (5.26%) Data Analyst
6 1 (5.26%) Designer
6 1 (5.26%) Senior Analyst
6 1 (5.26%) Senior Data Analyst
6 1 (5.26%) Senior Data Warehouse Specialist
6 1 (5.26%) Senior Designer
6 1 (5.26%) Senior Solutions Analyst
6 1 (5.26%) Solutions Analyst
Miscellaneous
1 5 (26.32%) Mainframe
2 3 (15.79%) Data Structures
2 3 (15.79%) Greenfield Project
2 3 (15.79%) Private Cloud
3 2 (10.53%) Analytical Skills
Operating Systems
1 4 (21.05%) Unix
Processes & Methodologies
1 9 (47.37%) Business Intelligence
1 9 (47.37%) Migration
2 6 (31.58%) Data Analysis
2 6 (31.58%) Data Visualisation
2 6 (31.58%) ETL
2 6 (31.58%) Visualisation
3 5 (26.32%) Data Migration
3 5 (26.32%) ETL Development
4 4 (21.05%) Analytics
5 3 (15.79%) Agile Software Development
5 3 (15.79%) Data Modelling
5 3 (15.79%) Stakeholder Management
6 1 (5.26%) Data Analytics
6 1 (5.26%) Data Architecture
6 1 (5.26%) Network Virtualisation
Programming Languages
1 12 (63.16%) SQL
2 1 (5.26%) R
Quality Assurance & Compliance
1 1 (5.26%) Data Quality
System Software
1 2 (10.53%) Virtual Machines
Vendors
1 13 (68.42%) Teradata
2 5 (26.32%) Informatica
2 5 (26.32%) Oracle
3 3 (15.79%) Microsoft
4 1 (5.26%) CA
4 1 (5.26%) Twitter