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

3 months to
30 Apr 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 81 58 69
Rank change year-on-year
-23 +11
Permanent jobs citing Data Warehouse 85 109 126
As % of all permanent IT jobs located in Scotland 2.96% 3.46% 3.17%
As % of the Database & Business Intelligence category 9.59% 11.20% 9.81%
Number of salaries quoted 45 86 55
Average salary £50,000 £47,500 £47,500
Average salary % change year-on-year
+5.26% -
90% offered a salary of more than £34,300 £32,850 £36,400
10% offered a salary of more than £55,000 £63,250 £95,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
886 973 1284
As % of all permanent IT jobs located in Scotland 30.84% 30.92% 32.32%
Number of salaries quoted 509 609 886
Average salary £47,500 £42,500 £40,000
Average salary % change year-on-year
+11.76% +6.25%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £58,000 £55,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 30 April 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 30 April 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 +23 64 £50,000 - 7
Glasgow -19 31 £50,000 +11.11% 5
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 30 April 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 140 (63.35%) Business Intelligence
2 131 (59.28%) SQL
3 110 (49.77%) Finance
4 91 (41.18%) Oracle
5 86 (38.91%) Agile Software Development
6 81 (36.65%) Stakeholder Management
7 73 (33.03%) ETL
7 73 (33.03%) BusinessObjects
8 68 (30.77%) SQL Server Integration Services
9 62 (28.05%) Cognos
10 61 (27.60%) Data Modelling
10 61 (27.60%) Data Analysis
10 61 (27.60%) Analytical Skills
11 58 (26.24%) Banking
12 46 (20.81%) Data Management
13 45 (20.36%) Degree
13 45 (20.36%) SQL Server
14 42 (19.00%) SQL Server Reporting Services
15 41 (18.55%) SQL Server Analysis Services
16 40 (18.10%) Asset Management
17 39 (17.65%) Business Analysis
17 39 (17.65%) PL/SQL
18 37 (16.74%) QlikView
18 37 (16.74%) Visualisation
19 36 (16.29%) Data Quality
20 35 (15.84%) Oracle Database
21 33 (14.93%) Oracle Database 11g
21 33 (14.93%) Java
22 30 (13.57%) Oracle Database 10g
22 30 (13.57%) Dimensional Modelling

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 30 April 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 29 (13.12%) SAS
2 7 (3.17%) SharePoint
3 6 (2.71%) Apache
3 6 (2.71%) Tomcat
4 5 (2.26%) SharePoint 2010
5 4 (1.81%) GemFire
5 4 (1.81%) Oracle Coherence
5 4 (1.81%) SharePoint 2013
5 4 (1.81%) WebSphere
6 3 (1.36%) BizTalk Server
7 2 (0.90%) Apache Pig
7 2 (0.90%) Apache Spark
8 1 (0.45%) PowerExchange
Applications
1 17 (7.69%) MS Excel
2 6 (2.71%) MS PowerPoint
3 2 (0.90%) MS Office
Business Applications
1 17 (7.69%) Markit EDM
2 3 (1.36%) Oracle 11i
2 3 (1.36%) Oracle ERP
2 3 (1.36%) Primavera
3 1 (0.45%) Oracle Applications
3 1 (0.45%) Oracle EBS
3 1 (0.45%) Oracle EBS R12
3 1 (0.45%) SAP MDM
Cloud Services
1 4 (1.81%) Amazon AWS
2 1 (0.45%) Google Analytics
Communications & Networking
1 1 (0.45%) ATM
1 1 (0.45%) Internet
Database & Business Intelligence
1 73 (33.03%) BusinessObjects
2 68 (30.77%) SQL Server Integration Services
3 45 (20.36%) SQL Server
4 42 (19.00%) SQL Server Reporting Services
5 41 (18.55%) SQL Server Analysis Services
6 37 (16.74%) QlikView
7 35 (15.84%) Oracle Database
8 33 (14.93%) Oracle Database 11g
9 30 (13.57%) Oracle BI EE
9 30 (13.57%) Oracle Database 10g
10 26 (11.76%) Data Mining
10 26 (11.76%) Relational Database
11 22 (9.95%) Oracle ODI
12 21 (9.50%) PowerCenter
13 20 (9.05%) DataStage
14 17 (7.69%) RDBMS
15 16 (7.24%) Big Data
15 16 (7.24%) BODI
16 15 (6.79%) BusinessObjects XI
17 13 (5.88%) Star Schema
Development Applications
1 28 (12.67%) Talend Open Studio
2 10 (4.52%) Git (software)
3 8 (3.62%) JIRA
4 6 (2.71%) Jenkins
4 6 (2.71%) Maven
4 6 (2.71%) Subversion
5 4 (1.81%) SQL Server Management Studio (SSMS)
6 2 (0.90%) Team Foundation Server
7 1 (0.45%) Toad
7 1 (0.45%) Visual Studio
General
1 110 (49.77%) Finance
2 58 (26.24%) Banking
3 13 (5.88%) Retail
4 8 (3.62%) Financial Institution
5 7 (3.17%) Marketing
6 5 (2.26%) Corporate Banking
6 5 (2.26%) Investment Banking
7 4 (1.81%) Retail Banking
7 4 (1.81%) Spanish Language
8 2 (0.90%) Dutch Language
8 2 (0.90%) French Language
8 2 (0.90%) German Language
8 2 (0.90%) Legal
8 2 (0.90%) Publishing
8 2 (0.90%) Telecoms
9 1 (0.45%) General Ledger
Job Titles
1 78 (35.29%) Developer
2 73 (33.03%) Consultant
3 57 (25.79%) Business Intelligence Developer
4 55 (24.89%) Business Intelligence Consultant
5 51 (23.08%) Analyst
6 25 (11.31%) Business Analyst
7 23 (10.41%) Business Consultant
8 17 (7.69%) Technical Analyst
8 17 (7.69%) Technical Business Analyst
9 15 (6.79%) Oracle Consultant
10 14 (6.33%) Architect
11 11 (4.98%) Oracle Developer
11 11 (4.98%) Senior Analyst
11 11 (4.98%) SQL Analyst
11 11 (4.98%) Systems Analyst
12 10 (4.52%) Oracle BI Consultant
12 10 (4.52%) Senior Developer
13 9 (4.07%) Report Developer
14 8 (3.62%) Business Intelligence Analyst
14 8 (3.62%) Senior Oracle Developer
Libraries, Frameworks & Software Standards
1 22 (9.95%) .NET
2 12 (5.43%) XML
3 11 (4.98%) HTML
4 10 (4.52%) RESTful
4 10 (4.52%) Web Services
5 6 (2.71%) Ext JS
5 6 (2.71%) Hibernate
5 6 (2.71%) J2EE
5 6 (2.71%) JSP
5 6 (2.71%) Spring
6 4 (1.81%) BSON
6 4 (1.81%) FIX Protocol
6 4 (1.81%) FIXML
6 4 (1.81%) HTML5
6 4 (1.81%) JSON
6 4 (1.81%) MDX
6 4 (1.81%) SOAP
6 4 (1.81%) WebSphere MQ
7 3 (1.36%) Middleware
7 3 (1.36%) WebCenter
Miscellaneous
1 61 (27.60%) Analytical Skills
2 37 (16.74%) Visualisation
3 22 (9.95%) Management Information System
4 17 (7.69%) Data Integration
5 8 (3.62%) Computer Science
5 8 (3.62%) Mainframe
6 6 (2.71%) Derivative
7 4 (1.81%) Data Structures
7 4 (1.81%) Mathematics
8 2 (0.90%) N-Tier
8 2 (0.90%) Taxonomies
8 2 (0.90%) User Experience
9 1 (0.45%) Credit Risk
9 1 (0.45%) Data Extraction
9 1 (0.45%) IVR
9 1 (0.45%) Online Banking
Operating Systems
1 19 (8.60%) Unix
2 9 (4.07%) Linux
3 7 (3.17%) Windows
4 3 (1.36%) Solaris
4 3 (1.36%) Windows Server 2003
4 3 (1.36%) Windows Server 2008
4 3 (1.36%) Windows Server 2012
Processes & Methodologies
1 140 (63.35%) Business Intelligence
2 86 (38.91%) Agile Software Development
3 81 (36.65%) Stakeholder Management
4 73 (33.03%) ETL
5 61 (27.60%) Data Analysis
5 61 (27.60%) Data Modelling
6 46 (20.81%) Data Management
7 40 (18.10%) Asset Management
8 39 (17.65%) Business Analysis
9 30 (13.57%) Dimensional Modelling
10 29 (13.12%) PRINCE2
11 28 (12.67%) Enterprise Data Management
12 26 (11.76%) Scrum
13 25 (11.31%) Analytics
13 25 (11.31%) ETL Development
14 22 (9.95%) Project Management
15 19 (8.60%) Translating Business Requirements
16 18 (8.14%) Mentoring
17 16 (7.24%) Waterfall
18 15 (6.79%) SDLC
Programming Languages
1 131 (59.28%) SQL
2 39 (17.65%) PL/SQL
3 33 (14.93%) Java
4 13 (5.88%) VBA
5 11 (4.98%) T-SQL
6 10 (4.52%) VB.NET
7 8 (3.62%) C#
8 7 (3.17%) JavaScript
9 6 (2.71%) Perl
10 2 (0.90%) C++
10 2 (0.90%) Python
10 2 (0.90%) Scala
11 1 (0.45%) Data Mining Extensions (DMX)
11 1 (0.45%) R
Qualifications
1 45 (20.36%) Degree
2 28 (12.67%) PRINCE2 Practitioner
2 28 (12.67%) Security Cleared
3 15 (6.79%) ISEB
4 8 (3.62%) ISTQB
4 8 (3.62%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 36 (16.29%) Data Quality
2 15 (6.79%) QA
3 5 (2.26%) Basel II
3 5 (2.26%) Solvency II
4 1 (0.45%) FATCA
4 1 (0.45%) ISO 9001
System Software
1 2 (0.90%) Apache Flume
1 2 (0.90%) HDFS
Systems Management
1 2 (0.90%) Ambari
1 2 (0.90%) Hadoop YARN
1 2 (0.90%) Oozie
2 1 (0.45%) HP Quality Center
Vendors
1 91 (41.18%) Oracle
2 62 (28.05%) Cognos
3 28 (12.67%) Informatica
3 28 (12.67%) Talend
4 23 (10.41%) Microsoft
5 21 (9.50%) Teradata
6 17 (7.69%) Tableau
7 12 (5.43%) SAP
8 10 (4.52%) MicroStrategy
9 3 (1.36%) Hyperion
10 2 (0.90%) IBM
10 2 (0.90%) Splunk
11 1 (0.45%) Ab Initio
11 1 (0.45%) Google
11 1 (0.45%) Siebel
Glasgow, Lanarkshire
Harvey Nash plc
Salary: £65000 - £72000 per annum + Car allowance, bonus, benefits
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent rate plus benefits
Posted: 2 days ago
Glasgow, Lanarkshire
Net Talent
Salary: excellent package and bens
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: competitive benefits, D.O.E.
Posted: 5 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: benefits, D.O.E.
Posted: 5 days ago
Edinburgh, Midlothian
Sopra Steria Recruitment
Salary: Unspecified DOE + flex + benefits
Posted: 12 days ago
Edinburgh
Churchill Frank International
Salary: £45000 - £50000 per annum + Negotiable
Posted: 12 days ago
Glasgow
Cathcart Associates
Posted: 18 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £60000.00 per annum
Posted: 26 days ago