Period
to 21 July 2019

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 21 July 2019 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Scotland > Edinburgh
6 months to
21 Jul 2019
Same period 2018 Same period 2017
Rank 153 142 137
Rank change year-on-year -11 -5 +8
Permanent jobs citing Amazon Redshift 4 13 8
As % of all permanent IT jobs advertised in Edinburgh 0.15% 0.49% 0.32%
As % of the Database & Business Intelligence category 0.54% 1.81% 0.93%
Number of salaries quoted 4 7 5
Edinburgh median annual salary £55,000 £52,500 £65,000
Median salary % change year-on-year +4.76% -19.23% +62.50%
10th Percentile £49,000 £46,500 £48,050
90th Percentile £68,000 £59,200 £74,850
Scotland median annual salary £55,000 £52,500 £65,000
% change year-on-year +4.76% -19.23% +62.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 741 718 858
As % of all permanent IT jobs advertised in Edinburgh 27.61% 26.89% 34.29%
Number of salaries quoted 481 492 559
Edinburgh median annual salary £41,500 £45,000 £42,500
Median salary % change year-on-year -7.78% +5.88% -5.56%
10th Percentile £27,750 £28,000 £27,500
90th Percentile £63,750 £68,750 £70,000
Scotland median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -2.30%

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 21 July 2019.

Salary histogram for Amazon Redshift in Edinburgh

For the 6 months to 21 July 2019, 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 3 (75.00%) Agile Software Development
1 3 (75.00%) PostgreSQL
1 3 (75.00%) Amazon AWS
2 2 (50.00%) MySQL
2 2 (50.00%) SQL Server
2 2 (50.00%) Python
2 2 (50.00%) NoSQL
3 1 (25.00%) PMO
3 1 (25.00%) IT Strategy
3 1 (25.00%) Data Science
3 1 (25.00%) SQL Server 2017
3 1 (25.00%) Big Data
3 1 (25.00%) Amazon DynamoDB
3 1 (25.00%) Performance Tuning
3 1 (25.00%) Data Engineering
3 1 (25.00%) SQL Server 2016
3 1 (25.00%) SQL
3 1 (25.00%) Project Management
3 1 (25.00%) Change Management
3 1 (25.00%) Disaster Recovery
3 1 (25.00%) ITIL
3 1 (25.00%) PRINCE2
3 1 (25.00%) Bash Shell
3 1 (25.00%) Data Management
3 1 (25.00%) SQL Server Reporting Services
3 1 (25.00%) PowerShell
3 1 (25.00%) Database Tuning
3 1 (25.00%) Microsoft Azure

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:

Cloud Services
1 3 (75.00%) Amazon AWS
2 1 (25.00%) Microsoft Azure
Database & Business Intelligence
1 3 (75.00%) PostgreSQL
2 2 (50.00%) MySQL
2 2 (50.00%) NoSQL
2 2 (50.00%) SQL Server
3 1 (25.00%) Amazon DynamoDB
3 1 (25.00%) Big Data
3 1 (25.00%) SQL Server 2016
3 1 (25.00%) SQL Server 2017
3 1 (25.00%) SQL Server Reporting Services
Job Titles
1 2 (50.00%) Data Engineer
2 1 (25.00%) Administrator
2 1 (25.00%) Cloud Administrator
2 1 (25.00%) DBA
2 1 (25.00%) Head of Technology
2 1 (25.00%) SQL DBA
Processes & Methodologies
1 3 (75.00%) Agile Software Development
2 1 (25.00%) Change Management
2 1 (25.00%) Data Engineering
2 1 (25.00%) Data Management
2 1 (25.00%) Data Science
2 1 (25.00%) Database Tuning
2 1 (25.00%) Disaster Recovery
2 1 (25.00%) IT Strategy
2 1 (25.00%) ITIL
2 1 (25.00%) Performance Tuning
2 1 (25.00%) PRINCE2
2 1 (25.00%) Project Management
Programming Languages
1 2 (50.00%) Python
2 1 (25.00%) Bash Shell
2 1 (25.00%) PowerShell
2 1 (25.00%) SQL
Quality Assurance & Compliance
1 1 (25.00%) PMO