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

3 months to
26 Mar 2017
Same period 2016 Same period 2015
Data Warehousing
Scotland / Edinburgh
Rank 77 28 71
Rank change year-on-year -49 +43  
Permanent jobs citing Data Warehouse 15 88 31
As % of all permanent IT jobs advertised in Edinburgh 1.35% 6.58% 2.32%
As % of the Database & Business Intelligence category 3.75% 24.31% 8.73%
Number of salaries quoted 12 57 23
Median salary £55,000 £47,500 £50,000
Median salary % change year-on-year +15.78% -5.00%  
90% offered a salary of more than £37,750 £38,100 £39,200
10% offered a salary of more than £70,900 £55,000 £67,500
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

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 400 362 355
As % of all permanent IT job vacancies advertised in Edinburgh 35.87% 27.06% 26.61%
Number of salaries quoted 251 243 246
Median salary £45,000 £47,500 £40,000
Median salary % change year-on-year -5.26% +18.75%  
90% offered a salary of more than £35,000 £32,500 £32,000
10% offered a salary of more than £77,500 £52,500 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

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 March 2017.

Salary histogram for Data Warehouse in Edinburgh

Data Warehouse
Top 30 Related IT Skills in Edinburgh

For the 6 months to 26 March 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 24 (60.00%) Finance
2 22 (55.00%) Business Intelligence
3 16 (40.00%) Relational Database
4 15 (37.50%) SQL
5 14 (35.00%) Data Management
6 13 (32.50%) Data Modelling
7 12 (30.00%) Agile Software Development
7 12 (30.00%) Analytics
8 11 (27.50%) Analytical Skills
9 10 (25.00%) Hadoop
10 9 (22.50%) SQL Server
11 8 (20.00%) RDBMS
11 8 (20.00%) NoSQL
11 8 (20.00%) Data Integration
11 8 (20.00%) Selenium
12 7 (17.50%) ETL
12 7 (17.50%) DB2
12 7 (17.50%) Oracle
12 7 (17.50%) Machine Learning
12 7 (17.50%) Big Data
13 6 (15.00%) Metadata Management
13 6 (15.00%) Performance Tuning
13 6 (15.00%) Teradata
13 6 (15.00%) .NET
13 6 (15.00%) Predictive Analytics
13 6 (15.00%) Integration Testing
13 6 (15.00%) SQL Server Integration Services
13 6 (15.00%) Data Architecture
13 6 (15.00%) Data Mapping
13 6 (15.00%) Waterfall

Data Warehouse
Top Related 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 5 (12.50%) SAS
2 3 (7.50%) Apache Spark
3 2 (5.00%) Confluence
4 1 (2.50%) Apache Pig
Applications
1 4 (10.00%) MS Excel
2 2 (5.00%) MS Office
2 2 (5.00%) MS PowerPoint
3 1 (2.50%) Spreadsheet
Business Applications
1 2 (5.00%) Markit EDM
1 2 (5.00%) thinkFolio
Cloud Services
1 1 (2.50%) Amazon AWS
1 1 (2.50%) Amazon EMR
1 1 (2.50%) Cloud Computing
1 1 (2.50%) Google Analytics
1 1 (2.50%) SaaS
Database & Business Intelligence
1 16 (40.00%) Relational Database
2 10 (25.00%) Hadoop
3 9 (22.50%) SQL Server
4 8 (20.00%) NoSQL
4 8 (20.00%) RDBMS
5 7 (17.50%) Big Data
5 7 (17.50%) DB2
6 6 (15.00%) SQL Server Integration Services
7 5 (12.50%) Data Mart
7 5 (12.50%) SQL Server Reporting Services
8 3 (7.50%) Amazon Redshift
8 3 (7.50%) SAS Data Integration Studio
8 3 (7.50%) SAS Enterprise Guide
9 2 (5.00%) Oracle Exadata
9 2 (5.00%) Oracle Reports
9 2 (5.00%) QlikView
9 2 (5.00%) SQL Server 2012
9 2 (5.00%) SQL Server Analysis Services
10 1 (2.50%) Base SAS
10 1 (2.50%) Data Mining
Development Applications
1 8 (20.00%) Selenium
2 5 (12.50%) ERwin
3 2 (5.00%) JBehave
3 2 (5.00%) Jenkins
3 2 (5.00%) JIRA
3 2 (5.00%) Maven
3 2 (5.00%) Team Foundation Server
4 1 (2.50%) Visual Studio
General
1 24 (60.00%) Finance
2 4 (10.00%) Banking
3 2 (5.00%) Back Office
3 2 (5.00%) Retail
3 2 (5.00%) Retail Banking
Job Titles
1 9 (22.50%) Architect
1 9 (22.50%) Data Architect
2 7 (17.50%) Analyst
3 6 (15.00%) Senior Architect
3 6 (15.00%) Senior Data Architect
4 5 (12.50%) Data Modeller
4 5 (12.50%) Developer
5 4 (10.00%) Applications Engineer
5 4 (10.00%) Business Intelligence Developer
5 4 (10.00%) Test Engineer
6 3 (7.50%) Consultant
6 3 (7.50%) Team Leader
6 3 (7.50%) Test Analyst
7 2 (5.00%) Python Developer
7 2 (5.00%) Scrum Master
7 2 (5.00%) Senior Applications Engineer
7 2 (5.00%) Senior Test Engineer
7 2 (5.00%) Systems Analyst
7 2 (5.00%) Technical Analyst
7 2 (5.00%) Test Automation Engineer
Libraries, Frameworks & Software Standards
1 6 (15.00%) .NET
2 3 (7.50%) Kafka
3 2 (5.00%) XMPP
4 1 (2.50%) Web Services
Miscellaneous
1 11 (27.50%) Analytical Skills
2 2 (5.00%) Mainframe
2 2 (5.00%) Virtual Team
3 1 (2.50%) Computer Science
3 1 (2.50%) Enterprise Software
3 1 (2.50%) Management Information System
Operating Systems
1 3 (7.50%) Unix
2 1 (2.50%) Linux
2 1 (2.50%) Windows
Processes & Methodologies
1 22 (55.00%) Business Intelligence
2 14 (35.00%) Data Management
3 13 (32.50%) Data Modelling
4 12 (30.00%) Agile Software Development
4 12 (30.00%) Analytics
5 8 (20.00%) Data Integration
6 7 (17.50%) ETL
6 7 (17.50%) Machine Learning
7 6 (15.00%) Data Architecture
7 6 (15.00%) Data Mapping
7 6 (15.00%) Integration Testing
7 6 (15.00%) Metadata Management
7 6 (15.00%) Open Source
7 6 (15.00%) Performance Tuning
7 6 (15.00%) Predictive Analytics
7 6 (15.00%) Waterfall
8 5 (12.50%) Infrastructure Management
8 5 (12.50%) Scrum
8 5 (12.50%) Software Testing
8 5 (12.50%) Test Automation
Programming Languages
1 15 (37.50%) SQL
2 5 (12.50%) C#
3 4 (10.00%) T-SQL
4 3 (7.50%) Python
4 3 (7.50%) Ruby
5 2 (5.00%) VB.NET
5 2 (5.00%) VBA
6 1 (2.50%) Bash Shell
6 1 (2.50%) Perl
Qualifications
1 5 (12.50%) ISEB
2 1 (2.50%) ISTQB
Quality Assurance & Compliance
1 1 (2.50%) Data Quality
Systems Management
1 4 (10.00%) HP Quality Center
Vendors
1 7 (17.50%) Oracle
2 6 (15.00%) Teradata
3 5 (12.50%) Informatica
3 5 (12.50%) Microsoft
3 5 (12.50%) Pega
3 5 (12.50%) Tableau
4 4 (10.00%) HP
5 3 (7.50%) Cognos
6 2 (5.00%) CA Agile Central
6 2 (5.00%) MicroStrategy
6 2 (5.00%) Netezza
7 1 (2.50%) Google
Edinburgh, Midlothian
HAYS INFORMATION TECHNOLOGY
Salary: £35000.00 - £46000.00 per annum
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: £40000.00 - £50000.00 per annum + benefits
Posted: 4 days ago
Edinburgh, Midlothian
Churchill Frank
Salary: £35000 - £50000 per annum + Bonus, Pension, SAS Training & More
Posted: 6 days ago