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

Location
3 months to
26 Nov 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 64 66 62
Rank change year-on-year
+2 -4
Permanent jobs citing OLAP 8 5 8
As % of all permanent IT jobs located in Staffordshire 1.20% 0.77% 1.51%
As % of the Database & Business Intelligence category 2.71% 1.62% 3.13%
Number of salaries quoted 4 5 8
Average salary £32,500 £75,000 £42,000
Average salary % change year-on-year
-56.66% +78.57%
UK excluding London average salary £42,500 £40,000 £42,500
% change year-on-year
+6.25% -5.88%
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 Staffordshire region.

Database & Business Intelligence Category
Staffordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
295 309 256
As % of all permanent IT jobs located in Staffordshire 44.16% 47.54% 48.39%
Number of salaries quoted 258 258 209
Average salary £35,000 £31,750 £37,500
Average salary % change year-on-year
+10.23% -15.33%
90% offered a salary of more than £25,000 £20,000 £27,500
10% offered a salary of more than £46,000 £50,000 £60,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

OLAP
Jobs Demand Trend in Staffordshire

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

OLAP Jobs Demand Trend in Staffordshire

OLAP
Salary Trend in Staffordshire

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

OLAP Salary Trend in Staffordshire

OLAP
Top 30 Related IT Skills in Staffordshire

For the 6 months to 26 November 2014, IT jobs across the Staffordshire 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 53 (100.00%) SQL
2 38 (71.70%) Business Intelligence
3 34 (64.15%) MicroStrategy
4 31 (58.49%) Data Modelling
4 31 (58.49%) SQL Server
5 24 (45.28%) Data Warehouse
6 17 (32.08%) ETL
7 16 (30.19%) T-SQL
8 13 (24.53%) SQL Server Integration Services
9 12 (22.64%) SQL Server Reporting Services
9 12 (22.64%) MS Excel
10 10 (18.87%) SQL Server Analysis Services
11 9 (16.98%) Mentoring
11 9 (16.98%) Analytical Skills
11 9 (16.98%) Microsoft
12 8 (15.09%) SharePoint
12 8 (15.09%) MS Office
13 7 (13.21%) S-PLUS
13 7 (13.21%) Office 365
13 7 (13.21%) OLAP Cube
14 6 (11.32%) Microsoft Analysis Services
15 5 (9.43%) Degree
15 5 (9.43%) MDX
15 5 (9.43%) Big Data
15 5 (9.43%) SQL Server 2008
16 4 (7.55%) Kalman Filter
16 4 (7.55%) E-Commerce
16 4 (7.55%) Data Mart
17 3 (5.66%) Project Management
18 2 (3.77%) Cognos

OLAP
Top Related IT Skills in Staffordshire by Category

For the 6 months to 26 November 2014, IT jobs across the Staffordshire 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 8 (15.09%) SharePoint
2 1 (1.89%) SharePoint Server
Applications
1 12 (22.64%) MS Excel
2 8 (15.09%) MS Office
3 7 (13.21%) S-PLUS
Business Applications
1 1 (1.89%) Dynamics CRM
1 1 (1.89%) Line 500
Cloud Services
1 7 (13.21%) Office 365
Database & Business Intelligence
1 31 (58.49%) SQL Server
2 24 (45.28%) Data Warehouse
3 13 (24.53%) SQL Server Integration Services
4 12 (22.64%) SQL Server Reporting Services
5 10 (18.87%) SQL Server Analysis Services
6 7 (13.21%) OLAP Cube
7 6 (11.32%) Microsoft Analysis Services
8 5 (9.43%) SQL Server 2008
8 5 (9.43%) Big Data
9 4 (7.55%) Data Mart
10 1 (1.89%) QlikView
10 1 (1.89%) DTS
10 1 (1.89%) Data Mining
Development Applications
1 1 (1.89%) Visual Studio
1 1 (1.89%) Visual Studio Team System
General
1 1 (1.89%) Billing
Job Titles
1 43 (81.13%) Developer
2 24 (45.28%) Microstrategy Developer
3 12 (22.64%) Business Intelligence Developer
4 11 (20.75%) SQL Developer
5 10 (18.87%) Lead Developer
5 10 (18.87%) Business Developer
6 9 (16.98%) Senior Developer
7 8 (15.09%) Team Leader
8 5 (9.43%) Business Intelligence Analyst
8 5 (9.43%) Senior Business Intelligence Analyst
8 5 (9.43%) Senior Business Analyst
8 5 (9.43%) Senior Analyst
8 5 (9.43%) Analyst
8 5 (9.43%) Business Analyst
9 4 (7.55%) Analyst Developer
9 4 (7.55%) Data Warehouse Developer
9 4 (7.55%) Technical Developer
9 4 (7.55%) Microsoft Developer
9 4 (7.55%) Technical Leader
9 4 (7.55%) Senior Analyst Developer
Libraries, Frameworks & Software Standards
1 5 (9.43%) MDX
2 1 (1.89%) HTML
2 1 (1.89%) .NET
2 1 (1.89%) ASP.NET
2 1 (1.89%) XML
2 1 (1.89%) .NET Framework
Miscellaneous
1 9 (16.98%) Analytical Skills
2 2 (3.77%) Data Structures
Processes & Methodologies
1 38 (71.70%) Business Intelligence
2 31 (58.49%) Data Modelling
3 17 (32.08%) ETL
4 9 (16.98%) Mentoring
5 4 (7.55%) E-Commerce
5 4 (7.55%) Kalman Filter
6 3 (5.66%) Project Management
7 1 (1.89%) Change Management
7 1 (1.89%) Disaster Recovery
7 1 (1.89%) Data Architecture
7 1 (1.89%) Database Security
7 1 (1.89%) ITIL
7 1 (1.89%) CRM
7 1 (1.89%) Multidimensional Analysis
Programming Languages
1 53 (100.00%) SQL
2 16 (30.19%) T-SQL
3 1 (1.89%) VBA
3 1 (1.89%) JavaScript
Qualifications
1 5 (9.43%) Degree
2 1 (1.89%) ITIL Certification
Vendors
1 34 (64.15%) MicroStrategy
2 9 (16.98%) Microsoft
3 2 (3.77%) Cognos
4 1 (1.89%) Sage
4 1 (1.89%) Logi Analytics
Staffordshire
Computer Futures
Salary: £45000 - £50000 per annum + competitive benefits
Posted: 16 days ago