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

3 months to
27 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
North West / Manchester
Rank 196 164 174
Rank change year-on-year
-32 +10
Permanent jobs citing OLAP 8 12 19
As % of all permanent IT jobs located in Manchester 0.21% 0.37% 0.48%
As % of the Database & Business Intelligence category 0.61% 1.18% 1.46%
Number of salaries quoted 8 12 19
Median salary £36,000 £44,750 £31,500
Median salary % change year-on-year
-19.55% +42.06%
UK excluding London median salary £45,000 £46,750 £41,750
% change year-on-year
-3.74% +11.97%

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

Database & Business Intelligence Category
Manchester
Permanent IT job ads with a match in the
Database & Business Intelligence category
1303 1016 1305
As % of all permanent IT jobs located in Manchester 33.99% 31.07% 33.12%
Number of salaries quoted 1108 881 1142
Median salary £40,000 £42,500 £37,608
Median salary % change year-on-year
-5.88% +13.00%
90% offered a salary of more than £28,500 £30,000 £27,500
10% offered a salary of more than £60,000 £50,000 £55,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Manchester

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

OLAP Jobs Demand Trend in Manchester

OLAP
Salary Trend in Manchester

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

OLAP Salary Trend in Manchester

OLAP
Salary Histogram in Manchester

This chart provides a salary histogram for IT jobs citing OLAP across the Manchester region over the 3 months to 27 February 2017.

OLAP Salary Histogram in Manchester

OLAP
Top 30 Related IT Skills in Manchester

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

1 23 (100.00%) SQL
1 23 (100.00%) Business Intelligence
1 23 (100.00%) SQL Server Reporting Services
1 23 (100.00%) SQL Server Integration Services
2 22 (95.65%) SQL Server Analysis Services
3 19 (82.61%) Data Warehouse
4 17 (73.91%) Microsoft
5 15 (65.22%) SQL Server
6 13 (56.52%) T-SQL
7 10 (43.48%) Visualisation
7 10 (43.48%) ETL
8 9 (39.13%) Agile Software Development
8 9 (39.13%) Data Visualisation
8 9 (39.13%) OLAP Cube
9 8 (34.78%) Performance Tuning
9 8 (34.78%) Performance Monitoring
9 8 (34.78%) PowerShell
9 8 (34.78%) Statistics
9 8 (34.78%) Data Extraction
9 8 (34.78%) VBA
9 8 (34.78%) MS Excel
10 5 (21.74%) OLTP
10 5 (21.74%) Advertising
10 5 (21.74%) MDX
10 5 (21.74%) SQL Server 2008
10 5 (21.74%) Power BI
11 4 (17.39%) SQL Server 2005
11 4 (17.39%) Time Management
12 3 (13.04%) Analytics
13 2 (8.70%) High Availability

OLAP
Top Related 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:

Applications
1 8 (34.78%) MS Excel
Cloud Services
1 1 (4.35%) Amazon AWS
1 1 (4.35%) IaaS
1 1 (4.35%) Microsoft Azure
1 1 (4.35%) PaaS
Database & Business Intelligence
1 23 (100.00%) SQL Server Integration Services
1 23 (100.00%) SQL Server Reporting Services
2 22 (95.65%) SQL Server Analysis Services
3 19 (82.61%) Data Warehouse
4 15 (65.22%) SQL Server
5 9 (39.13%) OLAP Cube
6 5 (21.74%) OLTP
6 5 (21.74%) Power BI
6 5 (21.74%) SQL Server 2008
7 4 (17.39%) SQL Server 2005
8 1 (4.35%) Azure SQL Database
8 1 (4.35%) Big Data
8 1 (4.35%) Microsoft Analysis Services
General
1 5 (21.74%) Advertising
2 1 (4.35%) Finance
Job Titles
1 19 (82.61%) Business Intelligence Developer
1 19 (82.61%) Developer
2 13 (56.52%) SSIS Developer
2 13 (56.52%) SSRS Developer
3 10 (43.48%) SQL BI Developer
3 10 (43.48%) SQL Developer
4 5 (21.74%) SSAS Developer
5 2 (8.70%) Analyst
6 1 (4.35%) Architect
6 1 (4.35%) Business Developer
6 1 (4.35%) Business Intelligence Analyst
6 1 (4.35%) Business Intelligence Solutions Architect
6 1 (4.35%) Data Analyst
6 1 (4.35%) DBA
6 1 (4.35%) Junior
6 1 (4.35%) Junior DBA
6 1 (4.35%) Junior SQL DBA
6 1 (4.35%) Microsoft BI Architect
6 1 (4.35%) Solutions Architect
6 1 (4.35%) SQL DBA
Libraries, Frameworks & Software Standards
1 5 (21.74%) MDX
Miscellaneous
1 1 (4.35%) Analytical Skills
Processes & Methodologies
1 23 (100.00%) Business Intelligence
2 10 (43.48%) ETL
2 10 (43.48%) Visualisation
3 9 (39.13%) Agile Software Development
3 9 (39.13%) Data Visualisation
4 8 (34.78%) Data Extraction
4 8 (34.78%) Performance Monitoring
4 8 (34.78%) Performance Tuning
4 8 (34.78%) Statistics
5 4 (17.39%) Time Management
6 3 (13.04%) Analytics
7 2 (8.70%) High Availability
8 1 (4.35%) Content Management
8 1 (4.35%) Data Integration
8 1 (4.35%) Data Management
8 1 (4.35%) Kimball Methodology
8 1 (4.35%) Migration
8 1 (4.35%) Scrum
Programming Languages
1 23 (100.00%) SQL
2 13 (56.52%) T-SQL
3 8 (34.78%) PowerShell
3 8 (34.78%) VBA
Vendors
1 17 (73.91%) Microsoft
2 2 (8.70%) Tableau
3 1 (4.35%) Google
Greater Manchester
Verticality Ltd
Salary: to £25k DOE + Bonus + Benefits
Posted: 5 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 14 days ago