The following table provides summary statistics for permanent job vacancies advertised in Birmingham with a requirement for OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 3 months to 29 March 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
West Midlands / Birmingham
3 months to
29 Mar 2017
Same period 2016 Same period 2015
Rank 116 136 118
Rank change year-on-year +20 -18  
Permanent jobs citing OLAP 4 6 6
As % of all permanent IT jobs advertised in Birmingham 0.21% 0.25% 0.35%
As % of the Database & Business Intelligence category 0.80% 1.19% 1.13%
Number of salaries quoted 2 6 6
Median salary £33,750 £35,000 £44,250
Median salary % change year-on-year -3.57% -20.90%  
90% offered a salary of more than £32,750 £32,500 £38,750
10% offered a salary of more than £34,750 £35,000 £54,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year - +5.88%  

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Birmingham with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
Birmingham
Permanent job vacancies with a requirement for database and business intelligence skills 499 504 533
As % of all permanent IT job vacancies advertised in Birmingham 26.76% 21.03% 30.86%
Number of salaries quoted 426 460 463
Median salary £41,500 £42,500 £37,500
Median salary % change year-on-year -2.35% +13.33%  
90% offered a salary of more than £30,000 £30,000 £26,000
10% offered a salary of more than £60,000 £55,000 £55,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLAP
Job Vacancy Trend in Birmingham

The job posting trend of jobs advertised in Birmingham citing OLAP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLAP in Birmingham

OLAP
Salary Trend in Birmingham

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

Salary trend for OLAP in Birmingham

For the 6 months to 29 March 2017, 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 Birmingham region with a requirement for OLAP.

1 6 (100.00%) Business Intelligence
2 4 (66.67%) SQL
2 4 (66.67%) SQL Server
2 4 (66.67%) Data Warehouse
3 3 (50.00%) MySQL
3 3 (50.00%) ETL
3 3 (50.00%) Agile Software Development
3 3 (50.00%) SQL Server Reporting Services
3 3 (50.00%) Analytical Skills
4 2 (33.33%) Apache Spark
4 2 (33.33%) Hadoop YARN
4 2 (33.33%) OLAP Cube
4 2 (33.33%) Samza
4 2 (33.33%) HDFS
4 2 (33.33%) Impala
4 2 (33.33%) Apache ZooKeeper
4 2 (33.33%) Riak
4 2 (33.33%) Vertica
4 2 (33.33%) Big Data
4 2 (33.33%) Apache Pig
4 2 (33.33%) Elasticsearch
4 2 (33.33%) Flink
4 2 (33.33%) Fintech
4 2 (33.33%) Lucene
4 2 (33.33%) Degree
4 2 (33.33%) Oracle OLAP
4 2 (33.33%) SQL Server Analysis Services
4 2 (33.33%) SQL Server Integration Services
4 2 (33.33%) TestNG
4 2 (33.33%) Pentaho

OLAP
Co-occurring IT Skills in Birmingham 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 2 (33.33%) Apache
1 2 (33.33%) Apache Pig
1 2 (33.33%) Apache Spark
1 2 (33.33%) Elasticsearch
2 1 (16.67%) SAS
Applications
1 1 (16.67%) MS Excel
Cloud Services
1 1 (16.67%) Amazon AWS
1 1 (16.67%) Microsoft Azure
Database & Business Intelligence
1 4 (66.67%) Data Warehouse
1 4 (66.67%) SQL Server
2 3 (50.00%) MySQL
2 3 (50.00%) SQL Server Reporting Services
3 2 (33.33%) Apache Cassandra
3 2 (33.33%) Apache Hive
3 2 (33.33%) Big Data
3 2 (33.33%) Data Mining
3 2 (33.33%) Flink
3 2 (33.33%) Hadoop
3 2 (33.33%) Impala
3 2 (33.33%) MongoDB
3 2 (33.33%) MS Access
3 2 (33.33%) OLAP Cube
3 2 (33.33%) Oracle OLAP
3 2 (33.33%) Pentaho
3 2 (33.33%) Riak
3 2 (33.33%) SQL Server Analysis Services
3 2 (33.33%) SQL Server Integration Services
4 1 (16.67%) Power BI
Development Applications
1 2 (33.33%) JUnit
1 2 (33.33%) TestNG
2 1 (16.67%) SQL Server Management Studio (SSMS)
2 1 (16.67%) Team Foundation Server
2 1 (16.67%) Visual Studio
General
1 2 (33.33%) Finance
2 1 (16.67%) Advertising
2 1 (16.67%) Manufacturing
2 1 (16.67%) Retail
Job Titles
1 2 (33.33%) Analyst
1 2 (33.33%) Developer
2 1 (16.67%) Big Data Engineer
2 1 (16.67%) Business Analyst
2 1 (16.67%) Business Intelligence Analyst
2 1 (16.67%) Business Intelligence Developer
2 1 (16.67%) Data Engineer
2 1 (16.67%) DBA
2 1 (16.67%) SQL DBA
2 1 (16.67%) SQL Developer
Libraries, Frameworks & Software Standards
1 2 (33.33%) Lucene
1 2 (33.33%) Samza
2 1 (16.67%) MDX
2 1 (16.67%) ODBC
Miscellaneous
1 3 (50.00%) Analytical Skills
2 2 (33.33%) Fintech
3 1 (16.67%) Computer Science
3 1 (16.67%) Driving Licence
3 1 (16.67%) User Experience
Processes & Methodologies
1 6 (100.00%) Business Intelligence
2 3 (50.00%) Agile Software Development
2 3 (50.00%) ETL
3 2 (33.33%) BDD
3 2 (33.33%) Data Visualisation
3 2 (33.33%) MVC
3 2 (33.33%) TDD
3 2 (33.33%) Visualisation
4 1 (16.67%) Capacity Planning
4 1 (16.67%) Continuous Improvement
4 1 (16.67%) Data Analysis
4 1 (16.67%) Data Protection
4 1 (16.67%) Data Transformation
4 1 (16.67%) Performance Monitoring
4 1 (16.67%) Performance Tuning
4 1 (16.67%) Scrum
4 1 (16.67%) Statistics
4 1 (16.67%) Waterfall
Programming Languages
1 4 (66.67%) SQL
2 2 (33.33%) Java
2 2 (33.33%) Scala
2 2 (33.33%) T-SQL
3 1 (16.67%) C
3 1 (16.67%) PL/SQL
Qualifications
1 2 (33.33%) Degree
Quality Assurance & Compliance
1 1 (16.67%) Data Quality
1 1 (16.67%) QA
System Software
1 2 (33.33%) Apache ZooKeeper
1 2 (33.33%) HDFS
Systems Management
1 2 (33.33%) Hadoop YARN
Vendors
1 2 (33.33%) Oracle
1 2 (33.33%) Tableau
1 2 (33.33%) Vertica
2 1 (16.67%) IBM
2 1 (16.67%) Microsoft