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

Location
3 months to
27 Aug 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 173 150 190
Rank change year-on-year
-23 +40
Permanent jobs citing OLAP 44 62 21
As % of all permanent IT jobs located in the West Midlands 0.79% 1.13% 0.38%
As % of the Database & Business Intelligence category 2.68% 3.37% 1.30%
Number of salaries quoted 29 38 20
Average salary £40,000 £40,000 £35,750
Average salary % change year-on-year
- +11.88%
90% offered a salary of more than £33,700 £34,250 £32,250
10% offered a salary of more than £55,000 £55,000 £43,650
UK excluding London average salary £42,500 £45,000 £40,000
% change year-on-year
-5.55% +12.50%
OLAP
England

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 West Midlands region.

Database & Business Intelligence Category
West Midlands
Permanent IT job ads with a match in the
Database & Business Intelligence category
1640 1841 1619
As % of all permanent IT jobs located in the West Midlands 29.56% 33.69% 29.36%
Number of salaries quoted 1422 1528 1447
Average salary £40,000 £37,500 £40,000
Average salary % change year-on-year
+6.66% -6.25%
90% offered a salary of more than £27,500 £27,500 £27,500
10% offered a salary of more than £55,000 £55,000 £50,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in the West Midlands

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

OLAP Jobs Demand Trend in the West Midlands

OLAP
Salary Trend in the West Midlands

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

OLAP Salary Trend in the West Midlands

OLAP
Salary Histogram in the West Midlands

This chart provides a salary histogram for IT jobs citing OLAP across the West Midlands region over the 3 months to 27 August 2015.

OLAP Salary Histogram in the West Midlands

OLAP
Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the West Midlands region over the 3 months to 27 August 2015. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Birmingham +33 23 £42,500 -2.85% 3
Staffordshire -23 10 £38,500 -3.75% 2
Warwickshire -9 5 £32,500 -14.47% 3
Wolverhampton - 5 - -
Coventry -11 1 £52,500 +16.66%
OLAP
England

OLAP
Top 30 Related IT Skills in the West Midlands

For the 6 months to 27 August 2015, IT jobs across the West Midlands 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 56 (83.58%) SQL
2 45 (67.16%) Business Intelligence
3 34 (50.75%) Data Warehouse
4 33 (49.25%) SQL Server Reporting Services
5 30 (44.78%) SQL Server Integration Services
6 29 (43.28%) Microsoft
6 29 (43.28%) SQL Server
7 27 (40.30%) T-SQL
8 25 (37.31%) ETL
8 25 (37.31%) SQL Server Analysis Services
9 20 (29.85%) Data Modelling
10 19 (28.36%) OLAP Cube
10 19 (28.36%) Analytical Skills
11 18 (26.87%) Cognos
11 18 (26.87%) Data Analysis
12 16 (23.88%) Finance
13 14 (20.90%) BusinessObjects
13 14 (20.90%) C#
13 14 (20.90%) Data Integration
14 12 (17.91%) Oracle OLAP
14 12 (17.91%) Oracle
14 12 (17.91%) XML
15 11 (16.42%) Team Foundation Server
16 10 (14.93%) MS Excel
16 10 (14.93%) .NET
16 10 (14.93%) Agile Software Development
17 9 (13.43%) SAP
17 9 (13.43%) ASP.NET
17 9 (13.43%) MDX
18 8 (11.94%) SQL Server 2008

OLAP
Top Related IT Skills in the West Midlands by Category

For the 6 months to 27 August 2015, IT jobs across the West Midlands 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 (8.96%) SAS
2 5 (7.46%) SharePoint
3 2 (2.99%) BizTalk Server
4 1 (1.49%) IIS
Applications
1 10 (14.93%) MS Excel
2 4 (5.97%) PowerPivot
3 3 (4.48%) SPSS
4 1 (1.49%) MS Office
Business Applications
1 8 (11.94%) Dynamics AX
2 2 (2.99%) Cognos Business Intelligence
2 2 (2.99%) Dynamics CRM
3 1 (1.49%) Oracle EBS R12
3 1 (1.49%) Oracle EBS
3 1 (1.49%) Oracle ERP
Cloud Services
1 8 (11.94%) Microsoft Azure
2 2 (2.99%) Office 365
Communications & Networking
1 5 (7.46%) HTTP
1 5 (7.46%) Internet
Database & Business Intelligence
1 34 (50.75%) Data Warehouse
2 33 (49.25%) SQL Server Reporting Services
3 30 (44.78%) SQL Server Integration Services
4 29 (43.28%) SQL Server
5 25 (37.31%) SQL Server Analysis Services
6 19 (28.36%) OLAP Cube
7 14 (20.90%) BusinessObjects
8 12 (17.91%) Oracle OLAP
9 8 (11.94%) SQL Server 2008
9 8 (11.94%) Big Data
10 5 (7.46%) SAS Data Integration Studio
10 5 (7.46%) MySQL
10 5 (7.46%) Base SAS
10 5 (7.46%) SAS Enterprise Guide
11 4 (5.97%) Microsoft Analysis Services
11 4 (5.97%) QlikView
12 3 (4.48%) Relational Database
12 3 (4.48%) SQL Server 2012
13 2 (2.99%) NoSQL
13 2 (2.99%) SAP HANA
Development Applications
1 11 (16.42%) Team Foundation Server
2 6 (8.96%) Visual Studio
General
1 16 (23.88%) Finance
2 6 (8.96%) Retail
3 5 (7.46%) Banking
4 4 (5.97%) Automotive
5 1 (1.49%) Advertising
5 1 (1.49%) Front Office
5 1 (1.49%) Back Office
5 1 (1.49%) Marketing
Job Titles
1 35 (52.24%) Developer
2 17 (25.37%) Business Intelligence Developer
3 15 (22.39%) Business Intelligence Analyst
3 15 (22.39%) Analyst
4 11 (16.42%) Business Analyst
5 7 (10.45%) Architect
5 7 (10.45%) Business Objects Developer
6 6 (8.96%) Systems Developer
6 6 (8.96%) Data Architect
6 6 (8.96%) Report Developer
7 5 (7.46%) Business Developer
7 5 (7.46%) Team Leader
8 4 (5.97%) SQL Developer
8 4 (5.97%) Software Developer
8 4 (5.97%) C# Developer
8 4 (5.97%) Microstrategy Developer
9 3 (4.48%) C# Software Developer
9 3 (4.48%) Cognos Developer
10 2 (2.99%) Business Manager
10 2 (2.99%) Lead Developer
Libraries, Frameworks & Software Standards
1 12 (17.91%) XML
2 10 (14.93%) .NET
3 9 (13.43%) ASP.NET
3 9 (13.43%) MDX
4 7 (10.45%) CSS
4 7 (10.45%) HTML
5 6 (8.96%) Web Services
5 6 (8.96%) jQuery
6 2 (2.99%) ASP.NET MVC
6 2 (2.99%) WCF
6 2 (2.99%) Silverlight
7 1 (1.49%) LINQ
7 1 (1.49%) WF
7 1 (1.49%) HTML5
7 1 (1.49%) CSS3
7 1 (1.49%) MSMQ
7 1 (1.49%) Ajax
7 1 (1.49%) .NET Remoting
7 1 (1.49%) .NET Framework
Miscellaneous
1 19 (28.36%) Analytical Skills
2 14 (20.90%) Data Integration
3 8 (11.94%) Data Structures
4 7 (10.45%) Visualisation
5 5 (7.46%) Credit Risk
6 4 (5.97%) Management Information System
7 1 (1.49%) NHS
7 1 (1.49%) Data Conversion
Operating Systems
1 7 (10.45%) Windows
2 2 (2.99%) UNIX
Processes & Methodologies
1 45 (67.16%) Business Intelligence
2 25 (37.31%) ETL
3 20 (29.85%) Data Modelling
4 18 (26.87%) Data Analysis
5 10 (14.93%) Agile Software Development
6 8 (11.94%) Project Management
6 8 (11.94%) Kimball Methodology
7 7 (10.45%) Data Architecture
8 6 (8.96%) Mentoring
8 6 (8.96%) Logical Data Model
8 6 (8.96%) Physical Data Model
8 6 (8.96%) Migration
8 6 (8.96%) UML
8 6 (8.96%) EAI
9 5 (7.46%) RAD
9 5 (7.46%) Logistics
9 5 (7.46%) Release Management
9 5 (7.46%) User Acceptance Testing
9 5 (7.46%) System Testing
9 5 (7.46%) System Integration Testing
Programming Languages
1 56 (83.58%) SQL
2 27 (40.30%) T-SQL
3 14 (20.90%) C#
4 7 (10.45%) JavaScript
5 6 (8.96%) VBA
5 6 (8.96%) X++
6 5 (7.46%) Java
6 5 (7.46%) VB
7 4 (5.97%) PL/SQL
8 3 (4.48%) VB.NET
Qualifications
1 1 (1.49%) Degree
Vendors
1 29 (43.28%) Microsoft
2 18 (26.87%) Cognos
3 12 (17.91%) Oracle
4 9 (13.43%) SAP
5 8 (11.94%) MicroStrategy
6 7 (10.45%) IBM
7 3 (4.48%) Informatica
8 2 (2.99%) Telerik
8 2 (2.99%) Netezza
9 1 (1.49%) Tableau
9 1 (1.49%) Ab Initio
9 1 (1.49%) Teradata
9 1 (1.49%) Hyperion
Staffordshire
Outsource UK
Salary: Excellent benefits
Posted: 22 hours ago
Leamington Spa, Warwickshire
Circle Recruitment
Salary: £30000 - £35000 per annum + Benefits
Posted: Yesterday
Birmingham, West Midlands (County)
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
Birmingham, West Midlands (County)
ANSON MCCADE
Salary: £70,000-£90,000 plus attractive benefits,
Posted: 2 days ago
Warwick, Warwickshire
Anderson Scott Solutions Ltd
Posted: 6 days ago
Leamington Spa
Erin Associates
Salary: £30000 - £33000 per annum + Bonus & Benefits
Posted: 7 days ago
Lichfield
Hays IT - Uk Posting account
Salary: £50000.00 - £60000.00 per annum
Posted: 8 days ago
Birmingham
Churchill Frank
Salary: £40000 - £45000 per annum + Pension + Bonus + Training
Posted: 9 days ago