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

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 138 137 173
Rank change year-on-year
-1 +36
Permanent jobs citing OLAP 23 26 8
As % of all permanent IT jobs located in Scotland 0.80% 0.82% 0.22%
As % of the Database & Business Intelligence category 2.42% 2.40% 0.67%
Number of salaries quoted 17 7 3
Median salary £55,000 £42,500 £35,000
Median salary % change year-on-year
+29.41% +21.42%
90% offered a salary of more than £45,500 £37,000 £31,000
10% offered a salary of more than £65,000 £49,500 £52,200
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
951 1084 1192
As % of all permanent IT jobs located in Scotland 32.98% 34.14% 32.46%
Number of salaries quoted 477 705 804
Median salary £45,000 £43,500 £42,500
Median salary % change year-on-year
+3.44% +2.35%
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £60,000 £57,500 £65,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 27 July 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 27 July 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 +20 16 £55,000 +4.76%
Glasgow -14 6 - - 1
Aberdeen -1 1 £47,500 +46.15%
OLAP
UK

OLAP
Top 30 Related IT Skills in Scotland

For the 6 months to 27 July 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 (70.97%) SQL
2 20 (64.52%) Finance
3 18 (58.06%) Business Intelligence
4 17 (54.84%) ETL
4 17 (54.84%) Data Warehouse
5 16 (51.61%) SQL Server
6 14 (45.16%) Oracle
6 14 (45.16%) Retail
6 14 (45.16%) Oracle OLAP
7 13 (41.94%) Data Modelling
8 11 (35.48%) SAS
9 10 (32.26%) Base SAS
9 10 (32.26%) SAS Enterprise Guide
9 10 (32.26%) Data Architecture
10 9 (29.03%) Hadoop
10 9 (29.03%) Apache Hive
10 9 (29.03%) REST
10 9 (29.03%) Data Governance
10 9 (29.03%) HBase
10 9 (29.03%) Big Data
10 9 (29.03%) Kanban
10 9 (29.03%) Logical Data Model
10 9 (29.03%) Physical Data Model
10 9 (29.03%) Microsoft
10 9 (29.03%) Informatica
10 9 (29.03%) Shell Script
10 9 (29.03%) Perl
10 9 (29.03%) Software Engineering
10 9 (29.03%) Agile Software Development
10 9 (29.03%) 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 11 (35.48%) SAS
2 3 (9.68%) SharePoint
Applications
1 7 (22.58%) MS Excel
2 3 (9.68%) MS Office
Database & Business Intelligence
1 17 (54.84%) Data Warehouse
2 16 (51.61%) SQL Server
3 14 (45.16%) Oracle OLAP
4 10 (32.26%) Base SAS
4 10 (32.26%) SAS Enterprise Guide
5 9 (29.03%) Apache Hive
5 9 (29.03%) Big Data
5 9 (29.03%) Hadoop
5 9 (29.03%) HBase
6 8 (25.81%) SQL Server Integration Services
7 7 (22.58%) OLTP
7 7 (22.58%) SQL Server Reporting Services
8 6 (19.35%) QlikView
8 6 (19.35%) SQL Server Analysis Services
9 5 (16.13%) SAS EBI
9 5 (16.13%) SQL Server 2005
10 3 (9.68%) Power BI
10 3 (9.68%) Relational Database
10 3 (9.68%) SAS Data Integration Studio
10 3 (9.68%) SQL Server 2016
General
1 20 (64.52%) Finance
2 14 (45.16%) Retail
3 9 (29.03%) Banking
3 9 (29.03%) Games
3 9 (29.03%) Telecoms
4 5 (16.13%) Manufacturing
5 3 (9.68%) Marketing
Job Titles
1 9 (29.03%) Architect
1 9 (29.03%) Data Architect
2 8 (25.81%) Consultant
2 8 (25.81%) SAS Consultant
3 5 (16.13%) Business Intelligence Consultant
3 5 (16.13%) Developer
3 5 (16.13%) SAS BI Consultant
4 3 (9.68%) Hadoop Architect
4 3 (9.68%) SQL Developer
4 3 (9.68%) Technical Leader
5 2 (6.45%) Business Intelligence Developer
5 2 (6.45%) DBA
5 2 (6.45%) SQL DBA
5 2 (6.45%) SQL Server Developer
6 1 (3.23%) Analyst
6 1 (3.23%) Business Intelligence Analyst
6 1 (3.23%) Junior
6 1 (3.23%) Junior Developer
6 1 (3.23%) Senior Developer
6 1 (3.23%) Senior SQL Server Developer
Libraries, Frameworks & Software Standards
1 9 (29.03%) REST
2 4 (12.90%) MDX
3 2 (6.45%) COM
4 1 (3.23%) .NET
Miscellaneous
1 2 (6.45%) Clustering
2 1 (3.23%) Computer Science
2 1 (3.23%) Data Integration
2 1 (3.23%) Replication
Operating Systems
1 8 (25.81%) Unix
2 5 (16.13%) Linux
2 5 (16.13%) Windows
Processes & Methodologies
1 18 (58.06%) Business Intelligence
2 17 (54.84%) ETL
3 13 (41.94%) Data Modelling
4 10 (32.26%) Data Architecture
5 9 (29.03%) Agile Software Development
5 9 (29.03%) Data Governance
5 9 (29.03%) Kanban
5 9 (29.03%) Logical Data Model
5 9 (29.03%) Physical Data Model
5 9 (29.03%) Scrum
5 9 (29.03%) Software Engineering
6 5 (16.13%) Business Analysis
6 5 (16.13%) Project Management
7 4 (12.90%) Mentoring
8 3 (9.68%) Dashboard Development
8 3 (9.68%) Data Transformation
9 2 (6.45%) Data Mapping
9 2 (6.45%) E-Commerce
9 2 (6.45%) ETL Development
9 2 (6.45%) Performance Tuning
Programming Languages
1 22 (70.97%) SQL
2 9 (29.03%) Perl
2 9 (29.03%) Shell Script
3 7 (22.58%) T-SQL
4 3 (9.68%) SAS Macro
5 1 (3.23%) C#
5 1 (3.23%) VB.NET
Qualifications
1 1 (3.23%) Degree
Vendors
1 14 (45.16%) Oracle
2 9 (29.03%) Informatica
2 9 (29.03%) Microsoft
3 3 (9.68%) Tableau
4 1 (3.23%) Cognizant
Glasgow
Vivid Resourcing
Posted: 7 days ago