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

Location
3 months to
27 Nov 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 442 363 328
Rank change year-on-year
-79 -35
Permanent jobs citing OLAP 605 783 908
As % of all permanent IT jobs located in the UK 0.53% 0.72% 0.79%
As % of the Database & Business Intelligence category 1.79% 2.22% 2.44%
Number of salaries quoted 519 673 826
Average salary £47,500 £50,000 £45,000
Average salary % change year-on-year
-5.00% +11.11%
90% offered a salary of more than £33,000 £32,500 £32,500
10% offered a salary of more than £70,000 £75,000 £65,000
UK excluding London average salary £42,500 £40,500 £42,500
% change year-on-year
+4.93% -4.70%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
33887 35228 37265
As % of all permanent IT jobs located in the UK 29.79% 32.18% 32.44%
Number of salaries quoted 28955 30253 33118
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £62,500 £67,500
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%

OLAP
Jobs Demand Trend

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

OLAP Jobs Demand Trend in the UK

OLAP
Salary Trend

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

OLAP Salary Trend in the UK

OLAP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLAP over the 3 months to 27 November 2014 within the UK.

OLAP Salary Histogram in the UK

OLAP
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the UK over the 3 months to 27 November 2014. 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
England -88 571 £50,000 - 94
London -79 293 £57,500 +4.54% 32
City of London +11 90 £62,500 +13.63% 12
South East -31 75 £55,000 +15.78% 8
East of England -25 51 £40,000 +6.66% 5
North West +1 50 £44,000 +10.00% 7
Manchester +4 44 £42,500 -5.55% 7
Yorkshire -28 35 £43,500 +8.75% 13
Berkshire -4 34 £45,000 -18.18% 2
West Yorkshire -5 28 £45,500 +13.75% 6
West Midlands +1 26 £37,500 -6.25% 11
Hertfordshire -9 26 £42,500 +30.76% 1
South West -4 19 £37,500 -2.59% 10
Reading +10 18 £40,000 -20.00% 1
South Wales +24 17 £36,500 -9.87% 1
Wales +17 17 £36,500 -9.87% 2
Surrey -2 17 £57,250 +34.70% 2
East Midlands +2 15 £45,000 +20.00% 8
Cardiff +7 13 £37,000 -3.89%
Bristol +8 11 £35,000 -8.49% 7
Bradford -11 10 £46,750 +16.87% 2
Leeds -15 10 £37,500 -3.22% 3
Docklands, London - 10 £70,000 -
Essex -2 9 £42,500 -26.08% 1
Coventry -4 9 £35,000 -11.94% 5
Scotland -29 9 £47,500 - 2
Staffordshire +2 8 £32,500 -56.66% 1
Northamptonshire - 8 £45,000 -
Southend-on-Sea - 8 £42,500 -
Nottinghamshire +4 7 £37,500 +2.73% 6

OLAP
Top 30 Related IT Skills

For the 6 months to 27 November 2014, IT jobs within the UK 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 972 (71.47%) Business Intelligence
2 930 (68.38%) SQL
3 866 (63.68%) SQL Server
4 800 (58.82%) Data Warehouse
5 698 (51.32%) ETL
6 668 (49.12%) SQL Server Integration Services
7 651 (47.87%) SQL Server Analysis Services
8 627 (46.10%) SQL Server Reporting Services
9 461 (33.90%) Microsoft
10 441 (32.43%) OLAP Cube
11 416 (30.59%) Finance
12 378 (27.79%) T-SQL
13 377 (27.72%) Oracle
13 377 (27.72%) Oracle OLAP
14 337 (24.78%) SQL Server 2008
15 305 (22.43%) Data Modelling
16 304 (22.35%) MS Excel
17 282 (20.74%) Agile Software Development
18 272 (20.00%) Analytical Skills
19 233 (17.13%) SQL Server 2012
20 223 (16.40%) .NET
21 222 (16.32%) MDX
22 214 (15.74%) OLTP
23 209 (15.37%) Degree
24 205 (15.07%) SharePoint
25 194 (14.26%) C#
26 189 (13.90%) Analytics
27 166 (12.21%) Relational Database
28 153 (11.25%) Kimball Methodology
29 151 (11.10%) Cognos

OLAP
Top Related IT Skills by Category

For the 6 months to 27 November 2014, IT jobs within the UK 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 205 (15.07%) SharePoint
2 72 (5.29%) SAS
3 45 (3.31%) SharePoint 2010
4 26 (1.91%) WebLogic
5 23 (1.69%) Tomcat
6 21 (1.54%) BizTalk Server
7 16 (1.18%) IIS
8 14 (1.03%) WebSphere
9 11 (0.81%) ColdFusion
10 10 (0.74%) Apache Solr
11 9 (0.66%) Apache Spark
11 9 (0.66%) Oracle Coherence
12 6 (0.44%) SharePoint Server
12 6 (0.44%) SharePoint 2013
12 6 (0.44%) CMS
12 6 (0.44%) Oracle Workflow
13 5 (0.37%) OpenCms
13 5 (0.37%) Drupal
14 4 (0.29%) JBoss
15 3 (0.22%) WebSphere Application Server
Applications
1 304 (22.35%) MS Excel
2 80 (5.88%) MS Office
3 64 (4.71%) PowerPivot
4 23 (1.69%) MS PowerPoint
5 21 (1.54%) MS Project
6 19 (1.40%) SPSS
7 16 (1.18%) MS Visio
8 7 (0.51%) S-PLUS
9 4 (0.29%) FastStats
10 3 (0.22%) Stata
11 1 (0.074%) Spreadsheet
Business Applications
1 55 (4.04%) Cognos TM1
2 48 (3.53%) Cognos Business Intelligence
3 23 (1.69%) HFM
4 20 (1.47%) Dynamics CRM
5 13 (0.96%) Oracle EBS
5 13 (0.96%) Hyperion Planning
6 11 (0.81%) Oracle ERP
7 7 (0.51%) Cognos Planning
8 6 (0.44%) Dynamics AX
8 6 (0.44%) Summit
9 5 (0.37%) Google Analytics
10 4 (0.29%) Oracle General Ledger
11 2 (0.15%) Remedy ITSM
11 2 (0.15%) Cognos Controller
11 2 (0.15%) Adaptiv
12 1 (0.074%) Khalix
12 1 (0.074%) SAP Oil and Gas
12 1 (0.074%) Dynamics NAV
12 1 (0.074%) Agresso
12 1 (0.074%) WebTrends
Cloud Services
1 16 (1.18%) Office 365
2 7 (0.51%) SaaS
3 5 (0.37%) Microsoft Azure
4 2 (0.15%) Amazon AWS
4 2 (0.15%) Cloud Computing
4 2 (0.15%) Amazon EC2
5 1 (0.074%) Amazon S3
Communications & Networking
1 19 (1.40%) Intranet
2 11 (0.81%) Internet
3 9 (0.66%) DNS
3 9 (0.66%) SAN
4 7 (0.51%) ATM
5 3 (0.22%) LDAP
6 2 (0.15%) TCP/IP
6 2 (0.15%) FTP
6 2 (0.15%) Broadband
6 2 (0.15%) Firewall
7 1 (0.074%) iSCSI
7 1 (0.074%) Cisco ASA
7 1 (0.074%) FCoE
7 1 (0.074%) Fibre Channel
7 1 (0.074%) InfiniBand
7 1 (0.074%) LAN
7 1 (0.074%) WAN
7 1 (0.074%) Ethernet
7 1 (0.074%) HTTP
Database & Business Intelligence
1 866 (63.68%) SQL Server
2 800 (58.82%) Data Warehouse
3 668 (49.12%) SQL Server Integration Services
4 651 (47.87%) SQL Server Analysis Services
5 627 (46.10%) SQL Server Reporting Services
6 441 (32.43%) OLAP Cube
7 377 (27.72%) Oracle OLAP
8 337 (24.78%) SQL Server 2008
9 233 (17.13%) SQL Server 2012
10 214 (15.74%) OLTP
11 166 (12.21%) Relational Database
12 144 (10.59%) Oracle Database
13 135 (9.93%) Microsoft Analysis Services
14 123 (9.04%) SQL Server 2005
15 116 (8.53%) RDBMS
16 107 (7.87%) Big Data
17 97 (7.13%) Data Mining
18 82 (6.03%) QlikView
19 75 (5.51%) MySQL
20 72 (5.29%) Oracle Database 11g
Development Applications
1 73 (5.37%) Team Foundation Server
2 36 (2.65%) Visual Studio
3 23 (1.69%) Talend Open Studio
4 16 (1.18%) ERwin
5 14 (1.03%) Subversion
6 11 (0.81%) Maven
6 11 (0.81%) JUnit
6 11 (0.81%) Toad
6 11 (0.81%) Git (software)
7 9 (0.66%) SQL Server Management Studio (SSMS)
7 9 (0.66%) PowerDesigner
8 6 (0.44%) Oracle Forms
9 5 (0.37%) Selenium
9 5 (0.37%) NuGet
10 4 (0.29%) Eclipse
10 4 (0.29%) VSS/SourceSafe
11 2 (0.15%) Ant
11 2 (0.15%) Oracle APEX
12 1 (0.074%) Visual Studio Team System
12 1 (0.074%) JIRA
General
1 416 (30.59%) Finance
2 138 (10.15%) Banking
3 62 (4.56%) Marketing
4 36 (2.65%) Investment Banking
5 34 (2.50%) Games
6 33 (2.43%) Retail
7 31 (2.28%) Front Office
8 30 (2.21%) Law
9 27 (1.99%) Advertising
10 22 (1.62%) Telecoms
11 19 (1.40%) Legal
12 10 (0.74%) Back Office
13 9 (0.66%) General Ledger
14 6 (0.44%) Billing
14 6 (0.44%) Retail Banking
15 5 (0.37%) Publishing
16 4 (0.29%) Pharmaceutical
17 3 (0.22%) Financial Institution
17 3 (0.22%) Music Industry
18 2 (0.15%) Manufacturing
Job Titles
1 743 (54.63%) Developer
2 380 (27.94%) Business Intelligence Developer
3 174 (12.79%) Analyst
4 162 (11.91%) Consultant
5 151 (11.10%) SQL Developer
6 149 (10.96%) Business Developer
7 124 (9.12%) Senior Developer
8 121 (8.90%) DBA
9 98 (7.21%) Business Intelligence Consultant
10 85 (6.25%) Business Intelligence Analyst
11 76 (5.59%) Business Analyst
12 70 (5.15%) Data Warehouse Developer
13 61 (4.49%) Senior Business Intelligence Developer
14 58 (4.26%) SQL Server Developer
15 57 (4.19%) Architect
16 52 (3.82%) SQL DBA
17 44 (3.24%) Database Developer
18 42 (3.09%) Administrator
19 38 (2.79%) Business Consultant
20 37 (2.72%) Analyst Developer
Libraries, Frameworks & Software Standards
1 223 (16.40%) .NET
2 222 (16.32%) MDX
3 104 (7.65%) XML
4 73 (5.37%) ASP.NET
5 64 (4.71%) HTML
6 56 (4.12%) Web Services
7 45 (3.31%) CSS
8 32 (2.35%) ASP.NET MVC
9 31 (2.28%) WCF
10 24 (1.76%) HTML5
11 22 (1.62%) jQuery
12 20 (1.47%) Spring
13 14 (1.03%) NHibernate
14 13 (0.96%) .NET Framework
14 13 (0.96%) Ajax
14 13 (0.96%) LINQ
14 13 (0.96%) CSS3
15 11 (0.81%) ASP.NET 2.0
15 11 (0.81%) WSDL
15 11 (0.81%) XML Schema
Miscellaneous
1 272 (20.00%) Analytical Skills
2 87 (6.40%) Computer Science
3 75 (5.51%) Management Information System
4 72 (5.29%) Data Structures
5 69 (5.07%) Data Integration
6 61 (4.49%) Visualisation
7 51 (3.75%) Mathematics
8 48 (3.53%) Replication
8 48 (3.53%) Clustering
9 28 (2.06%) Statistics
10 22 (1.62%) Fixed Income
10 22 (1.62%) PMI
11 20 (1.47%) Online Games
12 19 (1.40%) Oracle Exalytics
13 17 (1.25%) Kindle
13 17 (1.25%) Reference Data
14 16 (1.18%) iPad
14 16 (1.18%) Data Extraction
15 15 (1.10%) Hedge funds
15 15 (1.10%) Enterprise Software
Operating Systems
1 91 (6.69%) Windows
2 75 (5.51%) Linux
3 69 (5.07%) UNIX
4 21 (1.54%) Windows Server 2008
5 18 (1.32%) Windows Server 2003
6 16 (1.18%) Android
7 7 (0.51%) Oracle Linux
8 5 (0.37%) AIX
9 4 (0.29%) Windows Server 2012
10 3 (0.22%) MVS
11 2 (0.15%) zOS
12 1 (0.074%) Solaris
12 1 (0.074%) Ubuntu
12 1 (0.074%) CentOS
12 1 (0.074%) Windows 7
Processes & Methodologies
1 972 (71.47%) Business Intelligence
2 698 (51.32%) ETL
3 305 (22.43%) Data Modelling
4 282 (20.74%) Agile Software Development
5 189 (13.90%) Analytics
6 153 (11.25%) Kimball Methodology
7 140 (10.29%) Scrum
8 114 (8.38%) Dimensional Modelling
9 112 (8.24%) Project Management
10 104 (7.65%) Performance Tuning
11 102 (7.50%) Data Management
12 85 (6.25%) CRM
13 82 (6.03%) E-Commerce
14 69 (5.07%) Data Architecture
15 65 (4.78%) Data Analysis
16 61 (4.49%) Unit Testing
17 51 (3.75%) ERP
18 46 (3.38%) Information Management
19 44 (3.24%) Waterfall
20 43 (3.16%) Performance Management
Programming Languages
1 930 (68.38%) SQL
2 378 (27.79%) T-SQL
3 194 (14.26%) C#
4 122 (8.97%) PL/SQL
5 89 (6.54%) Java
6 57 (4.19%) JavaScript
7 31 (2.28%) VBA
8 28 (2.06%) PowerShell
9 26 (1.91%) Shell Script
10 21 (1.54%) VB.NET
11 20 (1.47%) R
11 20 (1.47%) Data Analysis Expressions (DAX)
12 16 (1.18%) VB
13 11 (0.81%) ActionScript
14 10 (0.74%) Python
14 10 (0.74%) Perl
15 8 (0.59%) C++
16 7 (0.51%) C
17 5 (0.37%) VBScript
17 5 (0.37%) Data Mining Extensions (DMX)
Qualifications
1 209 (15.37%) Degree
2 59 (4.34%) Microsoft Certification
3 31 (2.28%) MCDBA
4 27 (1.99%) Security Cleared
5 23 (1.69%) PMI Certification
6 13 (0.96%) MCSD
7 12 (0.88%) SC Cleared
8 11 (0.81%) MCITP
8 11 (0.81%) MCSE
8 11 (0.81%) ACCA
9 9 (0.66%) Oracle Certification
9 9 (0.66%) MCAD
10 4 (0.29%) IBM Certification
11 3 (0.22%) CIMA
11 3 (0.22%) SAS Certification
11 3 (0.22%) MCP
11 3 (0.22%) ISEB
12 2 (0.15%) OCP
12 2 (0.15%) ITIL Certification
12 2 (0.15%) ISTQB
Quality Assurance & Compliance
1 54 (3.97%) QA
2 28 (2.06%) ISO 9001
3 14 (1.03%) SLA
4 7 (0.51%) Data Quality
5 6 (0.44%) Solvency II
6 5 (0.37%) HL7
6 5 (0.37%) GAAP
7 3 (0.22%) Sarbanes-Oxley
8 2 (0.15%) GxP
8 2 (0.15%) ISO 14001
8 2 (0.15%) ISO/IEC 27001
8 2 (0.15%) COBIT
8 2 (0.15%) PCI DSS
8 2 (0.15%) GAMP
System Software
1 40 (2.94%) Oracle RAC
2 10 (0.74%) Active Directory
3 7 (0.51%) HDFS
4 5 (0.37%) Varnish
4 5 (0.37%) VMware Infrastructure
5 4 (0.29%) Oracle RMAN
6 2 (0.15%) XenApp
6 2 (0.15%) XenDesktop
7 1 (0.074%) Hyper-V
Systems Management
1 28 (2.06%) Data Guard
2 7 (0.51%) Oracle Enterprise Manager
3 4 (0.29%) Foglight
4 2 (0.15%) SCCM
4 2 (0.15%) MAINVIEW
Vendors
1 461 (33.90%) Microsoft
2 377 (27.72%) Oracle
3 151 (11.10%) Cognos
4 133 (9.78%) Business Objects
5 101 (7.43%) IBM
6 91 (6.69%) Informatica
7 83 (6.10%) SAP
7 83 (6.10%) Tableau
8 65 (4.78%) MicroStrategy
9 52 (3.82%) Sybase
10 50 (3.68%) Teradata
11 38 (2.79%) Netezza
12 33 (2.43%) Hyperion
13 23 (1.69%) Talend
14 17 (1.25%) Ab Initio
14 17 (1.25%) Siebel
15 13 (0.96%) JD Edwards
15 13 (0.96%) DataSynapse
16 12 (0.88%) Sun
17 11 (0.81%) Vertica
Birmingham, West Midlands (County)
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
Bristol, Avon
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
Manchester, Lancashire
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
Gloucester, Gloucestershire
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
Guildford, Surrey
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
London
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
UK
ANSON MCCADE
Salary: From £40,000 to £55,000 per annum + attractive benefits and extensive
Posted: 5 hours ago
Coventry, West Midlands (County)
Ashdown IT
Salary: £35000 per annum
Posted: 17 hours ago
Coventry, West Midlands (County)
Big Red Recruitment
Salary: £25000 - £35000 per annum + Pension, childcare & more
Posted: 23 hours ago
Manchester, Lancashire
Circle Recruitment
Salary: £30000 - £38000 per annum + Benefits
Posted: Yesterday
City, London
Logic Engagements Ltd
Salary: £50000 - £60000 per annum + Excellent benefits
Posted: Yesterday
Derby, Derbyshire
Oscar Associates (UK) Ltd
Salary: £36000 - £42000 per annum + Comprehensive benefits package
Posted: Yesterday
Newport, Gwent
Sanderson
Salary: £35000.00 - £38000.00 per annum
Posted: Yesterday
Southampton, Hampshire
Acceler-IT
Salary: From £40,000 to £55,000 per annum +superb benefits.and bonus
Posted: Yesterday
London
McGregor Boyall
Salary: £30000 - £55000 per annum
Posted: 2 days ago
Bristol, Avon
Genium Selection Limited
Salary: From £30,000 to £40,000 per annum + excellent benefits
Posted: 2 days ago
Aberdeen, Aberdeenshire
Informatiq Consulting
Salary: Excellent salary
Posted: 2 days ago
Manchester, Lancashire
Circle Recruitment
Salary: £28000 - £35000 per annum + Bonus + Benefits
Posted: 2 days ago
Belfast, County Antrim
HAYS INFORMATION TECHNOLOGY
Salary: £25000.00 - £45000.00 per annum
Posted: 2 days ago
City, London
Ashdown IT
Salary: £65000 - £80000 per annum
Posted: 2 days ago