Apache Hive Contracts

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 3 months to 24 June 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
Location	3 months to 24 Jun 2017	Same period 2016	Same period 2015
Rank	323	431	540
Rank change year-on-year	+108	+109
Contract jobs citing Apache Hive	304	219	106
As % of all contract IT jobs advertised in the UK	0.66%	0.41%	0.19%
As % of the Database & Business Intelligence category	2.93%	1.86%	0.80%
Number of daily rates quoted	202	168	70
Median daily rate	£488	£544	£550
Median daily rate % change year-on-year	-10.34%	-1.13%
90% offered a daily rate of more than	£365	£400	£400
10% offered a daily rate of more than	£625	£703	£703
UK excluding London median daily rate	£401	£525	£425
% change year-on-year	-23.71%	+23.52%
Number of hourly rates quoted	0	0	0
Median hourly rate	-	-	-
UK excluding London median hourly rate	-	-	-

Apache Hive is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills UK
Contract job vacancies with a requirement for database and business intelligence skills	10382	11757	13183
As % of all contract IT job vacancies advertised in the UK	22.44%	21.86%	23.50%
Number of daily rates quoted	6788	7965	8622
Median daily rate	£450	£425	£400
Median daily rate % change year-on-year	+5.88%	+6.25%
90% offered a daily rate of more than	£325	£300	£275
10% offered a daily rate of more than	£600	£600	£550
UK excluding London median daily rate	£400	£383	£350
% change year-on-year	+4.57%	+9.28%
Number of hourly rates quoted	142	195	185
Median hourly rate	£31.50	£31.27	£26.75
Median hourly rate % change year-on-year	+0.73%	+16.89%
90% offered a hourly rate of more than	£13.20	£12.00	£15.35
10% offered a hourly rate of more than	£50.00	£49.00	£52.17
UK excluding London median hourly rate	£38.00	£31.00	£26.00
% change year-on-year	+22.58%	+19.23%

Apache Hive
Job Vacancy Trend

The job posting trend of jobs advertised citing Apache Hive as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 24 June 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 30 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 3 months to 24 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location	Rank Change on Same Period Last Year	Matching Contract IT Job Ads	Median Daily Rate Last 3 Months	Median Daily Rate % Change on Same Period Last Year	Live Job Vacancies
England	+96	279	£493	-9.42%	61
London	+30	174	£513	-6.81%	35
South East	+41	41	£401	+1.71%	9
City of London	+6	29	£514	-3.29%	6
East of England	+18	28	£450	-30.76%	3
South West	-	23	£425	-	1
Norfolk	-	23	£450	-
Norwich	-	23	£450	-
Hampshire	+34	21	£401	-33.25%
Somerset	-	15	£425	-
County Antrim	-30	13	£365	-
Northern Ireland	-36	13	£365	-
Taunton	-	12	£425	-
Belfast	-35	11	£365	-
Buckinghamshire	-12	10	£388	-	6
Scotland	+52	8	£350	-	5
Milton Keynes	-7	7	£388	-	6
Edinburgh	-	7	£350	-	3
West Midlands	+26	5	£496	-0.88%
Berkshire	+23	5	£350	-17.64%	3
Hook	-	5	£250	-
Surrey	0	4	£525	-4.54%
Yorkshire	+7	3	-	-	8
Shropshire	-	3	£496	-
Cobham	-	3	£475	-
Southampton	-	3	£400	-
Telford	-	3	£496	-
Essex	-	3	£550	-
Reading	+16	2	£425	-19.04%	1
Sheffield	-1	2	-	-

Apache Hive
Top 30 Co-occurring IT Skills

For the 6 months to 24 June 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	581 (94.32%)	Hadoop
2	466 (75.65%)	Big Data
3	394 (63.96%)	Apache Spark
4	281 (45.62%)	Java
5	255 (41.40%)	Python
6	227 (36.85%)	HBase
7	210 (34.09%)	Scala
8	208 (33.77%)	SQL
9	199 (32.31%)	Agile Software Development
10	186 (30.19%)	Linux
11	172 (27.92%)	Cloudera
12	163 (26.46%)	Apache Pig
13	159 (25.81%)	HDFS
14	158 (25.65%)	Analytics
15	157 (25.49%)	Impala

16	156 (25.32%)	Kafka
17	142 (23.05%)	MapReduce
18	138 (22.40%)	Amazon AWS
19	134 (21.75%)	ETL
20	133 (21.59%)	Finance
21	126 (20.45%)	Unix
21	126 (20.45%)	Apache Flume
22	111 (18.02%)	Oozie
23	110 (17.86%)	R
24	102 (16.56%)	MongoDB
25	101 (16.40%)	Sqoop
26	96 (15.58%)	DevOps
27	95 (15.42%)	NoSQL
28	93 (15.10%)	Hadoop YARN
28	93 (15.10%)	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
Applications
Business Applications
Cloud Services
Communications & Networking
Database & Business Intelligence
Development Applications
General
Job Titles
Libraries, Frameworks & Software Standards
Miscellaneous
Operating Systems
Processes & Methodologies
Programming Languages
Qualifications
Quality Assurance & Compliance
System Software
Systems Management
Vendors

Application Platforms
1	394 (63.96%)	Apache Spark
2	163 (26.46%)	Apache Pig
3	63 (10.23%)	Apache
4	50 (8.12%)	Elasticsearch
5	44 (7.14%)	Apache Solr
6	42 (6.82%)	SAS
7	9 (1.46%)	WebSphere
8	8 (1.30%)	Tomcat
9	7 (1.14%)	nginx
10	6 (0.97%)	Apache Airflow
10	6 (0.97%)	ArcGIS
10	6 (0.97%)	Confluence
10	6 (0.97%)	WebLogic
11	5 (0.81%)	Jupyter
12	4 (0.65%)	JBoss
13	3 (0.49%)	Mule
13	3 (0.49%)	OpenStack
14	2 (0.32%)	Adobe Experience Manager
14	2 (0.32%)	CMS
14	2 (0.32%)	SharePoint

Applications
1	13 (2.11%)	SPSS
2	12 (1.95%)	Microsoft Excel
3	5 (0.81%)	Microsoft Office
3	5 (0.81%)	Stata
4	3 (0.49%)	Microsoft PowerPoint
4	3 (0.49%)	Weka
5	1 (0.16%)	MS Visio

Business Applications
1	7 (1.14%)	Actimize
2	6 (0.97%)	SAP Oil and Gas
3	1 (0.16%)	Oracle BPM
3	1 (0.16%)	SAP MDG
3	1 (0.16%)	SAP MDM

Cloud Services
1	138 (22.40%)	Amazon AWS
2	34 (5.52%)	Amazon EMR
3	28 (4.55%)	Amazon S3
3	28 (4.55%)	Cloud Computing
4	24 (3.90%)	Amazon EC2
5	22 (3.57%)	Microsoft Azure
5	22 (3.57%)	Virtual Private Cloud
6	12 (1.95%)	AWS Lambda
7	8 (1.30%)	Google Cloud Platform
8	7 (1.14%)	SaaS
9	6 (0.97%)	AWS Data Pipeline
9	6 (0.97%)	IaaS
10	5 (0.81%)	Amazon Kinesis
11	4 (0.65%)	Amazon SQS
11	4 (0.65%)	GitHub
12	3 (0.49%)	PaaS
13	2 (0.32%)	Bluemix
13	2 (0.32%)	IBM Cloud
14	1 (0.16%)	Amazon CloudWatch
14	1 (0.16%)	BIME

Communications & Networking
1	41 (6.66%)	Kerberos
2	10 (1.62%)	LDAP
3	8 (1.30%)	HTTP
4	7 (1.14%)	Internet
4	7 (1.14%)	Network Security
4	7 (1.14%)	SSL
5	5 (0.81%)	Firewall
6	4 (0.65%)	Skype
7	3 (0.49%)	FTP
8	2 (0.32%)	SNA
9	1 (0.16%)	DNS
9	1 (0.16%)	SMS
9	1 (0.16%)	TCP/IP

Database & Business Intelligence
1	581 (94.32%)	Hadoop
2	466 (75.65%)	Big Data
3	227 (36.85%)	HBase
4	157 (25.49%)	Impala
5	102 (16.56%)	MongoDB
6	101 (16.40%)	Sqoop
7	95 (15.42%)	NoSQL
8	89 (14.45%)	Apache Cassandra
9	87 (14.12%)	Data Warehouse
10	57 (9.25%)	SQL Server
11	47 (7.63%)	Relational Database
12	37 (6.01%)	Neo4j
13	35 (5.68%)	QlikView
14	30 (4.87%)	Amazon Redshift
14	30 (4.87%)	MySQL
15	28 (4.55%)	PostgreSQL
15	28 (4.55%)	RDBMS
16	26 (4.22%)	Data Lake
17	24 (3.90%)	SQL Server Integration Services
18	20 (3.25%)	Data Mining

Development Applications
1	75 (12.18%)	Jenkins
2	64 (10.39%)	Git (software)
3	32 (5.19%)	JIRA
4	29 (4.71%)	Maven
5	24 (3.90%)	JUnit
6	18 (2.92%)	Mockito
7	13 (2.11%)	Eclipse
7	13 (2.11%)	Talend Open Studio
8	11 (1.79%)	Team Foundation Server
8	11 (1.79%)	Vagrant
8	11 (1.79%)	WebDriver
9	10 (1.62%)	Sonatype Nexus
10	8 (1.30%)	Subversion
11	6 (0.97%)	Gradle
11	6 (0.97%)	NUnit
12	5 (0.81%)	Hudson
12	5 (0.81%)	ProC
13	4 (0.65%)	IntelliJ
13	4 (0.65%)	Visual Studio
14	3 (0.49%)	ClearCase

General
1	133 (21.59%)	Finance
2	80 (12.99%)	Banking
3	23 (3.73%)	Retail
3	23 (3.73%)	Telecoms
4	22 (3.57%)	Investment Banking
5	21 (3.41%)	Legal
6	19 (3.08%)	Marketing
7	11 (1.79%)	Games
8	9 (1.46%)	Front Office
9	7 (1.14%)	Law
10	6 (0.97%)	Electronics
10	6 (0.97%)	Manufacturing
10	6 (0.97%)	Retail Banking
11	4 (0.65%)	Financial Institution
12	3 (0.49%)	Corporate Banking
13	2 (0.32%)	Billing
13	2 (0.32%)	Pharmaceutical
14	1 (0.16%)	German Language
14	1 (0.16%)	Publishing

Job Titles
1	211 (34.25%)	Developer
2	120 (19.48%)	Data Engineer
3	99 (16.07%)	Big Data Engineer
4	97 (15.75%)	Big Data Developer
5	79 (12.82%)	Java Developer
6	67 (10.88%)	Hadoop Developer
7	55 (8.93%)	Hadoop Engineer
8	53 (8.60%)	Architect
9	48 (7.79%)	Administrator
10	43 (6.98%)	Data Architect
11	41 (6.66%)	DevOps Engineer
12	38 (6.17%)	AWS Engineer
13	36 (5.84%)	Analyst
14	35 (5.68%)	Hadoop Administrator
15	34 (5.52%)	Consultant
15	34 (5.52%)	Data Scientist
16	30 (4.87%)	Scala Developer
17	25 (4.06%)	Java Hadoop Developer
18	24 (3.90%)	Linux Administrator
19	23 (3.73%)	Cloud Engineer

Libraries, Frameworks & Software Standards
1	156 (25.32%)	Kafka
2	41 (6.66%)	Spring
3	34 (5.52%)	Web Services
4	32 (5.19%)	JSON
5	31 (5.03%)	Spark Streaming
6	24 (3.90%)	Akka
7	21 (3.41%)	Cascading
8	20 (3.25%)	HTML
9	19 (3.08%)	Hibernate
9	19 (3.08%)	XML
10	17 (2.76%)	REST
11	16 (2.60%)	Apache Avro
11	16 (2.60%)	CSS
12	14 (2.27%)	HTML5
13	13 (2.11%)	AngularJS
14	12 (1.95%)	Apache Commons
14	12 (1.95%)	Play Framework
15	11 (1.79%)	Ajax
15	11 (1.79%)	jQuery
15	11 (1.79%)	Lucene

Miscellaneous
1	93 (15.10%)	Analytical Skills
2	72 (11.69%)	Algorithms
3	40 (6.49%)	Computer Science
4	38 (6.17%)	Data Structures
5	22 (3.57%)	Reference Data
6	20 (3.25%)	Greenfield Project
7	19 (3.08%)	Management Information System
8	8 (1.30%)	Fintech
9	7 (1.14%)	Enterprise Software
9	7 (1.14%)	Linux Command Line
10	6 (0.97%)	Replication
11	5 (0.81%)	Foreign Exchange (FX)
11	5 (0.81%)	Grid Computing
12	4 (0.65%)	Credit Risk
12	4 (0.65%)	Distributed Denial-of-Service
13	3 (0.49%)	Data Centre
13	3 (0.49%)	Equities
13	3 (0.49%)	Private Cloud
13	3 (0.49%)	User Experience
14	2 (0.32%)	Derivative

Operating Systems
1	186 (30.19%)	Linux
2	126 (20.45%)	Unix
3	48 (7.79%)	Red Hat Enterprise Linux
4	25 (4.06%)	Ubuntu
5	19 (3.08%)	Debian
6	17 (2.76%)	CentOS
7	12 (1.95%)	Windows
8	6 (0.97%)	Fedora
9	4 (0.65%)	Apple iOS
10	3 (0.49%)	Android
11	1 (0.16%)	AIX
11	1 (0.16%)	Windows Server

Processes & Methodologies
1	199 (32.31%)	Agile Software Development
2	158 (25.65%)	Analytics
3	142 (23.05%)	MapReduce
4	134 (21.75%)	ETL
5	96 (15.58%)	DevOps
6	84 (13.64%)	Data Modelling
7	78 (12.66%)	Machine Learning
8	74 (12.01%)	Business Intelligence
9	71 (11.53%)	Data Analytics
10	70 (11.36%)	Open Source
11	56 (9.09%)	Data Architecture
12	55 (8.93%)	Continuous Integration
13	54 (8.77%)	TDD
14	53 (8.60%)	Software Engineering
15	46 (7.47%)	Scrum
16	43 (6.98%)	Visualisation
17	41 (6.66%)	Data Integration
18	40 (6.49%)	Performance Tuning
18	40 (6.49%)	SDLC
19	39 (6.33%)	Data Analysis

Programming Languages
1	281 (45.62%)	Java
2	255 (41.40%)	Python
3	210 (34.09%)	Scala
4	208 (33.77%)	SQL
5	110 (17.86%)	R
6	56 (9.09%)	Bash Shell
7	42 (6.82%)	Perl
8	41 (6.66%)	Shell Script
9	29 (4.71%)	JavaScript
10	17 (2.76%)	C#
11	16 (2.60%)	PL/SQL
12	15 (2.44%)	Ruby
12	15 (2.44%)	T-SQL
13	10 (1.62%)	C
13	10 (1.62%)	C++
14	7 (1.14%)	Dart
14	7 (1.14%)	MATLAB
15	6 (0.97%)	HiveQL
15	6 (0.97%)	PowerShell
15	6 (0.97%)	TypeScript

Qualifications
1	50 (8.12%)	Degree
2	44 (7.14%)	Security Cleared
3	31 (5.03%)	SC Cleared
4	16 (2.60%)	Computer Science Degree
4	16 (2.60%)	Master's Degree
5	10 (1.62%)	CISSP
5	10 (1.62%)	Numerate Degree
6	7 (1.14%)	CESG Certified Professional
6	7 (1.14%)	CLAS
7	6 (0.97%)	DV Cleared
8	5 (0.81%)	PhD
9	4 (0.65%)	BPSS Clearance
9	4 (0.65%)	CISA
9	4 (0.65%)	CISM
10	1 (0.16%)	DBS Check
10	1 (0.16%)	SANS

Quality Assurance & Compliance
1	34 (5.52%)	Data Quality
2	16 (2.60%)	QA
3	6 (0.97%)	JSP 440
3	6 (0.97%)	PCI DSS
4	5 (0.81%)	SLA
5	4 (0.65%)	FedRAMP
6	2 (0.32%)	Dodd-Frank
6	2 (0.32%)	EMIR
6	2 (0.32%)	MiFID
7	1 (0.16%)	GDPR

System Software
1	159 (25.81%)	HDFS
2	126 (20.45%)	Apache Flume
3	49 (7.95%)	Docker
4	43 (6.98%)	Apache ZooKeeper
5	10 (1.62%)	Active Directory
6	3 (0.49%)	Oracle RAC
7	2 (0.32%)	vSphere
8	1 (0.16%)	Cronacle
8	1 (0.16%)	Virtual Machines
8	1 (0.16%)	VMware ESXi

Systems Management
1	111 (18.02%)	Oozie
2	93 (15.10%)	Hadoop YARN
3	60 (9.74%)	Ansible
4	46 (7.47%)	Puppet
5	40 (6.49%)	Opscode Chef
6	26 (4.22%)	Terraform
7	12 (1.95%)	Ambari
7	12 (1.95%)	Kibana
7	12 (1.95%)	Mesos
8	10 (1.62%)	Kubernetes
9	8 (1.30%)	Nagios
10	4 (0.65%)	logstash
11	2 (0.32%)	Salt
12	1 (0.16%)	ArcSight ESM
12	1 (0.16%)	Business Desktop Deployment
12	1 (0.16%)	Control-M
12	1 (0.16%)	QRadar
12	1 (0.16%)	Tivoli

Vendors
1	172 (27.92%)	Cloudera
2	69 (11.20%)	Oracle
3	50 (8.12%)	Tableau
4	38 (6.17%)	Hortonworks
5	36 (5.84%)	Red Hat
6	29 (4.71%)	Informatica
7	28 (4.55%)	Splunk
8	27 (4.38%)	MapR
9	21 (3.41%)	Microsoft
9	21 (3.41%)	Nuix
10	18 (2.92%)	Google
11	16 (2.60%)	Ab Initio
12	14 (2.27%)	MicroStrategy
12	14 (2.27%)	Teradata
13	13 (2.11%)	IBM
13	13 (2.11%)	Talend
14	12 (1.95%)	Cognos
14	12 (1.95%)	SAP
15	6 (0.97%)	ESRI
16	5 (0.81%)	Vertica