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 average salaries offered in IT jobs that have cited Data Warehouse over the 3 months to 10 February 2016 with a comparison to the same period in the previous 2 years.

Location
3 months to
10 Feb 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 47 83 71
Rank change year-on-year
+36 -12
Permanent jobs citing Data Warehouse 127 82 112
As % of all permanent IT jobs located in Scotland 4.28% 2.64% 3.35%
As % of the Database & Business Intelligence category 13.61% 8.53% 10.83%
Number of salaries quoted 75 49 84
Average salary £47,500 £42,500 £47,500
Average salary % change year-on-year
+11.76% -10.52%
90% offered a salary of more than £40,000 £35,000 £32,500
10% offered a salary of more than £55,000 £75,000 £80,000
UK excluding London average salary £45,000 £45,000 £45,000
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
933 961 1034
As % of all permanent IT jobs located in Scotland 31.46% 30.93% 30.93%
Number of salaries quoted 604 647 721
Average salary £47,500 £40,000 £42,500
Average salary % change year-on-year
+18.75% -5.88%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £55,000 £65,000 £55,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

Data Warehouse
Jobs Demand Trend in Scotland

This chart provides a 3-month moving total of permanent IT jobs citing Data Warehouse across the Scotland region as a proportion of the total demand within 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 10 February 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 average salaries quoted in IT jobs citing Data Warehouse within the Scotland region over the 3 months to 10 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +50 93 £47,500 +11.76% 6
Glasgow +14 85 £47,500 +18.75% 6
West Lothian +6 1 £68,500 +95.71%
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 10 February 2016, IT jobs across the Scotland region citing Data Warehouse also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Data Warehouse.

1 170 (63.67%) SQL
2 165 (61.80%) Business Intelligence
3 136 (50.94%) Finance
4 105 (39.33%) BusinessObjects
5 100 (37.45%) Oracle
6 98 (36.70%) ETL
7 92 (34.46%) Stakeholder Management
7 92 (34.46%) Agile Software Development
8 79 (29.59%) Data Modelling
9 73 (27.34%) Analytical Skills
10 71 (26.59%) Banking
11 67 (25.09%) Data Management
12 64 (23.97%) SQL Server Integration Services
12 64 (23.97%) Data Quality
13 59 (22.10%) Cognos
14 57 (21.35%) PL/SQL
14 57 (21.35%) SQL Server Reporting Services
15 56 (20.97%) QlikView
16 54 (20.22%) SQL Server Analysis Services
17 49 (18.35%) SQL Server
18 48 (17.98%) Visualisation
19 45 (16.85%) Data Analysis
20 44 (16.48%) SAS
20 44 (16.48%) Informatica
21 40 (14.98%) Security Cleared
21 40 (14.98%) Dimensional Modelling
22 38 (14.23%) PRINCE2 Practitioner
22 38 (14.23%) Enterprise Data Management
22 38 (14.23%) Talend Open Studio
22 38 (14.23%) PRINCE2

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 10 February 2016, IT jobs across the Scotland region citing Data Warehouse also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Data Warehouse. Up to 20 skills are shown per category.

Application Platforms
1 44 (16.48%) SAS
2 4 (1.50%) Apache
2 4 (1.50%) GemFire
2 4 (1.50%) Oracle Coherence
2 4 (1.50%) SharePoint
2 4 (1.50%) SharePoint 2010
2 4 (1.50%) SharePoint 2013
2 4 (1.50%) Tomcat
2 4 (1.50%) WebSphere
3 3 (1.12%) Apache Pig
3 3 (1.12%) BizTalk Server
3 3 (1.12%) PowerExchange
4 2 (0.75%) Apache Spark
Applications
1 29 (10.86%) MS Excel
2 4 (1.50%) MS PowerPoint
3 1 (0.37%) MS Office
3 1 (0.37%) SPSS
Business Applications
1 11 (4.12%) Oracle 11i
2 3 (1.12%) Oracle EBS R12
2 3 (1.12%) Oracle ERP
2 3 (1.12%) Primavera
3 2 (0.75%) Oracle EBS
4 1 (0.37%) SAP MDM
Cloud Services
1 6 (2.25%) Amazon AWS
1 6 (2.25%) Google Analytics
2 5 (1.87%) Microsoft Azure
3 2 (0.75%) Amazon EC2
Communications & Networking
1 2 (0.75%) ATM
1 2 (0.75%) Internet
Database & Business Intelligence
1 105 (39.33%) BusinessObjects
2 64 (23.97%) SQL Server Integration Services
3 57 (21.35%) SQL Server Reporting Services
4 56 (20.97%) QlikView
5 54 (20.22%) SQL Server Analysis Services
6 49 (18.35%) SQL Server
7 36 (13.48%) Oracle Database
8 33 (12.36%) Oracle Database 10g
9 29 (10.86%) Oracle Database 11g
10 27 (10.11%) Big Data
11 26 (9.74%) Data Mining
12 25 (9.36%) Relational Database
13 22 (8.24%) PowerCenter
14 21 (7.87%) Oracle BI EE
15 18 (6.74%) Star Schema
16 17 (6.37%) RDBMS
17 16 (5.99%) NoSQL
17 16 (5.99%) Oracle ODI
18 15 (5.62%) BODI
18 15 (5.62%) BusinessObjects Web Intelligence
Development Applications
1 38 (14.23%) Talend Open Studio
2 9 (3.37%) HP UFT
3 8 (3.00%) Git (software)
3 8 (3.00%) JIRA
4 5 (1.87%) Team Foundation Server
4 5 (1.87%) Visual Studio
5 4 (1.50%) Jenkins
5 4 (1.50%) Maven
5 4 (1.50%) SQL Server Management Studio (SSMS)
5 4 (1.50%) Subversion
6 1 (0.37%) Oracle Forms
6 1 (0.37%) PowerDesigner
General
1 136 (50.94%) Finance
2 71 (26.59%) Banking
3 13 (4.87%) Retail
4 12 (4.49%) Spanish Language
5 11 (4.12%) Investment Banking
6 8 (3.00%) Financial Institution
7 7 (2.62%) Marketing
8 6 (2.25%) Retail Banking
9 3 (1.12%) Corporate Banking
10 2 (0.75%) Publishing
11 1 (0.37%) General Ledger
Job Titles
1 86 (32.21%) Consultant
2 84 (31.46%) Developer
3 76 (28.46%) Analyst
4 65 (24.34%) Business Intelligence Developer
5 63 (23.60%) Business Intelligence Consultant
6 29 (10.86%) Business Analyst
7 22 (8.24%) Architect
8 21 (7.87%) Technical Analyst
9 20 (7.49%) Technical Business Analyst
10 18 (6.74%) Business Consultant
11 15 (5.62%) Oracle Consultant
12 14 (5.24%) Business Intelligence Analyst
12 14 (5.24%) Senior Analyst
13 13 (4.87%) Senior Business Analyst
14 12 (4.49%) Business Objects Developer
14 12 (4.49%) Test Analyst
15 10 (3.75%) Oracle BI Consultant
16 9 (3.37%) SAS Analyst
17 8 (3.00%) SQL Analyst
17 8 (3.00%) Systems Analyst
Libraries, Frameworks & Software Standards
1 20 (7.49%) .NET
2 10 (3.75%) Web Services
3 9 (3.37%) HTML
3 9 (3.37%) XML
4 8 (3.00%) RESTful
5 5 (1.87%) SOAP
6 4 (1.50%) BSON
6 4 (1.50%) Ext JS
6 4 (1.50%) FIX Protocol
6 4 (1.50%) FIXML
6 4 (1.50%) Hibernate
6 4 (1.50%) HTML5
6 4 (1.50%) J2EE
6 4 (1.50%) JSON
6 4 (1.50%) JSP
6 4 (1.50%) MDX
6 4 (1.50%) Spring
6 4 (1.50%) WebSphere MQ
7 3 (1.12%) Middleware
7 3 (1.12%) WebCenter
Miscellaneous
1 73 (27.34%) Analytical Skills
2 48 (17.98%) Visualisation
3 34 (12.73%) Data Integration
4 11 (4.12%) Management Information System
5 8 (3.00%) Mainframe
5 8 (3.00%) N-Tier
5 8 (3.00%) Taxonomies
6 6 (2.25%) Computer Science
6 6 (2.25%) Credit Risk
6 6 (2.25%) Data Structures
7 5 (1.87%) Mathematics
8 4 (1.50%) Derivative
9 2 (0.75%) Enterprise Software
9 2 (0.75%) IVR
9 2 (0.75%) Online Banking
9 2 (0.75%) PMI
10 1 (0.37%) Data Extraction
10 1 (0.37%) Economics
10 1 (0.37%) Statistics
Operating Systems
1 31 (11.61%) Unix
2 13 (4.87%) Linux
2 13 (4.87%) Windows
3 5 (1.87%) Solaris
4 3 (1.12%) Windows Server 2003
4 3 (1.12%) Windows Server 2008
4 3 (1.12%) Windows Server 2012
5 2 (0.75%) AIX
Processes & Methodologies
1 165 (61.80%) Business Intelligence
2 98 (36.70%) ETL
3 92 (34.46%) Agile Software Development
3 92 (34.46%) Stakeholder Management
4 79 (29.59%) Data Modelling
5 67 (25.09%) Data Management
6 45 (16.85%) Data Analysis
7 40 (14.98%) Dimensional Modelling
8 38 (14.23%) Analytics
8 38 (14.23%) Enterprise Data Management
8 38 (14.23%) PRINCE2
9 30 (11.24%) Business Analysis
10 22 (8.24%) ETL Development
10 22 (8.24%) Scrum
11 20 (7.49%) UML
12 19 (7.12%) User Acceptance Testing
13 17 (6.37%) Logical Data Model
14 16 (5.99%) Translating Business Requirements
15 15 (5.62%) Master Data Management
15 15 (5.62%) SDLC
Programming Languages
1 170 (63.67%) SQL
2 57 (21.35%) PL/SQL
3 34 (12.73%) Java
4 18 (6.74%) T-SQL
5 13 (4.87%) C#
6 9 (3.37%) Perl
7 8 (3.00%) C++
8 7 (2.62%) JavaScript
8 7 (2.62%) VB.NET
9 6 (2.25%) VBA
10 2 (0.75%) Python
10 2 (0.75%) Scala
11 1 (0.37%) Bash Shell
11 1 (0.37%) Data Mining Extensions (DMX)
11 1 (0.37%) R
11 1 (0.37%) Shell Script
Qualifications
1 40 (14.98%) Security Cleared
2 38 (14.23%) PRINCE2 Practitioner
3 26 (9.74%) Degree
4 18 (6.74%) ISEB
5 5 (1.87%) ISTQB
5 5 (1.87%) ISTQB Foundation Certification
6 2 (0.75%) PMI Certification
Quality Assurance & Compliance
1 64 (23.97%) Data Quality
2 20 (7.49%) QA
3 12 (4.49%) Basel II
3 12 (4.49%) Solvency II
4 3 (1.12%) FATCA
5 2 (0.75%) COREP
5 2 (0.75%) FINREP
System Software
1 3 (1.12%) Apache Flume
2 2 (0.75%) HDFS
Systems Management
1 9 (3.37%) HP Quality Center
2 2 (0.75%) Ambari
2 2 (0.75%) Hadoop YARN
2 2 (0.75%) Oozie
3 1 (0.37%) MOM
3 1 (0.37%) Oracle RMAN
Vendors
1 100 (37.45%) Oracle
2 59 (22.10%) Cognos
3 44 (16.48%) Informatica
4 38 (14.23%) Talend
5 32 (11.99%) Teradata
6 20 (7.49%) Microsoft
6 20 (7.49%) Tableau
7 6 (2.25%) Google
7 6 (2.25%) MicroStrategy
8 5 (1.87%) Vertica
9 4 (1.50%) SAP
10 3 (1.12%) Hyperion
11 2 (0.75%) Siebel
11 2 (0.75%) Splunk
12 1 (0.37%) Ab Initio
12 1 (0.37%) Cognizant
12 1 (0.37%) Pega
Edinburgh, Midlothian
Sopra Steria Recruitment
Salary: Unspecified
Posted: 2 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £55,000 per annum Plus excellent benefits
Posted: 5 days ago
Edinburgh, Midlothian
McGregor Boyall
Posted: 6 days ago
Edinburgh, Midlothian
McGregor Boyall
Posted: 6 days ago
Glasgow, Lanarkshire
Cathcart Associates Ltd
Posted: 6 days ago