Period
to 19 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Hammersmith 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 19 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
West London > Hammersmith
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 5 16 7
Rank change year-on-year +11 -9 +4
Permanent jobs citing SQL 67 14 48
As % of all permanent IT jobs advertised in Hammersmith 21.20% 12.50% 23.88%
As % of the Programming Languages category 29.26% 18.67% 34.04%
Number of salaries quoted 53 14 45
Hammersmith median annual salary £47,500 £45,000 £47,500
Median salary % change year-on-year +5.56% -5.26% -20.83%
10th Percentile £31,250 £36,625 £31,000
90th Percentile £67,500 £61,875 £57,500
West London median annual salary £50,000 £45,000 £47,000
% change year-on-year +11.11% -4.26% +4.44%

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 Hammersmith with a requirement for coding skills.

All Programming Languages
Hammersmith
Permanent vacancies with a requirement for coding skills 229 75 141
As % of all permanent IT jobs advertised in Hammersmith 72.47% 66.96% 70.15%
Number of salaries quoted 200 74 132
Hammersmith median annual salary £55,000 £50,000 £51,500
Median salary % change year-on-year +10.00% -2.91% +28.75%
10th Percentile £33,625 £36,250 £35,125
90th Percentile £75,000 £63,750 £66,250
West London median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +11.11%

SQL
Job Vacancy Trend in Hammersmith

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

Job vacancy trend for SQL in Hammersmith

SQL
Salary Trend in Hammersmith

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

Salary trend for SQL in Hammersmith

SQL
Salary Histogram in Hammersmith

The salary distribution of IT jobs citing SQL in Hammersmith over the 6 months to 19 November 2017.

Salary histogram for SQL in Hammersmith

For the 6 months to 19 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 Hammersmith region with a requirement for SQL.

1 29 (43.28%) MVC
2 22 (32.84%) TDD
2 22 (32.84%) AngularJS
3 21 (31.34%) Agile Software Development
3 21 (31.34%) C#
4 20 (29.85%) Mentoring
5 19 (28.36%) HTML
5 19 (28.36%) JavaScript
5 19 (28.36%) CSS
5 19 (28.36%) Degree
6 16 (23.88%) jQuery
7 15 (22.39%) Git (software)
7 15 (22.39%) RESTful
7 15 (22.39%) Analytical Skills
7 15 (22.39%) E-Commerce
8 14 (20.90%) .NET
8 14 (20.90%) Retail
9 13 (19.40%) OO
10 12 (17.91%) SOLID
10 12 (17.91%) BDD
11 10 (14.93%) Python
11 10 (14.93%) OOP
11 10 (14.93%) MySQL
11 10 (14.93%) Java
11 10 (14.93%) PHP
11 10 (14.93%) LAMP
11 10 (14.93%) Ajax
11 10 (14.93%) Puppet
11 10 (14.93%) CSS3
11 10 (14.93%) Laravel

SQL
Co-occurring IT Skills in Hammersmith 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 9 (13.43%) Umbraco
2 7 (10.45%) SAS
3 5 (7.46%) Apache Spark
4 3 (4.48%) Apache Airflow
4 3 (4.48%) CMS
5 1 (1.49%) Confluence
5 1 (1.49%) IIS
Applications
1 5 (7.46%) Microsoft Excel
2 4 (5.97%) SPSS
3 1 (1.49%) Microsoft Office
Business Applications
1 4 (5.97%) Adobe Campaign
2 1 (1.49%) HFM
Cloud Services
1 6 (8.96%) Microsoft Azure
Communications & Networking
1 3 (4.48%) TCP/IP
1 3 (4.48%) Unified Communications
1 3 (4.48%) VoIP
Database & Business Intelligence
1 10 (14.93%) MySQL
2 9 (13.43%) SQL Server
2 9 (13.43%) SQL Server Integration Services
3 7 (10.45%) Big Data
3 7 (10.45%) Data Warehouse
4 6 (8.96%) Relational Database
5 5 (7.46%) Hadoop
5 5 (7.46%) NoSQL
6 4 (5.97%) GIS
7 3 (4.48%) Apache Hive
7 3 (4.48%) Data Lake
7 3 (4.48%) Enterprise Data Warehouse
7 3 (4.48%) HBase
7 3 (4.48%) Power BI
7 3 (4.48%) QlikView
7 3 (4.48%) SQL Server Analysis Services
8 2 (2.99%) Geospatial Data
8 2 (2.99%) SQL Server 2005
8 2 (2.99%) SQL Server 2008
9 1 (1.49%) SQL Server Reporting Services
Development Applications
1 15 (22.39%) Git (software)
2 10 (14.93%) Bower
2 10 (14.93%) Grunt
2 10 (14.93%) gulp
2 10 (14.93%) PHPUnit
2 10 (14.93%) Vagrant
3 5 (7.46%) JUnit
3 5 (7.46%) Mockito
4 4 (5.97%) Moq
4 4 (5.97%) NUnit
5 2 (2.99%) JMeter
5 2 (2.99%) Team Foundation Server
6 1 (1.49%) JIRA
6 1 (1.49%) TeamCity
General
1 14 (20.90%) Retail
2 9 (13.43%) Marketing
3 4 (5.97%) Games
4 3 (4.48%) Telecoms
5 2 (2.99%) Finance
6 1 (1.49%) Pharmaceutical
Job Titles
1 30 (44.78%) Developer
2 17 (25.37%) SQL Developer
3 11 (16.42%) Senior Developer
4 10 (14.93%) PHP Developer
5 9 (13.43%) Analyst
6 8 (11.94%) .NET Developer
6 8 (11.94%) E-Commerce Developer
6 8 (11.94%) Senior SQL Developer
7 7 (10.45%) JavaScript Developer
7 7 (10.45%) Junior
7 7 (10.45%) PHP Laravel Developer
7 7 (10.45%) Senior Software Engineer
7 7 (10.45%) Software Engineer
8 6 (8.96%) C# Developer
9 5 (7.46%) Lead .NET Developer
9 5 (7.46%) Lead Developer
10 4 (5.97%) Java Engineer
10 4 (5.97%) Senior Java Engineer
10 4 (5.97%) Senior JavaScript Developer
10 4 (5.97%) SSIS Developer
Libraries, Frameworks & Software Standards
1 22 (32.84%) AngularJS
2 19 (28.36%) CSS
2 19 (28.36%) HTML
3 16 (23.88%) jQuery
4 15 (22.39%) RESTful
5 14 (20.90%) .NET
6 10 (14.93%) Ajax
6 10 (14.93%) CSS3
6 10 (14.93%) HTML5
6 10 (14.93%) LAMP
6 10 (14.93%) Laravel
7 5 (7.46%) Hibernate
7 5 (7.46%) Java EE
7 5 (7.46%) Spring
8 4 (5.97%) .NET Framework
8 4 (5.97%) Entity Framework
8 4 (5.97%) NHibernate
8 4 (5.97%) WCF
8 4 (5.97%) WPF
9 3 (4.48%) MDX
Miscellaneous
1 15 (22.39%) Analytical Skills
2 8 (11.94%) User Experience
3 4 (5.97%) Data Structures
3 4 (5.97%) Marketing Technology
4 3 (4.48%) Video Conferencing
5 2 (2.99%) Computer Science
5 2 (2.99%) Mobile App
6 1 (1.49%) Algorithms
6 1 (1.49%) Life Science
6 1 (1.49%) Management Information System
Operating Systems
1 7 (10.45%) Linux
2 1 (1.49%) Apple iOS
2 1 (1.49%) Windows
2 1 (1.49%) Windows Server
Processes & Methodologies
1 29 (43.28%) MVC
2 22 (32.84%) TDD
3 21 (31.34%) Agile Software Development
4 20 (29.85%) Mentoring
5 15 (22.39%) E-Commerce
6 13 (19.40%) OO
7 12 (17.91%) BDD
7 12 (17.91%) SOLID
8 10 (14.93%) Dependency Management
8 10 (14.93%) OOP
8 10 (14.93%) Test Automation
9 9 (13.43%) Collaborative Working
10 8 (11.94%) Business Intelligence
10 8 (11.94%) DevOps
10 8 (11.94%) ETL
11 7 (10.45%) Mathematics
11 7 (10.45%) Scrum
11 7 (10.45%) Software Engineering
12 6 (8.96%) Microservices
12 6 (8.96%) SOA
Programming Languages
1 21 (31.34%) C#
2 19 (28.36%) JavaScript
3 10 (14.93%) Java
3 10 (14.93%) PHP
3 10 (14.93%) Python
4 9 (13.43%) T-SQL
5 3 (4.48%) Scala
5 3 (4.48%) VBA
6 2 (2.99%) R
7 1 (1.49%) Bash Shell
7 1 (1.49%) PowerShell
Qualifications
1 19 (28.36%) Degree
2 2 (2.99%) ISTQB
2 2 (2.99%) MCDBA
2 2 (2.99%) Microsoft Certification
3 1 (1.49%) Computer Science Degree
3 1 (1.49%) Master's Degree
3 1 (1.49%) Numerate Degree
3 1 (1.49%) PhD
Quality Assurance & Compliance
1 7 (10.45%) Data Quality
2 2 (2.99%) QA
3 1 (1.49%) HL7
3 1 (1.49%) SLA
Systems Management
1 10 (14.93%) Puppet
2 3 (4.48%) Oozie
Vendors
1 9 (13.43%) Microsoft
2 4 (5.97%) Adobe
2 4 (5.97%) Oracle
3 3 (4.48%) Cloudera
3 3 (4.48%) Hortonworks
3 3 (4.48%) Informatica
3 3 (4.48%) Tableau
4 1 (1.49%) IFS
4 1 (1.49%) Netezza
4 1 (1.49%) SAP