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 29 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 147 140 161
Rank change year-on-year
-7 +21
Permanent jobs citing OLAP 12 20 18
As % of all permanent IT jobs located in Scotland 0.43% 0.65% 0.46%
As % of the Database & Business Intelligence category 1.32% 2.00% 1.45%
Number of salaries quoted 9 9 8
Median salary £50,000 £42,500 £53,250
Median salary % change year-on-year
+17.64% -20.18%
90% offered a salary of more than £44,500 £39,500 £42,000
10% offered a salary of more than £51,000 £50,500 £62,050
UK excluding London median salary £45,500 £40,000 £42,500
% change year-on-year
+13.75% -5.88%
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
907 1001 1240
As % of all permanent IT jobs located in Scotland 32.23% 32.37% 32.02%
Number of salaries quoted 461 632 861
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £32,000 £32,500 £30,000
10% offered a salary of more than £60,000 £55,000 £57,500
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 29 May 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 29 May 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 +14 9 £50,000 -4.76% 2
Glasgow -15 3 - - 3
OLAP
UK

OLAP
Top 30 Related IT Skills in Scotland

For the 6 months to 29 May 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 22 (95.65%) SQL
2 16 (69.57%) Business Intelligence
3 15 (65.22%) SQL Server
4 12 (52.17%) SAS
5 11 (47.83%) Base SAS
5 11 (47.83%) SAS Enterprise Guide
6 10 (43.48%) Oracle
6 10 (43.48%) Oracle OLAP
7 9 (39.13%) Finance
7 9 (39.13%) Linux
8 8 (34.78%) Unix
8 8 (34.78%) OLTP
8 8 (34.78%) Banking
9 7 (30.43%) Retail
10 6 (26.09%) Data Warehouse
10 6 (26.09%) ETL
10 6 (26.09%) T-SQL
11 5 (21.74%) Windows
11 5 (21.74%) MS Excel
11 5 (21.74%) Project Management
11 5 (21.74%) Manufacturing
11 5 (21.74%) Games
11 5 (21.74%) Business Analysis
11 5 (21.74%) SQL Server Integration Services
11 5 (21.74%) Big Data
11 5 (21.74%) SAS EBI
12 4 (17.39%) Dashboard Development
12 4 (17.39%) Vertica
12 4 (17.39%) NewSQL
12 4 (17.39%) Relational Database

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 12 (52.17%) SAS
2 4 (17.39%) SharePoint
3 2 (8.70%) SharePoint 2010
3 2 (8.70%) SharePoint 2013
Applications
1 5 (21.74%) MS Excel
2 2 (8.70%) MS Office
Database & Business Intelligence
1 15 (65.22%) SQL Server
2 11 (47.83%) Base SAS
2 11 (47.83%) SAS Enterprise Guide
3 10 (43.48%) Oracle OLAP
4 8 (34.78%) OLTP
5 6 (26.09%) Data Warehouse
6 5 (21.74%) Big Data
6 5 (21.74%) SAS EBI
6 5 (21.74%) SQL Server Integration Services
7 4 (17.39%) Amazon Redshift
7 4 (17.39%) Apache Cassandra
7 4 (17.39%) MongoDB
7 4 (17.39%) NewSQL
7 4 (17.39%) NoSQL
7 4 (17.39%) PostgreSQL
7 4 (17.39%) Relational Database
7 4 (17.39%) SAS Data Integration Studio
7 4 (17.39%) SQL Server Analysis Services
7 4 (17.39%) SQL Server Reporting Services
7 4 (17.39%) VoltDB
Development Applications
1 2 (8.70%) Git (software)
1 2 (8.70%) SQL Server Management Studio (SSMS)
General
1 9 (39.13%) Finance
2 8 (34.78%) Banking
3 7 (30.43%) Retail
4 5 (21.74%) Games
4 5 (21.74%) Manufacturing
5 2 (8.70%) Marketing
6 1 (4.35%) Telecoms
Job Titles
1 8 (34.78%) Consultant
1 8 (34.78%) SAS Consultant
2 6 (26.09%) Developer
3 5 (21.74%) Business Intelligence Consultant
3 5 (21.74%) SAS BI Consultant
4 3 (13.04%) Business Intelligence Developer
4 3 (13.04%) Senior Software Engineer
4 3 (13.04%) Software Engineer
5 2 (8.70%) DBA
5 2 (8.70%) SQL Developer
6 1 (4.35%) Administrator
6 1 (4.35%) Architect
6 1 (4.35%) Data Architect
6 1 (4.35%) Database Developer
6 1 (4.35%) SQL DBA
6 1 (4.35%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 2 (8.70%) MDX
2 1 (4.35%) .NET
2 1 (4.35%) COM
2 1 (4.35%) JDBC
2 1 (4.35%) REST
Miscellaneous
1 2 (8.70%) Analytical Skills
1 2 (8.70%) Data Integration
1 2 (8.70%) Visualisation
2 1 (4.35%) Clustering
Operating Systems
1 9 (39.13%) Linux
2 8 (34.78%) Unix
3 5 (21.74%) Windows
Processes & Methodologies
1 16 (69.57%) Business Intelligence
2 6 (26.09%) ETL
3 5 (21.74%) Business Analysis
3 5 (21.74%) Project Management
4 4 (17.39%) Dashboard Development
4 4 (17.39%) Software Engineering
5 3 (13.04%) Agile Software Development
5 3 (13.04%) ETL Development
5 3 (13.04%) Multithreading
6 2 (8.70%) Data Visualisation
6 2 (8.70%) Inmon Methodology
6 2 (8.70%) Kimball Methodology
6 2 (8.70%) Web Development
7 1 (4.35%) Data Architecture
7 1 (4.35%) Data Governance
7 1 (4.35%) Data Mapping
7 1 (4.35%) Logical Data Model
7 1 (4.35%) Performance Tuning
7 1 (4.35%) Physical Data Model
7 1 (4.35%) Reverse Engineering
Programming Languages
1 22 (95.65%) SQL
2 6 (26.09%) T-SQL
3 4 (17.39%) Java
3 4 (17.39%) SAS Macro
4 2 (8.70%) VBA
5 1 (4.35%) C#
5 1 (4.35%) Perl
5 1 (4.35%) Shell Script
5 1 (4.35%) VB.NET
Vendors
1 10 (43.48%) Oracle
2 4 (17.39%) Vertica
3 3 (13.04%) Microsoft
4 1 (4.35%) Informatica
Glasgow, Lanarkshire
Cognizant
Posted: 6 days ago
Edinburgh
Churchill Frank International
Salary: £40000 - £45000 per annum + Negotiable
Posted: 18 days ago
Glasgow
Vivid Resourcing
Posted: 26 days ago