Period
to 17 September 2021

The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 17 September 2021 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Central London > City of London
6 months to
17 Sep 2021
Same period 2020 Same period 2019
Rank 172 181 309
Rank change year-on-year +9 +128 +17
Permanent jobs citing Amazon Redshift 81 20 31
As % of all permanent jobs advertised in the City of London 1.38% 0.50% 0.31%
As % of the Database & Business Intelligence category 4.64% 1.89% 0.97%
Number of salaries quoted 74 13 26
10th Percentile £52,500 £48,500 £52,500
25th Percentile £65,500 £57,500 £56,750
Median annual salary (50th Percentile) £80,000 £97,500 £72,500
Median % change year-on-year -17.95% +34.48% +3.57%
75th Percentile £87,813 £117,500 £85,000
90th Percentile £93,375 £123,500 £98,750
Central London median annual salary £80,000 £92,500 £75,000
% change year-on-year -13.51% +23.33% +7.14%

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 the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 1,747 1,061 3,204
As % of all permanent IT jobs advertised in the City of London 29.67% 26.65% 31.63%
Number of salaries quoted 1,545 884 2,888
10th Percentile £46,250 £42,500 £42,500
25th Percentile £56,250 £52,500 £52,500
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £95,000 £85,000 £85,000
90th Percentile £108,750 £100,000 £99,125
Central London median annual salary £72,500 £70,000 £65,000
% change year-on-year +3.57% +7.69% +1.96%

Amazon Redshift
Job Vacancy Trend in the City of London

Job postings citing Amazon Redshift as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Amazon Redshift in the City of London

Amazon Redshift
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing Amazon Redshift in the City of London.

Salary trend for Amazon Redshift in the City of London

Amazon Redshift
Salary Histogram in the City of London

Salary distribution for jobs citing Amazon Redshift in the City of London over the 6 months to 17 September 2021.

Salary histogram for Amazon Redshift in the City of London

For the 6 months to 17 September 2021, 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 City of London region with a requirement for Amazon Redshift.

1 58 (71.60%) AWS
2 50 (61.73%) Analytics
3 48 (59.26%) Data Warehouse
4 45 (55.56%) Python
5 41 (50.62%) Big Data
5 41 (50.62%) Hadoop
6 40 (49.38%) Apache Spark
7 38 (46.91%) SQL
8 37 (45.68%) Java
9 36 (44.44%) Amazon S3
10 35 (43.21%) GCP
11 32 (39.51%) Data Engineering
11 32 (39.51%) Amazon RDS
12 29 (35.80%) Amazon EC2
13 27 (33.33%) Data Pipeline
14 26 (32.10%) Data Modelling
15 23 (28.40%) NoSQL
15 23 (28.40%) Software Engineering
15 23 (28.40%) BigQuery
16 21 (25.93%) Data Lake
16 21 (25.93%) Data Science
17 19 (23.46%) Open Source
18 18 (22.22%) ETL
18 18 (22.22%) Serverless
18 18 (22.22%) AWS Lambda
19 17 (20.99%) AWS CloudFormation
19 17 (20.99%) Relational Database
19 17 (20.99%) Agile Software Development
19 17 (20.99%) Degree
20 16 (19.75%) Azure

Amazon Redshift
Co-occurring IT Skills in the City of London 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 40 (49.38%) Apache Spark
2 13 (16.05%) Apache
3 5 (6.17%) Apache Airflow
4 3 (3.70%) SAS
5 2 (2.47%) Apache Pig
Cloud Services
1 58 (71.60%) AWS
2 36 (44.44%) Amazon S3
3 35 (43.21%) GCP
4 29 (35.80%) Amazon EC2
5 18 (22.22%) AWS Lambda
5 18 (22.22%) Serverless
6 17 (20.99%) AWS CloudFormation
7 16 (19.75%) Azure
8 14 (17.28%) Amazon EMR
8 14 (17.28%) Snowflake
9 12 (14.81%) Virtual Private Cloud
10 9 (11.11%) AWS Step Functions
11 6 (7.41%) AWS Data Pipeline
12 5 (6.17%) Power Platform
13 4 (4.94%) Amazon Kinesis
13 4 (4.94%) Amazon SQS
14 3 (3.70%) Amazon SageMaker
15 2 (2.47%) Azure Data Factory
15 2 (2.47%) Azure Synapse Analytics
15 2 (2.47%) Matillion
Database & Business Intelligence
1 48 (59.26%) Data Warehouse
2 41 (50.62%) Big Data
2 41 (50.62%) Hadoop
3 32 (39.51%) Amazon RDS
4 23 (28.40%) BigQuery
4 23 (28.40%) NoSQL
5 21 (25.93%) Data Lake
6 17 (20.99%) Relational Database
7 14 (17.28%) PostgreSQL
8 9 (11.11%) OLTP
9 8 (9.88%) MySQL
9 8 (9.88%) Tableau
10 7 (8.64%) Metadata
10 7 (8.64%) Spark SQL
11 6 (7.41%) Amazon Aurora
12 5 (6.17%) Apache Hive
12 5 (6.17%) Electronic Patient Records
12 5 (6.17%) Power BI
13 4 (4.94%) Looker
14 3 (3.70%) Impala
Development Applications
1 15 (18.52%) JIRA
2 7 (8.64%) Atlassian Bamboo
2 7 (8.64%) ER Studio
2 7 (8.64%) ERwin
2 7 (8.64%) PowerDesigner
3 6 (7.41%) Subversion
4 5 (6.17%) Toad
4 5 (6.17%) TortoiseSVN
5 4 (4.94%) Bitbucket
6 3 (3.70%) Git (software)
7 2 (2.47%) Jenkins
8 1 (1.23%) GitLab
8 1 (1.23%) Vagrant
General
1 14 (17.28%) Analytical Skills
2 9 (11.11%) Finance
3 7 (8.64%) Advertising
4 6 (7.41%) Social Skills
5 5 (6.17%) Banking
6 4 (4.94%) Investment Banking
6 4 (4.94%) Retail
7 3 (3.70%) Public Sector
8 1 (1.23%) Financial Institution
8 1 (1.23%) Law
8 1 (1.23%) Manufacturing
8 1 (1.23%) Marketing
Job Titles
1 41 (50.62%) Data Engineer
2 23 (28.40%) AWS Engineer
2 23 (28.40%) Big Data Engineer
2 23 (28.40%) Java Engineer
3 16 (19.75%) Big Data Software Engineer
3 16 (19.75%) Data Analytics Engineer
3 16 (19.75%) Java Software Engineer
3 16 (19.75%) Software Engineer
4 9 (11.11%) DevOps Engineer
5 7 (8.64%) Hadoop Engineer
5 7 (8.64%) Senior Data Engineer
6 6 (7.41%) Architect
6 6 (7.41%) Data Architect
7 5 (6.17%) Scala Engineer
7 5 (6.17%) Senior Scala Engineer
8 4 (4.94%) AWS DevOps
8 4 (4.94%) AWS DevOps Engineer
8 4 (4.94%) Cloud Engineer
9 3 (3.70%) Developer
9 3 (3.70%) Informatica Engineer
Libraries, Frameworks & Software Standards
1 12 (14.81%) Web Services
2 9 (11.11%) Kafka
3 5 (6.17%) PySpark
4 3 (3.70%) Node.js
5 2 (2.47%) Middleware
5 2 (2.47%) Spark Streaming
6 1 (1.23%) TensorFlow
Miscellaneous
1 4 (4.94%) Self-Motivation
2 3 (3.70%) Derivative
2 3 (3.70%) User Experience
3 1 (1.23%) Acoustics
3 1 (1.23%) Blog
3 1 (1.23%) Data Centre
3 1 (1.23%) Data Structures
3 1 (1.23%) e-Learning
3 1 (1.23%) Enterprise Software
3 1 (1.23%) Equities
3 1 (1.23%) Equity Derivative
3 1 (1.23%) Fixed Income
3 1 (1.23%) Greenfield Project
3 1 (1.23%) Management Information System
Operating Systems
1 7 (8.64%) Unix
2 4 (4.94%) Linux
2 4 (4.94%) Windows
2 4 (4.94%) Windows Server
Processes & Methodologies
1 50 (61.73%) Analytics
2 32 (39.51%) Data Engineering
3 27 (33.33%) Data Pipeline
4 26 (32.10%) Data Modelling
5 23 (28.40%) Software Engineering
6 21 (25.93%) Data Science
7 19 (23.46%) Open Source
8 18 (22.22%) ETL
9 17 (20.99%) Agile Software Development
10 15 (18.52%) Business Intelligence
10 15 (18.52%) Data Architecture
11 13 (16.05%) Data Transformation
11 13 (16.05%) Infrastructure as Code
12 12 (14.81%) Scrum
13 11 (13.58%) DevOps
13 11 (13.58%) Fintech
14 10 (12.35%) Computer Science
15 9 (11.11%) Data Analysis
16 7 (8.64%) Logical Data Model
16 7 (8.64%) Process Improvement
Programming Languages
1 45 (55.56%) Python
2 38 (46.91%) SQL
3 37 (45.68%) Java
4 8 (9.88%) Scala
5 5 (6.17%) JavaScript
6 3 (3.70%) HiveQL
6 3 (3.70%) PL/SQL
7 1 (1.23%) Go
7 1 (1.23%) Ruby
Qualifications
1 17 (20.99%) Degree
2 5 (6.17%) Computer Science Degree
2 5 (6.17%) Master's Degree
3 4 (4.94%) AWS Certification
Quality Assurance & Compliance
1 8 (9.88%) QA
2 6 (7.41%) Data Quality
System Software
1 4 (4.94%) Docker
2 3 (3.70%) HDFS
3 2 (2.47%) Apache Flume
4 1 (1.23%) VirtualBox
Systems Management
1 16 (19.75%) Terraform
2 9 (11.11%) Kubernetes
3 3 (3.70%) Ansible
4 1 (1.23%) Docker Swarm
Vendors
1 16 (19.75%) Talend
2 14 (17.28%) Oracle
3 8 (9.88%) Databricks
4 7 (8.64%) Microsoft
5 6 (7.41%) Google
6 4 (4.94%) Atlassian
6 4 (4.94%) Informatica
7 3 (3.70%) SnapLogic
8 2 (2.47%) SAP
8 2 (2.47%) Workday
9 1 (1.23%) Alteryx
9 1 (1.23%) Cloudera
9 1 (1.23%) Hortonworks
9 1 (1.23%) IBM