Period
to 22 September 2018

The following table provides summary statistics for contract job vacancies advertised in London with a requirement for Amazon Redshift skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Amazon Redshift over the 6 months to 22 September 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Amazon Redshift
England > London
6 months to
22 Sep 2018
Same period 2017 Same period 2016
Rank 407 495 545
Rank change year-on-year +88 +50 +55
Contract jobs citing Amazon Redshift 240 123 70
As % of all contract IT jobs advertised in London 0.53% 0.28% 0.16%
As % of the Database & Business Intelligence category 2.11% 1.16% 0.68%
Number of daily rates quoted 199 101 60
London median daily rate £550 £475 £475
Median daily rate % change year-on-year +15.79% - +26.67%
10th Percentile £450 £310 £350
90th Percentile £650 £600 £563
England median daily rate £538 £475 £463
% change year-on-year +13.16% +2.70% +15.63%
Number of hourly rates quoted 0 4 0
London median hourly rate - £57.50 -
England median hourly rate - £57.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 contract job vacancies advertised in London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Contract vacancies with a requirement for database or business intelligence skills 11,356 10,626 10,327
As % of all contract IT jobs advertised in London 24.98% 23.97% 23.03%
Number of daily rates quoted 8,471 7,763 7,456
London median daily rate £525 £500 £475
Median daily rate % change year-on-year +5.00% +5.26% +5.56%
10th Percentile £360 £348 £313
90th Percentile £675 £650 £638
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 57 60 43
London median hourly rate £27.50 £27.33 £35.00
Median hourly rate % change year-on-year +0.62% -21.91% +52.17%
10th Percentile £19.25 £18.68 £17.03
90th Percentile £47.60 £58.75 £100.00
England median hourly rate £29.50 £30.00 £30.00
% change year-on-year -1.67% - +7.99%

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
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Amazon Redshift in London.

Contractor daily rate trend for Amazon Redshift in London

Amazon Redshift
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing Amazon Redshift in London over the 6 months to 22 September 2018.

Contractor daily rate histogram for Amazon Redshift in London

Amazon Redshift
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Amazon Redshift within the London region over the 6 months to 22 September 2018. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -5 38 £580 +30.70% 18
South London -24 16 £450 -16.28% 2
East London -4 15 £550 +10.00% 3
West London - 2 £480 - 9
North London - 1 £700 - 6
Amazon Redshift
England

For the 6 months to 22 September 2018, IT contractor 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 contract job ads across the London region with a requirement for Amazon Redshift.

1 217 (90.42%) Amazon AWS
2 149 (62.08%) Python
3 142 (59.17%) SQL
4 92 (38.33%) Big Data
5 91 (37.92%) Apache Spark
6 88 (36.67%) Java
7 87 (36.25%) Amazon S3
8 79 (32.92%) Agile Software Development
8 79 (32.92%) Analytics
9 77 (32.08%) ETL
10 75 (31.25%) Scala
11 65 (27.08%) Hadoop
11 65 (27.08%) Data Warehouse
12 63 (26.25%) NoSQL
13 61 (25.42%) Kafka
14 60 (25.00%) Amazon EMR
15 56 (23.33%) PostgreSQL
16 54 (22.50%) Business Intelligence
17 53 (22.08%) Analytical Skills
18 52 (21.67%) DevOps
18 52 (21.67%) Linux
19 50 (20.83%) Data Science
20 48 (20.00%) TDD
21 46 (19.17%) Amazon EC2
22 41 (17.08%) Relational Database
23 40 (16.67%) Amazon Kinesis
23 40 (16.67%) Web Services
24 39 (16.25%) Finance
24 39 (16.25%) Continuous Integration
25 37 (15.42%) Apache Hive

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 91 (37.92%) Apache Spark
2 35 (14.58%) Apache
3 33 (13.75%) Elasticsearch
4 19 (7.92%) Apache Airflow
5 14 (5.83%) Apache Pig
5 14 (5.83%) Confluence
6 7 (2.92%) Apache Solr
7 4 (1.67%) SAS
8 3 (1.25%) Luigi
Applications
1 4 (1.67%) Stata
2 3 (1.25%) Microsoft Excel
3 1 (0.42%) Microsoft Office
3 1 (0.42%) Microsoft PowerPoint
3 1 (0.42%) MS Visio
3 1 (0.42%) Shockwave
Business Applications
1 2 (0.83%) Markit EDM
1 2 (0.83%) PolarLake
Cloud Services
1 217 (90.42%) Amazon AWS
2 87 (36.25%) Amazon S3
3 60 (25.00%) Amazon EMR
4 46 (19.17%) Amazon EC2
5 40 (16.67%) Amazon Kinesis
6 34 (14.17%) Google Cloud Platform
7 32 (13.33%) Serverless
8 31 (12.92%) AWS Lambda
9 27 (11.25%) Microsoft Azure
10 22 (9.17%) Virtual Private Cloud
11 15 (6.25%) Amazon Glacier
12 8 (3.33%) GitHub
13 6 (2.50%) Amazon ELB
14 5 (2.08%) Amazon CloudWatch
14 5 (2.08%) Cloud Computing
14 5 (2.08%) Datadog
14 5 (2.08%) SaaS
15 4 (1.67%) AWS CloudFormation
15 4 (1.67%) Google Analytics
16 3 (1.25%) PaaS
Communications & Networking
1 6 (2.50%) VPN
2 5 (2.08%) Kerberos
2 5 (2.08%) SSL
3 2 (0.83%) HTTP
4 1 (0.42%) Intrusion Detection
4 1 (0.42%) OpenLDAP
Database & Business Intelligence
1 92 (38.33%) Big Data
2 65 (27.08%) Data Warehouse
2 65 (27.08%) Hadoop
3 63 (26.25%) NoSQL
4 56 (23.33%) PostgreSQL
5 41 (17.08%) Relational Database
6 37 (15.42%) Apache Hive
7 32 (13.33%) BigQuery
7 32 (13.33%) HBase
8 30 (12.50%) Apache Cassandra
9 27 (11.25%) Amazon RDS
10 23 (9.58%) SQL Server
11 22 (9.17%) Amazon Aurora
12 21 (8.75%) Data Lake
13 17 (7.08%) MySQL
14 15 (6.25%) Amazon Athena
15 14 (5.83%) Amazon DynamoDB
16 12 (5.00%) Parquet
16 12 (5.00%) Power BI
17 11 (4.58%) Flink
Development Applications
1 31 (12.92%) Jenkins
2 20 (8.33%) JIRA
3 13 (5.42%) Git (software)
4 6 (2.50%) RStudio
5 5 (2.08%) FishEye
5 5 (2.08%) Spinnaker
6 4 (1.67%) Bitbucket
7 2 (0.83%) Jasmine
7 2 (0.83%) Mocha
7 2 (0.83%) Team Foundation Server
8 1 (0.42%) git-flow
8 1 (0.42%) GitLab
8 1 (0.42%) Liquibase
8 1 (0.42%) NUnit
8 1 (0.42%) TeamCity
8 1 (0.42%) Xcode
General
1 39 (16.25%) Finance
2 21 (8.75%) Marketing
3 14 (5.83%) Retail
4 7 (2.92%) Banking
5 6 (2.50%) Advertising
6 5 (2.08%) Games
7 3 (1.25%) Legal
7 3 (1.25%) Telecoms
8 2 (0.83%) Back Office
8 2 (0.83%) Front Office
Job Titles
1 97 (40.42%) Data Engineer
2 57 (23.75%) Developer
3 45 (18.75%) Senior Data Engineer
4 38 (15.83%) AWS Engineer
5 28 (11.67%) Architect
6 24 (10.00%) Python Engineer
7 21 (8.75%) Analyst
8 18 (7.50%) AWS Developer
8 18 (7.50%) Java Developer
9 16 (6.67%) AWS Architect
9 16 (6.67%) Data Architect
9 16 (6.67%) DevOps Engineer
10 15 (6.25%) Data Analyst
11 11 (4.58%) Redshift Developer
12 9 (3.75%) AWS DevOps
12 9 (3.75%) Business Intelligence Analyst
12 9 (3.75%) Cloud Architect
12 9 (3.75%) Cloud Engineer
13 8 (3.33%) Big Data Architect
13 8 (3.33%) Big Data Developer
Libraries, Frameworks & Software Standards
1 61 (25.42%) Kafka
2 40 (16.67%) Web Services
3 19 (7.92%) REST
4 13 (5.42%) JSON
5 12 (5.00%) Lambda Expressions
6 9 (3.75%) Hibernate
6 9 (3.75%) HTML
6 9 (3.75%) JPA
6 9 (3.75%) JSON Schema
6 9 (3.75%) React
6 9 (3.75%) Samza
7 8 (3.33%) .NET
7 8 (3.33%) Natural Language Processing
8 6 (2.50%) HTML5
8 6 (2.50%) Matplotlib
8 6 (2.50%) Node.js
8 6 (2.50%) Seaborn
8 6 (2.50%) XML
9 5 (2.08%) Apache Avro
9 5 (2.08%) Elastic Stack
Miscellaneous
1 53 (22.08%) Analytical Skills
2 17 (7.08%) Fintech
3 12 (5.00%) Algorithms
4 7 (2.92%) Data Structures
4 7 (2.92%) Greenfield Project
5 6 (2.50%) Computer Science
6 5 (2.08%) Management Information System
7 4 (1.67%) Enterprise Software
8 3 (1.25%) Digital Media
8 3 (1.25%) Mobile App
9 2 (0.83%) Data Centre
9 2 (0.83%) Derivative
9 2 (0.83%) Equities
9 2 (0.83%) Fixed Income
9 2 (0.83%) Foreign Exchange (FX)
9 2 (0.83%) Hybrid Cloud
9 2 (0.83%) Marketing Technology
9 2 (0.83%) Self-Motivation
9 2 (0.83%) Smart Home
9 2 (0.83%) Virtual Team
Operating Systems
1 52 (21.67%) Linux
2 25 (10.42%) Unix
3 12 (5.00%) Red Hat Enterprise Linux
4 5 (2.08%) CentOS
4 5 (2.08%) Ubuntu
4 5 (2.08%) Windows
5 3 (1.25%) Apple iOS
6 1 (0.42%) Android
Processes & Methodologies
1 79 (32.92%) Agile Software Development
1 79 (32.92%) Analytics
2 77 (32.08%) ETL
3 54 (22.50%) Business Intelligence
4 52 (21.67%) DevOps
5 50 (20.83%) Data Science
6 48 (20.00%) TDD
7 39 (16.25%) Continuous Integration
8 33 (13.75%) BDD
9 31 (12.92%) E-Commerce
10 29 (12.08%) Open Source
11 27 (11.25%) Machine Learning
12 23 (9.58%) Data Modelling
13 22 (9.17%) Data Analytics
14 21 (8.75%) Software Engineering
15 19 (7.92%) Data Engineering
15 19 (7.92%) Performance Tuning
16 18 (7.50%) Microservices
16 18 (7.50%) Scrum
17 17 (7.08%) Migration
Programming Languages
1 149 (62.08%) Python
2 142 (59.17%) SQL
3 88 (36.67%) Java
4 75 (31.25%) Scala
5 21 (8.75%) R
6 15 (6.25%) Java 8
7 14 (5.83%) Groovy
8 13 (5.42%) JavaScript
9 12 (5.00%) Perl
10 11 (4.58%) Bash Shell
11 10 (4.17%) C
12 8 (3.33%) C++
12 8 (3.33%) Shell Script
13 4 (1.67%) T-SQL
14 3 (1.25%) Ruby
15 2 (0.83%) C#
15 2 (0.83%) VBA
16 1 (0.42%) PHP
16 1 (0.42%) PowerShell
16 1 (0.42%) VB.NET
Qualifications
1 10 (4.17%) SC Cleared
1 10 (4.17%) Security Cleared
2 4 (1.67%) Degree
2 4 (1.67%) DV Cleared
3 2 (0.83%) Computer Science Degree
4 1 (0.42%) AWS Certification
Quality Assurance & Compliance
1 12 (5.00%) Data Quality
2 7 (2.92%) QA
3 4 (1.67%) GDPR
System Software
1 28 (11.67%) Docker
2 17 (7.08%) Apache Flume
3 14 (5.83%) HDFS
4 2 (0.83%) Apache ZooKeeper
4 2 (0.83%) Virtual Machines
5 1 (0.42%) Active Directory
Systems Management
1 31 (12.92%) Terraform
2 23 (9.58%) Opscode Chef
3 20 (8.33%) Kubernetes
3 20 (8.33%) Oozie
4 18 (7.50%) Ansible
5 8 (3.33%) Packer
6 7 (2.92%) Hadoop YARN
7 6 (2.50%) Nagios
8 5 (2.08%) Docker Swarm
8 5 (2.08%) ZABBIX
9 4 (1.67%) Consul
10 3 (1.25%) Puppet
11 1 (0.42%) Failover Clustering
11 1 (0.42%) Grafana
11 1 (0.42%) Suricata
Vendors
1 20 (8.33%) Tableau
2 19 (7.92%) Google
2 19 (7.92%) Oracle
3 13 (5.42%) Splunk
4 10 (4.17%) SAP
5 9 (3.75%) Salesforce.com
6 7 (2.92%) Hortonworks
6 7 (2.92%) Informatica
7 6 (2.50%) Greenplum
7 6 (2.50%) Omniture
8 5 (2.08%) Atlassian
8 5 (2.08%) MapR
8 5 (2.08%) Red Hat
8 5 (2.08%) SaltStack
8 5 (2.08%) Talend
9 4 (1.67%) Cloudera
9 4 (1.67%) MicroStrategy
9 4 (1.67%) Teradata
10 3 (1.25%) Cognos
11 2 (0.83%) IBM