Period
to 12 November 2018

The following table provides summary statistics for permanent job vacancies advertised in Canary Wharf with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 12 November 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Tower Hamlets > Canary Wharf
6 months to
12 Nov 2018
Same period 2017 Same period 2016
Rank 2 4 7
Rank change year-on-year +2 +3 -1
Permanent jobs citing SQL 60 53 63
As % of all permanent IT jobs advertised in Canary Wharf 33.90% 25.36% 24.51%
As % of the Programming Languages category 53.10% 53.00% 45.32%
Number of salaries quoted 43 39 57
Canary Wharf median annual salary £50,000 £67,500 £65,000
Median salary % change year-on-year -25.93% +3.85% -1.89%
10th Percentile £41,250 £41,550 £50,300
90th Percentile £71,000 £76,250 £112,000
Tower Hamlets median annual salary £52,500 £67,500 £63,750
% change year-on-year -22.22% +5.88% -3.77%

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Canary Wharf with a requirement for coding skills.

All Programming Languages
Canary Wharf
Permanent vacancies with a requirement for coding skills 113 100 139
As % of all permanent IT jobs advertised in Canary Wharf 63.84% 47.85% 54.09%
Number of salaries quoted 86 75 122
Canary Wharf median annual salary £55,000 £67,500 £67,500
Median salary % change year-on-year -18.52% - -
10th Percentile £41,250 £43,800 £52,500
90th Percentile £82,500 £80,000 £112,500
Tower Hamlets median annual salary £55,000 £70,000 £67,500
% change year-on-year -21.43% +3.70% -

SQL
Job Vacancy Trend in Canary Wharf

Job postings citing SQL as a percentage of all IT jobs advertised in Canary Wharf.

Job vacancy trend for SQL in Canary Wharf

SQL
Salary Trend in Canary Wharf

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Canary Wharf.

Salary trend for SQL in Canary Wharf

SQL
Salary Histogram in Canary Wharf

The salary distribution of IT jobs citing SQL in Canary Wharf over the 6 months to 12 November 2018.

Salary histogram for SQL in Canary Wharf

For the 6 months to 12 November 2018, IT jobs citing SQL 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 Canary Wharf region with a requirement for SQL.

1 40 (66.67%) Oracle
2 35 (58.33%) Finance
3 25 (41.67%) Linux
4 24 (40.00%) Oracle Reports
4 24 (40.00%) Banking
5 23 (38.33%) Unix
6 21 (35.00%) Degree
7 18 (30.00%) Relational Database
8 17 (28.33%) Crystal Reports
9 16 (26.67%) Agile Software Development
10 15 (25.00%) Change Management
10 15 (25.00%) Java
10 15 (25.00%) Test Scripting
11 14 (23.33%) Mentoring
11 14 (23.33%) Windows
11 14 (23.33%) OO
12 13 (21.67%) HTML
12 13 (21.67%) CSS
12 13 (21.67%) JavaScript
12 13 (21.67%) Scrum
12 13 (21.67%) Software Engineering
12 13 (21.67%) Fintech
13 12 (20.00%) HTML5
13 12 (20.00%) RabbitMQ
13 12 (20.00%) CSS3
13 12 (20.00%) Time Management
13 12 (20.00%) JPA
13 12 (20.00%) Java EE
13 12 (20.00%) Dojo
13 12 (20.00%) Creative Thinking

SQL
Co-occurring IT Skills in Canary Wharf 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 12 (20.00%) Elasticsearch
2 2 (3.33%) SAS
3 1 (1.67%) MS Exchange
3 1 (1.67%) Oracle SOA Suite
Applications
1 1 (1.67%) Microsoft Excel
1 1 (1.67%) Microsoft Office
1 1 (1.67%) Stata
Business Applications
1 2 (3.33%) FLEXCUBE
1 2 (3.33%) Oracle Cash Management
Cloud Services
1 2 (3.33%) Amazon AWS
1 2 (3.33%) Microsoft Azure
2 1 (1.67%) Office 365
2 1 (1.67%) SaaS
Communications & Networking
1 3 (5.00%) SAN
2 1 (1.67%) Broadband
2 1 (1.67%) Firewall
2 1 (1.67%) Kerberos
2 1 (1.67%) MQTT
2 1 (1.67%) Network Security
2 1 (1.67%) OSPF
2 1 (1.67%) SNMP
2 1 (1.67%) TACACS
2 1 (1.67%) TCP/IP
Database & Business Intelligence
1 24 (40.00%) Oracle Reports
2 18 (30.00%) Relational Database
3 17 (28.33%) Crystal Reports
4 10 (16.67%) Oracle Database
4 10 (16.67%) Oracle Database 11g
5 7 (11.67%) BusinessObjects
5 7 (11.67%) Data Warehouse
5 7 (11.67%) Roambi
5 7 (11.67%) SQL Server
6 3 (5.00%) Big Data
6 3 (5.00%) SQL Server 2014
6 3 (5.00%) SQL Server Analysis Services
6 3 (5.00%) SQL Server Integration Services
6 3 (5.00%) SQL Server Reporting Services
7 2 (3.33%) Data Mining
8 1 (1.67%) Amazon RDS
8 1 (1.67%) Hadoop
8 1 (1.67%) RDBMS
8 1 (1.67%) Spotfire
8 1 (1.67%) SQLPlus
Development Applications
1 1 (1.67%) RStudio
1 1 (1.67%) Team Foundation Server
1 1 (1.67%) Visual Studio
General
1 35 (58.33%) Finance
2 24 (40.00%) Banking
3 7 (11.67%) Front Office
4 2 (3.33%) Investment Banking
4 2 (3.33%) Telecoms
5 1 (1.67%) Back Office
5 1 (1.67%) Financial Institution
5 1 (1.67%) Games
5 1 (1.67%) Law
5 1 (1.67%) Legal
5 1 (1.67%) Manufacturing
5 1 (1.67%) Retail
Job Titles
1 22 (36.67%) Applications Support
2 18 (30.00%) Analyst
3 17 (28.33%) Applications Support Analyst
3 17 (28.33%) Support Analyst
4 15 (25.00%) Developer
5 13 (21.67%) Java Engineer
5 13 (21.67%) Software Engineer
6 12 (20.00%) Elasticsearch Engineer
6 12 (20.00%) Java Software Engineer
6 12 (20.00%) Lead Software Engineer
7 10 (16.67%) Banking Analyst
8 9 (15.00%) Oracle Analyst
8 9 (15.00%) Oracle Support Analyst
8 9 (15.00%) Unix Analyst
8 9 (15.00%) Unix Support
8 9 (15.00%) Unix Support Analyst
9 7 (11.67%) Business Developer
9 7 (11.67%) SAP BusinessObjects (BO) Developer
10 5 (8.33%) Electronic Trading Support
10 5 (8.33%) SQL Developer
Libraries, Frameworks & Software Standards
1 13 (21.67%) CSS
1 13 (21.67%) HTML
2 12 (20.00%) ActiveMQ
2 12 (20.00%) CSS3
2 12 (20.00%) Dojo
2 12 (20.00%) Hibernate
2 12 (20.00%) HTML5
2 12 (20.00%) Java EE
2 12 (20.00%) JDBC
2 12 (20.00%) JPA
2 12 (20.00%) RabbitMQ
2 12 (20.00%) Spring
3 3 (5.00%) .NET
4 2 (3.33%) AngularJS
4 2 (3.33%) TensorFlow
5 1 (1.67%) Angular 2
5 1 (1.67%) PySpark
5 1 (1.67%) React
5 1 (1.67%) Unity DI Container
5 1 (1.67%) Vue.js
Miscellaneous
1 13 (21.67%) Fintech
2 9 (15.00%) Computer Science
3 7 (11.67%) Fixed Income
4 3 (5.00%) Algorithms
4 3 (5.00%) Analytical Skills
4 3 (5.00%) Clustering
4 3 (5.00%) Data Structures
4 3 (5.00%) Replication
5 2 (3.33%) Data Centre
5 2 (3.33%) Equities
5 2 (3.33%) Foreign Exchange (FX)
6 1 (1.67%) AS400
6 1 (1.67%) Greenfield Project
6 1 (1.67%) Hedge funds
6 1 (1.67%) Linux Command Line
6 1 (1.67%) Smart City
Operating Systems
1 25 (41.67%) Linux
2 23 (38.33%) Unix
3 14 (23.33%) Windows
4 7 (11.67%) Windows Server
4 7 (11.67%) Windows Server 2008
5 1 (1.67%) Debian
5 1 (1.67%) Embedded Linux
5 1 (1.67%) Solaris
Processes & Methodologies
1 16 (26.67%) Agile Software Development
2 15 (25.00%) Change Management
2 15 (25.00%) Test Scripting
3 14 (23.33%) Mentoring
3 14 (23.33%) OO
4 13 (21.67%) Scrum
4 13 (21.67%) Software Engineering
5 12 (20.00%) Anti-Money Laundering
5 12 (20.00%) Creative Thinking
5 12 (20.00%) KYC
5 12 (20.00%) Time Management
6 8 (13.33%) Mathematics
7 7 (11.67%) Business Intelligence
7 7 (11.67%) ITIL
8 5 (8.33%) Data Protection
8 5 (8.33%) Electronic Trading
9 4 (6.67%) Data Science
9 4 (6.67%) Performance Tuning
9 4 (6.67%) Risk Management
10 3 (5.00%) TDD
Programming Languages
1 15 (25.00%) Java
2 13 (21.67%) JavaScript
3 12 (20.00%) Java 8
4 11 (18.33%) Python
5 9 (15.00%) PL/SQL
6 8 (13.33%) Perl
7 7 (11.67%) C
8 6 (10.00%) Bash Shell
9 4 (6.67%) C#
10 3 (5.00%) C++
10 3 (5.00%) PowerShell
10 3 (5.00%) T-SQL
11 2 (3.33%) MATLAB
11 2 (3.33%) R
12 1 (1.67%) AWK
12 1 (1.67%) PHP
12 1 (1.67%) PHP 7
12 1 (1.67%) sed
Qualifications
1 21 (35.00%) Degree
2 6 (10.00%) Computer Science Degree
3 5 (8.33%) ITIL Certification
3 5 (8.33%) Numerate Degree
4 1 (1.67%) A+ Certification
4 1 (1.67%) CCNA
4 1 (1.67%) Cisco Certification
4 1 (1.67%) Citrix Certification
4 1 (1.67%) DV Cleared
4 1 (1.67%) MOS
4 1 (1.67%) SC Cleared
4 1 (1.67%) Security Cleared
Quality Assurance & Compliance
1 1 (1.67%) QA
System Software
1 1 (1.67%) Active Directory
1 1 (1.67%) Terminal Server
1 1 (1.67%) VMware Infrastructure
Systems Management
1 1 (1.67%) Ansible
1 1 (1.67%) Cisco Prime
1 1 (1.67%) Hadoop YARN
1 1 (1.67%) Oozie
1 1 (1.67%) SCCM
Vendors
1 40 (66.67%) Oracle
2 2 (3.33%) Bloomberg
2 2 (3.33%) Cisco
2 2 (3.33%) Citrix
2 2 (3.33%) Cognizant
2 2 (3.33%) Reuters
3 1 (1.67%) CheckPoint
3 1 (1.67%) Cloudera
3 1 (1.67%) EMC
3 1 (1.67%) F5
3 1 (1.67%) Hortonworks
3 1 (1.67%) McAfee
3 1 (1.67%) Microsoft
3 1 (1.67%) Red Hat
3 1 (1.67%) SolarWinds
3 1 (1.67%) VMware