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

3 months to
23 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 79 96 105
Rank change year-on-year
+17 +9
Permanent jobs citing OLAP 15 3 5
As % of all permanent IT jobs located in Edinburgh 1.27% 0.21% 0.34%
As % of the Database & Business Intelligence category 4.45% 0.68% 1.17%
Number of salaries quoted 15 1 1
Median salary £55,000 £52,500 £35,000
Median salary % change year-on-year
+4.76% +50.00%
UK excluding London median salary £47,500 £40,000 £44,500
% change year-on-year
+18.75% -10.11%
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
337 444 429
As % of all permanent IT jobs located in Edinburgh 28.44% 30.56% 29.08%
Number of salaries quoted 199 295 331
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £35,000 £28,150 £29,000
10% offered a salary of more than £65,000 £60,000 £79,500
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 23 July 2016.

OLAP Salary Histogram in Edinburgh

OLAP
Top 30 Related IT Skills in Edinburgh

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

1 19 (86.36%) Finance
2 14 (63.64%) SQL
2 14 (63.64%) Business Intelligence
3 13 (59.09%) Oracle
3 13 (59.09%) Retail
3 13 (59.09%) Oracle OLAP
4 11 (50.00%) Data Warehouse
4 11 (50.00%) Data Modelling
4 11 (50.00%) ETL
4 11 (50.00%) SAS
5 10 (45.45%) Base SAS
5 10 (45.45%) SAS Enterprise Guide
6 8 (36.36%) Data Architecture
6 8 (36.36%) Hadoop
6 8 (36.36%) Data Governance
6 8 (36.36%) HBase
6 8 (36.36%) Big Data
6 8 (36.36%) Logical Data Model
6 8 (36.36%) Physical Data Model
6 8 (36.36%) Apache Hive
6 8 (36.36%) REST
6 8 (36.36%) Kanban
6 8 (36.36%) SQL Server
6 8 (36.36%) Unix
6 8 (36.36%) Informatica
6 8 (36.36%) Shell Script
6 8 (36.36%) Software Engineering
6 8 (36.36%) Perl
6 8 (36.36%) Telecoms
6 8 (36.36%) Games

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 11 (50.00%) SAS
Applications
1 3 (13.64%) MS Excel
Database & Business Intelligence
1 13 (59.09%) Oracle OLAP
2 11 (50.00%) Data Warehouse
3 10 (45.45%) Base SAS
3 10 (45.45%) SAS Enterprise Guide
4 8 (36.36%) Apache Hive
4 8 (36.36%) Big Data
4 8 (36.36%) Hadoop
4 8 (36.36%) HBase
4 8 (36.36%) SQL Server
5 5 (22.73%) SAS EBI
6 3 (13.64%) Data Mining
6 3 (13.64%) Power BI
6 3 (13.64%) QlikView
6 3 (13.64%) Relational Database
6 3 (13.64%) SAS Data Integration Studio
6 3 (13.64%) SQL Server Analysis Services
6 3 (13.64%) SQL Server Integration Services
6 3 (13.64%) SQL Server Reporting Services
General
1 19 (86.36%) Finance
2 13 (59.09%) Retail
3 8 (36.36%) Games
3 8 (36.36%) Telecoms
4 6 (27.27%) Banking
5 5 (22.73%) Manufacturing
Job Titles
1 8 (36.36%) Architect
1 8 (36.36%) Consultant
1 8 (36.36%) Data Architect
1 8 (36.36%) SAS Consultant
2 5 (22.73%) Business Intelligence Consultant
2 5 (22.73%) SAS BI Consultant
3 3 (13.64%) Technical Leader
4 2 (9.09%) Hadoop Architect
Libraries, Frameworks & Software Standards
1 8 (36.36%) REST
2 3 (13.64%) MDX
Operating Systems
1 8 (36.36%) Unix
2 5 (22.73%) Linux
2 5 (22.73%) Windows
Processes & Methodologies
1 14 (63.64%) Business Intelligence
2 11 (50.00%) Data Modelling
2 11 (50.00%) ETL
3 8 (36.36%) Agile Software Development
3 8 (36.36%) Data Architecture
3 8 (36.36%) Data Governance
3 8 (36.36%) Kanban
3 8 (36.36%) Logical Data Model
3 8 (36.36%) Physical Data Model
3 8 (36.36%) Scrum
3 8 (36.36%) Software Engineering
4 5 (22.73%) Business Analysis
4 5 (22.73%) Project Management
5 3 (13.64%) Dashboard Development
5 3 (13.64%) Data Transformation
5 3 (13.64%) Mentoring
Programming Languages
1 14 (63.64%) SQL
2 8 (36.36%) Perl
2 8 (36.36%) Shell Script
3 3 (13.64%) SAS Macro
Vendors
1 13 (59.09%) Oracle
2 8 (36.36%) Informatica
3 3 (13.64%) Microsoft
3 3 (13.64%) Tableau
Edinburgh & Lothians
ANSON MCCADE
Salary: £40K-£60k plus attractive benefits, 30 days holiday and rapid career p
Posted: 5 days ago