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

3 months to
20 Feb 2017
Same period 2016 Same period 2015
Data Warehousing
UK / Scotland
Rank 56 55 78
Rank change year-on-year
-1 +23
Permanent jobs citing Data Warehouse 92 122 90
As % of all permanent IT jobs located in Scotland 3.98% 4.16% 2.84%
As % of the Database & Business Intelligence category 11.15% 13.17% 9.16%
Number of salaries quoted 63 72 58
Median salary £42,500 £47,500 £43,000
Median salary % change year-on-year
-10.52% +10.46%
90% offered a salary of more than £29,000 £40,000 £35,000
10% offered a salary of more than £71,500 £55,000 £67,500
UK excluding London median salary £45,000 £45,000 £45,000

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
825 926 982
As % of all permanent IT jobs located in Scotland 35.70% 31.58% 31.01%
Number of salaries quoted 529 595 667
Median salary £42,500 £47,500 £40,000
Median salary % change year-on-year
-10.52% +18.75%
90% offered a salary of more than £30,500 £32,500 £32,500
10% offered a salary of more than £65,000 £55,000 £55,000
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 20 February 2017.

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 20 February 2017. 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 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
Glasgow +3 59 £40,000 -15.78% 7
Edinburgh -43 25 £65,000 +36.84% 2
Renfrewshire - 5 £32,500 -
West Lothian -1 1 £40,000 -41.60%
Scottish Borders - 1 £35,000 - 1
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 20 February 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 Scotland region with a requirement for Data Warehouse.

1 109 (64.50%) SQL
2 81 (47.93%) Business Intelligence
3 72 (42.60%) Finance
4 65 (38.46%) ETL
5 60 (35.50%) Data Modelling
5 60 (35.50%) SQL Server
6 51 (30.18%) SQL Server Integration Services
7 49 (28.99%) Oracle
8 45 (26.63%) Analytical Skills
9 39 (23.08%) Agile Software Development
10 37 (21.89%) PL/SQL
11 36 (21.30%) Microsoft
11 36 (21.30%) Analytics
12 35 (20.71%) Relational Database
12 35 (20.71%) Data Management
12 35 (20.71%) SQL Server Reporting Services
13 34 (20.12%) Data Integration
14 33 (19.53%) MicroStrategy
15 31 (18.34%) Performance Tuning
16 30 (17.75%) MS Excel
17 26 (15.38%) C#
18 24 (14.20%) T-SQL
18 24 (14.20%) .NET
19 22 (13.02%) Unix
19 22 (13.02%) SAS
19 22 (13.02%) RDBMS
20 21 (12.43%) BusinessObjects
21 20 (11.83%) XML
22 19 (11.24%) Git (software)
22 19 (11.24%) Oracle Database

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 22 (13.02%) SAS
2 5 (2.96%) BizTalk Server
3 4 (2.37%) Apache Spark
3 4 (2.37%) SharePoint
4 3 (1.78%) Confluence
5 2 (1.18%) Apache
5 2 (1.18%) JBoss
5 2 (1.18%) Oracle SOA Suite
5 2 (1.18%) Tomcat
6 1 (0.59%) Apache Pig
Applications
1 30 (17.75%) MS Excel
2 2 (1.18%) MS Office
2 2 (1.18%) MS PowerPoint
2 2 (1.18%) S-PLUS
3 1 (0.59%) Spreadsheet
3 1 (0.59%) SPSS
Business Applications
1 2 (1.18%) Cognos Business Intelligence
2 1 (0.59%) Markit EDM
2 1 (0.59%) thinkFolio
Cloud Services
1 6 (3.55%) Amazon AWS
2 5 (2.96%) SaaS
3 4 (2.37%) GitHub
3 4 (2.37%) Microsoft Azure
4 3 (1.78%) Google Analytics
5 2 (1.18%) Amazon EMR
5 2 (1.18%) IaaS
6 1 (0.59%) Cloud Computing
6 1 (0.59%) Google Cloud Platform
Communications & Networking
1 1 (0.59%) SMS
Database & Business Intelligence
1 60 (35.50%) SQL Server
2 51 (30.18%) SQL Server Integration Services
3 35 (20.71%) Relational Database
3 35 (20.71%) SQL Server Reporting Services
4 22 (13.02%) RDBMS
5 21 (12.43%) BusinessObjects
6 19 (11.24%) Oracle Database
7 15 (8.88%) Big Data
8 14 (8.28%) DB2
9 13 (7.69%) Oracle Database 11g
9 13 (7.69%) SQL Server Analysis Services
10 12 (7.10%) BusinessObjects Web Intelligence
10 12 (7.10%) Hadoop
10 12 (7.10%) Oracle8/8i Database
10 12 (7.10%) SQL Server 2012
11 11 (6.51%) Data Mart
11 11 (6.51%) Oracle Database 10g
12 10 (5.92%) NoSQL
12 10 (5.92%) Oracle9i Database
13 9 (5.33%) SAS Data Integration Studio
Development Applications
1 19 (11.24%) Git (software)
2 15 (8.88%) Bitbucket
3 13 (7.69%) Talend Open Studio
4 12 (7.10%) ERwin
5 10 (5.92%) PVCS
6 8 (4.73%) Selenium
6 8 (4.73%) Visual Studio
7 5 (2.96%) MagicDraw
8 3 (1.78%) JIRA
8 3 (1.78%) Oracle Forms
8 3 (1.78%) Team Foundation Server
9 2 (1.18%) JBehave
9 2 (1.18%) Jenkins
9 2 (1.18%) Maven
General
1 72 (42.60%) Finance
2 17 (10.06%) Banking
3 7 (4.14%) Retail
4 5 (2.96%) Back Office
5 4 (2.37%) General Ledger
6 3 (1.78%) Marketing
7 2 (1.18%) Retail Banking
8 1 (0.59%) Advertising
8 1 (0.59%) Games
8 1 (0.59%) Legal
8 1 (0.59%) Telecoms
Job Titles
1 72 (42.60%) Developer
2 27 (15.98%) SQL Developer
3 18 (10.65%) Analyst
3 18 (10.65%) Architect
4 17 (10.06%) Senior Developer
5 16 (9.47%) Database Developer
5 16 (9.47%) SQL Database Developer
6 15 (8.88%) C# Developer
6 15 (8.88%) DBA
6 15 (8.88%) Oracle Developer
7 14 (8.28%) Business Intelligence Developer
8 12 (7.10%) SAP BusinessObjects (BO) Developer
9 11 (6.51%) Consultant
10 10 (5.92%) Administrator
10 10 (5.92%) Data Architect
10 10 (5.92%) Senior Oracle Developer
11 8 (4.73%) Data Modeller
12 7 (4.14%) Senior Architect
13 6 (3.55%) Senior SQL Developer
13 6 (3.55%) SQL DBA
Libraries, Frameworks & Software Standards
1 24 (14.20%) .NET
2 20 (11.83%) XML
3 15 (8.88%) ASP.NET
3 15 (8.88%) ASP.NET MVC
4 4 (2.37%) XML Schema
5 3 (1.78%) Kafka
6 2 (1.18%) HTML
6 2 (1.18%) Middleware
6 2 (1.18%) Web Services
6 2 (1.18%) XMPP
7 1 (0.59%) ASP.NET Web Forms
7 1 (0.59%) CSS
7 1 (0.59%) Grails
7 1 (0.59%) HTML5
7 1 (0.59%) JDO
7 1 (0.59%) MDX
7 1 (0.59%) REST
7 1 (0.59%) Spring
Miscellaneous
1 45 (26.63%) Analytical Skills
2 15 (8.88%) Credit Risk
2 15 (8.88%) Hedge funds
3 6 (3.55%) Reference Data
4 5 (2.96%) Data Structures
4 5 (2.96%) Management Information System
5 4 (2.37%) Taxonomies
6 3 (1.78%) Computer Science
6 3 (1.78%) Enterprise Software
7 2 (1.18%) Mainframe
7 2 (1.18%) Virtual Team
8 1 (0.59%) Clustering
Operating Systems
1 22 (13.02%) Unix
2 4 (2.37%) Linux
3 2 (1.18%) Red Hat Enterprise Linux
4 1 (0.59%) Windows
Processes & Methodologies
1 81 (47.93%) Business Intelligence
2 65 (38.46%) ETL
3 60 (35.50%) Data Modelling
4 39 (23.08%) Agile Software Development
5 36 (21.30%) Analytics
6 35 (20.71%) Data Management
7 34 (20.12%) Data Integration
8 31 (18.34%) Performance Tuning
9 18 (10.65%) Data Analysis
9 18 (10.65%) ETL Development
9 18 (10.65%) Infrastructure Management
10 16 (9.47%) Data Architecture
10 16 (9.47%) Investment Management
10 16 (9.47%) MVC
11 14 (8.28%) User Acceptance Testing
12 12 (7.10%) Metadata Management
12 12 (7.10%) Scorecard
12 12 (7.10%) SDLC
12 12 (7.10%) Test Planning
13 11 (6.51%) Master Data Management
Programming Languages
1 109 (64.50%) SQL
2 37 (21.89%) PL/SQL
3 26 (15.38%) C#
4 24 (14.20%) T-SQL
5 17 (10.06%) VBA
6 16 (9.47%) VB.NET
7 5 (2.96%) Java
7 5 (2.96%) Python
8 4 (2.37%) PowerShell
9 3 (1.78%) Perl
10 2 (1.18%) JavaScript
10 2 (1.18%) R
10 2 (1.18%) Ruby
11 1 (0.59%) C++
11 1 (0.59%) Groovy
11 1 (0.59%) SAS Macro
11 1 (0.59%) Scala
11 1 (0.59%) Shell Script
Qualifications
1 11 (6.51%) Degree
1 11 (6.51%) Security Cleared
2 8 (4.73%) MCSA
2 8 (4.73%) MCSE
2 8 (4.73%) Microsoft Certification
3 5 (2.96%) MCITP
4 4 (2.37%) ISEB
Quality Assurance & Compliance
1 18 (10.65%) QA
2 15 (8.88%) Basel III
3 13 (7.69%) Data Quality
4 4 (2.37%) ISO20022
Systems Management
1 4 (2.37%) HP Quality Center
2 1 (0.59%) Systems Management Server (SMS)
Vendors
1 49 (28.99%) Oracle
2 36 (21.30%) Microsoft
3 33 (19.53%) MicroStrategy
4 15 (8.88%) Informatica
4 15 (8.88%) Perforce
5 13 (7.69%) Talend
5 13 (7.69%) Teradata
6 12 (7.10%) Tableau
7 11 (6.51%) Cognos
8 10 (5.92%) IBM
9 9 (5.33%) Netezza
10 8 (4.73%) Pega
11 5 (2.96%) HP
11 5 (2.96%) SAP
12 3 (1.78%) Google
13 2 (1.18%) CA Agile Central
13 2 (1.18%) Red Hat
13 2 (1.18%) Salesforce.com
14 1 (0.59%) Alteryx
14 1 (0.59%) Cloudera
Edinburgh, Midlothian
Churchill Frank
Salary: £33000 - £40000 per annum
Posted: 2 days ago
Glasgow
Huxley
Salary: competitive
Posted: 10 days ago
Galashiels
Cathcart Associates
Salary: £30000 - £40000 per annum
Posted: 21 days ago
Glasgow
Huxley
Salary: competitive
Posted: 13 days ago
Glasgow
Huxley
Salary: competitive
Posted: 13 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £50,000-£75,000 depending on experience.
Posted: 4 days ago
Glasgow
Huxley
Salary: competitive
Posted: 27 days ago
Glasgow
Huxley
Salary: £35000 - £43000 per annum + Excellent Benefits
Posted: 26 days ago
Glasgow
Huxley
Salary: £35000 - £43000 per annum + Excellent Benefits
Posted: 27 days ago
Glasgow
Huxley
Salary: £35000 - £43000 per annum + Excellent Benefits
Posted: 27 days ago