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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 79 102 110
Rank change year-on-year
+23 +8
Permanent jobs citing OLAP 12 1 3
As % of all permanent IT jobs located in Edinburgh 1.06% 0.064% 0.20%
As % of the Database & Business Intelligence category 3.70% 0.22% 0.71%
Number of salaries quoted 12 1 2
Median salary £55,000 £47,500 £80,000
Median salary % change year-on-year
+15.78% -40.62%
UK excluding London median salary £48,750 £42,500 £42,500
% change year-on-year
+14.70% -
OLAP
Scotland

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 Edinburgh region.

Database & Business Intelligence Category
Edinburgh
Permanent IT job ads with a match in the
Database & Business Intelligence category
324 452 422
As % of all permanent IT jobs located in Edinburgh 28.57% 28.73% 28.30%
Number of salaries quoted 255 300 316
Median salary £45,000 £44,000 £40,000
Median salary % change year-on-year
+2.27% +10.00%
90% offered a salary of more than £33,100 £30,000 £30,000
10% offered a salary of more than £65,000 £57,500 £75,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Edinburgh

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

OLAP Jobs Demand Trend in Edinburgh

OLAP
Salary Trend in Edinburgh

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

OLAP Salary Trend in Edinburgh

OLAP
Salary Histogram in Edinburgh

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

OLAP Salary Histogram in Edinburgh

OLAP
Top 30 Related IT Skills in Edinburgh

For the 6 months to 26 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 Edinburgh region with a requirement for OLAP.

1 20 (90.91%) Finance
2 17 (77.27%) Retail
2 17 (77.27%) Oracle
2 17 (77.27%) Oracle OLAP
3 15 (68.18%) Data Warehouse
3 15 (68.18%) Data Modelling
3 15 (68.18%) ETL
4 12 (54.55%) Informatica
4 12 (54.55%) Shell Script
4 12 (54.55%) Perl
4 12 (54.55%) Software Engineering
4 12 (54.55%) Games
4 12 (54.55%) Scrum
4 12 (54.55%) Agile Software Development
4 12 (54.55%) Kanban
4 12 (54.55%) Data Architecture
4 12 (54.55%) Hadoop
4 12 (54.55%) Data Governance
4 12 (54.55%) HBase
4 12 (54.55%) Big Data
4 12 (54.55%) Apache Hive
4 12 (54.55%) REST
4 12 (54.55%) Telecoms
4 12 (54.55%) Logical Data Model
4 12 (54.55%) Physical Data Model
5 10 (45.45%) SQL
5 10 (45.45%) Business Intelligence
6 8 (36.36%) SQL Server
7 7 (31.82%) SAS
7 7 (31.82%) Base SAS

OLAP
Top Related IT Skills in Edinburgh 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 (31.82%) SAS
Applications
1 3 (13.64%) MS Excel
Database & Business Intelligence
1 17 (77.27%) Oracle OLAP
2 15 (68.18%) Data Warehouse
3 12 (54.55%) Apache Hive
3 12 (54.55%) Big Data
3 12 (54.55%) Hadoop
3 12 (54.55%) HBase
4 8 (36.36%) SQL Server
5 7 (31.82%) Base SAS
5 7 (31.82%) SAS Enterprise Guide
6 5 (22.73%) SAS EBI
7 3 (13.64%) Power BI
7 3 (13.64%) QlikView
7 3 (13.64%) Relational Database
7 3 (13.64%) SQL Server Analysis Services
7 3 (13.64%) SQL Server Integration Services
7 3 (13.64%) SQL Server Reporting Services
8 2 (9.09%) Data Mining
8 2 (9.09%) SAS Data Integration Studio
General
1 20 (90.91%) Finance
2 17 (77.27%) Retail
3 12 (54.55%) Games
3 12 (54.55%) Telecoms
4 5 (22.73%) Banking
4 5 (22.73%) Manufacturing
Job Titles
1 12 (54.55%) Architect
1 12 (54.55%) Data Architect
2 5 (22.73%) Business Intelligence Consultant
2 5 (22.73%) Consultant
2 5 (22.73%) SAS BI Consultant
2 5 (22.73%) SAS Consultant
3 4 (18.18%) Hadoop Architect
4 3 (13.64%) Technical Leader
Libraries, Frameworks & Software Standards
1 12 (54.55%) REST
2 3 (13.64%) MDX
Operating Systems
1 5 (22.73%) Linux
1 5 (22.73%) Unix
1 5 (22.73%) Windows
Processes & Methodologies
1 15 (68.18%) Data Modelling
1 15 (68.18%) ETL
2 12 (54.55%) Agile Software Development
2 12 (54.55%) Data Architecture
2 12 (54.55%) Data Governance
2 12 (54.55%) Kanban
2 12 (54.55%) Logical Data Model
2 12 (54.55%) Physical Data Model
2 12 (54.55%) Scrum
2 12 (54.55%) Software Engineering
3 10 (45.45%) Business Intelligence
4 5 (22.73%) Business Analysis
4 5 (22.73%) Project Management
5 3 (13.64%) Data Transformation
5 3 (13.64%) Mentoring
6 2 (9.09%) Dashboard Development
Programming Languages
1 12 (54.55%) Perl
1 12 (54.55%) Shell Script
2 10 (45.45%) SQL
3 2 (9.09%) SAS Macro
Vendors
1 17 (77.27%) Oracle
2 12 (54.55%) Informatica
3 3 (13.64%) Microsoft
3 3 (13.64%) Tableau