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

Location
3 months to
1 May 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 100 84 79
Rank change year-on-year
-16 -5
Permanent jobs citing OLAP 5 11 15
As % of all permanent IT jobs located in Nottingham 0.40% 1.08% 1.50%
As % of the Database & Business Intelligence category 1.14% 3.01% 3.56%
Number of salaries quoted 5 11 15
Average salary £40,000 £41,500 £38,500
Average salary % change year-on-year
-3.61% +7.79%
UK excluding London average salary £40,000 £41,500 £45,000
% change year-on-year
-3.61% -7.77%
OLAP
Nottinghamshire

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

Database & Business Intelligence Category
Nottingham
Permanent IT job ads with a match in the
Database & Business Intelligence category
439 366 421
As % of all permanent IT jobs located in Nottingham 34.70% 35.78% 42.10%
Number of salaries quoted 363 285 387
Average salary £41,500 £40,000 £37,500
Average salary % change year-on-year
+3.75% +6.66%
90% offered a salary of more than £27,500 £25,000 £30,000
10% offered a salary of more than £47,500 £45,000 £50,000
UK excluding London average salary £41,000 £40,000 £39,000
% change year-on-year
+2.50% +2.56%

OLAP
Jobs Demand Trend in Nottingham

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the Nottingham region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Nottingham

OLAP
Salary Trend in Nottingham

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

OLAP Salary Trend in Nottingham

OLAP
Top 30 Related IT Skills in Nottingham

For the 6 months to 1 May 2015, IT jobs across the Nottingham region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 9 (100.00%) Business Intelligence
2 8 (88.89%) ETL
2 8 (88.89%) SQL Server
2 8 (88.89%) SQL Server Integration Services
3 7 (77.78%) SQL
4 6 (66.67%) T-SQL
5 5 (55.56%) Data Warehouse
5 5 (55.56%) SQL Server Reporting Services
6 4 (44.44%) Disaster Recovery
6 4 (44.44%) SQL Server 2005
6 4 (44.44%) SQL Server Analysis Services
6 4 (44.44%) Performance Monitoring
7 3 (33.33%) SQL Server 2008
7 3 (33.33%) Performance Tuning
7 3 (33.33%) Windows
7 3 (33.33%) Microsoft
7 3 (33.33%) VLDB
7 3 (33.33%) Microsoft Certification
8 2 (22.22%) SharePoint
8 2 (22.22%) Data Security
8 2 (22.22%) Finance
8 2 (22.22%) Change Management
8 2 (22.22%) Data Analysis
8 2 (22.22%) Configuration Management
8 2 (22.22%) Microsoft Analysis Services
8 2 (22.22%) OLAP Cube
8 2 (22.22%) SC Cleared
8 2 (22.22%) Security Cleared
8 2 (22.22%) SQL Server 2012
8 2 (22.22%) Analytics

OLAP
Top Related IT Skills in Nottingham by Category

For the 6 months to 1 May 2015, IT jobs across the Nottingham region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 2 (22.22%) SharePoint
Applications
1 1 (11.11%) MS Excel
Cloud Services
1 1 (11.11%) Office 365
Database & Business Intelligence
1 8 (88.89%) SQL Server
1 8 (88.89%) SQL Server Integration Services
2 5 (55.56%) Data Warehouse
2 5 (55.56%) SQL Server Reporting Services
3 4 (44.44%) SQL Server 2005
3 4 (44.44%) SQL Server Analysis Services
4 3 (33.33%) SQL Server 2008
4 3 (33.33%) VLDB
5 2 (22.22%) Microsoft Analysis Services
5 2 (22.22%) OLAP Cube
5 2 (22.22%) SQL Server 2012
6 1 (11.11%) Oracle OLAP
6 1 (11.11%) Informix
General
1 2 (22.22%) Finance
1 2 (22.22%) Marketing
Job Titles
1 4 (44.44%) DBA
1 4 (44.44%) SQL DBA
1 4 (44.44%) SQL Server DBA
2 3 (33.33%) Developer
3 2 (22.22%) Consultant
3 2 (22.22%) Business Intelligence Consultant
4 1 (11.11%) Data Consultant
4 1 (11.11%) Microsoft BI Consultant
4 1 (11.11%) Business Intelligence Developer
4 1 (11.11%) SQL Server Developer
4 1 (11.11%) Microsoft Consultant
4 1 (11.11%) Data Warehouse Consultant
4 1 (11.11%) Business Consultant
4 1 (11.11%) Database Developer
4 1 (11.11%) SQL Developer
Miscellaneous
1 1 (11.11%) Analytical Skills
Operating Systems
1 3 (33.33%) Windows
2 1 (11.11%) UNIX
Processes & Methodologies
1 9 (100.00%) Business Intelligence
2 8 (88.89%) ETL
3 4 (44.44%) Disaster Recovery
3 4 (44.44%) Performance Monitoring
4 3 (33.33%) Performance Tuning
5 2 (22.22%) Data Security
5 2 (22.22%) Change Management
5 2 (22.22%) Data Analysis
5 2 (22.22%) Configuration Management
5 2 (22.22%) Analytics
5 2 (22.22%) Web Analytics
5 2 (22.22%) Search Engine Marketing
5 2 (22.22%) Release Management
6 1 (11.11%) Migration
6 1 (11.11%) Data Modelling
Programming Languages
1 7 (77.78%) SQL
2 6 (66.67%) T-SQL
3 1 (11.11%) Shell Script
Qualifications
1 3 (33.33%) Microsoft Certification
2 2 (22.22%) SC Cleared
2 2 (22.22%) Security Cleared
Quality Assurance & Compliance
1 2 (22.22%) QA
Vendors
1 3 (33.33%) Microsoft
2 1 (11.11%) Oracle