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

3 months to
27 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 194 167 160
Rank change year-on-year
-27 -7
Permanent jobs citing OLAP 5 27 29
As % of all permanent IT jobs located in Manchester 0.13% 0.70% 0.72%
As % of the Database & Business Intelligence category 0.38% 2.18% 1.90%
Number of salaries quoted 5 26 28
Median salary £45,000 £42,500 £50,000
Median salary % change year-on-year
+5.88% -15.00%
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
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
1299 1241 1526
As % of all permanent IT jobs located in Manchester 34.23% 32.14% 37.99%
Number of salaries quoted 1149 1055 1296
Median salary £45,000 £42,500 £37,500
Median salary % change year-on-year
+5.88% +13.33%
90% offered a salary of more than £30,000 £30,000 £27,000
10% offered a salary of more than £60,000 £52,500 £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 September 2016.

OLAP Salary Histogram in Manchester

OLAP
Top 30 Related IT Skills in Manchester

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

1 9 (100.00%) Business Intelligence
2 8 (88.89%) Microsoft
2 8 (88.89%) Data Warehouse
2 8 (88.89%) SQL
3 7 (77.78%) SQL Server
3 7 (77.78%) ETL
3 7 (77.78%) SQL Server Reporting Services
3 7 (77.78%) SQL Server Integration Services
3 7 (77.78%) SQL Server Analysis Services
4 6 (66.67%) MS Excel
5 5 (55.56%) T-SQL
5 5 (55.56%) OLAP Cube
6 4 (44.44%) Agile Software Development
6 4 (44.44%) Visualisation
6 4 (44.44%) Data Visualisation
7 3 (33.33%) Kimball Methodology
7 3 (33.33%) Analytics
7 3 (33.33%) PowerShell
7 3 (33.33%) Data Extraction
7 3 (33.33%) Statistics
7 3 (33.33%) VBA
7 3 (33.33%) Performance Tuning
7 3 (33.33%) Performance Monitoring
8 2 (22.22%) Oracle
8 2 (22.22%) Finance
8 2 (22.22%) Advertising
8 2 (22.22%) Informatica
8 2 (22.22%) Oracle OLAP
8 2 (22.22%) Data Integration
8 2 (22.22%) Oracle BI EE

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 (11.11%) Apache Pig
1 1 (11.11%) SharePoint
Applications
1 6 (66.67%) MS Excel
Business Applications
1 1 (11.11%) Dynamics NAV
1 1 (11.11%) Oracle EBS
Database & Business Intelligence
1 8 (88.89%) Data Warehouse
2 7 (77.78%) SQL Server
2 7 (77.78%) SQL Server Analysis Services
2 7 (77.78%) SQL Server Integration Services
2 7 (77.78%) SQL Server Reporting Services
3 5 (55.56%) OLAP Cube
4 2 (22.22%) Oracle BI EE
4 2 (22.22%) Oracle ODI
4 2 (22.22%) Oracle OLAP
5 1 (11.11%) Apache Hive
5 1 (11.11%) Big Data
5 1 (11.11%) Data Mart
5 1 (11.11%) Hadoop
5 1 (11.11%) Microsoft Analysis Services
5 1 (11.11%) Oracle Database
5 1 (11.11%) Oracle Database 11g
5 1 (11.11%) Oracle Database 12c
5 1 (11.11%) PerformancePoint
5 1 (11.11%) QlikView
5 1 (11.11%) SQL Server 2008
General
1 2 (22.22%) Advertising
1 2 (22.22%) Finance
2 1 (11.11%) Marketing
Job Titles
1 7 (77.78%) Business Intelligence Developer
1 7 (77.78%) Developer
2 4 (44.44%) SSIS Developer
2 4 (44.44%) SSRS Developer
3 2 (22.22%) SQL BI Developer
3 2 (22.22%) SQL Developer
4 1 (11.11%) Business Intelligence Lead
4 1 (11.11%) Business Intelligence Specialist
4 1 (11.11%) Consultant
4 1 (11.11%) Database Specialist
4 1 (11.11%) Lead Developer
4 1 (11.11%) OBIEE Consultant
4 1 (11.11%) Oracle BI Developer
4 1 (11.11%) Oracle Developer
4 1 (11.11%) SharePoint Specialist
4 1 (11.11%) SSAS Developer
4 1 (11.11%) Technical Consultant
Libraries, Frameworks & Software Standards
1 1 (11.11%) MDX
Miscellaneous
1 4 (44.44%) Visualisation
2 3 (33.33%) Data Extraction
2 3 (33.33%) Statistics
3 2 (22.22%) Data Integration
4 1 (11.11%) Analytical Skills
4 1 (11.11%) Data Conversion
4 1 (11.11%) Management Information System
Processes & Methodologies
1 9 (100.00%) Business Intelligence
2 7 (77.78%) ETL
3 4 (44.44%) Agile Software Development
3 4 (44.44%) Data Visualisation
4 3 (33.33%) Analytics
4 3 (33.33%) Kimball Methodology
4 3 (33.33%) Performance Monitoring
4 3 (33.33%) Performance Tuning
5 1 (11.11%) Business Development
5 1 (11.11%) Data Governance
5 1 (11.11%) Data Modelling
5 1 (11.11%) ERP
5 1 (11.11%) Information Management
5 1 (11.11%) Mentoring
5 1 (11.11%) PRINCE2
5 1 (11.11%) Programme Management
5 1 (11.11%) Project Management
5 1 (11.11%) Scrum
Programming Languages
1 8 (88.89%) SQL
2 5 (55.56%) T-SQL
3 3 (33.33%) PowerShell
3 3 (33.33%) VBA
4 1 (11.11%) PL/SQL
4 1 (11.11%) R
Qualifications
1 1 (11.11%) Oracle Certification
1 1 (11.11%) PRINCE2 Certification
Vendors
1 8 (88.89%) Microsoft
2 2 (22.22%) Informatica
2 2 (22.22%) Oracle
3 1 (11.11%) Tableau
Manchester, Lancashire
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: Yesterday
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 5 days ago
Manchester
Nigel Frank International Ltd
Salary: £60000 per annum
Posted: 21 days ago