Period
to 19 June 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 19 June 2021 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Central London > City of London
6 months to
19 Jun 2021
Same period 2020 Same period 2019
Rank 153 213 293
Rank change year-on-year +60 +80 +34
Permanent jobs citing Amazon Redshift 80 39 43
As % of all permanent jobs advertised in the City of London 1.53% 0.63% 0.43%
As % of the Database & Business Intelligence category 5.27% 2.67% 1.37%
Number of salaries quoted 71 29 37
10th Percentile £52,500 £47,250 £43,250
25th Percentile £65,000 £47,500 £55,000
Median annual salary (50th Percentile) £80,000 £70,000 £70,000
Median % change year-on-year +14.29% - -12.50%
75th Percentile £85,000 £97,500 £81,250
90th Percentile " £113,500 £110,000
Central London median annual salary £80,000 £71,250 £70,000
% change year-on-year +12.28% +1.79% -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 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,519 1,461 3,132
As % of all permanent IT jobs advertised in the City of London 29.05% 23.55% 31.09%
Number of salaries quoted 1,349 1,278 2,845
10th Percentile £45,000 £42,500 £42,500
25th Percentile £53,750 £52,500 £52,095
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £88,750 £83,750 £85,000
90th Percentile £107,500 £96,250 £97,500
Central London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +4.00%

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 19 June 2021.

Salary histogram for Amazon Redshift in the City of London

Amazon Redshift
Job Locations in the City of London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Amazon Redshift within the City of London region over the 6 months to 19 June 2021. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge - 1 £80,000 -
Amazon Redshift
Central London

For the 6 months to 19 June 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 51 (63.75%) AWS
2 48 (60.00%) Hadoop
2 48 (60.00%) Analytics
3 47 (58.75%) Big Data
4 44 (55.00%) SQL
4 44 (55.00%) Apache Spark
5 43 (53.75%) Data Warehouse
6 42 (52.50%) Java
7 33 (41.25%) Data Engineering
8 31 (38.75%) GCP
9 30 (37.50%) Data Lake
10 28 (35.00%) Open Source
11 27 (33.75%) Python
12 26 (32.50%) Amazon EC2
13 25 (31.25%) Software Engineering
13 25 (31.25%) BigQuery
13 25 (31.25%) Amazon RDS
14 24 (30.00%) ETL
15 23 (28.75%) NoSQL
15 23 (28.75%) Data Pipeline
16 21 (26.25%) Business Intelligence
17 20 (25.00%) Data Modelling
18 19 (23.75%) Talend
18 19 (23.75%) Data Transformation
19 18 (22.50%) Relational Database
19 18 (22.50%) Apache
20 17 (21.25%) Amazon S3
21 16 (20.00%) PostgreSQL
22 15 (18.75%) Data Architecture
22 15 (18.75%) Data Science

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 44 (55.00%) Apache Spark
2 18 (22.50%) Apache
3 2 (2.50%) Apache Airflow
3 2 (2.50%) Apache Pig
Cloud Services
1 51 (63.75%) AWS
2 31 (38.75%) GCP
3 26 (32.50%) Amazon EC2
4 17 (21.25%) Amazon S3
5 11 (13.75%) AWS CloudFormation
5 11 (13.75%) Azure
6 9 (11.25%) Snowflake
7 7 (8.75%) Power Platform
8 6 (7.50%) AWS Data Pipeline
8 6 (7.50%) Azure Data Factory
9 5 (6.25%) AWS Lambda
9 5 (6.25%) Serverless
10 3 (3.75%) AWS KMS
10 3 (3.75%) AWS Step Functions
10 3 (3.75%) Azure Active Directory
10 3 (3.75%) Azure Functions
10 3 (3.75%) Azure Key Vault
10 3 (3.75%) Azure Storage
10 3 (3.75%) Azure Synapse Analytics
10 3 (3.75%) SaaS
Database & Business Intelligence
1 48 (60.00%) Hadoop
2 47 (58.75%) Big Data
3 43 (53.75%) Data Warehouse
4 30 (37.50%) Data Lake
5 25 (31.25%) Amazon RDS
5 25 (31.25%) BigQuery
6 23 (28.75%) NoSQL
7 18 (22.50%) Relational Database
8 16 (20.00%) PostgreSQL
9 14 (17.50%) Tableau
10 9 (11.25%) Spark SQL
11 7 (8.75%) BusinessObjects
11 7 (8.75%) MySQL
11 7 (8.75%) OLTP
11 7 (8.75%) Power BI
11 7 (8.75%) Yellowfin
12 6 (7.50%) SQL Server
13 3 (3.75%) Azure SQL Database
13 3 (3.75%) Looker
13 3 (3.75%) QlikView
Development Applications
1 13 (16.25%) JIRA
2 5 (6.25%) ER Studio
2 5 (6.25%) ERwin
2 5 (6.25%) PowerDesigner
3 4 (5.00%) Jenkins
4 3 (3.75%) Subversion
4 3 (3.75%) TeamCity
4 3 (3.75%) Toad
4 3 (3.75%) TortoiseSVN
5 2 (2.50%) Atlassian Bamboo
5 2 (2.50%) Git (software)
General
1 13 (16.25%) Analytical Skills
2 9 (11.25%) Social Skills
3 6 (7.50%) Advertising
4 3 (3.75%) Finance
5 2 (2.50%) Influencing Skills
5 2 (2.50%) Marketing
6 1 (1.25%) Banking
6 1 (1.25%) Retail
Job Titles
1 33 (41.25%) Big Data Engineer
2 32 (40.00%) Data Engineer
3 29 (36.25%) Java Engineer
4 23 (28.75%) Big Data Software Engineer
4 23 (28.75%) Data Analytics Engineer
4 23 (28.75%) Java Software Engineer
4 23 (28.75%) Software Engineer
5 21 (26.25%) AWS Engineer
6 8 (10.00%) Analyst
6 8 (10.00%) Hadoop Engineer
7 7 (8.75%) Developer
8 4 (5.00%) Architect
8 4 (5.00%) AWS DevOps
8 4 (5.00%) Data Architect
8 4 (5.00%) Report Analyst
9 3 (3.75%) Business Intelligence Developer
9 3 (3.75%) Data Analyst
9 3 (3.75%) DevOps Engineer
9 3 (3.75%) ETL Developer
10 2 (2.50%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 4 (5.00%) D3.js
1 4 (5.00%) Web Services
2 3 (3.75%) PySpark
3 2 (2.50%) Kafka
3 2 (2.50%) Node.js
4 1 (1.25%) Middleware
4 1 (1.25%) Spark Streaming
Miscellaneous
1 3 (3.75%) Derivative
2 2 (2.50%) Greenfield Project
2 2 (2.50%) User Experience
3 1 (1.25%) Data Centre
3 1 (1.25%) Data Structures
3 1 (1.25%) e-Learning
3 1 (1.25%) Equities
3 1 (1.25%) Equity Derivative
3 1 (1.25%) Fixed Income
3 1 (1.25%) Management Information System
Operating Systems
1 2 (2.50%) Unix
2 1 (1.25%) Android
2 1 (1.25%) Apple iOS
2 1 (1.25%) Linux
2 1 (1.25%) Windows
Processes & Methodologies
1 48 (60.00%) Analytics
2 33 (41.25%) Data Engineering
3 28 (35.00%) Open Source
4 25 (31.25%) Software Engineering
5 24 (30.00%) ETL
6 23 (28.75%) Data Pipeline
7 21 (26.25%) Business Intelligence
8 20 (25.00%) Data Modelling
9 19 (23.75%) Data Transformation
10 15 (18.75%) Data Architecture
10 15 (18.75%) Data Science
11 12 (15.00%) Fintech
11 12 (15.00%) Insurtech
12 9 (11.25%) Visualisation
13 7 (8.75%) Data Analysis
13 7 (8.75%) Data Visualisation
13 7 (8.75%) DevOps
14 6 (7.50%) Architectural Design
14 6 (7.50%) Logical Data Model
14 6 (7.50%) Physical Data Model
Programming Languages
1 44 (55.00%) SQL
2 42 (52.50%) Java
3 27 (33.75%) Python
4 7 (8.75%) JavaScript
5 3 (3.75%) C#
5 3 (3.75%) PowerShell
5 3 (3.75%) Ruby
6 1 (1.25%) Clojure
6 1 (1.25%) Scala
Qualifications
1 8 (10.00%) Degree
2 5 (6.25%) Computer Science Degree
3 3 (3.75%) Master's Degree
Quality Assurance & Compliance
1 13 (16.25%) QA
2 3 (3.75%) Data Quality
System Software
1 3 (3.75%) Active Directory
2 2 (2.50%) Apache Flume
2 2 (2.50%) Docker
Systems Management
1 4 (5.00%) Terraform
2 3 (3.75%) Failover Clustering
2 3 (3.75%) Kubernetes
2 3 (3.75%) Opscode Chef
2 3 (3.75%) Puppet
3 2 (2.50%) Ansible
Vendors
1 19 (23.75%) Talend
2 11 (13.75%) Oracle
3 6 (7.50%) Databricks
3 6 (7.50%) Microsoft
4 5 (6.25%) SAP
5 2 (2.50%) Google
6 1 (1.25%) Adobe
6 1 (1.25%) Alteryx
6 1 (1.25%) Confluent
6 1 (1.25%) IBM
6 1 (1.25%) Informatica
6 1 (1.25%) Sage
6 1 (1.25%) Salesforce Marketing Cloud
6 1 (1.25%) Salesforce.com
6 1 (1.25%) SnapLogic
6 1 (1.25%) StreamSets
6 1 (1.25%) Workday