Period
to 27 July 2021

The following table provides summary statistics for contract job vacancies advertised in the City of 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 27 July 2021 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
Central London > City of London
6 months to
27 Jul 2021
Same period 2020 Same period 2019
Rank 156 127 193
Rank change year-on-year -29 +66 +26
Contract jobs citing Amazon Redshift 15 10 48
As % of all contract jobs advertised in the City of London 0.44% 0.42% 0.72%
As % of the Database & Business Intelligence category 2.03% 1.63% 2.64%
Number of daily rates quoted 11 8 36
10th Percentile £419 £556 £440
25th Percentile £447 £575 £513
Median daily rate (50th Percentile) £475 £600 £575
Median % change year-on-year -20.83% +4.35% -4.25%
75th Percentile £498 £625 £628
90th Percentile £613 £670 £675
Central London median daily rate £475 £600 £569
% change year-on-year -20.83% +5.45% -3.15%
Number of hourly rates quoted 0 0 1
Median hourly rate - - £10.50
Central London median hourly rate - - £10.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 the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Contract vacancies with a requirement for database or business intelligence skills 738 612 1,820
As % of all contract IT jobs advertised in the City of London 21.64% 25.47% 27.43%
Number of daily rates quoted 507 458 1,447
10th Percentile £406 £386 £399
25th Percentile £463 £427 £456
Median daily rate (50th Percentile) £550 £516 £525
Median % change year-on-year +6.54% -1.67% -
75th Percentile £650 £600 £613
90th Percentile £715 £688 £675
Central London median daily rate £550 £520 £525
% change year-on-year +5.77% -0.95% -
Number of hourly rates quoted 7 7 12
Median hourly rate £8.00 £37.50 £35.00
Median % change year-on-year -78.67% +7.14% +59.09%
Central London median hourly rate £14.00 £37.50 £35.00
% change year-on-year -62.67% +7.14% +57.30%

Amazon Redshift
Job Vacancy Trend in the City of London

Job postings citing Amazon Redshift as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Amazon Redshift in the City of London

Amazon Redshift
Contractor Daily Rate Trend in the City of London

3-month moving average daily rate quoted in jobs citing Amazon Redshift in the City of London.

Daily rate trend for Amazon Redshift in the City of London

Amazon Redshift
Daily Rate Histogram in the City of London

Daily rate distribution for jobs citing Amazon Redshift in the City of London over the 6 months to 27 July 2021.

Daily rate histogram for Amazon Redshift in the City of London

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

1 15 (100.00%) AWS
2 11 (73.33%) SQL
3 8 (53.33%) Data Warehouse
3 8 (53.33%) Business Intelligence
4 7 (46.67%) ETL
5 6 (40.00%) Visualisation
5 6 (40.00%) Tableau
5 6 (40.00%) Analytics
5 6 (40.00%) Power BI
5 6 (40.00%) Decision-Making
5 6 (40.00%) Power Platform
5 6 (40.00%) Social Skills
6 5 (33.33%) Snowflake
6 5 (33.33%) Data Visualisation
6 5 (33.33%) Stakeholder Management
7 4 (26.67%) Agile Software Development
7 4 (26.67%) BusinessObjects
7 4 (26.67%) Python
7 4 (26.67%) Oracle
8 3 (20.00%) Fintech
8 3 (20.00%) Data Engineering
8 3 (20.00%) Problem-Solving
8 3 (20.00%) GitHub
8 3 (20.00%) Yellowfin
8 3 (20.00%) Amazon S3
8 3 (20.00%) SAP
8 3 (20.00%) Java
8 3 (20.00%) Data Modelling
8 3 (20.00%) Data Mart
8 3 (20.00%) JIRA

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 2 (13.33%) Apache Spark
2 1 (6.67%) Oracle SOA Suite
2 1 (6.67%) SAS
2 1 (6.67%) SharePoint
Applications
1 1 (6.67%) SPSS
Business Applications
1 1 (6.67%) Oracle BPM
1 1 (6.67%) SAP MDG
1 1 (6.67%) SAP MDM
Cloud Services
1 15 (100.00%) AWS
2 6 (40.00%) Power Platform
3 5 (33.33%) Snowflake
4 3 (20.00%) Amazon S3
4 3 (20.00%) GitHub
5 2 (13.33%) Amazon EMR
5 2 (13.33%) Azure
5 2 (13.33%) GCP
5 2 (13.33%) Serverless
6 1 (6.67%) Amazon EC2
6 1 (6.67%) Amazon SageMaker
6 1 (6.67%) AWS CloudFormation
6 1 (6.67%) AWS Lambda
6 1 (6.67%) AWS Step Functions
Database & Business Intelligence
1 8 (53.33%) Data Warehouse
2 6 (40.00%) Power BI
2 6 (40.00%) Tableau
3 4 (26.67%) BusinessObjects
4 3 (20.00%) Data Mart
4 3 (20.00%) Yellowfin
5 2 (13.33%) Amazon RDS
5 2 (13.33%) BigQuery
5 2 (13.33%) Hadoop
5 2 (13.33%) Looker
5 2 (13.33%) MySQL
5 2 (13.33%) PostgreSQL
5 2 (13.33%) Sisense
6 1 (6.67%) Big Data
6 1 (6.67%) Oracle BI EE
6 1 (6.67%) Oracle Reports
6 1 (6.67%) PowerCenter
6 1 (6.67%) QlikView
6 1 (6.67%) Snowflake Schema
6 1 (6.67%) Spotfire
Development Applications
1 3 (20.00%) JIRA
2 1 (6.67%) ERwin
2 1 (6.67%) GoCD
2 1 (6.67%) Jenkins
2 1 (6.67%) Oracle APEX
General
1 6 (40.00%) Social Skills
2 2 (13.33%) Marketing
3 1 (6.67%) Analytical Skills
3 1 (6.67%) Finance
3 1 (6.67%) Pharmaceutical
Job Titles
1 5 (33.33%) Analyst
2 4 (26.67%) Business Intelligence Analyst
2 4 (26.67%) Data Analyst
2 4 (26.67%) Data Engineer
3 3 (20.00%) Business Intelligence Data Analyst
4 2 (13.33%) Architect
4 2 (13.33%) Business Intelligence Lead
4 2 (13.33%) Senior Data Engineer
5 1 (6.67%) AWS Architect
5 1 (6.67%) AWS Developer
5 1 (6.67%) Data Architect
5 1 (6.67%) Developer
5 1 (6.67%) ETL Developer
5 1 (6.67%) Information Architect
5 1 (6.67%) Java Engineer
5 1 (6.67%) Report Analyst
5 1 (6.67%) Senior Java Engineer
5 1 (6.67%) SQL Analyst
5 1 (6.67%) SQL Data Analyst
5 1 (6.67%) Supply Chain Architect
Libraries, Frameworks & Software Standards
1 2 (13.33%) D3.js
1 2 (13.33%) Kafka
2 1 (6.67%) JSON
2 1 (6.67%) PySpark
2 1 (6.67%) Spring
2 1 (6.67%) XML
Miscellaneous
1 1 (6.67%) Algorithms
1 1 (6.67%) Linux Command Line
1 1 (6.67%) Self-Motivation
Operating Systems
1 1 (6.67%) Linux
Processes & Methodologies
1 8 (53.33%) Business Intelligence
2 7 (46.67%) ETL
3 6 (40.00%) Analytics
3 6 (40.00%) Decision-Making
3 6 (40.00%) Visualisation
4 5 (33.33%) Data Visualisation
4 5 (33.33%) Stakeholder Management
5 4 (26.67%) Agile Software Development
6 3 (20.00%) Data Engineering
6 3 (20.00%) Data Modelling
6 3 (20.00%) Fintech
6 3 (20.00%) Problem-Solving
7 2 (13.33%) Architectural Design
7 2 (13.33%) Collaborative Working
7 2 (13.33%) DevOps
7 2 (13.33%) Machine Learning
7 2 (13.33%) Performance Metrics
7 2 (13.33%) Performance Tuning
7 2 (13.33%) Software Engineering
8 1 (6.67%) Data Extraction
Programming Languages
1 11 (73.33%) SQL
2 4 (26.67%) Python
3 3 (20.00%) Java
4 1 (6.67%) Scala
4 1 (6.67%) T-SQL
Qualifications
1 2 (13.33%) Degree
2 1 (6.67%) Computer Science Degree
Quality Assurance & Compliance
1 2 (13.33%) Data Quality
System Software
1 1 (6.67%) Docker
Systems Management
1 1 (6.67%) Kubernetes
1 1 (6.67%) Terraform
Vendors
1 4 (26.67%) Oracle
2 3 (20.00%) SAP
3 2 (13.33%) Informatica
3 2 (13.33%) Talend
4 1 (6.67%) Alteryx
4 1 (6.67%) Cognos
4 1 (6.67%) IBM
4 1 (6.67%) Microsoft
4 1 (6.67%) Salesforce Marketing Cloud
4 1 (6.67%) Salesforce.com