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 22 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
22 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK / England
Rank 550 566 516
Rank change year-on-year
+16 -50
Permanent jobs citing OLAP 299 372 457
As % of all permanent IT jobs located in England 0.38% 0.39% 0.47%
As % of the Database & Business Intelligence category 1.26% 1.23% 1.50%
Number of salaries quoted 265 307 364
Median salary £50,000 £52,500 £52,500
Median salary % change year-on-year
-4.76% -
90% offered a salary of more than £36,000 £35,800 £35,000
10% offered a salary of more than £70,000 £71,000 £75,000
UK excluding London median salary £45,000 £45,000 £40,000
% change year-on-year
- +12.50%

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
23742 30214 30561
As % of all permanent IT jobs located in England 30.18% 31.61% 31.14%
Number of salaries quoted 20380 25960 26403
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,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 22 February 2017.

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 22 February 2017. 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 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 +1 122 £60,000 +4.34% 13
South East +111 88 £52,500 +5.00% 3
East of England +45 36 £43,000 -28.33% 2
West Midlands +17 20 £42,500 -1.16% 3
Yorkshire -6 13 £42,500 - 2
North West -40 9 £36,000 -19.10% 5
East Midlands +13 7 £45,000 -14.28% 1
South West +17 1 £52,500 +40.00% 4
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 22 February 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 England region with a requirement for OLAP.

1 431 (78.36%) SQL
2 388 (70.55%) Business Intelligence
3 364 (66.18%) SQL Server
4 313 (56.91%) Data Warehouse
5 307 (55.82%) SQL Server Integration Services
6 295 (53.64%) SQL Server Reporting Services
7 285 (51.82%) SQL Server Analysis Services
8 265 (48.18%) ETL
9 259 (47.09%) Microsoft
10 207 (37.64%) T-SQL
11 175 (31.82%) Agile Software Development
12 158 (28.73%) OLTP
13 144 (26.18%) OLAP Cube
14 141 (25.64%) MS Excel
15 134 (24.36%) Oracle
15 134 (24.36%) Oracle OLAP
16 127 (23.09%) Finance
16 127 (23.09%) Power BI
17 117 (21.27%) Data Modelling
18 113 (20.55%) Big Data
19 110 (20.00%) SQL Server 2012
20 108 (19.64%) Relational Database
21 106 (19.27%) Analytics
22 102 (18.55%) MDX
23 99 (18.00%) .NET
24 98 (17.82%) SQL Server 2008
24 98 (17.82%) Kimball Methodology
25 96 (17.45%) Hadoop
26 94 (17.09%) Performance Tuning
27 78 (14.18%) Tableau

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 49 (8.91%) SharePoint
2 28 (5.09%) IIS
3 25 (4.55%) Apache
4 20 (3.64%) Apache Pig
4 20 (3.64%) Apache Spark
5 18 (3.27%) Tomcat
5 18 (3.27%) WebSphere
6 16 (2.91%) Oracle Coherence
6 16 (2.91%) Oracle HTTP Server
7 13 (2.36%) SAS
8 8 (1.45%) Elasticsearch
9 7 (1.27%) Oracle SOA Suite
10 6 (1.09%) Apache Airflow
11 5 (0.91%) Jupyter
11 5 (0.91%) Oracle Service Bus
12 4 (0.73%) SharePoint 2013
13 3 (0.55%) SharePoint Server
14 2 (0.36%) Apache Solr
15 1 (0.18%) DataSynapse
Applications
1 141 (25.64%) MS Excel
2 11 (2.00%) MS Visio
3 9 (1.64%) MS Office
4 1 (0.18%) MS PowerPoint
4 1 (0.18%) SPSS
Business Applications
1 11 (2.00%) Cognos TM1
2 9 (1.64%) SAP BPC
3 6 (1.09%) FastStats
4 5 (0.91%) Dynamics AX
4 5 (0.91%) Dynamics CRM
5 3 (0.55%) Hyperion Planning
6 2 (0.36%) Adobe Campaign
6 2 (0.36%) Dynamics NAV
6 2 (0.36%) Eloqua
6 2 (0.36%) HFM
6 2 (0.36%) Unica
7 1 (0.18%) Cognos Business Intelligence
7 1 (0.18%) Cognos Planning
7 1 (0.18%) OPENHousing
7 1 (0.18%) Oracle Applications
7 1 (0.18%) Oracle CRM
7 1 (0.18%) SAP CRM
7 1 (0.18%) SAP SD
Cloud Services
1 53 (9.64%) Microsoft Azure
2 23 (4.18%) Amazon AWS
3 21 (3.82%) GitHub
4 7 (1.27%) Google Cloud Platform
5 6 (1.09%) Amazon Kinesis
5 6 (1.09%) SaaS
6 5 (0.91%) Amazon S3
6 5 (0.91%) Azure Machine Learning
6 5 (0.91%) Data Lake Analytics
7 2 (0.36%) IaaS
7 2 (0.36%) Responsys
8 1 (0.18%) Google Play
8 1 (0.18%) PaaS
Communications & Networking
1 23 (4.18%) Intranet
2 21 (3.82%) SAN
3 17 (3.09%) HTTP
3 17 (3.09%) LAN
3 17 (3.09%) WAN
4 16 (2.91%) FCoE
4 16 (2.91%) Fibre Channel
4 16 (2.91%) iSCSI
4 16 (2.91%) Multicast
4 16 (2.91%) NAS
5 4 (0.73%) Ethernet
6 3 (0.55%) Internet
6 3 (0.55%) SSL
7 2 (0.36%) Extranet
8 1 (0.18%) Firewall
8 1 (0.18%) FTP
8 1 (0.18%) GPRS
8 1 (0.18%) Modbus
8 1 (0.18%) RS-485
8 1 (0.18%) Skype
Database & Business Intelligence
1 364 (66.18%) SQL Server
2 313 (56.91%) Data Warehouse
3 307 (55.82%) SQL Server Integration Services
4 295 (53.64%) SQL Server Reporting Services
5 285 (51.82%) SQL Server Analysis Services
6 158 (28.73%) OLTP
7 144 (26.18%) OLAP Cube
8 134 (24.36%) Oracle OLAP
9 127 (23.09%) Power BI
10 113 (20.55%) Big Data
11 110 (20.00%) SQL Server 2012
12 108 (19.64%) Relational Database
13 98 (17.82%) SQL Server 2008
14 96 (17.45%) Hadoop
15 73 (13.27%) MySQL
16 66 (12.00%) QlikView
16 66 (12.00%) SQL Server 2014
17 63 (11.45%) NoSQL
18 59 (10.73%) Microsoft Analysis Services
19 58 (10.55%) SQL Server 2005
Development Applications
1 54 (9.82%) Visual Studio
2 49 (8.91%) JIRA
3 45 (8.18%) Team Foundation Server
4 25 (4.55%) Talend Open Studio
5 15 (2.73%) Visual Studio Team System
6 10 (1.82%) Git (software)
6 10 (1.82%) Jenkins
7 9 (1.64%) Vagrant
8 7 (1.27%) Cucumber
8 7 (1.27%) ERwin
8 7 (1.27%) git-flow
9 6 (1.09%) Eclipse
9 6 (1.09%) PowerDesigner
9 6 (1.09%) SQL Server Management Studio (SSMS)
10 4 (0.73%) JUnit
10 4 (0.73%) Maven
11 2 (0.36%) Oracle Forms
11 2 (0.36%) TestNG
12 1 (0.18%) Subversion
12 1 (0.18%) TortoiseSVN
General
1 127 (23.09%) Finance
2 36 (6.55%) Advertising
3 27 (4.91%) Banking
4 23 (4.18%) Legal
5 21 (3.82%) Manufacturing
6 17 (3.09%) Marketing
7 15 (2.73%) Investment Banking
8 14 (2.55%) Retail
9 9 (1.64%) Financial Institution
10 8 (1.45%) Games
10 8 (1.45%) German Language
10 8 (1.45%) Spanish Language
11 6 (1.09%) French Language
12 4 (0.73%) Automotive
12 4 (0.73%) Billing
12 4 (0.73%) Dutch Language
12 4 (0.73%) Electronics
12 4 (0.73%) Italian Language
13 3 (0.55%) Music Industry
13 3 (0.55%) Telecoms
Job Titles
1 287 (52.18%) Developer
2 164 (29.82%) Business Intelligence Developer
3 95 (17.27%) SQL Developer
4 82 (14.91%) Analyst
5 73 (13.27%) Senior Developer
6 72 (13.09%) DBA
7 59 (10.73%) SSIS Developer
8 50 (9.09%) SQL DBA
9 45 (8.18%) SQL BI Developer
10 44 (8.00%) SSRS Developer
11 43 (7.82%) ETL Developer
12 40 (7.27%) Architect
13 39 (7.09%) Business Intelligence Analyst
14 38 (6.91%) SSAS Developer
15 33 (6.00%) Business Developer
16 31 (5.64%) Administrator
16 31 (5.64%) Senior Business Intelligence Developer
17 30 (5.45%) Data Warehouse Developer
17 30 (5.45%) SQL Server DBA
18 26 (4.73%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 102 (18.55%) MDX
2 99 (18.00%) .NET
3 35 (6.36%) XML
4 29 (5.27%) Web Services
5 20 (3.64%) Middleware
6 18 (3.27%) HTML
7 16 (2.91%) ASP.NET
7 16 (2.91%) Oracle GoldenGate
8 14 (2.55%) JSON
9 11 (2.00%) .NET Framework
10 10 (1.82%) Akka
11 8 (1.45%) REST
11 8 (1.45%) SOAP
12 7 (1.27%) CSS
12 7 (1.27%) Kafka
12 7 (1.27%) Spring
13 6 (1.09%) jQuery
13 6 (1.09%) Scrapy
14 4 (0.73%) Lucene
14 4 (0.73%) WCF
Miscellaneous
1 70 (12.73%) Analytical Skills
2 53 (9.64%) Management Information System
3 41 (7.45%) Replication
4 26 (4.73%) Clustering
5 21 (3.82%) Computer Science
6 16 (2.91%) Fintech
7 6 (1.09%) Mobile App
8 5 (0.91%) Data Structures
8 5 (0.91%) NHS
9 4 (0.73%) Data Centre
9 4 (0.73%) Reference Data
9 4 (0.73%) Social Media
10 3 (0.55%) Derivative
10 3 (0.55%) Enterprise Software
10 3 (0.55%) iPad
10 3 (0.55%) Online Games
11 2 (0.36%) Credit Derivative
11 2 (0.36%) Credit Risk
11 2 (0.36%) Data Protection Act
11 2 (0.36%) Foreign Exchange (FX)
Operating Systems
1 51 (9.27%) Windows
2 40 (7.27%) Linux
3 17 (3.09%) Unix
4 16 (2.91%) Solaris
5 15 (2.73%) Windows Server 2008
5 15 (2.73%) Windows Server 2012
6 10 (1.82%) Windows Server
7 1 (0.18%) Android
7 1 (0.18%) Apple iOS
Processes & Methodologies
1 388 (70.55%) Business Intelligence
2 265 (48.18%) ETL
3 175 (31.82%) Agile Software Development
4 117 (21.27%) Data Modelling
5 106 (19.27%) Analytics
6 98 (17.82%) Kimball Methodology
7 94 (17.09%) Performance Tuning
8 74 (13.45%) Dimensional Modelling
9 67 (12.18%) Scrum
10 53 (9.64%) Data Integration
11 46 (8.36%) Time Management
12 45 (8.18%) Visualisation
13 41 (7.45%) SDLC
14 36 (6.55%) Disaster Recovery
15 33 (6.00%) Data Visualisation
16 32 (5.82%) Mentoring
17 30 (5.45%) ITIL
18 29 (5.27%) Migration
18 29 (5.27%) Performance Monitoring
19 28 (5.09%) Kanban
Programming Languages
1 431 (78.36%) SQL
2 207 (37.64%) T-SQL
3 67 (12.18%) C#
4 52 (9.45%) PL/SQL
5 43 (7.82%) Data Analysis Expressions (DAX)
6 38 (6.91%) Java
7 22 (4.00%) PowerShell
8 19 (3.45%) Python
9 18 (3.27%) JavaScript
10 14 (2.55%) VB.NET
10 14 (2.55%) VBA
11 13 (2.36%) R
12 12 (2.18%) Scala
12 12 (2.18%) Shell Script
13 9 (1.64%) C
14 7 (1.27%) C++
15 6 (1.09%) PHP
16 5 (0.91%) ABAP
17 4 (0.73%) Embedded C
17 4 (0.73%) Embedded C++
Qualifications
1 64 (11.64%) Degree
2 32 (5.82%) Microsoft Certification
3 13 (2.36%) MCITP
4 12 (2.18%) SC Cleared
4 12 (2.18%) Security Cleared
5 10 (1.82%) MCSE
6 6 (1.09%) CIMA
7 2 (0.36%) MCTS
7 2 (0.36%) Postgraduate
8 1 (0.18%) ACCA
Quality Assurance & Compliance
1 46 (8.36%) Data Quality
2 23 (4.18%) QA
3 14 (2.55%) SLA
4 3 (0.55%) PCI DSS
5 2 (0.36%) Basel III
5 2 (0.36%) Dodd-Frank
6 1 (0.18%) HIPAA
6 1 (0.18%) IFRS
6 1 (0.18%) IFRS 9
6 1 (0.18%) ISO/IEC 27001
6 1 (0.18%) SSAE 16
System Software
1 21 (3.82%) Oracle RAC
2 16 (2.91%) Hyper-V
2 16 (2.91%) KVM
2 16 (2.91%) NFS
2 16 (2.91%) SRDF
2 16 (2.91%) VMware Infrastructure
2 16 (2.91%) Xen
3 10 (1.82%) HDFS
4 7 (1.27%) Active Directory
5 4 (0.73%) Firmware
6 3 (0.55%) Apache Flume
7 2 (0.36%) Apache ZooKeeper
Systems Management
1 21 (3.82%) Puppet
2 6 (1.09%) Kibana
3 5 (0.91%) Enterprise Manager Cloud Control
3 5 (0.91%) Oracle Enterprise Manager
3 5 (0.91%) Oracle RMAN
4 4 (0.73%) Oozie
5 3 (0.55%) Microsoft Clustering
6 2 (0.36%) Hadoop YARN
6 2 (0.36%) Perfmon
7 1 (0.18%) ITRS Geneos
Vendors
1 259 (47.09%) Microsoft
2 134 (24.36%) Oracle
3 78 (14.18%) Tableau
4 54 (9.82%) Cognos
5 25 (4.55%) Talend
6 24 (4.36%) IBM
7 20 (3.64%) EMC
7 20 (3.64%) SAP
8 19 (3.45%) Cisco
8 19 (3.45%) VMware
9 16 (2.91%) Intel
9 16 (2.91%) NetApp
10 12 (2.18%) MicroStrategy
11 10 (1.82%) Actian
11 10 (1.82%) Computacenter
11 10 (1.82%) Google
11 10 (1.82%) Hyperion
12 9 (1.64%) Informatica
12 9 (1.64%) Splunk
13 8 (1.45%) Sybase
Brentford
Nigel Frank International
Salary: £60000 per annum
Posted: 11 hours ago
Falmouth
Nigel Frank International
Salary: £30000 - £40000 per annum + pension, negotiable
Posted: 7 hours ago
Greater Manchester
Verticality Ltd
Salary: to £25k DOE + Bonus + Benefits
Posted: 8 hours ago
Solihull, West Midlands (County)
Modis International
Salary: £30000.00 - £38000.00 per annum + Benefits package
Posted: 1 hour ago
Birmingham, West Midlands (County)
Modis International
Posted: 56 minutes ago
Diss, Norfolk
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £45000.00 per annum
Posted: 2 days ago
Warrington
Nigel Frank International
Salary: £40000 - £45000 per annum + package
Posted: Yesterday
Truro
Nigel Frank International
Salary: £30000 - £40000 per annum + pension, negotiable
Posted: Yesterday
Falmouth
Nigel Frank International
Salary: £45000 - £46000 per annum + penison, negotiable
Posted: 2 days ago
Stoke-On-Trent, Staffordshire
Uniting Ambition
Salary: £35k - 45k per year + pension, holidays and flexible working
Posted: 2 days ago
Surrey
Opus Recruitment Solutions Ltd
Salary: £50000 - £70000 per annum, Benefits Benefits & Bonus included
Posted: Yesterday
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + package
Posted: 5 days ago
London
Austin Fraser
Salary: £45000 - £55000 per annum
Posted: 5 days ago
London
HFG
Salary: £45000 - £65000 per annum, Benefits + bonus + benefits
Posted: 5 days ago
Derby, Derbyshire
Erin Associates
Salary: £39000 - £40000 per annum + Benefits
Posted: 5 days ago
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + company package
Posted: 7 days ago
Wilmslow
Nigel Frank International
Salary: £35000 - £40000 per annum + company bonus + benefits
Posted: 7 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 5 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 5 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 5 days ago
Central London / West End
Initi8 Recruitment
Salary: £35000 - £40000 Per Annum
Posted: 5 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 9 days ago
Haywards Heath
Nigel Frank International
Salary: £40000 - £50000 per annum + Benefits
Posted: 12 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 5 days ago
City, London
Henderson Drake
Salary: From £34,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 7 days ago
City of London
Venturi
Salary: £22000.00 - £30000.00 per annum
Posted: 13 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: 6 days ago
Guildford
Venturi
Salary: £50000 - £60000 per annum + company benefits
Posted: 20 days ago
Bristol, Avon
Hargreaves Lansdown
Salary: Competitive
Posted: 26 days ago
Brentwood, Essex
Shawbrook
Posted: 20 days ago