The table below looks at the statistics for OLAP skills in IT jobs advertised for the Scotland region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 28 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
28 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 130 163 175
Rank change year-on-year
+33 +12
Permanent jobs citing OLAP 15 14 5
As % of all permanent IT jobs located in Scotland 0.60% 0.42% 0.14%
As % of the Database & Business Intelligence category 1.84% 1.35% 0.44%
Number of salaries quoted 13 3 2
Median salary £55,000 £47,500 £80,000
Median salary % change year-on-year
+15.78% -40.62%
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
OLAP
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
815 1038 1133
As % of all permanent IT jobs located in Scotland 32.38% 31.09% 31.75%
Number of salaries quoted 506 678 733
Median salary £42,500 £43,553 £40,000
Median salary % change year-on-year
-2.41% +8.88%
90% offered a salary of more than £30,000 £32,000 £30,000
10% offered a salary of more than £60,000 £55,000 £65,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

OLAP
Jobs Demand Trend in Scotland

The demand trend of job ads across the Scotland region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Scotland

OLAP
Salary Trend in Scotland

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the Scotland region.

OLAP Salary Trend in Scotland

OLAP
Salary Histogram in Scotland

This chart provides a salary histogram for IT jobs citing OLAP across the Scotland region over the 3 months to 28 September 2016.

OLAP Salary Histogram in Scotland

OLAP
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Scotland region over the 3 months to 28 September 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +31 12 £55,000 +15.78%
Glasgow +12 2 - -
Aberdeen - 1 £47,500 -
OLAP
UK

OLAP
Top 30 Related IT Skills in Scotland

For the 6 months to 28 September 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Scotland region with a requirement for OLAP.

1 20 (66.67%) Data Warehouse
1 20 (66.67%) ETL
1 20 (66.67%) Finance
2 18 (60.00%) SQL
3 17 (56.67%) Oracle
3 17 (56.67%) Retail
3 17 (56.67%) Oracle OLAP
4 16 (53.33%) SQL Server
4 16 (53.33%) Data Modelling
5 14 (46.67%) Business Intelligence
6 13 (43.33%) Data Architecture
7 12 (40.00%) Hadoop
7 12 (40.00%) Apache Hive
7 12 (40.00%) REST
7 12 (40.00%) Kanban
7 12 (40.00%) Data Governance
7 12 (40.00%) HBase
7 12 (40.00%) Big Data
7 12 (40.00%) Logical Data Model
7 12 (40.00%) Physical Data Model
7 12 (40.00%) Informatica
7 12 (40.00%) Shell Script
7 12 (40.00%) Perl
7 12 (40.00%) Software Engineering
7 12 (40.00%) Agile Software Development
7 12 (40.00%) Telecoms
7 12 (40.00%) Games
7 12 (40.00%) Scrum
8 9 (30.00%) Microsoft
9 8 (26.67%) Banking

OLAP
Top Related IT Skills in Scotland by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 7 (23.33%) SAS
2 3 (10.00%) SharePoint
Applications
1 7 (23.33%) MS Excel
2 3 (10.00%) MS Office
Database & Business Intelligence
1 20 (66.67%) Data Warehouse
2 17 (56.67%) Oracle OLAP
3 16 (53.33%) SQL Server
4 12 (40.00%) Apache Hive
4 12 (40.00%) Big Data
4 12 (40.00%) Hadoop
4 12 (40.00%) HBase
5 8 (26.67%) SQL Server Integration Services
6 7 (23.33%) Base SAS
6 7 (23.33%) OLTP
6 7 (23.33%) SAS Enterprise Guide
6 7 (23.33%) SQL Server Reporting Services
7 6 (20.00%) QlikView
7 6 (20.00%) SQL Server Analysis Services
8 5 (16.67%) SAS EBI
8 5 (16.67%) SQL Server 2005
9 3 (10.00%) Power BI
9 3 (10.00%) Relational Database
9 3 (10.00%) SQL Server 2016
10 2 (6.67%) SAS Data Integration Studio
General
1 20 (66.67%) Finance
2 17 (56.67%) Retail
3 12 (40.00%) Games
3 12 (40.00%) Telecoms
4 8 (26.67%) Banking
5 5 (16.67%) Manufacturing
6 3 (10.00%) Marketing
Job Titles
1 12 (40.00%) Architect
1 12 (40.00%) Data Architect
2 6 (20.00%) Developer
3 5 (16.67%) Business Intelligence Consultant
3 5 (16.67%) Consultant
3 5 (16.67%) SAS BI Consultant
3 5 (16.67%) SAS Consultant
4 4 (13.33%) Hadoop Architect
4 4 (13.33%) SQL Developer
5 3 (10.00%) SQL Server Developer
5 3 (10.00%) Technical Leader
6 2 (6.67%) Business Intelligence Developer
6 2 (6.67%) Senior Developer
6 2 (6.67%) Senior SQL Developer
6 2 (6.67%) Senior SQL Server Developer
7 1 (3.33%) Analyst
7 1 (3.33%) Business Intelligence Analyst
7 1 (3.33%) DBA
7 1 (3.33%) Junior Developer
7 1 (3.33%) SQL DBA
Libraries, Frameworks & Software Standards
1 12 (40.00%) REST
2 4 (13.33%) MDX
3 2 (6.67%) COM
4 1 (3.33%) .NET
Miscellaneous
1 1 (3.33%) Clustering
1 1 (3.33%) Computer Science
1 1 (3.33%) Data Integration
1 1 (3.33%) Replication
Operating Systems
1 5 (16.67%) Linux
1 5 (16.67%) Unix
1 5 (16.67%) Windows
Processes & Methodologies
1 20 (66.67%) ETL
2 16 (53.33%) Data Modelling
3 14 (46.67%) Business Intelligence
4 13 (43.33%) Data Architecture
5 12 (40.00%) Agile Software Development
5 12 (40.00%) Data Governance
5 12 (40.00%) Kanban
5 12 (40.00%) Logical Data Model
5 12 (40.00%) Physical Data Model
5 12 (40.00%) Scrum
5 12 (40.00%) Software Engineering
6 5 (16.67%) Business Analysis
6 5 (16.67%) Mentoring
6 5 (16.67%) Project Management
7 3 (10.00%) Data Mapping
7 3 (10.00%) Data Transformation
8 2 (6.67%) Dashboard Development
8 2 (6.67%) E-Commerce
8 2 (6.67%) ETL Development
8 2 (6.67%) Performance Tuning
Programming Languages
1 18 (60.00%) SQL
2 12 (40.00%) Perl
2 12 (40.00%) Shell Script
3 7 (23.33%) T-SQL
4 2 (6.67%) SAS Macro
5 1 (3.33%) C#
5 1 (3.33%) VB.NET
Qualifications
1 1 (3.33%) Degree
Vendors
1 17 (56.67%) Oracle
2 12 (40.00%) Informatica
3 9 (30.00%) Microsoft
4 3 (10.00%) Tableau
5 1 (3.33%) Cognizant