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 28 January 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
28 Jan 2015
Same period 2014 Same period 2013
Data Warehousing
Rank 79 67 46
Rank change year-on-year
-12 -21
Permanent jobs citing Data Warehouse 81 113 141
As % of all permanent IT jobs located in Scotland 2.63% 3.42% 4.80%
As % of the Database & Business Intelligence category 8.75% 11.33% 14.13%
Number of salaries quoted 48 87 96
Average salary £42,500 £47,500 £47,500
Average salary % change year-on-year
-10.52% -
90% offered a salary of more than £35,000 £32,500 £35,000
10% offered a salary of more than £76,500 £75,500 £67,750
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
926 997 998
As % of all permanent IT jobs located in Scotland 30.05% 30.18% 33.99%
Number of salaries quoted 634 700 682
Average salary £40,000 £42,500 £40,000
Average salary % change year-on-year
-5.88% +6.25%
90% offered a salary of more than £32,500 £30,000 £30,000
10% offered a salary of more than £57,500 £55,000 £65,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

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 28 January 2015.

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 28 January 2015. 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
Glasgow +14 39 £40,000 +11.88% 9
Edinburgh -30 25 £42,500 -22.72% 11
Stirling -1 13 £50,000 -4.76% 1
Aberdeen -1 1 - -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 28 January 2015, 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 108 (67.92%) SQL
2 92 (57.86%) Finance
3 82 (51.57%) Business Intelligence
4 63 (39.62%) ETL
5 59 (37.11%) Oracle
6 57 (35.85%) SQL Server
7 52 (32.70%) Business Objects
8 47 (29.56%) Banking
9 34 (21.38%) SAS
10 33 (20.75%) Data Modelling
11 30 (18.87%) SQL Server Integration Services
12 29 (18.24%) Informatica
13 28 (17.61%) Stakeholder Management
13 28 (17.61%) Oracle Database
14 26 (16.35%) MS Excel
14 26 (16.35%) Agile Software Development
14 26 (16.35%) SQL Server Reporting Services
15 23 (14.47%) Data Analysis
15 23 (14.47%) Data Management
15 23 (14.47%) Analytical Skills
16 21 (13.21%) Java
17 20 (12.58%) PL/SQL
17 20 (12.58%) Microsoft
18 19 (11.95%) Oracle Database 10g
18 19 (11.95%) SAP
19 18 (11.32%) Oracle BI EE
20 17 (10.69%) Relational Database
20 17 (10.69%) Performance Tuning
21 16 (10.06%) T-SQL
21 16 (10.06%) RDBMS

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 28 January 2015, 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 34 (21.38%) SAS
2 11 (6.92%) SharePoint
3 6 (3.77%) WebSphere
3 6 (3.77%) Tomcat
4 5 (3.14%) WebLogic
4 5 (3.14%) Oracle HTTP Server
4 5 (3.14%) Oracle Beehive
5 2 (1.26%) Apache Spark
5 2 (1.26%) Oracle Workflow
6 1 (0.63%) Elasticsearch
Applications
1 26 (16.35%) MS Excel
2 10 (6.29%) MS Office
3 3 (1.89%) MS Project
3 3 (1.89%) MS Visio
3 3 (1.89%) SPSS
Business Applications
1 7 (4.40%) Oracle EBS
2 6 (3.77%) Oracle 11i
3 3 (1.89%) Cognos Business Intelligence
4 2 (1.26%) Oracle General Ledger
4 2 (1.26%) Oracle EBS R12
4 2 (1.26%) Oracle Payables
4 2 (1.26%) Oracle Receivables
4 2 (1.26%) Oracle Assets
5 1 (0.63%) SAP Oil and Gas
Cloud Services
1 1 (0.63%) Microsoft Azure
Communications & Networking
1 6 (3.77%) HTTP
2 2 (1.26%) Internet
3 1 (0.63%) ASN.1
Database & Business Intelligence
1 57 (35.85%) SQL Server
2 30 (18.87%) SQL Server Integration Services
3 28 (17.61%) Oracle Database
4 26 (16.35%) SQL Server Reporting Services
5 19 (11.95%) Oracle Database 10g
6 18 (11.32%) Oracle BI EE
7 17 (10.69%) Relational Database
8 16 (10.06%) RDBMS
9 15 (9.43%) SQL Server Analysis Services
10 13 (8.18%) Data Mining
11 12 (7.55%) QlikView
11 12 (7.55%) Oracle Database 11g
11 12 (7.55%) Oracle ODI
12 11 (6.92%) BusinessObjects XI
12 11 (6.92%) BusinessObjects
13 8 (5.03%) DataStage
13 8 (5.03%) SQL Server 2008
13 8 (5.03%) Big Data
14 7 (4.40%) Crystal Reports
14 7 (4.40%) Oracle Reports
Development Applications
1 9 (5.66%) QuickTest Pro
1 9 (5.66%) LoadRunner
1 9 (5.66%) Selenium
2 7 (4.40%) Oracle APEX
3 5 (3.14%) Visual Studio
4 4 (2.52%) ERwin
5 3 (1.89%) JIRA
5 3 (1.89%) PowerDesigner
5 3 (1.89%) FishEye
6 2 (1.26%) TeamCity
6 2 (1.26%) Rational Application Developer
6 2 (1.26%) Toad
6 2 (1.26%) Subversion
6 2 (1.26%) Maven
General
1 92 (57.86%) Finance
2 47 (29.56%) Banking
3 10 (6.29%) Retail
4 7 (4.40%) Investment Banking
5 3 (1.89%) Telecoms
6 2 (1.26%) Financial Institution
6 2 (1.26%) Retail Banking
7 1 (0.63%) Marketing
7 1 (0.63%) Front Office
7 1 (0.63%) General Ledger
Job Titles
1 44 (27.67%) Analyst
2 40 (25.16%) Developer
3 26 (16.35%) Architect
4 19 (11.95%) Business Analyst
5 15 (9.43%) Data Architect
6 14 (8.81%) Consultant
7 13 (8.18%) Test Manager
8 12 (7.55%) Senior Analyst
8 12 (7.55%) Data Analyst
8 12 (7.55%) Business Developer
9 11 (6.92%) Senior Developer
9 11 (6.92%) Business Objects Developer
10 10 (6.29%) Business Intelligence Analyst
11 9 (5.66%) Technical Analyst
11 9 (5.66%) Business Intelligence Consultant
12 8 (5.03%) Senior Business Analyst
13 7 (4.40%) Java Developer
13 7 (4.40%) Project Manager
13 7 (4.40%) Technical Business Analyst
13 7 (4.40%) Senior Java Developer
Libraries, Frameworks & Software Standards
1 11 (6.92%) XML
2 10 (6.29%) .NET
3 7 (4.40%) Middleware
3 7 (4.40%) XML Messaging
3 7 (4.40%) SOAP
3 7 (4.40%) Web Services
3 7 (4.40%) Apache CXF
4 3 (1.89%) ASP.NET
5 2 (1.26%) HTML
5 2 (1.26%) RabbitMQ
5 2 (1.26%) Kafka
5 2 (1.26%) jQuery
6 1 (0.63%) J2EE
6 1 (0.63%) SAP XI
6 1 (0.63%) Spring
6 1 (0.63%) Ajax
6 1 (0.63%) JSON
Miscellaneous
1 23 (14.47%) Analytical Skills
2 8 (5.03%) Derivative
3 7 (4.40%) Credit Risk
3 7 (4.40%) Reference Data
4 6 (3.77%) Equities
4 6 (3.77%) Computer Science
5 3 (1.89%) Taxonomies
5 3 (1.89%) Social Media
5 3 (1.89%) Enterprise Software
6 2 (1.26%) iPad
6 2 (1.26%) Data Integration
6 2 (1.26%) Online Banking
6 2 (1.26%) Mainframe
7 1 (0.63%) Management Information System
7 1 (0.63%) Clustering
7 1 (0.63%) VSAM
7 1 (0.63%) PMI
7 1 (0.63%) Open Source
7 1 (0.63%) User Experience
Operating Systems
1 15 (9.43%) UNIX
2 9 (5.66%) Windows
3 4 (2.52%) Linux
4 2 (1.26%) AIX
Processes & Methodologies
1 82 (51.57%) Business Intelligence
2 63 (39.62%) ETL
3 33 (20.75%) Data Modelling
4 28 (17.61%) Stakeholder Management
5 26 (16.35%) Agile Software Development
6 23 (14.47%) Data Management
6 23 (14.47%) Data Analysis
7 17 (10.69%) Performance Tuning
8 15 (9.43%) Migration
8 15 (9.43%) User Acceptance Testing
9 14 (8.81%) Analytics
10 11 (6.92%) Time Management
10 11 (6.92%) CRM
10 11 (6.92%) Project Management
11 10 (6.29%) Test Automation
11 10 (6.29%) Master Data Management
12 9 (5.66%) Automation Testing
12 9 (5.66%) Kimball Methodology
12 9 (5.66%) Business Analysis
13 8 (5.03%) Dimensional Modelling
Programming Languages
1 108 (67.92%) SQL
2 21 (13.21%) Java
3 20 (12.58%) PL/SQL
4 16 (10.06%) T-SQL
5 10 (6.29%) C#
6 9 (5.66%) VBA
7 6 (3.77%) VB
7 6 (3.77%) VB.NET
7 6 (3.77%) Shell Script
8 4 (2.52%) C++
8 4 (2.52%) JavaScript
8 4 (2.52%) Python
9 2 (1.26%) C
10 1 (0.63%) Perl
10 1 (0.63%) PHP
10 1 (0.63%) JCL
10 1 (0.63%) SAS Macro
10 1 (0.63%) Scala
10 1 (0.63%) R
10 1 (0.63%) VBScript
Qualifications
1 12 (7.55%) Degree
2 11 (6.92%) ISEB
3 5 (3.14%) ISTQB
4 2 (1.26%) ITIL Foundation Certificate
5 1 (0.63%) ISTQB Foundation Certification
5 1 (0.63%) PMI Certification
Quality Assurance & Compliance
1 7 (4.40%) Data Quality
2 4 (2.52%) Solvency II
2 4 (2.52%) Basel II
3 3 (1.89%) SLA
4 2 (1.26%) ISO 9001
4 2 (1.26%) QA
5 1 (0.63%) COREP
System Software
1 5 (3.14%) Firmware
1 5 (3.14%) Oracle RMAN
1 5 (3.14%) Oracle RAC
Systems Management
1 5 (3.14%) Data Guard
2 3 (1.89%) HP Quality Center
Vendors
1 59 (37.11%) Oracle
2 52 (32.70%) Business Objects
3 29 (18.24%) Informatica
4 20 (12.58%) Microsoft
5 19 (11.95%) SAP
6 14 (8.81%) IBM
7 11 (6.92%) Cognos
8 8 (5.03%) Teradata
9 6 (3.77%) Tableau
10 5 (3.14%) Netezza
11 4 (2.52%) Sybase
12 2 (1.26%) PeopleSoft
12 2 (1.26%) Siebel
13 1 (0.63%) Cisco
13 1 (0.63%) HP
13 1 (0.63%) BMC
13 1 (0.63%) Salesforce.com
Glasgow, Lanarkshire
Harvey Nash plc
Salary: £30000 - £45000 per annum
Posted: 3 days ago
Stirlingshire
Circle Recruitment
Salary: £48000 - £52000 per annum + bens + bonus
Posted: 5 days ago
Edinburgh
Churchill Frank
Posted: 10 days ago
Edinburgh
Churchill Frank
Posted: 20 days ago