Period
to 20 November 2017

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

SQL (Structured Query Language)
Tower Hamlets > Canary Wharf
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 5 7 6
Rank change year-on-year +2 -1 +5
Permanent jobs citing SQL 53 65 49
As % of all permanent IT jobs advertised in Canary Wharf 25.24% 24.62% 17.07%
As % of the Programming Languages category 53.00% 45.14% 39.84%
Number of salaries quoted 39 57 28
Canary Wharf median annual salary £67,500 £65,000 £66,250
Median salary % change year-on-year +3.85% -1.89% +15.22%
10th Percentile £44,600 £50,300 £47,375
90th Percentile £76,250 £122,500 £100,000
Tower Hamlets median annual salary £67,500 £63,750 £66,250
% change year-on-year +5.88% -3.77% +15.22%

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 100 144 123
As % of all permanent IT jobs advertised in Canary Wharf 47.62% 54.55% 42.86%
Number of salaries quoted 77 120 88
Canary Wharf median annual salary £70,000 £67,500 £70,000
Median salary % change year-on-year +3.70% -3.57% +16.67%
10th Percentile £45,000 £52,500 £32,750
90th Percentile £80,000 £112,500 £105,000
Tower Hamlets median annual salary £70,000 £67,500 £70,000
% change year-on-year +3.70% -3.57% +16.67%

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

Salary histogram for SQL in Canary Wharf

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

1 24 (45.28%) JavaScript
1 24 (45.28%) Banking
2 22 (41.51%) SQL Server
3 18 (33.96%) HTML
4 17 (32.08%) C#
4 17 (32.08%) Finance
4 17 (32.08%) Relational Database
5 15 (28.30%) Oracle
6 14 (26.42%) Linux
6 14 (26.42%) Java
7 13 (24.53%) PostgreSQL
8 12 (22.64%) Sybase
8 12 (22.64%) .NET
8 12 (22.64%) RDBMS
8 12 (22.64%) Agile Software Development
9 11 (20.75%) Web Development
9 11 (20.75%) Unix
9 11 (20.75%) Windows
10 10 (18.87%) XML
10 10 (18.87%) Retail
10 10 (18.87%) Software Engineering
11 9 (16.98%) Microsoft
12 8 (15.09%) Cognizant
12 8 (15.09%) Systems Management Server (SMS)
12 8 (15.09%) Adobe
12 8 (15.09%) Data Modelling
12 8 (15.09%) CSS
12 8 (15.09%) Python
12 8 (15.09%) Marketing
12 8 (15.09%) Digital Marketing

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 6 (11.32%) Apache
2 4 (7.55%) Tomcat
3 3 (5.66%) GlassFish
3 3 (5.66%) JBoss
3 3 (5.66%) Jetty
3 3 (5.66%) Mule
3 3 (5.66%) SAS
3 3 (5.66%) WebLogic
3 3 (5.66%) WebSphere
3 3 (5.66%) WebSphere Application Server
4 2 (3.77%) Blackberry Enterprise Server
4 2 (3.77%) MS Exchange
5 1 (1.89%) Cloud Foundry
5 1 (1.89%) Gunicorn
5 1 (1.89%) IIS
5 1 (1.89%) nginx
5 1 (1.89%) Tornado
5 1 (1.89%) uWSGI
Applications
1 6 (11.32%) Microsoft Excel
Business Applications
1 8 (15.09%) Adobe Campaign
1 8 (15.09%) Eloqua
Cloud Services
1 3 (5.66%) Google Analytics
2 2 (3.77%) Microsoft Azure
2 2 (3.77%) Mimecast
2 2 (3.77%) Office 365
3 1 (1.89%) Amazon AWS
3 1 (1.89%) Google Drive
3 1 (1.89%) Heroku
3 1 (1.89%) OpenShift
3 1 (1.89%) PaaS
Communications & Networking
1 3 (5.66%) DNS
2 2 (3.77%) FTP
2 2 (3.77%) PuTTY
2 2 (3.77%) Remote Desktop
2 2 (3.77%) WAN
3 1 (1.89%) Cisco ASA
3 1 (1.89%) Cisco IOS
3 1 (1.89%) DHCP
3 1 (1.89%) Firewall
3 1 (1.89%) HTTP
3 1 (1.89%) HTTPS
3 1 (1.89%) SAN
3 1 (1.89%) SMTP
3 1 (1.89%) TCP/IP
3 1 (1.89%) VLAN
Database & Business Intelligence
1 22 (41.51%) SQL Server
2 17 (32.08%) Relational Database
3 13 (24.53%) PostgreSQL
4 12 (22.64%) RDBMS
5 6 (11.32%) MariaDB
5 6 (11.32%) VLDB
6 4 (7.55%) Data Warehouse
6 4 (7.55%) MySQL
6 4 (7.55%) NoSQL
7 3 (5.66%) Data Mining
7 3 (5.66%) Enterprise Data Warehouse
7 3 (5.66%) Hadoop
7 3 (5.66%) Informix
7 3 (5.66%) MongoDB
7 3 (5.66%) QlikView
7 3 (5.66%) SQL Server Integration Services
8 2 (3.77%) SQL Server 2008
8 2 (3.77%) SQL Server 2012
9 1 (1.89%) PowerPivot
9 1 (1.89%) SQL Server Analysis Services
Development Applications
1 3 (5.66%) Git (software)
1 3 (5.66%) NUnit
1 3 (5.66%) VSS/SourceSafe
2 2 (3.77%) Jasmine
2 2 (3.77%) ReSharper
2 2 (3.77%) Selenium
2 2 (3.77%) SpecFlow
2 2 (3.77%) Team Foundation Server
3 1 (1.89%) Vagrant
General
1 24 (45.28%) Banking
2 17 (32.08%) Finance
3 10 (18.87%) Retail
4 8 (15.09%) Marketing
5 6 (11.32%) Telecoms
6 3 (5.66%) Front Office
6 3 (5.66%) Investment Banking
7 1 (1.89%) Advertising
7 1 (1.89%) French Language
Job Titles
1 28 (52.83%) Developer
2 11 (20.75%) Java Developer
3 8 (15.09%) Analyst
3 8 (15.09%) Architect
3 8 (15.09%) Database Developer
3 8 (15.09%) Solutions Architect
4 7 (13.21%) Software Developer
5 6 (11.32%) Automation Engineer
5 6 (11.32%) Database Engineer
5 6 (11.32%) Software Engineer
6 5 (9.43%) Automation Developer
6 5 (9.43%) Banking Analyst
6 5 (9.43%) C# Developer
6 5 (9.43%) Data Analyst
6 5 (9.43%) Developer/Software Engineer
6 5 (9.43%) SQL Developer
7 4 (7.55%) Agile Developer
7 4 (7.55%) Senior Agile Developer
7 4 (7.55%) Senior Developer
7 4 (7.55%) UI Developer
Libraries, Frameworks & Software Standards
1 18 (33.96%) HTML
2 12 (22.64%) .NET
3 10 (18.87%) XML
4 8 (15.09%) CSS
4 8 (15.09%) jQuery
4 8 (15.09%) RESTful
5 7 (13.21%) REST
6 5 (9.43%) AngularJS
7 4 (7.55%) ASP.NET
7 4 (7.55%) JMS
7 4 (7.55%) React Native
7 4 (7.55%) Spring
8 3 (5.66%) Elastic Stack
8 3 (5.66%) J2EE
8 3 (5.66%) JSP
8 3 (5.66%) Middleware
8 3 (5.66%) Servlets
9 2 (3.77%) .NET Framework
9 2 (3.77%) Entity Framework
9 2 (3.77%) Twitter Bootstrap
Miscellaneous
1 8 (15.09%) Enterprise Software
2 7 (13.21%) Greenfield Project
3 6 (11.32%) Mobile App
4 4 (7.55%) Analytical Skills
4 4 (7.55%) Computer Science
5 3 (5.66%) Credit Risk
5 3 (5.66%) iPad
6 2 (3.77%) Fintech
6 2 (3.77%) Hedge funds
6 2 (3.77%) iPhone
7 1 (1.89%) CCTV
Operating Systems
1 14 (26.42%) Linux
2 11 (20.75%) Unix
2 11 (20.75%) Windows
3 8 (15.09%) Android
4 7 (13.21%) Apple iOS
5 4 (7.55%) Nucleus RTOS
5 4 (7.55%) Windows Phone
6 3 (5.66%) Solaris
7 2 (3.77%) Windows Server
8 1 (1.89%) Windows 10
8 1 (1.89%) Windows 7
8 1 (1.89%) Windows 8
8 1 (1.89%) Windows Server 2008
8 1 (1.89%) Windows Server 2012
Processes & Methodologies
1 12 (22.64%) Agile Software Development
2 11 (20.75%) Web Development
3 10 (18.87%) Software Engineering
4 8 (15.09%) Data Modelling
4 8 (15.09%) Digital Marketing
4 8 (15.09%) Marketing Automation
4 8 (15.09%) Presales
5 7 (13.21%) Analytics
5 7 (13.21%) Cross-Platform Development
5 7 (13.21%) Mentoring
5 7 (13.21%) Multithreading
5 7 (13.21%) Test Automation
6 6 (11.32%) Multithreaded Programming
7 5 (9.43%) Refactoring
8 4 (7.55%) Continuous Integration
8 4 (7.55%) Data Management
8 4 (7.55%) Enterprise Architecture
8 4 (7.55%) Kanban
8 4 (7.55%) Mobile Application Development
8 4 (7.55%) Web Application Development
Programming Languages
1 24 (45.28%) JavaScript
2 17 (32.08%) C#
3 14 (26.42%) Java
4 8 (15.09%) Python
5 7 (13.21%) PowerShell
6 6 (11.32%) Bash Shell
6 6 (11.32%) VBA
7 5 (9.43%) C++
8 4 (7.55%) Apple Swift
8 4 (7.55%) C
8 4 (7.55%) Objective-C
8 4 (7.55%) T-SQL
9 3 (5.66%) Shell Script
10 2 (3.77%) Ruby
11 1 (1.89%) PHP
Qualifications
1 4 (7.55%) Degree
2 1 (1.89%) Computer Science Degree
2 1 (1.89%) ITIL Certification
Quality Assurance & Compliance
1 3 (5.66%) ISO/IEC 20000
2 2 (3.77%) SLA
System Software
1 4 (7.55%) Active Directory
2 1 (1.89%) Docker
2 1 (1.89%) VMware Infrastructure
Systems Management
1 8 (15.09%) Systems Management Server (SMS)
2 3 (5.66%) Nagios
2 3 (5.66%) Opsview
2 3 (5.66%) ZABBIX
3 1 (1.89%) Ansible
3 1 (1.89%) Norton AntiVirus
Vendors
1 15 (28.30%) Oracle
2 12 (22.64%) Sybase
3 9 (16.98%) Microsoft
4 8 (15.09%) Adobe
4 8 (15.09%) Cognizant
4 8 (15.09%) Salesforce Marketing Cloud
5 7 (13.21%) Tableau
6 4 (7.55%) Google
6 4 (7.55%) Solace
7 3 (5.66%) MKS
7 3 (5.66%) Optimizely
7 3 (5.66%) Perforce
7 3 (5.66%) Red Hat
7 3 (5.66%) SolarWinds
7 3 (5.66%) VMware
8 1 (1.89%) Cisco
8 1 (1.89%) IBM
8 1 (1.89%) Symantec
8 1 (1.89%) TIBCO
8 1 (1.89%) Veeam