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

Location
3 months to
22 May 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 132 154 139
Rank change year-on-year
+22 -15
Permanent jobs citing OLAP 20 19 18
As % of all permanent IT jobs located in Scotland 0.68% 0.50% 0.56%
As % of the Database & Business Intelligence category 2.16% 1.56% 1.64%
Number of salaries quoted 9 9 9
Average salary £42,500 £50,000 £45,000
Average salary % change year-on-year
-15.00% +11.11%
90% offered a salary of more than £39,500 £43,000 £24,100
10% offered a salary of more than £50,500 £60,200 £52,800
UK excluding London average salary £40,000 £42,500 £45,000
% change year-on-year
-5.88% -5.55%
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
925 1218 1098
As % of all permanent IT jobs located in Scotland 31.32% 31.79% 34.41%
Number of salaries quoted 574 847 645
Average salary £42,500 £41,500 £40,000
Average salary % change year-on-year
+2.40% +3.75%
90% offered a salary of more than £32,500 £30,000 £28,000
10% offered a salary of more than £57,525 £57,500 £55,000
UK excluding London average salary £41,500 £40,000 £38,500
% change year-on-year
+3.75% +3.89%

OLAP
Jobs Demand Trend in Scotland

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the Scotland region as a proportion of the total demand within 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 22 May 2015.

OLAP Salary Histogram in Scotland

OLAP
Job Locations in Scotland

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the Scotland region over the 3 months to 22 May 2015. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Stirling +5 9 - -
Glasgow +6 6 £42,500 - 1
West Lothian - 3 £40,000 -
Aberdeen +19 1 - - 2
Edinburgh +8 1 £52,500 +5.00%
OLAP
UK

OLAP
Top 30 Related IT Skills in Scotland

For the 6 months to 22 May 2015, IT jobs across the Scotland region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 20 (86.96%) SQL
2 14 (60.87%) Finance
3 12 (52.17%) Oracle
4 11 (47.83%) Java
5 10 (43.48%) Analytics
5 10 (43.48%) Relational Database
6 9 (39.13%) Analytical Skills
6 9 (39.13%) Banking
6 9 (39.13%) Business Intelligence
7 8 (34.78%) Hibernate
7 8 (34.78%) Workflow
7 8 (34.78%) PL/SQL
7 8 (34.78%) Web Services
7 8 (34.78%) OO
7 8 (34.78%) JMS
7 8 (34.78%) RDBMS
7 8 (34.78%) Coaching
7 8 (34.78%) Spring Integration
7 8 (34.78%) Enterprise Software
7 8 (34.78%) Spring
7 8 (34.78%) Investment Banking
7 8 (34.78%) JPA
8 6 (26.09%) Agile Software Development
8 6 (26.09%) SQL Server
9 5 (21.74%) Microsoft
9 5 (21.74%) SQL Server Integration Services
10 4 (17.39%) Oracle OLAP
10 4 (17.39%) Data Warehouse
10 4 (17.39%) Oracle Reports
10 4 (17.39%) ETL

OLAP
Top Related IT Skills in Scotland by Category

For the 6 months to 22 May 2015, IT jobs across the Scotland region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 4 (17.39%) SAS
2 1 (4.35%) Tomcat
2 1 (4.35%) WebSphere Application Server
2 1 (4.35%) SharePoint
2 1 (4.35%) Mule
2 1 (4.35%) WebSphere
Applications
1 3 (13.04%) MS Excel
2 1 (4.35%) SPSS
Business Applications
1 2 (8.70%) Cognos TM1
2 1 (4.35%) Oracle EBS
2 1 (4.35%) Sage CRM
Communications & Networking
1 1 (4.35%) DAB
Database & Business Intelligence
1 10 (43.48%) Relational Database
2 8 (34.78%) RDBMS
3 6 (26.09%) SQL Server
4 5 (21.74%) SQL Server Integration Services
5 4 (17.39%) Oracle OLAP
5 4 (17.39%) Data Warehouse
5 4 (17.39%) Oracle Reports
6 3 (13.04%) OLTP
6 3 (13.04%) SQL Server Analysis Services
6 3 (13.04%) Base SAS
6 3 (13.04%) SAS Enterprise Guide
6 3 (13.04%) SQL Server Reporting Services
7 2 (8.70%) SQL Server 2005
7 2 (8.70%) Cognos Query Studio
7 2 (8.70%) Cognos Analysis Studio
7 2 (8.70%) Cognos Report Studio
7 2 (8.70%) Cognos Framework Manager
7 2 (8.70%) Cognos Event Studio
7 2 (8.70%) DTS
8 1 (4.35%) DB2
Development Applications
1 2 (8.70%) JIRA
2 1 (4.35%) ERwin
General
1 14 (60.87%) Finance
2 9 (39.13%) Banking
3 8 (34.78%) Investment Banking
4 2 (8.70%) Manufacturing
5 1 (4.35%) Advertising
Job Titles
1 8 (34.78%) Developer
1 8 (34.78%) Development Specialist
2 3 (13.04%) Consultant
2 3 (13.04%) SAS Consultant
2 3 (13.04%) SQL Developer
3 2 (8.70%) SQL DBA
3 2 (8.70%) Business Intelligence Developer
3 2 (8.70%) Cognos Developer
3 2 (8.70%) Architect
3 2 (8.70%) DBA
4 1 (4.35%) Solutions Architect
4 1 (4.35%) Senior Developer
4 1 (4.35%) Programmer
4 1 (4.35%) Business Analyst
4 1 (4.35%) Analyst
4 1 (4.35%) Business Developer
4 1 (4.35%) Analyst Developer
4 1 (4.35%) Business Intelligence Analyst
4 1 (4.35%) Data Architect
4 1 (4.35%) Development DBA
Libraries, Frameworks & Software Standards
1 8 (34.78%) Hibernate
1 8 (34.78%) Web Services
1 8 (34.78%) JMS
1 8 (34.78%) Spring Integration
1 8 (34.78%) Spring
1 8 (34.78%) JPA
2 3 (13.04%) .NET
3 1 (4.35%) ASP.NET Web Forms
3 1 (4.35%) WCF
3 1 (4.35%) Entity Framework
3 1 (4.35%) MDX
3 1 (4.35%) .NET Framework
Miscellaneous
1 9 (39.13%) Analytical Skills
2 8 (34.78%) Enterprise Software
3 1 (4.35%) Replication
3 1 (4.35%) Clustering
3 1 (4.35%) Computer Science
3 1 (4.35%) Social Media
3 1 (4.35%) Reference Data
Operating Systems
1 3 (13.04%) UNIX
Processes & Methodologies
1 10 (43.48%) Analytics
2 9 (39.13%) Business Intelligence
3 8 (34.78%) Workflow
3 8 (34.78%) OO
3 8 (34.78%) Coaching
4 6 (26.09%) Agile Software Development
5 4 (17.39%) ETL
6 3 (13.04%) Data Modelling
7 2 (8.70%) Data Analysis
7 2 (8.70%) Data Architecture
7 2 (8.70%) Kanban
7 2 (8.70%) Unit Testing
7 2 (8.70%) Performance Tuning
7 2 (8.70%) Continuous Improvement
7 2 (8.70%) CRM
7 2 (8.70%) E-Commerce
7 2 (8.70%) Scrum
8 1 (4.35%) Data Security
8 1 (4.35%) MVC
8 1 (4.35%) Risk Management
Programming Languages
1 20 (86.96%) SQL
2 11 (47.83%) Java
3 8 (34.78%) PL/SQL
4 2 (8.70%) T-SQL
5 1 (4.35%) JavaScript
5 1 (4.35%) C#
5 1 (4.35%) C++
Qualifications
1 2 (8.70%) Degree
Vendors
1 12 (52.17%) Oracle
2 5 (21.74%) Microsoft
3 3 (13.04%) Cognos
4 2 (8.70%) Google
4 2 (8.70%) Vertica
5 1 (4.35%) Teradata
5 1 (4.35%) Sybase
5 1 (4.35%) SAP
5 1 (4.35%) Informatica
5 1 (4.35%) Sage
5 1 (4.35%) TIBCO
Aberdeen
Net Talent
Salary: £40000 per annum
Posted: 8 hours ago
Aberdeen, Aberdeenshire
Entrust People Ltd
Salary: £Competitive
Posted: 10 hours ago
Scotland
ANSON MCCADE
Salary: £35k-£60k+attractive benefits+extensive career progression
Posted: 5 days ago
Scotland
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 5 days ago
Aberdeenshire
Deerfoot IT
Salary: Competitive salary and excellent benefits
Posted: 12 days ago
Glasgow
Nigel Frank International Limited - Newcastle
Salary: £35000 - £50000 per annum + Training & Benefits
Posted: 24 days ago