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

Amazon Redshift
Scotland > Edinburgh
6 months to
23 May 2018
Same period 2017 Same period 2016
Rank 131 125 138
Rank change year-on-year -6 +13 -
Permanent jobs citing Amazon Redshift 18 9 4
As % of all permanent IT jobs advertised in Edinburgh 0.69% 0.41% 0.16%
As % of the Database & Business Intelligence category 2.58% 1.19% 0.58%
Number of salaries quoted 1 8 0
Edinburgh median annual salary £62,000 £56,500 -
Median salary % change year-on-year +9.73% - -
Scotland median annual salary £55,000 £56,500 -
% change year-on-year -2.65% - -

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 697 756 694
As % of all permanent IT jobs advertised in Edinburgh 26.55% 34.36% 27.51%
Number of salaries quoted 462 491 444
Edinburgh median annual salary £42,500 £42,500 £45,000
Median salary % change year-on-year - -5.56% +12.50%
10th Percentile £28,000 £28,750 £29,000
90th Percentile £67,375 £70,000 £65,000
Scotland median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +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

For the 6 months to 23 May 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 17 (94.44%) SQL
1 17 (94.44%) Relational Database
2 16 (88.89%) PostgreSQL
3 14 (77.78%) Python
4 12 (66.67%) Data Warehouse
4 12 (66.67%) Statistics
4 12 (66.67%) Data Science
5 11 (61.11%) Algorithms
5 11 (61.11%) Machine Learning
6 6 (33.33%) Analytics
7 5 (27.78%) Vertica
7 5 (27.78%) NoSQL
7 5 (27.78%) Software Engineering
7 5 (27.78%) Java
8 4 (22.22%) RDBMS
8 4 (22.22%) JavaScript
8 4 (22.22%) MySQL
8 4 (22.22%) Marketing
8 4 (22.22%) MongoDB
8 4 (22.22%) Apache Cassandra
9 2 (11.11%) R
9 2 (11.11%) Kafka
9 2 (11.11%) Amazon EMR
9 2 (11.11%) Amazon DynamoDB
9 2 (11.11%) HDFS
9 2 (11.11%) Computer Science
9 2 (11.11%) Hadoop
9 2 (11.11%) Amazon EC2
9 2 (11.11%) Amazon S3
9 2 (11.11%) Amazon AWS

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 (11.11%) Apache Spark
2 1 (5.56%) Apache Pig
2 1 (5.56%) Elasticsearch
2 1 (5.56%) SAS
Cloud Services
1 2 (11.11%) Amazon AWS
1 2 (11.11%) Amazon EC2
1 2 (11.11%) Amazon EMR
1 2 (11.11%) Amazon S3
1 2 (11.11%) AWS Lambda
1 2 (11.11%) Serverless
2 1 (5.56%) AWS CloudFormation
2 1 (5.56%) AWS Data Pipeline
2 1 (5.56%) Cloud Computing
Database & Business Intelligence
1 17 (94.44%) Relational Database
2 16 (88.89%) PostgreSQL
3 12 (66.67%) Data Warehouse
4 5 (27.78%) NoSQL
5 4 (22.22%) Apache Cassandra
5 4 (22.22%) MongoDB
5 4 (22.22%) MySQL
5 4 (22.22%) RDBMS
6 2 (11.11%) Amazon DynamoDB
6 2 (11.11%) Hadoop
7 1 (5.56%) Amazon RDS
7 1 (5.56%) Apache Hive
7 1 (5.56%) Big Data
7 1 (5.56%) OpenTSDB
7 1 (5.56%) Parquet
7 1 (5.56%) Sqoop
General
1 4 (22.22%) Marketing
Job Titles
1 11 (61.11%) Data Scientist
2 5 (27.78%) Senior Software Engineer
2 5 (27.78%) Software Engineer
3 1 (5.56%) Analyst
3 1 (5.56%) AWS Consultant
3 1 (5.56%) Cloud Engineer
3 1 (5.56%) Cloud Software Engineer
3 1 (5.56%) Consultant
3 1 (5.56%) Data Analyst
3 1 (5.56%) Senior Cloud Engineer
3 1 (5.56%) Senior Web Engineer
3 1 (5.56%) Web Engineer
Libraries, Frameworks & Software Standards
1 2 (11.11%) Kafka
2 1 (5.56%) Apache Flex
2 1 (5.56%) Apache Thrift
2 1 (5.56%) Elastic Stack
2 1 (5.56%) PostGIS
2 1 (5.56%) Protocol Buffers
2 1 (5.56%) Samza
Miscellaneous
1 11 (61.11%) Algorithms
2 2 (11.11%) Computer Science
3 1 (5.56%) Analytical Mindset
3 1 (5.56%) Analytical Skills
3 1 (5.56%) Cloud Native
3 1 (5.56%) Data Centre
3 1 (5.56%) Private Cloud
3 1 (5.56%) Public Cloud
Processes & Methodologies
1 12 (66.67%) Data Science
1 12 (66.67%) Statistics
2 11 (61.11%) Machine Learning
3 6 (33.33%) Analytics
4 5 (27.78%) Software Engineering
5 1 (5.56%) Agile Software Development
5 1 (5.56%) Biology
5 1 (5.56%) Continuous Deployment
5 1 (5.56%) Customer Requirements
5 1 (5.56%) Data Analysis
5 1 (5.56%) Decision-Making
5 1 (5.56%) ETL
5 1 (5.56%) Low Latency
5 1 (5.56%) MapReduce
5 1 (5.56%) Migration
5 1 (5.56%) Open Source
5 1 (5.56%) Physics
5 1 (5.56%) Presales
5 1 (5.56%) Statistical Computing
Programming Languages
1 17 (94.44%) SQL
2 14 (77.78%) Python
3 5 (27.78%) Java
4 4 (22.22%) JavaScript
5 2 (11.11%) R
6 1 (5.56%) C#
6 1 (5.56%) Ruby
6 1 (5.56%) Scala
Qualifications
1 1 (5.56%) Computer Science Degree
1 1 (5.56%) Degree
1 1 (5.56%) Numerate Degree
System Software
1 2 (11.11%) HDFS
Systems Management
1 1 (5.56%) Ansible
1 1 (5.56%) Kibana
1 1 (5.56%) logstash
1 1 (5.56%) Mesos
1 1 (5.56%) Oozie
Vendors
1 5 (27.78%) Vertica