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

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Data Warehousing
Rank 67 79 40
Rank change year-on-year
+12 -39
Permanent jobs citing Data Warehouse 106 101 153
As % of all permanent IT jobs located in Scotland 3.35% 2.75% 4.70%
As % of the Database & Business Intelligence category 10.10% 8.67% 12.96%
Number of salaries quoted 78 74 91
Average salary £46,750 £45,000 £50,000
Average salary % change year-on-year
+3.88% -10.00%
90% offered a salary of more than £32,500 £32,500 £34,000
10% offered a salary of more than £62,250 £60,000 £60,000
UK excluding London average salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
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
1050 1165 1181
As % of all permanent IT jobs located in Scotland 33.16% 31.67% 36.28%
Number of salaries quoted 679 778 784
Average salary £43,500 £42,500 £41,000
Average salary % change year-on-year
+2.35% +3.65%
90% offered a salary of more than £30,000 £30,000 £29,000
10% offered a salary of more than £65,000 £55,500 £57,500
UK excluding London average salary £42,500 £40,000 £39,000
% change year-on-year
+6.25% +2.56%

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 31 July 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 31 July 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 +39 67 £44,500 +4.70% 4
Edinburgh -17 35 £50,000 +5.26% 9
Aberdeen +17 2 £35,000 -
Inverclyde - 2 £38,750 -
Stirling -6 1 £50,000 +11.11%
Renfrewshire - 1 £40,000 - 1
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 31 July 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 138 (63.89%) SQL
2 128 (59.26%) Business Intelligence
3 112 (51.85%) Finance
4 92 (42.59%) ETL
5 77 (35.65%) Oracle
6 70 (32.41%) Agile Software Development
7 55 (25.46%) BusinessObjects
7 55 (25.46%) SQL Server
8 53 (24.54%) Data Modelling
8 53 (24.54%) Analytical Skills
9 47 (21.76%) Data Management
10 42 (19.44%) SAS
11 41 (18.98%) SQL Server Integration Services
12 40 (18.52%) Microsoft
13 38 (17.59%) Waterfall
14 37 (17.13%) Informatica
15 36 (16.67%) Big Data
16 35 (16.20%) Banking
17 34 (15.74%) PL/SQL
17 34 (15.74%) Software Delivery
18 33 (15.28%) SQL Server Reporting Services
19 31 (14.35%) Analytics
20 28 (12.96%) Stakeholder Management
20 28 (12.96%) T-SQL
21 27 (12.50%) Data Analysis
22 25 (11.57%) SQL Server Analysis Services
22 25 (11.57%) UNIX
22 25 (11.57%) Logical Data Model
23 24 (11.11%) Master Data Management
24 23 (10.65%) SAP

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 31 July 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 42 (19.44%) SAS
2 10 (4.63%) Apache Pig
3 4 (1.85%) SharePoint
4 3 (1.39%) Tomcat
4 3 (1.39%) AquaLogic
5 2 (0.93%) SharePoint 2010
5 2 (0.93%) JBoss
5 2 (0.93%) PowerExchange
5 2 (0.93%) Oracle Application Server
5 2 (0.93%) SharePoint 2013
5 2 (0.93%) Apache Spark
6 1 (0.46%) Lync
6 1 (0.46%) WebSphere
Applications
1 20 (9.26%) MS Excel
2 1 (0.46%) MS Visio
2 1 (0.46%) MS Office
Business Applications
1 8 (3.70%) Markit EDM
2 5 (2.31%) thinkFolio
3 3 (1.39%) Oracle BPM
3 3 (1.39%) AquaLogic BPM
3 3 (1.39%) Cognos TM1
3 3 (1.39%) PRMS
4 2 (0.93%) Oracle Financials
5 1 (0.46%) Oracle 11i
5 1 (0.46%) Oracle EBS
Cloud Services
1 5 (2.31%) Microsoft Azure
2 2 (0.93%) SaaS
3 1 (0.46%) Office 365
3 1 (0.46%) Amazon AWS
3 1 (0.46%) Amazon EC2
Communications & Networking
1 2 (0.93%) Internet
Database & Business Intelligence
1 55 (25.46%) SQL Server
1 55 (25.46%) BusinessObjects
2 41 (18.98%) SQL Server Integration Services
3 36 (16.67%) Big Data
4 33 (15.28%) SQL Server Reporting Services
5 25 (11.57%) SQL Server Analysis Services
6 20 (9.26%) Relational Database
7 18 (8.33%) Oracle Database
8 17 (7.87%) Enterprise Data Warehouse
8 17 (7.87%) Oracle BI EE
9 16 (7.41%) DataStage
10 14 (6.48%) QlikView
11 13 (6.02%) Data Mart
11 13 (6.02%) Data Mining
11 13 (6.02%) RDBMS
12 11 (5.09%) Hadoop
13 10 (4.63%) Apache Hive
13 10 (4.63%) HBase
14 9 (4.17%) SQL Server 2012
15 8 (3.70%) NoSQL
Development Applications
1 4 (1.85%) FitNesse
1 4 (1.85%) Talend Open Studio
2 3 (1.39%) HP UFT
2 3 (1.39%) XMLUnit
2 3 (1.39%) Ant
2 3 (1.39%) JUnit
2 3 (1.39%) Subversion
2 3 (1.39%) Maven
2 3 (1.39%) JIRA
3 2 (0.93%) SQL Server Management Studio (SSMS)
3 2 (0.93%) Git (software)
4 1 (0.46%) Team Foundation Server
4 1 (0.46%) LoadRunner
4 1 (0.46%) Selenium
4 1 (0.46%) Oracle Forms
4 1 (0.46%) ClearCase
General
1 112 (51.85%) Finance
2 35 (16.20%) Banking
3 13 (6.02%) Marketing
4 10 (4.63%) Retail
5 3 (1.39%) Advertising
5 3 (1.39%) Telecoms
6 2 (0.93%) Dutch Language
6 2 (0.93%) French Language
6 2 (0.93%) Investment Banking
6 2 (0.93%) Retail Banking
7 1 (0.46%) Manufacturing
7 1 (0.46%) Financial Institution
7 1 (0.46%) Back Office
7 1 (0.46%) German Language
7 1 (0.46%) Spanish Language
7 1 (0.46%) Publishing
Job Titles
1 58 (26.85%) Developer
2 57 (26.39%) Analyst
3 31 (14.35%) Business Analyst
4 25 (11.57%) Architect
4 25 (11.57%) Senior Analyst
5 22 (10.19%) Consultant
6 20 (9.26%) Data Architect
7 19 (8.80%) Data Warehouse Developer
8 18 (8.33%) Senior Business Analyst
9 17 (7.87%) Business Intelligence Developer
10 15 (6.94%) Senior Developer
11 13 (6.02%) Designer
12 11 (5.09%) Systems Analyst
13 10 (4.63%) SQL Developer
14 8 (3.70%) Senior Systems Analyst
14 8 (3.70%) Data Analyst
14 8 (3.70%) Test Leader
15 7 (3.24%) Senior Designer
15 7 (3.24%) Business Intelligence Consultant
15 7 (3.24%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 14 (6.48%) .NET
2 10 (4.63%) Web Services
3 6 (2.78%) XML
4 5 (2.31%) ASP.NET
5 4 (1.85%) HTML
5 4 (1.85%) Spring
5 4 (1.85%) D3.js
5 4 (1.85%) AngularJS
6 3 (1.39%) ASP.NET MVC
6 3 (1.39%) Ajax
6 3 (1.39%) MDX
6 3 (1.39%) Apache Flex
6 3 (1.39%) J2EE
7 2 (0.93%) SOAP
7 2 (0.93%) JMS
7 2 (0.93%) OC4J
8 1 (0.46%) REST
8 1 (0.46%) Spring Integration
8 1 (0.46%) ASP.NET Web Forms
8 1 (0.46%) Middleware
Miscellaneous
1 53 (24.54%) Analytical Skills
2 22 (10.19%) Data Integration
3 11 (5.09%) Management Information System
4 7 (3.24%) Visualisation
5 4 (1.85%) Computer Science
5 4 (1.85%) Statistics
5 4 (1.85%) Mathematics
6 3 (1.39%) Physics
6 3 (1.39%) Enterprise Software
7 2 (0.93%) Mainframe
7 2 (0.93%) Data Extraction
8 1 (0.46%) Credit Risk
8 1 (0.46%) Reference Data
8 1 (0.46%) User Experience
8 1 (0.46%) Taxonomies
8 1 (0.46%) Economics
8 1 (0.46%) Client/Server
8 1 (0.46%) N-Tier
8 1 (0.46%) Data Structures
Operating Systems
1 25 (11.57%) UNIX
2 7 (3.24%) Linux
3 2 (0.93%) Tru64
3 2 (0.93%) AIX
4 1 (0.46%) Windows Server 2008
4 1 (0.46%) Windows
Processes & Methodologies
1 128 (59.26%) Business Intelligence
2 92 (42.59%) ETL
3 70 (32.41%) Agile Software Development
4 53 (24.54%) Data Modelling
5 47 (21.76%) Data Management
6 38 (17.59%) Waterfall
7 34 (15.74%) Software Delivery
8 31 (14.35%) Analytics
9 28 (12.96%) Stakeholder Management
10 27 (12.50%) Data Analysis
11 25 (11.57%) Logical Data Model
12 24 (11.11%) Master Data Management
13 19 (8.80%) SDLC
14 18 (8.33%) Dimensional Modelling
15 17 (7.87%) Time Management
15 17 (7.87%) Metadata Management
16 16 (7.41%) Data Mapping
16 16 (7.41%) Quality Management
17 15 (6.94%) Business Analysis
17 15 (6.94%) Scrum
Programming Languages
1 138 (63.89%) SQL
2 34 (15.74%) PL/SQL
3 28 (12.96%) T-SQL
4 16 (7.41%) Java
5 8 (3.70%) JavaScript
6 7 (3.24%) C#
6 7 (3.24%) VB.NET
7 5 (2.31%) VBA
7 5 (2.31%) Shell Script
8 4 (1.85%) Python
9 3 (1.39%) Perl
10 2 (0.93%) Scala
10 2 (0.93%) R
11 1 (0.46%) ABAP
Qualifications
1 16 (7.41%) Degree
2 9 (4.17%) ISEB
3 5 (2.31%) Security Cleared
4 4 (1.85%) PRINCE2 Practitioner
5 2 (0.93%) ISTQB
6 1 (0.46%) ISTQB Foundation Certification
6 1 (0.46%) ISEB Practitioner
Quality Assurance & Compliance
1 14 (6.48%) QA
2 5 (2.31%) Data Quality
3 3 (1.39%) Basel II
3 3 (1.39%) Solvency II
System Software
1 8 (3.70%) Apache Flume
2 2 (0.93%) Oracle RAC
Systems Management
1 6 (2.78%) MOM
2 2 (0.93%) Oracle RMAN
3 1 (0.46%) Data Guard
3 1 (0.46%) HP Quality Center
Vendors
1 77 (35.65%) Oracle
2 40 (18.52%) Microsoft
3 37 (17.13%) Informatica
4 23 (10.65%) SAP
5 22 (10.19%) Cognos
6 13 (6.02%) Teradata
7 11 (5.09%) MicroStrategy
8 10 (4.63%) IBM
9 4 (1.85%) Vertica
9 4 (1.85%) Talend
10 3 (1.39%) Siebel
10 3 (1.39%) Sybase
11 2 (0.93%) PeopleSoft
11 2 (0.93%) Hortonworks
11 2 (0.93%) Cloudera
11 2 (0.93%) MapR
11 2 (0.93%) Charles River
12 1 (0.46%) Netezza
12 1 (0.46%) Greenplum
12 1 (0.46%) Remedy
Edinburgh, Midlothian
Head Resourcing
Salary: £50000.00 - £56000.00 per annum + Excellent Benefits
Posted: Yesterday
Edinburgh, Midlothian
Evolution Recruitment Solutions
Salary: 30k - 35k + bonus and benefits
Posted: 2 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40k - £60k plus attractive benefits
Posted: 2 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 2 days ago
Edinburgh, Midlothian
Eutopia Solutions Ltd
Salary: £50000 - £65000 per annum
Posted: 3 days ago
Glasgow, Lanarkshire
Lawrence Harvey Enterprise
Salary: £50000.00 - £65000.00 per annum + benefits + bonus
Posted: 3 days ago
Edinburgh, Midlothian
Harvey Nash plc
Posted: 4 days ago
Edinburgh, Midlothian
Montash
Salary: £75000 - £90000 per annum + benefits + bonus
Posted: 4 days ago
Paisley
Noir Consulting
Salary: £30000 - £50000 per annum + Bonus + Pension + Benefits
Posted: 4 days ago
Edinburgh, Midlothian
Westbourne Partners
Salary: From £50,000 to £55,000 per annum
Posted: 6 days ago
Glasgow
Hays IT - Uk Posting account
Posted: 22 days ago