Period
to 16 January 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 16 January 2019 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
Scotland > Edinburgh
6 months to
16 Jan 2019
Same period 2018 Same period 2017
Rank 133 151 -
Rank change year-on-year +18 - -
Permanent jobs citing Enterprise Data Warehouse 6 1 0
As % of all permanent IT jobs advertised in Edinburgh 0.25% 0.038% -
As % of the Database & Business Intelligence category 0.95% 0.12% -
Number of salaries quoted 6 0 0
Edinburgh median annual salary £35,000 - -
Scotland median annual salary £35,000 £35,000 -

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 632 841 621
As % of all permanent IT jobs advertised in Edinburgh 26.23% 32.28% 28.56%
Number of salaries quoted 445 531 442
Edinburgh median annual salary £45,000 £40,000 £45,000
Median salary % change year-on-year +12.50% -11.11% +5.88%
10th Percentile £28,750 £27,500 £28,750
90th Percentile £69,500 £60,000 £63,750
Scotland median annual salary £45,000 £42,500 £43,500
% change year-on-year +5.88% -2.30% +4.82%

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 16 January 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%) T-SQL
1 6 (100.00%) SQL Server
1 6 (100.00%) Visual Studio
1 6 (100.00%) Data Warehouse
1 6 (100.00%) ETL
1 6 (100.00%) Business Intelligence
1 6 (100.00%) Regression Testing
1 6 (100.00%) Agile Software Development
1 6 (100.00%) SQL Server Reporting Services
1 6 (100.00%) SQL Server Integration Services
1 6 (100.00%) Team Foundation Server
2 5 (83.33%) Test Management
2 5 (83.33%) Change Data Capture
2 5 (83.33%) SQL Server Management Studio (SSMS)
2 5 (83.33%) System Testing
2 5 (83.33%) Microsoft
3 4 (66.67%) Bug Management
4 2 (33.33%) Test Automation
5 1 (16.67%) Agile Testing
5 1 (16.67%) Non-Functional Testing
5 1 (16.67%) SQL Server 2012
5 1 (16.67%) Test Scripting
5 1 (16.67%) Collaborative Working
5 1 (16.67%) Finance
5 1 (16.67%) Games

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:

Database & Business Intelligence
1 6 (100.00%) Data Warehouse
1 6 (100.00%) SQL Server
1 6 (100.00%) SQL Server Integration Services
1 6 (100.00%) SQL Server Reporting Services
2 1 (16.67%) SQL Server 2012
Development Applications
1 6 (100.00%) Team Foundation Server
1 6 (100.00%) Visual Studio
2 5 (83.33%) SQL Server Management Studio (SSMS)
General
1 1 (16.67%) Finance
1 1 (16.67%) Games
Job Titles
1 6 (100.00%) Analyst
2 5 (83.33%) Business Intelligence Analyst
2 5 (83.33%) Test Analyst
3 4 (66.67%) Business Test Analyst
3 4 (66.67%) Senior Analyst
3 4 (66.67%) Senior Business Intelligence Analyst
3 4 (66.67%) Senior Test Analyst
Processes & Methodologies
1 6 (100.00%) Agile Software Development
1 6 (100.00%) Business Intelligence
1 6 (100.00%) ETL
1 6 (100.00%) Regression Testing
2 5 (83.33%) Change Data Capture
2 5 (83.33%) System Testing
2 5 (83.33%) Test Management
3 4 (66.67%) Bug Management
4 2 (33.33%) Test Automation
5 1 (16.67%) Agile Testing
5 1 (16.67%) Collaborative Working
5 1 (16.67%) Non-Functional Testing
5 1 (16.67%) Test Scripting
Programming Languages
1 6 (100.00%) SQL
1 6 (100.00%) T-SQL
Vendors
1 5 (83.33%) Microsoft