Period
to 20 June 2018

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

Amazon Redshift
Central London > City of London
6 months to
20 Jun 2018
Same period 2017 Same period 2016
Rank 319 319 339
Rank change year-on-year 0 +20 +112
Permanent jobs citing Amazon Redshift 27 23 50
As % of all permanent IT jobs advertised in the City of London 0.24% 0.23% 0.37%
As % of the Database & Business Intelligence category 0.78% 0.71% 1.32%
Number of salaries quoted 23 23 42
City of London median annual salary £80,000 £62,500 £60,000
Median salary % change year-on-year +28.00% +4.17% +20.00%
10th Percentile £57,750 £48,750 £45,000
90th Percentile £109,250 £90,750 £70,000
Central London median annual salary £80,000 £62,500 £60,000
% change year-on-year +28.00% +4.17% +23.08%

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 3,464 3,232 3,775
As % of all permanent IT jobs advertised in the City of London 31.36% 31.91% 28.00%
Number of salaries quoted 3,108 2,908 3,377
City of London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -
10th Percentile £40,000 £37,500 £36,250
90th Percentile £90,000 £86,250 £82,500
Central London median annual salary £62,500 £60,000 £55,000
% change year-on-year +4.17% +9.09% -

Amazon Redshift
Job Vacancy Trend in the City of London

Job postings citing Amazon Redshift as a percentage 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

This chart provides the 3-month moving average for salaries quoted in permanent IT 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

The salary distribution of IT jobs citing Amazon Redshift in the City of London over the 6 months to 20 June 2018.

Salary histogram for Amazon Redshift in the City of London

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

1 23 (85.19%) Amazon AWS
2 21 (77.78%) Python
3 16 (59.26%) SQL
4 15 (55.56%) Apache Spark
5 12 (44.44%) ETL
5 12 (44.44%) Big Data
6 11 (40.74%) Data Warehouse
6 11 (40.74%) Data Science
7 10 (37.04%) Java
7 10 (37.04%) Kafka
7 10 (37.04%) NoSQL
8 9 (33.33%) Hadoop
9 8 (29.63%) Scala
9 8 (29.63%) PostgreSQL
9 8 (29.63%) Agile Software Development
10 7 (25.93%) Machine Learning
10 7 (25.93%) Amazon EMR
10 7 (25.93%) Amazon Kinesis
10 7 (25.93%) HDFS
10 7 (25.93%) Data Engineering
10 7 (25.93%) Elastic Stack
11 6 (22.22%) Mesos
11 6 (22.22%) HBase
11 6 (22.22%) Apache Hive
11 6 (22.22%) Apache Cassandra
11 6 (22.22%) Business Intelligence
12 5 (18.52%) SQL Server
12 5 (18.52%) Tandem
12 5 (18.52%) Software Engineering
12 5 (18.52%) SQL Server Integration Services

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 15 (55.56%) Apache Spark
2 5 (18.52%) Elasticsearch
3 2 (7.41%) Apache
4 1 (3.70%) Apache Pig
Applications
1 1 (3.70%) Microsoft Excel
1 1 (3.70%) Microsoft Office
1 1 (3.70%) Microsoft PowerPoint
1 1 (3.70%) MS Visio
Cloud Services
1 23 (85.19%) Amazon AWS
2 7 (25.93%) Amazon EMR
2 7 (25.93%) Amazon Kinesis
3 5 (18.52%) AWS Lambda
3 5 (18.52%) Microsoft Azure
3 5 (18.52%) Serverless
4 3 (11.11%) Amazon EC2
4 3 (11.11%) Amazon S3
4 3 (11.11%) AWS CloudFormation
5 1 (3.70%) Azure Machine Learning
5 1 (3.70%) GitHub
Database & Business Intelligence
1 12 (44.44%) Big Data
2 11 (40.74%) Data Warehouse
3 10 (37.04%) NoSQL
4 9 (33.33%) Hadoop
5 8 (29.63%) PostgreSQL
6 6 (22.22%) Apache Cassandra
6 6 (22.22%) Apache Hive
6 6 (22.22%) HBase
7 5 (18.52%) Amazon Athena
7 5 (18.52%) Impala
7 5 (18.52%) SQL Server
7 5 (18.52%) SQL Server Integration Services
8 4 (14.81%) BigQuery
8 4 (14.81%) MongoDB
8 4 (14.81%) MySQL
8 4 (14.81%) Relational Database
9 3 (11.11%) Azure SQL Data Warehouse
10 2 (7.41%) OpenTSDB
10 2 (7.41%) Parquet
10 2 (7.41%) Power BI
Development Applications
1 2 (7.41%) GoCD
2 1 (3.70%) JUnit
General
1 3 (11.11%) Finance
2 2 (7.41%) Advertising
3 1 (3.70%) Digital Economy
3 1 (3.70%) Legal
3 1 (3.70%) Marketing
Job Titles
1 6 (22.22%) Data Engineer
1 6 (22.22%) Developer
2 4 (14.81%) Data Scientist
2 4 (14.81%) Senior Data Scientist
3 3 (11.11%) DBA
3 3 (11.11%) Senior Developer
3 3 (11.11%) SQL DBA
3 3 (11.11%) Team Leader
4 2 (7.41%) .NET Developer
4 2 (7.41%) AWS Developer
4 2 (7.41%) AWS Engineer
4 2 (7.41%) Business Intelligence Developer
4 2 (7.41%) Lead Software Engineer
4 2 (7.41%) Senior .NET Developer
4 2 (7.41%) Software Engineer
5 1 (3.70%) AWS Software Engineer
5 1 (3.70%) C# .NET Developer
5 1 (3.70%) Full Stack Developer
5 1 (3.70%) Product Developer
5 1 (3.70%) Senior Full Stack Developer
Libraries, Frameworks & Software Standards
1 10 (37.04%) Kafka
2 7 (25.93%) Elastic Stack
3 5 (18.52%) AngularJS
4 4 (14.81%) .NET
4 4 (14.81%) Natural Language Processing
4 4 (14.81%) Pandas
5 3 (11.11%) Node.js
5 3 (11.11%) scikit-learn
5 3 (11.11%) SciPy
6 2 (7.41%) Apache Thrift
6 2 (7.41%) ASP.NET
6 2 (7.41%) CSS
6 2 (7.41%) HTML
6 2 (7.41%) Lambda Expressions
6 2 (7.41%) PostGIS
6 2 (7.41%) Protocol Buffers
6 2 (7.41%) React
6 2 (7.41%) REST
7 1 (3.70%) React Native
7 1 (3.70%) Vue (Vue.js)
Miscellaneous
1 5 (18.52%) Analytical Skills
1 5 (18.52%) Tandem
2 4 (14.81%) Algorithms
2 4 (14.81%) Self-Motivation
3 3 (11.11%) Fintech
4 2 (7.41%) Greenfield Project
5 1 (3.70%) Computer Science
5 1 (3.70%) Data Structures
5 1 (3.70%) Derivative
5 1 (3.70%) Hybrid Cloud
5 1 (3.70%) Management Information System
5 1 (3.70%) Reinsurance
5 1 (3.70%) User Experience
Operating Systems
1 1 (3.70%) Android
1 1 (3.70%) Apple iOS
1 1 (3.70%) Linux
Processes & Methodologies
1 12 (44.44%) ETL
2 11 (40.74%) Data Science
3 8 (29.63%) Agile Software Development
4 7 (25.93%) Data Engineering
4 7 (25.93%) Machine Learning
5 6 (22.22%) Business Intelligence
6 5 (18.52%) Data Development
6 5 (18.52%) MapReduce
6 5 (18.52%) Resource Management
6 5 (18.52%) Software Engineering
7 4 (14.81%) DevOps
8 3 (11.11%) Artificial Intelligence
8 3 (11.11%) Business Transformation
8 3 (11.11%) Data Transformation
8 3 (11.11%) Line Management
8 3 (11.11%) Scrum
8 3 (11.11%) TDD
9 2 (7.41%) Analytics
9 2 (7.41%) Open Source
9 2 (7.41%) Workflow
Programming Languages
1 21 (77.78%) Python
2 16 (59.26%) SQL
3 10 (37.04%) Java
4 8 (29.63%) Scala
5 4 (14.81%) C#
5 4 (14.81%) Ruby
6 3 (11.11%) JavaScript
6 3 (11.11%) TypeScript
7 2 (7.41%) Go
7 2 (7.41%) R
8 1 (3.70%) C
8 1 (3.70%) CoffeeScript
8 1 (3.70%) F#
8 1 (3.70%) Java 8
Qualifications
1 2 (7.41%) Degree
2 1 (3.70%) Computer Science Degree
Quality Assurance & Compliance
1 1 (3.70%) QA
System Software
1 7 (25.93%) HDFS
2 3 (11.11%) Docker
3 1 (3.70%) Apache Flume
Systems Management
1 6 (22.22%) Mesos
2 5 (18.52%) Hadoop YARN
2 5 (18.52%) Terraform
3 2 (7.41%) Kibana
3 2 (7.41%) logstash
4 1 (3.70%) Ansible
4 1 (3.70%) Graphite
Vendors
1 4 (14.81%) Microsoft
1 4 (14.81%) Tableau
2 1 (3.70%) Alteryx
2 1 (3.70%) Google
2 1 (3.70%) Talend