Period
to 23 February 2018

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 February 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
Scotland > Edinburgh
6 months to
23 Feb 2018
Same period 2017 Same period 2016
Rank 77 83 31
Rank change year-on-year +6 -52 +56
Permanent jobs citing Data Warehouse 75 48 167
As % of all permanent IT jobs advertised in Edinburgh 2.79% 2.18% 6.02%
As % of the Database & Business Intelligence category 9.33% 7.32% 22.69%
Number of salaries quoted 25 39 166
Edinburgh median annual salary £44,000 £55,000 £47,500
Median salary % change year-on-year -20.00% +15.79% +11.76%
10th Percentile £34,200 £37,500 £37,500
90th Percentile £67,250 £77,250 £65,000
Scotland median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.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 804 656 736
As % of all permanent IT jobs advertised in Edinburgh 29.91% 29.82% 26.53%
Number of salaries quoted 516 444 518
Edinburgh median annual salary £40,000 £42,500 £42,500
Median salary % change year-on-year -5.88% - +6.25%
10th Percentile £28,000 £28,750 £27,500
90th Percentile £65,000 £68,525 £63,700
Scotland median annual salary £42,500 £42,500 £41,500
% change year-on-year - +2.41% +3.75%

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 February 2018.

Salary histogram for Data Warehouse in Edinburgh

For the 6 months to 23 February 2018, IT 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 permanent job ads across the Edinburgh region with a requirement for Data Warehouse.

1 54 (72.00%) SQL
2 36 (48.00%) ETL
3 30 (40.00%) Python
3 30 (40.00%) Statistics
4 29 (38.67%) PostgreSQL
5 28 (37.33%) Machine Learning
5 28 (37.33%) Data Science
6 26 (34.67%) Business Intelligence
7 25 (33.33%) Relational Database
8 22 (29.33%) Amazon Redshift
9 21 (28.00%) Algorithms
10 18 (24.00%) SQL Server
11 15 (20.00%) T-SQL
11 15 (20.00%) SQL Server Integration Services
12 14 (18.67%) Finance
13 13 (17.33%) SQL Server Reporting Services
13 13 (17.33%) Degree
14 12 (16.00%) Microsoft
15 9 (12.00%) Agile Software Development
15 9 (12.00%) Tableau
15 9 (12.00%) Power BI
15 9 (12.00%) Analytics
15 9 (12.00%) Creative Thinking
16 8 (10.67%) Visualisation
16 8 (10.67%) Oracle
17 7 (9.33%) Middleware
17 7 (9.33%) Stakeholder Management
17 7 (9.33%) Apache Spark
18 6 (8.00%) Creative Problem-Solving
18 6 (8.00%) SciPy

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 7 (9.33%) Apache Spark
2 5 (6.67%) SAS
3 1 (1.33%) Apache
3 1 (1.33%) Tomcat
3 1 (1.33%) WebLogic
Applications
1 1 (1.33%) Mingle
1 1 (1.33%) MS Visio
Business Applications
1 2 (2.67%) Dynamics AX
2 1 (1.33%) Cognos Business Intelligence
2 1 (1.33%) Oracle EBS R12
Cloud Services
1 2 (2.67%) SaaS
2 1 (1.33%) Amazon AWS
2 1 (1.33%) Amazon EMR
2 1 (1.33%) Google Analytics
2 1 (1.33%) Microsoft Azure
Communications & Networking
1 2 (2.67%) Wi-Fi
2 1 (1.33%) Internet
Database & Business Intelligence
1 29 (38.67%) PostgreSQL
2 25 (33.33%) Relational Database
3 22 (29.33%) Amazon Redshift
4 18 (24.00%) SQL Server
5 15 (20.00%) SQL Server Integration Services
6 13 (17.33%) SQL Server Reporting Services
7 9 (12.00%) Power BI
8 6 (8.00%) MongoDB
8 6 (8.00%) Star Schema
9 4 (5.33%) BusinessObjects
9 4 (5.33%) SAS Data Integration Studio
9 4 (5.33%) SQL Server Analysis Services
10 3 (4.00%) QlikView
10 3 (4.00%) SAS EBI
10 3 (4.00%) SAS Visual Analytics
10 3 (4.00%) Snowflake Schema
10 3 (4.00%) SQL Server 2012
11 2 (2.67%) Microsoft Analysis Services
11 2 (2.67%) Oracle Exadata
11 2 (2.67%) PowerPivot
Development Applications
1 1 (1.33%) Oracle Forms
1 1 (1.33%) SQL Server Management Studio (SSMS)
1 1 (1.33%) Team Foundation Server
1 1 (1.33%) Toad
1 1 (1.33%) Visual Studio
General
1 14 (18.67%) Finance
2 5 (6.67%) Banking
3 1 (1.33%) Investment Banking
3 1 (1.33%) Manufacturing
3 1 (1.33%) Retail
3 1 (1.33%) Telecoms
Job Titles
1 27 (36.00%) Data Scientist
2 18 (24.00%) Developer
3 12 (16.00%) Business Intelligence Developer
4 11 (14.67%) SQL Developer
5 6 (8.00%) Consultant
5 6 (8.00%) Data Warehouse Developer
5 6 (8.00%) SSIS Developer
5 6 (8.00%) SSRS Developer
6 5 (6.67%) SQL BI Developer
7 4 (5.33%) Architect
7 4 (5.33%) Power BI Developer
7 4 (5.33%) SAS Consultant
8 3 (4.00%) Analyst
8 3 (4.00%) DBA
8 3 (4.00%) Designer
8 3 (4.00%) ETL Developer
8 3 (4.00%) Lead Developer
8 3 (4.00%) MicroStrategy Developer
9 2 (2.67%) Business Analyst
9 2 (2.67%) Data Architect
Libraries, Frameworks & Software Standards
1 7 (9.33%) Middleware
2 6 (8.00%) MLlib
2 6 (8.00%) NumPy
2 6 (8.00%) SciPy
3 3 (4.00%) MDX
4 1 (1.33%) .NET
4 1 (1.33%) AngularJS
4 1 (1.33%) Node.js
4 1 (1.33%) Pandas
4 1 (1.33%) PostGIS
4 1 (1.33%) scikit-learn
Miscellaneous
1 21 (28.00%) Algorithms
2 4 (5.33%) Mainframe
3 3 (4.00%) N-Tier
4 1 (1.33%) Fintech
4 1 (1.33%) Greenfield Project
4 1 (1.33%) Management Information System
Operating Systems
1 5 (6.67%) Unix
1 5 (6.67%) Windows
2 2 (2.67%) Linux
2 2 (2.67%) Windows Server
Processes & Methodologies
1 36 (48.00%) ETL
2 30 (40.00%) Statistics
3 28 (37.33%) Data Science
3 28 (37.33%) Machine Learning
4 26 (34.67%) Business Intelligence
5 9 (12.00%) Agile Software Development
5 9 (12.00%) Analytics
5 9 (12.00%) Creative Thinking
6 8 (10.67%) Visualisation
7 7 (9.33%) Stakeholder Management
8 6 (8.00%) Applied Mathematics
8 6 (8.00%) Creative Problem-Solving
8 6 (8.00%) Mathematics
8 6 (8.00%) Operations Research
8 6 (8.00%) Statistical Analysis
9 5 (6.67%) SDLC
10 4 (5.33%) Business Analysis
10 4 (5.33%) Data Integration
10 4 (5.33%) Data Modelling
11 3 (4.00%) Service Delivery
Programming Languages
1 54 (72.00%) SQL
2 30 (40.00%) Python
3 15 (20.00%) T-SQL
4 6 (8.00%) R
5 3 (4.00%) COBOL
5 3 (4.00%) JCL
6 2 (2.67%) C#
6 2 (2.67%) C++
6 2 (2.67%) Java
7 1 (1.33%) Bash Shell
7 1 (1.33%) Data Analysis Expressions (DAX)
7 1 (1.33%) PHP
7 1 (1.33%) PL/SQL
7 1 (1.33%) PowerShell
7 1 (1.33%) Ruby
Qualifications
1 13 (17.33%) Degree
2 1 (1.33%) Postgraduate
Quality Assurance & Compliance
1 2 (2.67%) SLA
2 1 (1.33%) BS7666
2 1 (1.33%) GDPR
2 1 (1.33%) QA
System Software
1 1 (1.33%) Docker
Systems Management
1 1 (1.33%) Ansible
1 1 (1.33%) Puppet
Vendors
1 12 (16.00%) Microsoft
2 9 (12.00%) Tableau
3 8 (10.67%) Oracle
4 3 (4.00%) MicroStrategy
4 3 (4.00%) Teradata
5 2 (2.67%) Ab Initio
5 2 (2.67%) TIBCO
6 1 (1.33%) Cloudera
6 1 (1.33%) Cognos
6 1 (1.33%) Google
6 1 (1.33%) IBM
6 1 (1.33%) Netezza