Period
to 27 January 2020

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

Amazon Redshift
England > London
6 months to
27 Jan 2020
Same period 2019 Same period 2018
Rank 313 388 563
Rank change year-on-year +75 +175 +2
Permanent jobs citing Amazon Redshift 498 447 266
As % of all permanent IT jobs advertised in London 0.98% 0.72% 0.38%
As % of the Database & Business Intelligence category 3.50% 2.44% 1.27%
Number of salaries quoted 421 345 232
London median annual salary £80,000 £80,000 £67,500
Median salary % change year-on-year - +18.52% -3.57%
10th Percentile £50,000 £47,500 £45,000
90th Percentile £120,000 £115,000 £97,500
England median annual salary £75,000 £75,000 £60,000
% change year-on-year - +25.00% -7.69%

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

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 14,244 18,335 20,991
As % of all permanent IT jobs advertised in London 27.98% 29.44% 30.21%
Number of salaries quoted 11,765 15,159 17,229
London median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% +4.35%
10th Percentile £38,750 £37,500 £36,250
90th Percentile £105,000 £95,000 £90,000
England median annual salary £52,500 £52,500 £50,000
% change year-on-year - +5.00% +5.26%

Amazon Redshift
Job Vacancy Trend in London

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

Job vacancy trend for Amazon Redshift in London

Amazon Redshift
Salary Trend in London

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

Salary trend for Amazon Redshift in London

Amazon Redshift
Salary Histogram in London

The salary distribution of IT jobs citing Amazon Redshift in London over the 6 months to 27 January 2020.

Salary histogram for Amazon Redshift in London

Amazon Redshift
Job Locations in 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 London region over the 6 months to 27 January 2020. 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
Central London +16 42 £67,500 - 25
South London +33 29 £90,000 +33.33% 1
East London +17 13 £57,500 -28.13% 1
West London +16 7 £65,000 +8.33% 7
Amazon Redshift
England

For the 6 months to 27 January 2020, 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 London region with a requirement for Amazon Redshift.

1 432 (86.75%) AWS
2 343 (68.88%) Python
3 248 (49.80%) SQL
4 218 (43.78%) Analytics
5 211 (42.37%) ETL
6 208 (41.77%) Java
7 198 (39.76%) Agile Software Development
8 189 (37.95%) GCP
9 176 (35.34%) Data Warehouse
10 171 (34.34%) Data Science
11 167 (33.53%) Business Intelligence
12 161 (32.33%) Software Engineering
12 161 (32.33%) Apache Spark
13 153 (30.72%) Azure
14 150 (30.12%) Big Data
15 146 (29.32%) Docker
15 146 (29.32%) Terraform
16 145 (29.12%) Amazon S3
17 144 (28.92%) Finance
18 134 (26.91%) Hadoop
18 134 (26.91%) Machine Learning
19 133 (26.71%) Data Modelling
20 131 (26.31%) Google
21 126 (25.30%) Kubernetes
22 122 (24.50%) Web Services
23 119 (23.90%) Snowflake Schema
24 118 (23.69%) Kafka
25 114 (22.89%) BigQuery
26 106 (21.29%) Data Engineering
27 105 (21.08%) NoSQL

Amazon Redshift
Co-occurring IT Skills in 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 161 (32.33%) Apache Spark
2 72 (14.46%) Apache Airflow
3 38 (7.63%) Apache
4 35 (7.03%) Luigi
5 31 (6.22%) Elasticsearch
6 19 (3.82%) SAS
7 15 (3.01%) Confluence
8 4 (0.80%) Jupyter
9 2 (0.40%) Apache Pig
9 2 (0.40%) Apache Solr
9 2 (0.40%) Cloud Foundry
9 2 (0.40%) nginx
9 2 (0.40%) Tomcat
10 1 (0.20%) Oracle SOA Suite
10 1 (0.20%) Oracle Workflow
Applications
1 13 (2.61%) Microsoft Excel
2 2 (0.40%) SPSS
3 1 (0.20%) GNU Octave
3 1 (0.20%) Microsoft PowerPoint
3 1 (0.20%) SPSS Modeler
Business Applications
1 3 (0.60%) SAP BPC
2 2 (0.40%) Eikon
2 2 (0.40%) SAP S/4HANA
3 1 (0.20%) Cognos TM1
3 1 (0.20%) HFM
3 1 (0.20%) PolarLake
3 1 (0.20%) SAP CO
3 1 (0.20%) SAP FI
3 1 (0.20%) SAP FI/CO
3 1 (0.20%) Siebel CRM
Cloud Services
1 432 (86.75%) AWS
2 189 (37.95%) GCP
3 153 (30.72%) Azure
4 145 (29.12%) Amazon S3
5 89 (17.87%) Amazon ECS
5 89 (17.87%) Amazon SQS
6 85 (17.07%) Serverless
7 84 (16.87%) Amazon EMR
8 81 (16.27%) AWS Lambda
9 77 (15.46%) Amazon EC2
10 64 (12.85%) Amazon Kinesis
11 49 (9.84%) AWS CloudFormation
12 47 (9.44%) OpenShift
13 43 (8.63%) Power Platform
14 27 (5.42%) IBM Cloud
15 25 (5.02%) SaaS
16 20 (4.02%) Azure Data Factory
17 17 (3.41%) GitHub
18 13 (2.61%) Google Analytics
19 8 (1.61%) PaaS
Communications & Networking
1 11 (2.21%) HTTP
2 5 (1.00%) FTP
3 2 (0.40%) Internet
4 1 (0.20%) Unified Communications
Database & Business Intelligence
1 176 (35.34%) Data Warehouse
2 150 (30.12%) Big Data
3 134 (26.91%) Hadoop
4 119 (23.90%) Snowflake Schema
5 114 (22.89%) BigQuery
6 105 (21.08%) NoSQL
7 102 (20.48%) PostgreSQL
8 86 (17.27%) Amazon RDS
9 84 (16.87%) Looker
10 78 (15.66%) Amazon Athena
11 76 (15.26%) SQL Server
12 56 (11.24%) Amazon DynamoDB
12 56 (11.24%) Relational Database
13 52 (10.44%) Data Lake
14 49 (9.84%) Apache Hive
15 44 (8.84%) HBase
16 43 (8.63%) Power BI
17 34 (6.83%) MySQL
18 33 (6.63%) SQL Server Integration Services
19 31 (6.22%) Pentaho
Development Applications
1 65 (13.05%) Artifactory
2 55 (11.04%) Jenkins
3 51 (10.24%) Git (software)
4 27 (5.42%) Atlassian Bamboo
4 27 (5.42%) Vagrant
5 22 (4.42%) JIRA
5 22 (4.42%) Maven
6 20 (4.02%) Bitbucket
7 15 (3.01%) RStudio
8 5 (1.00%) ERwin
9 4 (0.80%) IntelliJ
9 4 (0.80%) TeamCity
10 3 (0.60%) GitLab
11 2 (0.40%) CircleCI
11 2 (0.40%) Subversion
11 2 (0.40%) Travis CI
12 1 (0.20%) ER Studio
12 1 (0.20%) GoCD
12 1 (0.20%) Oracle Forms
12 1 (0.20%) Sonatype Nexus
General
1 144 (28.92%) Finance
2 81 (16.27%) Front Office
3 59 (11.85%) Banking
4 34 (6.83%) Retail
5 30 (6.02%) Investment Banking
6 22 (4.42%) Manufacturing
7 20 (4.02%) Automotive
7 20 (4.02%) Marketing
8 18 (3.61%) Legal
9 14 (2.81%) Public Sector
10 9 (1.81%) Law
11 6 (1.20%) Advertising
11 6 (1.20%) Games
12 5 (1.00%) Publishing
13 3 (0.60%) Telecoms
14 2 (0.40%) Music Industry
15 1 (0.20%) Financial Institution
Job Titles
1 142 (28.51%) Data Engineer
2 136 (27.31%) Developer
3 113 (22.69%) Architect
4 108 (21.69%) Data Architect
5 62 (12.45%) AWS Developer
6 58 (11.65%) AWS Engineer
7 50 (10.04%) Python Developer
8 49 (9.84%) Python Engineer
9 44 (8.84%) Senior Developer
10 43 (8.63%) Java Developer
11 39 (7.83%) Data Warehouse Architect
12 37 (7.43%) Software Engineer
13 35 (7.03%) Senior Software Engineer
14 34 (6.83%) AWS Software Engineer
14 34 (6.83%) Developer/Software Engineer
14 34 (6.83%) Python Software Engineer
14 34 (6.83%) Senior Python Developer
14 34 (6.83%) Senior Software Developer
15 33 (6.63%) Analyst
16 30 (6.02%) Front Office Developer
Libraries, Frameworks & Software Standards
1 122 (24.50%) Web Services
2 118 (23.69%) Kafka
3 41 (8.23%) Node.js
4 36 (7.23%) Spark Streaming
5 35 (7.03%) React
6 32 (6.43%) Pandas
7 31 (6.22%) AngularJS
8 30 (6.02%) Redux
9 28 (5.62%) J2EE
10 27 (5.42%) scikit-learn
11 21 (4.22%) TensorFlow
12 17 (3.41%) Lambda Expressions
13 14 (2.81%) J2SE
13 14 (2.81%) REST
14 11 (2.21%) RabbitMQ
15 8 (1.61%) Apache Beam
15 8 (1.61%) Natural Language Processing
15 8 (1.61%) NumPy
16 6 (1.20%) Dask
16 6 (1.20%) Gearman
Miscellaneous
1 94 (18.88%) Analytical Skills
2 79 (15.86%) Fixed Income
3 52 (10.44%) Blog
4 51 (10.24%) Greenfield Project
5 41 (8.23%) Data Structures
6 37 (7.43%) Algorithms
7 32 (6.43%) Foreign Exchange (FX)
8 31 (6.22%) Equities
9 30 (6.02%) Derivative
9 30 (6.02%) Hedge funds
10 23 (4.62%) Public Cloud
11 21 (4.22%) Acoustics
12 16 (3.21%) Cloud Native
13 10 (2.01%) Management Information System
14 8 (1.61%) Virtual Team
15 4 (0.80%) Self-Motivation
16 3 (0.60%) Hybrid Cloud
16 3 (0.60%) Replication
16 3 (0.60%) User Experience
17 2 (0.40%) Data Centre
Operating Systems
1 25 (5.02%) Linux
2 24 (4.82%) Unix
3 2 (0.40%) Windows
Processes & Methodologies
1 218 (43.78%) Analytics
2 211 (42.37%) ETL
3 198 (39.76%) Agile Software Development
4 171 (34.34%) Data Science
5 167 (33.53%) Business Intelligence
6 161 (32.33%) Software Engineering
7 134 (26.91%) Machine Learning
8 133 (26.71%) Data Modelling
9 106 (21.29%) Data Engineering
10 103 (20.68%) DevOps
11 79 (15.86%) Asset Management
11 79 (15.86%) Data Analytics
12 72 (14.46%) Artificial Intelligence
13 59 (11.85%) Visualisation
14 57 (11.45%) Continuous Integration
14 57 (11.45%) Decision-Making
15 50 (10.04%) Microservices
16 49 (9.84%) Problem-Solving
17 46 (9.24%) E-Commerce
18 45 (9.04%) Data Architecture
Programming Languages
1 343 (68.88%) Python
2 248 (49.80%) SQL
3 208 (41.77%) Java
4 104 (20.88%) Scala
5 79 (15.86%) R
6 56 (11.24%) JavaScript
7 34 (6.83%) Kotlin
8 31 (6.22%) Go
9 21 (4.22%) PL/SQL
10 12 (2.41%) C#
10 12 (2.41%) C++
11 11 (2.21%) T-SQL
12 9 (1.81%) Bash Shell
13 8 (1.61%) Clojure
14 7 (1.41%) TypeScript
15 5 (1.00%) Data Analysis Expressions (DAX)
16 4 (0.80%) ML
16 4 (0.80%) Ruby
17 2 (0.40%) Perl
17 2 (0.40%) VBA
Qualifications
1 47 (9.44%) Degree
2 24 (4.82%) Computer Science Degree
3 10 (2.01%) Master's Degree
4 5 (1.00%) ISTQB
5 4 (0.80%) PhD
6 3 (0.60%) MBA
7 2 (0.40%) ACCA
7 2 (0.40%) CIMA
7 2 (0.40%) SC Cleared
7 2 (0.40%) Security Cleared
8 1 (0.20%) AWS Certification
8 1 (0.20%) Numerate Degree
Quality Assurance & Compliance
1 18 (3.61%) Data Quality
2 10 (2.01%) QA
3 6 (1.20%) GDPR
4 1 (0.20%) ISO/IEC 27001
System Software
1 146 (29.32%) Docker
2 27 (5.42%) VirtualBox
3 17 (3.41%) HDFS
4 8 (1.61%) Apache Flume
5 2 (0.40%) Apache ZooKeeper
5 2 (0.40%) Varnish
6 1 (0.20%) Active Directory
Systems Management
1 146 (29.32%) Terraform
2 126 (25.30%) Kubernetes
3 47 (9.44%) Ansible
4 32 (6.43%) Docker Swarm
5 17 (3.41%) Hadoop YARN
6 16 (3.21%) Oozie
7 6 (1.20%) Prometheus
7 6 (1.20%) StatsD
8 4 (0.80%) Grafana
Vendors
1 131 (26.31%) Google
2 79 (15.86%) Tableau
3 53 (10.64%) Talend
4 48 (9.64%) Cloudera
5 47 (9.44%) Informatica
6 46 (9.24%) Oracle
7 31 (6.22%) Microsoft
8 29 (5.82%) Hortonworks
9 28 (5.62%) IBM
10 21 (4.22%) Databricks
11 10 (2.01%) Adobe
11 10 (2.01%) Teradata
12 8 (1.61%) SAP
12 8 (1.61%) SnapLogic
12 8 (1.61%) Snowplow
12 8 (1.61%) Splunk
13 7 (1.41%) MicroStrategy
14 6 (1.20%) Cadence
14 6 (1.20%) Vertica
15 5 (1.00%) Netezza