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

Location
3 months to
29 Aug 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 90 - 72
Rank change year-on-year
- 0
Permanent jobs citing OLAP 6 0 12
As % of all permanent IT jobs located in Milton Keynes 0.52% - 1.32%
As % of the Database & Business Intelligence category 1.56% - 5.06%
Number of salaries quoted 5 0 12
Average salary £50,000 - £39,000
UK excluding London average salary £45,000 £40,000 £40,000
% change year-on-year
+12.50% -
OLAP
Buckinghamshire

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 Milton Keynes region.

Database & Business Intelligence Category
Milton Keynes
Permanent IT job ads with a match in the
Database & Business Intelligence category
384 336 237
As % of all permanent IT jobs located in Milton Keynes 33.60% 36.84% 26.07%
Number of salaries quoted 333 306 204
Average salary £42,500 £42,500 £39,000
Average salary % change year-on-year
- +8.97%
90% offered a salary of more than £28,000 £27,500 £21,250
10% offered a salary of more than £50,000 £45,000 £55,000
UK excluding London average salary £40,000 £40,000 £38,750
% change year-on-year
- +3.22%

OLAP
Jobs Demand Trend in Milton Keynes

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

OLAP Jobs Demand Trend in Milton Keynes

OLAP
Salary Trend in Milton Keynes

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

OLAP Salary Trend in Milton Keynes

OLAP
Top 30 Related IT Skills in Milton Keynes

For the 6 months to 29 August 2014, IT jobs across the Milton Keynes 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 (60.00%) Data Warehouse
1 9 (60.00%) Business Intelligence
2 7 (46.67%) SQL
3 6 (40.00%) Data Modelling
3 6 (40.00%) Relational Database
4 5 (33.33%) Waterfall
4 5 (33.33%) Big Data
4 5 (33.33%) HL7
4 5 (33.33%) RDBMS
4 5 (33.33%) XML
5 4 (26.67%) SQL Server
6 3 (20.00%) SQL Server Integration Services
6 3 (20.00%) SQL Server Reporting Services
6 3 (20.00%) Finance
6 3 (20.00%) Data Extraction
6 3 (20.00%) Kimball Methodology
6 3 (20.00%) ACCA
6 3 (20.00%) CIMA
6 3 (20.00%) Crystal Reports
6 3 (20.00%) Business Objects
6 3 (20.00%) IIS
6 3 (20.00%) OLTP
7 2 (13.33%) ETL
7 2 (13.33%) Client/Server
7 2 (13.33%) Python
7 2 (13.33%) Snowflake Schema
7 2 (13.33%) Star Schema
7 2 (13.33%) Microsoft
7 2 (13.33%) Performance Tuning
7 2 (13.33%) SQL Server Analysis Services

OLAP
Top Related IT Skills in Milton Keynes by Category

For the 6 months to 29 August 2014, IT jobs across the Milton Keynes 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 3 (20.00%) IIS
2 1 (6.67%) SAS
Database & Business Intelligence
1 9 (60.00%) Data Warehouse
2 6 (40.00%) Relational Database
3 5 (33.33%) Big Data
3 5 (33.33%) RDBMS
4 4 (26.67%) SQL Server
5 3 (20.00%) Crystal Reports
5 3 (20.00%) OLTP
5 3 (20.00%) SQL Server Reporting Services
5 3 (20.00%) SQL Server Integration Services
6 2 (13.33%) SQL Server Analysis Services
6 2 (13.33%) Data Mart
6 2 (13.33%) Snowflake Schema
6 2 (13.33%) Star Schema
7 1 (6.67%) Base SAS
7 1 (6.67%) SAS Enterprise Guide
7 1 (6.67%) SAS Data Integration Studio
Development Applications
1 1 (6.67%) Team Foundation Server
General
1 3 (20.00%) Finance
Job Titles
1 6 (40.00%) Analyst
2 4 (26.67%) Business Analyst
2 4 (26.67%) Business Intelligence Analyst
3 3 (20.00%) SQL DBA
3 3 (20.00%) Developer
3 3 (20.00%) DBA
3 3 (20.00%) Finance Systems Manager
3 3 (20.00%) Systems Manager
4 2 (13.33%) SQL Server DBA
4 2 (13.33%) Senior DBA
4 2 (13.33%) Senior SQL Server DBA
4 2 (13.33%) IT Finance Manager
4 2 (13.33%) Senior SQL DBA
4 2 (13.33%) Business Intelligence Developer
4 2 (13.33%) SQL Developer
5 1 (6.67%) Agile Business Analyst
5 1 (6.67%) Server Administrator
5 1 (6.67%) SAS Developer
5 1 (6.67%) SQL Database Developer
5 1 (6.67%) Database Developer
Libraries, Frameworks & Software Standards
1 5 (33.33%) XML
2 1 (6.67%) Web Services
Miscellaneous
1 3 (20.00%) Data Extraction
2 2 (13.33%) Statistics
2 2 (13.33%) Client/Server
3 1 (6.67%) Management Information System
3 1 (6.67%) Replication
Operating Systems
1 1 (6.67%) UNIX
1 1 (6.67%) Windows
1 1 (6.67%) Linux
Processes & Methodologies
1 9 (60.00%) Business Intelligence
2 6 (40.00%) Data Modelling
3 5 (33.33%) Waterfall
4 3 (20.00%) Kimball Methodology
5 2 (13.33%) ETL
5 2 (13.33%) Refactoring
5 2 (13.33%) Performance Tuning
6 1 (6.67%) Use Case
6 1 (6.67%) Scrum
6 1 (6.67%) Analytics
6 1 (6.67%) Inmon Methodology
Programming Languages
1 7 (46.67%) SQL
2 2 (13.33%) Python
3 1 (6.67%) T-SQL
Qualifications
1 3 (20.00%) ACCA
1 3 (20.00%) CIMA
2 1 (6.67%) MCITP
2 1 (6.67%) Degree
2 1 (6.67%) Microsoft Certification
2 1 (6.67%) SAS Certification
Quality Assurance & Compliance
1 5 (33.33%) HL7
System Software
1 1 (6.67%) Active Directory
Vendors
1 3 (20.00%) Business Objects
2 2 (13.33%) Microsoft