Period
to 23 November 2017

The following table provides summary statistics for contract job vacancies advertised in the South East with a requirement for OLAP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLAP over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Online Analytical Processing (OLAP)
England > South East
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 331 351 346
Rank change year-on-year +20 -5 -1
Contract jobs citing OLAP 45 30 57
As % of all contract IT jobs advertised in the South East 0.27% 0.18% 0.30%
As % of the Database & Business Intelligence category 1.28% 0.89% 1.31%
Number of daily rates quoted 26 24 36
South East median daily rate £395 £450 £369
Median daily rate % change year-on-year -12.22% +22.03% +1.03%
10th Percentile £317 £307 £241
90th Percentile £619 £525 £438
England median daily rate £475 £425 £425
% change year-on-year +11.76% - -
Number of hourly rates quoted 1 0 0
South East median hourly rate £55.00 - -
England median hourly rate £55.00 - -

OLAP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the South East with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
South East
Contract vacancies with a requirement for database or business intelligence skills 3524 3379 4339
As % of all contract IT jobs advertised in the South East 20.93% 20.26% 22.47%
Number of daily rates quoted 2237 2021 2566
South East median daily rate £413 £400 £375
Median daily rate % change year-on-year +3.13% +6.67% +7.14%
10th Percentile £295 £275 £263
90th Percentile £556 £538 £525
England median daily rate £460 £425 £413
% change year-on-year +8.24% +3.03% +3.13%
Number of hourly rates quoted 55 91 101
South East median hourly rate £42.50 £26.50 £27.50
Median hourly rate % change year-on-year +60.38% -3.64% +10.00%
10th Percentile £10.02 £9.25 £9.25
90th Percentile £50.00 £52.25 £48.75
England median hourly rate £32.00 £28.00 £27.50
% change year-on-year +14.29% +1.82% +11.11%

OLAP
Job Vacancy Trend in the South East

Job postings citing OLAP as a percentage of all IT jobs advertised in the South East.

Job vacancy trend for OLAP in the South East

OLAP
Contractor Daily Rate Trend in the South East

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing OLAP in the South East.

Contractor daily rate trend for OLAP in the South East

OLAP
Contractor Daily Rate Histogram in the South East

The daily rate distribution of IT jobs citing OLAP in the South East over the 6 months to 23 November 2017.

Contractor daily rate histogram for OLAP in the South East

OLAP
Contractor Hourly Rate Trend in the South East

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing OLAP in the South East.

Contractor hourly rate trend for OLAP in the South East

OLAP
Contract Job Locations in the South East

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the South East region over the 6 months to 23 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Thames Valley +3 19 £420 -9.58%
Hampshire +22 11 £650 +25.00% 1
Berkshire -2 8 £444 +17.24%
West Sussex -6 6 £339 +7.54% 2
Buckinghamshire -17 6 £415 -17.00%
Oxfordshire +3 5 £400 -20.79%
East Sussex - 4 £345 -
Surrey -12 3 - - 1
OLAP
England

For the 6 months to 23 November 2017, IT contractor jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the South East region with a requirement for OLAP.

1 43 (95.56%) SQL
2 33 (73.33%) Data Warehouse
3 27 (60.00%) SQL Server Integration Services
4 26 (57.78%) Agile Software Development
5 24 (53.33%) Business Intelligence
6 23 (51.11%) T-SQL
7 22 (48.89%) SQL Server
8 21 (46.67%) ETL
9 20 (44.44%) OLAP Cube
10 18 (40.00%) SQL Server Reporting Services
11 17 (37.78%) SQL Server Analysis Services
11 17 (37.78%) Microsoft
12 13 (28.89%) Waterfall
13 12 (26.67%) Oracle OLAP
13 12 (26.67%) Oracle
13 12 (26.67%) SQL Server 2012
14 11 (24.44%) Relational Database
14 11 (24.44%) Java
14 11 (24.44%) SAS
14 11 (24.44%) XML
14 11 (24.44%) RDBMS
14 11 (24.44%) Oracle BI EE
14 11 (24.44%) MDX
15 10 (22.22%) Release Management
15 10 (22.22%) Unix
15 10 (22.22%) Linux
15 10 (22.22%) SAS Data Integration Studio
16 9 (20.00%) SQL Server 2014
17 8 (17.78%) SQL Server 2016
17 8 (17.78%) Power BI

OLAP
Co-occurring IT Skills in the South East 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 (24.44%) SAS
2 5 (11.11%) IIS
3 4 (8.89%) SharePoint
Applications
1 4 (8.89%) Microsoft Excel
2 3 (6.67%) Microsoft Office
Business Applications
1 3 (6.67%) Cognos TM1
2 2 (4.44%) Cognos Business Intelligence
3 1 (2.22%) Dynamics AX
Cloud Services
1 8 (17.78%) Microsoft Azure
2 6 (13.33%) IaaS
2 6 (13.33%) PaaS
3 2 (4.44%) Azure Data Factory
4 1 (2.22%) Amazon AWS
4 1 (2.22%) Data Lake Analytics
Database & Business Intelligence
1 33 (73.33%) Data Warehouse
2 27 (60.00%) SQL Server Integration Services
3 22 (48.89%) SQL Server
4 20 (44.44%) OLAP Cube
5 18 (40.00%) SQL Server Reporting Services
6 17 (37.78%) SQL Server Analysis Services
7 12 (26.67%) Oracle OLAP
7 12 (26.67%) SQL Server 2012
8 11 (24.44%) Oracle BI EE
8 11 (24.44%) RDBMS
8 11 (24.44%) Relational Database
9 10 (22.22%) SAS Data Integration Studio
10 9 (20.00%) SQL Server 2014
11 8 (17.78%) Power BI
11 8 (17.78%) SQL Server 2016
12 7 (15.56%) SQL Server 2008
13 6 (13.33%) OLTP
14 5 (11.11%) MongoDB
15 4 (8.89%) BusinessObjects
16 3 (6.67%) SQL Server 2005
Development Applications
1 4 (8.89%) Visual Studio
2 3 (6.67%) Team Foundation Server
3 2 (4.44%) Git (software)
4 1 (2.22%) SQL Server Management Studio (SSMS)
General
1 7 (15.56%) Finance
Job Titles
1 35 (77.78%) Developer
2 20 (44.44%) SQL Developer
3 7 (15.56%) Systems Developer
4 6 (13.33%) SAS Developer
5 5 (11.11%) Business Intelligence Developer
5 5 (11.11%) SQL Server Developer
6 4 (8.89%) .NET Developer
6 4 (8.89%) Analyst
6 4 (8.89%) Consultant
7 3 (6.67%) Business Intelligence Analyst
7 3 (6.67%) Business Intelligence Consultant
7 3 (6.67%) ETL Developer
7 3 (6.67%) SQL BI Developer
7 3 (6.67%) SSIS Developer
8 2 (4.44%) Data Consultant
8 2 (4.44%) Excel Analyst
8 2 (4.44%) SQL Analyst
8 2 (4.44%) SQL BI Architect
8 2 (4.44%) SQL Reporting Analyst
8 2 (4.44%) SSRS Developer
Libraries, Frameworks & Software Standards
1 11 (24.44%) MDX
1 11 (24.44%) XML
2 8 (17.78%) .NET
3 5 (11.11%) Angular 2
3 5 (11.11%) AngularJS
3 5 (11.11%) CSS
3 5 (11.11%) REST
3 5 (11.11%) SOAP
3 5 (11.11%) Twitter Bootstrap
4 4 (8.89%) ASP.NET
4 4 (8.89%) ASP.NET MVC
4 4 (8.89%) HTML
4 4 (8.89%) Razor View Engine
5 1 (2.22%) OLE
5 1 (2.22%) OLE DB
Miscellaneous
1 6 (13.33%) Analytical Skills
2 4 (8.89%) N-Tier
3 2 (4.44%) Computer Science
4 1 (2.22%) Greenfield Project
4 1 (2.22%) Replication
4 1 (2.22%) RIA
Operating Systems
1 10 (22.22%) Linux
1 10 (22.22%) Unix
Processes & Methodologies
1 26 (57.78%) Agile Software Development
2 24 (53.33%) Business Intelligence
3 21 (46.67%) ETL
4 13 (28.89%) Waterfall
5 10 (22.22%) Release Management
6 8 (17.78%) System Testing
7 5 (11.11%) BDD
7 5 (11.11%) Continuous Delivery
7 5 (11.11%) Data Analysis
7 5 (11.11%) DevOps
7 5 (11.11%) Performance Tuning
8 4 (8.89%) Continuous Integration
8 4 (8.89%) Dashboard Development
8 4 (8.89%) Dependency Injection
8 4 (8.89%) Kimball Methodology
8 4 (8.89%) Refactoring
8 4 (8.89%) TDD
8 4 (8.89%) Test Automation
8 4 (8.89%) Unit Testing
8 4 (8.89%) Visualisation
Programming Languages
1 43 (95.56%) SQL
2 23 (51.11%) T-SQL
3 11 (24.44%) Java
4 8 (17.78%) C#
5 4 (8.89%) JavaScript
6 2 (4.44%) Data Analysis Expressions (DAX)
6 2 (4.44%) PowerShell
6 2 (4.44%) VBA
7 1 (2.22%) PL/SQL
7 1 (2.22%) Tcl
7 1 (2.22%) U-SQL
7 1 (2.22%) VB
7 1 (2.22%) VB.NET
Qualifications
1 3 (6.67%) Degree
2 1 (2.22%) BPSS Clearance
2 1 (2.22%) DBS Check
2 1 (2.22%) ISEB
2 1 (2.22%) Security Cleared
Quality Assurance & Compliance
1 2 (4.44%) Data Quality
System Software
1 6 (13.33%) Virtual Machines
2 5 (11.11%) Active Directory
2 5 (11.11%) VMware Infrastructure
Vendors
1 17 (37.78%) Microsoft
2 12 (26.67%) Oracle
3 5 (11.11%) SAP
3 5 (11.11%) Twitter
3 5 (11.11%) VMware
4 4 (8.89%) Tableau
5 3 (6.67%) Cognos