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

3 months to
7 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 178 133 161
Rank change year-on-year
-45 +28
Permanent jobs citing OLAP 13 51 41
As % of all permanent IT jobs located in Manchester 0.35% 1.42% 0.98%
As % of the Database & Business Intelligence category 0.95% 4.54% 2.76%
Number of salaries quoted 13 49 39
Median salary £45,000 £47,500 £42,500
Median salary % change year-on-year
-5.26% +11.76%
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
OLAP
North West

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
1362 1123 1484
As % of all permanent IT jobs located in Manchester 36.29% 31.37% 35.43%
Number of salaries quoted 1237 969 1303
Median salary £45,000 £42,500 £38,500
Median salary % change year-on-year
+5.88% +10.38%
90% offered a salary of more than £30,000 £30,500 £28,500
10% offered a salary of more than £60,000 £52,500 £53,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 7 December 2016.

OLAP Salary Histogram in Manchester

OLAP
Top 30 Related IT Skills in Manchester

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

1 17 (100.00%) SQL
1 17 (100.00%) Data Warehouse
1 17 (100.00%) Business Intelligence
2 16 (94.12%) SQL Server Reporting Services
2 16 (94.12%) SQL Server Integration Services
3 15 (88.24%) Microsoft
3 15 (88.24%) SQL Server
3 15 (88.24%) SQL Server Analysis Services
4 11 (64.71%) ETL
5 10 (58.82%) T-SQL
5 10 (58.82%) Agile Software Development
5 10 (58.82%) OLAP Cube
6 9 (52.94%) Visualisation
6 9 (52.94%) Data Visualisation
6 9 (52.94%) MS Excel
7 8 (47.06%) VBA
7 8 (47.06%) Statistics
7 8 (47.06%) PowerShell
7 8 (47.06%) Data Extraction
7 8 (47.06%) Performance Tuning
7 8 (47.06%) Performance Monitoring
8 5 (29.41%) SQL Server 2008
9 4 (23.53%) Time Management
9 4 (23.53%) SQL Server 2005
9 4 (23.53%) OLTP
10 3 (17.65%) Kimball Methodology
10 3 (17.65%) Analytics
11 2 (11.76%) Finance
11 2 (11.76%) Advertising
11 2 (11.76%) Scrum

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:

Application Platforms
1 1 (5.88%) Apache Pig
Applications
1 9 (52.94%) MS Excel
Business Applications
1 1 (5.88%) Dynamics NAV
Database & Business Intelligence
1 17 (100.00%) Data Warehouse
2 16 (94.12%) SQL Server Integration Services
2 16 (94.12%) SQL Server Reporting Services
3 15 (88.24%) SQL Server
3 15 (88.24%) SQL Server Analysis Services
4 10 (58.82%) OLAP Cube
5 5 (29.41%) SQL Server 2008
6 4 (23.53%) OLTP
6 4 (23.53%) SQL Server 2005
7 1 (5.88%) Apache Hive
7 1 (5.88%) Big Data
7 1 (5.88%) Data Mart
7 1 (5.88%) Hadoop
7 1 (5.88%) Oracle BI EE
7 1 (5.88%) Oracle ODI
7 1 (5.88%) Oracle OLAP
7 1 (5.88%) Power BI
7 1 (5.88%) QlikView
7 1 (5.88%) Relational Database
General
1 2 (11.76%) Advertising
1 2 (11.76%) Finance
Job Titles
1 16 (94.12%) Business Intelligence Developer
1 16 (94.12%) Developer
2 9 (52.94%) SSIS Developer
2 9 (52.94%) SSRS Developer
3 6 (35.29%) SQL BI Developer
3 6 (35.29%) SQL Developer
4 1 (5.88%) Business Developer
4 1 (5.88%) Business Intelligence Lead
4 1 (5.88%) Consultant
4 1 (5.88%) Lead Developer
4 1 (5.88%) OBIEE Consultant
4 1 (5.88%) SSAS Developer
4 1 (5.88%) Technical Consultant
Libraries, Frameworks & Software Standards
1 1 (5.88%) MDX
Miscellaneous
1 9 (52.94%) Visualisation
2 8 (47.06%) Data Extraction
2 8 (47.06%) Statistics
3 1 (5.88%) Analytical Skills
3 1 (5.88%) Data Integration
Processes & Methodologies
1 17 (100.00%) Business Intelligence
2 11 (64.71%) ETL
3 10 (58.82%) Agile Software Development
4 9 (52.94%) Data Visualisation
5 8 (47.06%) Performance Monitoring
5 8 (47.06%) Performance Tuning
6 4 (23.53%) Time Management
7 3 (17.65%) Analytics
7 3 (17.65%) Kimball Methodology
8 2 (11.76%) Scrum
9 1 (5.88%) High Availability
9 1 (5.88%) Mentoring
9 1 (5.88%) PRINCE2
9 1 (5.88%) Project Management
Programming Languages
1 17 (100.00%) SQL
2 10 (58.82%) T-SQL
3 8 (47.06%) PowerShell
3 8 (47.06%) VBA
4 1 (5.88%) PL/SQL
Qualifications
1 1 (5.88%) Oracle Certification
1 1 (5.88%) PRINCE2 Certification
Vendors
1 15 (88.24%) Microsoft
2 1 (5.88%) Informatica
2 1 (5.88%) Oracle
2 1 (5.88%) Tableau
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 5 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 26 days ago
Manchester
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 26 days ago