Period
to 21 February 2018

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 6 months to 21 February 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Central London > City of London
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 84 57 76
Rank change year-on-year -27 +19 +13
Permanent jobs citing T-SQL 401 500 549
As % of all permanent IT jobs advertised in the City of London 3.74% 4.77% 3.96%
As % of the Programming Languages category 6.40% 8.19% 7.09%
Number of salaries quoted 347 489 515
City of London median annual salary £55,000 £57,500 £55,000
Median salary % change year-on-year -4.35% +4.55% +10.00%
10th Percentile £40,750 £36,250 £36,600
90th Percentile £76,750 £75,000 £75,000
Central London median annual salary £55,000 £55,750 £54,000
% change year-on-year -1.35% +3.24% +8.00%

T-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 the City of London with a requirement for coding skills.

All Programming Languages
City of London
Permanent vacancies with a requirement for coding skills 6,267 6,103 7,746
As % of all permanent IT jobs advertised in the City of London 58.43% 58.23% 55.91%
Number of salaries quoted 5,636 5,602 6,891
City of London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £39,750 £36,250 £36,250
90th Percentile £95,000 £92,500 £87,500
Central London median annual salary £60,000 £60,000 £57,500
% change year-on-year - +4.35% +4.55%

T-SQL
Job Vacancy Trend in the City of London

Job postings citing T-SQL as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for T-SQL in the City of London

T-SQL
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in the City of London.

Salary trend for T-SQL in the City of London

T-SQL
Salary Histogram in the City of London

The salary distribution of IT jobs citing T-SQL in the City of London over the 6 months to 21 February 2018.

Salary histogram for T-SQL in the City of London

T-SQL
Job Locations in the City of London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the City of London region over the 6 months to 21 February 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge +6 1 £52,500 +13.51%
T-SQL
Central London

For the 6 months to 21 February 2018, IT jobs citing T-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 City of London region with a requirement for T-SQL.

1 398 (99.25%) SQL
2 370 (92.27%) SQL Server
3 247 (61.60%) Microsoft
4 221 (55.11%) SQL Server Integration Services
5 215 (53.62%) SQL Server Reporting Services
6 195 (48.63%) C#
7 173 (43.14%) Finance
8 165 (41.15%) .NET
9 151 (37.66%) Business Intelligence
10 133 (33.17%) SQL Server Analysis Services
11 126 (31.42%) Data Warehouse
12 122 (30.42%) ETL
13 104 (25.94%) Agile Software Development
14 103 (25.69%) JavaScript
15 92 (22.94%) ASP.NET
16 82 (20.45%) MVC
17 74 (18.45%) OO
18 71 (17.71%) Windows
19 67 (16.71%) HTML
20 62 (15.46%) Team Foundation Server
21 55 (13.72%) Visual Studio
21 55 (13.72%) Relational Database
22 54 (13.47%) Analytical Skills
22 54 (13.47%) Degree
22 54 (13.47%) SharePoint
23 52 (12.97%) ASP.NET MVC
24 51 (12.72%) AngularJS
24 51 (12.72%) Power BI
25 50 (12.47%) CSS
26 48 (11.97%) Analytics

T-SQL
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 54 (13.47%) SharePoint
2 13 (3.24%) MS Exchange
3 4 (1.00%) IIS
3 4 (1.00%) SAS
3 4 (1.00%) SharePoint 2010
4 3 (0.75%) MS Project Server
4 3 (0.75%) SharePoint Server
5 2 (0.50%) Apache Airflow
5 2 (0.50%) Apache Spark
5 2 (0.50%) Confluence
5 2 (0.50%) Elasticsearch
5 2 (0.50%) Umbraco
6 1 (0.25%) BizTalk Server
6 1 (0.25%) OpenStack
6 1 (0.25%) WordPress
Applications
1 28 (6.98%) Microsoft Excel
2 19 (4.74%) Microsoft Office
3 7 (1.75%) Spreadsheet
4 4 (1.00%) Microsoft PowerPoint
5 1 (0.25%) Microsoft Project
Business Applications
1 9 (2.24%) MetaTrader
2 6 (1.50%) Dynamics CRM
3 3 (0.75%) Elite 3E
4 1 (0.25%) Cognos Business Intelligence
4 1 (0.25%) Markit EDM
4 1 (0.25%) RMDS
Cloud Services
1 48 (11.97%) Microsoft Azure
2 23 (5.74%) Office 365
3 10 (2.49%) Amazon AWS
4 8 (2.00%) SaaS
5 7 (1.75%) Azure Active Directory
6 6 (1.50%) Azure Data Factory
6 6 (1.50%) Azure Machine Learning
6 6 (1.50%) IaaS
7 4 (1.00%) GitHub
8 3 (0.75%) Cortana Intelligence Suite
8 3 (0.75%) PaaS
9 2 (0.50%) Datadog
9 2 (0.50%) Trello
10 1 (0.25%) Google Cloud Platform
Communications & Networking
1 17 (4.24%) Firewall
2 11 (2.74%) DNS
2 11 (2.74%) Internet
2 11 (2.74%) SSL
3 6 (1.50%) WAN
4 2 (0.50%) Network Security
Database & Business Intelligence
1 370 (92.27%) SQL Server
2 221 (55.11%) SQL Server Integration Services
3 215 (53.62%) SQL Server Reporting Services
4 133 (33.17%) SQL Server Analysis Services
5 126 (31.42%) Data Warehouse
6 55 (13.72%) Relational Database
7 51 (12.72%) Power BI
8 43 (10.72%) SQL Server 2008
9 35 (8.73%) Crystal Reports
10 31 (7.73%) SQL Server 2012
11 30 (7.48%) SQL Server 2016
12 27 (6.73%) QlikView
13 24 (5.99%) BusinessObjects
14 22 (5.49%) RDBMS
15 17 (4.24%) NoSQL
16 16 (3.99%) Big Data
17 15 (3.74%) OLAP
18 13 (3.24%) MySQL
19 10 (2.49%) Hadoop
19 10 (2.49%) SQL Server 2000
Development Applications
1 62 (15.46%) Team Foundation Server
2 55 (13.72%) Visual Studio
3 41 (10.22%) SQL Server Management Studio (SSMS)
4 24 (5.99%) JIRA
5 19 (4.74%) VSS/SourceSafe
6 17 (4.24%) Git (software)
7 15 (3.74%) Subversion
8 13 (3.24%) RStudio
9 9 (2.24%) Eclipse
9 9 (2.24%) Octopus Deploy
9 9 (2.24%) TeamCity
9 9 (2.24%) Visual Studio Team System
10 7 (1.75%) Mercurial
11 6 (1.50%) InstallShield
12 4 (1.00%) NUnit
13 3 (0.75%) Bitbucket
14 2 (0.50%) Maven
14 2 (0.50%) MSTest
14 2 (0.50%) NuGet
14 2 (0.50%) Rhino Mocks
General
1 173 (43.14%) Finance
2 40 (9.98%) Banking
3 20 (4.99%) Back Office
4 17 (4.24%) Financial Institution
5 16 (3.99%) Investment Banking
6 14 (3.49%) Advertising
7 11 (2.74%) Law
7 11 (2.74%) Telecoms
8 8 (2.00%) Front Office
9 7 (1.75%) Retail
10 6 (1.50%) Legal
11 4 (1.00%) Automotive
12 3 (0.75%) Marketing
13 2 (0.50%) Games
14 1 (0.25%) International Banking
Job Titles
1 244 (60.85%) Developer
2 136 (33.92%) SQL Developer
3 86 (21.45%) C# Developer
4 74 (18.45%) Analyst
5 65 (16.21%) SSIS Developer
6 63 (15.71%) .NET Developer
7 60 (14.96%) Business Intelligence Developer
8 51 (12.72%) C# .NET Developer
9 47 (11.72%) SSRS Developer
10 44 (10.97%) SQL Analyst
10 44 (10.97%) SQL Server Developer
11 39 (9.73%) T-SQL Developer
12 36 (8.98%) SSAS Developer
13 32 (7.98%) ASP.NET MVC Developer
14 30 (7.48%) Senior Developer
15 29 (7.23%) Analyst Developer
15 29 (7.23%) SQL BI Developer
16 26 (6.48%) Systems Analyst
17 24 (5.99%) Business Intelligence Lead
17 24 (5.99%) ETL Developer
Libraries, Frameworks & Software Standards
1 165 (41.15%) .NET
2 92 (22.94%) ASP.NET
3 67 (16.71%) HTML
4 52 (12.97%) ASP.NET MVC
5 51 (12.72%) AngularJS
6 50 (12.47%) CSS
7 38 (9.48%) .NET Framework
7 38 (9.48%) ASP.NET Web API
8 28 (6.98%) WPF
9 27 (6.73%) Ajax
9 27 (6.73%) jQuery
9 27 (6.73%) WCF
9 27 (6.73%) XML
10 26 (6.48%) Angular 2
10 26 (6.48%) HTML5
11 24 (5.99%) ASP.NET Web Forms
12 20 (4.99%) Entity Framework
13 18 (4.49%) REST
14 15 (3.74%) CSS3
14 15 (3.74%) Twitter Bootstrap
Miscellaneous
1 54 (13.47%) Analytical Skills
2 39 (9.73%) Computer Science
3 34 (8.48%) User Experience
4 33 (8.23%) Data Structures
5 24 (5.99%) Foreign Exchange (FX)
5 24 (5.99%) Greenfield Project
6 16 (3.99%) Equities
7 14 (3.49%) Algorithms
7 14 (3.49%) Replication
8 11 (2.74%) Management Information System
8 11 (2.74%) Public Cloud
8 11 (2.74%) Reinsurance
9 7 (1.75%) Fintech
10 6 (1.50%) Enterprise Cloud
11 5 (1.25%) Virtual Team
12 4 (1.00%) Client/Server
12 4 (1.00%) e-Learning
12 4 (1.00%) Fixed Income
12 4 (1.00%) SCORM
13 3 (0.75%) Derivative
Operating Systems
1 71 (17.71%) Windows
2 17 (4.24%) Unix
2 17 (4.24%) Windows Server
3 13 (3.24%) Linux
4 7 (1.75%) Windows Server 2008
5 6 (1.50%) Windows 10
5 6 (1.50%) Windows 7
6 5 (1.25%) Windows Server 2012
7 1 (0.25%) HPUX
Processes & Methodologies
1 151 (37.66%) Business Intelligence
2 122 (30.42%) ETL
3 104 (25.94%) Agile Software Development
4 82 (20.45%) MVC
5 74 (18.45%) OO
6 48 (11.97%) Analytics
7 43 (10.72%) DevOps
8 40 (9.98%) Mathematics
9 38 (9.48%) OOP
10 35 (8.73%) Investment Management
11 33 (8.23%) OOD
12 30 (7.48%) Performance Tuning
12 30 (7.48%) Software Engineering
13 29 (7.23%) Data Modelling
13 29 (7.23%) TDD
14 28 (6.98%) Continuous Integration
14 28 (6.98%) Defect Management
14 28 (6.98%) Test Automation
15 23 (5.74%) Scrum
15 23 (5.74%) SDLC
Programming Languages
1 398 (99.25%) SQL
2 195 (48.63%) C#
3 103 (25.69%) JavaScript
4 36 (8.98%) VB
5 30 (7.48%) Python
6 24 (5.99%) VBA
7 23 (5.74%) PowerShell
8 22 (5.49%) R
9 16 (3.99%) Shell Script
10 13 (3.24%) C++
10 13 (3.24%) PL/SQL
11 12 (2.99%) Data Analysis Expressions (DAX)
12 11 (2.74%) VB.NET
13 9 (2.24%) Java
13 9 (2.24%) VB6
14 5 (1.25%) F#
15 4 (1.00%) Perl
15 4 (1.00%) Scala
16 2 (0.50%) C
16 2 (0.50%) Ruby
Qualifications
1 54 (13.47%) Degree
2 4 (1.00%) Computer Science Degree
3 3 (0.75%) SC Cleared
3 3 (0.75%) Security Cleared
4 2 (0.50%) MCSE
4 2 (0.50%) Microsoft Certification
4 2 (0.50%) PhD
5 1 (0.25%) Master's Degree
5 1 (0.25%) PRINCE2 Certification
Quality Assurance & Compliance
1 31 (7.73%) QA
2 11 (2.74%) Data Quality
3 3 (0.75%) Solvency II
4 1 (0.25%) Basel II
4 1 (0.25%) Basel III
4 1 (0.25%) PCI DSS
4 1 (0.25%) UCITS
System Software
1 26 (6.48%) Active Directory
2 17 (4.24%) VMware Infrastructure
3 11 (2.74%) Docker
3 11 (2.74%) VMware Workstation
4 9 (2.24%) HDFS
5 6 (1.50%) Hyper-V
6 2 (0.50%) Virtual Machines
Systems Management
1 7 (1.75%) Opscode Chef
1 7 (1.75%) Puppet
2 6 (1.50%) SCCM
3 3 (0.75%) Ansible
3 3 (0.75%) Kubernetes
4 2 (0.50%) Failover Clustering
4 2 (0.50%) Hadoop YARN
4 2 (0.50%) Kibana
4 2 (0.50%) logstash
4 2 (0.50%) Oozie
4 2 (0.50%) SCOM
5 1 (0.25%) Docker Swarm
5 1 (0.25%) Mesos
5 1 (0.25%) Perfmon
Vendors
1 247 (61.60%) Microsoft
2 22 (5.49%) Tableau
3 21 (5.24%) Sybase
4 17 (4.24%) Cognos
4 17 (4.24%) VMware
5 10 (2.49%) Infragistics
6 8 (2.00%) MicroStrategy
7 7 (1.75%) Alteryx
8 6 (1.50%) Citrix
8 6 (1.50%) Oracle
9 5 (1.25%) IBM
9 5 (1.25%) PeopleSoft
9 5 (1.25%) Salesforce.com
10 3 (0.75%) Aderant
11 2 (0.50%) AppDynamics
11 2 (0.50%) Fidessa
11 2 (0.50%) RedGate
11 2 (0.50%) Sitecore
11 2 (0.50%) Splunk
12 1 (0.25%) TIBCO