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

3 months to
28 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 84 95 95
Rank change year-on-year
+11 0
Permanent jobs citing OLAP 9 1 12
As % of all permanent IT jobs located in Edinburgh 0.73% 0.074% 0.76%
As % of the Database & Business Intelligence category 2.63% 0.27% 2.64%
Number of salaries quoted 9 1 7
Median salary £50,000 £52,500 £50,000
Median salary % change year-on-year
-4.76% +5.00%
90% offered a salary of more than £44,500 £52,500 £41,000
10% offered a salary of more than £51,000 £52,500 £63,900
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%
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
342 372 454
As % of all permanent IT jobs located in Edinburgh 27.65% 27.54% 28.73%
Number of salaries quoted 185 239 339
Median salary £50,000 £44,000 £42,500
Median salary % change year-on-year
+13.63% +3.52%
90% offered a salary of more than £30,000 £32,000 £28,500
10% offered a salary of more than £64,000 £60,000 £55,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 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 28 May 2016.

OLAP Salary Histogram in Edinburgh

OLAP
Top 30 Related IT Skills in Edinburgh

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

1 18 (94.74%) SQL
2 14 (73.68%) Business Intelligence
3 12 (63.16%) SAS
4 11 (57.89%) SQL Server
4 11 (57.89%) Base SAS
4 11 (57.89%) SAS Enterprise Guide
5 10 (52.63%) Oracle OLAP
5 10 (52.63%) Oracle
6 9 (47.37%) Linux
6 9 (47.37%) Finance
7 8 (42.11%) Unix
8 7 (36.84%) Retail
9 6 (31.58%) Banking
10 5 (26.32%) Business Analysis
10 5 (26.32%) Windows
10 5 (26.32%) Manufacturing
10 5 (26.32%) Games
10 5 (26.32%) Project Management
10 5 (26.32%) Big Data
10 5 (26.32%) SAS EBI
11 4 (21.05%) Vertica
11 4 (21.05%) Relational Database
11 4 (21.05%) VoltDB
11 4 (21.05%) Amazon Redshift
11 4 (21.05%) SAS Data Integration Studio
11 4 (21.05%) NewSQL
11 4 (21.05%) Dashboard Development
11 4 (21.05%) OLTP
11 4 (21.05%) RDBMS
11 4 (21.05%) PostgreSQL

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 12 (63.16%) SAS
2 2 (10.53%) SharePoint
2 2 (10.53%) SharePoint 2010
2 2 (10.53%) SharePoint 2013
Applications
1 2 (10.53%) MS Excel
Database & Business Intelligence
1 11 (57.89%) Base SAS
1 11 (57.89%) SAS Enterprise Guide
1 11 (57.89%) SQL Server
2 10 (52.63%) Oracle OLAP
3 5 (26.32%) Big Data
3 5 (26.32%) SAS EBI
4 4 (21.05%) Amazon Redshift
4 4 (21.05%) Apache Cassandra
4 4 (21.05%) Data Mining
4 4 (21.05%) MongoDB
4 4 (21.05%) NewSQL
4 4 (21.05%) NoSQL
4 4 (21.05%) OLTP
4 4 (21.05%) PostgreSQL
4 4 (21.05%) RDBMS
4 4 (21.05%) Relational Database
4 4 (21.05%) SAS Data Integration Studio
4 4 (21.05%) VoltDB
5 3 (15.79%) Data Warehouse
6 2 (10.53%) SQL Server Integration Services
Development Applications
1 2 (10.53%) Git (software)
1 2 (10.53%) SQL Server Management Studio (SSMS)
General
1 9 (47.37%) Finance
2 7 (36.84%) Retail
3 6 (31.58%) Banking
4 5 (26.32%) Games
4 5 (26.32%) Manufacturing
5 1 (5.26%) Telecoms
Job Titles
1 8 (42.11%) Consultant
1 8 (42.11%) SAS Consultant
2 5 (26.32%) Business Intelligence Consultant
2 5 (26.32%) SAS BI Consultant
3 3 (15.79%) Developer
3 3 (15.79%) Senior Software Engineer
3 3 (15.79%) Software Engineer
4 2 (10.53%) Business Intelligence Developer
5 1 (5.26%) Administrator
5 1 (5.26%) Architect
5 1 (5.26%) Data Architect
5 1 (5.26%) Database Developer
5 1 (5.26%) DBA
Libraries, Frameworks & Software Standards
1 2 (10.53%) MDX
2 1 (5.26%) JDBC
2 1 (5.26%) REST
Miscellaneous
1 2 (10.53%) Analytical Skills
1 2 (10.53%) Data Integration
1 2 (10.53%) Visualisation
Operating Systems
1 9 (47.37%) Linux
2 8 (42.11%) Unix
3 5 (26.32%) Windows
Processes & Methodologies
1 14 (73.68%) Business Intelligence
2 5 (26.32%) Business Analysis
2 5 (26.32%) Project Management
3 4 (21.05%) Dashboard Development
3 4 (21.05%) Software Engineering
4 3 (15.79%) Agile Software Development
4 3 (15.79%) ETL
4 3 (15.79%) Multithreading
5 2 (10.53%) Data Visualisation
5 2 (10.53%) ETL Development
5 2 (10.53%) Inmon Methodology
5 2 (10.53%) Kimball Methodology
5 2 (10.53%) Web Development
6 1 (5.26%) Data Architecture
6 1 (5.26%) Data Governance
6 1 (5.26%) Data Modelling
6 1 (5.26%) Kanban
6 1 (5.26%) Logical Data Model
6 1 (5.26%) Physical Data Model
6 1 (5.26%) Scrum
Programming Languages
1 18 (94.74%) SQL
2 4 (21.05%) Java
2 4 (21.05%) SAS Macro
3 2 (10.53%) T-SQL
3 2 (10.53%) VBA
4 1 (5.26%) Perl
4 1 (5.26%) Shell Script
Vendors
1 10 (52.63%) Oracle
2 4 (21.05%) Vertica
3 1 (5.26%) Informatica
Edinburgh
Churchill Frank International
Salary: £40000 - £45000 per annum + Negotiable
Posted: 17 days ago