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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 125 128 123
Rank change year-on-year
+3 -5
Permanent jobs citing OLAP 4 3 17
As % of all permanent IT jobs located in Cambridgeshire 0.23% 0.14% 0.70%
As % of the Database & Business Intelligence category 0.83% 0.48% 2.62%
Number of salaries quoted 4 3 17
Median salary £50,000 £37,500 £40,500
Median salary % change year-on-year
+33.33% -7.40%
90% offered a salary of more than £34,600 £33,500 £27,500
10% offered a salary of more than £51,750 £43,500 £60,000
UK excluding London median salary £48,750 £42,500 £42,500
% change year-on-year
+14.70% -
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
484 627 650
As % of all permanent IT jobs located in Cambridgeshire 28.01% 29.73% 26.64%
Number of salaries quoted 401 591 530
Median salary £42,500 £45,000 £40,750
Median salary % change year-on-year
-5.55% +10.42%
90% offered a salary of more than £30,000 £32,500 £30,000
10% offered a salary of more than £57,500 £55,000 £60,000
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 26 September 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 26 September 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 +6 1 £28,000 -32.12%
OLAP
East of England

OLAP
Top 30 Related IT Skills in Cambridgeshire

For the 6 months to 26 September 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 7 (77.78%) T-SQL
1 7 (77.78%) SQL Server
1 7 (77.78%) Microsoft
2 5 (55.56%) Data Warehouse
2 5 (55.56%) Business Intelligence
2 5 (55.56%) Analytical Skills
3 4 (44.44%) Analytics
3 4 (44.44%) iPad
3 4 (44.44%) SQL Server Reporting Services
3 4 (44.44%) SQL Server Integration Services
3 4 (44.44%) Crystal Reports
3 4 (44.44%) SQL
3 4 (44.44%) ITIL
4 3 (33.33%) Tableau
4 3 (33.33%) Big Data
4 3 (33.33%) QlikView
4 3 (33.33%) SQL Server Analysis Services
4 3 (33.33%) SQL Server 2008
4 3 (33.33%) Hadoop
4 3 (33.33%) Power BI
5 2 (22.22%) HTTP
5 2 (22.22%) COM
6 1 (11.11%) Cognos
6 1 (11.11%) JDE OneWorld
6 1 (11.11%) Oracle
6 1 (11.11%) ERP
6 1 (11.11%) Data Modelling
6 1 (11.11%) ETL
6 1 (11.11%) Oracle Certification
6 1 (11.11%) JD Edwards

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 (11.11%) Cognos TM1
1 1 (11.11%) JDE OneWorld
Communications & Networking
1 2 (22.22%) HTTP
Database & Business Intelligence
1 7 (77.78%) SQL Server
2 5 (55.56%) Data Warehouse
3 4 (44.44%) Crystal Reports
3 4 (44.44%) SQL Server Integration Services
3 4 (44.44%) SQL Server Reporting Services
4 3 (33.33%) Big Data
4 3 (33.33%) Hadoop
4 3 (33.33%) Power BI
4 3 (33.33%) QlikView
4 3 (33.33%) SQL Server 2008
4 3 (33.33%) SQL Server Analysis Services
5 1 (11.11%) OLAP Cube
5 1 (11.11%) Oracle OLAP
Job Titles
1 4 (44.44%) Analyst
1 4 (44.44%) Applications Support
1 4 (44.44%) Applications Support Analyst
1 4 (44.44%) SQL Analyst
1 4 (44.44%) SQL Support Analyst
1 4 (44.44%) Support Analyst
2 3 (33.33%) Business Intelligence Developer
2 3 (33.33%) Developer
2 3 (33.33%) Microsoft BI Developer
2 3 (33.33%) Microsoft Developer
3 1 (11.11%) Architect
3 1 (11.11%) Business Architect
3 1 (11.11%) ERP Manager
3 1 (11.11%) IT Manager
3 1 (11.11%) MIS Architect
3 1 (11.11%) Systems Manager
Libraries, Frameworks & Software Standards
1 2 (22.22%) COM
Miscellaneous
1 5 (55.56%) Analytical Skills
2 4 (44.44%) iPad
3 1 (11.11%) Data Integration
3 1 (11.11%) Data Structures
Processes & Methodologies
1 5 (55.56%) Business Intelligence
2 4 (44.44%) Analytics
2 4 (44.44%) ITIL
3 1 (11.11%) Agile Software Development
3 1 (11.11%) Business Analytics
3 1 (11.11%) Data Modelling
3 1 (11.11%) ERP
3 1 (11.11%) ETL
3 1 (11.11%) Mentoring
3 1 (11.11%) Statistical Analysis
Programming Languages
1 7 (77.78%) T-SQL
2 4 (44.44%) SQL
Qualifications
1 1 (11.11%) Degree
1 1 (11.11%) Oracle Certification
Vendors
1 7 (77.78%) Microsoft
2 3 (33.33%) Tableau
3 1 (11.11%) Cognos
3 1 (11.11%) JD Edwards
3 1 (11.11%) Oracle