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

3 months to
29 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 582 499 420
Rank change year-on-year
-83 -79
Permanent jobs citing OLAP 317 493 721
As % of all permanent IT jobs located in England 0.35% 0.49% 0.66%
As % of the Database & Business Intelligence category 1.17% 1.57% 2.08%
Number of salaries quoted 267 390 616
Median salary £50,000 £50,000 £52,500
Median salary % change year-on-year
- -4.76%
90% offered a salary of more than £37,500 £35,000 £35,300
10% offered a salary of more than £80,000 £72,500 £72,500
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
OLAP
UK

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

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
27185 31311 34659
As % of all permanent IT jobs located in England 29.65% 31.17% 31.89%
Number of salaries quoted 23505 26647 29477
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £75,000 £69,000 £72,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in England

The demand trend of job ads across the England region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in England

OLAP
Salary Trend in England

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

OLAP Salary Trend in England

OLAP
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing OLAP across the England region over the 3 months to 29 August 2016.

OLAP Salary Histogram in England

OLAP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the England region over the 3 months to 29 August 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London -46 140 £65,000 +13.04% 11
South East -11 78 £50,000 +23.45% 4
Yorkshire +11 29 £45,000 - 2
North West +15 21 £35,000 -11.39% 1
East of England +19 15 £44,000 -2.22% 2
South West +4 15 £50,000 -16.66% 1
East Midlands +4 8 £46,250 +12.12% 1
West Midlands -44 7 £40,000 - 2
North East - 4 £38,750 -
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 29 August 2016, 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 England region with a requirement for OLAP.

1 497 (73.85%) Business Intelligence
2 492 (73.11%) SQL
3 475 (70.58%) SQL Server
4 390 (57.95%) Data Warehouse
5 313 (46.51%) SQL Server Reporting Services
6 292 (43.39%) SQL Server Integration Services
7 290 (43.09%) ETL
8 288 (42.79%) SQL Server Analysis Services
9 270 (40.12%) Microsoft
10 223 (33.14%) T-SQL
11 222 (32.99%) OLAP Cube
12 198 (29.42%) Finance
13 186 (27.64%) Agile Software Development
14 174 (25.85%) MS Excel
14 174 (25.85%) OLTP
15 160 (23.77%) Oracle
15 160 (23.77%) Oracle OLAP
16 141 (20.95%) Analytical Skills
17 138 (20.51%) SQL Server 2012
18 127 (18.87%) Tableau
19 118 (17.53%) Analytics
20 116 (17.24%) Performance Tuning
21 112 (16.64%) Kimball Methodology
22 109 (16.20%) MDX
23 107 (15.90%) Data Modelling
24 92 (13.67%) Big Data
25 87 (12.93%) Relational Database
26 84 (12.48%) SQL Server 2008
27 83 (12.33%) Hadoop
28 77 (11.44%) Degree

OLAP
Top Related IT Skills in England 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 50 (7.43%) SAS
2 41 (6.09%) SharePoint
3 21 (3.12%) Apache Spark
3 21 (3.12%) IIS
4 20 (2.97%) Apache
4 20 (2.97%) Tomcat
5 17 (2.53%) Oracle Coherence
5 17 (2.53%) WebSphere
6 16 (2.38%) Oracle HTTP Server
7 7 (1.04%) Apache Pig
8 6 (0.89%) Elasticsearch
9 4 (0.59%) Oracle Spatial
9 4 (0.59%) Oracle Workflow
10 2 (0.30%) NetWeaver
10 2 (0.30%) SharePoint 2013
11 1 (0.15%) Blackberry Enterprise Server
11 1 (0.15%) MS Exchange
Applications
1 174 (25.85%) MS Excel
2 9 (1.34%) MS Office
3 4 (0.59%) Gephi
3 4 (0.59%) MS Visio
3 4 (0.59%) SPSS
4 3 (0.45%) MS PowerPoint
5 2 (0.30%) Spreadsheet
6 1 (0.15%) Acrobat
6 1 (0.15%) MS Project
Business Applications
1 15 (2.23%) Cognos Business Intelligence
2 14 (2.08%) Cognos TM1
3 12 (1.78%) SAP Business One
4 11 (1.63%) Oracle EBS
5 9 (1.34%) Cognos Controller
6 5 (0.74%) Dynamics NAV
6 5 (0.74%) SAP BPC
7 4 (0.59%) Oracle Financials
7 4 (0.59%) Unica
8 3 (0.45%) SAP Oil and Gas
9 2 (0.30%) Cognos Planning
9 2 (0.30%) HFM
9 2 (0.30%) Infor M3
9 2 (0.30%) Magento
10 1 (0.15%) FastStats
10 1 (0.15%) Hyperion Planning
10 1 (0.15%) JDE EnterpriseOne
10 1 (0.15%) JDE OneWorld
10 1 (0.15%) Oracle Applications
10 1 (0.15%) Oracle Financial Analyzer
Cloud Services
1 42 (6.24%) Microsoft Azure
2 18 (2.67%) Amazon AWS
3 7 (1.04%) Azure Machine Learning
3 7 (1.04%) Data Lake Analytics
3 7 (1.04%) IaaS
3 7 (1.04%) PaaS
4 5 (0.74%) GitHub
4 5 (0.74%) SaaS
5 2 (0.30%) Amazon S3
Communications & Networking
1 27 (4.01%) SAN
2 20 (2.97%) LAN
2 20 (2.97%) WAN
3 18 (2.67%) HTTP
4 17 (2.53%) Intranet
5 16 (2.38%) FCoE
5 16 (2.38%) Fibre Channel
5 16 (2.38%) iSCSI
5 16 (2.38%) Multicast
5 16 (2.38%) NAS
6 15 (2.23%) Extranet
7 10 (1.49%) Firewall
8 3 (0.45%) PBX
9 2 (0.30%) DHCP
9 2 (0.30%) DNS
9 2 (0.30%) Skype
9 2 (0.30%) TCP/IP
10 1 (0.15%) Ethernet
10 1 (0.15%) Internet
10 1 (0.15%) Remote Desktop
Database & Business Intelligence
1 475 (70.58%) SQL Server
2 390 (57.95%) Data Warehouse
3 313 (46.51%) SQL Server Reporting Services
4 292 (43.39%) SQL Server Integration Services
5 288 (42.79%) SQL Server Analysis Services
6 222 (32.99%) OLAP Cube
7 174 (25.85%) OLTP
8 160 (23.77%) Oracle OLAP
9 138 (20.51%) SQL Server 2012
10 92 (13.67%) Big Data
11 87 (12.93%) Relational Database
12 84 (12.48%) SQL Server 2008
13 83 (12.33%) Hadoop
14 76 (11.29%) SQL Server 2014
15 68 (10.10%) Microsoft Analysis Services
16 56 (8.32%) QlikView
17 48 (7.13%) Power BI
18 47 (6.98%) MySQL
19 46 (6.84%) NoSQL
20 43 (6.39%) PowerPivot
Development Applications
1 19 (2.82%) Team Foundation Server
2 17 (2.53%) Visual Studio
3 13 (1.93%) JIRA
4 10 (1.49%) SQL Server Management Studio (SSMS)
5 7 (1.04%) Visual Studio Tools for Office
6 6 (0.89%) tSQLt
7 5 (0.74%) ERwin
7 5 (0.74%) Git (software)
7 5 (0.74%) Talend Open Studio
8 4 (0.59%) Jenkins
8 4 (0.59%) Subversion
9 3 (0.45%) Eclipse
9 3 (0.45%) Maven
9 3 (0.45%) Vagrant
10 2 (0.30%) Cucumber
11 1 (0.15%) Gradle
11 1 (0.15%) TeamCity
General
1 198 (29.42%) Finance
2 55 (8.17%) Banking
3 40 (5.94%) Retail
4 30 (4.46%) Manufacturing
5 29 (4.31%) Marketing
6 28 (4.16%) Games
7 23 (3.42%) Legal
7 23 (3.42%) Telecoms
8 19 (2.82%) Front Office
9 18 (2.67%) Investment Banking
10 11 (1.63%) Publishing
11 8 (1.19%) Advertising
12 7 (1.04%) Back Office
13 4 (0.59%) Electronics
14 3 (0.45%) Law
15 2 (0.30%) Financial Institution
16 1 (0.15%) Automotive
16 1 (0.15%) Billing
Job Titles
1 349 (51.86%) Developer
2 233 (34.62%) Business Intelligence Developer
3 130 (19.32%) SQL Developer
4 88 (13.08%) Architect
5 71 (10.55%) SQL BI Developer
6 62 (9.21%) Analyst
7 59 (8.77%) DBA
7 59 (8.77%) SSAS Developer
8 58 (8.62%) SQL Server Developer
9 57 (8.47%) SSIS Developer
10 50 (7.43%) Data Architect
11 47 (6.98%) Consultant
12 45 (6.69%) SQL DBA
13 44 (6.54%) Senior Developer
14 39 (5.79%) SSRS Developer
15 37 (5.50%) ETL Developer
16 33 (4.90%) SQL Server BI Developer
17 32 (4.75%) Business Intelligence Consultant
18 30 (4.46%) Oracle Developer
19 28 (4.16%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 109 (16.20%) MDX
2 44 (6.54%) .NET
3 32 (4.75%) XML
4 25 (3.71%) Web Services
5 19 (2.82%) HTML
6 17 (2.53%) Middleware
7 16 (2.38%) REST
8 14 (2.08%) JSON
9 13 (1.93%) D3.js
10 11 (1.63%) Oracle GoldenGate
11 10 (1.49%) jQuery
12 9 (1.34%) HTML5
13 8 (1.19%) ASP.NET
14 7 (1.04%) CSS
14 7 (1.04%) Leaflet
14 7 (1.04%) SOAP
15 6 (0.89%) Django
15 6 (0.89%) WCF
16 4 (0.59%) J2SE
16 4 (0.59%) WF
Miscellaneous
1 141 (20.95%) Analytical Skills
2 72 (10.70%) Visualisation
3 48 (7.13%) Data Integration
4 43 (6.39%) Enterprise Software
5 41 (6.09%) Computer Science
6 38 (5.65%) Replication
7 28 (4.16%) Clustering
8 26 (3.86%) Management Information System
9 25 (3.71%) Data Extraction
9 25 (3.71%) Statistics
10 16 (2.38%) Fintech
11 13 (1.93%) Credit Risk
11 13 (1.93%) Mathematics
12 11 (1.63%) Neural Network
13 10 (1.49%) Data Conversion
13 10 (1.49%) Online Games
14 8 (1.19%) Economics
15 7 (1.04%) Data Protection Act
15 7 (1.04%) Data Structures
15 7 (1.04%) Mobile App
Operating Systems
1 63 (9.36%) Windows
2 57 (8.47%) Linux
3 28 (4.16%) Unix
4 16 (2.38%) Solaris
5 13 (1.93%) Windows Server
6 7 (1.04%) Oracle Linux
7 5 (0.74%) Windows Server 2008
7 5 (0.74%) Windows Server 2012
8 1 (0.15%) CentOS
8 1 (0.15%) Windows 7
8 1 (0.15%) Windows Vista
Processes & Methodologies
1 497 (73.85%) Business Intelligence
2 290 (43.09%) ETL
3 186 (27.64%) Agile Software Development
4 118 (17.53%) Analytics
5 116 (17.24%) Performance Tuning
6 112 (16.64%) Kimball Methodology
7 107 (15.90%) Data Modelling
8 71 (10.55%) Dimensional Modelling
9 67 (9.96%) Scrum
10 56 (8.32%) Data Management
11 54 (8.02%) Project Management
12 50 (7.43%) SDLC
13 49 (7.28%) Business Analysis
14 48 (7.13%) Data Analysis
15 47 (6.98%) Data Analytics
16 39 (5.79%) Data Architecture
16 39 (5.79%) Migration
17 32 (4.75%) Disaster Recovery
18 29 (4.31%) Data Governance
18 29 (4.31%) SOA
Programming Languages
1 492 (73.11%) SQL
2 223 (33.14%) T-SQL
3 50 (7.43%) C#
3 50 (7.43%) Java
3 50 (7.43%) PL/SQL
4 36 (5.35%) Data Analysis Expressions (DAX)
5 35 (5.20%) JavaScript
6 34 (5.05%) Python
7 18 (2.67%) PowerShell
7 18 (2.67%) VBA
8 17 (2.53%) R
9 15 (2.23%) C
10 13 (1.93%) VB.NET
11 11 (1.63%) PHP
12 9 (1.34%) Shell Script
13 8 (1.19%) Scala
14 5 (0.74%) VB
15 4 (0.59%) C++
16 3 (0.45%) Perl
16 3 (0.45%) XMLA
Qualifications
1 77 (11.44%) Degree
2 25 (3.71%) Microsoft Certification
3 10 (1.49%) MCSE
4 6 (0.89%) MCP
4 6 (0.89%) MCSA
5 5 (0.74%) MCITP
6 4 (0.59%) ACCA
6 4 (0.59%) CIMA
6 4 (0.59%) SC Cleared
6 4 (0.59%) Security Cleared
7 3 (0.45%) IBM Certification
7 3 (0.45%) ISEB
8 2 (0.30%) AAT
8 2 (0.30%) Oracle Certification
9 1 (0.15%) CISSP
9 1 (0.15%) HND
9 1 (0.15%) ITIL Certification
9 1 (0.15%) MBA
9 1 (0.15%) MCAD
9 1 (0.15%) PRINCE2 Certification
Quality Assurance & Compliance
1 35 (5.20%) Data Quality
2 32 (4.75%) QA
3 3 (0.45%) SLA
4 2 (0.30%) Basel II
4 2 (0.30%) PCI DSS
System Software
1 23 (3.42%) Oracle RAC
2 22 (3.27%) VMware Infrastructure
3 17 (2.53%) KVM
4 16 (2.38%) Hyper-V
4 16 (2.38%) NFS
4 16 (2.38%) SRDF
4 16 (2.38%) Xen
5 12 (1.78%) Virtual Machines
6 5 (0.74%) VMware ESX
6 5 (0.74%) vSphere
7 4 (0.59%) HDFS
8 2 (0.30%) Apache Flume
9 1 (0.15%) Active Directory
9 1 (0.15%) Firmware
9 1 (0.15%) Microsoft Virtual Server
9 1 (0.15%) Virtual Servers
9 1 (0.15%) VirtualBox
Systems Management
1 11 (1.63%) Microsoft Clustering
2 7 (1.04%) Data Guard
2 7 (1.04%) Oracle Enterprise Manager
3 4 (0.59%) Mesos
4 3 (0.45%) Oozie
4 3 (0.45%) Puppet
5 2 (0.30%) Cisco IPCC
5 2 (0.30%) ITRS Geneos
Vendors
1 270 (40.12%) Microsoft
2 160 (23.77%) Oracle
3 127 (18.87%) Tableau
4 63 (9.36%) Cognos
5 42 (6.24%) IBM
5 42 (6.24%) SAP
6 33 (4.90%) VMware
7 21 (3.12%) NetApp
8 18 (2.67%) Teradata
9 17 (2.53%) EMC
10 16 (2.38%) Cisco
10 16 (2.38%) Intel
11 14 (2.08%) Netezza
12 12 (1.78%) MicroStrategy
13 10 (1.49%) Sybase
14 8 (1.19%) Informatica
15 6 (0.89%) Actuate
15 6 (0.89%) Alteryx
16 5 (0.74%) Atlassian
16 5 (0.74%) Google
Sittingbourne, Kent
TLP Consultancy Ltd.
Salary: £45000 - £55000 per annum + bENEFITS
Posted: 3 days ago
Bradford, West Yorkshire
X4 Group
Salary: Market related
Posted: 3 days ago
London
Lawrence Harvey Enterprise
Salary: £50000.00 - £60000.00 per annum + pension, health care, discounts
Posted: 4 days ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 5 days ago
Hertfordshire
Nigel Frank International Ltd
Salary: £53000 - £62000 per annum
Posted: 6 days ago
Tunbridge Wells, Kent
Evolution Recruitment Solutions
Salary: 20,000 - 25,000
Posted: 5 days ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 3 days ago
Central London / West End
Gamesys
Posted: 3 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 5 days ago
Leeds, West Yorkshire
Search Consultancy
Salary: £25000.00 - £30000.00 per annum + Benefits
Posted: 5 days ago
London
Stafford-Sharp Associates
Salary: £400 - £475 per day
Posted: 4 days ago
London
Nicoll Curtin
Salary: £80000.00 - £115000.00 per annum + Package
Posted: 3 days ago
London
Lawrence Harvey Enterprise
Salary: £50000.00 - £85000.00 per annum + bonus + benefits
Posted: 5 days ago
Staines, Middlesex
Ortolan Group
Posted: 3 days ago
Camborne
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £55000.00 per annum + Relocation + Home working
Posted: 20 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 11 days ago
London
Accenture
Posted: 12 days ago
Sutton, London UK
Reed Business Information
Salary: Competitive Salary + bonus + benefits
Posted: 13 days ago
Royston, Hertfordshire
Hotel Chocolat
Salary: From £45,000 to £55,000 per annum + bens
Posted: 14 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 25 days ago