Period
to 29 September 2020

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

Transact-SQL
Central London > City of London
6 months to
29 Sep 2020
Same period 2019 Same period 2018
Rank 129 85 48
Rank change year-on-year -44 -37 0
Permanent jobs citing T-SQL 65 372 580
As % of all permanent jobs advertised in the City of London 1.74% 3.73% 5.28%
As % of the Programming Languages category 2.83% 6.18% 8.55%
Number of salaries quoted 68 368 541
Median annual salary £57,500 £62,500 £62,500
Median salary % change year-on-year -8.00% - +8.70%
10th Percentile £37,772 £43,750 £41,250
90th Percentile £82,500 £77,500 £78,750
Central London median annual salary £62,500 £60,000 £60,000
% change year-on-year +4.17% - +4.35%

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 2,295 6,022 6,784
As % of all permanent IT jobs advertised in the City of London 61.41% 60.35% 61.75%
Number of salaries quoted 2,018 5,309 6,183
Median annual salary £70,000 £70,000 £65,000
Median salary % change year-on-year - +7.69% +8.33%
10th Percentile £45,000 £42,500 £41,250
90th Percentile £108,750 £97,500 £95,000
Central London median annual salary £70,000 £67,500 £65,000
% change year-on-year +3.70% +3.85% +8.33%

T-SQL
Job Vacancy Trend in the City of London

Job postings citing T-SQL as a proportion 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

3-month moving average salary quoted in 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

Salary distribution for jobs citing T-SQL in the City of London over the 6 months to 29 September 2020.

Salary histogram for T-SQL in the City of London

For the 6 months to 29 September 2020, 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 63 (96.92%) SQL
2 43 (66.15%) SQL Server
3 34 (52.31%) Microsoft
3 34 (52.31%) SQL Server Integration Services
4 30 (46.15%) .NET
5 28 (43.08%) Finance
6 25 (38.46%) C#
7 23 (35.38%) Business Intelligence
7 23 (35.38%) Azure
7 23 (35.38%) Power BI
7 23 (35.38%) Power Platform
8 20 (30.77%) Agile Software Development
9 18 (27.69%) SQL Server Reporting Services
10 17 (26.15%) JavaScript
11 16 (24.62%) Windows
11 16 (24.62%) Data Warehouse
12 15 (23.08%) Web Services
13 14 (21.54%) HTML
13 14 (21.54%) SQL Server Analysis Services
13 14 (21.54%) DevOps
14 13 (20.00%) AWS
14 13 (20.00%) Disaster Recovery
14 13 (20.00%) ASP.NET
15 12 (18.46%) IIS
15 12 (18.46%) Git (software)
16 11 (16.92%) CSS
16 11 (16.92%) Fintech
16 11 (16.92%) Analytical Skills
17 10 (15.38%) Windows Server
17 10 (15.38%) Python

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 12 (18.46%) IIS
2 4 (6.15%) Tomcat
3 3 (4.62%) Confluence
3 3 (4.62%) Elasticsearch
4 2 (3.08%) Apache Spark
4 2 (3.08%) SharePoint
Applications
1 6 (9.23%) Microsoft Office
2 4 (6.15%) Microsoft Excel
Business Applications
1 4 (6.15%) FastStats
1 4 (6.15%) Unica
2 2 (3.08%) Dynamics CRM
2 2 (3.08%) iTrent
2 2 (3.08%) Northgate Housing
2 2 (3.08%) Oracle Applications
Cloud Services
1 23 (35.38%) Azure
1 23 (35.38%) Power Platform
2 13 (20.00%) AWS
3 6 (9.23%) Azure Active Directory
4 4 (6.15%) Office 365
4 4 (6.15%) SaaS
5 3 (4.62%) AWS Lambda
5 3 (4.62%) Serverless
6 2 (3.08%) Amazon ElastiCache
6 2 (3.08%) Amazon EMR
6 2 (3.08%) Amazon Kinesis
6 2 (3.08%) Amazon S3
6 2 (3.08%) Azure Data Factory
6 2 (3.08%) Logic Apps
7 1 (1.54%) IaaS
7 1 (1.54%) npm
7 1 (1.54%) NuGet
7 1 (1.54%) PaaS
Communications & Networking
1 4 (6.15%) Cisco ASA
1 4 (6.15%) Cisco Firepower
1 4 (6.15%) Cisco IOS
1 4 (6.15%) Cisco Nexus
1 4 (6.15%) DHCP
1 4 (6.15%) DNS
1 4 (6.15%) VLAN
1 4 (6.15%) VoIP
1 4 (6.15%) VPN
2 1 (1.54%) WebEx
Database & Business Intelligence
1 43 (66.15%) SQL Server
2 34 (52.31%) SQL Server Integration Services
3 23 (35.38%) Power BI
4 18 (27.69%) SQL Server Reporting Services
5 16 (24.62%) Data Warehouse
6 14 (21.54%) SQL Server Analysis Services
7 8 (12.31%) Big Data
7 8 (12.31%) SQL Server 2012
8 7 (10.77%) Data Lake
9 6 (9.23%) MongoDB
10 2 (3.08%) Amazon DynamoDB
10 2 (3.08%) Apache Hive
10 2 (3.08%) Cosmos DB
10 2 (3.08%) Hadoop
10 2 (3.08%) HBase
10 2 (3.08%) Oracle Reports
10 2 (3.08%) Redis
10 2 (3.08%) SQL Server 2016
10 2 (3.08%) SQL Server 2017
10 2 (3.08%) Sqoop
Development Applications
1 12 (18.46%) Git (software)
2 4 (6.15%) Subversion
2 4 (6.15%) Team Foundation Server
3 3 (4.62%) Bitbucket
3 3 (4.62%) git-flow
3 3 (4.62%) JIRA
3 3 (4.62%) SQL Server Management Studio (SSMS)
4 2 (3.08%) Visual Studio
5 1 (1.54%) GitLab
5 1 (1.54%) Visual Studio Tools for Office
General
1 28 (43.08%) Finance
2 4 (6.15%) Marketing
2 4 (6.15%) Telecoms
3 3 (4.62%) Banking
3 3 (4.62%) Investment Banking
4 2 (3.08%) Advertising
4 2 (3.08%) Front Office
4 2 (3.08%) Law
4 2 (3.08%) Legal
4 2 (3.08%) Social Housing
5 1 (1.54%) Retail
Job Titles
1 38 (58.46%) Developer
2 17 (26.15%) Senior Developer
3 14 (21.54%) .NET Developer
4 9 (13.85%) Analyst
5 7 (10.77%) Applications Support
5 7 (10.77%) Business Intelligence Developer
5 7 (10.77%) C# Developer
5 7 (10.77%) Senior .NET Developer
6 6 (9.23%) Applications Specialist
6 6 (9.23%) Applications Support Specialist
6 6 (9.23%) C# .NET Developer
6 6 (9.23%) Data Warehouse Developer
6 6 (9.23%) SQL Developer
6 6 (9.23%) Support Specialist
7 5 (7.69%) Senior Business Intelligence Developer
7 5 (7.69%) Web Developer
8 4 (6.15%) Full Stack Developer
8 4 (6.15%) Senior C# .NET Developer
8 4 (6.15%) SQL DBA
8 4 (6.15%) SSIS Developer
Libraries, Frameworks & Software Standards
1 30 (46.15%) .NET
2 15 (23.08%) Web Services
3 14 (21.54%) HTML
4 13 (20.00%) ASP.NET
5 11 (16.92%) CSS
6 9 (13.85%) .NET Core
6 9 (13.85%) ASP.NET Web API
6 9 (13.85%) HTML5
7 8 (12.31%) AngularJS
7 8 (12.31%) jQuery
8 7 (10.77%) .NET Framework
8 7 (10.77%) MDX
8 7 (10.77%) XML
9 6 (9.23%) React
10 5 (7.69%) Node.js
11 4 (6.15%) ASP.NET Web Forms
11 4 (6.15%) JSON
11 4 (6.15%) REST
12 3 (4.62%) CSS3
12 3 (4.62%) WCF
Miscellaneous
1 11 (16.92%) Analytical Skills
2 8 (12.31%) Replication
3 5 (7.69%) Enterprise Software
4 4 (6.15%) Data Structures
4 4 (6.15%) EFT
4 4 (6.15%) Management Information System
5 3 (4.62%) Clustering
5 3 (4.62%) Mobile App
6 2 (3.08%) Data Centre
6 2 (3.08%) Greenfield Project
6 2 (3.08%) Self-Motivation
7 1 (1.54%) Client/Server
7 1 (1.54%) Derivative
7 1 (1.54%) Hedge funds
7 1 (1.54%) Reinsurance
7 1 (1.54%) Video Conferencing
Operating Systems
1 16 (24.62%) Windows
2 10 (15.38%) Windows Server
3 5 (7.69%) Linux
4 4 (6.15%) Windows Server 2012
5 1 (1.54%) Oracle Linux
5 1 (1.54%) Unix
Processes & Methodologies
1 23 (35.38%) Business Intelligence
2 20 (30.77%) Agile Software Development
3 14 (21.54%) DevOps
4 13 (20.00%) Disaster Recovery
5 11 (16.92%) Fintech
6 10 (15.38%) Continuous Integration
6 10 (15.38%) Stakeholder Management
7 9 (13.85%) Analytics
7 9 (13.85%) Business Analysis
7 9 (13.85%) SDLC
8 8 (12.31%) CRM
8 8 (12.31%) Dimensional Modelling
8 8 (12.31%) MVC
9 7 (10.77%) Change Control
9 7 (10.77%) Computer Science
9 7 (10.77%) Data Modelling
9 7 (10.77%) ETL
9 7 (10.77%) Kimball Methodology
10 6 (9.23%) Data Protection
10 6 (9.23%) Web Development
Programming Languages
1 63 (96.92%) SQL
2 25 (38.46%) C#
3 17 (26.15%) JavaScript
4 10 (15.38%) Python
5 5 (7.69%) PowerShell
6 4 (6.15%) PL/SQL
7 3 (4.62%) TypeScript
7 3 (4.62%) VB.NET
7 3 (4.62%) VBA
8 2 (3.08%) R
9 1 (1.54%) Bash Shell
9 1 (1.54%) Data Analysis Expressions (DAX)
9 1 (1.54%) VBScript
9 1 (1.54%) XAML
Qualifications
1 5 (7.69%) Degree
2 3 (4.62%) Computer Science Degree
3 2 (3.08%) ITIL Foundation Certificate
4 1 (1.54%) Numerate Degree
Quality Assurance & Compliance
1 2 (3.08%) SLA
2 1 (1.54%) ISO/IEC 27001
2 1 (1.54%) QA
System Software
1 6 (9.23%) Active Directory
2 5 (7.69%) Docker
3 4 (6.15%) Hyper-V
4 1 (1.54%) Cronacle
4 1 (1.54%) Tivoli Workload Scheduler
Systems Management
1 4 (6.15%) Backup Exec
1 4 (6.15%) Symantec Endpoint Protection
2 1 (1.54%) Microsoft Clustering
2 1 (1.54%) Tivoli
Vendors
1 34 (52.31%) Microsoft
2 9 (13.85%) Oracle
3 4 (6.15%) Apteco
3 4 (6.15%) Cisco
3 4 (6.15%) Dell
3 4 (6.15%) IBM
3 4 (6.15%) Symantec
3 4 (6.15%) Veritas
4 3 (4.62%) Atlassian
5 2 (3.08%) Databricks
5 2 (3.08%) Northgate
5 2 (3.08%) Tableau
5 2 (3.08%) Yardi
6 1 (1.54%) SAP