Period
to 21 October 2017

The following table provides summary statistics for permanent job vacancies 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 21 October 2017 with a comparison to the same period in the previous 2 years.

Apache Hive
UK
6 months to
21 Oct 2017
Same period 2016 Same period 2015
Rank 609 591 603
Rank change year-on-year -18 +12 +219
Permanent jobs citing Apache Hive 668 806 911
As % of all permanent IT jobs advertised in the UK 0.38% 0.42% 0.42%
As % of the Database & Business Intelligence category 1.26% 1.42% 1.32%
Number of salaries quoted 500 624 761
UK median annual salary £65,000 £60,000 £65,000
Median salary % change year-on-year +8.33% -7.69% -
10th Percentile £38,685 £40,000 £42,500
90th Percentile £102,500 £96,250 £90,500
UK excluding London median annual salary £52,750 £52,500 £50,000
% change year-on-year +0.48% +5.00% -13.04%

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 53070 56594 69157
As % of all permanent IT jobs advertised in the UK 30.49% 29.62% 31.57%
Number of salaries quoted 43594 48176 58326
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

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
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Apache Hive.

Salary trend for Apache Hive in the UK

Apache Hive
Salary Histogram

The salary distribution of IT jobs citing Apache Hive over the 6 months to 21 October 2017.

Salary histogram for Apache Hive in the UK

Apache Hive
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Apache Hive within the UK over the 6 months to 21 October 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
England -12 640 £67,000 +7.20% 42
London +10 426 £70,000 -6.67% 29
UK excluding London -72 236 £52,750 +0.48% 13
South East +45 88 £55,000 -4.35% 5
North of England +30 57 £60,000 +14.29% 4
North West +13 51 £60,000 +5.26% 3
East of England +29 32 £45,000 -25.00%
South West -86 26 £51,250 +2.50% 1
Scotland -32 13 £52,500 -
Midlands +10 11 £42,500 -22.73% 3
Wales +15 9 £35,000 -30.00%
West Midlands -6 9 £42,500 -22.73%
Yorkshire +15 6 £42,500 -20.93% 1
East Midlands +31 2 £38,750 -10.92% 3

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

1 585 (87.57%) Hadoop
2 528 (79.04%) Big Data
3 497 (74.40%) Apache Spark
4 356 (53.29%) Python
5 334 (50.00%) Java
6 331 (49.55%) Analytics
7 295 (44.16%) SQL
8 245 (36.68%) Agile Software Development
9 202 (30.24%) Scala
10 192 (28.74%) NoSQL
11 189 (28.29%) Machine Learning
12 185 (27.69%) HBase
13 179 (26.80%) MapReduce
14 171 (25.60%) Apache Pig
15 168 (25.15%) Finance
16 164 (24.55%) Kafka
17 159 (23.80%) Amazon AWS
18 158 (23.65%) Business Intelligence
19 146 (21.86%) R
20 145 (21.71%) Degree
21 142 (21.26%) HDFS
22 139 (20.81%) MongoDB
22 139 (20.81%) Linux
23 138 (20.66%) Analytical Skills
24 128 (19.16%) ETL
25 126 (18.86%) Data Analytics
26 120 (17.96%) Visualisation
27 119 (17.81%) Impala
28 114 (17.07%) Computer Science
29 108 (16.17%) Apache Cassandra

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 497 (74.40%) Apache Spark
2 171 (25.60%) Apache Pig
3 92 (13.77%) SAS
4 81 (12.13%) Apache
5 48 (7.19%) Elasticsearch
6 40 (5.99%) Apache Solr
7 14 (2.10%) Apache Airflow
7 14 (2.10%) WebSphere
8 13 (1.95%) OpenStack
9 6 (0.90%) Oracle SOA Suite
10 5 (0.75%) JBoss
10 5 (0.75%) WebLogic
11 3 (0.45%) Tomcat
12 2 (0.30%) IPython
12 2 (0.30%) Oracle Coherence
13 1 (0.15%) CMS
13 1 (0.15%) Jupyter
Applications
1 41 (6.14%) Microsoft Excel
2 29 (4.34%) SPSS
3 10 (1.50%) Spreadsheet
4 5 (0.75%) Stata
5 4 (0.60%) S-PLUS
6 3 (0.45%) Microsoft PowerPoint
7 2 (0.30%) GNU Octave
7 2 (0.30%) Microsoft Office
7 2 (0.30%) Weka
8 1 (0.15%) LaTeX
8 1 (0.15%) MS Visio
Business Applications
1 11 (1.65%) SAP ERP
1 11 (1.65%) SAP InfiniteInsight
2 1 (0.15%) Dynamics CRM
2 1 (0.15%) Oracle Applications
Cloud Services
1 159 (23.80%) Amazon AWS
2 88 (13.17%) Microsoft Azure
3 49 (7.34%) Google Cloud Platform
4 32 (4.79%) Amazon EMR
5 31 (4.64%) Cloud Computing
6 14 (2.10%) Amazon Kinesis
6 14 (2.10%) AWS Lambda
7 12 (1.80%) SaaS
8 11 (1.65%) Amazon EC2
8 11 (1.65%) Serverless
9 10 (1.50%) Amazon S3
10 6 (0.90%) Azure Machine Learning
11 4 (0.60%) GitHub
11 4 (0.60%) PaaS
12 3 (0.45%) AWS CloudFormation
12 3 (0.45%) AWS Elastic Beanstalk
12 3 (0.45%) Basecamp
12 3 (0.45%) IaaS
12 3 (0.45%) Trello
12 3 (0.45%) Virtual Private Cloud
Communications & Networking
1 9 (1.35%) Kerberos
2 7 (1.05%) HTTP
3 6 (0.90%) LDAP
4 5 (0.75%) SSL
5 4 (0.60%) TCP/IP
6 3 (0.45%) Firewall
6 3 (0.45%) Internet
7 2 (0.30%) Broadband
8 1 (0.15%) Network Security
Database & Business Intelligence
1 585 (87.57%) Hadoop
2 528 (79.04%) Big Data
3 192 (28.74%) NoSQL
4 185 (27.69%) HBase
5 139 (20.81%) MongoDB
6 119 (17.81%) Impala
7 108 (16.17%) Apache Cassandra
8 104 (15.57%) Relational Database
9 81 (12.13%) Data Warehouse
10 77 (11.53%) Sqoop
11 72 (10.78%) SQL Server
12 70 (10.48%) QlikView
13 57 (8.53%) MySQL
14 55 (8.23%) Data Mining
15 50 (7.49%) RDBMS
16 29 (4.34%) Amazon Redshift
16 29 (4.34%) Power BI
17 27 (4.04%) BusinessObjects
18 25 (3.74%) Pentaho
18 25 (3.74%) Qlik Sense
Development Applications
1 27 (4.04%) Jenkins
2 22 (3.29%) Git (software)
3 20 (2.99%) Talend Open Studio
4 14 (2.10%) JIRA
4 14 (2.10%) Vagrant
5 12 (1.80%) Maven
6 11 (1.65%) gulp
6 11 (1.65%) webpack
7 7 (1.05%) Selenium
8 6 (0.90%) NUnit
9 3 (0.45%) Artifactory
9 3 (0.45%) Atlassian Bamboo
9 3 (0.45%) Bitbucket
9 3 (0.45%) Eclipse
10 2 (0.30%) CodeSonar
10 2 (0.30%) EasyMock
10 2 (0.30%) git-flow
10 2 (0.30%) Mockito
10 2 (0.30%) Oracle APEX
10 2 (0.30%) Robot Framework
General
1 168 (25.15%) Finance
2 79 (11.83%) Retail
3 49 (7.34%) Banking
4 48 (7.19%) Games
5 43 (6.44%) Marketing
6 15 (2.25%) Telecoms
7 13 (1.95%) Investment Banking
8 12 (1.80%) Front Office
9 11 (1.65%) Legal
10 10 (1.50%) Spanish Language
11 8 (1.20%) Advertising
12 4 (0.60%) Dutch Language
12 4 (0.60%) French Language
12 4 (0.60%) German Language
12 4 (0.60%) Italian Language
12 4 (0.60%) Law
13 3 (0.45%) Brand Awareness
13 3 (0.45%) Electronics
14 2 (0.30%) Automotive
14 2 (0.30%) Retail Banking
Job Titles
1 142 (21.26%) Developer
2 122 (18.26%) Data Engineer
3 104 (15.57%) Data Scientist
4 85 (12.72%) Big Data Engineer
5 78 (11.68%) Architect
6 61 (9.13%) Data Architect
7 51 (7.63%) Software Engineer
8 49 (7.34%) Big Data Architect
9 48 (7.19%) Big Data Developer
10 45 (6.74%) Data Manager
11 44 (6.59%) Consultant
12 34 (5.09%) Hadoop Engineer
13 32 (4.79%) Data Consultant
14 30 (4.49%) Analyst
14 30 (4.49%) Analytics Consultant
15 29 (4.34%) Java Developer
16 25 (3.74%) Data Analyst
17 24 (3.59%) Data Analytics Consultant
18 22 (3.29%) Analytics Manager
19 21 (3.14%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 164 (24.55%) Kafka
2 69 (10.33%) Web Services
3 37 (5.54%) JSON
4 36 (5.39%) XML
5 34 (5.09%) HTML
5 34 (5.09%) Node.js
6 33 (4.94%) Natural Language Processing
7 31 (4.64%) CSS
7 31 (4.64%) Spring
8 30 (4.49%) Java EE
9 25 (3.74%) TensorFlow
10 24 (3.59%) RESTful
11 23 (3.44%) REST
12 22 (3.29%) AngularJS
13 20 (2.99%) scikit-learn
14 19 (2.84%) HTML5
14 19 (2.84%) Pandas
14 19 (2.84%) RabbitMQ
14 19 (2.84%) React
15 18 (2.69%) Spark Streaming
Miscellaneous
1 138 (20.66%) Analytical Skills
2 114 (17.07%) Computer Science
3 64 (9.58%) Algorithms
4 43 (6.44%) Greenfield Project
5 24 (3.59%) Data Structures
6 19 (2.84%) Foreign Exchange (FX)
7 18 (2.69%) Fintech
8 16 (2.40%) PKI
9 12 (1.80%) Derivative
9 12 (1.80%) Fixed Income
10 9 (1.35%) Public Cloud
11 8 (1.20%) Interest Rate Derivative
11 8 (1.20%) N-Tier
12 7 (1.05%) Hybrid Cloud
12 7 (1.05%) Virtual Team
13 6 (0.90%) Blog
13 6 (0.90%) Cyberthreat
13 6 (0.90%) Management Information System
14 5 (0.75%) BBC
14 5 (0.75%) Online Games
Operating Systems
1 139 (20.81%) Linux
2 29 (4.34%) Unix
3 26 (3.89%) Windows
4 6 (0.90%) Android
4 6 (0.90%) Mac OS X
5 5 (0.75%) Apple iOS
5 5 (0.75%) Red Hat Enterprise Linux
6 4 (0.60%) openSUSE
6 4 (0.60%) SUSE
6 4 (0.60%) Ubuntu
7 2 (0.30%) Solaris
8 1 (0.15%) Mesosphere
Processes & Methodologies
1 331 (49.55%) Analytics
2 245 (36.68%) Agile Software Development
3 189 (28.29%) Machine Learning
4 179 (26.80%) MapReduce
5 158 (23.65%) Business Intelligence
6 128 (19.16%) ETL
7 126 (18.86%) Data Analytics
8 120 (17.96%) Visualisation
9 104 (15.57%) Software Engineering
10 99 (14.82%) Data Modelling
11 98 (14.67%) Statistics
12 83 (12.43%) Mathematics
13 82 (12.28%) Data Visualisation
14 78 (11.68%) DevOps
15 75 (11.23%) TDD
16 60 (8.98%) Continuous Integration
17 53 (7.93%) Scrum
18 50 (7.49%) Open Source
18 50 (7.49%) Statistical Modelling
19 48 (7.19%) Data Architecture
Programming Languages
1 356 (53.29%) Python
2 334 (50.00%) Java
3 295 (44.16%) SQL
4 202 (30.24%) Scala
5 146 (21.86%) R
6 69 (10.33%) C++
7 66 (9.88%) JavaScript
8 41 (6.14%) MATLAB
9 37 (5.54%) C#
10 33 (4.94%) C
11 28 (4.19%) VBA
12 25 (3.74%) Ruby
13 23 (3.44%) Perl
14 21 (3.14%) Shell Script
15 16 (2.40%) Go
16 15 (2.25%) PHP
17 14 (2.10%) VB
18 13 (1.95%) T-SQL
19 12 (1.80%) Bash Shell
20 11 (1.65%) ES6
Qualifications
1 145 (21.71%) Degree
2 49 (7.34%) PhD
3 40 (5.99%) Security Cleared
4 35 (5.24%) DV Cleared
5 27 (4.04%) Master's Degree
6 25 (3.74%) Computer Science Degree
6 25 (3.74%) Numerate Degree
7 14 (2.10%) SC Cleared
8 4 (0.60%) Microsoft Certification
9 3 (0.45%) CCNA
9 3 (0.45%) Cisco Certification
9 3 (0.45%) CISSP
9 3 (0.45%) GIAC
9 3 (0.45%) Linux+ Certification
9 3 (0.45%) MCSE
9 3 (0.45%) Network+ Certification
9 3 (0.45%) Postgraduate
9 3 (0.45%) SANS
9 3 (0.45%) SSCP
10 2 (0.30%) CompTIA Security+
Quality Assurance & Compliance
1 44 (6.59%) Data Quality
2 18 (2.69%) QA
3 4 (0.60%) GCP
4 3 (0.45%) Actionable Recommendations
5 1 (0.15%) PMO
5 1 (0.15%) SLA
System Software
1 142 (21.26%) HDFS
2 97 (14.52%) Apache Flume
3 55 (8.23%) Docker
4 9 (1.35%) Apache ZooKeeper
5 8 (1.20%) VMware Infrastructure
6 7 (1.05%) Hyper-V
7 2 (0.30%) Active Directory
7 2 (0.30%) vSphere
8 1 (0.15%) Cronacle
8 1 (0.15%) MapR-FS
8 1 (0.15%) Oracle RAC
8 1 (0.15%) Virtual Machines
Systems Management
1 72 (10.78%) Oozie
2 24 (3.59%) Hadoop YARN
3 21 (3.14%) Opscode Chef
4 19 (2.84%) Mesos
5 18 (2.69%) Kubernetes
6 17 (2.54%) Puppet
6 17 (2.54%) Terraform
7 14 (2.10%) Ansible
8 11 (1.65%) Ambari
9 8 (1.20%) Graphite
9 8 (1.20%) Kibana
10 4 (0.60%) Grafana
10 4 (0.60%) Nagios
11 3 (0.45%) Salt
12 2 (0.30%) QRadar
12 2 (0.30%) Systems Management Server (SMS)
13 1 (0.15%) Control-M
13 1 (0.15%) Data Guard
13 1 (0.15%) Docker Swarm
13 1 (0.15%) yum
Vendors
1 107 (16.02%) Tableau
2 105 (15.72%) Cloudera
3 104 (15.57%) Oracle
4 58 (8.68%) Google
5 57 (8.53%) Hortonworks
6 44 (6.59%) Microsoft
7 37 (5.54%) MapR
8 35 (5.24%) SAP
9 28 (4.19%) Teradata
9 28 (4.19%) Vertica
10 27 (4.04%) Cognos
11 22 (3.29%) IBM
12 21 (3.14%) Splunk
13 20 (2.99%) Talend
14 15 (2.25%) Informatica
15 12 (1.80%) MicroStrategy
16 9 (1.35%) Ab Initio
17 8 (1.20%) VMware
18 7 (1.05%) Greenplum
18 7 (1.05%) HP