Period
to 23 November 2017

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

Data Warehousing
Scotland > Edinburgh
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 78 72 51
Rank change year-on-year -6 -21 +32
Permanent jobs citing Data Warehouse 80 65 123
As % of all permanent IT jobs advertised in Edinburgh 2.96% 2.79% 4.03%
As % of the Database & Business Intelligence category 8.77% 10.12% 14.64%
Number of salaries quoted 37 56 112
Edinburgh median annual salary £44,000 £55,000 £47,500
Median salary % change year-on-year -20.00% +15.79% +8.57%
10th Percentile £32,000 £36,875 £35,250
90th Percentile £72,500 £75,000 £68,750
Scotland median annual salary £45,000 £50,000 £47,500
% change year-on-year -10.00% +5.26% +5.56%

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 912 642 840
As % of all permanent IT jobs advertised in Edinburgh 33.77% 27.53% 27.54%
Number of salaries quoted 580 462 567
Edinburgh median annual salary £40,000 £45,000 £40,000
Median salary % change year-on-year -11.11% +12.50% -
10th Percentile £27,000 £28,075 £26,750
90th Percentile £62,500 £62,500 £62,500
Scotland median annual salary £41,750 £42,500 £40,000
% change year-on-year -1.76% +6.25% -

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
Salary Trend in Edinburgh

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

Salary trend for Data Warehouse in Edinburgh

Data Warehouse
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Data Warehouse in Edinburgh over the 6 months to 23 November 2017.

Salary histogram for Data Warehouse in Edinburgh

For the 6 months to 23 November 2017, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Edinburgh region with a requirement for Data Warehouse.

1 53 (66.25%) SQL
2 41 (51.25%) ETL
3 40 (50.00%) Business Intelligence
4 25 (31.25%) SQL Server
5 24 (30.00%) Python
6 22 (27.50%) PostgreSQL
6 22 (27.50%) Machine Learning
7 21 (26.25%) Relational Database
7 21 (26.25%) Statistics
8 19 (23.75%) Amazon Redshift
8 19 (23.75%) SQL Server Integration Services
9 17 (21.25%) Agile Software Development
9 17 (21.25%) T-SQL
10 16 (20.00%) SQL Server Reporting Services
11 15 (18.75%) Algorithms
12 14 (17.50%) Tableau
13 13 (16.25%) Data Management
13 13 (16.25%) Microsoft
13 13 (16.25%) Finance
14 12 (15.00%) Degree
14 12 (15.00%) Master Data Management
15 11 (13.75%) Data Quality
15 11 (13.75%) Informatica
15 11 (13.75%) PowerCenter
15 11 (13.75%) Oracle
16 10 (12.50%) BusinessObjects
16 10 (12.50%) SAS
16 10 (12.50%) Information Management
16 10 (12.50%) Analytics
16 10 (12.50%) Apache Spark

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 10 (12.50%) Apache Spark
1 10 (12.50%) SAS
2 2 (2.50%) Apache
Applications
1 1 (1.25%) Microsoft Excel
Business Applications
1 1 (1.25%) Cognos Business Intelligence
Cloud Services
1 3 (3.75%) Microsoft Azure
2 2 (2.50%) Amazon AWS
2 2 (2.50%) Amazon EMR
2 2 (2.50%) Google Analytics
Communications & Networking
1 4 (5.00%) Internet
Database & Business Intelligence
1 25 (31.25%) SQL Server
2 22 (27.50%) PostgreSQL
3 21 (26.25%) Relational Database
4 19 (23.75%) Amazon Redshift
4 19 (23.75%) SQL Server Integration Services
5 16 (20.00%) SQL Server Reporting Services
6 11 (13.75%) PowerCenter
7 10 (12.50%) BusinessObjects
8 7 (8.75%) Hadoop
8 7 (8.75%) Power BI
9 6 (7.50%) Big Data
10 5 (6.25%) MongoDB
10 5 (6.25%) RDBMS
10 5 (6.25%) SQL Server 2012
10 5 (6.25%) SQL Server Analysis Services
11 4 (5.00%) SQL Server 2014
11 4 (5.00%) SQL Server 2016
11 4 (5.00%) Star Schema
12 3 (3.75%) SAS Data Integration Studio
12 3 (3.75%) Snowflake Schema
General
1 13 (16.25%) Finance
2 2 (2.50%) Banking
3 1 (1.25%) Financial Institution
3 1 (1.25%) Investment Banking
3 1 (1.25%) Local Government
3 1 (1.25%) Manufacturing
3 1 (1.25%) Retail
3 1 (1.25%) Telecoms
Job Titles
1 40 (50.00%) Developer
2 20 (25.00%) Data Scientist
3 18 (22.50%) SQL Developer
4 16 (20.00%) Business Intelligence Developer
5 13 (16.25%) Consultant
6 9 (11.25%) Data Warehouse Developer
6 9 (11.25%) ETL Developer
7 8 (10.00%) SQL Server Developer
8 7 (8.75%) SQL BI Developer
8 7 (8.75%) SSIS Developer
9 6 (7.50%) Data Consultant
9 6 (7.50%) ETL Consultant
9 6 (7.50%) SSRS Developer
10 5 (6.25%) Data Warehouse Consultant
10 5 (6.25%) Informatica Developer
11 4 (5.00%) Power BI Developer
12 3 (3.75%) Architect
12 3 (3.75%) Designer
12 3 (3.75%) Lead Developer
12 3 (3.75%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 6 (7.50%) Middleware
2 5 (6.25%) MLlib
2 5 (6.25%) NumPy
2 5 (6.25%) SciPy
3 3 (3.75%) .NET
4 2 (2.50%) Natural Language Processing
4 2 (2.50%) Pandas
4 2 (2.50%) scikit-learn
5 1 (1.25%) CSS
5 1 (1.25%) MDX
Miscellaneous
1 15 (18.75%) Algorithms
2 3 (3.75%) N-Tier
3 2 (2.50%) Fintech
3 2 (2.50%) Mainframe
4 1 (1.25%) Analytical Skills
4 1 (1.25%) Credit Risk
4 1 (1.25%) Driving Licence
4 1 (1.25%) Greenfield Project
4 1 (1.25%) Hedge funds
Operating Systems
1 4 (5.00%) Unix
2 3 (3.75%) Linux
3 1 (1.25%) Windows
Processes & Methodologies
1 41 (51.25%) ETL
2 40 (50.00%) Business Intelligence
3 22 (27.50%) Machine Learning
4 21 (26.25%) Statistics
5 17 (21.25%) Agile Software Development
6 13 (16.25%) Data Management
7 12 (15.00%) Master Data Management
8 10 (12.50%) Analytics
8 10 (12.50%) Information Management
9 8 (10.00%) Customer Engagement
9 8 (10.00%) Visualisation
10 7 (8.75%) Stakeholder Management
11 6 (7.50%) Data Modelling
12 5 (6.25%) Applied Mathematics
12 5 (6.25%) Data Integration
12 5 (6.25%) Mathematics
12 5 (6.25%) Operations Research
12 5 (6.25%) Statistical Analysis
13 4 (5.00%) Creative Thinking
13 4 (5.00%) Migration
Programming Languages
1 53 (66.25%) SQL
2 24 (30.00%) Python
3 17 (21.25%) T-SQL
4 6 (7.50%) C#
5 5 (6.25%) Scala
6 3 (3.75%) COBOL
6 3 (3.75%) Java
6 3 (3.75%) JCL
6 3 (3.75%) R
7 1 (1.25%) C++
7 1 (1.25%) Data Analysis Expressions (DAX)
7 1 (1.25%) PL/SQL
7 1 (1.25%) PowerShell
7 1 (1.25%) SAS Macro
Qualifications
1 12 (15.00%) Degree
Quality Assurance & Compliance
1 11 (13.75%) Data Quality
2 2 (2.50%) QA
3 1 (1.25%) Basel III
3 1 (1.25%) GDPR
Vendors
1 14 (17.50%) Tableau
2 13 (16.25%) Microsoft
3 11 (13.75%) Informatica
3 11 (13.75%) Oracle
4 9 (11.25%) MicroStrategy
5 7 (8.75%) Teradata
6 6 (7.50%) Netezza
7 3 (3.75%) Cognos
8 2 (2.50%) Ab Initio
8 2 (2.50%) Google
8 2 (2.50%) IBM
9 1 (1.25%) TIBCO