Period
to 15 November 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 15 November 2018 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Scotland > Edinburgh
6 months to
15 Nov 2018
Same period 2017 Same period 2016
Rank 138 130 129
Rank change year-on-year -8 -1 +26
Permanent jobs citing Amazon Redshift 10 19 8
As % of all permanent IT jobs advertised in Edinburgh 0.39% 0.70% 0.34%
As % of the Database & Business Intelligence category 1.45% 2.06% 1.26%
Number of salaries quoted 10 3 8
Edinburgh median annual salary £55,000 £45,000 £40,000
Median salary % change year-on-year +22.22% +12.50% -
10th Percentile £49,125 £37,500 £35,000
90th Percentile £67,500 £68,500 £73,625
Scotland median annual salary £53,750 £45,000 £40,000
% change year-on-year +19.44% +12.50% -

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 689 923 635
As % of all permanent IT jobs advertised in Edinburgh 27.13% 34.02% 27.31%
Number of salaries quoted 477 584 447
Edinburgh median annual salary £45,000 £40,000 £45,000
Median salary % change year-on-year +12.50% -11.11% +12.50%
10th Percentile £26,750 £27,000 £27,000
90th Percentile £70,000 £62,500 £62,500
Scotland median annual salary £45,000 £42,000 £42,500
% change year-on-year +7.14% -1.18% +6.25%

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 15 November 2018.

Salary histogram for Amazon Redshift in Edinburgh

For the 6 months to 15 November 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 10 (100.00%) Amazon AWS
2 8 (80.00%) Hadoop
2 8 (80.00%) Amazon S3
2 8 (80.00%) Apache Spark
2 8 (80.00%) AWS Lambda
2 8 (80.00%) Serverless
3 7 (70.00%) HDFS
3 7 (70.00%) Amazon EMR
3 7 (70.00%) Python
4 6 (60.00%) SQL
4 6 (60.00%) Software Engineering
4 6 (60.00%) Ruby
4 6 (60.00%) Analytics
4 6 (60.00%) Kafka
4 6 (60.00%) Apache Hive
4 6 (60.00%) Amazon EC2
5 5 (50.00%) R
5 5 (50.00%) Big Data
5 5 (50.00%) Apache Pig
5 5 (50.00%) Sqoop
5 5 (50.00%) Java
5 5 (50.00%) ETL
5 5 (50.00%) Oozie
5 5 (50.00%) Data Science
6 4 (40.00%) Data Centre
6 4 (40.00%) Amazon DynamoDB
6 4 (40.00%) Amazon RDS
6 4 (40.00%) Elasticsearch
6 4 (40.00%) Scala
7 3 (30.00%) Open Source

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 8 (80.00%) Apache Spark
2 5 (50.00%) Apache Pig
3 4 (40.00%) Elasticsearch
4 2 (20.00%) SAS
5 1 (10.00%) Apache
Cloud Services
1 10 (100.00%) Amazon AWS
2 8 (80.00%) Amazon S3
2 8 (80.00%) AWS Lambda
2 8 (80.00%) Serverless
3 7 (70.00%) Amazon EMR
4 6 (60.00%) Amazon EC2
5 2 (20.00%) Amazon ElastiCache
5 2 (20.00%) Amazon ELB
5 2 (20.00%) Amazon Kinesis
5 2 (20.00%) AWS CloudFormation
5 2 (20.00%) Cloud Computing
5 2 (20.00%) SaaS
5 2 (20.00%) Virtual Private Cloud
6 1 (10.00%) AWS Data Pipeline
6 1 (10.00%) Google Analytics
6 1 (10.00%) Google Cloud Platform
Database & Business Intelligence
1 8 (80.00%) Hadoop
2 6 (60.00%) Apache Hive
3 5 (50.00%) Big Data
3 5 (50.00%) Sqoop
4 4 (40.00%) Amazon DynamoDB
4 4 (40.00%) Amazon RDS
5 3 (30.00%) Data Warehouse
5 3 (30.00%) PostgreSQL
6 2 (20.00%) MySQL
6 2 (20.00%) NoSQL
6 2 (20.00%) OpenTSDB
6 2 (20.00%) Parquet
7 1 (10.00%) Apache Kudu
7 1 (10.00%) BigQuery
7 1 (10.00%) Data Lake
7 1 (10.00%) Data Mining
7 1 (10.00%) HBase
7 1 (10.00%) Impala
7 1 (10.00%) Presto
7 1 (10.00%) Relational Database
Job Titles
1 5 (50.00%) AWS Consultant
1 5 (50.00%) Consultant
2 3 (30.00%) Big Data Consultant
2 3 (30.00%) Data Consultant
3 2 (20.00%) Cloud Consultant
3 2 (20.00%) Junior
3 2 (20.00%) Operations Team Leader
3 2 (20.00%) Senior Software Engineer
3 2 (20.00%) Senior Web Engineer
3 2 (20.00%) Software Engineer
3 2 (20.00%) Team Leader
3 2 (20.00%) Web Engineer
4 1 (10.00%) Cloud Engineer
4 1 (10.00%) Cloud Software Engineer
4 1 (10.00%) Data Engineer
4 1 (10.00%) Senior Cloud Engineer
4 1 (10.00%) Solutions Consultant
Libraries, Frameworks & Software Standards
1 6 (60.00%) Kafka
2 2 (20.00%) Apache Flex
2 2 (20.00%) Apache Thrift
2 2 (20.00%) Elastic Stack
2 2 (20.00%) Node.js
2 2 (20.00%) PostGIS
2 2 (20.00%) Protocol Buffers
2 2 (20.00%) RabbitMQ
2 2 (20.00%) Ruby on Rails
2 2 (20.00%) Samza
2 2 (20.00%) Web Services
Miscellaneous
1 4 (40.00%) Data Centre
2 3 (30.00%) Analytical Skills
2 3 (30.00%) Private Cloud
2 3 (30.00%) Public Cloud
3 2 (20.00%) Cloud Native
3 2 (20.00%) Enterprise Cloud
4 1 (10.00%) Analytical Mindset
4 1 (10.00%) Computer Science
4 1 (10.00%) Self-Motivation
Operating Systems
1 2 (20.00%) SmartOS
2 1 (10.00%) Linux
Processes & Methodologies
1 6 (60.00%) Analytics
1 6 (60.00%) Software Engineering
2 5 (50.00%) Data Science
2 5 (50.00%) ETL
3 3 (30.00%) Open Source
3 3 (30.00%) Problem-Solving
4 2 (20.00%) Agile Software Development
4 2 (20.00%) Business Intelligence
4 2 (20.00%) Coaching
4 2 (20.00%) Continuous Delivery
4 2 (20.00%) Continuous Deployment
4 2 (20.00%) Customer Requirements
4 2 (20.00%) Data Modelling
4 2 (20.00%) Decision-Making
4 2 (20.00%) Line Management
4 2 (20.00%) Low Latency
4 2 (20.00%) MapReduce
4 2 (20.00%) Mentoring
4 2 (20.00%) Tech Ops
5 1 (10.00%) Performance Tuning
Programming Languages
1 7 (70.00%) Python
2 6 (60.00%) Ruby
2 6 (60.00%) SQL
3 5 (50.00%) Java
3 5 (50.00%) R
4 4 (40.00%) Scala
5 2 (20.00%) Bash Shell
5 2 (20.00%) C#
5 2 (20.00%) PHP
Qualifications
1 1 (10.00%) Computer Science Degree
1 1 (10.00%) Degree
1 1 (10.00%) Numerate Degree
System Software
1 7 (70.00%) HDFS
2 1 (10.00%) Docker
Systems Management
1 5 (50.00%) Oozie
2 2 (20.00%) Ansible
2 2 (20.00%) Kibana
2 2 (20.00%) logstash
2 2 (20.00%) Mesos
2 2 (20.00%) Puppet
2 2 (20.00%) Terraform
3 1 (10.00%) Kubernetes
Vendors
1 2 (20.00%) Google
2 1 (10.00%) Cloudera