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

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 148 136 170
Rank change year-on-year
-12 +34
Permanent jobs citing OLAP 16 27 13
As % of all permanent IT jobs located in Scotland 0.56% 0.85% 0.34%
As % of the Database & Business Intelligence category 1.74% 2.51% 1.04%
Number of salaries quoted 11 11 6
Median salary £50,000 £42,500 £50,750
Median salary % change year-on-year
+17.64% -16.25%
UK excluding London median salary £46,750 £40,000 £42,624
% change year-on-year
+16.87% -6.15%
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
922 1074 1245
As % of all permanent IT jobs located in Scotland 32.38% 33.93% 32.89%
Number of salaries quoted 429 692 864
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £60,000 £57,500 £60,000
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 1 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 1 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 +19 11 £50,000 -4.76% 1
Glasgow -9 5 - - 2
OLAP
UK

OLAP
Top 30 Related IT Skills in Scotland

For the 6 months to 1 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 18 (78.26%) SQL
2 14 (60.87%) Business Intelligence
3 13 (56.52%) SQL Server
3 13 (56.52%) Finance
4 11 (47.83%) Retail
4 11 (47.83%) Oracle OLAP
4 11 (47.83%) Oracle
5 10 (43.48%) Data Warehouse
5 10 (43.48%) ETL
5 10 (43.48%) SAS
6 9 (39.13%) Banking
6 9 (39.13%) Base SAS
6 9 (39.13%) SAS Enterprise Guide
7 8 (34.78%) Unix
8 7 (30.43%) T-SQL
8 7 (30.43%) OLTP
9 6 (26.09%) Linux
9 6 (26.09%) Agile Software Development
9 6 (26.09%) Games
9 6 (26.09%) Software Engineering
9 6 (26.09%) Big Data
10 5 (21.74%) REST
10 5 (21.74%) Data Governance
10 5 (21.74%) HBase
10 5 (21.74%) Data Architecture
10 5 (21.74%) Hadoop
10 5 (21.74%) Apache Hive
10 5 (21.74%) Logical Data Model
10 5 (21.74%) Physical Data Model
10 5 (21.74%) Kanban

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 10 (43.48%) SAS
2 4 (17.39%) SharePoint
3 1 (4.35%) SharePoint 2010
3 1 (4.35%) SharePoint 2013
Applications
1 5 (21.74%) MS Excel
2 3 (13.04%) MS Office
Database & Business Intelligence
1 13 (56.52%) SQL Server
2 11 (47.83%) Oracle OLAP
3 10 (43.48%) Data Warehouse
4 9 (39.13%) Base SAS
4 9 (39.13%) SAS Enterprise Guide
5 7 (30.43%) OLTP
6 6 (26.09%) Big Data
7 5 (21.74%) Apache Hive
7 5 (21.74%) Hadoop
7 5 (21.74%) HBase
7 5 (21.74%) SAS EBI
7 5 (21.74%) SQL Server Integration Services
8 4 (17.39%) SQL Server Analysis Services
8 4 (17.39%) SQL Server Reporting Services
9 3 (13.04%) QlikView
9 3 (13.04%) SQL Server 2005
9 3 (13.04%) SQL Server 2016
10 2 (8.70%) Data Mining
10 2 (8.70%) DTS
10 2 (8.70%) SAS Data Integration Studio
Development Applications
1 1 (4.35%) Git (software)
1 1 (4.35%) SQL Server Management Studio (SSMS)
General
1 13 (56.52%) Finance
2 11 (47.83%) Retail
3 9 (39.13%) Banking
4 6 (26.09%) Games
5 5 (21.74%) Manufacturing
5 5 (21.74%) Telecoms
6 3 (13.04%) Marketing
Job Titles
1 8 (34.78%) Consultant
1 8 (34.78%) SAS Consultant
2 5 (21.74%) Architect
2 5 (21.74%) Business Intelligence Consultant
2 5 (21.74%) Data Architect
2 5 (21.74%) Developer
2 5 (21.74%) SAS BI Consultant
3 3 (13.04%) Business Intelligence Developer
4 2 (8.70%) DBA
4 2 (8.70%) SQL DBA
4 2 (8.70%) SQL Developer
5 1 (4.35%) Development DBA
5 1 (4.35%) Junior
5 1 (4.35%) Junior Business Intelligence Developer
5 1 (4.35%) Junior Developer
5 1 (4.35%) Senior Software Engineer
5 1 (4.35%) Software Engineer
5 1 (4.35%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 5 (21.74%) REST
2 2 (8.70%) COM
3 1 (4.35%) .NET
3 1 (4.35%) MDX
Miscellaneous
1 2 (8.70%) Clustering
2 1 (4.35%) Analytical Skills
2 1 (4.35%) Computer Science
2 1 (4.35%) Data Integration
2 1 (4.35%) Replication
2 1 (4.35%) Visualisation
Operating Systems
1 8 (34.78%) Unix
2 6 (26.09%) Linux
3 5 (21.74%) Windows
Processes & Methodologies
1 14 (60.87%) Business Intelligence
2 10 (43.48%) ETL
3 6 (26.09%) Agile Software Development
3 6 (26.09%) Software Engineering
4 5 (21.74%) Business Analysis
4 5 (21.74%) Data Architecture
4 5 (21.74%) Data Governance
4 5 (21.74%) Data Modelling
4 5 (21.74%) Kanban
4 5 (21.74%) Logical Data Model
4 5 (21.74%) Physical Data Model
4 5 (21.74%) Project Management
4 5 (21.74%) Scrum
5 3 (13.04%) ETL Development
6 2 (8.70%) Dashboard Development
6 2 (8.70%) E-Commerce
6 2 (8.70%) Performance Tuning
7 1 (4.35%) Data Mapping
7 1 (4.35%) Inmon Methodology
7 1 (4.35%) Kimball Methodology
Programming Languages
1 18 (78.26%) SQL
2 7 (30.43%) T-SQL
3 5 (21.74%) Perl
3 5 (21.74%) Shell Script
4 2 (8.70%) SAS Macro
5 1 (4.35%) C#
5 1 (4.35%) Java
5 1 (4.35%) VB.NET
5 1 (4.35%) VBA
Qualifications
1 1 (4.35%) Degree
Vendors
1 11 (47.83%) Oracle
2 5 (21.74%) Informatica
2 5 (21.74%) Microsoft
3 1 (4.35%) Cognizant
3 1 (4.35%) Vertica
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent salary, bonus and benefits
Posted: 2 days ago
Glasgow, Lanarkshire
Net Talent
Posted: 3 days ago
Edinburgh
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + pension, bonus, health care
Posted: 14 days ago