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

Location
3 months to
14 Feb 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 49 81 75
Rank change year-on-year
+32 -6
Permanent jobs citing Data Warehouse 123 83 107
As % of all permanent IT jobs located in Scotland 4.13% 2.70% 3.23%
As % of the Database & Business Intelligence category 13.24% 8.71% 10.43%
Number of salaries quoted 73 49 79
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,500
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
929 953 1026
As % of all permanent IT jobs located in Scotland 31.23% 30.97% 31.02%
Number of salaries quoted 597 645 715
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 14 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 14 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 +49 90 £47,500 +11.76% 17
Glasgow +22 82 £47,500 +18.75% 4
West Lothian +7 1 £68,500 +95.71%
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 14 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 167 (64.23%) SQL
2 160 (61.54%) Business Intelligence
3 132 (50.77%) Finance
4 103 (39.62%) BusinessObjects
5 97 (37.31%) Oracle
6 95 (36.54%) ETL
7 90 (34.62%) Stakeholder Management
7 90 (34.62%) Agile Software Development
8 77 (29.62%) Data Modelling
9 70 (26.92%) Banking
9 70 (26.92%) Analytical Skills
10 65 (25.00%) Data Management
11 62 (23.85%) SQL Server Integration Services
11 62 (23.85%) Data Quality
12 58 (22.31%) Cognos
13 57 (21.92%) PL/SQL
14 55 (21.15%) SQL Server Reporting Services
14 55 (21.15%) QlikView
15 52 (20.00%) SQL Server Analysis Services
16 47 (18.08%) Visualisation
17 46 (17.69%) SQL Server
18 45 (17.31%) Data Analysis
19 43 (16.54%) SAS
19 43 (16.54%) Informatica
20 40 (15.38%) Dimensional Modelling
21 39 (15.00%) Security Cleared
22 37 (14.23%) Talend Open Studio
22 37 (14.23%) PRINCE2 Practitioner
22 37 (14.23%) Enterprise Data Management
22 37 (14.23%) PRINCE2

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 14 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 43 (16.54%) SAS
2 4 (1.54%) Apache
2 4 (1.54%) GemFire
2 4 (1.54%) Oracle Coherence
2 4 (1.54%) SharePoint
2 4 (1.54%) SharePoint 2010
2 4 (1.54%) SharePoint 2013
2 4 (1.54%) Tomcat
2 4 (1.54%) WebSphere
3 3 (1.15%) Apache Pig
3 3 (1.15%) BizTalk Server
3 3 (1.15%) PowerExchange
4 2 (0.77%) Apache Spark
Applications
1 28 (10.77%) MS Excel
2 4 (1.54%) MS PowerPoint
3 1 (0.38%) MS Office
3 1 (0.38%) SPSS
Business Applications
1 11 (4.23%) Oracle 11i
2 3 (1.15%) Oracle EBS R12
2 3 (1.15%) Oracle ERP
2 3 (1.15%) Primavera
3 2 (0.77%) Oracle EBS
4 1 (0.38%) SAP MDM
Cloud Services
1 6 (2.31%) Amazon AWS
2 5 (1.92%) Google Analytics
3 4 (1.54%) Microsoft Azure
4 2 (0.77%) Amazon EC2
Communications & Networking
1 2 (0.77%) ATM
1 2 (0.77%) Internet
Database & Business Intelligence
1 103 (39.62%) BusinessObjects
2 62 (23.85%) SQL Server Integration Services
3 55 (21.15%) QlikView
3 55 (21.15%) SQL Server Reporting Services
4 52 (20.00%) SQL Server Analysis Services
5 46 (17.69%) SQL Server
6 35 (13.46%) Oracle Database
7 33 (12.69%) Oracle Database 10g
8 29 (11.15%) Oracle Database 11g
9 26 (10.00%) Big Data
10 25 (9.62%) Data Mining
10 25 (9.62%) Relational Database
11 21 (8.08%) Oracle BI EE
11 21 (8.08%) PowerCenter
12 18 (6.92%) Star Schema
13 17 (6.54%) RDBMS
14 16 (6.15%) NoSQL
14 16 (6.15%) Oracle ODI
15 15 (5.77%) BODI
15 15 (5.77%) BusinessObjects Web Intelligence
Development Applications
1 37 (14.23%) Talend Open Studio
2 9 (3.46%) HP UFT
3 8 (3.08%) Git (software)
3 8 (3.08%) JIRA
4 4 (1.54%) Jenkins
4 4 (1.54%) Maven
4 4 (1.54%) SQL Server Management Studio (SSMS)
4 4 (1.54%) Subversion
4 4 (1.54%) Team Foundation Server
4 4 (1.54%) Visual Studio
5 1 (0.38%) PowerDesigner
General
1 132 (50.77%) Finance
2 70 (26.92%) Banking
3 13 (5.00%) Retail
4 12 (4.62%) Spanish Language
5 11 (4.23%) Investment Banking
6 8 (3.08%) Financial Institution
7 7 (2.69%) Marketing
8 6 (2.31%) Retail Banking
9 3 (1.15%) Corporate Banking
10 2 (0.77%) Publishing
11 1 (0.38%) General Ledger
Job Titles
1 85 (32.69%) Consultant
2 81 (31.15%) Developer
3 75 (28.85%) Analyst
4 63 (24.23%) Business Intelligence Developer
5 62 (23.85%) Business Intelligence Consultant
6 28 (10.77%) Business Analyst
7 21 (8.08%) Architect
8 20 (7.69%) Technical Analyst
9 19 (7.31%) Technical Business Analyst
10 18 (6.92%) Business Consultant
11 15 (5.77%) Oracle Consultant
12 14 (5.38%) Business Intelligence Analyst
12 14 (5.38%) Senior Analyst
13 13 (5.00%) Senior Business Analyst
14 12 (4.62%) Business Objects Developer
14 12 (4.62%) Test Analyst
15 10 (3.85%) Oracle BI Consultant
16 9 (3.46%) SAS Analyst
17 8 (3.08%) SQL Analyst
17 8 (3.08%) Systems Analyst
Libraries, Frameworks & Software Standards
1 19 (7.31%) .NET
2 10 (3.85%) Web Services
3 9 (3.46%) HTML
3 9 (3.46%) XML
4 8 (3.08%) RESTful
5 5 (1.92%) SOAP
6 4 (1.54%) BSON
6 4 (1.54%) Ext JS
6 4 (1.54%) FIX Protocol
6 4 (1.54%) FIXML
6 4 (1.54%) Hibernate
6 4 (1.54%) HTML5
6 4 (1.54%) J2EE
6 4 (1.54%) JSON
6 4 (1.54%) JSP
6 4 (1.54%) MDX
6 4 (1.54%) Spring
6 4 (1.54%) WebSphere MQ
7 3 (1.15%) Middleware
7 3 (1.15%) WebCenter
Miscellaneous
1 70 (26.92%) Analytical Skills
2 47 (18.08%) Visualisation
3 33 (12.69%) Data Integration
4 10 (3.85%) Management Information System
5 8 (3.08%) Mainframe
5 8 (3.08%) N-Tier
5 8 (3.08%) Taxonomies
6 6 (2.31%) Computer Science
6 6 (2.31%) Credit Risk
6 6 (2.31%) Data Structures
7 5 (1.92%) Mathematics
8 4 (1.54%) Derivative
9 2 (0.77%) IVR
9 2 (0.77%) Online Banking
9 2 (0.77%) PMI
10 1 (0.38%) Data Extraction
10 1 (0.38%) Economics
10 1 (0.38%) Enterprise Software
10 1 (0.38%) Statistics
Operating Systems
1 31 (11.92%) Unix
2 13 (5.00%) Linux
2 13 (5.00%) Windows
3 5 (1.92%) Solaris
4 3 (1.15%) Windows Server 2003
4 3 (1.15%) Windows Server 2008
4 3 (1.15%) Windows Server 2012
5 2 (0.77%) AIX
Processes & Methodologies
1 160 (61.54%) Business Intelligence
2 95 (36.54%) ETL
3 90 (34.62%) Agile Software Development
3 90 (34.62%) Stakeholder Management
4 77 (29.62%) Data Modelling
5 65 (25.00%) Data Management
6 45 (17.31%) Data Analysis
7 40 (15.38%) Dimensional Modelling
8 37 (14.23%) Analytics
8 37 (14.23%) Enterprise Data Management
8 37 (14.23%) PRINCE2
9 29 (11.15%) Business Analysis
10 22 (8.46%) ETL Development
11 21 (8.08%) Scrum
12 19 (7.31%) UML
12 19 (7.31%) User Acceptance Testing
13 17 (6.54%) Logical Data Model
14 16 (6.15%) Translating Business Requirements
15 15 (5.77%) Project Management
16 14 (5.38%) TDD
Programming Languages
1 167 (64.23%) SQL
2 57 (21.92%) PL/SQL
3 34 (13.08%) Java
4 17 (6.54%) T-SQL
5 11 (4.23%) C#
6 9 (3.46%) Perl
7 8 (3.08%) C++
8 7 (2.69%) VB.NET
9 6 (2.31%) JavaScript
9 6 (2.31%) VBA
10 2 (0.77%) Python
10 2 (0.77%) Scala
11 1 (0.38%) Bash Shell
11 1 (0.38%) Data Mining Extensions (DMX)
11 1 (0.38%) R
11 1 (0.38%) Shell Script
Qualifications
1 39 (15.00%) Security Cleared
2 37 (14.23%) PRINCE2 Practitioner
3 26 (10.00%) Degree
4 17 (6.54%) ISEB
5 5 (1.92%) ISTQB
5 5 (1.92%) ISTQB Foundation Certification
6 2 (0.77%) PMI Certification
Quality Assurance & Compliance
1 62 (23.85%) Data Quality
2 20 (7.69%) QA
3 11 (4.23%) Basel II
3 11 (4.23%) Solvency II
4 3 (1.15%) FATCA
5 2 (0.77%) COREP
5 2 (0.77%) FINREP
System Software
1 3 (1.15%) Apache Flume
2 2 (0.77%) HDFS
Systems Management
1 9 (3.46%) HP Quality Center
2 2 (0.77%) Ambari
2 2 (0.77%) Hadoop YARN
2 2 (0.77%) Oozie
3 1 (0.38%) MOM
3 1 (0.38%) Oracle RMAN
Vendors
1 97 (37.31%) Oracle
2 58 (22.31%) Cognos
3 43 (16.54%) Informatica
4 37 (14.23%) Talend
5 31 (11.92%) Teradata
6 19 (7.31%) Microsoft
6 19 (7.31%) Tableau
7 6 (2.31%) MicroStrategy
8 5 (1.92%) Google
8 5 (1.92%) Vertica
9 4 (1.54%) SAP
10 3 (1.15%) Hyperion
11 2 (0.77%) Siebel
11 2 (0.77%) Splunk
12 1 (0.38%) Ab Initio
12 1 (0.38%) Cognizant
12 1 (0.38%) Pega
Edinburgh, Midlothian
Oho Group Ltd.
Salary: £40k - 60k per year + Benefits
Posted: Yesterday
Edinburgh, Midlothian
Oho Group Ltd.
Salary: £40k - 60k per year + Benefits
Posted: Yesterday
Edinburgh, Midlothian
Oho Group Ltd.
Salary: £45k - 60k per year + Benefits
Posted: Yesterday
Edinburgh, Midlothian
Search Consultancy
Salary: £30000.00 - £60000.00 per annum + benefits
Posted: 2 days ago
Edinburgh & Lothians
Rockhall Recruitment
Salary: From £35,000 to £55,000 per annum + Package
Posted: 2 days ago
Edinburgh, Midlothian
Harvey Nash plc
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: £35000 - £60000 per annum + benefits
Posted: 3 days ago
Edinburgh, Midlothian
McGregor Boyall
Salary: £35000 - £40000 per annum
Posted: 4 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 4 days ago
Edinburgh, Midlothian
Asset Resourcing Ltd
Salary: £45000 - £65000 per annum + benefits _ employee focussed development
Posted: 4 days ago
Edinburgh, Midlothian
Sopra Steria Recruitment
Salary: Unspecified
Posted: 5 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £55,000 per annum Plus excellent benefits
Posted: 8 days ago
Glasgow
Cathcart Associates
Posted: 11 days ago