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

Transact-SQL
Central London > City of London
6 months to
19 Jun 2018
Same period 2017 Same period 2016
Rank 65 44 88
Rank change year-on-year -21 +44 -13
Permanent jobs citing T-SQL 512 561 492
As % of all permanent IT jobs advertised in the City of London 4.64% 5.54% 3.68%
As % of the Programming Languages category 7.64% 9.75% 6.52%
Number of salaries quoted 467 531 465
City of London median annual salary £62,500 £60,000 £53,500
Median salary % change year-on-year +4.17% +12.15% +7.00%
10th Percentile £42,500 £40,750 £35,200
90th Percentile £80,000 £77,500 £75,000
Central London median annual salary £60,000 £59,500 £52,500
% change year-on-year +0.84% +13.33% +5.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,700 5,753 7,546
As % of all permanent IT jobs advertised in the City of London 60.73% 56.79% 56.38%
Number of salaries quoted 6,034 5,197 6,824
City of London median annual salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.35% +4.55%
10th Percentile £40,000 £37,375 £36,750
90th Percentile £95,000 £95,000 £86,250
Central London median annual salary £62,500 £60,000 £57,000
% change year-on-year +4.17% +5.26% +3.64%

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 19 June 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 19 June 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 +9 12 £45,000 -10.00%
T-SQL
Central London

For the 6 months to 19 June 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 505 (98.63%) SQL
2 452 (88.28%) SQL Server
3 300 (58.59%) Microsoft
4 281 (54.88%) SQL Server Integration Services
5 278 (54.30%) SQL Server Reporting Services
6 254 (49.61%) Finance
7 221 (43.16%) C#
8 205 (40.04%) Business Intelligence
9 198 (38.67%) Agile Software Development
10 197 (38.48%) .NET
11 190 (37.11%) Data Warehouse
12 161 (31.45%) SQL Server Analysis Services
13 125 (24.41%) ETL
14 120 (23.44%) MVC
15 114 (22.27%) Power BI
16 105 (20.51%) Degree
17 96 (18.75%) JavaScript
18 92 (17.97%) Analytical Skills
19 91 (17.77%) ASP.NET Web API
20 90 (17.58%) Microsoft Azure
21 88 (17.19%) Team Foundation Server
22 78 (15.23%) Entity Framework
23 77 (15.04%) ASP.NET
24 75 (14.65%) SQL Server 2008
25 74 (14.45%) Continuous Integration
25 74 (14.45%) CSS
26 71 (13.87%) Problem-Solving
27 69 (13.48%) SDLC
27 69 (13.48%) Test Automation
28 68 (13.28%) .NET Framework

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 58 (11.33%) SharePoint
2 10 (1.95%) IIS
3 6 (1.17%) Apache Spark
3 6 (1.17%) SAS
4 4 (0.78%) Confluence
5 3 (0.59%) Elasticsearch
5 3 (0.59%) Oracle Workflow
6 2 (0.39%) Exchange Server 2013
6 2 (0.39%) NServiceBus
6 2 (0.39%) SharePoint 2013
6 2 (0.39%) Umbraco
7 1 (0.20%) Apache Airflow
7 1 (0.20%) CMS
7 1 (0.20%) MS Exchange
7 1 (0.20%) OpenStack
7 1 (0.20%) R Markdown
7 1 (0.20%) SharePoint 2010
7 1 (0.20%) SharePoint Server
7 1 (0.20%) WordPress
Applications
1 68 (13.28%) Microsoft Excel
2 15 (2.93%) Microsoft PowerPoint
3 14 (2.73%) Microsoft Office
4 9 (1.76%) Spreadsheet
5 1 (0.20%) Adobe Illustrator
5 1 (0.20%) MS Visio
5 1 (0.20%) Photoshop
Business Applications
1 27 (5.27%) Dynamics CRM
2 8 (1.56%) Salesforce.com CRM
3 4 (0.78%) Markit EDM
4 3 (0.59%) Elite 3E
4 3 (0.59%) MetaTrader
5 2 (0.39%) SunGard GMI
6 1 (0.20%) Endur
Cloud Services
1 90 (17.58%) Microsoft Azure
2 29 (5.66%) Amazon AWS
3 24 (4.69%) IaaS
4 22 (4.30%) Azure Active Directory
5 8 (1.56%) Office 365
6 4 (0.78%) GitHub
7 3 (0.59%) Cloud Computing
8 2 (0.39%) Azure Data Factory
8 2 (0.39%) Google Analytics
8 2 (0.39%) Trello
9 1 (0.20%) Data Lake Analytics
9 1 (0.20%) Dynamics 365
9 1 (0.20%) Google Cloud Platform
9 1 (0.20%) npm
9 1 (0.20%) SaaS
Communications & Networking
1 9 (1.76%) Firewall
1 9 (1.76%) WAN
2 3 (0.59%) SSL
3 2 (0.39%) DMVPN
3 2 (0.39%) EIGRP
3 2 (0.39%) Extranet
3 2 (0.39%) Internet
3 2 (0.39%) Intranet
3 2 (0.39%) MPLS
3 2 (0.39%) SMS
3 2 (0.39%) Unified Communications
4 1 (0.20%) DNS
4 1 (0.20%) Network Security
Database & Business Intelligence
1 452 (88.28%) SQL Server
2 281 (54.88%) SQL Server Integration Services
3 278 (54.30%) SQL Server Reporting Services
4 190 (37.11%) Data Warehouse
5 161 (31.45%) SQL Server Analysis Services
6 114 (22.27%) Power BI
7 75 (14.65%) SQL Server 2008
8 55 (10.74%) Big Data
9 47 (9.18%) SQL Server 2012
10 41 (8.01%) SQL Server 2016
11 38 (7.42%) Data Lake
12 29 (5.66%) Relational Database
13 22 (4.30%) BusinessObjects
13 22 (4.30%) SQL Server 2014
14 18 (3.52%) Azure SQL Database
14 18 (3.52%) MS Access
15 17 (3.32%) Crystal Reports
15 17 (3.32%) Hadoop
15 17 (3.32%) OLAP
16 15 (2.93%) NoSQL
Development Applications
1 88 (17.19%) Team Foundation Server
2 59 (11.52%) Visual Studio
3 35 (6.84%) Visual Studio Team System
4 29 (5.66%) Git (software)
5 25 (4.88%) Jenkins
5 25 (4.88%) SQL Server Management Studio (SSMS)
6 22 (4.30%) Subversion
7 19 (3.71%) JIRA
8 16 (3.13%) CruiseControl
8 16 (3.13%) MSBuild
9 15 (2.93%) Octopus Deploy
9 15 (2.93%) TeamCity
10 9 (1.76%) NUnit
10 9 (1.76%) VSS/SourceSafe
11 8 (1.56%) Maven
12 7 (1.37%) Ant
13 6 (1.17%) Eclipse
13 6 (1.17%) Jasmine
13 6 (1.17%) Selenium
14 4 (0.78%) SpecFlow
General
1 254 (49.61%) Finance
2 34 (6.64%) Banking
3 23 (4.49%) Front Office
4 17 (3.32%) Marketing
5 14 (2.73%) Back Office
6 11 (2.15%) Retail
7 8 (1.56%) Advertising
7 8 (1.56%) Law
7 8 (1.56%) Legal
8 7 (1.37%) Financial Institution
9 4 (0.78%) General Ledger
10 3 (0.59%) Automotive
10 3 (0.59%) Investment Banking
11 2 (0.39%) Telecoms
Job Titles
1 306 (59.77%) Developer
2 133 (25.98%) SQL Developer
3 103 (20.12%) Business Intelligence Developer
4 98 (19.14%) .NET Developer
5 97 (18.95%) Analyst
6 82 (16.02%) C# Developer
7 64 (12.50%) SSIS Developer
8 61 (11.91%) C# .NET Developer
9 56 (10.94%) SQL BI Developer
10 51 (9.96%) SSRS Developer
11 43 (8.40%) SQL Server Developer
12 42 (8.20%) Architect
13 41 (8.01%) Senior Developer
14 39 (7.62%) T-SQL Developer
15 36 (7.03%) SSAS Developer
16 35 (6.84%) Data Warehouse Developer
16 35 (6.84%) Microsoft Developer
17 33 (6.45%) SQL Analyst
18 27 (5.27%) Power BI Developer
19 26 (5.08%) Analyst Developer
Libraries, Frameworks & Software Standards
1 197 (38.48%) .NET
2 91 (17.77%) ASP.NET Web API
3 78 (15.23%) Entity Framework
4 77 (15.04%) ASP.NET
5 74 (14.45%) CSS
6 68 (13.28%) .NET Framework
7 64 (12.50%) AngularJS
8 62 (12.11%) HTML
9 60 (11.72%) Twitter Bootstrap
10 59 (11.52%) WCF
11 58 (11.33%) Web Services
12 57 (11.13%) jQuery
13 54 (10.55%) ASP.NET MVC
14 37 (7.23%) .NET Core
15 31 (6.05%) XML
16 27 (5.27%) React
17 22 (4.30%) WinForms
18 20 (3.91%) RESTful
19 19 (3.71%) HTML5
19 19 (3.71%) WPF
Miscellaneous
1 92 (17.97%) Analytical Skills
2 57 (11.13%) Computer Science
3 43 (8.40%) User Experience
4 28 (5.47%) Management Information System
4 28 (5.47%) N-Tier
5 27 (5.27%) Data Structures
6 23 (4.49%) Greenfield Project
7 16 (3.13%) Replication
8 13 (2.54%) Equities
8 13 (2.54%) Fintech
8 13 (2.54%) Foreign Exchange (FX)
9 12 (2.34%) Derivative
10 10 (1.95%) Enterprise Software
11 9 (1.76%) Reinsurance
12 8 (1.56%) Virtual Team
13 7 (1.37%) Enterprise Cloud
14 6 (1.17%) Client/Server
14 6 (1.17%) Self-Motivation
15 5 (0.98%) Spread Betting
15 5 (0.98%) Tandem
Operating Systems
1 62 (12.11%) Windows
2 16 (3.13%) VMS
3 8 (1.56%) Linux
4 7 (1.37%) Windows 10
4 7 (1.37%) Windows 7
5 6 (1.17%) Windows Server 2012
6 5 (0.98%) Windows Server 2008
7 4 (0.78%) Unix
8 2 (0.39%) Windows Server
9 1 (0.20%) Android
9 1 (0.20%) Red Hat Enterprise Linux
9 1 (0.20%) Windows Embedded Compact
Processes & Methodologies
1 205 (40.04%) Business Intelligence
2 198 (38.67%) Agile Software Development
3 125 (24.41%) ETL
4 120 (23.44%) MVC
5 74 (14.45%) Continuous Integration
6 71 (13.87%) Problem-Solving
7 69 (13.48%) SDLC
7 69 (13.48%) Test Automation
8 67 (13.09%) Scrum
9 63 (12.30%) OO
10 58 (11.33%) Mentoring
11 55 (10.74%) SOA
11 55 (10.74%) Software Engineering
12 53 (10.35%) DevOps
13 49 (9.57%) Analytics
14 47 (9.18%) Data Modelling
15 46 (8.98%) Microservices
15 46 (8.98%) Waterfall
15 46 (8.98%) Web Development
16 45 (8.79%) CRM
Programming Languages
1 505 (98.63%) SQL
2 221 (43.16%) C#
3 96 (18.75%) JavaScript
4 42 (8.20%) PowerShell
5 32 (6.25%) VBA
6 23 (4.49%) PL/SQL
6 23 (4.49%) VB
7 22 (4.30%) Java
8 21 (4.10%) Python
9 10 (1.95%) R
10 8 (1.56%) Perl
10 8 (1.56%) VB.NET
11 7 (1.37%) Bash Shell
11 7 (1.37%) Scala
11 7 (1.37%) Shell Script
11 7 (1.37%) XPath
12 6 (1.17%) Data Analysis Expressions (DAX)
12 6 (1.17%) Ruby
12 6 (1.17%) TypeScript
12 6 (1.17%) VB6
Qualifications
1 105 (20.51%) Degree
2 31 (6.05%) Computer Science Degree
3 13 (2.54%) Microsoft Certification
4 9 (1.76%) MCITP
4 9 (1.76%) Microsoft Certified Architect
5 7 (1.37%) ISEB
5 7 (1.37%) ISTQB
6 3 (0.59%) Master's Degree
6 3 (0.59%) SC Cleared
6 3 (0.59%) Security Cleared
7 2 (0.39%) CCNA
7 2 (0.39%) CCNP
7 2 (0.39%) CCVP
7 2 (0.39%) Cisco Certification
8 1 (0.20%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 42 (8.20%) QA
2 7 (1.37%) Data Quality
3 5 (0.98%) MiFID
4 4 (0.78%) Solvency II
5 3 (0.59%) EMIR
5 3 (0.59%) FATCA
5 3 (0.59%) GDPR
6 2 (0.39%) PCI DSS
7 1 (0.20%) SLA
System Software
1 28 (5.47%) Active Directory
2 10 (1.95%) Docker
3 8 (1.56%) Hyper-V
3 8 (1.56%) VMware Infrastructure
4 5 (0.98%) HDFS
5 3 (0.59%) Tivoli Workload Scheduler
6 2 (0.39%) Virtual Machines
Systems Management
1 9 (1.76%) Opscode Chef
1 9 (1.76%) Puppet
2 8 (1.56%) Ansible
3 5 (0.98%) Oozie
4 4 (0.78%) Failover Clustering
5 3 (0.59%) Tivoli
6 2 (0.39%) Kubernetes
7 1 (0.20%) Docker Swarm
7 1 (0.20%) Hadoop YARN
7 1 (0.20%) Mesos
Vendors
1 300 (58.59%) Microsoft
2 34 (6.64%) Oracle
3 28 (5.47%) Tableau
4 23 (4.49%) Nintex
5 19 (3.71%) Cognos
5 19 (3.71%) Salesforce.com
6 16 (3.13%) Informatica
7 13 (2.54%) MicroStrategy
8 8 (1.56%) Citrix
8 8 (1.56%) IBM
8 8 (1.56%) Perforce
8 8 (1.56%) VMware
9 7 (1.37%) Sybase
10 6 (1.17%) Fidessa
10 6 (1.17%) PeopleSoft
11 5 (0.98%) FIS
11 5 (0.98%) SAP
11 5 (0.98%) SmartStream
12 4 (0.78%) Infragistics
13 3 (0.59%) Aderant