The following table provides summary statistics for contract job vacancies advertised in Manchester with a requirement for OLAP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLAP over the 3 months to 30 March 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)
North West / Manchester
3 months to
30 Mar 2017
Same period 2016 Same period 2015
Rank 84 100 89
Rank change year-on-year +16 -11  
Contract jobs citing OLAP 3 2 8
As % of all contract IT jobs advertised in Manchester 0.23% 0.11% 0.49%
As % of the Database & Business Intelligence category 0.89% 0.65% 2.32%
Number of daily rates quoted 3 1 4
Median daily rate £388 £350 £375
Median daily rate % change year-on-year +10.71% -6.66%  
90% offered a daily rate of more than £348 £350 £333
10% offered a daily rate of more than £418 £350 £435
UK excluding London median daily rate £431 £400 £415
% change year-on-year +7.81% -3.61%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Manchester with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
Manchester
Contract job vacancies with a requirement for database and business intelligence skills 338 308 345
As % of all contract IT job vacancies advertised in Manchester 25.53% 17.14% 21.26%
Number of daily rates quoted 213 187 186
Median daily rate £375 £375 £350
Median daily rate % change year-on-year - +7.14%  
90% offered a daily rate of more than £275 £275 £275
10% offered a daily rate of more than £500 £500 £500
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.22% +3.33%  
Number of hourly rates quoted 2 2 3
Median hourly rate £35.00 £17.00 £25.00
Median hourly rate % change year-on-year +105.88% -32.00%  
UK excluding London median hourly rate £35.00 £32.50 £32.50
% change year-on-year +7.69% -  

OLAP
Job Vacancy Trend in Manchester

The job posting trend of jobs advertised in Manchester citing OLAP as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLAP in Manchester

OLAP
Contractor Daily Rate Trend in Manchester

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

Contractor daily rate trend for OLAP in Manchester

OLAP
Contractor Hourly Rate Trend in Manchester

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

Contractor hourly rate trend for OLAP in Manchester

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

1 5 (71.43%) SQL
1 5 (71.43%) Business Intelligence
2 4 (57.14%) Finance
2 4 (57.14%) OLAP Cube
3 3 (42.86%) Oracle OLAP
3 3 (42.86%) ETL
3 3 (42.86%) Oracle
3 3 (42.86%) SQL Server
4 2 (28.57%) Oracle Reports
4 2 (28.57%) Oracle Financials
4 2 (28.57%) Data Warehouse
4 2 (28.57%) Oracle EBS
4 2 (28.57%) Validation
4 2 (28.57%) SQL Server Integration Services
4 2 (28.57%) MDX
4 2 (28.57%) User Acceptance Testing
4 2 (28.57%) SQL Server Analysis Services
4 2 (28.57%) Oracle BI EE
4 2 (28.57%) Oracle Payables
4 2 (28.57%) Oracle Receivables
4 2 (28.57%) Spreadsheet
4 2 (28.57%) Oracle General Ledger
4 2 (28.57%) Trend Analysis
4 2 (28.57%) Data Quality
5 1 (14.29%) SQL Server 2012
5 1 (14.29%) Kimball Methodology
5 1 (14.29%) Analytics
5 1 (14.29%) Cybersecurity
5 1 (14.29%) Relational Database
5 1 (14.29%) SAS Data Integration Studio

OLAP
Co-occurring IT Skills in Manchester 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 1 (14.29%) SAS
Applications
1 2 (28.57%) Spreadsheet
Business Applications
1 2 (28.57%) Oracle EBS
1 2 (28.57%) Oracle Financials
1 2 (28.57%) Oracle General Ledger
1 2 (28.57%) Oracle Payables
1 2 (28.57%) Oracle Receivables
Database & Business Intelligence
1 4 (57.14%) OLAP Cube
2 3 (42.86%) Oracle OLAP
2 3 (42.86%) SQL Server
3 2 (28.57%) Data Warehouse
3 2 (28.57%) Oracle BI EE
3 2 (28.57%) Oracle Reports
3 2 (28.57%) SQL Server Analysis Services
3 2 (28.57%) SQL Server Integration Services
4 1 (14.29%) BusinessObjects
4 1 (14.29%) BusinessObjects Business Intelligence
4 1 (14.29%) Microsoft Analysis Services
4 1 (14.29%) RDBMS
4 1 (14.29%) Relational Database
4 1 (14.29%) SAP BW
4 1 (14.29%) SAS Data Integration Studio
4 1 (14.29%) SQL Server 2000
4 1 (14.29%) SQL Server 2005
4 1 (14.29%) SQL Server 2012
4 1 (14.29%) SQL Server 2014
4 1 (14.29%) SQL Server Reporting Services
General
1 4 (57.14%) Finance
Job Titles
1 4 (57.14%) Developer
2 2 (28.57%) Analyst
2 2 (28.57%) Business Intelligence Developer
2 2 (28.57%) Report Analyst
3 1 (14.29%) Data Warehouse Developer
3 1 (14.29%) ETL Developer
3 1 (14.29%) Microsoft BI Developer
3 1 (14.29%) Microsoft Developer
3 1 (14.29%) SAS Developer
3 1 (14.29%) SQL Developer
3 1 (14.29%) SQL Server Developer
3 1 (14.29%) SSAS Developer
3 1 (14.29%) SSIS Developer
3 1 (14.29%) SSRS Developer
Libraries, Frameworks & Software Standards
1 2 (28.57%) MDX
Miscellaneous
1 1 (14.29%) Analytical Skills
Processes & Methodologies
1 5 (71.43%) Business Intelligence
2 3 (42.86%) ETL
3 2 (28.57%) Trend Analysis
3 2 (28.57%) User Acceptance Testing
3 2 (28.57%) Validation
4 1 (14.29%) Analytics
4 1 (14.29%) Cybersecurity
4 1 (14.29%) Data Migration
4 1 (14.29%) Kimball Methodology
4 1 (14.29%) Migration
4 1 (14.29%) Project Management
4 1 (14.29%) Web Analytics
Programming Languages
1 5 (71.43%) SQL
2 1 (14.29%) C#
2 1 (14.29%) T-SQL
Quality Assurance & Compliance
1 2 (28.57%) Data Quality
Vendors
1 3 (42.86%) Oracle
2 1 (14.29%) Cognos
2 1 (14.29%) Microsoft
2 1 (14.29%) SAP