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

3 months to
30 Apr 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 140 121 117
Rank change year-on-year
-19 -4
Permanent jobs citing OLAP 4 6 6
As % of all permanent IT jobs located in Birmingham 0.16% 0.33% 0.33%
As % of the Database & Business Intelligence category 0.83% 1.08% 1.24%
Number of salaries quoted 4 6 6
Average salary £45,000 £44,250 £41,249
Average salary % change year-on-year
+1.69% +7.27%
UK excluding London average salary £47,500 £40,000 £41,000
% change year-on-year
+18.75% -2.43%
OLAP
West Midlands

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

Database & Business Intelligence Category
Birmingham
Permanent IT job ads with a match in the
Database & Business Intelligence category
482 557 482
As % of all permanent IT jobs located in Birmingham 19.55% 30.59% 26.63%
Number of salaries quoted 435 467 436
Average salary £45,000 £37,500 £39,500
Average salary % change year-on-year
+20.00% -5.06%
90% offered a salary of more than £29,500 £25,500 £27,500
10% offered a salary of more than £55,000 £50,000 £55,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in Birmingham

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the Birmingham region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Birmingham

OLAP
Salary Trend in Birmingham

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

OLAP Salary Trend in Birmingham

OLAP
Top 30 Related IT Skills in Birmingham

For the 6 months to 30 April 2016, IT jobs across the Birmingham region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 11 (100.00%) ETL
1 11 (100.00%) Business Intelligence
1 11 (100.00%) SQL Server Reporting Services
2 10 (90.91%) Data Warehouse
3 9 (81.82%) MDX
3 9 (81.82%) Kimball Methodology
4 8 (72.73%) SQL Server Integration Services
4 8 (72.73%) SQL Server Analysis Services
4 8 (72.73%) SQL
5 7 (63.64%) SQL Server
5 7 (63.64%) Microsoft
5 7 (63.64%) Relational Database
5 7 (63.64%) Power BI
6 6 (54.55%) Data Structures
6 6 (54.55%) Test Scripting
6 6 (54.55%) Refactoring
6 6 (54.55%) OpenView
6 6 (54.55%) BusinessObjects
6 6 (54.55%) BizTalk Server
6 6 (54.55%) Data Mart
6 6 (54.55%) RDBMS
6 6 (54.55%) Snowflake Schema
6 6 (54.55%) Star Schema
6 6 (54.55%) Visual Studio
6 6 (54.55%) SOAP
6 6 (54.55%) Web Services
6 6 (54.55%) XML
6 6 (54.55%) XSL
6 6 (54.55%) C#
6 6 (54.55%) VB

OLAP
Top Related IT Skills in Birmingham by Category

For the 6 months to 30 April 2016, IT jobs across the Birmingham region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 6 (54.55%) BizTalk Server
Applications
1 1 (9.09%) MS Excel
Cloud Services
1 1 (9.09%) Microsoft Azure
Database & Business Intelligence
1 11 (100.00%) SQL Server Reporting Services
2 10 (90.91%) Data Warehouse
3 8 (72.73%) SQL Server Analysis Services
3 8 (72.73%) SQL Server Integration Services
4 7 (63.64%) Power BI
4 7 (63.64%) Relational Database
4 7 (63.64%) SQL Server
5 6 (54.55%) BusinessObjects
5 6 (54.55%) Data Mart
5 6 (54.55%) RDBMS
5 6 (54.55%) Snowflake Schema
5 6 (54.55%) Star Schema
6 3 (27.27%) OLTP
6 3 (27.27%) QlikView
7 2 (18.18%) Big Data
7 2 (18.18%) OLAP Cube
8 1 (9.09%) Datazen
8 1 (9.09%) Microsoft Power View
8 1 (9.09%) PowerPivot
8 1 (9.09%) SQL Server 2008
Development Applications
1 6 (54.55%) Visual Studio
2 1 (9.09%) Team Foundation Server
Job Titles
1 9 (81.82%) Business Intelligence Developer
1 9 (81.82%) Developer
2 8 (72.73%) Analyst
2 8 (72.73%) Business Intelligence Analyst
3 6 (54.55%) Analyst Developer
3 6 (54.55%) Developer Analyst
3 6 (54.55%) Report Analyst
3 6 (54.55%) Report Developer
4 1 (9.09%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 9 (81.82%) MDX
2 6 (54.55%) SOAP
2 6 (54.55%) Web Services
2 6 (54.55%) XML
2 6 (54.55%) XSL
Miscellaneous
1 6 (54.55%) Data Structures
2 4 (36.36%) Visualisation
3 3 (27.27%) Data Conversion
4 1 (9.09%) Enterprise Software
Processes & Methodologies
1 11 (100.00%) Business Intelligence
1 11 (100.00%) ETL
2 9 (81.82%) Kimball Methodology
3 6 (54.55%) Data Modelling
3 6 (54.55%) Refactoring
3 6 (54.55%) Test Scripting
4 4 (36.36%) Dimensional Modelling
5 3 (27.27%) Complex Event Processing
5 3 (27.27%) Data Acquisition
5 3 (27.27%) Data Architecture
5 3 (27.27%) Open Source
5 3 (27.27%) SDLC
5 3 (27.27%) UML
6 2 (18.18%) Agile Software Development
6 2 (18.18%) Analytics
6 2 (18.18%) Predictive Analytics
7 1 (9.09%) Data Validation
7 1 (9.09%) Line Management
7 1 (9.09%) Scrum
7 1 (9.09%) Validation
Programming Languages
1 8 (72.73%) SQL
2 6 (54.55%) C#
2 6 (54.55%) VB
3 2 (18.18%) T-SQL
Systems Management
1 6 (54.55%) OpenView
Vendors
1 7 (63.64%) Microsoft
2 3 (27.27%) Tableau