Period
to 24 February 2018

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for Amazon Redshift skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Amazon Redshift over the 6 months to 24 February 2018 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Scotland > Edinburgh
6 months to
24 Feb 2018
Same period 2017 Same period 2016
Rank 122 118 150
Rank change year-on-year -4 +32 +3
Permanent jobs citing Amazon Redshift 28 13 6
As % of all permanent IT jobs advertised in Edinburgh 1.05% 0.59% 0.22%
As % of the Database & Business Intelligence category 3.51% 1.98% 0.82%
Number of salaries quoted 3 13 0
Edinburgh median annual salary £62,000 £50,500 -
Median salary % change year-on-year +22.77% - -
Scotland median annual salary £62,000 £50,500 -
% change year-on-year +22.77% - -

Amazon Redshift 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 798 657 734
As % of all permanent IT jobs advertised in Edinburgh 29.99% 29.88% 26.50%
Number of salaries quoted 514 443 517
Edinburgh median annual salary £40,000 £42,500 £42,500
Median salary % change year-on-year -5.88% - +6.25%
10th Percentile £28,000 £28,750 £27,500
90th Percentile £65,000 £68,600 £63,100
Scotland median annual salary £42,500 £42,500 £41,500
% change year-on-year - +2.41% +3.75%

Amazon Redshift
Job Vacancy Trend in Edinburgh

Job postings citing Amazon Redshift as a percentage of all IT jobs advertised in Edinburgh.

Job vacancy trend for Amazon Redshift in Edinburgh

Amazon Redshift
Salary Trend in Edinburgh

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

Salary trend for Amazon Redshift in Edinburgh

Amazon Redshift
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Amazon Redshift in Edinburgh over the 6 months to 24 February 2018.

Salary histogram for Amazon Redshift in Edinburgh

For the 6 months to 24 February 2018, IT jobs citing Amazon Redshift 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 Amazon Redshift.

1 28 (100.00%) PostgreSQL
2 26 (92.86%) SQL
3 25 (89.29%) Relational Database
4 24 (85.71%) Python
5 22 (78.57%) Data Warehouse
5 22 (78.57%) Machine Learning
5 22 (78.57%) Data Science
6 21 (75.00%) Algorithms
6 21 (75.00%) Statistics
7 7 (25.00%) Software Engineering
8 6 (21.43%) Java
9 5 (17.86%) JavaScript
9 5 (17.86%) Analytics
9 5 (17.86%) MongoDB
9 5 (17.86%) Apache Cassandra
10 4 (14.29%) NoSQL
10 4 (14.29%) Vertica
10 4 (14.29%) MySQL
10 4 (14.29%) RDBMS
10 4 (14.29%) Marketing
11 3 (10.71%) Amazon AWS
11 3 (10.71%) Amazon EMR
12 2 (7.14%) Amazon DynamoDB
12 2 (7.14%) Elasticsearch
12 2 (7.14%) Google
12 2 (7.14%) PostGIS
12 2 (7.14%) Protocol Buffers
12 2 (7.14%) logstash
12 2 (7.14%) Ansible
12 2 (7.14%) Kibana

Amazon Redshift
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 2 (7.14%) Apache Spark
1 2 (7.14%) Elasticsearch
2 1 (3.57%) Apache
Cloud Services
1 3 (10.71%) Amazon AWS
1 3 (10.71%) Amazon EMR
2 2 (7.14%) Amazon EC2
2 2 (7.14%) Amazon S3
2 2 (7.14%) AWS CloudFormation
2 2 (7.14%) AWS Lambda
2 2 (7.14%) Serverless
3 1 (3.57%) Cloud Computing
3 1 (3.57%) Google Analytics
3 1 (3.57%) Google Cloud Platform
3 1 (3.57%) Microsoft Azure
Database & Business Intelligence
1 28 (100.00%) PostgreSQL
2 25 (89.29%) Relational Database
3 22 (78.57%) Data Warehouse
4 5 (17.86%) Apache Cassandra
4 5 (17.86%) MongoDB
5 4 (14.29%) MySQL
5 4 (14.29%) NoSQL
5 4 (14.29%) RDBMS
6 2 (7.14%) Amazon DynamoDB
6 2 (7.14%) Hadoop
6 2 (7.14%) OpenTSDB
6 2 (7.14%) Parquet
7 1 (3.57%) Apache Hive
7 1 (3.57%) Couchbase
7 1 (3.57%) Electronic Patient Records
General
1 4 (14.29%) Marketing
Job Titles
1 21 (75.00%) Data Scientist
2 6 (21.43%) Software Engineer
3 5 (17.86%) Senior Software Engineer
4 1 (3.57%) Cloud Engineer
4 1 (3.57%) Cloud Software Engineer
4 1 (3.57%) Data Engineer
4 1 (3.57%) Senior Cloud Engineer
4 1 (3.57%) Senior Web Engineer
4 1 (3.57%) Web Engineer
Libraries, Frameworks & Software Standards
1 2 (7.14%) Apache Flex
1 2 (7.14%) Apache Thrift
1 2 (7.14%) Elastic Stack
1 2 (7.14%) PostGIS
1 2 (7.14%) Protocol Buffers
2 1 (3.57%) .NET
2 1 (3.57%) CSS
2 1 (3.57%) HTML
2 1 (3.57%) Kafka
2 1 (3.57%) Node.js
2 1 (3.57%) Pandas
2 1 (3.57%) React
2 1 (3.57%) Samza
2 1 (3.57%) scikit-learn
Miscellaneous
1 21 (75.00%) Algorithms
2 1 (3.57%) Cloud Native
2 1 (3.57%) Data Centre
2 1 (3.57%) Greenfield Project
2 1 (3.57%) User Experience
Processes & Methodologies
1 22 (78.57%) Data Science
1 22 (78.57%) Machine Learning
2 21 (75.00%) Statistics
3 7 (25.00%) Software Engineering
4 5 (17.86%) Analytics
5 1 (3.57%) Agile Software Development
5 1 (3.57%) Artificial Intelligence
5 1 (3.57%) Business Intelligence
5 1 (3.57%) Continuous Deployment
5 1 (3.57%) CRM
5 1 (3.57%) Dashboard Development
5 1 (3.57%) Data Modelling
5 1 (3.57%) Low Latency
5 1 (3.57%) Open Source
Programming Languages
1 26 (92.86%) SQL
2 24 (85.71%) Python
3 6 (21.43%) Java
4 5 (17.86%) JavaScript
5 2 (7.14%) C#
6 1 (3.57%) C++
6 1 (3.57%) Ruby
6 1 (3.57%) Scala
System Software
1 1 (3.57%) HDFS
Systems Management
1 2 (7.14%) Ansible
1 2 (7.14%) Kibana
1 2 (7.14%) logstash
2 1 (3.57%) Mesos
Vendors
1 4 (14.29%) Vertica
2 2 (7.14%) Google