Period
to 21 November 2017

The following table provides summary statistics for contract job vacancies 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 21 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)
UK
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 627 619 506
Rank change year-on-year -8 -113 -5
Contract jobs citing OLAP 259 272 424
As % of all contract IT jobs advertised in the UK 0.25% 0.26% 0.37%
As % of the Database & Business Intelligence category 1.14% 1.15% 1.60%
Number of daily rates quoted 181 207 316
UK median daily rate £475 £425 £425
Median daily rate % change year-on-year +11.76% - -
10th Percentile £345 £308 £300
90th Percentile £650 £588 £575
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 1 0 0
UK median hourly rate £55.00 - -
UK excluding London 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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 22785 23660 26437
As % of all contract IT jobs advertised in the UK 22.09% 22.59% 23.28%
Number of daily rates quoted 15575 15682 17425
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +0.63%
10th Percentile £310 £285 £269
90th Percentile £625 £600 £575
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 288 368 408
UK median hourly rate £31.23 £28.00 £28.50
Median hourly rate % change year-on-year +11.54% -1.75% +14.00%
10th Percentile £14.00 £10.00 £12.00
90th Percentile £57.44 £52.05 £52.47
UK excluding London median hourly rate £35.00 £28.00 £30.00
% change year-on-year +25.00% -6.67% +31.32%

OLAP
Job Vacancy Trend

Job postings citing OLAP as a percentage of all IT jobs advertised.

Job vacancy trend for OLAP in the UK

OLAP
Contractor Daily Rate Trend

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

Contractor daily rate trend for OLAP in the UK

OLAP
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing OLAP over the 6 months to 21 November 2017.

Contractor daily rate histogram for OLAP in the UK

OLAP
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for OLAP in the UK

OLAP
Top 14 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the UK over the 6 months to 21 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
England +11 256 £475 +11.76% 38
London +26 145 £525 +10.53% 15
UK excluding London -37 110 £400 - 24
South East +14 44 £390 -13.33% 5
North of England +11 33 £425 +5.92% 13
Midlands +20 22 £400 +23.08% 3
Yorkshire +15 22 £350 -6.67% 4
West Midlands +24 20 £400 +23.08% 1
North West +1 10 £538 +7.50% 5
East of England -10 7 - - 2
East Midlands -2 2 £390 +6.85% 2
Scotland -8 2 £350 +16.18% 1
South West -26 2 £475 +17.28%
North East +53 1 £438 +16.67% 4

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

1 161 (62.16%) SQL
2 157 (60.62%) Business Intelligence
3 150 (57.92%) SQL Server
4 141 (54.44%) Data Warehouse
5 138 (53.28%) ETL
6 129 (49.81%) SQL Server Integration Services
7 121 (46.72%) Microsoft
8 110 (42.47%) SQL Server Analysis Services
9 104 (40.15%) SQL Server Reporting Services
10 85 (32.82%) Finance
11 79 (30.50%) Agile Software Development
12 73 (28.19%) T-SQL
13 72 (27.80%) MDX
13 72 (27.80%) OLAP Cube
14 63 (24.32%) Data Modelling
15 58 (22.39%) Kimball Methodology
16 54 (20.85%) C#
17 53 (20.46%) Oracle
17 53 (20.46%) Oracle OLAP
18 51 (19.69%) Power BI
19 49 (18.92%) Java
20 47 (18.15%) Analytics
21 46 (17.76%) SQL Server 2008
22 43 (16.60%) SQL Server 2012
23 42 (16.22%) Banking
24 40 (15.44%) Performance Tuning
25 39 (15.06%) Analytical Skills
26 38 (14.67%) Migration
27 37 (14.29%) JavaScript
28 36 (13.90%) OLTP

OLAP
Co-occurring IT Skills 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 20 (7.72%) SAS
2 13 (5.02%) SharePoint
3 10 (3.86%) ArcGIS
4 7 (2.70%) Apache Spark
4 7 (2.70%) IIS
5 5 (1.93%) Apache
6 2 (0.77%) SharePoint 2010
7 1 (0.39%) Apache Pig
7 1 (0.39%) Exchange Server 2007
7 1 (0.39%) Exchange Server 2013
7 1 (0.39%) MS Exchange
7 1 (0.39%) Oracle 10gAS
7 1 (0.39%) Oracle Application Server
Applications
1 32 (12.36%) Microsoft Excel
2 7 (2.70%) Microsoft Office
3 6 (2.32%) Microsoft PowerPoint
4 5 (1.93%) MS Visio
5 2 (0.77%) Spreadsheet
6 1 (0.39%) Microsoft Project
Business Applications
1 9 (3.47%) ION MarketView
2 6 (2.32%) Cognos TM1
3 5 (1.93%) Cognos Business Intelligence
3 5 (1.93%) Dynamics AX
4 3 (1.16%) Cognos Planning
4 3 (1.16%) Dynamics CRM
5 2 (0.77%) Oracle Retail
5 2 (0.77%) SAP R/3
Cloud Services
1 33 (12.74%) Microsoft Azure
2 13 (5.02%) Amazon AWS
3 7 (2.70%) IaaS
3 7 (2.70%) PaaS
4 4 (1.54%) Dynamics 365
5 2 (0.77%) Azure Data Factory
5 2 (0.77%) SaaS
6 1 (0.39%) Cloud Computing
6 1 (0.39%) Data Lake Analytics
Communications & Networking
1 6 (2.32%) Extranet
1 6 (2.32%) Intranet
2 5 (1.93%) DNS
2 5 (1.93%) Firewall
3 1 (0.39%) Kerberos
3 1 (0.39%) SMS
Database & Business Intelligence
1 150 (57.92%) SQL Server
2 141 (54.44%) Data Warehouse
3 129 (49.81%) SQL Server Integration Services
4 110 (42.47%) SQL Server Analysis Services
5 104 (40.15%) SQL Server Reporting Services
6 72 (27.80%) OLAP Cube
7 53 (20.46%) Oracle OLAP
8 51 (19.69%) Power BI
9 46 (17.76%) SQL Server 2008
10 43 (16.60%) SQL Server 2012
11 36 (13.90%) OLTP
11 36 (13.90%) SQL Server 2016
12 31 (11.97%) Relational Database
13 26 (10.04%) Microsoft Analysis Services
14 23 (8.88%) SQL Server 2014
15 20 (7.72%) Oracle BI EE
16 19 (7.34%) Oracle Database
16 19 (7.34%) PowerPivot
17 18 (6.95%) BusinessObjects
17 18 (6.95%) RDBMS
Development Applications
1 24 (9.27%) Visual Studio
2 16 (6.18%) Team Foundation Server
3 9 (3.47%) JIRA
4 8 (3.09%) Subversion
5 7 (2.70%) ERwin
5 7 (2.70%) Git (software)
6 6 (2.32%) Bitbucket
6 6 (2.32%) Octopus Deploy
7 5 (1.93%) TeamCity
8 3 (1.16%) Toad
9 2 (0.77%) SQL Server Management Studio (SSMS)
10 1 (0.39%) Cucumber
10 1 (0.39%) Eclipse
General
1 85 (32.82%) Finance
2 42 (16.22%) Banking
3 19 (7.34%) Front Office
4 17 (6.56%) Investment Banking
5 10 (3.86%) Back Office
6 9 (3.47%) Retail
7 6 (2.32%) Publishing
8 5 (1.93%) Marketing
8 5 (1.93%) Retail Banking
9 4 (1.54%) Telecoms
10 3 (1.16%) Electronics
10 3 (1.16%) Manufacturing
11 1 (0.39%) Advertising
11 1 (0.39%) Dutch Language
11 1 (0.39%) Legal
11 1 (0.39%) Local Government
Job Titles
1 177 (68.34%) Developer
2 61 (23.55%) Business Intelligence Developer
3 57 (22.01%) SQL Developer
4 26 (10.04%) SSAS Developer
5 24 (9.27%) Analyst
6 23 (8.88%) Senior Developer
7 21 (8.11%) JavaScript Developer
8 19 (7.34%) Architect
8 19 (7.34%) SSIS Developer
9 18 (6.95%) Data Warehouse Developer
9 18 (6.95%) DBA
9 18 (6.95%) ETL Developer
10 17 (6.56%) SQL BI Developer
10 17 (6.56%) SQL Server Developer
11 16 (6.18%) C# Developer
12 14 (5.41%) Business Intelligence Analyst
13 12 (4.63%) Business Developer
14 11 (4.25%) Consultant
14 11 (4.25%) HTML Developer
14 11 (4.25%) Oracle DBA
Libraries, Frameworks & Software Standards
1 72 (27.80%) MDX
2 35 (13.51%) .NET
3 34 (13.13%) XML
4 21 (8.11%) HTML
5 17 (6.56%) AngularJS
6 16 (6.18%) XSD
6 16 (6.18%) XSLT
7 15 (5.79%) HTML5
7 15 (5.79%) Web Services
8 13 (5.02%) Node.js
9 12 (4.63%) SOAP
10 10 (3.86%) Kendo UI
11 9 (3.47%) D3.js
12 8 (3.09%) ASP.NET
12 8 (3.09%) CSS
13 7 (2.70%) REST
14 6 (2.32%) Angular 2
14 6 (2.32%) JSON
14 6 (2.32%) Kafka
14 6 (2.32%) Twitter Bootstrap
Miscellaneous
1 39 (15.06%) Analytical Skills
2 21 (8.11%) Fixed Income
3 11 (4.25%) Greenfield Project
4 10 (3.86%) Foreign Exchange (FX)
5 8 (3.09%) Hedge funds
6 6 (2.32%) Market Risk
7 5 (1.93%) Computer Science
7 5 (1.93%) Data Centre
7 5 (1.93%) N-Tier
7 5 (1.93%) Reference Data
7 5 (1.93%) Reinsurance
8 4 (1.54%) Credit Risk
8 4 (1.54%) Equities
8 4 (1.54%) Replication
9 2 (0.77%) Clustering
9 2 (0.77%) Data Structures
9 2 (0.77%) User Experience
10 1 (0.39%) Grid Computing
10 1 (0.39%) IBM Mainframe
10 1 (0.39%) RIA
Operating Systems
1 27 (10.42%) Linux
2 21 (8.11%) Unix
3 8 (3.09%) Windows
4 4 (1.54%) Red Hat Enterprise Linux
5 2 (0.77%) Windows Server
6 1 (0.39%) HPUX
6 1 (0.39%) Windows 10
6 1 (0.39%) Windows 7
6 1 (0.39%) Windows Server 2003
6 1 (0.39%) Windows Server 2008
6 1 (0.39%) Windows Server 2012
Processes & Methodologies
1 157 (60.62%) Business Intelligence
2 138 (53.28%) ETL
3 79 (30.50%) Agile Software Development
4 63 (24.32%) Data Modelling
5 58 (22.39%) Kimball Methodology
6 47 (18.15%) Analytics
7 40 (15.44%) Performance Tuning
8 38 (14.67%) Migration
9 31 (11.97%) Dimensional Modelling
10 27 (10.42%) Data Analysis
11 24 (9.27%) Visualisation
12 23 (8.88%) Scrum
13 22 (8.49%) Continuous Integration
14 20 (7.72%) Data Visualisation
14 20 (7.72%) ETL Development
15 18 (6.95%) Data Integration
16 17 (6.56%) Data Management
17 16 (6.18%) DevOps
17 16 (6.18%) Open Source
17 16 (6.18%) User Acceptance Testing
Programming Languages
1 161 (62.16%) SQL
2 73 (28.19%) T-SQL
3 54 (20.85%) C#
4 49 (18.92%) Java
5 37 (14.29%) JavaScript
6 22 (8.49%) Data Analysis Expressions (DAX)
7 15 (5.79%) Python
8 13 (5.02%) PL/SQL
9 10 (3.86%) PowerShell
10 8 (3.09%) Lisp
11 7 (2.70%) Shell Script
12 5 (1.93%) VB.NET
13 4 (1.54%) C
13 4 (1.54%) VB
14 3 (1.16%) R
14 3 (1.16%) VBA
14 3 (1.16%) XPath
15 2 (0.77%) ABAP
15 2 (0.77%) SAS Macro
16 1 (0.39%) Tcl
Qualifications
1 15 (5.79%) Security Cleared
2 13 (5.02%) SC Cleared
3 12 (4.63%) Degree
4 8 (3.09%) MCSE
4 8 (3.09%) Microsoft Certification
5 6 (2.32%) MCITP
6 3 (1.16%) ISEB
7 2 (0.77%) BPSS Clearance
7 2 (0.77%) MCSA
8 1 (0.39%) Computer Science Degree
8 1 (0.39%) DBS Check
8 1 (0.39%) Numerate Degree
Quality Assurance & Compliance
1 12 (4.63%) QA
2 10 (3.86%) Data Quality
3 1 (0.39%) Cyber Essentials
3 1 (0.39%) Cyber Essentials PLUS
3 1 (0.39%) GDPR
3 1 (0.39%) PCI DSS
3 1 (0.39%) Solvency II
System Software
1 13 (5.02%) Docker
2 12 (4.63%) Active Directory
3 11 (4.25%) VMware Infrastructure
4 7 (2.70%) Virtual Machines
5 4 (1.54%) Oracle RAC
6 1 (0.39%) HDFS
6 1 (0.39%) Hyper-V
Systems Management
1 13 (5.02%) Data Guard
2 11 (4.25%) Oracle RMAN
3 10 (3.86%) Oracle EDQ
4 1 (0.39%) Enterprise Manager Cloud Control
4 1 (0.39%) Oracle Enterprise Manager
4 1 (0.39%) Oracle Identity Management
4 1 (0.39%) Oracle Identity Manager
4 1 (0.39%) Symantec Enterprise Vault
Vendors
1 121 (46.72%) Microsoft
2 53 (20.46%) Oracle
3 35 (13.51%) Tableau
4 27 (10.42%) Cognos
5 16 (6.18%) IBM
6 11 (4.25%) SAP
6 11 (4.25%) VMware
7 10 (3.86%) Red Hat
8 9 (3.47%) ION Trading
9 8 (3.09%) RedGate
10 6 (2.32%) Informatica
10 6 (2.32%) Jaspersoft
10 6 (2.32%) Twitter
11 5 (1.93%) InterSystems
11 5 (1.93%) Netezza
11 5 (1.93%) Sencha
12 3 (1.16%) EnterpriseDB
13 2 (0.77%) JD Edwards
13 2 (0.77%) Salesforce.com
13 2 (0.77%) Teradata