Period
to 23 November 2017

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for Apache Hive skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Apache Hive over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Apache Hive
Central London > City of London
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 146 178 228
Rank change year-on-year +32 +50 +47
Contract jobs citing Apache Hive 103 64 44
As % of all contract IT jobs advertised in the City of London 1.44% 0.96% 0.49%
As % of the Database & Business Intelligence category 5.90% 3.64% 1.87%
Number of daily rates quoted 94 50 40
City of London median daily rate £625 £525 £500
Median daily rate % change year-on-year +19.05% +5.00% +11.11%
10th Percentile £504 £431 £398
90th Percentile £738 £664 £680
Central London median daily rate £625 £525 £500
% change year-on-year +19.05% +5.00% +5.26%
Number of hourly rates quoted 0 0 1
City of London median hourly rate - - £37.50
Central London median hourly rate - - £37.50

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 contract 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
Contract vacancies with a requirement for database or business intelligence skills 1745 1757 2359
As % of all contract IT jobs advertised in the City of London 24.44% 26.23% 26.08%
Number of daily rates quoted 1422 1398 1887
City of London median daily rate £525 £475 £463
Median daily rate % change year-on-year +10.53% +2.70% +6.32%
10th Percentile £363 £325 £313
90th Percentile £700 £675 £638
Central London median daily rate £525 £475 £450
% change year-on-year +10.53% +5.56% +5.88%
Number of hourly rates quoted 11 1 9
City of London median hourly rate £27.50 £45.00 £25.00
Median hourly rate % change year-on-year -38.89% +80.00% -18.88%
10th Percentile £20.75 £42.50 £16.25
90th Percentile £33.25 £47.50 £70.75
Central London median hourly rate £25.99 £45.00 £21.98
% change year-on-year -42.24% +104.78% -25.46%

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
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Apache Hive in the City of London.

Contractor daily rate trend for Apache Hive in the City of London

Apache Hive
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing Apache Hive in the City of London over the 6 months to 23 November 2017.

Contractor daily rate histogram for Apache Hive in the City of London

For the 6 months to 23 November 2017, IT contractor 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 contract ads across the City of London region with a requirement for Apache Hive.

1 100 (97.09%) Hadoop
2 94 (91.26%) Big Data
3 90 (87.38%) Apache Spark
4 76 (73.79%) Java
5 67 (65.05%) HDFS
6 57 (55.34%) Python
7 52 (50.49%) Kafka
8 51 (49.51%) Apache Flume
8 51 (49.51%) Oozie
9 48 (46.60%) MapReduce
10 41 (39.81%) HBase
11 40 (38.83%) Finance
12 37 (35.92%) Agile Software Development
13 33 (32.04%) Banking
14 31 (30.10%) DevOps
14 31 (30.10%) PySpark
15 30 (29.13%) Impala
16 29 (28.16%) Oracle
17 28 (27.18%) Open Source
18 26 (25.24%) SQL
18 26 (25.24%) Data Modelling
18 26 (25.24%) Data Engineering
18 26 (25.24%) Ambari
19 25 (24.27%) PostgreSQL
20 24 (23.30%) Jenkins
21 23 (22.33%) Sqoop
21 23 (22.33%) Apache
22 22 (21.36%) NoSQL
22 22 (21.36%) Hadoop YARN
23 21 (20.39%) TDD

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 90 (87.38%) Apache Spark
2 23 (22.33%) Apache
3 19 (18.45%) Elasticsearch
4 16 (15.53%) Apache Pig
5 5 (4.85%) Apache Solr
6 4 (3.88%) SAS
7 1 (0.97%) Apache Airflow
Cloud Services
1 20 (19.42%) Amazon AWS
2 17 (16.50%) GitHub
3 15 (14.56%) Bluemix
3 15 (14.56%) IBM Cloud
4 1 (0.97%) Amazon EMR
4 1 (0.97%) Amazon Kinesis
4 1 (0.97%) Amazon S3
4 1 (0.97%) Google Cloud Platform
4 1 (0.97%) Virtual Private Cloud
Communications & Networking
1 3 (2.91%) SSL
2 2 (1.94%) Kerberos
2 2 (1.94%) Network Security
Database & Business Intelligence
1 100 (97.09%) Hadoop
2 94 (91.26%) Big Data
3 41 (39.81%) HBase
4 30 (29.13%) Impala
5 25 (24.27%) PostgreSQL
6 23 (22.33%) Sqoop
7 22 (21.36%) NoSQL
8 15 (14.56%) Oracle ODI
9 13 (12.62%) Data Warehouse
9 13 (12.62%) MongoDB
9 13 (12.62%) Relational Database
10 12 (11.65%) RDBMS
11 11 (10.68%) Oracle Database
12 10 (9.71%) Apache Cassandra
13 3 (2.91%) QlikView
13 3 (2.91%) SAS Enterprise Guide
14 2 (1.94%) Cloudera CDH
14 2 (1.94%) Neo4j
14 2 (1.94%) SQLite
15 1 (0.97%) SAS Visual Analytics
Development Applications
1 24 (23.30%) Jenkins
2 6 (5.83%) Git (software)
3 2 (1.94%) Maven
4 1 (0.97%) Ant
4 1 (0.97%) Eclipse
4 1 (0.97%) ERwin
4 1 (0.97%) Gradle
4 1 (0.97%) HP UFT
4 1 (0.97%) JIRA
4 1 (0.97%) JUnit
4 1 (0.97%) Mockito
4 1 (0.97%) ProC
4 1 (0.97%) Selenium
4 1 (0.97%) Talend Open Studio
4 1 (0.97%) WebDriver
General
1 40 (38.83%) Finance
2 33 (32.04%) Banking
3 5 (4.85%) Investment Banking
4 1 (0.97%) Retail
Job Titles
1 24 (23.30%) Developer
1 24 (23.30%) Java Engineer
2 17 (16.50%) Hadoop Engineer
3 14 (13.59%) Big Data Developer
3 14 (13.59%) Senior Hadoop Engineer
3 14 (13.59%) Senior Java Engineer
4 13 (12.62%) Scala Developer
5 9 (8.74%) Data Engineer
6 8 (7.77%) Architect
7 7 (6.80%) Apache Spark Developer
8 5 (4.85%) Big Data Engineer
8 5 (4.85%) Data Architect
9 4 (3.88%) Administrator
9 4 (3.88%) Big Data Architect
9 4 (3.88%) Data Scientist
10 3 (2.91%) Senior Developer
10 3 (2.91%) Solutions Architect
11 2 (1.94%) Analyst
11 2 (1.94%) Cloud Administrator
11 2 (1.94%) Hadoop Developer
Libraries, Frameworks & Software Standards
1 52 (50.49%) Kafka
2 31 (30.10%) PySpark
3 12 (11.65%) Akka
4 8 (7.77%) AngularJS
4 8 (7.77%) React
4 8 (7.77%) Redux
4 8 (7.77%) Twitter Bootstrap
5 4 (3.88%) RabbitMQ
6 2 (1.94%) .NET
6 2 (1.94%) Java EE
6 2 (1.94%) JSON
6 2 (1.94%) scikit-learn
7 1 (0.97%) Apache Commons
7 1 (0.97%) Cascading
7 1 (0.97%) Django
7 1 (0.97%) Flask
7 1 (0.97%) Lucene
7 1 (0.97%) Pandas
7 1 (0.97%) Spark Streaming
7 1 (0.97%) Spring
Miscellaneous
1 20 (19.42%) Analytical Skills
2 9 (8.74%) Algorithms
3 7 (6.80%) Market Risk
4 4 (3.88%) Greenfield Project
5 3 (2.91%) Data Centre
6 2 (1.94%) Computer Science
6 2 (1.94%) Replication
7 1 (0.97%) Credit Derivative
7 1 (0.97%) Data Structures
7 1 (0.97%) Derivative
7 1 (0.97%) Equities
7 1 (0.97%) Foreign Exchange (FX)
7 1 (0.97%) Infotainment
7 1 (0.97%) Management Information System
7 1 (0.97%) Reference Data
Operating Systems
1 10 (9.71%) Unix
2 7 (6.80%) Linux
3 2 (1.94%) Android
3 2 (1.94%) Apple iOS
3 2 (1.94%) Windows
4 1 (0.97%) CentOS
4 1 (0.97%) Red Hat Enterprise Linux
Processes & Methodologies
1 48 (46.60%) MapReduce
2 37 (35.92%) Agile Software Development
3 31 (30.10%) DevOps
4 28 (27.18%) Open Source
5 26 (25.24%) Data Engineering
5 26 (25.24%) Data Modelling
6 21 (20.39%) TDD
7 18 (17.48%) BDD
8 14 (13.59%) Business Intelligence
8 14 (13.59%) Multithreading
8 14 (13.59%) Use Case
9 13 (12.62%) Analytics
10 10 (9.71%) SDLC
11 7 (6.80%) ETL
12 6 (5.83%) Data Integration
12 6 (5.83%) Visualisation
13 5 (4.85%) Continuous Integration
13 5 (4.85%) Data Architecture
13 5 (4.85%) Data Visualisation
13 5 (4.85%) Test Automation
Programming Languages
1 76 (73.79%) Java
2 57 (55.34%) Python
3 26 (25.24%) SQL
4 20 (19.42%) Shell Script
5 19 (18.45%) Scala
6 11 (10.68%) PL/SQL
7 8 (7.77%) JavaScript
8 6 (5.83%) R
9 2 (1.94%) C#
9 2 (1.94%) COBOL
10 1 (0.97%) Bash Shell
10 1 (0.97%) PROC SQL
10 1 (0.97%) SAS Macro
10 1 (0.97%) T-SQL
Qualifications
1 2 (1.94%) Security Cleared
2 1 (0.97%) Degree
2 1 (0.97%) SC Cleared
Quality Assurance & Compliance
1 3 (2.91%) IFRS
1 3 (2.91%) IFRS 9
2 2 (1.94%) Data Quality
3 1 (0.97%) QA
System Software
1 67 (65.05%) HDFS
2 51 (49.51%) Apache Flume
3 17 (16.50%) Docker
4 7 (6.80%) Apache ZooKeeper
5 1 (0.97%) Active Directory
Systems Management
1 51 (49.51%) Oozie
2 26 (25.24%) Ambari
3 22 (21.36%) Hadoop YARN
4 15 (14.56%) Kubernetes
5 8 (7.77%) Ansible
6 6 (5.83%) Puppet
7 4 (3.88%) Opscode Chef
8 2 (1.94%) Apache Slider
8 2 (1.94%) Control-M
9 1 (0.97%) Terraform
Vendors
1 29 (28.16%) Oracle
2 19 (18.45%) Tableau
3 15 (14.56%) IBM
4 12 (11.65%) Cloudera
5 2 (1.94%) Google
5 2 (1.94%) Hortonworks
5 2 (1.94%) Informatica
5 2 (1.94%) MapR
5 2 (1.94%) Palantir
5 2 (1.94%) SaltStack
6 1 (0.97%) Nuix
6 1 (0.97%) Perforce
6 1 (0.97%) Red Hat
6 1 (0.97%) SAP
6 1 (0.97%) Splunk
6 1 (0.97%) Talend