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 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 175 204 199
Rank change year-on-year
+29 -5
Permanent jobs citing OLAP 16 11 26
As % of all permanent IT jobs located in Surrey 0.44% 0.24% 0.51%
As % of the Database & Business Intelligence category 1.45% 0.75% 1.57%
Number of salaries quoted 16 11 25
Median salary £55,000 £45,000 £52,000
Median salary % change year-on-year
+22.22% -13.46%
90% offered a salary of more than £46,250 £31,500 £45,600
10% offered a salary of more than £70,000 £52,500 £63,000
UK excluding London median salary £47,500 £40,000 £44,500
% change year-on-year
+18.75% -10.11%
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
1103 1474 1652
As % of all permanent IT jobs located in Surrey 30.63% 32.02% 32.56%
Number of salaries quoted 968 1271 1402
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
90% offered a salary of more than £33,500 £30,000 £31,500
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 23 July 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 23 July 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
Guildford - 6 £70,000 -
Woking - 6 £50,000 -
Egham - 3 £55,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Surrey

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 Surrey region with a requirement for OLAP.

1 26 (86.67%) Business Intelligence
2 22 (73.33%) SQL
3 21 (70.00%) Microsoft
3 21 (70.00%) SQL Server Integration Services
3 21 (70.00%) SQL Server Analysis Services
4 18 (60.00%) OLAP Cube
4 18 (60.00%) SQL Server Reporting Services
5 15 (50.00%) Oracle OLAP
5 15 (50.00%) Data Modelling
5 15 (50.00%) T-SQL
5 15 (50.00%) HTML
5 15 (50.00%) JavaScript
5 15 (50.00%) Oracle
5 15 (50.00%) SQL Server
5 15 (50.00%) SQL Server 2008
6 13 (43.33%) Data Warehouse
7 12 (40.00%) .NET
7 12 (40.00%) ETL
7 12 (40.00%) C#
7 12 (40.00%) Scrum
7 12 (40.00%) Agile Software Development
7 12 (40.00%) SQL Server 2012
8 11 (36.67%) VBA
8 11 (36.67%) BusinessObjects
9 9 (30.00%) MS Visio
9 9 (30.00%) XML
9 9 (30.00%) UML
9 9 (30.00%) PL/SQL
9 9 (30.00%) MS Office
9 9 (30.00%) Relational Database

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 6 (20.00%) SAS
2 2 (6.67%) NetWeaver
Applications
1 9 (30.00%) MS Office
1 9 (30.00%) MS Visio
2 8 (26.67%) MS Excel
Business Applications
1 2 (6.67%) SAP BPC
Database & Business Intelligence
1 21 (70.00%) SQL Server Analysis Services
1 21 (70.00%) SQL Server Integration Services
2 18 (60.00%) OLAP Cube
2 18 (60.00%) SQL Server Reporting Services
3 15 (50.00%) Oracle OLAP
3 15 (50.00%) SQL Server
3 15 (50.00%) SQL Server 2008
4 13 (43.33%) Data Warehouse
5 12 (40.00%) SQL Server 2012
6 11 (36.67%) BusinessObjects
7 9 (30.00%) Relational Database
7 9 (30.00%) SQL Server 2005
8 6 (20.00%) Adabas
8 6 (20.00%) Big Data
8 6 (20.00%) Hadoop
8 6 (20.00%) PowerPivot
9 3 (10.00%) Data Mart
9 3 (10.00%) Microsoft Analysis Services
9 3 (10.00%) OLTP
9 3 (10.00%) SQL Server 2014
Development Applications
1 3 (10.00%) Visual Studio
General
1 8 (26.67%) Finance
Job Titles
1 21 (70.00%) Developer
2 18 (60.00%) Business Intelligence Developer
3 12 (40.00%) Microsoft BI Developer
3 12 (40.00%) Microsoft Developer
3 12 (40.00%) SSIS Developer
4 9 (30.00%) Business Intelligence Consultant
4 9 (30.00%) Consultant
4 9 (30.00%) Microsoft BI Consultant
4 9 (30.00%) Microsoft Consultant
4 9 (30.00%) Senior Business Intelligence Consultant
4 9 (30.00%) Senior Business Intelligence Developer
4 9 (30.00%) Senior Consultant
4 9 (30.00%) Senior Developer
4 9 (30.00%) Senior Microsoft Consultant
4 9 (30.00%) Senior Microsoft Developer
4 9 (30.00%) SSAS Developer
4 9 (30.00%) SSIS Consultant
4 9 (30.00%) SSRS Consultant
4 9 (30.00%) SSRS Developer
5 6 (20.00%) Data Architect
Libraries, Frameworks & Software Standards
1 15 (50.00%) HTML
2 12 (40.00%) .NET
3 9 (30.00%) XML
4 6 (20.00%) jQuery
5 3 (10.00%) AngularJS
5 3 (10.00%) ASP.NET
5 3 (10.00%) CSS
5 3 (10.00%) Node.js
Miscellaneous
1 3 (10.00%) Visualisation
Processes & Methodologies
1 26 (86.67%) Business Intelligence
2 15 (50.00%) Data Modelling
3 12 (40.00%) Agile Software Development
3 12 (40.00%) ETL
3 12 (40.00%) Scrum
4 9 (30.00%) Business Analysis
4 9 (30.00%) UML
5 6 (20.00%) Analytics
5 6 (20.00%) Data Analytics
5 6 (20.00%) Data Architecture
5 6 (20.00%) Data Governance
5 6 (20.00%) Data Management
5 6 (20.00%) Data Migration
5 6 (20.00%) Information Architecture
5 6 (20.00%) Migration
5 6 (20.00%) OO
5 6 (20.00%) SOA
6 3 (10.00%) Continuous Integration
6 3 (10.00%) Data Visualisation
6 3 (10.00%) Performance Tuning
Programming Languages
1 22 (73.33%) SQL
2 15 (50.00%) JavaScript
2 15 (50.00%) T-SQL
3 12 (40.00%) C#
4 11 (36.67%) VBA
5 9 (30.00%) PL/SQL
6 3 (10.00%) PHP
Qualifications
1 3 (10.00%) MCSE
1 3 (10.00%) Microsoft Certification
Quality Assurance & Compliance
1 3 (10.00%) QA
Vendors
1 21 (70.00%) Microsoft
2 15 (50.00%) Oracle
3 2 (6.67%) SAP