The table below looks at the statistics for Data Warehouse skills in IT jobs advertised for the Scotland region. Included is a guide to the salaries offered in IT jobs that have cited Data Warehouse over the 3 months to 29 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 Aug 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 82 60 98
Rank change year-on-year
-22 +38
Permanent jobs citing Data Warehouse 75 113 84
As % of all permanent IT jobs located in Scotland 2.70% 3.50% 2.26%
As % of the Database & Business Intelligence category 8.45% 10.75% 7.11%
Number of salaries quoted 48 85 64
Median salary £52,500 £47,500 £44,000
Median salary % change year-on-year
+10.52% +7.95%
90% offered a salary of more than £39,250 £32,500 £32,500
10% offered a salary of more than £75,000 £65,000 £60,000
UK excluding London median salary £46,000 £45,000 £45,000
% change year-on-year
+2.22% -
Data Warehouse
UK

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the Scotland region.

Database & Business Intelligence Category
Scotland
Permanent IT job ads with a match in the
Database & Business Intelligence category
888 1051 1181
As % of all permanent IT jobs located in Scotland 31.93% 32.58% 31.76%
Number of salaries quoted 507 676 769
Median salary £45,000 £45,000 £40,000
Median salary % change year-on-year
- +12.50%
90% offered a salary of more than £30,300 £30,000 £30,000
10% offered a salary of more than £60,000 £57,500 £67,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

Data Warehouse
Jobs Demand Trend in Scotland

The demand trend of job ads across the Scotland region citing Data Warehouse as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

Data Warehouse Jobs Demand Trend in Scotland

Data Warehouse
Salary Trend in Scotland

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

Data Warehouse Salary Trend in Scotland

Data Warehouse
Salary Histogram in Scotland

This chart provides a salary histogram for IT jobs citing Data Warehouse across the Scotland region over the 3 months to 29 August 2016.

Data Warehouse Salary Histogram in Scotland

Data Warehouse
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Scotland region over the 3 months to 29 August 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -5 37 £55,000 +7.31% 3
Glasgow -14 33 £49,250 +5.34% 2
Stirling +13 2 - - 1
Aberdeen +2 2 £47,500 +58.33%
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 29 August 2016, 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 Scotland region with a requirement for Data Warehouse.

1 100 (56.82%) SQL
2 95 (53.98%) Finance
3 93 (52.84%) Oracle
4 89 (50.57%) Business Intelligence
5 88 (50.00%) Agile Software Development
6 63 (35.80%) ETL
7 57 (32.39%) SQL Server
8 56 (31.82%) Analytical Skills
9 49 (27.84%) SQL Server Integration Services
10 47 (26.70%) Scrum
11 45 (25.57%) Data Modelling
12 43 (24.43%) Informatica
13 41 (23.30%) Microsoft
14 37 (21.02%) Data Analysis
15 36 (20.45%) Analytics
16 35 (19.89%) Banking
17 34 (19.32%) Asset Management
18 33 (18.75%) Big Data
19 31 (17.61%) Hadoop
20 30 (17.05%) Degree
21 29 (16.48%) Data Management
22 28 (15.91%) PL/SQL
23 27 (15.34%) Stakeholder Management
23 27 (15.34%) Business Analysis
24 26 (14.77%) Apache Hive
25 25 (14.20%) Retail
25 25 (14.20%) HBase
25 25 (14.20%) Mentoring
26 23 (13.07%) Perl
26 23 (13.07%) Oracle Reports

Data Warehouse
Top Related IT Skills in Scotland 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 17 (9.66%) SAS
2 6 (3.41%) SharePoint
3 4 (2.27%) Apache
3 4 (2.27%) Apache Pig
3 4 (2.27%) Apache Spark
3 4 (2.27%) Tomcat
4 2 (1.14%) JBoss
5 1 (0.57%) SharePoint 2010
Applications
1 17 (9.66%) MS Excel
2 4 (2.27%) MS Office
3 3 (1.70%) MS PowerPoint
Business Applications
1 22 (12.50%) Markit EDM
2 1 (0.57%) Oracle Applications
2 1 (0.57%) Oracle EBS
Cloud Services
1 11 (6.25%) SaaS
2 3 (1.70%) Google Analytics
2 3 (1.70%) Microsoft Azure
3 2 (1.14%) IaaS
4 1 (0.57%) Google Cloud Platform
Database & Business Intelligence
1 57 (32.39%) SQL Server
2 49 (27.84%) SQL Server Integration Services
3 33 (18.75%) Big Data
4 31 (17.61%) Hadoop
5 26 (14.77%) Apache Hive
6 25 (14.20%) HBase
7 23 (13.07%) Oracle Reports
8 22 (12.50%) SQL Server Reporting Services
9 21 (11.93%) Data Mining
9 21 (11.93%) Oracle BI EE
9 21 (11.93%) SQL Server Analysis Services
10 20 (11.36%) OLAP
10 20 (11.36%) Relational Database
11 16 (9.09%) Oracle Database
11 16 (9.09%) PowerCenter
12 13 (7.39%) BusinessObjects
13 12 (6.82%) Oracle OLAP
14 11 (6.25%) DataStage
14 11 (6.25%) QlikView
15 10 (5.68%) BusinessObjects XI
Development Applications
1 8 (4.55%) Oracle Forms
2 5 (2.84%) ERwin
3 4 (2.27%) Team Foundation Server
4 3 (1.70%) ProC
4 3 (1.70%) Visual Studio
5 2 (1.14%) Git (software)
5 2 (1.14%) Jenkins
5 2 (1.14%) Maven
5 2 (1.14%) Subversion
6 1 (0.57%) Talend Open Studio
6 1 (0.57%) Toad
General
1 95 (53.98%) Finance
2 35 (19.89%) Banking
3 25 (14.20%) Retail
4 14 (7.95%) Telecoms
5 13 (7.39%) Marketing
6 12 (6.82%) Games
7 6 (3.41%) Retail Banking
8 3 (1.70%) Legal
9 2 (1.14%) Dutch Language
9 2 (1.14%) French Language
9 2 (1.14%) German Language
10 1 (0.57%) Advertising
10 1 (0.57%) Corporate Banking
Job Titles
1 60 (34.09%) Developer
2 29 (16.48%) Analyst
3 24 (13.64%) Consultant
4 19 (10.80%) Business Intelligence Developer
5 17 (9.66%) Architect
6 15 (8.52%) Data Architect
7 14 (7.95%) SQL Developer
8 12 (6.82%) Senior Consultant
9 11 (6.25%) Business Analyst
9 11 (6.25%) Senior Developer
10 10 (5.68%) Oracle Developer
10 10 (5.68%) Report Developer
10 10 (5.68%) Senior Oracle Developer
11 9 (5.11%) Data Engineer
11 9 (5.11%) Data Modeller
11 9 (5.11%) Technical Analyst
12 8 (4.55%) Data Consultant
12 8 (4.55%) Data Warehouse Developer
12 8 (4.55%) Senior Analyst
13 7 (3.98%) Big Data Developer
Libraries, Frameworks & Software Standards
1 12 (6.82%) REST
2 11 (6.25%) .NET
3 6 (3.41%) MDX
3 6 (3.41%) XML
4 5 (2.84%) Web Services
5 3 (1.70%) COM
6 2 (1.14%) Ext JS
6 2 (1.14%) Hibernate
6 2 (1.14%) HTML
6 2 (1.14%) J2EE
6 2 (1.14%) JSP
6 2 (1.14%) Middleware
6 2 (1.14%) RESTful
6 2 (1.14%) Spring
7 1 (0.57%) Entity Framework
7 1 (0.57%) FpML
7 1 (0.57%) XML Schema
Miscellaneous
1 56 (31.82%) Analytical Skills
2 21 (11.93%) Data Integration
3 19 (10.80%) Management Information System
4 5 (2.84%) CESG
5 4 (2.27%) Computer Science
5 4 (2.27%) Visualisation
6 3 (1.70%) Derivative
6 3 (1.70%) Enterprise Software
7 2 (1.14%) Data Centre
7 2 (1.14%) IVR
7 2 (1.14%) User Experience
7 2 (1.14%) Virtual Team
8 1 (0.57%) Fixed Income
8 1 (0.57%) Mainframe
8 1 (0.57%) Reference Data
Operating Systems
1 17 (9.66%) Unix
2 15 (8.52%) Linux
3 2 (1.14%) Red Hat Enterprise Linux
Processes & Methodologies
1 89 (50.57%) Business Intelligence
2 88 (50.00%) Agile Software Development
3 63 (35.80%) ETL
4 47 (26.70%) Scrum
5 45 (25.57%) Data Modelling
6 37 (21.02%) Data Analysis
7 36 (20.45%) Analytics
8 34 (19.32%) Asset Management
9 29 (16.48%) Data Management
10 27 (15.34%) Business Analysis
10 27 (15.34%) Stakeholder Management
11 25 (14.20%) Mentoring
12 21 (11.93%) Information Management
12 21 (11.93%) Master Data Management
13 19 (10.80%) Data Governance
14 17 (9.66%) Software Engineering
15 15 (8.52%) Logical Data Model
16 14 (7.95%) Data Architecture
16 14 (7.95%) Waterfall
17 13 (7.39%) Kanban
Programming Languages
1 100 (56.82%) SQL
2 28 (15.91%) PL/SQL
3 23 (13.07%) Perl
4 21 (11.93%) T-SQL
5 20 (11.36%) Java
6 12 (6.82%) Shell Script
7 11 (6.25%) Python
7 11 (6.25%) VBA
8 8 (4.55%) R
9 7 (3.98%) C#
10 5 (2.84%) VB.NET
11 2 (1.14%) C
11 2 (1.14%) JavaScript
12 1 (0.57%) PowerShell
Qualifications
1 30 (17.05%) Degree
2 3 (1.70%) ISEB
3 2 (1.14%) ISTQB
3 2 (1.14%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 16 (9.09%) Data Quality
2 6 (3.41%) QA
3 1 (0.57%) ISO 9001
System Software
1 4 (2.27%) Apache Flume
Systems Management
1 3 (1.70%) MOM
2 1 (0.57%) HP Quality Center
Vendors
1 93 (52.84%) Oracle
2 43 (24.43%) Informatica
3 41 (23.30%) Microsoft
4 21 (11.93%) Cognos
5 17 (9.66%) MicroStrategy
6 16 (9.09%) IBM
7 15 (8.52%) SAP
7 15 (8.52%) Tableau
8 9 (5.11%) Cloudera
9 8 (4.55%) Teradata
10 6 (3.41%) HP
10 6 (3.41%) Sun
11 5 (2.84%) Netezza
11 5 (2.84%) Pega
11 5 (2.84%) Vertica
12 3 (1.70%) Google
13 2 (1.14%) Red Hat
13 2 (1.14%) Sybase
13 2 (1.14%) Twitter
14 1 (0.57%) Talend
Edinburgh, Midlothian
Complete Tech Limited
Salary: Up to £55,000 per annum + bonus + life assurance + pension + more
Posted: 2 days ago
Glasgow, Lanarkshire
Cathcart Associates Ltd
Salary: Benefits
Posted: 3 days ago
Glasgow, Lanarkshire
Harvey Nash plc
Posted: 4 days ago
Stirling, Stirlingshire
PRUDENTIAL
Posted: 14 days ago