The following table provides summary statistics for contract job vacancies advertised in Scotland 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 3 months to 23 June 2017 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
UK / Scotland
3 months to
23 Jun 2017
Same period 2016 Same period 2015
Rank 106 110 102
Rank change year-on-year +4 -8  
Contract jobs citing T-SQL 10 45 37
As % of all contract IT jobs advertised in Scotland 0.46% 1.53% 1.21%
As % of the Programming Languages category 1.07% 4.23% 3.78%
Number of daily rates quoted 7 25 28
Median daily rate £375 £338 £369
Median daily rate % change year-on-year +11.11% -8.47%  
90% offered a daily rate of more than £213 £294 £279
10% offered a daily rate of more than £450 £359 £450
UK excluding London median daily rate £350 £350 £325
% change year-on-year - +7.69%  
Number of hourly rates quoted 2 2 1
Median hourly rate £190.00 £42.75 £42.50
Median hourly rate % change year-on-year +344.44% +0.58%  
UK excluding London median hourly rate £37.50 £29.00 £21.00
% change year-on-year +29.31% +38.09%  

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Scotland with a requirement for programming language skills.

Contract Programming Language Skills
Scotland
Contract job vacancies with a requirement for programming language skills 933 1064 980
As % of all contract IT job vacancies advertised in Scotland 43.04% 36.23% 32.02%
Number of daily rates quoted 538 574 506
Median daily rate £388 £350 £365
Median daily rate % change year-on-year +10.71% -4.10%  
90% offered a daily rate of more than £300 £260 £275
10% offered a daily rate of more than £500 £450 £450
UK excluding London median daily rate £400 £375 £350
% change year-on-year +6.66% +7.14%  
Number of hourly rates quoted 11 21 21
Median hourly rate £43.39 £36.00 £30.50
Median hourly rate % change year-on-year +20.52% +18.03%  
90% offered a hourly rate of more than £35.00 £35.50 £30.00
10% offered a hourly rate of more than £190.00 £42.50 £55.00
UK excluding London median hourly rate £42.50 £37.50 £36.50
% change year-on-year +13.33% +2.73%  

T-SQL
Job Vacancy Trend in Scotland

The job posting trend of jobs advertised in Scotland citing T-SQL as a proportion of all contract or permanent IT jobs with a match in the Programming Languages category.

Job vacancy trend for T-SQL in Scotland

T-SQL
Contractor Daily Rate Trend in Scotland

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

Contractor daily rate trend for T-SQL in Scotland

T-SQL
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing T-SQL in Scotland over the 3 months to 23 June 2017.

Contractor daily rate histogram for T-SQL in Scotland

T-SQL
Contractor Hourly Rate Trend in Scotland

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

Contractor hourly rate trend for T-SQL in Scotland

T-SQL
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing T-SQL within the Scotland region over the 3 months to 23 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +4 5 £438 +40.00% 2
Glasgow -7 4 £281 -19.64% 3
Fife - 1 £138 -
T-SQL
UK

For the 6 months to 23 June 2017, 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 Scotland region with a requirement for T-SQL.

1 26 (100.00%) SQL
2 22 (84.62%) SQL Server
3 8 (30.77%) .NET
4 6 (23.08%) C#
4 6 (23.08%) SQL Server Reporting Services
5 5 (19.23%) SQL Server Integration Services
5 5 (19.23%) HTML
5 5 (19.23%) Java
5 5 (19.23%) CSS
5 5 (19.23%) Finance
6 4 (15.38%) ASP.NET
6 4 (15.38%) MVC
6 4 (15.38%) Migration
6 4 (15.38%) Microsoft
6 4 (15.38%) JavaScript
6 4 (15.38%) PL/SQL
6 4 (15.38%) Oracle
6 4 (15.38%) Analytical Skills
6 4 (15.38%) SQL Server 2014
7 3 (11.54%) SQL Server Management Studio (SSMS)
7 3 (11.54%) Data Extraction
7 3 (11.54%) SQL Server 2008
7 3 (11.54%) ASP.NET MVC
7 3 (11.54%) SQL Server 2005
7 3 (11.54%) jQuery
7 3 (11.54%) Agile Software Development
7 3 (11.54%) Banking
7 3 (11.54%) VB
7 3 (11.54%) Microsoft Office
7 3 (11.54%) SQL Server 2000

T-SQL
Co-occurring IT Skills in Scotland 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 1 (3.85%) CMS
1 1 (3.85%) DNN
1 1 (3.85%) Drupal
1 1 (3.85%) SAS
1 1 (3.85%) SharePoint
Applications
1 3 (11.54%) Microsoft Office
Business Applications
1 2 (7.69%) Infor CloudSuite Industrial (formerly SyteLine)
Cloud Services
1 2 (7.69%) Microsoft Azure
2 1 (3.85%) Adobe Creative Cloud
Database & Business Intelligence
1 22 (84.62%) SQL Server
2 6 (23.08%) SQL Server Reporting Services
3 5 (19.23%) SQL Server Integration Services
4 4 (15.38%) SQL Server 2014
5 3 (11.54%) SQL Server 2000
5 3 (11.54%) SQL Server 2005
5 3 (11.54%) SQL Server 2008
6 2 (7.69%) Data Mining
6 2 (7.69%) Data Warehouse
6 2 (7.69%) PostgreSQL
6 2 (7.69%) QlikView
6 2 (7.69%) Relational Database
6 2 (7.69%) SQL Server 2016
6 2 (7.69%) SQL Server Analysis Services
7 1 (3.85%) Big Data
7 1 (3.85%) Hadoop
7 1 (3.85%) RDBMS
7 1 (3.85%) SQL Server 2012
Development Applications
1 3 (11.54%) SQL Server Management Studio (SSMS)
2 2 (7.69%) Visual Studio
3 1 (3.85%) Git (software)
3 1 (3.85%) Subversion
3 1 (3.85%) Team Foundation Server
General
1 5 (19.23%) Finance
2 3 (11.54%) Banking
3 1 (3.85%) Advertising
Job Titles
1 16 (61.54%) Developer
2 7 (26.92%) Analyst
3 5 (19.23%) SQL Developer
4 4 (15.38%) SQL Analyst
5 3 (11.54%) .NET Developer
5 3 (11.54%) C# Developer
5 3 (11.54%) DBA
6 2 (7.69%) 2nd Line Support
6 2 (7.69%) Analyst Developer
6 2 (7.69%) Applications Developer
6 2 (7.69%) Business Analyst
6 2 (7.69%) C# .NET Developer
6 2 (7.69%) ERP Analyst
6 2 (7.69%) ERP Business Analyst
6 2 (7.69%) Informatica Developer
6 2 (7.69%) Oracle Developer
6 2 (7.69%) Senior Analyst
6 2 (7.69%) Senior Developer
6 2 (7.69%) SQL DBA
6 2 (7.69%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 8 (30.77%) .NET
2 5 (19.23%) CSS
2 5 (19.23%) HTML
3 4 (15.38%) ASP.NET
4 3 (11.54%) ASP.NET MVC
4 3 (11.54%) jQuery
5 2 (7.69%) ASP.NET Web API
5 2 (7.69%) RabbitMQ
5 2 (7.69%) Web Services
5 2 (7.69%) XML
6 1 (3.85%) ADO.NET
6 1 (3.85%) AngularJS
6 1 (3.85%) ASP.NET MVC 5
6 1 (3.85%) Hibernate
6 1 (3.85%) HTML5
6 1 (3.85%) React
6 1 (3.85%) Sass
6 1 (3.85%) Twitter Bootstrap
6 1 (3.85%) WCF
6 1 (3.85%) WinForms
Miscellaneous
1 4 (15.38%) Analytical Skills
2 2 (7.69%) Clustering
3 1 (3.85%) Fintech
3 1 (3.85%) Greenfield Project
3 1 (3.85%) Mainframe
3 1 (3.85%) N-Tier
Operating Systems
1 1 (3.85%) MVS
Processes & Methodologies
1 4 (15.38%) Migration
1 4 (15.38%) MVC
2 3 (11.54%) Agile Software Development
2 3 (11.54%) Data Extraction
3 2 (7.69%) ERP
3 2 (7.69%) Performance Management
3 2 (7.69%) Stakeholder Management
4 1 (3.85%) Analytics
4 1 (3.85%) Business Intelligence
4 1 (3.85%) Continuous Integration
4 1 (3.85%) Data Modelling
4 1 (3.85%) ETL
4 1 (3.85%) Kimball Methodology
4 1 (3.85%) Logical Data Model
4 1 (3.85%) MVVM
4 1 (3.85%) Physical Data Model
4 1 (3.85%) Scrum
4 1 (3.85%) Stakeholder Engagement
4 1 (3.85%) Use Case
4 1 (3.85%) Web Development
Programming Languages
1 26 (100.00%) SQL
2 6 (23.08%) C#
3 5 (19.23%) Java
4 4 (15.38%) JavaScript
4 4 (15.38%) PL/SQL
5 3 (11.54%) VB
6 2 (7.69%) Python
6 2 (7.69%) VB.NET
7 1 (3.85%) C
7 1 (3.85%) C++
7 1 (3.85%) MATLAB
7 1 (3.85%) PHP
7 1 (3.85%) PowerShell
7 1 (3.85%) R
Qualifications
1 1 (3.85%) SC Cleared
1 1 (3.85%) Security Cleared
Quality Assurance & Compliance
1 1 (3.85%) QA
1 1 (3.85%) SLA
System Software
1 1 (3.85%) Firmware
Vendors
1 4 (15.38%) Microsoft
1 4 (15.38%) Oracle
2 2 (7.69%) Infor
2 2 (7.69%) Informatica
3 1 (3.85%) Adobe
3 1 (3.85%) DevExpress
3 1 (3.85%) Perforce
3 1 (3.85%) Telerik