Period
to 20 July 2018

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Apache Hive skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Apache Hive over the 6 months to 20 July 2018 with a comparison to the same period in the previous 2 years.

Apache Hive
Central London > City of London
6 months to
20 Jul 2018
Same period 2017 Same period 2016
Rank 272 268 316
Rank change year-on-year -4 +48 +53
Permanent jobs citing Apache Hive 80 68 65
As % of all permanent IT jobs advertised in the City of London 0.72% 0.66% 0.48%
As % of the Database & Business Intelligence category 2.26% 2.09% 1.70%
Number of salaries quoted 75 66 46
City of London median annual salary £72,500 £72,500 £98,750
Median salary % change year-on-year - -26.58% +41.07%
10th Percentile £47,500 £55,000 £46,250
90th Percentile £100,000 £114,375 £113,750
Central London median annual salary £72,750 £70,000 £85,000
% change year-on-year +3.93% -17.65% +21.43%

Apache Hive is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 3,534 3,252 3,819
As % of all permanent IT jobs advertised in the City of London 31.67% 31.71% 28.20%
Number of salaries quoted 3,205 2,920 3,432
City of London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -
10th Percentile £40,000 £37,500 £36,250
90th Percentile £92,500 £87,500 £82,500
Central London median annual salary £62,500 £60,000 £55,000
% change year-on-year +4.17% +9.09% -

Apache Hive
Job Vacancy Trend in the City of London

Job postings citing Apache Hive as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for Apache Hive in the City of London

Apache Hive
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Apache Hive in the City of London.

Salary trend for Apache Hive in the City of London

Apache Hive
Salary Histogram in the City of London

The salary distribution of IT jobs citing Apache Hive in the City of London over the 6 months to 20 July 2018.

Salary histogram for Apache Hive in the City of London

Apache Hive
Job Locations in the City of London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Apache Hive within the City of London region over the 6 months to 20 July 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge - 4 £80,000 -
Apache Hive
Central London

For the 6 months to 20 July 2018, IT jobs citing Apache Hive also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the City of London region with a requirement for Apache Hive.

1 71 (88.75%) Big Data
2 66 (82.50%) Hadoop
3 51 (63.75%) Apache Spark
4 39 (48.75%) Python
4 39 (48.75%) Finance
5 38 (47.50%) SQL
6 32 (40.00%) Java
6 32 (40.00%) Amazon AWS
7 31 (38.75%) ETL
8 30 (37.50%) Analytics
9 28 (35.00%) NoSQL
10 27 (33.75%) Kafka
11 26 (32.50%) Scala
12 24 (30.00%) Machine Learning
13 22 (27.50%) Oozie
13 22 (27.50%) Data Warehouse
14 21 (26.25%) Data Science
14 21 (26.25%) SQL Server
14 21 (26.25%) Artificial Intelligence
15 20 (25.00%) HDFS
15 20 (25.00%) HBase
16 19 (23.75%) Apache Cassandra
17 18 (22.50%) Microsoft Azure
17 18 (22.50%) Agile Software Development
18 17 (21.25%) SQL Server Integration Services
18 17 (21.25%) Apache Pig
19 16 (20.00%) Data Integration
19 16 (20.00%) Linux
20 14 (17.50%) Relational Database
20 14 (17.50%) Sqoop

Apache Hive
Co-occurring IT Skills in the City of London 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 51 (63.75%) Apache Spark
2 17 (21.25%) Apache Pig
3 9 (11.25%) SharePoint
4 6 (7.50%) Apache
5 5 (6.25%) Oracle Workflow
6 3 (3.75%) SAS
7 2 (2.50%) Apache Solr
7 2 (2.50%) Elasticsearch
8 1 (1.25%) Confluence
8 1 (1.25%) Luigi
Applications
1 4 (5.00%) Microsoft Excel
2 1 (1.25%) Microsoft Office
2 1 (1.25%) Microsoft PowerPoint
2 1 (1.25%) MS Visio
Cloud Services
1 32 (40.00%) Amazon AWS
2 18 (22.50%) Microsoft Azure
3 7 (8.75%) Amazon EMR
4 6 (7.50%) Amazon Kinesis
5 5 (6.25%) Google Cloud Platform
6 2 (2.50%) Amazon EC2
6 2 (2.50%) Azure Data Factory
7 1 (1.25%) AWS Data Pipeline
Communications & Networking
1 1 (1.25%) Broadband
1 1 (1.25%) Firewall
1 1 (1.25%) Kerberos
1 1 (1.25%) SSL
Database & Business Intelligence
1 71 (88.75%) Big Data
2 66 (82.50%) Hadoop
3 28 (35.00%) NoSQL
4 22 (27.50%) Data Warehouse
5 21 (26.25%) SQL Server
6 20 (25.00%) HBase
7 19 (23.75%) Apache Cassandra
8 17 (21.25%) SQL Server Integration Services
9 14 (17.50%) Relational Database
9 14 (17.50%) Sqoop
10 13 (16.25%) QlikView
11 10 (12.50%) Impala
11 10 (12.50%) SQL Server Reporting Services
12 9 (11.25%) BusinessObjects
12 9 (11.25%) MS Access
13 7 (8.75%) MongoDB
14 6 (7.50%) Amazon Redshift
14 6 (7.50%) Data Lake
15 5 (6.25%) Amazon Athena
15 5 (6.25%) MySQL
Development Applications
1 9 (11.25%) SQL Server Management Studio (SSMS)
1 9 (11.25%) Subversion
2 4 (5.00%) Git (software)
3 3 (3.75%) RStudio
4 2 (2.50%) GitLab
4 2 (2.50%) Travis CI
5 1 (1.25%) Bitbucket
5 1 (1.25%) CA Release Automation
5 1 (1.25%) Hudson
5 1 (1.25%) Jenkins
5 1 (1.25%) JIRA
5 1 (1.25%) TeamCity
General
1 39 (48.75%) Finance
2 5 (6.25%) Banking
2 5 (6.25%) Marketing
3 3 (3.75%) Telecoms
4 2 (2.50%) Retail
5 1 (1.25%) Front Office
Job Titles
1 26 (32.50%) Developer
2 22 (27.50%) Data Engineer
3 20 (25.00%) Big Data Engineer
4 18 (22.50%) Big Data Developer
5 17 (21.25%) Architect
5 17 (21.25%) Data Architect
6 16 (20.00%) Big Data Architect
7 9 (11.25%) Data Manager
7 9 (11.25%) Release Manager
8 8 (10.00%) Hadoop Developer
9 7 (8.75%) SQL Developer
9 7 (8.75%) SQL Server Architect
9 7 (8.75%) SQL Server Developer
10 4 (5.00%) Analyst
10 4 (5.00%) Consultant
10 4 (5.00%) Data Consultant
10 4 (5.00%) Database Engineer
10 4 (5.00%) Java Developer
10 4 (5.00%) Senior Database Engineer
10 4 (5.00%) Senior Developer
Libraries, Frameworks & Software Standards
1 27 (33.75%) Kafka
2 5 (6.25%) .NET
2 5 (6.25%) .NET Framework
2 5 (6.25%) D3.js
2 5 (6.25%) Elastic Stack
3 4 (5.00%) Flask
3 4 (5.00%) JSON
3 4 (5.00%) Node.js
3 4 (5.00%) REST
3 4 (5.00%) SOAP
3 4 (5.00%) Spark Streaming
3 4 (5.00%) XML
4 3 (3.75%) PySpark
5 2 (2.50%) Akka
5 2 (2.50%) AngularJS
5 2 (2.50%) LAPP Stack
5 2 (2.50%) Natural Language Processing
5 2 (2.50%) React
5 2 (2.50%) scikit-learn
5 2 (2.50%) YAML
Miscellaneous
1 10 (12.50%) Analytical Skills
1 10 (12.50%) Data Structures
2 5 (6.25%) Greenfield Project
2 5 (6.25%) Tandem
3 4 (5.00%) Algorithms
3 4 (5.00%) Public Cloud
4 3 (3.75%) Computer Science
4 3 (3.75%) FMCG
4 3 (3.75%) Virtual Team
5 2 (2.50%) Fixed Income
5 2 (2.50%) Life Science
5 2 (2.50%) Management Information System
5 2 (2.50%) Social Network
6 1 (1.25%) Fintech
6 1 (1.25%) Hybrid Cloud
6 1 (1.25%) Linux Command Line
6 1 (1.25%) NHS
6 1 (1.25%) Reinsurance
6 1 (1.25%) Robotics
6 1 (1.25%) Self-Motivation
Operating Systems
1 16 (20.00%) Linux
2 11 (13.75%) Unix
3 1 (1.25%) CentOS
3 1 (1.25%) Red Hat Enterprise Linux
Processes & Methodologies
1 31 (38.75%) ETL
2 30 (37.50%) Analytics
3 24 (30.00%) Machine Learning
4 21 (26.25%) Artificial Intelligence
4 21 (26.25%) Data Science
5 18 (22.50%) Agile Software Development
6 16 (20.00%) Data Integration
7 13 (16.25%) Data Engineering
7 13 (16.25%) Data Management
8 12 (15.00%) Migration
8 12 (15.00%) Open Source
9 11 (13.75%) Data Analytics
9 11 (13.75%) DevOps
9 11 (13.75%) MapReduce
9 11 (13.75%) Scrum
9 11 (13.75%) Visualisation
10 10 (12.50%) Data Virtualisation
10 10 (12.50%) Microservices
11 9 (11.25%) Release Management
12 7 (8.75%) Problem-Solving
Programming Languages
1 39 (48.75%) Python
2 38 (47.50%) SQL
3 32 (40.00%) Java
4 26 (32.50%) Scala
5 13 (16.25%) T-SQL
6 10 (12.50%) R
7 9 (11.25%) JavaScript
8 8 (10.00%) C#
8 8 (10.00%) C++
9 7 (8.75%) Bash Shell
10 5 (6.25%) Korn
10 5 (6.25%) Perl
11 4 (5.00%) Java 8
12 3 (3.75%) PL/SQL
12 3 (3.75%) VBA
13 2 (2.50%) Julia
13 2 (2.50%) MATLAB
14 1 (1.25%) PHP
14 1 (1.25%) PHP 7
14 1 (1.25%) Shell Script
Qualifications
1 3 (3.75%) Degree
2 2 (2.50%) PhD
Quality Assurance & Compliance
1 3 (3.75%) Data Quality
2 2 (2.50%) GCP
2 2 (2.50%) Solvency II
3 1 (1.25%) EMIR
3 1 (1.25%) GDPR
3 1 (1.25%) MiFID
System Software
1 20 (25.00%) HDFS
2 10 (12.50%) Apache Flume
3 5 (6.25%) Docker
4 3 (3.75%) Apache ZooKeeper
4 3 (3.75%) Oracle RAC
Systems Management
1 22 (27.50%) Oozie
2 10 (12.50%) Hadoop YARN
3 7 (8.75%) Mesos
4 4 (5.00%) Kubernetes
5 3 (3.75%) Data Guard
5 3 (3.75%) Oracle RMAN
5 3 (3.75%) Prometheus
6 2 (2.50%) Ansible
6 2 (2.50%) Docker Swarm
7 1 (1.25%) Grafana
7 1 (1.25%) Kibana
7 1 (1.25%) logstash
Vendors
1 13 (16.25%) Hortonworks
2 12 (15.00%) Cloudera
3 11 (13.75%) MapR
4 8 (10.00%) Google
4 8 (10.00%) Oracle
5 6 (7.50%) Informatica
5 6 (7.50%) Tableau
6 5 (6.25%) Microsoft
6 5 (6.25%) Sun
7 4 (5.00%) Apigee
7 4 (5.00%) Datameer
8 3 (3.75%) Talend
9 2 (2.50%) Solace
10 1 (1.25%) Alteryx
10 1 (1.25%) Paxata