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

3 months to
30 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 179 213 199
Rank change year-on-year
+34 -14
Permanent jobs citing OLAP 13 9 28
As % of all permanent IT jobs located in Surrey 0.36% 0.19% 0.53%
As % of the Database & Business Intelligence category 1.13% 0.59% 1.63%
Number of salaries quoted 13 9 27
Median salary £50,000 £47,500 £52,000
Median salary % change year-on-year
+5.26% -8.65%
90% offered a salary of more than £48,000 £31,200 £46,500
10% offered a salary of more than £70,000 £53,000 £62,000
UK excluding London median salary £47,500 £40,000 £42,500
% change year-on-year
+18.75% -5.88%
OLAP
South East

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

Database & Business Intelligence Category
Surrey
Permanent IT job ads with a match in the
Database & Business Intelligence category
1155 1513 1723
As % of all permanent IT jobs located in Surrey 31.67% 32.54% 32.37%
Number of salaries quoted 1012 1296 1455
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
90% offered a salary of more than £32,500 £30,000 £32,000
10% offered a salary of more than £70,000 £65,000 £65,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 Surrey

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

OLAP Jobs Demand Trend in Surrey

OLAP
Salary Trend in Surrey

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

OLAP Salary Trend in Surrey

OLAP
Salary Histogram in Surrey

This chart provides a salary histogram for IT jobs citing OLAP across the Surrey region over the 3 months to 30 June 2016.

OLAP Salary Histogram in Surrey

OLAP
Job Locations in Surrey

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Surrey region over the 3 months to 30 June 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Woking - 6 £50,000 -
Egham - 3 £55,000 -
Guildford - 3 £70,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Surrey

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

1 28 (87.50%) Business Intelligence
2 27 (84.38%) Microsoft
2 27 (84.38%) SQL Server Integration Services
2 27 (84.38%) SQL Server Analysis Services
3 25 (78.13%) SQL
4 24 (75.00%) SQL Server Reporting Services
5 21 (65.63%) T-SQL
5 21 (65.63%) SQL Server
6 20 (62.50%) HTML
6 20 (62.50%) JavaScript
6 20 (62.50%) SQL Server 2008
6 20 (62.50%) OLAP Cube
7 17 (53.13%) C#
7 17 (53.13%) .NET
7 17 (53.13%) Oracle
7 17 (53.13%) Data Modelling
7 17 (53.13%) SQL Server 2012
7 17 (53.13%) Oracle OLAP
8 15 (46.88%) Relational Database
8 15 (46.88%) BusinessObjects
8 15 (46.88%) VBA
9 14 (43.75%) PL/SQL
9 14 (43.75%) MS Office
9 14 (43.75%) XML
9 14 (43.75%) UML
9 14 (43.75%) MS Visio
9 14 (43.75%) Business Analysis
9 14 (43.75%) SQL Server 2005
10 12 (37.50%) Scrum
10 12 (37.50%) Agile Software Development

OLAP
Top Related IT Skills in Surrey 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 3 (9.38%) SAS
2 1 (3.13%) NetWeaver
Applications
1 14 (43.75%) MS Office
1 14 (43.75%) MS Visio
2 7 (21.88%) MS Excel
Business Applications
1 1 (3.13%) SAP BPC
Database & Business Intelligence
1 27 (84.38%) SQL Server Analysis Services
1 27 (84.38%) SQL Server Integration Services
2 24 (75.00%) SQL Server Reporting Services
3 21 (65.63%) SQL Server
4 20 (62.50%) OLAP Cube
4 20 (62.50%) SQL Server 2008
5 17 (53.13%) Oracle OLAP
5 17 (53.13%) SQL Server 2012
6 15 (46.88%) BusinessObjects
6 15 (46.88%) Relational Database
7 14 (43.75%) SQL Server 2005
8 11 (34.38%) Data Warehouse
9 6 (18.75%) PowerPivot
10 4 (12.50%) OLTP
11 3 (9.38%) Adabas
11 3 (9.38%) Big Data
11 3 (9.38%) Data Mart
11 3 (9.38%) Hadoop
11 3 (9.38%) Microsoft Analysis Services
11 3 (9.38%) SQL Server 2014
Development Applications
1 3 (9.38%) Visual Studio
General
1 4 (12.50%) Finance
2 1 (3.13%) Legal
Job Titles
1 27 (84.38%) Developer
2 24 (75.00%) Business Intelligence Developer
3 18 (56.25%) Microsoft BI Developer
3 18 (56.25%) Microsoft Developer
3 18 (56.25%) SSIS Developer
4 15 (46.88%) SSAS Developer
4 15 (46.88%) SSRS Developer
5 14 (43.75%) Business Intelligence Consultant
5 14 (43.75%) Consultant
5 14 (43.75%) Microsoft BI Consultant
5 14 (43.75%) Microsoft Consultant
5 14 (43.75%) Senior Business Intelligence Consultant
5 14 (43.75%) Senior Business Intelligence Developer
5 14 (43.75%) Senior Consultant
5 14 (43.75%) Senior Developer
5 14 (43.75%) Senior Microsoft Consultant
5 14 (43.75%) Senior Microsoft Developer
5 14 (43.75%) SSIS Consultant
5 14 (43.75%) SSRS Consultant
6 3 (9.38%) ETL Developer
Libraries, Frameworks & Software Standards
1 20 (62.50%) HTML
2 17 (53.13%) .NET
3 14 (43.75%) XML
4 6 (18.75%) jQuery
5 3 (9.38%) AngularJS
5 3 (9.38%) ASP.NET
5 3 (9.38%) CSS
5 3 (9.38%) Node.js
Miscellaneous
1 3 (9.38%) Visualisation
Processes & Methodologies
1 28 (87.50%) Business Intelligence
2 17 (53.13%) Data Modelling
3 14 (43.75%) Business Analysis
3 14 (43.75%) UML
4 12 (37.50%) Agile Software Development
4 12 (37.50%) ETL
4 12 (37.50%) Scrum
5 4 (12.50%) Analytics
5 4 (12.50%) Data Analytics
6 3 (9.38%) Continuous Integration
6 3 (9.38%) Data Architecture
6 3 (9.38%) Data Governance
6 3 (9.38%) Data Migration
6 3 (9.38%) Data Visualisation
6 3 (9.38%) Information Architecture
6 3 (9.38%) Migration
6 3 (9.38%) OO
6 3 (9.38%) Performance Tuning
6 3 (9.38%) SDLC
6 3 (9.38%) SOA
Programming Languages
1 25 (78.13%) SQL
2 21 (65.63%) T-SQL
3 20 (62.50%) JavaScript
4 17 (53.13%) C#
5 15 (46.88%) VBA
6 14 (43.75%) PL/SQL
7 3 (9.38%) PHP
Qualifications
1 3 (9.38%) MCSE
1 3 (9.38%) Microsoft Certification
Quality Assurance & Compliance
1 3 (9.38%) QA
Vendors
1 27 (84.38%) Microsoft
2 17 (53.13%) Oracle
3 1 (3.13%) SAP