The first table below looks at the demand 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 25 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the Scotland region.

Location
3 months to
25 Jul 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 79 39 54
Rank change year-on-year
-40 +15
Permanent jobs citing Data Warehouse 102 155 114
As % of all permanent IT jobs located in Scotland 2.74% 4.73% 3.55%
As % of the Database & Business Intelligence category 8.65% 13.10% 11.11%
Number of salaries quoted 74 91 65
Average salary £45,000 £48,000 £50,000
Average salary % change year-on-year
-6.25% -4.00%
90% offered a salary of more than £32,500 £34,000 £35,000
10% offered a salary of more than £60,000 £60,000 £60,000
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
Database & Business Intelligence Category
Scotland
Permanent IT job ads with a match in the
Database & Business Intelligence category
1179 1183 1026
As % of all permanent IT jobs located in Scotland 31.70% 36.08% 31.91%
Number of salaries quoted 786 795 729
Average salary £42,500 £41,000 £37,500
Average salary % change year-on-year
+3.65% +9.33%
90% offered a salary of more than £30,000 £29,000 £27,500
10% offered a salary of more than £57,500 £52,500 £55,500
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%
Data Warehouse
UK

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 25 July 2014.

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 25 July 2014. 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 -13 58 £47,500 -13.63% 6
Glasgow -37 32 £42,500 - 5
Stirling -18 3 £45,000 -6.25%
Fife - 2 £37,500 -
Aberdeen +8 1 - -
West Lothian -3 1 £50,000 +38.88% 1
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 25 July 2014, 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 145 (63.88%) Business Intelligence
2 108 (47.58%) Oracle
3 102 (44.93%) SQL
4 96 (42.29%) Finance
5 80 (35.24%) ETL
6 49 (21.59%) Oracle Database
7 45 (19.82%) Microsoft
8 43 (18.94%) SQL Server
8 43 (18.94%) Performance Tuning
9 42 (18.50%) UNIX
9 42 (18.50%) Banking
10 37 (16.30%) Informatica
11 36 (15.86%) Data Modelling
11 36 (15.86%) Data Management
12 35 (15.42%) SQL Server Reporting Services
12 35 (15.42%) Relational Database
13 34 (14.98%) Oracle BI EE
13 34 (14.98%) PL/SQL
14 33 (14.54%) SQL Server Integration Services
15 32 (14.10%) Oracle EBS
16 30 (13.22%) SAS
16 30 (13.22%) DataStage
17 29 (12.78%) RDBMS
18 26 (11.45%) Oracle Database 10g
18 26 (11.45%) OLAP
18 26 (11.45%) Data Analysis
18 26 (11.45%) Analytics
19 24 (10.57%) .NET
20 23 (10.13%) IBM
21 22 (9.69%) Business Objects

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 25 July 2014, 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 30 (13.22%) SAS
2 18 (7.93%) Oracle SOA Suite
3 9 (3.96%) SharePoint
4 3 (1.32%) WebLogic
4 3 (1.32%) IIS
5 2 (0.88%) SharePoint 2010
5 2 (0.88%) SharePoint 2013
6 1 (0.44%) Mule
6 1 (0.44%) Apache
6 1 (0.44%) MTS
6 1 (0.44%) Tomcat
Applications
1 17 (7.49%) MS Excel
2 3 (1.32%) MS Office
Business Applications
1 32 (14.10%) Oracle EBS
2 5 (2.20%) Oracle Financials
2 5 (2.20%) Oracle 11i
2 5 (2.20%) Oracle General Ledger
2 5 (2.20%) Oracle EBS R12
2 5 (2.20%) Oracle Payables
2 5 (2.20%) Oracle Receivables
2 5 (2.20%) Oracle Applications
3 2 (0.88%) Google Analytics
4 1 (0.44%) HFM
4 1 (0.44%) Cognos Business Intelligence
4 1 (0.44%) Oracle ERP
Cloud Services
1 4 (1.76%) Amazon EC2
Communications & Networking
1 2 (0.88%) HTTP
2 1 (0.44%) Intranet
Database & Business Intelligence
1 49 (21.59%) Oracle Database
2 43 (18.94%) SQL Server
3 35 (15.42%) SQL Server Reporting Services
3 35 (15.42%) Relational Database
4 34 (14.98%) Oracle BI EE
5 33 (14.54%) SQL Server Integration Services
6 30 (13.22%) DataStage
7 29 (12.78%) RDBMS
8 26 (11.45%) Oracle Database 10g
8 26 (11.45%) OLAP
9 21 (9.25%) SQL Server Analysis Services
10 18 (7.93%) Oracle9i Database
10 18 (7.93%) Oracle Database 11g
11 14 (6.17%) IBM InfoSphere
12 10 (4.41%) OLTP
13 8 (3.52%) Oracle ODI
13 8 (3.52%) Big Data
13 8 (3.52%) Oracle OLAP
14 6 (2.64%) NoSQL
14 6 (2.64%) Snowflake Schema
Development Applications
1 14 (6.17%) Subversion
2 10 (4.41%) QuickTest Pro
3 7 (3.08%) ERwin
4 3 (1.32%) Oracle APEX
4 3 (1.32%) Toad
5 2 (0.88%) Jenkins
6 1 (0.44%) Selenium
6 1 (0.44%) TeamCity
6 1 (0.44%) WinRunner
6 1 (0.44%) JUnit
6 1 (0.44%) Visual Studio
6 1 (0.44%) PowerDesigner
6 1 (0.44%) Maven
6 1 (0.44%) JIRA
General
1 96 (42.29%) Finance
2 42 (18.50%) Banking
3 7 (3.08%) Retail
3 7 (3.08%) Investment Banking
4 4 (1.76%) Legal
5 3 (1.32%) Manufacturing
5 3 (1.32%) Advertising
5 3 (1.32%) Games
5 3 (1.32%) Retail Banking
5 3 (1.32%) Marketing
6 1 (0.44%) Aerospace
6 1 (0.44%) Front Office
Job Titles
1 87 (38.33%) Developer
2 50 (22.03%) Architect
3 33 (14.54%) Business Intelligence Developer
4 28 (12.33%) Analyst
5 21 (9.25%) Technical Architect
6 19 (8.37%) Implementation Manager
7 14 (6.17%) Oracle Developer
8 13 (5.73%) Business Developer
8 13 (5.73%) Data Architect
8 13 (5.73%) SQL Developer
9 12 (5.29%) DBA
10 10 (4.41%) Consultant
10 10 (4.41%) Principal Architect
11 8 (3.52%) Information Architect
12 7 (3.08%) Business Intelligence Consultant
12 7 (3.08%) Test Manager
13 6 (2.64%) Business Analyst
13 6 (2.64%) Senior Developer
13 6 (2.64%) Data Analyst
13 6 (2.64%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 24 (10.57%) .NET
2 17 (7.49%) XML
3 11 (4.85%) CSS
4 9 (3.96%) jQuery
5 8 (3.52%) ASP.NET
6 7 (3.08%) HTML
7 6 (2.64%) XSLT
7 6 (2.64%) SOAP
7 6 (2.64%) Web Services
8 5 (2.20%) Middleware
8 5 (2.20%) Oracle Fusion
9 4 (1.76%) Ajax
9 4 (1.76%) JDBC
10 3 (1.32%) ODBC
10 3 (1.32%) .NET Framework
10 3 (1.32%) WCF
11 2 (0.88%) JSON
11 2 (0.88%) ASP.NET MVC
11 2 (0.88%) OAuth
11 2 (0.88%) REST
Miscellaneous
1 11 (4.85%) Computer Science
2 7 (3.08%) Reference Data
2 7 (3.08%) Data Integration
3 5 (2.20%) Enterprise Software
3 5 (2.20%) Management Information System
4 2 (0.88%) Statistics
4 2 (0.88%) Physics
5 1 (0.44%) Client/Server
5 1 (0.44%) Data Extraction
5 1 (0.44%) Mathematics
5 1 (0.44%) Clustering
5 1 (0.44%) Economics
Operating Systems
1 42 (18.50%) UNIX
2 16 (7.05%) AIX
3 13 (5.73%) Linux
4 5 (2.20%) Windows
5 4 (1.76%) Ubuntu
Processes & Methodologies
1 145 (63.88%) Business Intelligence
2 80 (35.24%) ETL
3 43 (18.94%) Performance Tuning
4 36 (15.86%) Data Management
4 36 (15.86%) Data Modelling
5 26 (11.45%) Data Analysis
5 26 (11.45%) Analytics
6 22 (9.69%) Asset Management
7 21 (9.25%) User Acceptance Testing
7 21 (9.25%) Data Architecture
7 21 (9.25%) Information Architecture
8 20 (8.81%) TOGAF
8 20 (8.81%) SOA
9 19 (8.37%) CRM
10 18 (7.93%) Zachman Framework
11 17 (7.49%) Network Management
12 15 (6.61%) E-Commerce
13 14 (6.17%) Release Management
13 14 (6.17%) Change Data Capture
14 13 (5.73%) Data Governance
Programming Languages
1 102 (44.93%) SQL
2 34 (14.98%) PL/SQL
3 15 (6.61%) C#
4 14 (6.17%) Java
5 8 (3.52%) JavaScript
5 8 (3.52%) Perl
5 8 (3.52%) T-SQL
6 7 (3.08%) VB
7 5 (2.20%) VB.NET
8 4 (1.76%) Python
9 3 (1.32%) Shell Script
10 2 (0.88%) C
11 1 (0.44%) C++
11 1 (0.44%) PHP
11 1 (0.44%) Data Analysis Expressions (DAX)
Qualifications
1 21 (9.25%) Degree
2 3 (1.32%) Security Cleared
2 3 (1.32%) Oracle Certification
3 2 (0.88%) PMP
3 2 (0.88%) PMI Certification
3 2 (0.88%) ISEB
3 2 (0.88%) Microsoft Certification
3 2 (0.88%) OCP
3 2 (0.88%) OCA
3 2 (0.88%) MCITP
4 1 (0.44%) MCDBA
4 1 (0.44%) SC Cleared
4 1 (0.44%) MBA
Quality Assurance & Compliance
1 7 (3.08%) Data Quality
2 6 (2.64%) QA
3 5 (2.20%) Sarbanes-Oxley
4 3 (1.32%) SLA
5 1 (0.44%) Basel II
5 1 (0.44%) Solvency II
System Software
1 6 (2.64%) Oracle RAC
Systems Management
1 13 (5.73%) HP Quality Center
2 1 (0.44%) Control-M
Vendors
1 108 (47.58%) Oracle
2 45 (19.82%) Microsoft
3 37 (16.30%) Informatica
4 23 (10.13%) IBM
5 22 (9.69%) Business Objects
6 21 (9.25%) Cognos
7 14 (6.17%) SAP
8 13 (5.73%) MicroStrategy
9 7 (3.08%) Teradata
10 6 (2.64%) PeopleSoft
10 6 (2.64%) Ab Initio
11 5 (2.20%) Siebel
12 4 (1.76%) Red Hat
12 4 (1.76%) Vertica
13 3 (1.32%) Logi Analytics
13 3 (1.32%) Tableau
13 3 (1.32%) Sybase
14 2 (0.88%) HP
14 2 (0.88%) Omniture
14 2 (0.88%) Google
Glasgow
Huxley Associates
Salary: £35000 - £42000 per annum + Competitive Package
Posted: 22 hours ago
Glasgow
Hays IT - Uk Posting account
Salary: £25000.00 - £40000.00 per annum
Posted: 2 days ago
Glasgow, Lanarkshire
Harvey Nash plc
Salary: excellent benefits
Posted: 2 days ago
Livingston, West Lothian
NSK International Consultants Ltd
Salary: From £30,000 to £40,000 per annum Plus Benefits
Posted: 3 days ago
Edinburgh, Midlothian
Aridhia
Salary: Competitive
Posted: 3 days ago
Edinburgh, Midlothian
Asset Resourcing Ltd
Salary: £50000 - £65000 per annum + Bonus + Excellent Benefits Package
Posted: 5 days ago
Edinburgh
Cathcart Associates
Salary: £35000 - £45000 per annum + Excellent Benefits + Training
Posted: 9 days ago
Glasgow
Hays IT - Uk Posting account
Salary: £40000.00 - £55000.00 per annum + Benefits
Posted: 18 days ago