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

3 months to
29 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 165 201 201
Rank change year-on-year
+36 0
Permanent jobs citing OLAP 17 13 25
As % of all permanent IT jobs located in Surrey 0.49% 0.30% 0.50%
As % of the Database & Business Intelligence category 1.68% 0.93% 1.49%
Number of salaries quoted 17 12 23
Median salary £57,500 £45,000 £50,000
Median salary % change year-on-year
+27.77% -10.00%
90% offered a salary of more than £48,000 £31,500 £45,000
10% offered a salary of more than £70,000 £52,250 £63,000
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
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
1011 1401 1678
As % of all permanent IT jobs located in Surrey 29.33% 32.18% 33.78%
Number of salaries quoted 868 1221 1424
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
90% offered a salary of more than £35,000 £31,500 £30,000
10% offered a salary of more than £67,500 £64,000 £62,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 29 August 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 29 August 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 - 4 £50,000 -
Egham - 3 £55,000 -
Weybridge - 2 £60,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Surrey

For the 6 months to 29 August 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 21 (84.00%) Business Intelligence
2 17 (68.00%) SQL
2 17 (68.00%) Data Warehouse
3 15 (60.00%) Microsoft
3 15 (60.00%) SQL Server Integration Services
3 15 (60.00%) SQL Server Analysis Services
4 14 (56.00%) ETL
5 12 (48.00%) Scrum
5 12 (48.00%) Agile Software Development
5 12 (48.00%) OLAP Cube
6 11 (44.00%) Finance
7 10 (40.00%) SQL Server Reporting Services
8 9 (36.00%) T-SQL
8 9 (36.00%) SQL Server
9 8 (32.00%) MS Excel
9 8 (32.00%) Data Modelling
9 8 (32.00%) SQL Server 2008
9 8 (32.00%) Big Data
10 7 (28.00%) Data Analytics
10 7 (28.00%) Data Governance
10 7 (28.00%) PowerPivot
10 7 (28.00%) Analytics
10 7 (28.00%) Hadoop
10 7 (28.00%) Data Architecture
10 7 (28.00%) Information Architecture
10 7 (28.00%) Data Migration
10 7 (28.00%) Oracle OLAP
10 7 (28.00%) Data Management
10 7 (28.00%) Migration
10 7 (28.00%) SOA

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 7 (28.00%) SAS
2 2 (8.00%) NetWeaver
Applications
1 8 (32.00%) MS Excel
Business Applications
1 2 (8.00%) Infor M3
1 2 (8.00%) SAP BPC
Database & Business Intelligence
1 17 (68.00%) Data Warehouse
2 15 (60.00%) SQL Server Analysis Services
2 15 (60.00%) SQL Server Integration Services
3 12 (48.00%) OLAP Cube
4 10 (40.00%) SQL Server Reporting Services
5 9 (36.00%) SQL Server
6 8 (32.00%) Big Data
6 8 (32.00%) SQL Server 2008
7 7 (28.00%) Adabas
7 7 (28.00%) Hadoop
7 7 (28.00%) Oracle OLAP
7 7 (28.00%) PowerPivot
8 5 (20.00%) Microsoft Analysis Services
9 4 (16.00%) Data Mart
9 4 (16.00%) OLTP
9 4 (16.00%) SQL Server 2014
10 3 (12.00%) SQL Server 2012
11 2 (8.00%) BusinessObjects
11 2 (8.00%) SAP BI
12 1 (4.00%) Enterprise Data Warehouse
Development Applications
1 3 (12.00%) Visual Studio
General
1 11 (44.00%) Finance
Job Titles
1 15 (60.00%) Developer
2 12 (48.00%) Business Intelligence Developer
3 7 (28.00%) Architect
3 7 (28.00%) Data Architect
4 5 (20.00%) SSIS Developer
5 3 (12.00%) .NET Developer
5 3 (12.00%) C# .NET Developer
5 3 (12.00%) C# Developer
5 3 (12.00%) ETL Developer
5 3 (12.00%) Microsoft BI Developer
5 3 (12.00%) Microsoft Developer
5 3 (12.00%) Web Developer
6 2 (8.00%) Accountant
6 2 (8.00%) SSAS Developer
6 2 (8.00%) Systems Accountant
7 1 (4.00%) Administrator
7 1 (4.00%) Senior Business Intelligence Developer
7 1 (4.00%) Senior Developer
7 1 (4.00%) TM1 Administrator
Libraries, Frameworks & Software Standards
1 6 (24.00%) HTML
1 6 (24.00%) jQuery
2 3 (12.00%) .NET
2 3 (12.00%) AngularJS
2 3 (12.00%) ASP.NET
2 3 (12.00%) CSS
2 3 (12.00%) Node.js
3 2 (8.00%) MDX
Miscellaneous
1 3 (12.00%) Visualisation
Processes & Methodologies
1 21 (84.00%) Business Intelligence
2 14 (56.00%) ETL
3 12 (48.00%) Agile Software Development
3 12 (48.00%) Scrum
4 8 (32.00%) Data Modelling
5 7 (28.00%) Analytics
5 7 (28.00%) Data Analytics
5 7 (28.00%) Data Architecture
5 7 (28.00%) Data Governance
5 7 (28.00%) Data Management
5 7 (28.00%) Data Migration
5 7 (28.00%) Information Architecture
5 7 (28.00%) Migration
5 7 (28.00%) OO
5 7 (28.00%) SOA
6 3 (12.00%) Data Visualisation
6 3 (12.00%) Performance Tuning
6 3 (12.00%) Requirements Analysis
6 3 (12.00%) SDLC
6 3 (12.00%) Web Development
Programming Languages
1 17 (68.00%) SQL
2 9 (36.00%) T-SQL
3 6 (24.00%) JavaScript
4 3 (12.00%) C#
4 3 (12.00%) PHP
5 2 (8.00%) VBA
6 1 (4.00%) Data Analysis Expressions (DAX)
Qualifications
1 3 (12.00%) MCSE
1 3 (12.00%) Microsoft Certification
Quality Assurance & Compliance
1 3 (12.00%) QA
Vendors
1 15 (60.00%) Microsoft
2 7 (28.00%) Oracle
3 2 (8.00%) Cognos
3 2 (8.00%) SAP
Staines, Middlesex
Ortolan Group
Posted: 3 days ago