Period
to 20 November 2017

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

Transact-SQL
Central London > City of London
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 60 71 71
Rank change year-on-year +11 0 +10
Permanent jobs citing T-SQL 453 492 704
As % of all permanent IT jobs advertised in the City of London 4.44% 4.27% 4.11%
As % of the Programming Languages category 7.80% 7.32% 7.47%
Number of salaries quoted 415 475 646
City of London median annual salary £57,500 £55,000 £55,000
Median salary % change year-on-year +4.55% - +10.00%
10th Percentile £42,500 £37,500 £34,125
90th Percentile £75,000 £75,000 £75,000
Central London median annual salary £55,000 £55,000 £55,000

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 5807 6723 9421
As % of all permanent IT jobs advertised in the City of London 56.89% 58.30% 54.97%
Number of salaries quoted 5328 6205 8309
City of London median annual salary £60,500 £58,000 £57,500
Median salary % change year-on-year +4.31% +0.87% +4.55%
10th Percentile £37,500 £37,500 £35,000
90th Percentile £95,000 £90,000 £86,500
Central London median annual salary £60,000 £57,500 £55,000
% 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 20 November 2017.

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 20 November 2017. 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 +12 2 £52,500 +23.53%
T-SQL
Central London

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

1 447 (98.68%) SQL
2 417 (92.05%) SQL Server
3 265 (58.50%) Microsoft
4 234 (51.66%) SQL Server Integration Services
5 209 (46.14%) SQL Server Reporting Services
6 199 (43.93%) C#
7 177 (39.07%) .NET
8 175 (38.63%) Finance
9 154 (34.00%) Business Intelligence
10 148 (32.67%) ETL
11 131 (28.92%) Data Warehouse
12 124 (27.37%) SQL Server Analysis Services
13 112 (24.72%) Agile Software Development
14 109 (24.06%) JavaScript
15 97 (21.41%) HTML
16 96 (21.19%) ASP.NET
16 96 (21.19%) MVC
17 89 (19.65%) Windows
18 84 (18.54%) CSS
19 83 (18.32%) Relational Database
20 74 (16.34%) Degree
21 69 (15.23%) Team Foundation Server
22 62 (13.69%) ASP.NET MVC
23 60 (13.25%) AngularJS
23 60 (13.25%) Visual Studio
24 59 (13.02%) OO
25 58 (12.80%) .NET Framework
26 56 (12.36%) SQL Server Management Studio (SSMS)
27 55 (12.14%) jQuery
28 54 (11.92%) SharePoint

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 (11.92%) SharePoint
2 11 (2.43%) MS Exchange
3 10 (2.21%) IIS
3 10 (2.21%) SharePoint 2013
4 9 (1.99%) SharePoint 2010
4 9 (1.99%) WordPress
5 3 (0.66%) Elasticsearch
5 3 (0.66%) MS Project Server
5 3 (0.66%) SAS
5 3 (0.66%) SharePoint Server
6 1 (0.22%) BizTalk Server
6 1 (0.22%) CMS
6 1 (0.22%) Oracle SOA Suite
6 1 (0.22%) Sitecore CMS
6 1 (0.22%) Umbraco
Applications
1 27 (5.96%) Microsoft Excel
2 15 (3.31%) Microsoft Office
3 5 (1.10%) Microsoft PowerPoint
4 1 (0.22%) SPSS
Business Applications
1 10 (2.21%) MetaTrader
2 9 (1.99%) Cognos Business Intelligence
3 4 (0.88%) Dynamics CRM
4 3 (0.66%) FastStats
5 2 (0.44%) Endur
5 2 (0.44%) OpenLink RightAngle
6 1 (0.22%) Adobe Campaign
6 1 (0.22%) Dynamics AX
6 1 (0.22%) Markit EDM
6 1 (0.22%) RMDS
6 1 (0.22%) Unica
Cloud Services
1 48 (10.60%) Microsoft Azure
2 17 (3.75%) Office 365
3 14 (3.09%) Amazon AWS
4 12 (2.65%) GitHub
4 12 (2.65%) SaaS
5 6 (1.32%) Azure Machine Learning
5 6 (1.32%) PaaS
6 4 (0.88%) Azure Data Factory
7 3 (0.66%) Cortana Intelligence Suite
7 3 (0.66%) Datadog
8 2 (0.44%) Google Cloud Platform
9 1 (0.22%) Azure Active Directory
9 1 (0.22%) Cloud Computing
9 1 (0.22%) IaaS
Communications & Networking
1 11 (2.43%) DNS
1 11 (2.43%) Firewall
1 11 (2.43%) Internet
1 11 (2.43%) SSL
2 3 (0.66%) LDAP
2 3 (0.66%) Network Security
3 1 (0.22%) SMS
Database & Business Intelligence
1 417 (92.05%) SQL Server
2 234 (51.66%) SQL Server Integration Services
3 209 (46.14%) SQL Server Reporting Services
4 131 (28.92%) Data Warehouse
5 124 (27.37%) SQL Server Analysis Services
6 83 (18.32%) Relational Database
7 47 (10.38%) SQL Server 2008
8 45 (9.93%) Power BI
9 38 (8.39%) RDBMS
9 38 (8.39%) SQL Server 2012
10 27 (5.96%) NoSQL
11 26 (5.74%) Big Data
12 24 (5.30%) BusinessObjects
13 23 (5.08%) Crystal Reports
14 20 (4.42%) QlikView
15 19 (4.19%) MySQL
15 19 (4.19%) SQL Server 2016
16 16 (3.53%) SQL Server 2000
17 15 (3.31%) Hadoop
17 15 (3.31%) OLAP
Development Applications
1 69 (15.23%) Team Foundation Server
2 60 (13.25%) Visual Studio
3 56 (12.36%) SQL Server Management Studio (SSMS)
4 24 (5.30%) VSS/SourceSafe
5 23 (5.08%) Git (software)
6 18 (3.97%) Subversion
7 17 (3.75%) RStudio
8 15 (3.31%) TeamCity
9 14 (3.09%) Octopus Deploy
10 13 (2.87%) JIRA
10 13 (2.87%) Mercurial
10 13 (2.87%) NUnit
10 13 (2.87%) SpecFlow
11 10 (2.21%) Jasmine
11 10 (2.21%) Rhino Mocks
11 10 (2.21%) Selenium
12 6 (1.32%) InstallShield
12 6 (1.32%) Visual Studio Team System
13 4 (0.88%) Eclipse
14 3 (0.66%) CruiseControl
General
1 175 (38.63%) Finance
2 27 (5.96%) Banking
3 21 (4.64%) Law
4 16 (3.53%) Advertising
4 16 (3.53%) Back Office
5 14 (3.09%) Investment Banking
6 13 (2.87%) Retail
7 12 (2.65%) Legal
8 11 (2.43%) Telecoms
9 9 (1.99%) Front Office
10 8 (1.77%) Financial Institution
10 8 (1.77%) Games
11 3 (0.66%) Marketing
12 2 (0.44%) Billing
13 1 (0.22%) Automotive
Job Titles
1 267 (58.94%) Developer
2 137 (30.24%) SQL Developer
3 84 (18.54%) C# Developer
4 76 (16.78%) .NET Developer
5 75 (16.56%) Analyst
6 64 (14.13%) SSIS Developer
7 58 (12.80%) T-SQL Developer
8 54 (11.92%) SSRS Developer
9 52 (11.48%) Business Intelligence Developer
10 45 (9.93%) C# .NET Developer
11 43 (9.49%) Lead Developer
12 41 (9.05%) DBA
13 38 (8.39%) SQL Analyst
14 37 (8.17%) SQL DBA
15 34 (7.51%) ASP.NET MVC Developer
16 32 (7.06%) SQL Server Developer
17 31 (6.84%) Senior Developer
18 29 (6.40%) SSAS Developer
18 29 (6.40%) Systems Analyst
19 25 (5.52%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 177 (39.07%) .NET
2 97 (21.41%) HTML
3 96 (21.19%) ASP.NET
4 84 (18.54%) CSS
5 62 (13.69%) ASP.NET MVC
6 60 (13.25%) AngularJS
7 58 (12.80%) .NET Framework
8 55 (12.14%) jQuery
9 49 (10.82%) HTML5
10 38 (8.39%) CSS3
11 36 (7.95%) Ajax
11 36 (7.95%) WCF
12 35 (7.73%) Entity Framework
13 30 (6.62%) ASP.NET Web API
14 29 (6.40%) XML
15 26 (5.74%) ASP.NET Web Forms
16 22 (4.86%) WinForms
16 22 (4.86%) WPF
17 20 (4.42%) MDX
17 20 (4.42%) Sass
Miscellaneous
1 49 (10.82%) User Experience
2 29 (6.40%) Analytical Skills
2 29 (6.40%) Foreign Exchange (FX)
3 28 (6.18%) Data Structures
4 27 (5.96%) Computer Science
5 23 (5.08%) Replication
6 19 (4.19%) Management Information System
7 16 (3.53%) Algorithms
8 15 (3.31%) Greenfield Project
9 13 (2.87%) Clustering
10 11 (2.43%) Public Cloud
11 9 (1.99%) Reinsurance
12 7 (1.55%) Equities
13 6 (1.32%) e-Learning
13 6 (1.32%) SCORM
14 4 (0.88%) Client/Server
15 3 (0.66%) Fintech
15 3 (0.66%) N-Tier
16 2 (0.44%) Data Centre
16 2 (0.44%) Fixed Income
Operating Systems
1 89 (19.65%) Windows
2 19 (4.19%) Linux
2 19 (4.19%) Windows Server
3 16 (3.53%) Unix
4 10 (2.21%) Windows Server 2008
5 7 (1.55%) Windows Server 2012
6 6 (1.32%) Windows 7
7 3 (0.66%) HPUX
8 2 (0.44%) Windows 10
Processes & Methodologies
1 154 (34.00%) Business Intelligence
2 148 (32.67%) ETL
3 112 (24.72%) Agile Software Development
4 96 (21.19%) MVC
5 59 (13.02%) OO
6 53 (11.70%) Data Modelling
7 44 (9.71%) Scrum
8 43 (9.49%) Mathematics
9 41 (9.05%) TDD
10 39 (8.61%) Performance Tuning
11 36 (7.95%) Continuous Integration
12 35 (7.73%) OOP
13 34 (7.51%) Analytics
13 34 (7.51%) DevOps
14 29 (6.40%) Data Management
14 29 (6.40%) Software Engineering
15 27 (5.96%) Data Analysis
16 26 (5.74%) SDLC
16 26 (5.74%) Web Development
17 25 (5.52%) Investment Management
Programming Languages
1 447 (98.68%) SQL
2 199 (43.93%) C#
3 109 (24.06%) JavaScript
4 51 (11.26%) VB
5 38 (8.39%) PowerShell
6 27 (5.96%) VBA
7 25 (5.52%) R
8 20 (4.42%) Python
9 17 (3.75%) C++
10 13 (2.87%) Shell Script
11 11 (2.43%) PL/SQL
12 9 (1.99%) PHP
13 8 (1.77%) Data Analysis Expressions (DAX)
13 8 (1.77%) VB6
14 6 (1.32%) C
14 6 (1.32%) VBScript
15 5 (1.10%) VB.NET
16 3 (0.66%) Java
16 3 (0.66%) Perl
16 3 (0.66%) Ruby
Qualifications
1 74 (16.34%) Degree
2 4 (0.88%) Microsoft Certification
3 3 (0.66%) MCSE
4 2 (0.44%) Computer Science Degree
5 1 (0.22%) ISEB
5 1 (0.22%) ISTQB
5 1 (0.22%) Master's Degree
5 1 (0.22%) SC Cleared
5 1 (0.22%) Security Cleared
Quality Assurance & Compliance
1 29 (6.40%) Data Quality
2 22 (4.86%) QA
3 1 (0.22%) UCITS
System Software
1 21 (4.64%) Active Directory
2 14 (3.09%) HDFS
3 11 (2.43%) VMware Infrastructure
3 11 (2.43%) VMware Workstation
4 3 (0.66%) Docker
5 2 (0.44%) Microsoft Virtual Server
5 2 (0.44%) Virtual Servers
Systems Management
1 7 (1.55%) Perfmon
2 6 (1.32%) SCCM
3 3 (0.66%) Ansible
3 3 (0.66%) Kibana
3 3 (0.66%) logstash
3 3 (0.66%) SCOM
Vendors
1 265 (58.50%) Microsoft
2 25 (5.52%) Sybase
3 21 (4.64%) Tableau
4 18 (3.97%) Cognos
5 15 (3.31%) MicroStrategy
6 12 (2.65%) Oracle
7 11 (2.43%) VMware
8 7 (1.55%) Bloomberg
8 7 (1.55%) RedGate
9 6 (1.32%) Alteryx
9 6 (1.32%) Calypso
9 6 (1.32%) Murex
9 6 (1.32%) Reuters
10 4 (0.88%) Infragistics
11 3 (0.66%) AppDynamics
11 3 (0.66%) Splunk
12 2 (0.44%) OpenLink
12 2 (0.44%) Red Hat
13 1 (0.22%) StatPro
13 1 (0.22%) TIBCO