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

3 months to
27 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 86 97 107
Rank change year-on-year
+11 +10
Permanent jobs citing OLAP 10 3 8
As % of all permanent IT jobs located in Edinburgh 0.84% 0.22% 0.50%
As % of the Database & Business Intelligence category 3.06% 0.74% 1.65%
Number of salaries quoted 10 1 3
Median salary £50,000 £52,500 £45,000
Median salary % change year-on-year
-4.76% +16.66%
90% offered a salary of more than £49,250 £52,500 £37,000
10% offered a salary of more than £55,000 £52,500 £69,000
UK excluding London median salary £46,000 £40,000 £42,500
% change year-on-year
+15.00% -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
327 406 486
As % of all permanent IT jobs located in Edinburgh 27.39% 29.19% 30.45%
Number of salaries quoted 169 254 363
Median salary £45,000 £44,000 £42,500
Median salary % change year-on-year
+2.27% +3.52%
90% offered a salary of more than £30,000 £29,000 £28,500
10% offered a salary of more than £67,250 £60,000 £64,250
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 27 June 2016.

OLAP Salary Histogram in Edinburgh

OLAP
Top 30 Related IT Skills in Edinburgh

For the 6 months to 27 June 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 13 (76.47%) SQL
2 12 (70.59%) Finance
3 11 (64.71%) Oracle
3 11 (64.71%) Business Intelligence
3 11 (64.71%) Oracle OLAP
4 10 (58.82%) Retail
4 10 (58.82%) SAS
5 9 (52.94%) Base SAS
5 9 (52.94%) SAS Enterprise Guide
6 8 (47.06%) SQL Server
6 8 (47.06%) Unix
7 7 (41.18%) Linux
8 6 (35.29%) Games
8 6 (35.29%) Software Engineering
8 6 (35.29%) Banking
8 6 (35.29%) Big Data
9 5 (29.41%) Agile Software Development
9 5 (29.41%) Business Analysis
9 5 (29.41%) Manufacturing
9 5 (29.41%) Project Management
9 5 (29.41%) Data Warehouse
9 5 (29.41%) ETL
9 5 (29.41%) Windows
9 5 (29.41%) SAS EBI
10 4 (23.53%) Hadoop
10 4 (23.53%) Logical Data Model
10 4 (23.53%) Physical Data Model
10 4 (23.53%) Perl
10 4 (23.53%) Data Modelling
10 4 (23.53%) Informatica

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 10 (58.82%) SAS
2 1 (5.88%) SharePoint
2 1 (5.88%) SharePoint 2010
2 1 (5.88%) SharePoint 2013
Applications
1 1 (5.88%) MS Excel
Database & Business Intelligence
1 11 (64.71%) Oracle OLAP
2 9 (52.94%) Base SAS
2 9 (52.94%) SAS Enterprise Guide
3 8 (47.06%) SQL Server
4 6 (35.29%) Big Data
5 5 (29.41%) Data Warehouse
5 5 (29.41%) SAS EBI
6 4 (23.53%) Apache Hive
6 4 (23.53%) Hadoop
6 4 (23.53%) HBase
7 2 (11.76%) Amazon Redshift
7 2 (11.76%) Apache Cassandra
7 2 (11.76%) Data Mining
7 2 (11.76%) MongoDB
7 2 (11.76%) NoSQL
7 2 (11.76%) OLTP
7 2 (11.76%) PostgreSQL
7 2 (11.76%) RDBMS
7 2 (11.76%) Relational Database
7 2 (11.76%) VoltDB
Development Applications
1 1 (5.88%) Git (software)
1 1 (5.88%) SQL Server Management Studio (SSMS)
General
1 12 (70.59%) Finance
2 10 (58.82%) Retail
3 6 (35.29%) Banking
3 6 (35.29%) Games
4 5 (29.41%) Manufacturing
5 4 (23.53%) Telecoms
Job Titles
1 8 (47.06%) Consultant
1 8 (47.06%) SAS Consultant
2 5 (29.41%) Business Intelligence Consultant
2 5 (29.41%) SAS BI Consultant
3 4 (23.53%) Architect
3 4 (23.53%) Data Architect
4 2 (11.76%) Senior Software Engineer
4 2 (11.76%) Software Engineer
5 1 (5.88%) Business Intelligence Developer
5 1 (5.88%) Developer
Libraries, Frameworks & Software Standards
1 4 (23.53%) REST
2 1 (5.88%) MDX
Miscellaneous
1 1 (5.88%) Analytical Skills
1 1 (5.88%) Data Integration
1 1 (5.88%) Visualisation
Operating Systems
1 8 (47.06%) Unix
2 7 (41.18%) Linux
3 5 (29.41%) Windows
Processes & Methodologies
1 11 (64.71%) Business Intelligence
2 6 (35.29%) Software Engineering
3 5 (29.41%) Agile Software Development
3 5 (29.41%) Business Analysis
3 5 (29.41%) ETL
3 5 (29.41%) Project Management
4 4 (23.53%) Data Architecture
4 4 (23.53%) Data Governance
4 4 (23.53%) Data Modelling
4 4 (23.53%) Kanban
4 4 (23.53%) Logical Data Model
4 4 (23.53%) Physical Data Model
4 4 (23.53%) Scrum
5 2 (11.76%) Dashboard Development
5 2 (11.76%) Multithreading
6 1 (5.88%) Data Visualisation
6 1 (5.88%) ETL Development
6 1 (5.88%) Inmon Methodology
6 1 (5.88%) Kimball Methodology
6 1 (5.88%) Web Development
Programming Languages
1 13 (76.47%) SQL
2 4 (23.53%) Perl
2 4 (23.53%) Shell Script
3 2 (11.76%) Java
3 2 (11.76%) SAS Macro
4 1 (5.88%) T-SQL
4 1 (5.88%) VBA
Vendors
1 11 (64.71%) Oracle
2 4 (23.53%) Informatica
3 2 (11.76%) Vertica
Edinburgh
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + pension, bonus, health care
Posted: 11 days ago