Period
to 21 November 2017

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 21 November 2017 with a comparison to the same period in the previous 2 years.

Amazon Redshift
Central London > City of London
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 246 328 401
Rank change year-on-year +82 +73 +70
Permanent jobs citing Amazon Redshift 76 22 13
As % of all permanent IT jobs advertised in the City of London 0.74% 0.19% 0.076%
As % of the Database & Business Intelligence category 2.37% 0.63% 0.26%
Number of salaries quoted 68 20 13
City of London median annual salary £70,000 £43,750 £50,000
Median salary % change year-on-year +60.00% -12.50% -9.09%
10th Percentile £51,000 £23,750 £39,800
90th Percentile £126,250 £68,750 £62,500
Central London median annual salary £70,000 £60,000 £50,000
% change year-on-year +16.67% +20.00% -20.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 3204 3512 5047
As % of all permanent IT jobs advertised in the City of London 31.21% 30.23% 29.66%
Number of salaries quoted 2928 3225 4388
City of London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - +4.55%
10th Percentile £41,250 £36,250 £36,250
90th Percentile £87,500 £86,250 £85,000
Central London median annual salary £59,500 £55,000 £57,000
% change year-on-year +8.18% -3.51% +3.64%

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 21 November 2017.

Salary histogram for Amazon Redshift in the City of London

For the 6 months to 21 November 2017, IT jobs citing Amazon Redshift also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for Amazon Redshift.

1 71 (93.42%) Amazon AWS
2 54 (71.05%) Python
3 40 (52.63%) SQL
4 39 (51.32%) Amazon RDS
5 29 (38.16%) Data Warehouse
5 29 (38.16%) Agile Software Development
6 27 (35.53%) Business Intelligence
6 27 (35.53%) Analytical Skills
7 26 (34.21%) Apache Spark
7 26 (34.21%) R
8 25 (32.89%) Big Data
8 25 (32.89%) ETL
9 24 (31.58%) SQL Server
9 24 (31.58%) Kafka
9 24 (31.58%) DevOps
9 24 (31.58%) AWS Lambda
9 24 (31.58%) Serverless
10 23 (30.26%) Machine Learning
10 23 (30.26%) Analytics
10 23 (30.26%) .NET
10 23 (30.26%) C#
11 22 (28.95%) ASP.NET
11 22 (28.95%) Dimensional Modelling
11 22 (28.95%) Tableau
11 22 (28.95%) Amazon EC2
12 20 (26.32%) Microsoft Azure
12 20 (26.32%) Alteryx
12 20 (26.32%) SQL Server Integration Services
12 20 (26.32%) PostgreSQL
13 19 (25.00%) Microsoft

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 26 (34.21%) Apache Spark
2 12 (15.79%) Apache
2 12 (15.79%) Elasticsearch
3 8 (10.53%) Apache Airflow
4 4 (5.26%) Apache Solr
5 2 (2.63%) Apache Pig
5 2 (2.63%) SAS
6 1 (1.32%) Confluence
6 1 (1.32%) nginx
6 1 (1.32%) Tomcat
Applications
1 1 (1.32%) SPSS
Business Applications
1 2 (2.63%) Magento
1 2 (2.63%) Odoo
Cloud Services
1 71 (93.42%) Amazon AWS
2 24 (31.58%) AWS Lambda
2 24 (31.58%) Serverless
3 22 (28.95%) Amazon EC2
4 20 (26.32%) Microsoft Azure
5 19 (25.00%) Azure Machine Learning
6 18 (23.68%) Amazon S3
7 14 (18.42%) AWS CloudFormation
7 14 (18.42%) GitHub
8 12 (15.79%) Amazon CloudWatch
9 11 (14.47%) Amazon Kinesis
9 11 (14.47%) Virtual Private Cloud
10 5 (6.58%) Amazon EMR
11 4 (5.26%) Amazon ElastiCache
12 3 (3.95%) Amazon SQS
13 1 (1.32%) Boomi
13 1 (1.32%) Cloud Computing
13 1 (1.32%) Google Cloud Platform
13 1 (1.32%) IBM Cloud
13 1 (1.32%) SoftLayer
Communications & Networking
1 3 (3.95%) Network Security
2 1 (1.32%) Asterisk PBX
2 1 (1.32%) Reverse Proxy
2 1 (1.32%) RTP
2 1 (1.32%) TCP/IP
Database & Business Intelligence
1 39 (51.32%) Amazon RDS
2 29 (38.16%) Data Warehouse
3 25 (32.89%) Big Data
4 24 (31.58%) SQL Server
5 20 (26.32%) PostgreSQL
5 20 (26.32%) SQL Server Integration Services
6 19 (25.00%) Power BI
6 19 (25.00%) SQL Server 2012
7 18 (23.68%) Hadoop
8 14 (18.42%) Amazon DynamoDB
9 13 (17.11%) SQL Server 2016
9 13 (17.11%) SQL Server Analysis Services
9 13 (17.11%) SQL Server Reporting Services
10 8 (10.53%) InfluxDB
10 8 (10.53%) Neo4j
11 7 (9.21%) Azure SQL Data Warehouse
12 5 (6.58%) MongoDB
12 5 (6.58%) OpenTSDB
12 5 (6.58%) Parquet
12 5 (6.58%) QlikView
Development Applications
1 12 (15.79%) Git (software)
2 7 (9.21%) Jenkins
3 5 (6.58%) GoCD
4 3 (3.95%) Bitbucket
4 3 (3.95%) Sonatype Nexus
5 2 (2.63%) Subversion
6 1 (1.32%) JIRA
General
1 14 (18.42%) Marketing
2 5 (6.58%) Retail
3 4 (5.26%) Finance
4 3 (3.95%) Games
5 2 (2.63%) Digital Economy
6 1 (1.32%) Advertising
6 1 (1.32%) Legal
Job Titles
1 24 (31.58%) Developer
2 14 (18.42%) Business Intelligence Developer
3 10 (13.16%) Business Intelligence Lead
3 10 (13.16%) DevOps Engineer
4 8 (10.53%) Cloud Engineer
4 8 (10.53%) Head of Engineering
5 7 (9.21%) Azure Consultant
5 7 (9.21%) Business Intelligence Consultant
5 7 (9.21%) Consultant
5 7 (9.21%) SSIS Consultant
5 7 (9.21%) SSRS Consultant
6 6 (7.89%) Azure Developer
6 6 (7.89%) Data Scientist
6 6 (7.89%) Senior Developer
6 6 (7.89%) SSAS Developer
6 6 (7.89%) SSIS Developer
6 6 (7.89%) SSRS Developer
7 5 (6.58%) Data Engineer
7 5 (6.58%) Scala Developer
8 4 (5.26%) Cloud Software Engineer
Libraries, Frameworks & Software Standards
1 24 (31.58%) Kafka
2 23 (30.26%) .NET
3 22 (28.95%) ASP.NET
4 19 (25.00%) Node.js
5 8 (10.53%) Web Services
6 7 (9.21%) RabbitMQ
7 6 (7.89%) Elastic Stack
7 6 (7.89%) RESTful
8 5 (6.58%) AngularJS
8 5 (6.58%) Apache Thrift
8 5 (6.58%) PostGIS
8 5 (6.58%) Protocol Buffers
8 5 (6.58%) React
9 3 (3.95%) ASP.NET MVC
9 3 (3.95%) ASP.NET Web API
9 3 (3.95%) Natural Language Processing
9 3 (3.95%) Samza
10 2 (2.63%) Apache Flex
10 2 (2.63%) CSS
10 2 (2.63%) HTML
Miscellaneous
1 27 (35.53%) Analytical Skills
2 13 (17.11%) Computer Science
3 6 (7.89%) Algorithms
4 4 (5.26%) BBC
4 4 (5.26%) Digital TV
4 4 (5.26%) STB
5 3 (3.95%) Data Centre
5 3 (3.95%) Fintech
6 2 (2.63%) Greenfield Project
6 2 (2.63%) User Experience
7 1 (1.32%) Data Structures
7 1 (1.32%) Replication
7 1 (1.32%) Social Gaming
Operating Systems
1 9 (11.84%) Linux
2 7 (9.21%) CentOS
3 4 (5.26%) Ubuntu
3 4 (5.26%) Unix
4 3 (3.95%) Red Hat Enterprise Linux
4 3 (3.95%) Windows
5 2 (2.63%) Android
5 2 (2.63%) Apple iOS
Processes & Methodologies
1 29 (38.16%) Agile Software Development
2 27 (35.53%) Business Intelligence
3 25 (32.89%) ETL
4 24 (31.58%) DevOps
5 23 (30.26%) Analytics
5 23 (30.26%) Machine Learning
6 22 (28.95%) Dimensional Modelling
7 18 (23.68%) Data Modelling
8 17 (22.37%) Visualisation
9 16 (21.05%) E-Commerce
10 15 (19.74%) Microservices
10 15 (19.74%) Software Engineering
11 14 (18.42%) Data Visualisation
12 12 (15.79%) Coaching
13 9 (11.84%) Data Engineering
14 8 (10.53%) Digital Marketing
14 8 (10.53%) Line Management
14 8 (10.53%) Open Source
14 8 (10.53%) Statistics
14 8 (10.53%) TDD
Programming Languages
1 54 (71.05%) Python
2 40 (52.63%) SQL
3 26 (34.21%) R
4 23 (30.26%) C#
5 16 (21.05%) Java
6 15 (19.74%) Scala
7 14 (18.42%) Ruby
8 10 (13.16%) Go
9 7 (9.21%) JavaScript
10 6 (7.89%) T-SQL
11 4 (5.26%) Clojure
12 3 (3.95%) CoffeeScript
12 3 (3.95%) F#
13 2 (2.63%) Bash Shell
14 1 (1.32%) PHP
Qualifications
1 19 (25.00%) Degree
2 6 (7.89%) Computer Science Degree
3 2 (2.63%) Master's Degree
Quality Assurance & Compliance
1 1 (1.32%) QA
System Software
1 14 (18.42%) Docker
2 6 (7.89%) HDFS
3 3 (3.95%) Active Directory
4 1 (1.32%) Apache ZooKeeper
4 1 (1.32%) Kamailio
Systems Management
1 17 (22.37%) Ansible
2 10 (13.16%) Terraform
3 6 (7.89%) Kubernetes
4 5 (6.58%) Kibana
4 5 (6.58%) logstash
5 4 (5.26%) Graphite
5 4 (5.26%) Mesos
6 2 (2.63%) Puppet
7 1 (1.32%) Consul
7 1 (1.32%) Grafana
7 1 (1.32%) HAProxy
7 1 (1.32%) Icinga
7 1 (1.32%) Rancher
7 1 (1.32%) Riemann
Vendors
1 22 (28.95%) Tableau
2 20 (26.32%) Alteryx
3 19 (25.00%) Microsoft
4 8 (10.53%) PagerDuty
5 4 (5.26%) Arqiva
5 4 (5.26%) BT
5 4 (5.26%) Red Hat
6 3 (3.95%) Adthena
7 2 (2.63%) Birst
7 2 (2.63%) SAP
7 2 (2.63%) SnapLogic
7 2 (2.63%) Vertica
8 1 (1.32%) Cloudera
8 1 (1.32%) Dell
8 1 (1.32%) EXASOL
8 1 (1.32%) Hortonworks
8 1 (1.32%) Informatica
8 1 (1.32%) Oracle
8 1 (1.32%) Rackspace
8 1 (1.32%) Splunk