The table below looks at the statistics for OLAP skills in IT jobs advertised for the Cambridgeshire region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 27 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 118 127 123
Rank change year-on-year
+9 -4
Permanent jobs citing OLAP 9 5 22
As % of all permanent IT jobs located in Cambridgeshire 0.49% 0.24% 0.88%
As % of the Database & Business Intelligence category 1.80% 0.78% 3.13%
Number of salaries quoted 9 5 22
Median salary £47,500 £37,500 £40,500
Median salary % change year-on-year
+26.66% -7.40%
90% offered a salary of more than £27,700 £32,500 £30,000
10% offered a salary of more than £50,500 £45,000 £60,000
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
OLAP
East of England

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 Cambridgeshire region.

Database & Business Intelligence Category
Cambridgeshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
501 641 703
As % of all permanent IT jobs located in Cambridgeshire 27.50% 30.73% 28.28%
Number of salaries quoted 432 599 580
Median salary £42,500 £45,000 £41,500
Median salary % change year-on-year
-5.55% +8.43%
90% offered a salary of more than £30,000 £32,500 £30,000
10% offered a salary of more than £60,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Cambridgeshire

The demand trend of job ads across the Cambridgeshire region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Cambridgeshire

OLAP
Salary Trend in Cambridgeshire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the Cambridgeshire region.

OLAP Salary Trend in Cambridgeshire

OLAP
Salary Histogram in Cambridgeshire

This chart provides a salary histogram for IT jobs citing OLAP across the Cambridgeshire region over the 3 months to 27 August 2016.

OLAP Salary Histogram in Cambridgeshire

OLAP
Job Locations in Cambridgeshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Cambridgeshire region over the 3 months to 27 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
Cambridge +10 6 £29,000 -22.66%
OLAP
East of England

OLAP
Top 30 Related IT Skills in Cambridgeshire

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

1 8 (80.00%) T-SQL
1 8 (80.00%) SQL Server
1 8 (80.00%) Microsoft
2 5 (50.00%) Data Warehouse
2 5 (50.00%) Crystal Reports
2 5 (50.00%) SQL
2 5 (50.00%) Business Intelligence
2 5 (50.00%) Analytical Skills
3 4 (40.00%) SQL Server Integration Services
3 4 (40.00%) iPad
3 4 (40.00%) Analytics
3 4 (40.00%) SQL Server Reporting Services
3 4 (40.00%) ITIL
4 3 (30.00%) Hadoop
4 3 (30.00%) Tableau
4 3 (30.00%) Big Data
4 3 (30.00%) QlikView
4 3 (30.00%) SQL Server Analysis Services
4 3 (30.00%) SQL Server 2008
4 3 (30.00%) Power BI
5 2 (20.00%) Degree
5 2 (20.00%) Mentoring
5 2 (20.00%) HTTP
5 2 (20.00%) COM
6 1 (10.00%) CRM
6 1 (10.00%) Cognos
6 1 (10.00%) JDE OneWorld
6 1 (10.00%) Oracle
6 1 (10.00%) ERP
6 1 (10.00%) Data Modelling

OLAP
Top Related IT Skills in Cambridgeshire 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:

Business Applications
1 1 (10.00%) Cognos TM1
1 1 (10.00%) JDE OneWorld
Communications & Networking
1 2 (20.00%) HTTP
Database & Business Intelligence
1 8 (80.00%) SQL Server
2 5 (50.00%) Crystal Reports
2 5 (50.00%) Data Warehouse
3 4 (40.00%) SQL Server Integration Services
3 4 (40.00%) SQL Server Reporting Services
4 3 (30.00%) Big Data
4 3 (30.00%) Hadoop
4 3 (30.00%) Power BI
4 3 (30.00%) QlikView
4 3 (30.00%) SQL Server 2008
4 3 (30.00%) SQL Server Analysis Services
5 1 (10.00%) OLAP Cube
5 1 (10.00%) Oracle OLAP
Job Titles
1 5 (50.00%) Applications Support
2 4 (40.00%) Analyst
2 4 (40.00%) Applications Support Analyst
2 4 (40.00%) SQL Analyst
2 4 (40.00%) SQL Support Analyst
2 4 (40.00%) Support Analyst
3 3 (30.00%) Business Intelligence Developer
3 3 (30.00%) Developer
3 3 (30.00%) Microsoft BI Developer
3 3 (30.00%) Microsoft Developer
4 1 (10.00%) Applications Engineer
4 1 (10.00%) Applications Support Engineer
4 1 (10.00%) Architect
4 1 (10.00%) Business Architect
4 1 (10.00%) ERP Manager
4 1 (10.00%) IT Manager
4 1 (10.00%) MIS Architect
4 1 (10.00%) Support Engineer
4 1 (10.00%) Systems Manager
Libraries, Frameworks & Software Standards
1 2 (20.00%) COM
Miscellaneous
1 5 (50.00%) Analytical Skills
2 4 (40.00%) iPad
3 1 (10.00%) Computer Science
3 1 (10.00%) Data Integration
3 1 (10.00%) Data Structures
Processes & Methodologies
1 5 (50.00%) Business Intelligence
2 4 (40.00%) Analytics
2 4 (40.00%) ITIL
3 2 (20.00%) Mentoring
4 1 (10.00%) Agile Software Development
4 1 (10.00%) Business Analytics
4 1 (10.00%) CRM
4 1 (10.00%) Data Modelling
4 1 (10.00%) ERP
4 1 (10.00%) ETL
4 1 (10.00%) Statistical Analysis
Programming Languages
1 8 (80.00%) T-SQL
2 5 (50.00%) SQL
Qualifications
1 2 (20.00%) Degree
2 1 (10.00%) Oracle Certification
Vendors
1 8 (80.00%) Microsoft
2 3 (30.00%) Tableau
3 1 (10.00%) Cognos
3 1 (10.00%) JD Edwards
3 1 (10.00%) Oracle