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

3 months to
27 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 176 168 180
Rank change year-on-year
-8 +12
Permanent jobs citing OLAP 4 15 9
As % of all permanent IT jobs located in Manchester 0.11% 0.45% 0.23%
As % of the Database & Business Intelligence category 0.35% 1.27% 0.65%
Number of salaries quoted 4 14 9
Median salary £50,000 £40,000 £45,000
Median salary % change year-on-year
+25.00% -11.11%
90% offered a salary of more than £41,250 £37,500 £31,200
10% offered a salary of more than £53,500 £40,000 £62,500
UK excluding London median salary £46,000 £40,000 £42,500
% change year-on-year
+15.00% -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
1132 1178 1386
As % of all permanent IT jobs located in Manchester 32.35% 35.61% 34.75%
Number of salaries quoted 1015 1031 1204
Median salary £42,500 £40,000 £38,500
Median salary % change year-on-year
+6.25% +3.89%
90% offered a salary of more than £30,000 £27,500 £25,500
10% offered a salary of more than £55,000 £56,500 £55,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 June 2016.

OLAP Salary Histogram in Manchester

OLAP
Job Locations in Manchester

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Manchester region over the 3 months to 27 June 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Bolton - 1 £37,500 -
OLAP
North West

OLAP
Top 30 Related IT Skills in Manchester

For the 6 months to 27 June 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 10 (100.00%) Business Intelligence
2 9 (90.00%) SQL
3 7 (70.00%) Microsoft
4 6 (60.00%) Finance
5 5 (50.00%) SQL Server Integration Services
5 5 (50.00%) MS Excel
5 5 (50.00%) Data Warehouse
5 5 (50.00%) SQL Server Reporting Services
5 5 (50.00%) SQL Server Analysis Services
5 5 (50.00%) Analytical Skills
6 4 (40.00%) OLAP Cube
6 4 (40.00%) ETL
6 4 (40.00%) SQL Server
7 3 (30.00%) Data Mining
7 3 (30.00%) Agile Software Development
7 3 (30.00%) Kimball Methodology
8 2 (20.00%) Analytics
8 2 (20.00%) Oracle ODI
8 2 (20.00%) Informatica
8 2 (20.00%) SQL Server 2012
8 2 (20.00%) Oracle OLAP
8 2 (20.00%) Oracle BI EE
8 2 (20.00%) MongoDB
8 2 (20.00%) Migration
8 2 (20.00%) T-SQL
8 2 (20.00%) VBA
8 2 (20.00%) Oracle
8 2 (20.00%) Power BI
8 2 (20.00%) SQL Server 2014
8 2 (20.00%) Budgeting and Forecasting

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 (10.00%) SharePoint
Applications
1 5 (50.00%) MS Excel
Business Applications
1 1 (10.00%) Oracle EBS
Database & Business Intelligence
1 5 (50.00%) Data Warehouse
1 5 (50.00%) SQL Server Analysis Services
1 5 (50.00%) SQL Server Integration Services
1 5 (50.00%) SQL Server Reporting Services
2 4 (40.00%) OLAP Cube
2 4 (40.00%) SQL Server
3 3 (30.00%) Data Mining
4 2 (20.00%) MongoDB
4 2 (20.00%) Oracle BI EE
4 2 (20.00%) Oracle ODI
4 2 (20.00%) Oracle OLAP
4 2 (20.00%) Power BI
4 2 (20.00%) SQL Server 2012
4 2 (20.00%) SQL Server 2014
5 1 (10.00%) Hadoop
5 1 (10.00%) NoSQL
5 1 (10.00%) Oracle Database 11g
5 1 (10.00%) Oracle Database 12c
5 1 (10.00%) PerformancePoint
5 1 (10.00%) SQL Server 2008
General
1 6 (60.00%) Finance
2 1 (10.00%) Marketing
Job Titles
1 4 (40.00%) Analyst
1 4 (40.00%) Business Intelligence Developer
1 4 (40.00%) Developer
2 2 (20.00%) Business Intelligence Analyst
2 2 (20.00%) Commercial Analyst
2 2 (20.00%) SQL Analyst
2 2 (20.00%) Technical Analyst
3 1 (10.00%) Business Intelligence Specialist
3 1 (10.00%) Consultant
3 1 (10.00%) Database Specialist
3 1 (10.00%) OBIEE Consultant
3 1 (10.00%) Oracle BI Developer
3 1 (10.00%) Oracle Developer
3 1 (10.00%) SharePoint Specialist
3 1 (10.00%) SQL BI Developer
3 1 (10.00%) SQL Developer
3 1 (10.00%) Technical Consultant
Libraries, Frameworks & Software Standards
1 1 (10.00%) MDX
Miscellaneous
1 5 (50.00%) Analytical Skills
2 1 (10.00%) Data Conversion
2 1 (10.00%) Data Integration
2 1 (10.00%) Management Information System
2 1 (10.00%) Visualisation
Processes & Methodologies
1 10 (100.00%) Business Intelligence
2 4 (40.00%) ETL
3 3 (30.00%) Agile Software Development
3 3 (30.00%) Kimball Methodology
4 2 (20.00%) Analytics
4 2 (20.00%) Budgeting and Forecasting
4 2 (20.00%) Migration
5 1 (10.00%) Business Development
5 1 (10.00%) Data Governance
5 1 (10.00%) Data Modelling
5 1 (10.00%) Data Visualisation
5 1 (10.00%) ERP
5 1 (10.00%) ETL Development
5 1 (10.00%) Information Management
5 1 (10.00%) Programme Management
5 1 (10.00%) Scrum
Programming Languages
1 9 (90.00%) SQL
2 2 (20.00%) T-SQL
2 2 (20.00%) VBA
3 1 (10.00%) Data Analysis Expressions (DAX)
3 1 (10.00%) PL/SQL
3 1 (10.00%) R
Qualifications
1 1 (10.00%) Oracle Certification
Vendors
1 7 (70.00%) Microsoft
2 2 (20.00%) Informatica
2 2 (20.00%) Oracle
3 1 (10.00%) Tableau