Period
to 19 September 2017

The following table provides summary statistics for contract job vacancies 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 19 September 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
UK
6 months to
19 Sep 2017
Same period 2016 Same period 2015
Rank 343 455 596
Rank change year-on-year +112 +141 +100
Contract jobs citing Apache Hive 704 508 322
As % of all contract IT jobs advertised in the UK 0.71% 0.47% 0.28%
As % of the Database & Business Intelligence category 3.17% 2.13% 1.22%
Number of daily rates quoted 497 372 198
UK median daily rate £500 £538 £550
Median daily rate % change year-on-year -6.98% -2.27% +5.77%
10th Percentile £358 £400 £413
90th Percentile £675 £724 £700
UK excluding London median daily rate £450 £525 £450
% change year-on-year -14.29% +16.67% +20.00%
Number of hourly rates quoted 2 0 3
UK median hourly rate £40.00 - £33.55
UK excluding London median hourly rate £40.00 - £33.55

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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 22176 23820 26386
As % of all contract IT jobs advertised in the UK 22.47% 22.25% 23.27%
Number of daily rates quoted 14793 15997 17367
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +3.23%
10th Percentile £305 £281 £263
90th Percentile £625 £600 £575
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 277 386 387
UK median hourly rate £29.50 £29.94 £28.50
Median hourly rate % change year-on-year -1.47% +5.05% +3.64%
10th Percentile £12.23 £11.25 £14.00
90th Percentile £53.75 £48.75 £52.80
UK excluding London median hourly rate £30.00 £28.50 £29.50
% change year-on-year +5.26% -3.39% +15.69%

Apache Hive
Job Vacancy Trend

Job postings citing Apache Hive as a percentage of all IT jobs advertised.

Job vacancy trend for Apache Hive in the UK

Apache Hive
Contractor Daily Rate Trend

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

Contractor daily rate trend for Apache Hive in the UK

Apache Hive
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Apache Hive over the 6 months to 19 September 2017.

Contractor daily rate histogram for Apache Hive in the UK

Apache Hive
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Apache Hive.

Contractor hourly rate trend for Apache Hive in the UK

Apache Hive
Top 16 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Apache Hive within the UK over the 6 months to 19 September 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +118 660 £525 -3.23% 63
London +19 407 £538 -2.27% 49
UK excluding London +160 285 £450 -14.29% 17
South East +46 110 £401 -5.76% 9
North of England +79 51 £500 -25.65% 4
Yorkshire +35 41 £508 -27.50% 1
East of England +24 41 £488 -9.30% 1
South West +29 32 £450 +12.50%
Northern Ireland -35 20 £365 -
Scotland +44 16 £350 -6.67% 3
North West +33 14 £610 +22.00% 3
Midlands +27 12 £500 -
North East +72 6 £610 -18.67%
West Midlands +25 6 £498 -0.44%
East Midlands - 6 £525 -
Wales - 3 £400 -

For the 6 months to 19 September 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 with a requirement for Apache Hive.

1 664 (94.32%) Hadoop
2 584 (82.95%) Big Data
3 517 (73.44%) Apache Spark
4 348 (49.43%) Java
5 285 (40.48%) Python
6 274 (38.92%) SQL
7 271 (38.49%) HBase
8 258 (36.65%) MapReduce
9 251 (35.65%) Agile Software Development
10 237 (33.66%) Kafka
11 225 (31.96%) HDFS
11 225 (31.96%) Impala
12 220 (31.25%) Apache Flume
13 201 (28.55%) Scala
14 198 (28.13%) Analytics
15 189 (26.85%) Cloudera
16 188 (26.70%) ETL
17 183 (25.99%) Linux
18 175 (24.86%) Sqoop
19 168 (23.86%) Finance
20 155 (22.02%) Apache Pig
21 153 (21.73%) Unix
22 149 (21.16%) Oozie
23 129 (18.32%) Amazon AWS
24 128 (18.18%) Hadoop YARN
25 119 (16.90%) Data Modelling
26 118 (16.76%) Open Source
27 116 (16.48%) DevOps
28 113 (16.05%) NoSQL
29 112 (15.91%) Analytical Skills

Apache Hive
Co-occurring IT Skills 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 517 (73.44%) Apache Spark
2 155 (22.02%) Apache Pig
3 78 (11.08%) Apache
4 57 (8.10%) Elasticsearch
5 46 (6.53%) Apache Solr
6 39 (5.54%) SAS
7 16 (2.27%) Tomcat
8 14 (1.99%) WebSphere
9 12 (1.70%) OpenStack
10 9 (1.28%) Cloud Foundry
10 9 (1.28%) GemFire
11 7 (0.99%) nginx
12 6 (0.85%) Apache Airflow
12 6 (0.85%) ArcGIS
13 5 (0.71%) JBoss
13 5 (0.71%) WebLogic
14 3 (0.43%) Confluence
14 3 (0.43%) Mule
14 3 (0.43%) SharePoint
15 2 (0.28%) Jupyter
Applications
1 12 (1.70%) Microsoft Excel
2 6 (0.85%) SPSS
3 5 (0.71%) Microsoft Office
3 5 (0.71%) Stata
4 2 (0.28%) Microsoft PowerPoint
5 1 (0.14%) GNU Octave
5 1 (0.14%) MS Visio
Business Applications
1 12 (1.70%) Actimize
2 1 (0.14%) SAP CRM
Cloud Services
1 129 (18.32%) Amazon AWS
2 73 (10.37%) GitHub
3 34 (4.83%) Microsoft Azure
4 32 (4.55%) Bluemix
4 32 (4.55%) IBM Cloud
5 25 (3.55%) Google Cloud Platform
6 22 (3.13%) Cloud Computing
7 18 (2.56%) Virtual Private Cloud
8 13 (1.85%) Amazon EC2
8 13 (1.85%) AWS Lambda
9 12 (1.70%) Amazon S3
10 10 (1.42%) SaaS
11 9 (1.28%) PaaS
12 8 (1.14%) Amazon EMR
12 8 (1.14%) Google Analytics
13 4 (0.57%) Amazon Kinesis
13 4 (0.57%) Azure Data Factory
13 4 (0.57%) IaaS
13 4 (0.57%) Slack
14 3 (0.43%) Azure Active Directory
Communications & Networking
1 47 (6.68%) Kerberos
2 15 (2.13%) LAN
3 14 (1.99%) VPN
3 14 (1.99%) WAN
4 9 (1.28%) Network Security
5 6 (0.85%) LDAP
6 5 (0.71%) Firewall
7 4 (0.57%) Skype
8 3 (0.43%) Internet
8 3 (0.43%) SNA
8 3 (0.43%) SSL
9 2 (0.28%) HTTP
10 1 (0.14%) Broadband
10 1 (0.14%) DNS
Database & Business Intelligence
1 664 (94.32%) Hadoop
2 584 (82.95%) Big Data
3 271 (38.49%) HBase
4 225 (31.96%) Impala
5 175 (24.86%) Sqoop
6 113 (16.05%) NoSQL
7 110 (15.63%) MongoDB
8 100 (14.20%) Data Warehouse
9 84 (11.93%) Apache Cassandra
10 67 (9.52%) SQL Server
11 58 (8.24%) PostgreSQL
12 45 (6.39%) Relational Database
13 38 (5.40%) Amazon Redshift
14 33 (4.69%) Data Lake
15 29 (4.12%) SQL Server Integration Services
16 26 (3.69%) RDBMS
17 25 (3.55%) Data Mining
18 23 (3.27%) MySQL
19 22 (3.13%) QlikView
20 20 (2.84%) SQL Server 2008
Development Applications
1 105 (14.91%) Jenkins
2 82 (11.65%) Git (software)
3 35 (4.97%) JIRA
4 32 (4.55%) JUnit
5 31 (4.40%) Maven
6 26 (3.69%) Team Foundation Server
7 21 (2.98%) Mockito
8 15 (2.13%) Gradle
8 15 (2.13%) Talend Open Studio
9 12 (1.70%) Eclipse
9 12 (1.70%) Subversion
10 11 (1.56%) IntelliJ
11 10 (1.42%) Sonatype Nexus
11 10 (1.42%) Vagrant
12 9 (1.28%) NUnit
13 8 (1.14%) Visual Studio
13 8 (1.14%) WebDriver
14 7 (0.99%) ProC
15 5 (0.71%) ClearCase
15 5 (0.71%) ERwin
General
1 168 (23.86%) Finance
2 73 (10.37%) Banking
3 38 (5.40%) Telecoms
4 26 (3.69%) Retail
5 20 (2.84%) Marketing
6 11 (1.56%) Electronics
6 11 (1.56%) Games
6 11 (1.56%) Investment Banking
7 10 (1.42%) Legal
7 10 (1.42%) Manufacturing
8 6 (0.85%) Front Office
8 6 (0.85%) Law
9 5 (0.71%) Pharmaceutical
10 3 (0.43%) Publishing
10 3 (0.43%) Retail Banking
11 2 (0.28%) Back Office
11 2 (0.28%) Billing
Job Titles
1 232 (32.95%) Developer
2 164 (23.30%) Data Engineer
3 134 (19.03%) Big Data Engineer
4 112 (15.91%) Big Data Developer
5 78 (11.08%) Hadoop Engineer
6 75 (10.65%) Java Developer
7 69 (9.80%) Architect
8 59 (8.38%) Hadoop Developer
9 47 (6.68%) Data Architect
10 41 (5.82%) Administrator
11 37 (5.26%) Data Scientist
12 34 (4.83%) Consultant
12 34 (4.83%) Hadoop Administrator
13 32 (4.55%) Scala Developer
14 29 (4.12%) DevOps Engineer
15 27 (3.84%) Analyst
15 27 (3.84%) Apache Spark Developer
15 27 (3.84%) Big Data Architect
16 23 (3.27%) Java Engineer
17 22 (3.13%) Cloud Engineer
Libraries, Frameworks & Software Standards
1 237 (33.66%) Kafka
2 78 (11.08%) Spark Streaming
3 60 (8.52%) Web Services
4 55 (7.81%) Spring
5 45 (6.39%) PySpark
6 43 (6.11%) JSON
7 28 (3.98%) XML
8 24 (3.41%) Akka
9 23 (3.27%) Cascading
9 23 (3.27%) RESTful
10 21 (2.98%) J2EE
11 20 (2.84%) Hibernate
11 20 (2.84%) REST
12 19 (2.70%) HTML
13 18 (2.56%) .NET
13 18 (2.56%) Apache Avro
14 17 (2.41%) Lucene
14 17 (2.41%) Node.js
14 17 (2.41%) Spring Boot
15 16 (2.27%) HTML5
Miscellaneous
1 112 (15.91%) Analytical Skills
2 67 (9.52%) Algorithms
3 35 (4.97%) Computer Science
4 28 (3.98%) Greenfield Project
5 20 (2.84%) Replication
6 18 (2.56%) Data Structures
7 15 (2.13%) Management Information System
8 14 (1.99%) Enterprise Software
8 14 (1.99%) Fintech
9 13 (1.85%) Linux Command Line
10 11 (1.56%) Reference Data
11 9 (1.28%) Virtual Team
12 8 (1.14%) Market Risk
13 7 (0.99%) Foreign Exchange (FX)
14 4 (0.57%) Distributed Denial-of-Service
14 4 (0.57%) User Experience
15 3 (0.43%) Data Centre
15 3 (0.43%) Digital Media
15 3 (0.43%) Private Cloud
15 3 (0.43%) Social Network
Operating Systems
1 183 (25.99%) Linux
2 153 (21.73%) Unix
3 53 (7.53%) Red Hat Enterprise Linux
4 30 (4.26%) Ubuntu
5 18 (2.56%) CentOS
6 15 (2.13%) Debian
7 11 (1.56%) Windows
8 3 (0.43%) Apple iOS
9 2 (0.28%) Android
9 2 (0.28%) Fedora
10 1 (0.14%) Mac OS X
10 1 (0.14%) Windows Server
Processes & Methodologies
1 258 (36.65%) MapReduce
2 251 (35.65%) Agile Software Development
3 198 (28.13%) Analytics
4 188 (26.70%) ETL
5 119 (16.90%) Data Modelling
6 118 (16.76%) Open Source
7 116 (16.48%) DevOps
8 102 (14.49%) TDD
9 95 (13.49%) Business Intelligence
10 91 (12.93%) Continuous Integration
11 83 (11.79%) Scrum
12 73 (10.37%) Machine Learning
13 71 (10.09%) Data Analytics
14 59 (8.38%) Software Engineering
15 55 (7.81%) BDD
16 54 (7.67%) Visualisation
17 51 (7.24%) Data Engineering
18 50 (7.10%) Data Architecture
19 46 (6.53%) Big Data Analytics
20 43 (6.11%) SDLC
Programming Languages
1 348 (49.43%) Java
2 285 (40.48%) Python
3 274 (38.92%) SQL
4 201 (28.55%) Scala
5 108 (15.34%) R
6 80 (11.36%) Shell Script
7 40 (5.68%) JavaScript
8 31 (4.40%) Bash Shell
9 29 (4.12%) C#
10 21 (2.98%) Perl
11 16 (2.27%) HiveQL
12 14 (1.99%) PL/SQL
13 13 (1.85%) T-SQL
14 9 (1.28%) TypeScript
14 9 (1.28%) VB.NET
15 8 (1.14%) MATLAB
16 7 (0.99%) Dart
16 7 (0.99%) PROC SQL
16 7 (0.99%) SAS Macro
17 6 (0.85%) C
Qualifications
1 60 (8.52%) Security Cleared
2 47 (6.68%) Degree
3 46 (6.53%) SC Cleared
4 18 (2.56%) Master's Degree
5 12 (1.70%) Computer Science Degree
6 10 (1.42%) CISSP
7 8 (1.14%) DV Cleared
8 7 (0.99%) CESG Certified Professional
8 7 (0.99%) CLAS
9 5 (0.71%) BPSS Clearance
9 5 (0.71%) PhD
10 4 (0.57%) CISA
10 4 (0.57%) CISM
10 4 (0.57%) Numerate Degree
11 1 (0.14%) DBS Check
11 1 (0.14%) SANS
Quality Assurance & Compliance
1 36 (5.11%) QA
2 30 (4.26%) Data Quality
3 6 (0.85%) JSP 440
3 6 (0.85%) PCI DSS
4 5 (0.71%) GDPR
5 4 (0.57%) FedRAMP
6 3 (0.43%) Dodd-Frank
6 3 (0.43%) IFRS
6 3 (0.43%) IFRS 9
6 3 (0.43%) MiFID
7 2 (0.28%) EMIR
7 2 (0.28%) SLA
8 1 (0.14%) Basel III
System Software
1 225 (31.96%) HDFS
2 220 (31.25%) Apache Flume
3 49 (6.96%) Docker
4 40 (5.68%) Apache ZooKeeper
5 6 (0.85%) Active Directory
6 2 (0.28%) Oracle RAC
Systems Management
1 149 (21.16%) Oozie
2 128 (18.18%) Hadoop YARN
3 61 (8.66%) Ansible
4 58 (8.24%) Ambari
5 23 (3.27%) Puppet
6 20 (2.84%) Kubernetes
6 20 (2.84%) Terraform
7 18 (2.56%) Opscode Chef
8 16 (2.27%) Prometheus
9 14 (1.99%) Control-M
10 10 (1.42%) Kibana
11 6 (0.85%) Mesos
12 4 (0.57%) logstash
13 3 (0.43%) HP Quality Center
14 2 (0.28%) Apache Slider
15 1 (0.14%) ArcSight ESM
15 1 (0.14%) Nagios
15 1 (0.14%) Packer
15 1 (0.14%) QRadar
Vendors
1 189 (26.85%) Cloudera
2 84 (11.93%) Tableau
3 82 (11.65%) Oracle
4 54 (7.67%) IBM
5 50 (7.10%) Red Hat
6 48 (6.82%) Hortonworks
7 46 (6.53%) Google
8 44 (6.25%) Informatica
9 28 (3.98%) Teradata
10 27 (3.84%) MapR
10 27 (3.84%) Microsoft
11 21 (2.98%) SAP
12 18 (2.56%) Splunk
13 15 (2.13%) Talend
14 9 (1.28%) Nuix
15 8 (1.14%) Salesforce.com
16 7 (0.99%) Ab Initio
17 6 (0.85%) ESRI
18 5 (0.71%) MicroStrategy
18 5 (0.71%) Palantir