Period
to 19 January 2018

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

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Transact-SQL
Central London > City of London
6 months to
19 Jan 2018
Same period 2017 Same period 2016
Rank 112 82 55
Rank change year-on-year -30 -27 +29
Contract jobs citing T-SQL 154 184 258
As % of all contract IT jobs advertised in the City of London 2.17% 2.95% 3.60%
As % of the Programming Languages category 4.08% 5.81% 7.69%
Number of daily rates quoted 138 150 206
City of London median daily rate £490 £425 £450
Median daily rate % change year-on-year +15.29% -5.61% +7.52%
10th Percentile £404 £313 £313
90th Percentile £650 £538 £568
Central London median daily rate £486 £425 £450
% change year-on-year +14.41% -5.56% +9.09%
Number of hourly rates quoted 0 0 0
City of London median hourly rate - - -
Central London median hourly rate - - -

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the City of London with a requirement for coding skills.

All Programming Languages
City of London
Contract vacancies with a requirement for coding skills 3,776 3,166 3,355
As % of all contract IT jobs advertised in the City of London 53.23% 50.83% 46.75%
Number of daily rates quoted 3,192 2,655 2,816
City of London median daily rate £525 £475 £475
Median daily rate % change year-on-year +10.53% - +5.56%
10th Percentile £363 £325 £313
90th Percentile £688 £663 £656
Central London median daily rate £513 £475 £475
% change year-on-year +7.89% - +5.56%
Number of hourly rates quoted 8 10 20
City of London median hourly rate £27.55 £27.50 £29.82
Median hourly rate % change year-on-year +0.16% -7.78% +49.10%
10th Percentile £20.30 £16.06 £18.90
90th Percentile £54.03 £55.19 £55.50
Central London median hourly rate £28.00 £27.50 £29.82
% change year-on-year +1.82% -7.78% +49.10%

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
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing T-SQL in the City of London.

Contractor daily rate trend for T-SQL in the City of London

T-SQL
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing T-SQL in the City of London over the 6 months to 19 January 2018.

Contractor daily rate histogram for T-SQL in the City of London

T-SQL
Contractor Hourly Rate Trend in the City of London

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

Contractor hourly rate trend for T-SQL in the City of London

For the 6 months to 19 January 2018, IT contractor 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 contract ads across the City of London region with a requirement for T-SQL.

1 149 (96.75%) SQL
2 119 (77.27%) SQL Server
3 66 (42.86%) Business Intelligence
4 63 (40.91%) C#
5 62 (40.26%) SQL Server Reporting Services
6 59 (38.31%) .NET
7 58 (37.66%) SQL Server Integration Services
8 53 (34.42%) Agile Software Development
9 51 (33.12%) Microsoft
10 46 (29.87%) Finance
11 45 (29.22%) ETL
12 41 (26.62%) Data Warehouse
13 39 (25.32%) SQL Server Analysis Services
14 33 (21.43%) TDD
15 28 (18.18%) WCF
16 25 (16.23%) OO
16 25 (16.23%) Microsoft Azure
17 22 (14.29%) Data Structures
18 21 (13.64%) Data Modelling
18 21 (13.64%) JavaScript
18 21 (13.64%) WPF
19 20 (12.99%) OOP
19 20 (12.99%) MVC
20 19 (12.34%) Scrum
20 19 (12.34%) Windows
20 19 (12.34%) Visual Studio
20 19 (12.34%) Degree
20 19 (12.34%) Algorithms
20 19 (12.34%) Team Foundation Server
21 18 (11.69%) SQL Server 2008

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 (7.79%) IIS
2 8 (5.19%) Apache
3 7 (4.55%) WildFly
4 3 (1.95%) Elasticsearch
5 2 (1.30%) Tomcat
6 1 (0.65%) Apache Pig
6 1 (0.65%) Apache Spark
6 1 (0.65%) ArcGIS
6 1 (0.65%) BizTalk Server
6 1 (0.65%) Cloud Foundry
6 1 (0.65%) Confluence
6 1 (0.65%) SAS
6 1 (0.65%) SharePoint
6 1 (0.65%) Umbraco
Applications
1 15 (9.74%) Microsoft Excel
2 4 (2.60%) Microsoft PowerPoint
3 3 (1.95%) MS Visio
4 2 (1.30%) Microsoft Office
5 1 (0.65%) Microsoft Project
5 1 (0.65%) SPSS
Business Applications
1 4 (2.60%) Markit EDM
2 2 (1.30%) Dynamics AX
2 2 (1.30%) Dynamics CRM
2 2 (1.30%) SunGard GMI
3 1 (0.65%) Dynamics GP
3 1 (0.65%) SAP CRM
Cloud Services
1 25 (16.23%) Microsoft Azure
2 11 (7.14%) Amazon AWS
3 1 (0.65%) Azure Data Factory
3 1 (0.65%) GitHub
3 1 (0.65%) IaaS
3 1 (0.65%) npm
3 1 (0.65%) Office 365
Communications & Networking
1 3 (1.95%) SAN
2 2 (1.30%) DNS
3 1 (0.65%) DHCP
3 1 (0.65%) Firewall
3 1 (0.65%) SSL
3 1 (0.65%) TCP/IP
Database & Business Intelligence
1 119 (77.27%) SQL Server
2 62 (40.26%) SQL Server Reporting Services
3 58 (37.66%) SQL Server Integration Services
4 41 (26.62%) Data Warehouse
5 39 (25.32%) SQL Server Analysis Services
6 18 (11.69%) SQL Server 2008
7 17 (11.04%) Power BI
8 15 (9.74%) SQL Server 2016
9 14 (9.09%) SQL Server 2014
10 11 (7.14%) Microsoft Analysis Services
11 10 (6.49%) SQL Server 2012
12 7 (4.55%) IBM InfoSphere
12 7 (4.55%) OLAP
13 6 (3.90%) NoSQL
13 6 (3.90%) OLAP Cube
13 6 (3.90%) SQL Server 2005
14 5 (3.25%) MongoDB
15 4 (2.60%) DataStage
15 4 (2.60%) Enterprise Data Warehouse
16 2 (1.30%) Oracle Database
Development Applications
1 19 (12.34%) Team Foundation Server
1 19 (12.34%) Visual Studio
2 11 (7.14%) NUnit
3 7 (4.55%) Moq
4 6 (3.90%) Git (software)
5 5 (3.25%) MSTest
6 4 (2.60%) JIRA
7 2 (1.30%) Eclipse
7 2 (1.30%) ERwin
7 2 (1.30%) Jenkins
7 2 (1.30%) Maven
7 2 (1.30%) Subversion
8 1 (0.65%) Bower
8 1 (0.65%) Chocolatey
8 1 (0.65%) MSBuild
8 1 (0.65%) Octopus Deploy
8 1 (0.65%) SonarQube
8 1 (0.65%) SQL Server Management Studio (SSMS)
8 1 (0.65%) TestRail
8 1 (0.65%) Zephyr
General
1 46 (29.87%) Finance
2 12 (7.79%) Banking
3 10 (6.49%) Front Office
4 7 (4.55%) Legal
5 6 (3.90%) Law
6 4 (2.60%) Investment Banking
6 4 (2.60%) Retail
7 3 (1.95%) Financial Institution
8 2 (1.30%) Advertising
8 2 (1.30%) Back Office
9 1 (0.65%) Corporate Banking
9 1 (0.65%) German Language
9 1 (0.65%) Manufacturing
9 1 (0.65%) Pharmaceutical
9 1 (0.65%) Publishing
9 1 (0.65%) Retail Banking
Job Titles
1 117 (75.97%) Developer
2 37 (24.03%) Business Intelligence Developer
3 35 (22.73%) SQL Developer
4 33 (21.43%) C# Developer
5 30 (19.48%) .NET Developer
6 19 (12.34%) SSRS Developer
7 17 (11.04%) Analyst
7 17 (11.04%) SSIS Developer
8 14 (9.09%) C# .NET Developer
9 12 (7.79%) SQL BI Developer
10 11 (7.14%) C# WPF Developer
10 11 (7.14%) Senior Developer
10 11 (7.14%) SSAS Developer
10 11 (7.14%) WPF Developer
11 10 (6.49%) Full Stack Developer
12 9 (5.84%) T-SQL Developer
13 8 (5.19%) DBA
13 8 (5.19%) SQL DBA
14 7 (4.55%) Analyst Developer
14 7 (4.55%) Report Developer
Libraries, Frameworks & Software Standards
1 59 (38.31%) .NET
2 28 (18.18%) WCF
3 21 (13.64%) WPF
4 18 (11.69%) HTML
5 17 (11.04%) MDX
6 16 (10.39%) WinForms
7 14 (9.09%) AngularJS
7 14 (9.09%) ASP.NET
7 14 (9.09%) ASP.NET MVC
8 13 (8.44%) .NET Framework
8 13 (8.44%) HTML5
9 11 (7.14%) Web Services
10 10 (6.49%) ASP.NET Web API
10 10 (6.49%) jQuery
10 10 (6.49%) REST
11 9 (5.84%) JSON
12 8 (5.19%) .NET Core
12 8 (5.19%) LINQ
13 7 (4.55%) NHibernate
14 6 (3.90%) FIX Protocol
Miscellaneous
1 22 (14.29%) Data Structures
2 19 (12.34%) Algorithms
3 18 (11.69%) Computer Science
3 18 (11.69%) Hedge funds
4 13 (8.44%) Analytical Skills
5 8 (5.19%) Greenfield Project
6 7 (4.55%) Equities
6 7 (4.55%) Foreign Exchange (FX)
7 6 (3.90%) Derivative
7 6 (3.90%) Fixed Income
8 4 (2.60%) Credit Risk
8 4 (2.60%) Management Information System
8 4 (2.60%) Replication
9 3 (1.95%) Clustering
9 3 (1.95%) Market Risk
9 3 (1.95%) NHS
10 2 (1.30%) Data Centre
10 2 (1.30%) Enterprise Software
10 2 (1.30%) Reinsurance
11 1 (0.65%) User Experience
Operating Systems
1 19 (12.34%) Windows
2 7 (4.55%) Linux
3 6 (3.90%) Unix
4 5 (3.25%) Windows Server
5 4 (2.60%) Windows Server 2003
6 2 (1.30%) Windows Server 2008
7 1 (0.65%) Windows 7
7 1 (0.65%) Windows 8
Processes & Methodologies
1 66 (42.86%) Business Intelligence
2 53 (34.42%) Agile Software Development
3 45 (29.22%) ETL
4 33 (21.43%) TDD
5 25 (16.23%) OO
6 21 (13.64%) Data Modelling
7 20 (12.99%) MVC
7 20 (12.99%) OOP
8 19 (12.34%) Scrum
9 17 (11.04%) ETL Development
9 17 (11.04%) OOD
10 16 (10.39%) Kimball Methodology
10 16 (10.39%) Multithreading
11 14 (9.09%) Pair Programming
11 14 (9.09%) Unit Testing
12 12 (7.79%) SDLC
13 10 (6.49%) Business Analysis
13 10 (6.49%) Data Analysis
13 10 (6.49%) Kanban
14 9 (5.84%) Dimensional Modelling
Programming Languages
1 149 (96.75%) SQL
2 63 (40.91%) C#
3 21 (13.64%) JavaScript
4 13 (8.44%) Java
5 9 (5.84%) PL/SQL
6 7 (4.55%) Data Analysis Expressions (DAX)
6 7 (4.55%) Python
7 4 (2.60%) PowerShell
7 4 (2.60%) VBA
8 3 (1.95%) R
8 3 (1.95%) Ruby
9 2 (1.30%) C
9 2 (1.30%) TypeScript
9 2 (1.30%) VB
9 2 (1.30%) VB.NET
9 2 (1.30%) VBScript
10 1 (0.65%) Bash Shell
10 1 (0.65%) Perl
10 1 (0.65%) X++
10 1 (0.65%) XPath
Qualifications
1 19 (12.34%) Degree
2 5 (3.25%) Microsoft Certification
3 3 (1.95%) MCP
3 3 (1.95%) MCPD
3 3 (1.95%) Security Cleared
4 2 (1.30%) Computer Science Degree
4 2 (1.30%) MCSE
5 1 (0.65%) CTC Cleared
5 1 (0.65%) ITIL Certification
5 1 (0.65%) Numerate Degree
5 1 (0.65%) SC Cleared
Quality Assurance & Compliance
1 12 (7.79%) MiFID
2 4 (2.60%) Data Quality
3 3 (1.95%) QA
4 1 (0.65%) SLA
4 1 (0.65%) Solvency II
System Software
1 2 (1.30%) Docker
2 1 (0.65%) Active Directory
2 1 (0.65%) HDFS
2 1 (0.65%) Hyper-V
2 1 (0.65%) VMware Infrastructure
2 1 (0.65%) XenApp
Systems Management
1 3 (1.95%) Microsoft Clustering
2 1 (0.65%) Forefront Identity Manager
2 1 (0.65%) Rancher
2 1 (0.65%) SCCM
2 1 (0.65%) SCOM
2 1 (0.65%) WMI
Vendors
1 51 (33.12%) Microsoft
2 11 (7.14%) Tableau
3 5 (3.25%) MicroStrategy
3 5 (3.25%) Typemock
4 4 (2.60%) IBM
5 3 (1.95%) SAP
6 2 (1.30%) Atlassian
6 2 (1.30%) CQG
6 2 (1.30%) Fidessa
6 2 (1.30%) FIS
6 2 (1.30%) Oracle
6 2 (1.30%) SunGard
7 1 (0.65%) Black Duck
7 1 (0.65%) Citrix
7 1 (0.65%) Cognos
7 1 (0.65%) Informatica
7 1 (0.65%) Splunk
7 1 (0.65%) VMware