Period
to 19 November 2017

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 19 November 2017 with a comparison to the same period in the previous 2 years.

Apache Hive
Central London > City of London
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 265 291 307
Rank change year-on-year +26 +16 +84
Permanent jobs citing Apache Hive 57 59 122
As % of all permanent IT jobs advertised in the City of London 0.56% 0.51% 0.71%
As % of the Database & Business Intelligence category 1.80% 1.68% 2.39%
Number of salaries quoted 55 53 105
City of London median annual salary £70,000 £75,000 £72,500
Median salary % change year-on-year -6.67% +3.45% +16.00%
10th Percentile £53,750 £56,250 £47,900
90th Percentile £114,500 £113,000 £94,500
Central London median annual salary £72,500 £77,500 £75,000
% change year-on-year -6.45% +3.33% +20.00%

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 3171 3510 5106
As % of all permanent IT jobs advertised in the City of London 31.30% 30.19% 29.70%
Number of salaries quoted 2899 3219 4436
City of London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - +4.55%
10th Percentile £41,250 £36,250 £36,250
90th Percentile £87,500 £86,250 £85,000
Central London median annual salary £59,500 £55,000 £56,000
% change year-on-year +8.18% -1.79% +1.82%

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 19 November 2017.

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 19 November 2017. 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
Moorgate - 3 £90,000 -
Apache Hive
Central London

For the 6 months to 19 November 2017, IT jobs citing Apache Hive 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 City of London region with a requirement for Apache Hive.

1 47 (82.46%) Hadoop
1 47 (82.46%) Big Data
2 37 (64.91%) Apache Spark
3 29 (50.88%) Analytics
4 25 (43.86%) Java
5 23 (40.35%) Python
6 19 (33.33%) Scala
7 18 (31.58%) SQL
8 17 (29.82%) Machine Learning
8 17 (29.82%) HDFS
9 16 (28.07%) Finance
10 15 (26.32%) Apache
10 15 (26.32%) R
11 14 (24.56%) Apache Pig
11 14 (24.56%) Banking
12 13 (22.81%) Apache Cassandra
12 13 (22.81%) HBase
12 13 (22.81%) Analytical Skills
13 12 (21.05%) MapReduce
13 12 (21.05%) Statistics
13 12 (21.05%) Degree
14 11 (19.30%) MongoDB
14 11 (19.30%) Data Mining
15 10 (17.54%) Kafka
15 10 (17.54%) Apache Flume
15 10 (17.54%) Sqoop
16 9 (15.79%) Data Strategy
16 9 (15.79%) MATLAB
16 9 (15.79%) SAS
16 9 (15.79%) XML

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 37 (64.91%) Apache Spark
2 15 (26.32%) Apache
3 14 (24.56%) Apache Pig
4 9 (15.79%) SAS
5 4 (7.02%) Apache Solr
6 1 (1.75%) Elasticsearch
6 1 (1.75%) Jupyter
Applications
1 5 (8.77%) SPSS
Business Applications
1 1 (1.75%) Dynamics CRM
Cloud Services
1 6 (10.53%) Amazon AWS
2 5 (8.77%) Google Cloud Platform
3 3 (5.26%) Microsoft Azure
4 2 (3.51%) Amazon EC2
4 2 (3.51%) Amazon EMR
4 2 (3.51%) Azure Machine Learning
4 2 (3.51%) Cloud Computing
5 1 (1.75%) Amazon Kinesis
Communications & Networking
1 2 (3.51%) Broadband
2 1 (1.75%) Kerberos
2 1 (1.75%) LDAP
2 1 (1.75%) SSL
Database & Business Intelligence
1 47 (82.46%) Big Data
1 47 (82.46%) Hadoop
2 13 (22.81%) Apache Cassandra
2 13 (22.81%) HBase
3 11 (19.30%) Data Mining
3 11 (19.30%) MongoDB
4 10 (17.54%) Sqoop
5 5 (8.77%) Impala
5 5 (8.77%) NoSQL
6 4 (7.02%) Flink
6 4 (7.02%) Relational Database
7 3 (5.26%) Apache Zeppelin
7 3 (5.26%) BigQuery
7 3 (5.26%) Data Lake
7 3 (5.26%) Parquet
7 3 (5.26%) RDBMS
7 3 (5.26%) Text Mining
8 2 (3.51%) BusinessObjects
8 2 (3.51%) MySQL
8 2 (3.51%) PostgreSQL
Development Applications
1 2 (3.51%) Git (software)
2 1 (1.75%) Eclipse
2 1 (1.75%) Hudson
2 1 (1.75%) Jenkins
2 1 (1.75%) Maven
2 1 (1.75%) TeamCity
2 1 (1.75%) Visual Studio
General
1 16 (28.07%) Finance
2 14 (24.56%) Banking
3 8 (14.04%) Retail
4 3 (5.26%) Games
5 2 (3.51%) Marketing
6 1 (1.75%) Investment Banking
Job Titles
1 15 (26.32%) Data Scientist
2 14 (24.56%) Data Engineer
3 10 (17.54%) Developer
4 9 (15.79%) Senior Data Engineer
5 8 (14.04%) Architect
6 7 (12.28%) Data Architect
7 6 (10.53%) Big Data Architect
7 6 (10.53%) Big Data Developer
8 5 (8.77%) Big Data Engineer
9 4 (7.02%) Cloud Architect
10 3 (5.26%) Data Migration Architect
10 3 (5.26%) Migration Architect
10 3 (5.26%) Senior Data Scientist
11 2 (3.51%) Big Data Manager
11 2 (3.51%) Big Data Software Engineer
11 2 (3.51%) Big Data Solutions Architect
11 2 (3.51%) Data Analytics Scientist
11 2 (3.51%) E-Commerce Director
11 2 (3.51%) Machine Learning Scientist
11 2 (3.51%) Technology Director
Libraries, Frameworks & Software Standards
1 10 (17.54%) Kafka
2 9 (15.79%) JSON
2 9 (15.79%) XML
3 6 (10.53%) Web Services
4 4 (7.02%) GraphX
4 4 (7.02%) MLlib
4 4 (7.02%) NumPy
4 4 (7.02%) Pandas
4 4 (7.02%) scikit-learn
4 4 (7.02%) TensorFlow
5 3 (5.26%) Apache Avro
5 3 (5.26%) Natural Language Processing
5 3 (5.26%) Node.js
6 2 (3.51%) Akka
6 2 (3.51%) LAMP
6 2 (3.51%) LAPP Stack
6 2 (3.51%) REST
6 2 (3.51%) Spark Streaming
6 2 (3.51%) Spring
6 2 (3.51%) Symfony
Miscellaneous
1 13 (22.81%) Analytical Skills
2 8 (14.04%) Algorithms
3 6 (10.53%) Computer Science
4 3 (5.26%) Equities
4 3 (5.26%) Robotics
5 2 (3.51%) Clustering
5 2 (3.51%) Fintech
5 2 (3.51%) Linux Command Line
5 2 (3.51%) Mobile Games
5 2 (3.51%) Virtual Team
6 1 (1.75%) Greenfield Project
Operating Systems
1 8 (14.04%) Linux
2 3 (5.26%) Mac OS X
2 3 (5.26%) Windows
Processes & Methodologies
1 29 (50.88%) Analytics
2 17 (29.82%) Machine Learning
3 12 (21.05%) MapReduce
3 12 (21.05%) Statistics
4 9 (15.79%) Data Strategy
4 9 (15.79%) Open Source
4 9 (15.79%) Predictive Analytics
5 8 (14.04%) Agile Software Development
5 8 (14.04%) Business Intelligence
5 8 (14.04%) Mathematics
6 7 (12.28%) Data Analytics
7 6 (10.53%) Data Architecture
7 6 (10.53%) Stakeholder Management
8 5 (8.77%) Predictive Modelling
8 5 (8.77%) Statistical Modelling
9 4 (7.02%) Cluster Analysis
9 4 (7.02%) Configuration Management
9 4 (7.02%) E-Commerce
9 4 (7.02%) Unit Testing
9 4 (7.02%) Visualisation
Programming Languages
1 25 (43.86%) Java
2 23 (40.35%) Python
3 19 (33.33%) Scala
4 18 (31.58%) SQL
5 15 (26.32%) R
6 9 (15.79%) MATLAB
7 8 (14.04%) C++
8 5 (8.77%) C
9 4 (7.02%) PHP
10 3 (5.26%) Fortran
10 3 (5.26%) HiveQL
11 2 (3.51%) Erlang
11 2 (3.51%) Perl
11 2 (3.51%) PHP 7
11 2 (3.51%) Shell Script
Qualifications
1 12 (21.05%) Degree
2 8 (14.04%) PhD
3 3 (5.26%) DV Cleared
3 3 (5.26%) Security Cleared
4 2 (3.51%) Computer Science Degree
5 1 (1.75%) Numerate Degree
Quality Assurance & Compliance
1 2 (3.51%) Data Quality
System Software
1 17 (29.82%) HDFS
2 10 (17.54%) Apache Flume
3 3 (5.26%) Docker
4 2 (3.51%) Apache ZooKeeper
Systems Management
1 4 (7.02%) Opscode Chef
2 3 (5.26%) Oozie
3 2 (3.51%) Puppet
4 1 (1.75%) Hadoop YARN
4 1 (1.75%) Kubernetes
Vendors
1 8 (14.04%) Google
2 6 (10.53%) Tableau
3 3 (5.26%) Cloudera
4 2 (3.51%) IBM
4 2 (3.51%) Vertica
5 1 (1.75%) Capita
5 1 (1.75%) Hortonworks