Period
to 19 October 2018

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

Amazon Redshift
Scotland > Glasgow
6 months to
19 Oct 2018
Same period 2017 Same period 2016
Rank 149 142 150
Rank change year-on-year -7 +8 -
Permanent jobs citing Amazon Redshift 8 9 1
As % of all permanent IT jobs advertised in Glasgow 0.37% 0.40% 0.044%
As % of the Database & Business Intelligence category 0.89% 0.98% 0.11%
Number of salaries quoted 9 0 1
Glasgow median annual salary £52,500 - £40,000
10th Percentile £47,250 - £35,000
90th Percentile £55,250 - £45,000
Scotland median annual salary £52,500 £45,000 £40,000
% change year-on-year +16.67% +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 Glasgow with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Glasgow
Permanent vacancies with a requirement for database or business intelligence skills 903 920 886
As % of all permanent IT jobs advertised in Glasgow 41.27% 41.14% 39.08%
Number of salaries quoted 676 546 402
Glasgow median annual salary £47,500 £45,000 £42,500
Median salary % change year-on-year +5.56% +5.88% -
10th Percentile £32,500 £31,438 £28,500
90th Percentile £65,000 £70,000 £62,375
Scotland median annual salary £45,000 £41,500 £43,000
% change year-on-year +8.43% -3.49% +6.83%

Amazon Redshift
Job Vacancy Trend in Glasgow

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

Job vacancy trend for Amazon Redshift in Glasgow

Amazon Redshift
Salary Trend in Glasgow

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

Salary trend for Amazon Redshift in Glasgow

Amazon Redshift
Salary Histogram in Glasgow

The salary distribution of IT jobs citing Amazon Redshift in Glasgow over the 6 months to 19 October 2018.

Salary histogram for Amazon Redshift in Glasgow

For the 6 months to 19 October 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 Glasgow region with a requirement for Amazon Redshift.

1 8 (100.00%) SQL
1 8 (100.00%) Amazon AWS
2 7 (87.50%) Hadoop
2 7 (87.50%) Apache Hive
2 7 (87.50%) Analytics
2 7 (87.50%) Apache Spark
3 6 (75.00%) HDFS
3 6 (75.00%) Apache Pig
3 6 (75.00%) Sqoop
3 6 (75.00%) Amazon EMR
3 6 (75.00%) Big Data
3 6 (75.00%) Oozie
3 6 (75.00%) R
3 6 (75.00%) ETL
3 6 (75.00%) SAS
4 4 (50.00%) Data Science
5 2 (25.00%) Critical Thinking
5 2 (25.00%) Analytical Thinking
5 2 (25.00%) Analytical Mindset
5 2 (25.00%) Analytical Skills
5 2 (25.00%) Machine Learning
5 2 (25.00%) Software Engineering
5 2 (25.00%) Python
6 1 (12.50%) CRM
6 1 (12.50%) Data Warehouse
6 1 (12.50%) Data Modelling
6 1 (12.50%) PostgreSQL
6 1 (12.50%) Data Analysis
6 1 (12.50%) Logistics
6 1 (12.50%) Google

Amazon Redshift
Co-occurring IT Skills in Glasgow 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 (87.50%) Apache Spark
2 6 (75.00%) Apache Pig
2 6 (75.00%) SAS
Cloud Services
1 8 (100.00%) Amazon AWS
2 6 (75.00%) Amazon EMR
3 1 (12.50%) Amazon EC2
3 1 (12.50%) Cloud Computing
3 1 (12.50%) Google Analytics
3 1 (12.50%) Google Cloud Platform
Database & Business Intelligence
1 7 (87.50%) Apache Hive
1 7 (87.50%) Hadoop
2 6 (75.00%) Big Data
2 6 (75.00%) Sqoop
3 1 (12.50%) Data Warehouse
3 1 (12.50%) NoSQL
3 1 (12.50%) PostgreSQL
Job Titles
1 6 (75.00%) AWS Consultant
1 6 (75.00%) Consultant
2 5 (62.50%) Big Data Consultant
2 5 (62.50%) Data Consultant
3 1 (12.50%) Data Engineer
3 1 (12.50%) Data Scientist
3 1 (12.50%) Senior Data Scientist
Miscellaneous
1 2 (25.00%) Analytical Mindset
1 2 (25.00%) Analytical Skills
2 1 (12.50%) Algorithms
Processes & Methodologies
1 7 (87.50%) Analytics
2 6 (75.00%) ETL
3 4 (50.00%) Data Science
4 2 (25.00%) Analytical Thinking
4 2 (25.00%) Critical Thinking
4 2 (25.00%) Machine Learning
4 2 (25.00%) Software Engineering
5 1 (12.50%) Business Intelligence
5 1 (12.50%) CRM
5 1 (12.50%) Data Analysis
5 1 (12.50%) Data Modelling
5 1 (12.50%) Database Tuning
5 1 (12.50%) Logistics
5 1 (12.50%) Open Source
5 1 (12.50%) Operations Research
5 1 (12.50%) Performance Tuning
5 1 (12.50%) Predictive Modelling
5 1 (12.50%) Statistical Modelling
Programming Languages
1 8 (100.00%) SQL
2 6 (75.00%) R
3 2 (25.00%) Python
4 1 (12.50%) Java
4 1 (12.50%) Scala
System Software
1 6 (75.00%) HDFS
Systems Management
1 6 (75.00%) Oozie
Vendors
1 1 (12.50%) Google