Period
to 21 March 2019

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

Apache Hive
Scotland > Edinburgh
6 months to
21 Mar 2019
Same period 2018 Same period 2017
Rank 139 131 100
Rank change year-on-year -8 -31 +45
Permanent jobs citing Apache Hive 7 21 39
As % of all permanent IT jobs advertised in Edinburgh 0.28% 0.79% 1.76%
As % of the Database & Business Intelligence category 1.11% 2.77% 5.58%
Number of salaries quoted 1 3 15
Edinburgh median annual salary £65,000 £45,000 £77,500
Median salary % change year-on-year +44.44% -41.94% +29.17%
10th Percentile £52,500 £42,500 £51,400
90th Percentile £77,500 £97,500 £91,250
Scotland median annual salary £66,250 £45,000 £77,500
% change year-on-year +47.22% -41.94% +72.22%

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

All Database and Business Intelligence Skills
Edinburgh
Permanent vacancies with a requirement for database or business intelligence skills 632 757 699
As % of all permanent IT jobs advertised in Edinburgh 25.61% 28.61% 31.49%
Number of salaries quoted 438 501 456
Edinburgh median annual salary £42,500 £40,000 £45,000
Median salary % change year-on-year +6.25% -11.11% +5.88%
10th Percentile £27,750 £28,000 £30,000
90th Percentile £70,000 £65,000 £70,000
Scotland median annual salary £45,000 £45,000 £43,500
% change year-on-year - +3.45% +3.57%

Apache Hive
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Apache Hive in Edinburgh

Apache Hive
Salary Trend in Edinburgh

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

Salary trend for Apache Hive in Edinburgh

For the 6 months to 21 March 2019, IT jobs citing Apache Hive also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Edinburgh region with a requirement for Apache Hive.

1 7 (100.00%) Python
1 7 (100.00%) Scala
1 7 (100.00%) Hadoop
1 7 (100.00%) Big Data
1 7 (100.00%) Apache Spark
2 6 (85.71%) Anti-Money Laundering
2 6 (85.71%) Analytics
2 6 (85.71%) Apache Pig
2 6 (85.71%) Ambari
2 6 (85.71%) R
2 6 (85.71%) Data Science
2 6 (85.71%) Open Source
2 6 (85.71%) Java
2 6 (85.71%) SQL
2 6 (85.71%) MATLAB
3 5 (71.43%) Finance
3 5 (71.43%) Oracle
3 5 (71.43%) PL/SQL
3 5 (71.43%) Degree
3 5 (71.43%) Computer Science
3 5 (71.43%) Banking
3 5 (71.43%) Google
3 5 (71.43%) Google Analytics
4 4 (57.14%) Machine Learning
4 4 (57.14%) Functional Programming
4 4 (57.14%) Analytical Skills
4 4 (57.14%) Support Vector Machines
4 4 (57.14%) Decision Tree
4 4 (57.14%) Data Analysis
4 4 (57.14%) Regression Analysis

Apache Hive
Co-occurring IT Skills in Edinburgh 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 7 (100.00%) Apache Spark
2 6 (85.71%) Apache Pig
3 3 (42.86%) SAS
Applications
1 3 (42.86%) Microsoft Excel
1 3 (42.86%) Microsoft PowerPoint
1 3 (42.86%) MS Visio
Cloud Services
1 5 (71.43%) Google Analytics
Database & Business Intelligence
1 7 (100.00%) Big Data
1 7 (100.00%) Hadoop
2 3 (42.86%) QlikView
2 3 (42.86%) SAS Visual Analytics
3 1 (14.29%) Data Lake
General
1 5 (71.43%) Banking
1 5 (71.43%) Finance
2 3 (42.86%) Private Banking
2 3 (42.86%) Retail Banking
Job Titles
1 5 (71.43%) Analyst
2 3 (42.86%) Senior Analyst
3 1 (14.29%) Analytics Developer
3 1 (14.29%) Big Data Engineer
3 1 (14.29%) Data Engineer
3 1 (14.29%) Developer
3 1 (14.29%) Risk Analyst
3 1 (14.29%) Software Developer
Miscellaneous
1 4 (57.14%) Analytical Skills
2 3 (42.86%) Management Information System
Processes & Methodologies
1 6 (85.71%) Analytics
1 6 (85.71%) Anti-Money Laundering
1 6 (85.71%) Data Science
1 6 (85.71%) Open Source
2 5 (71.43%) Computer Science
3 4 (57.14%) Data Analysis
3 4 (57.14%) Data Modelling
3 4 (57.14%) Decision Tree
3 4 (57.14%) Functional Programming
3 4 (57.14%) Machine Learning
3 4 (57.14%) Regression Analysis
3 4 (57.14%) Support Vector Machines
4 3 (42.86%) Asset Management
4 3 (42.86%) Information Security
4 3 (42.86%) Regulatory Compliance
4 3 (42.86%) Risk Management
4 3 (42.86%) Visual Analytics
4 3 (42.86%) Wealth Management
5 1 (14.29%) Agile Software Development
5 1 (14.29%) Statistics
Programming Languages
1 7 (100.00%) Python
1 7 (100.00%) Scala
2 6 (85.71%) Java
2 6 (85.71%) MATLAB
2 6 (85.71%) R
2 6 (85.71%) SQL
3 5 (71.43%) PL/SQL
Qualifications
1 5 (71.43%) Degree
Systems Management
1 6 (85.71%) Ambari
Vendors
1 5 (71.43%) Google
1 5 (71.43%) Oracle
2 3 (42.86%) Platfora
2 3 (42.86%) Tableau