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

Amazon Redshift
Central London > City of London
6 months to
23 Feb 2018
Same period 2017 Same period 2016
Rank 275 324 353
Rank change year-on-year +49 +29 +101
Permanent jobs citing Amazon Redshift 66 16 40
As % of all permanent IT jobs advertised in the City of London 0.62% 0.15% 0.28%
As % of the Database & Business Intelligence category 2.01% 0.48% 0.93%
Number of salaries quoted 59 14 32
City of London median annual salary £70,000 £62,500 £55,000
Median salary % change year-on-year +12.00% +13.64% +10.00%
10th Percentile £52,500 £48,750 £45,000
90th Percentile £106,250 £78,375 £65,000
Central London median annual salary £70,000 £62,500 £55,000
% change year-on-year +12.00% +13.64% +10.00%

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,289 3,305 4,310
As % of all permanent IT jobs advertised in the City of London 30.67% 31.61% 30.69%
Number of salaries quoted 2,947 3,057 3,818
City of London median annual salary £60,500 £58,000 £57,500
Median salary % change year-on-year +4.31% +0.87% +4.55%
10th Percentile £41,250 £36,650 £37,175
90th Percentile £90,000 £87,500 £85,000
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +4.55%

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 23 February 2018.

Salary histogram for Amazon Redshift in the City of London

For the 6 months to 23 February 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 65 (98.48%) Amazon AWS
2 51 (77.27%) Python
3 40 (60.61%) SQL
4 31 (46.97%) Amazon RDS
5 30 (45.45%) Data Warehouse
6 28 (42.42%) ETL
6 28 (42.42%) SQL Server
7 27 (40.91%) Big Data
8 26 (39.39%) .NET
8 26 (39.39%) C#
9 24 (36.36%) ASP.NET
9 24 (36.36%) Business Intelligence
9 24 (36.36%) R
9 24 (36.36%) Analytical Skills
10 23 (34.85%) Dimensional Modelling
11 22 (33.33%) SQL Server Integration Services
12 21 (31.82%) Microsoft Azure
12 21 (31.82%) Microsoft
12 21 (31.82%) Agile Software Development
12 21 (31.82%) Analytics
13 20 (30.30%) Tableau
14 19 (28.79%) SQL Server 2012
14 19 (28.79%) Alteryx
14 19 (28.79%) Apache Spark
14 19 (28.79%) Azure Machine Learning
14 19 (28.79%) Power BI
14 19 (28.79%) PostgreSQL
15 18 (27.27%) Data Modelling
15 18 (27.27%) Ruby
15 18 (27.27%) Amazon DynamoDB

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 19 (28.79%) Apache Spark
2 13 (19.70%) Elasticsearch
3 7 (10.61%) Apache
4 4 (6.06%) Apache Solr
5 1 (1.52%) Apache Airflow
5 1 (1.52%) Apache Pig
5 1 (1.52%) Confluence
5 1 (1.52%) nginx
5 1 (1.52%) Tomcat
Cloud Services
1 65 (98.48%) Amazon AWS
2 21 (31.82%) Microsoft Azure
3 19 (28.79%) Azure Machine Learning
4 17 (25.76%) AWS Lambda
4 17 (25.76%) Serverless
5 16 (24.24%) Amazon S3
6 15 (22.73%) Amazon EC2
7 14 (21.21%) AWS CloudFormation
8 11 (16.67%) Amazon Kinesis
9 8 (12.12%) Amazon EMR
10 7 (10.61%) GitHub
11 5 (7.58%) Amazon CloudWatch
12 4 (6.06%) Amazon ElastiCache
13 2 (3.03%) Virtual Private Cloud
14 1 (1.52%) Amazon SQS
14 1 (1.52%) Boomi
14 1 (1.52%) Cloud Computing
14 1 (1.52%) IBM Cloud
14 1 (1.52%) SoftLayer
Communications & Networking
1 1 (1.52%) Asterisk PBX
1 1 (1.52%) Internet
1 1 (1.52%) Network Security
1 1 (1.52%) Reverse Proxy
1 1 (1.52%) RTP
1 1 (1.52%) TCP/IP
Database & Business Intelligence
1 31 (46.97%) Amazon RDS
2 30 (45.45%) Data Warehouse
3 28 (42.42%) SQL Server
4 27 (40.91%) Big Data
5 22 (33.33%) SQL Server Integration Services
6 19 (28.79%) PostgreSQL
6 19 (28.79%) Power BI
6 19 (28.79%) SQL Server 2012
7 18 (27.27%) Amazon DynamoDB
8 15 (22.73%) Hadoop
9 13 (19.70%) SQL Server 2016
9 13 (19.70%) SQL Server Analysis Services
9 13 (19.70%) SQL Server Reporting Services
10 9 (13.64%) Azure SQL Data Warehouse
11 8 (12.12%) OpenTSDB
11 8 (12.12%) Parquet
12 6 (9.09%) Couchbase
12 6 (9.09%) MongoDB
13 5 (7.58%) Apache Cassandra
13 5 (7.58%) QlikView
Development Applications
1 6 (9.09%) GoCD
2 5 (7.58%) Jenkins
3 3 (4.55%) Git (software)
4 1 (1.52%) Bitbucket
4 1 (1.52%) JIRA
4 1 (1.52%) Sonatype Nexus
General
1 5 (7.58%) Marketing
2 3 (4.55%) Digital Economy
2 3 (4.55%) Finance
3 2 (3.03%) Legal
4 1 (1.52%) Advertising
4 1 (1.52%) Games
4 1 (1.52%) Law
Job Titles
1 28 (42.42%) Developer
2 14 (21.21%) Business Intelligence Developer
3 10 (15.15%) Business Intelligence Lead
4 8 (12.12%) DevOps Engineer
4 8 (12.12%) Senior Developer
5 7 (10.61%) Azure Consultant
5 7 (10.61%) Business Intelligence Consultant
5 7 (10.61%) Consultant
5 7 (10.61%) Scala Developer
5 7 (10.61%) SSIS Consultant
5 7 (10.61%) SSRS Consultant
6 6 (9.09%) AWS Developer
6 6 (9.09%) Azure Developer
6 6 (9.09%) Cloud Engineer
6 6 (9.09%) SSAS Developer
6 6 (9.09%) SSIS Developer
6 6 (9.09%) SSRS Developer
7 5 (7.58%) Data Scientist
7 5 (7.58%) Senior C# .NET Developer
7 5 (7.58%) Senior Scala Developer
Libraries, Frameworks & Software Standards
1 26 (39.39%) .NET
2 24 (36.36%) ASP.NET
3 18 (27.27%) Kafka
4 14 (21.21%) Node.js
5 10 (15.15%) RabbitMQ
6 9 (13.64%) Elastic Stack
7 8 (12.12%) AngularJS
7 8 (12.12%) Apache Thrift
7 8 (12.12%) PostGIS
7 8 (12.12%) Protocol Buffers
7 8 (12.12%) React
8 5 (7.58%) ASP.NET MVC
8 5 (7.58%) ASP.NET Web API
8 5 (7.58%) Samza
9 4 (6.06%) RESTful
10 3 (4.55%) Apache Flex
10 3 (4.55%) Backbone.js
10 3 (4.55%) Natural Language Processing
10 3 (4.55%) React Native
10 3 (4.55%) REST
Miscellaneous
1 24 (36.36%) Analytical Skills
2 11 (16.67%) Computer Science
3 4 (6.06%) BBC
3 4 (6.06%) Digital TV
3 4 (6.06%) Fintech
3 4 (6.06%) STB
4 3 (4.55%) Algorithms
4 3 (4.55%) Greenfield Project
4 3 (4.55%) User Experience
5 2 (3.03%) Data Centre
6 1 (1.52%) Data Structures
6 1 (1.52%) Replication
Operating Systems
1 7 (10.61%) Linux
2 5 (7.58%) CentOS
3 4 (6.06%) Ubuntu
3 4 (6.06%) Unix
4 3 (4.55%) Android
4 3 (4.55%) Apple iOS
5 1 (1.52%) Red Hat Enterprise Linux
5 1 (1.52%) Windows
Processes & Methodologies
1 28 (42.42%) ETL
2 24 (36.36%) Business Intelligence
3 23 (34.85%) Dimensional Modelling
4 21 (31.82%) Agile Software Development
4 21 (31.82%) Analytics
5 18 (27.27%) Data Modelling
6 17 (25.76%) DevOps
7 15 (22.73%) Visualisation
8 14 (21.21%) Data Visualisation
9 12 (18.18%) Coaching
9 12 (18.18%) Machine Learning
10 10 (15.15%) Microservices
10 10 (15.15%) Open Source
11 9 (13.64%) E-Commerce
11 9 (13.64%) Software Engineering
12 8 (12.12%) Data Science
12 8 (12.12%) TDD
13 7 (10.61%) Presales
13 7 (10.61%) Technical Architecture
14 6 (9.09%) Mathematics
Programming Languages
1 51 (77.27%) Python
2 40 (60.61%) SQL
3 26 (39.39%) C#
4 24 (36.36%) R
5 18 (27.27%) Ruby
6 17 (25.76%) Java
7 11 (16.67%) Go
7 11 (16.67%) Scala
8 8 (12.12%) JavaScript
9 6 (9.09%) T-SQL
10 5 (7.58%) CoffeeScript
10 5 (7.58%) F#
11 4 (6.06%) Clojure
12 1 (1.52%) Bash Shell
Qualifications
1 16 (24.24%) Degree
2 5 (7.58%) Computer Science Degree
3 1 (1.52%) Master's Degree
Quality Assurance & Compliance
1 1 (1.52%) QA
System Software
1 16 (24.24%) Docker
2 5 (7.58%) HDFS
3 1 (1.52%) Active Directory
3 1 (1.52%) Apache ZooKeeper
3 1 (1.52%) Kamailio
Systems Management
1 11 (16.67%) Terraform
2 9 (13.64%) Ansible
3 8 (12.12%) Kibana
3 8 (12.12%) logstash
4 6 (9.09%) Graphite
4 6 (9.09%) Mesos
5 5 (7.58%) Kubernetes
6 2 (3.03%) Puppet
6 2 (3.03%) Rancher
7 1 (1.52%) Consul
7 1 (1.52%) Grafana
7 1 (1.52%) HAProxy
7 1 (1.52%) Icinga
7 1 (1.52%) Riemann
Vendors
1 21 (31.82%) Microsoft
2 20 (30.30%) Tableau
3 19 (28.79%) Alteryx
4 4 (6.06%) Arqiva
4 4 (6.06%) BT
4 4 (6.06%) Red Hat
5 3 (4.55%) Adthena
6 2 (3.03%) Google
7 1 (1.52%) Birst
7 1 (1.52%) Dell
7 1 (1.52%) Facebook
7 1 (1.52%) Informatica
7 1 (1.52%) PagerDuty
7 1 (1.52%) Rackspace
7 1 (1.52%) SAP
7 1 (1.52%) SnapLogic