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

3 months to
3 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 173 162 165
Rank change year-on-year
-11 +3
Permanent jobs citing OLAP 4 25 30
As % of all permanent IT jobs located in Manchester 0.12% 0.70% 0.75%
As % of the Database & Business Intelligence category 0.38% 1.98% 1.94%
Number of salaries quoted 4 24 24
Median salary £39,375 £40,000 £35,000
Median salary % change year-on-year
-1.56% +14.28%
90% offered a salary of more than £33,750 £31,500 £31,500
10% offered a salary of more than £52,000 £52,400 £56,500
UK excluding London median salary £47,500 £40,000 £41,500
% change year-on-year
+18.75% -3.61%
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
1041 1262 1547
As % of all permanent IT jobs located in Manchester 30.18% 35.47% 38.59%
Number of salaries quoted 912 1088 1353
Median salary £42,500 £40,000 £38,000
Median salary % change year-on-year
+6.25% +5.26%
90% offered a salary of more than £30,000 £27,000 £27,500
10% offered a salary of more than £55,000 £52,500 £52,500
UK excluding London median salary £42,500 £40,000 £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 3 May 2016.

OLAP Salary Histogram in Manchester

OLAP
Top 30 Related IT Skills in Manchester

For the 6 months to 3 May 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 25 (96.15%) SQL
2 21 (80.77%) SQL Server Reporting Services
2 21 (80.77%) SQL Server Integration Services
3 18 (69.23%) SQL Server Analysis Services
3 18 (69.23%) SQL Server
4 16 (61.54%) Business Intelligence
4 16 (61.54%) Finance
5 11 (42.31%) Microsoft Analysis Services
6 10 (38.46%) SQL Server 2008
6 10 (38.46%) Disaster Recovery
6 10 (38.46%) OLTP
6 10 (38.46%) SQL Server 2000
7 9 (34.62%) Data Warehouse
8 8 (30.77%) Microsoft
8 8 (30.77%) ETL
9 6 (23.08%) SQL Server 2012
9 6 (23.08%) Data Mining
9 6 (23.08%) OLAP Cube
10 5 (19.23%) Analytical Skills
10 5 (19.23%) Migration
10 5 (19.23%) T-SQL
11 4 (15.38%) MS Excel
11 4 (15.38%) Agile Software Development
11 4 (15.38%) MDX
11 4 (15.38%) Security Cleared
11 4 (15.38%) Enterprise Data Warehouse
12 3 (11.54%) ETL Development
12 3 (11.54%) Power BI
12 3 (11.54%) SQL Server 2014
12 3 (11.54%) Kimball Methodology

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 4 (15.38%) MS Excel
Business Applications
1 1 (3.85%) Oracle EBS
Database & Business Intelligence
1 21 (80.77%) SQL Server Integration Services
1 21 (80.77%) SQL Server Reporting Services
2 18 (69.23%) SQL Server
2 18 (69.23%) SQL Server Analysis Services
3 11 (42.31%) Microsoft Analysis Services
4 10 (38.46%) OLTP
4 10 (38.46%) SQL Server 2000
4 10 (38.46%) SQL Server 2008
5 9 (34.62%) Data Warehouse
6 6 (23.08%) Data Mining
6 6 (23.08%) OLAP Cube
6 6 (23.08%) SQL Server 2012
7 4 (15.38%) Enterprise Data Warehouse
8 3 (11.54%) NoSQL
8 3 (11.54%) Power BI
8 3 (11.54%) SQL Server 2014
9 2 (7.69%) MongoDB
9 2 (7.69%) PowerPivot
10 1 (3.85%) Hadoop
10 1 (3.85%) Oracle ODI
Development Applications
1 2 (7.69%) Talend Open Studio
General
1 16 (61.54%) Finance
2 1 (3.85%) Marketing
Job Titles
1 11 (42.31%) DBA
1 11 (42.31%) SQL DBA
2 8 (30.77%) Developer
3 7 (26.92%) Business Intelligence Developer
4 6 (23.08%) SQL Server DBA
5 5 (19.23%) Analyst
6 4 (15.38%) Production DBA
7 3 (11.54%) Commercial Analyst
7 3 (11.54%) SQL Analyst
7 3 (11.54%) SQL Developer
8 2 (7.69%) Business Intelligence Analyst
8 2 (7.69%) Business Intelligence Lead
8 2 (7.69%) Business Intelligence Manager
8 2 (7.69%) IT Manager
8 2 (7.69%) SQL BI Developer
8 2 (7.69%) Technical Analyst
9 1 (3.85%) Administrator
9 1 (3.85%) Database Developer
9 1 (3.85%) Oracle Developer
9 1 (3.85%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 4 (15.38%) MDX
Miscellaneous
1 5 (19.23%) Analytical Skills
2 3 (11.54%) Management Information System
3 2 (7.69%) Data Extraction
4 1 (3.85%) Data Centre
4 1 (3.85%) Data Conversion
4 1 (3.85%) Data Integration
Processes & Methodologies
1 16 (61.54%) Business Intelligence
2 10 (38.46%) Disaster Recovery
3 8 (30.77%) ETL
4 5 (19.23%) Migration
5 4 (15.38%) Agile Software Development
6 3 (11.54%) Analytics
6 3 (11.54%) ETL Development
6 3 (11.54%) Kimball Methodology
7 2 (7.69%) Customer Insight
7 2 (7.69%) Data Management
7 2 (7.69%) Master Data Management
7 2 (7.69%) Stakeholder Engagement
7 2 (7.69%) Web Analytics
8 1 (3.85%) Business Development
8 1 (3.85%) Data Governance
8 1 (3.85%) ERP
8 1 (3.85%) Information Management
8 1 (3.85%) Programme Management
Programming Languages
1 25 (96.15%) SQL
2 5 (19.23%) T-SQL
3 3 (11.54%) R
3 3 (11.54%) VBA
4 1 (3.85%) Data Analysis Expressions (DAX)
Qualifications
1 4 (15.38%) Security Cleared
Quality Assurance & Compliance
1 2 (7.69%) Data Quality
Vendors
1 8 (30.77%) Microsoft
2 3 (11.54%) Tableau
3 2 (7.69%) Alteryx
3 2 (7.69%) Talend
3 2 (7.69%) Vertica
4 1 (3.85%) Informatica
4 1 (3.85%) Oracle