Period
to 18 January 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 18 January 2018 with a comparison to the same period in the previous 2 years.

Apache Hive
Central London > City of London
6 months to
18 Jan 2018
Same period 2017 Same period 2016
Rank 268 265 271
Rank change year-on-year -3 +6 +99
Permanent jobs citing Apache Hive 60 74 103
As % of all permanent IT jobs advertised in the City of London 0.57% 0.69% 0.72%
As % of the Database & Business Intelligence category 1.86% 2.24% 2.37%
Number of salaries quoted 59 68 84
City of London median annual salary £80,000 £72,500 £72,500
Median salary % change year-on-year +10.34% - +16.00%
10th Percentile £54,750 £57,125 £48,750
90th Percentile £115,000 £115,000 £95,000
Central London median annual salary £80,000 £72,500 £75,000
% change year-on-year +10.34% -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 3,221 3,305 4,354
As % of all permanent IT jobs advertised in the City of London 30.86% 30.93% 30.59%
Number of salaries quoted 2,897 3,056 3,843
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,750 £37,000
90th Percentile £88,750 £87,500 £85,000
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +5.50%

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 18 January 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 18 January 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
Moorgate - 3 £90,000 -
Apache Hive
Central London

For the 6 months to 18 January 2018, 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 51 (85.00%) Hadoop
2 49 (81.67%) Big Data
3 40 (66.67%) Apache Spark
4 31 (51.67%) Python
5 30 (50.00%) Analytics
6 29 (48.33%) Java
7 26 (43.33%) Scala
8 24 (40.00%) Machine Learning
9 21 (35.00%) SQL
10 20 (33.33%) R
11 17 (28.33%) Finance
12 16 (26.67%) Apache
12 16 (26.67%) Apache Cassandra
13 14 (23.33%) MongoDB
13 14 (23.33%) HDFS
13 14 (23.33%) Statistics
14 13 (21.67%) Banking
14 13 (21.67%) MATLAB
14 13 (21.67%) HBase
15 12 (20.00%) SAS
16 11 (18.33%) Data Mining
16 11 (18.33%) Business Intelligence
16 11 (18.33%) Apache Pig
17 10 (16.67%) Kafka
17 10 (16.67%) SPSS
17 10 (16.67%) C++
17 10 (16.67%) Agile Software Development
17 10 (16.67%) Amazon AWS
18 9 (15.00%) Visualisation
18 9 (15.00%) Mathematics

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 40 (66.67%) Apache Spark
2 16 (26.67%) Apache
3 12 (20.00%) SAS
4 11 (18.33%) Apache Pig
5 2 (3.33%) Apache Solr
5 2 (3.33%) Elasticsearch
6 1 (1.67%) Jupyter
6 1 (1.67%) Luigi
Applications
1 10 (16.67%) SPSS
Business Applications
1 1 (1.67%) Dynamics CRM
Cloud Services
1 10 (16.67%) Amazon AWS
2 4 (6.67%) Google Cloud Platform
2 4 (6.67%) Microsoft Azure
3 3 (5.00%) Cloud Computing
4 2 (3.33%) Amazon EC2
4 2 (3.33%) Amazon EMR
4 2 (3.33%) Cortana Intelligence Suite
5 1 (1.67%) Azure Machine Learning
5 1 (1.67%) SaaS
Communications & Networking
1 2 (3.33%) Broadband
Database & Business Intelligence
1 51 (85.00%) Hadoop
2 49 (81.67%) Big Data
3 16 (26.67%) Apache Cassandra
4 14 (23.33%) MongoDB
5 13 (21.67%) HBase
6 11 (18.33%) Data Mining
7 6 (10.00%) Impala
8 5 (8.33%) NoSQL
8 5 (8.33%) PostgreSQL
8 5 (8.33%) Relational Database
8 5 (8.33%) Sqoop
9 4 (6.67%) Flink
9 4 (6.67%) Neo4j
9 4 (6.67%) QlikView
10 3 (5.00%) Apache Zeppelin
10 3 (5.00%) BigQuery
10 3 (5.00%) Data Lake
10 3 (5.00%) Parquet
10 3 (5.00%) Power BI
11 2 (3.33%) Presto
Development Applications
1 4 (6.67%) Git (software)
2 3 (5.00%) TeamCity
3 2 (3.33%) Gatling
3 2 (3.33%) Jenkins
3 2 (3.33%) Maven
3 2 (3.33%) Octopus Deploy
4 1 (1.67%) Eclipse
4 1 (1.67%) Hudson
4 1 (1.67%) Travis CI
4 1 (1.67%) Visual Studio
General
1 17 (28.33%) Finance
2 13 (21.67%) Banking
3 8 (13.33%) Retail
4 1 (1.67%) Games
4 1 (1.67%) Investment Banking
Job Titles
1 15 (25.00%) Data Engineer
2 13 (21.67%) Data Scientist
3 12 (20.00%) Developer
4 8 (13.33%) Architect
4 8 (13.33%) Senior Data Engineer
5 7 (11.67%) Big Data Developer
5 7 (11.67%) Big Data Engineer
5 7 (11.67%) Data Architect
6 6 (10.00%) Big Data Architect
7 4 (6.67%) Cloud Architect
7 4 (6.67%) Senior Manager
8 3 (5.00%) Big Data Software Engineer
8 3 (5.00%) Data Migration Architect
8 3 (5.00%) Migration Architect
8 3 (5.00%) Senior Data Scientist
8 3 (5.00%) Software Engineer
9 2 (3.33%) Analytics Manager
9 2 (3.33%) Big Data Manager
9 2 (3.33%) Senior Analytics Manager
9 2 (3.33%) Solutions Architect
Libraries, Frameworks & Software Standards
1 10 (16.67%) Kafka
2 8 (13.33%) JSON
2 8 (13.33%) XML
3 7 (11.67%) Web Services
4 6 (10.00%) GraphX
4 6 (10.00%) MLlib
4 6 (10.00%) NumPy
4 6 (10.00%) Pandas
4 6 (10.00%) scikit-learn
5 4 (6.67%) Natural Language Processing
5 4 (6.67%) TensorFlow
6 3 (5.00%) Apache Avro
6 3 (5.00%) D3.js
6 3 (5.00%) REST
6 3 (5.00%) Spark Streaming
6 3 (5.00%) Spring
7 2 (3.33%) Akka
7 2 (3.33%) JMS
7 2 (3.33%) LAPP Stack
7 2 (3.33%) Symfony
Miscellaneous
1 9 (15.00%) Algorithms
2 7 (11.67%) Analytical Skills
2 7 (11.67%) Computer Science
3 4 (6.67%) Fintech
4 3 (5.00%) Equities
5 2 (3.33%) Clustering
5 2 (3.33%) Linux Command Line
5 2 (3.33%) Robotics
6 1 (1.67%) Greenfield Project
6 1 (1.67%) Mobile Games
Operating Systems
1 8 (13.33%) Linux
2 2 (3.33%) Mac OS X
2 2 (3.33%) Windows
Processes & Methodologies
1 30 (50.00%) Analytics
2 24 (40.00%) Machine Learning
3 14 (23.33%) Statistics
4 11 (18.33%) Business Intelligence
5 10 (16.67%) Agile Software Development
6 9 (15.00%) Mathematics
6 9 (15.00%) Predictive Analytics
6 9 (15.00%) Visualisation
7 8 (13.33%) Data Analytics
7 8 (13.33%) Data Strategy
7 8 (13.33%) Open Source
8 7 (11.67%) Data Architecture
8 7 (11.67%) Data Modelling
9 6 (10.00%) MapReduce
9 6 (10.00%) Statistical Modelling
10 5 (8.33%) Acceptance Criteria
10 5 (8.33%) Artificial Intelligence
10 5 (8.33%) Configuration Management
10 5 (8.33%) Kalman Filter
10 5 (8.33%) Predictive Modelling
Programming Languages
1 31 (51.67%) Python
2 29 (48.33%) Java
3 26 (43.33%) Scala
4 21 (35.00%) SQL
5 20 (33.33%) R
6 13 (21.67%) MATLAB
7 10 (16.67%) C++
8 7 (11.67%) C
9 5 (8.33%) Fortran
10 4 (6.67%) PHP
11 3 (5.00%) Cypher
11 3 (5.00%) HiveQL
12 2 (3.33%) Perl
12 2 (3.33%) PHP 7
13 1 (1.67%) Bash Shell
13 1 (1.67%) C#
13 1 (1.67%) Erlang
13 1 (1.67%) JavaScript
13 1 (1.67%) Ruby
13 1 (1.67%) Shell Script
Qualifications
1 8 (13.33%) Degree
2 6 (10.00%) PhD
3 4 (6.67%) Security Cleared
4 2 (3.33%) DV Cleared
5 1 (1.67%) Computer Science Degree
5 1 (1.67%) Numerate Degree
Quality Assurance & Compliance
1 5 (8.33%) Data Quality
2 2 (3.33%) QA
2 2 (3.33%) Solvency II
3 1 (1.67%) Dodd-Frank
3 1 (1.67%) EMIR
3 1 (1.67%) FATCA
3 1 (1.67%) GDPR
3 1 (1.67%) MiFID
System Software
1 14 (23.33%) HDFS
2 7 (11.67%) Apache Flume
3 6 (10.00%) Docker
4 3 (5.00%) Apache ZooKeeper
Systems Management
1 5 (8.33%) Kubernetes
2 4 (6.67%) Opscode Chef
3 3 (5.00%) Puppet
4 2 (3.33%) Hadoop YARN
4 2 (3.33%) Mesos
4 2 (3.33%) Simian Army
5 1 (1.67%) Ansible
5 1 (1.67%) Consul
5 1 (1.67%) Docker Swarm
5 1 (1.67%) Oozie
5 1 (1.67%) Salt
5 1 (1.67%) Terraform
Vendors
1 9 (15.00%) Google
2 8 (13.33%) Tableau
3 4 (6.67%) Cloudera
4 3 (5.00%) IBM
5 2 (3.33%) Apple
5 2 (3.33%) Capita
5 2 (3.33%) Microsoft
6 1 (1.67%) Hortonworks
6 1 (1.67%) MapR