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

SQL (Structured Query Language)
Tower Hamlets > Canary Wharf
6 months to
20 Aug 2018
Same period 2017 Same period 2016
Rank 2 2 7
Rank change year-on-year 0 +5 0
Permanent jobs citing SQL 80 90 45
As % of all permanent IT jobs advertised in Canary Wharf 38.46% 32.37% 15.90%
As % of the Programming Languages category 60.61% 60.00% 33.83%
Number of salaries quoted 65 63 48
Canary Wharf median annual salary £50,000 £65,000 £60,000
Median salary % change year-on-year -23.08% +8.33% -
10th Percentile £41,250 £36,250 £41,250
90th Percentile £75,000 £82,250 £105,000
Tower Hamlets median annual salary £50,000 £65,000 £60,000
% change year-on-year -23.08% +8.33% -

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 132 150 133
As % of all permanent IT jobs advertised in Canary Wharf 63.46% 53.96% 47.00%
Number of salaries quoted 109 106 117
Canary Wharf median annual salary £55,000 £67,500 £60,000
Median salary % change year-on-year -18.52% +12.50% -
10th Percentile £41,250 £38,750 £45,750
90th Percentile £82,500 £81,250 £105,000
Tower Hamlets median annual salary £55,000 £67,500 £60,000
% change year-on-year -18.52% +12.50% +4.35%

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 20 August 2018.

Salary histogram for SQL in Canary Wharf

For the 6 months to 20 August 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 43 (53.75%) Oracle
2 36 (45.00%) Banking
3 35 (43.75%) Finance
4 31 (38.75%) Oracle Reports
5 27 (33.75%) Unix
6 26 (32.50%) Linux
7 21 (26.25%) Windows
8 20 (25.00%) SQL Server
9 19 (23.75%) PL/SQL
9 19 (23.75%) Degree
9 19 (23.75%) Relational Database
10 18 (22.50%) Crystal Reports
11 17 (21.25%) Data Warehouse
12 16 (20.00%) Change Management
12 16 (20.00%) Oracle Database
12 16 (20.00%) Oracle Database 11g
12 16 (20.00%) Test Scripting
13 14 (17.50%) Windows Server
14 13 (16.25%) Roambi
14 13 (16.25%) HTML
14 13 (16.25%) Business Intelligence
14 13 (16.25%) BusinessObjects
14 13 (16.25%) Windows Server 2008
15 12 (15.00%) Mathematics
15 12 (15.00%) Python
15 12 (15.00%) Front Office
15 12 (15.00%) Problem-Solving
16 11 (13.75%) Agile Software Development
16 11 (13.75%) Analytical Skills
17 10 (12.50%) C

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 5 (6.25%) Elasticsearch
1 5 (6.25%) SAS
2 2 (2.50%) IIS
Applications
1 2 (2.50%) Microsoft Excel
1 2 (2.50%) Microsoft Office
2 1 (1.25%) Microsoft PowerPoint
2 1 (1.25%) Stata
Business Applications
1 2 (2.50%) FLEXCUBE
1 2 (2.50%) Oracle Cash Management
Cloud Services
1 4 (5.00%) Amazon AWS
1 4 (5.00%) Microsoft Azure
2 1 (1.25%) Office 365
Communications & Networking
1 3 (3.75%) SAN
2 2 (2.50%) TCP/IP
3 1 (1.25%) DHCP
3 1 (1.25%) DNS
3 1 (1.25%) Firewall
3 1 (1.25%) HTTP
3 1 (1.25%) Kerberos
3 1 (1.25%) Network Security
3 1 (1.25%) OSPF
3 1 (1.25%) PuTTY
3 1 (1.25%) SNMP
3 1 (1.25%) SSH
3 1 (1.25%) SSL
3 1 (1.25%) TACACS
3 1 (1.25%) WinSCP
Database & Business Intelligence
1 31 (38.75%) Oracle Reports
2 20 (25.00%) SQL Server
3 19 (23.75%) Relational Database
4 18 (22.50%) Crystal Reports
5 17 (21.25%) Data Warehouse
6 16 (20.00%) Oracle Database
6 16 (20.00%) Oracle Database 11g
7 13 (16.25%) BusinessObjects
7 13 (16.25%) Roambi
8 4 (5.00%) SQL Server 2008
9 3 (3.75%) Azure SQL Database
9 3 (3.75%) Data Mining
9 3 (3.75%) SQL Server 2014
9 3 (3.75%) SQL Server Analysis Services
9 3 (3.75%) SQL Server Integration Services
9 3 (3.75%) SQL Server Reporting Services
10 2 (2.50%) Amazon Aurora
10 2 (2.50%) Amazon Redshift
10 2 (2.50%) Big Data
10 2 (2.50%) MySQL
Development Applications
1 6 (7.50%) Visual Studio
2 2 (2.50%) Git (software)
2 2 (2.50%) Jenkins
2 2 (2.50%) Subversion
2 2 (2.50%) Team Foundation Server
3 1 (1.25%) RStudio
General
1 36 (45.00%) Banking
2 35 (43.75%) Finance
3 12 (15.00%) Front Office
4 4 (5.00%) Investment Banking
4 4 (5.00%) Marketing
5 2 (2.50%) Financial Institution
6 1 (1.25%) Back Office
6 1 (1.25%) Brand Awareness
6 1 (1.25%) Telecoms
Job Titles
1 34 (42.50%) Developer
2 23 (28.75%) Applications Support
3 22 (27.50%) Analyst
4 20 (25.00%) Applications Support Analyst
4 20 (25.00%) Support Analyst
5 16 (20.00%) SQL Developer
6 14 (17.50%) Banking Analyst
7 13 (16.25%) Business Developer
7 13 (16.25%) SAP BusinessObjects (BO) Developer
8 12 (15.00%) Unix Analyst
9 11 (13.75%) Oracle Analyst
9 11 (13.75%) Oracle Support Analyst
9 11 (13.75%) Unix Support
9 11 (13.75%) Unix Support Analyst
10 9 (11.25%) C# Developer
11 8 (10.00%) .NET Developer
11 8 (10.00%) C# .NET Developer
12 6 (7.50%) Front Office Developer
12 6 (7.50%) Report Developer
13 5 (6.25%) Software Engineer
Libraries, Frameworks & Software Standards
1 13 (16.25%) HTML
2 10 (12.50%) .NET
3 8 (10.00%) CSS
4 6 (7.50%) ASP.NET
5 5 (6.25%) ActiveMQ
5 5 (6.25%) CSS3
5 5 (6.25%) Dojo
5 5 (6.25%) Hibernate
5 5 (6.25%) HTML5
5 5 (6.25%) Java EE
5 5 (6.25%) JDBC
5 5 (6.25%) JPA
5 5 (6.25%) RabbitMQ
5 5 (6.25%) Spring
6 4 (5.00%) EDI
7 2 (2.50%) jQuery
7 2 (2.50%) JSON
7 2 (2.50%) REST
7 2 (2.50%) SOAP
7 2 (2.50%) Web Services
Miscellaneous
1 11 (13.75%) Analytical Skills
2 9 (11.25%) Computer Science
3 8 (10.00%) Fintech
4 5 (6.25%) Data Structures
4 5 (6.25%) Fixed Income
4 5 (6.25%) Foreign Exchange (FX)
5 4 (5.00%) Replication
5 4 (5.00%) User Experience
6 3 (3.75%) Clustering
6 3 (3.75%) Equities
7 2 (2.50%) Algorithms
7 2 (2.50%) Data Centre
7 2 (2.50%) Derivative
7 2 (2.50%) Hedge funds
8 1 (1.25%) Analytical Mindset
8 1 (1.25%) AS400
8 1 (1.25%) Blog
8 1 (1.25%) Greenfield Project
8 1 (1.25%) Linux Command Line
8 1 (1.25%) Self-Motivation
Operating Systems
1 27 (33.75%) Unix
2 26 (32.50%) Linux
3 21 (26.25%) Windows
4 14 (17.50%) Windows Server
5 13 (16.25%) Windows Server 2008
6 1 (1.25%) Red Hat Enterprise Linux
6 1 (1.25%) Solaris
Processes & Methodologies
1 16 (20.00%) Change Management
1 16 (20.00%) Test Scripting
2 13 (16.25%) Business Intelligence
3 12 (15.00%) Mathematics
3 12 (15.00%) Problem-Solving
4 11 (13.75%) Agile Software Development
5 9 (11.25%) Performance Tuning
6 8 (10.00%) Analytics
6 8 (10.00%) ETL
6 8 (10.00%) Risk Management
7 7 (8.75%) Mentoring
7 7 (8.75%) OO
7 7 (8.75%) Scrum
8 6 (7.50%) ITIL
8 6 (7.50%) Stakeholder Management
8 6 (7.50%) Statistics
9 5 (6.25%) Data Protection
9 5 (6.25%) SDLC
9 5 (6.25%) Software Engineering
9 5 (6.25%) Time Management
Programming Languages
1 19 (23.75%) PL/SQL
2 12 (15.00%) Python
3 10 (12.50%) C
4 9 (11.25%) C#
4 9 (11.25%) Java
4 9 (11.25%) JavaScript
5 7 (8.75%) Perl
6 6 (7.50%) T-SQL
7 5 (6.25%) Java 8
8 4 (5.00%) Bash Shell
9 3 (3.75%) MATLAB
9 3 (3.75%) PowerShell
9 3 (3.75%) R
10 2 (2.50%) C++
11 1 (1.25%) AWK
11 1 (1.25%) Korn
11 1 (1.25%) PHP
11 1 (1.25%) PHP 7
11 1 (1.25%) sed
11 1 (1.25%) Shell Script
Qualifications
1 19 (23.75%) Degree
2 5 (6.25%) Computer Science Degree
3 4 (5.00%) Numerate Degree
4 3 (3.75%) ITIL Certification
5 2 (2.50%) Security Cleared
6 1 (1.25%) CCNA
6 1 (1.25%) CFA
6 1 (1.25%) Cisco Certification
6 1 (1.25%) Citrix Certification
6 1 (1.25%) DV Cleared
6 1 (1.25%) SC Cleared
Quality Assurance & Compliance
1 3 (3.75%) QA
System Software
1 1 (1.25%) Terminal Server
1 1 (1.25%) VMware Infrastructure
Systems Management
1 1 (1.25%) Ansible
1 1 (1.25%) Cisco Prime
Vendors
1 43 (53.75%) Oracle
2 7 (8.75%) Microsoft
3 2 (2.50%) Bloomberg
3 2 (2.50%) Cisco
3 2 (2.50%) Cognizant
3 2 (2.50%) Google
3 2 (2.50%) Red Hat
3 2 (2.50%) Reuters
4 1 (1.25%) CheckPoint
4 1 (1.25%) Citrix
4 1 (1.25%) EMC
4 1 (1.25%) F5
4 1 (1.25%) FactSet
4 1 (1.25%) IBM
4 1 (1.25%) McAfee
4 1 (1.25%) SolarWinds
4 1 (1.25%) Sun
4 1 (1.25%) Sybase
4 1 (1.25%) Teradata
4 1 (1.25%) VMware