Period
to 17 August 2019

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for Enterprise Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Enterprise Data Warehouse over the 6 months to 17 August 2019 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
Scotland > Edinburgh
6 months to
17 Aug 2019
Same period 2018 Same period 2017
Rank 150 146 -
Rank change year-on-year -4 - +146
Permanent jobs citing Enterprise Data Warehouse 6 3 0
As % of all permanent IT jobs advertised in Edinburgh 0.23% 0.12% -
As % of the Database & Business Intelligence category 0.85% 0.44% -
Number of salaries quoted 10 0 0
Edinburgh median annual salary £52,500 - -
Scotland median annual salary £52,500 £41,500 £38,750
% change year-on-year +26.51% +7.10% -18.42%

Enterprise 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 permanent job vacancies advertised in Edinburgh with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Edinburgh
Permanent vacancies with a requirement for database or business intelligence skills 708 686 875
As % of all permanent IT jobs advertised in Edinburgh 27.63% 26.84% 34.72%
Number of salaries quoted 451 484 553
Edinburgh median annual salary £42,500 £45,000 £40,000
Median salary % change year-on-year -5.56% +12.50% -11.11%
10th Percentile £27,750 £28,000 £27,500
90th Percentile £62,500 £68,750 £67,500
Scotland median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -5.56%

Enterprise Data Warehouse
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Enterprise Data Warehouse in Edinburgh

Enterprise Data Warehouse
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Enterprise Data Warehouse in Edinburgh.

Salary trend for Enterprise Data Warehouse in Edinburgh

For the 6 months to 17 August 2019, IT jobs citing Enterprise 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 permanent job ads across the Edinburgh region with a requirement for Enterprise Data Warehouse.

1 6 (100.00%) SQL
1 6 (100.00%) ETL
1 6 (100.00%) Finance
2 5 (83.33%) Data Warehouse
2 5 (83.33%) Agile Software Development
2 5 (83.33%) Data Architecture
3 4 (66.67%) Microsoft Azure
3 4 (66.67%) Azure SQL Database
3 4 (66.67%) Analytical Skills
3 4 (66.67%) SDLC
3 4 (66.67%) ETL Development
3 4 (66.67%) Power BI
3 4 (66.67%) Fintech
3 4 (66.67%) Self-Motivation
3 4 (66.67%) Problem-Solving
3 4 (66.67%) Power Platform
3 4 (66.67%) Internet
3 4 (66.67%) OLTP
3 4 (66.67%) Snowflake Schema
3 4 (66.67%) Microsoft
3 4 (66.67%) T-SQL
3 4 (66.67%) SQL Server
4 2 (33.33%) Banking
5 1 (16.67%) Data Analysis
5 1 (16.67%) Retail Banking
5 1 (16.67%) Data Integration
5 1 (16.67%) Hudson
5 1 (16.67%) Big Data
5 1 (16.67%) Unix
5 1 (16.67%) Oracle

Enterprise 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:

Cloud Services
1 4 (66.67%) Microsoft Azure
1 4 (66.67%) Power Platform
Communications & Networking
1 4 (66.67%) Internet
Database & Business Intelligence
1 5 (83.33%) Data Warehouse
2 4 (66.67%) Azure SQL Database
2 4 (66.67%) OLTP
2 4 (66.67%) Power BI
2 4 (66.67%) Snowflake Schema
2 4 (66.67%) SQL Server
3 1 (16.67%) Big Data
3 1 (16.67%) PowerCenter
Development Applications
1 1 (16.67%) Hudson
General
1 6 (100.00%) Finance
2 2 (33.33%) Banking
3 1 (16.67%) Retail Banking
Job Titles
1 5 (83.33%) Developer
2 4 (66.67%) SQL Developer
3 1 (16.67%) Consultant
3 1 (16.67%) ETL Consultant
3 1 (16.67%) ETL Developer
3 1 (16.67%) Test Manager
Miscellaneous
1 4 (66.67%) Analytical Skills
1 4 (66.67%) Self-Motivation
Operating Systems
1 1 (16.67%) Unix
Processes & Methodologies
1 6 (100.00%) ETL
2 5 (83.33%) Agile Software Development
2 5 (83.33%) Data Architecture
3 4 (66.67%) ETL Development
3 4 (66.67%) Fintech
3 4 (66.67%) Problem-Solving
3 4 (66.67%) SDLC
4 1 (16.67%) Data Analysis
4 1 (16.67%) Data Integration
4 1 (16.67%) Test Automation
Programming Languages
1 6 (100.00%) SQL
2 4 (66.67%) T-SQL
Vendors
1 4 (66.67%) Microsoft
2 1 (16.67%) Informatica
2 1 (16.67%) Oracle
2 1 (16.67%) Teradata