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 3 months to 26 June 2017 with a comparison to the same period in the previous 2 years.

Data Warehousing
Scotland / Edinburgh
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 58 50 69
Rank change year-on-year -8 +19  
Permanent jobs citing Data Warehouse 42 45 38
As % of all permanent IT jobs advertised in Edinburgh 3.38% 3.79% 2.70%
As % of the Database & Business Intelligence category 10.42% 13.85% 9.29%
Number of salaries quoted 21 17 33
Median salary £50,000 £54,500 £50,000
Median salary % change year-on-year -8.25% +9.00%  
90% offered a salary of more than £45,000 £39,853 £32,100
10% offered a salary of more than £70,000 £55,000 £60,000
UK excluding London median salary £45,000 £45,000 £45,000

Data Warehouse is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Edinburgh with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
Edinburgh
Permanent job vacancies with a requirement for database and business intelligence skills 403 325 409
As % of all permanent IT job vacancies advertised in Edinburgh 32.42% 27.40% 29.05%
Number of salaries quoted 265 166 255
Median salary £40,500 £45,000 £44,000
Median salary % change year-on-year -10.00% +2.27%  
90% offered a salary of more than £32,500 £30,000 £29,000
10% offered a salary of more than £65,000 £62,500 £67,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

Data Warehouse
Job Vacancy Trend in Edinburgh

The job posting trend of jobs advertised in Edinburgh citing Data Warehouse as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 26 June 2017.

Salary histogram for Data Warehouse in Edinburgh

For the 6 months to 26 June 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 37 (64.91%) Business Intelligence
2 27 (47.37%) ETL
3 23 (40.35%) SQL Server
4 21 (36.84%) Agile Software Development
5 20 (35.09%) SQL
6 16 (28.07%) Relational Database
7 15 (26.32%) Oracle
7 15 (26.32%) Data Management
8 13 (22.81%) Information Management
8 13 (22.81%) SQL Server Integration Services
8 13 (22.81%) RDBMS
9 11 (19.30%) T-SQL
9 11 (19.30%) SAS
9 11 (19.30%) Master Data Management
9 11 (19.30%) Apache Spark
9 11 (19.30%) Data Quality
10 10 (17.54%) Mentoring
10 10 (17.54%) Cognos
10 10 (17.54%) Informatica
10 10 (17.54%) PowerCenter
11 9 (15.79%) Finance
11 9 (15.79%) Data Integration
11 9 (15.79%) Tableau
11 9 (15.79%) Machine Learning
11 9 (15.79%) Hadoop
12 8 (14.04%) Analytics
12 8 (14.04%) Customer Engagement
12 8 (14.04%) Netezza
12 8 (14.04%) Python
12 8 (14.04%) DB2

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 11 (19.30%) Apache Spark
1 11 (19.30%) SAS
2 1 (1.75%) Confluence
Applications
1 1 (1.75%) Microsoft Excel
1 1 (1.75%) Microsoft Office
1 1 (1.75%) Microsoft PowerPoint
Business Applications
1 1 (1.75%) Cognos Business Intelligence
1 1 (1.75%) Markit EDM
1 1 (1.75%) thinkFolio
Cloud Services
1 3 (5.26%) Microsoft Azure
2 1 (1.75%) Cloud Computing
2 1 (1.75%) Google Analytics
2 1 (1.75%) SaaS
Database & Business Intelligence
1 23 (40.35%) SQL Server
2 16 (28.07%) Relational Database
3 13 (22.81%) RDBMS
3 13 (22.81%) SQL Server Integration Services
4 10 (17.54%) PowerCenter
5 9 (15.79%) Hadoop
6 8 (14.04%) DB2
7 7 (12.28%) NoSQL
7 7 (12.28%) SQL Server Reporting Services
8 6 (10.53%) Big Data
8 6 (10.53%) BusinessObjects
8 6 (10.53%) PostgreSQL
9 5 (8.77%) DataStage
9 5 (8.77%) MongoDB
9 5 (8.77%) SQL Server 2012
10 4 (7.02%) Cognos Analysis Studio
10 4 (7.02%) Cognos Query Studio
10 4 (7.02%) Cognos Report Studio
10 4 (7.02%) IBM InfoSphere
10 4 (7.02%) SAS Data Integration Studio
Development Applications
1 2 (3.51%) Git (software)
1 2 (3.51%) Team Foundation Server
2 1 (1.75%) Atlassian Bamboo
2 1 (1.75%) Bitbucket
2 1 (1.75%) ERwin
2 1 (1.75%) Jenkins
2 1 (1.75%) JIRA
2 1 (1.75%) Subversion
2 1 (1.75%) Visual Studio
General
1 9 (15.79%) Finance
2 2 (3.51%) Local Government
2 2 (3.51%) Retail
3 1 (1.75%) Back Office
3 1 (1.75%) Banking
3 1 (1.75%) Retail Banking
Job Titles
1 23 (40.35%) Developer
2 17 (29.82%) Consultant
3 9 (15.79%) SQL Developer
4 8 (14.04%) Data Consultant
5 7 (12.28%) SQL Server Developer
6 6 (10.53%) Business Intelligence Developer
6 6 (10.53%) Database Developer
6 6 (10.53%) ETL Consultant
6 6 (10.53%) ETL Developer
7 5 (8.77%) Data Scientist
7 5 (8.77%) Data Warehouse Consultant
7 5 (8.77%) SQL Database Developer
8 4 (7.02%) Architect
8 4 (7.02%) Informatica Developer
9 3 (5.26%) Analyst
9 3 (5.26%) Data Architect
9 3 (5.26%) DBA
9 3 (5.26%) SAS Consultant
9 3 (5.26%) Senior Consultant
9 3 (5.26%) Team Leader
Libraries, Frameworks & Software Standards
1 5 (8.77%) MLlib
1 5 (8.77%) NumPy
1 5 (8.77%) SciPy
2 3 (5.26%) Kafka
3 2 (3.51%) CSS
4 1 (1.75%) .NET
4 1 (1.75%) Ajax
4 1 (1.75%) JSON
4 1 (1.75%) RESTful
4 1 (1.75%) RSS
4 1 (1.75%) XML
Miscellaneous
1 5 (8.77%) Driving Licence
2 3 (5.26%) Analytical Skills
2 3 (5.26%) Mainframe
3 2 (3.51%) Data Structures
4 1 (1.75%) Algorithms
4 1 (1.75%) Computer Science
4 1 (1.75%) Enterprise Software
Operating Systems
1 6 (10.53%) Linux
2 4 (7.02%) Unix
Processes & Methodologies
1 37 (64.91%) Business Intelligence
2 27 (47.37%) ETL
3 21 (36.84%) Agile Software Development
4 15 (26.32%) Data Management
5 13 (22.81%) Information Management
6 11 (19.30%) Master Data Management
7 10 (17.54%) Mentoring
8 9 (15.79%) Data Integration
8 9 (15.79%) Machine Learning
9 8 (14.04%) Analytics
9 8 (14.04%) Customer Engagement
10 7 (12.28%) Visualisation
11 6 (10.53%) Stakeholder Management
12 5 (8.77%) Applied Mathematics
12 5 (8.77%) Data Modelling
12 5 (8.77%) Mathematics
12 5 (8.77%) Operations Research
12 5 (8.77%) Prototyping
12 5 (8.77%) Statistical Analysis
12 5 (8.77%) Statistics
Programming Languages
1 20 (35.09%) SQL
2 11 (19.30%) T-SQL
3 8 (14.04%) Python
4 3 (5.26%) Ruby
5 2 (3.51%) Scala
6 1 (1.75%) Bash Shell
6 1 (1.75%) C
6 1 (1.75%) C#
6 1 (1.75%) Java
6 1 (1.75%) JavaScript
6 1 (1.75%) Perl
6 1 (1.75%) PHP
6 1 (1.75%) SAS Macro
6 1 (1.75%) Shell Script
6 1 (1.75%) VB.NET
Qualifications
1 5 (8.77%) Degree
2 1 (1.75%) ISEB
2 1 (1.75%) ISTQB
2 1 (1.75%) Oracle Certification
Quality Assurance & Compliance
1 11 (19.30%) Data Quality
2 5 (8.77%) QA
System Software
1 1 (1.75%) Apache Flume
1 1 (1.75%) HDFS
1 1 (1.75%) KVM
1 1 (1.75%) Virtual Machines
Vendors
1 15 (26.32%) Oracle
2 10 (17.54%) Cognos
2 10 (17.54%) Informatica
3 9 (15.79%) Tableau
4 8 (14.04%) Netezza
5 7 (12.28%) Microsoft
5 7 (12.28%) MicroStrategy
6 6 (10.53%) Teradata
7 4 (7.02%) IBM
8 1 (1.75%) Google
Edinburgh, Midlothian
Eximius Group Limited
Posted: 4 days ago
Edinburgh, Midlothian
Capita Resourcing - IT Resourcing
Salary: £35000 - £45000.00 per annum
Posted: 5 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £45,000 - £60,000k plus brilliant package and unrivalled development
Posted: 6 days ago
Edinburgh
Churchill Frank
Salary: £35000 - £50000 per annum
Posted: 17 days ago
Edinburgh
TDA Group
Salary: £45000 - £55000 per annum + + Bonus
Posted: 27 days ago