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 30 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
30 Sep 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 73 59 112
Rank change year-on-year
-14 +53
Permanent jobs citing Data Warehouse 73 121 70
As % of all permanent IT jobs located in Scotland 2.90% 3.65% 1.92%
As % of the Database & Business Intelligence category 8.99% 11.91% 5.97%
Number of salaries quoted 51 89 53
Median salary £51,250 £50,000 £45,000
Median salary % change year-on-year
+2.50% +11.11%
90% offered a salary of more than £40,000 £32,500 £32,500
10% offered a salary of more than £75,000 £65,600 £67,000
UK excluding London median salary £47,500 £45,000 £45,000
% change year-on-year
+5.55% -
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
812 1016 1172
As % of all permanent IT jobs located in Scotland 32.21% 30.68% 32.08%
Number of salaries quoted 506 665 756
Median salary £42,500 £44,000 £40,000
Median salary % change year-on-year
-3.40% +10.00%
90% offered a salary of more than £30,000 £32,000 £30,000
10% offered a salary of more than £61,050 £55,000 £65,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 30 September 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 30 September 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 -11 38 £55,000 +3.77% 6
Glasgow -1 29 £50,000 +6.95% 8
Stirling +8 2 - -
Aberdeen - 2 £47,500 -
Inverclyde - 1 - -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 30 September 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 97 (57.40%) SQL
2 90 (53.25%) Finance
3 89 (52.66%) Oracle
4 82 (48.52%) Business Intelligence
5 80 (47.34%) Agile Software Development
6 70 (41.42%) ETL
7 60 (35.50%) Analytical Skills
8 56 (33.14%) SQL Server
9 55 (32.54%) Data Modelling
10 46 (27.22%) Informatica
11 45 (26.63%) SQL Server Integration Services
12 44 (26.04%) Scrum
12 44 (26.04%) Analytics
13 43 (25.44%) Microsoft
14 34 (20.12%) Data Management
15 33 (19.53%) Big Data
16 31 (18.34%) Hadoop
17 30 (17.75%) Banking
18 29 (17.16%) Data Integration
19 28 (16.57%) Data Analysis
19 28 (16.57%) PL/SQL
20 26 (15.38%) T-SQL
20 26 (15.38%) Apache Hive
20 26 (15.38%) Relational Database
21 25 (14.79%) HBase
21 25 (14.79%) Degree
22 24 (14.20%) SQL Server Reporting Services
22 24 (14.20%) Master Data Management
23 23 (13.61%) Mentoring
23 23 (13.61%) Retail

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 14 (8.28%) SAS
2 7 (4.14%) SharePoint
3 5 (2.96%) Apache Spark
4 4 (2.37%) Apache
4 4 (2.37%) Apache Pig
4 4 (2.37%) Tomcat
5 2 (1.18%) JBoss
6 1 (0.59%) Confluence
6 1 (0.59%) SharePoint 2010
Applications
1 20 (11.83%) MS Excel
2 4 (2.37%) MS Office
3 2 (1.18%) S-PLUS
4 1 (0.59%) MS PowerPoint
4 1 (0.59%) SPSS
Business Applications
1 16 (9.47%) Markit EDM
2 1 (0.59%) Cognos Business Intelligence
Cloud Services
1 11 (6.51%) SaaS
2 5 (2.96%) Google Analytics
3 3 (1.78%) Microsoft Azure
4 2 (1.18%) Amazon AWS
4 2 (1.18%) GitHub
4 2 (1.18%) Google Cloud Platform
4 2 (1.18%) IaaS
5 1 (0.59%) Amazon EMR
Communications & Networking
1 1 (0.59%) SMS
Database & Business Intelligence
1 56 (33.14%) SQL Server
2 45 (26.63%) SQL Server Integration Services
3 33 (19.53%) Big Data
4 31 (18.34%) Hadoop
5 26 (15.38%) Apache Hive
5 26 (15.38%) Relational Database
6 25 (14.79%) HBase
7 24 (14.20%) SQL Server Reporting Services
8 23 (13.61%) SQL Server Analysis Services
9 20 (11.83%) Data Mining
9 20 (11.83%) OLAP
9 20 (11.83%) Oracle Reports
10 15 (8.88%) Oracle BI EE
10 15 (8.88%) PowerCenter
11 14 (8.28%) Oracle Database
12 12 (7.10%) Oracle OLAP
13 11 (6.51%) BusinessObjects
13 11 (6.51%) QlikView
13 11 (6.51%) RDBMS
14 10 (5.92%) DB2
Development Applications
1 9 (5.33%) ERwin
2 8 (4.73%) Oracle Forms
3 7 (4.14%) Visual Studio
4 5 (2.96%) Team Foundation Server
5 4 (2.37%) Git (software)
6 3 (1.78%) ProC
6 3 (1.78%) Talend Open Studio
7 2 (1.18%) Jenkins
7 2 (1.18%) Maven
7 2 (1.18%) Subversion
8 1 (0.59%) JIRA
8 1 (0.59%) PVCS
General
1 90 (53.25%) Finance
2 30 (17.75%) Banking
3 23 (13.61%) Retail
4 12 (7.10%) Games
4 12 (7.10%) Telecoms
5 11 (6.51%) Marketing
6 5 (2.96%) Retail Banking
7 1 (0.59%) Advertising
7 1 (0.59%) Corporate Banking
7 1 (0.59%) Legal
Job Titles
1 53 (31.36%) Developer
2 23 (13.61%) Analyst
3 22 (13.02%) Consultant
4 17 (10.06%) Architect
4 17 (10.06%) Business Intelligence Developer
5 15 (8.88%) Data Architect
6 13 (7.69%) Data Modeller
7 12 (7.10%) Senior Consultant
8 11 (6.51%) SQL Developer
9 10 (5.92%) Data Engineer
10 9 (5.33%) Data Consultant
10 9 (5.33%) ETL Developer
11 8 (4.73%) Data Warehouse Developer
12 7 (4.14%) Big Data Developer
12 7 (4.14%) Data Analyst
12 7 (4.14%) Oracle Developer
12 7 (4.14%) Senior Developer
12 7 (4.14%) Senior Oracle Developer
13 6 (3.55%) Developer Analyst
13 6 (3.55%) Report Developer
Libraries, Frameworks & Software Standards
1 12 (7.10%) REST
2 6 (3.55%) .NET
2 6 (3.55%) MDX
2 6 (3.55%) Web Services
2 6 (3.55%) XML
3 3 (1.78%) COM
4 2 (1.18%) Ext JS
4 2 (1.18%) Hibernate
4 2 (1.18%) HTML
4 2 (1.18%) J2EE
4 2 (1.18%) JSP
4 2 (1.18%) Middleware
4 2 (1.18%) RESTful
4 2 (1.18%) Spring
5 1 (0.59%) Entity Framework
5 1 (0.59%) FpML
5 1 (0.59%) XML Schema
Miscellaneous
1 60 (35.50%) Analytical Skills
2 29 (17.16%) Data Integration
3 17 (10.06%) Management Information System
4 9 (5.33%) Visualisation
5 5 (2.96%) CESG
5 5 (2.96%) Enterprise Software
6 3 (1.78%) Computer Science
6 3 (1.78%) Data Structures
6 3 (1.78%) Derivative
7 2 (1.18%) Data Centre
7 2 (1.18%) Data Extraction
7 2 (1.18%) IVR
7 2 (1.18%) Ontologies
7 2 (1.18%) Statistics
7 2 (1.18%) Virtual Team
8 1 (0.59%) Fixed Income
8 1 (0.59%) Mainframe
8 1 (0.59%) Reference Data
Operating Systems
1 18 (10.65%) Unix
2 16 (9.47%) Linux
3 2 (1.18%) Red Hat Enterprise Linux
Processes & Methodologies
1 82 (48.52%) Business Intelligence
2 80 (47.34%) Agile Software Development
3 70 (41.42%) ETL
4 55 (32.54%) Data Modelling
5 44 (26.04%) Analytics
5 44 (26.04%) Scrum
6 34 (20.12%) Data Management
7 28 (16.57%) Data Analysis
8 24 (14.20%) Master Data Management
9 23 (13.61%) Asset Management
9 23 (13.61%) Mentoring
10 20 (11.83%) Performance Tuning
11 19 (11.24%) Information Management
11 19 (11.24%) Stakeholder Management
12 18 (10.65%) Business Analysis
12 18 (10.65%) Data Governance
13 16 (9.47%) Data Architecture
13 16 (9.47%) Software Engineering
14 15 (8.88%) ETL Development
14 15 (8.88%) Logical Data Model
Programming Languages
1 97 (57.40%) SQL
2 28 (16.57%) PL/SQL
3 26 (15.38%) T-SQL
4 23 (13.61%) Perl
5 20 (11.83%) Java
6 12 (7.10%) Python
6 12 (7.10%) Shell Script
7 9 (5.33%) R
8 8 (4.73%) C#
9 7 (4.14%) VBA
10 2 (1.18%) C
10 2 (1.18%) JavaScript
11 1 (0.59%) PowerShell
11 1 (0.59%) SAS Macro
11 1 (0.59%) Scala
11 1 (0.59%) VB.NET
Qualifications
1 25 (14.79%) Degree
2 3 (1.78%) MCSA
2 3 (1.78%) MCSE
2 3 (1.78%) Microsoft Certification
3 1 (0.59%) ISEB
3 1 (0.59%) ISTQB
3 1 (0.59%) ISTQB Foundation Certification
3 1 (0.59%) Security Cleared
Quality Assurance & Compliance
1 17 (10.06%) Data Quality
2 5 (2.96%) QA
System Software
1 4 (2.37%) Apache Flume
Systems Management
1 3 (1.78%) MOM
2 1 (0.59%) Systems Management Server (SMS)
Vendors
1 89 (52.66%) Oracle
2 46 (27.22%) Informatica
3 43 (25.44%) Microsoft
4 23 (13.61%) MicroStrategy
5 16 (9.47%) IBM
5 16 (9.47%) Tableau
6 15 (8.88%) Cognos
7 12 (7.10%) SAP
8 11 (6.51%) Teradata
9 9 (5.33%) Cloudera
9 9 (5.33%) Pega
10 6 (3.55%) HP
10 6 (3.55%) Netezza
10 6 (3.55%) Sun
11 5 (2.96%) Google
11 5 (2.96%) Vertica
12 3 (1.78%) Talend
13 2 (1.18%) Red Hat
13 2 (1.18%) Sybase
13 2 (1.18%) Twitter
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent salary + benefits
Posted: 3 days ago
Glasgow, Lanarkshire
FPSG Connect
Posted: 3 days ago
Bathgate, West Lothian
Ardour Solutions
Salary: From £30,000 to £35,000 per annum + Benefits
Posted: 4 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £50,000 per annum Plus benefits
Posted: 4 days ago
Edinburgh & Lothians
Meraki Talent Ltd
Salary: Excellent plus bonus and benefits
Posted: 4 days ago
Glasgow, Lanarkshire
Harvey Nash plc
Salary: £40000 - £55000 per annum + benefits
Posted: 4 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £50000 per annum + Benefits
Posted: 22 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £50000 per annum + Benefits
Posted: 19 days ago
Edinburgh, Midlothian
EY
Salary: Competitive
Posted: 22 days ago
Edinburgh, Midlothian
EY
Salary: Competitive
Posted: 22 days ago