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 24 March 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.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Transact-SQL
UK / Scotland
Rank 91 99 90
Rank change year-on-year +8 -9  
Contract jobs citing T-SQL 16 28 33
As % of all contract IT jobs advertised in Scotland 0.91% 1.09% 1.17%
As % of the Programming Languages category 2.05% 3.40% 3.66%
Number of daily rates quoted 14 18 22
Median daily rate £350 £358 £350
Median daily rate % change year-on-year -2.09% +2.14%  
90% offered a daily rate of more than £275 £321 £205
10% offered a daily rate of more than £393 £408 £400
UK excluding London median daily rate £350 £350 £325
% change year-on-year - +7.69%  
Number of hourly rates quoted 0 1 2
Median hourly rate - £22.50 £47.50
Median hourly rate % change year-on-year - -52.63%  
UK excluding London median hourly rate £20.75 £32.50 £30.60
% change year-on-year -36.15% +6.22%  

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 780 824 902
As % of all contract IT job vacancies advertised in Scotland 44.47% 32.04% 32.11%
Number of daily rates quoted 481 480 529
Median daily rate £375 £375 £375
90% offered a daily rate of more than £275 £280 £275
10% offered a daily rate of more than £470 £475 £475
UK excluding London median daily rate £390 £375 £350
% change year-on-year +4.00% +7.14%  
Number of hourly rates quoted 16 12 12
Median hourly rate £41.25 £37.50 £34.00
Median hourly rate % change year-on-year +10.00% +10.29%  
90% offered a hourly rate of more than £15.89 £19.65 £18.70
10% offered a hourly rate of more than £52.17 £45.30 £47.50
UK excluding London median hourly rate £41.64 £40.00 £36.00
% change year-on-year +4.10% +11.11%  

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 24 March 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 hourly rates quoted in IT contractor 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 24 March 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 +10 8 £325 -1.51% 2
Glasgow +3 7 £350 -6.66% 4
South Lanarkshire - 1 £400 -
T-SQL
UK

T-SQL
Top 30 Related IT Skills in Scotland

For the 6 months to 24 March 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 47 (100.00%) SQL
2 41 (87.23%) SQL Server
3 20 (42.55%) .NET
4 19 (40.43%) C#
5 15 (31.91%) SQL Server Integration Services
6 14 (29.79%) Microsoft
7 13 (27.66%) ASP.NET
7 13 (27.66%) SQL Server Reporting Services
8 12 (25.53%) SQL Server 2008
8 12 (25.53%) SQL Server 2012
9 11 (23.40%) Agile Software Development
10 10 (21.28%) MVC
10 10 (21.28%) Business Intelligence
11 9 (19.15%) JavaScript
12 8 (17.02%) ETL
12 8 (17.02%) jQuery
12 8 (17.02%) SQL Server Analysis Services
13 7 (14.89%) HTML
13 7 (14.89%) CSS
13 7 (14.89%) Data Warehouse
14 6 (12.77%) Java
14 6 (12.77%) Oracle
14 6 (12.77%) Visual Studio
14 6 (12.77%) Data Modelling
14 6 (12.77%) Finance
14 6 (12.77%) Migration
14 6 (12.77%) Git (software)
14 6 (12.77%) Microsoft Azure
15 5 (10.64%) ASP.NET MVC
15 5 (10.64%) WCF

T-SQL
Top Related 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 2 (4.26%) SharePoint
2 1 (2.13%) BizTalk Server
2 1 (2.13%) Oracle Coherence
2 1 (2.13%) SAS
Applications
1 1 (2.13%) MS Excel
1 1 (2.13%) MS Office
Business Applications
1 2 (4.26%) Infor CloudSuite Industrial (formerly SyteLine)
2 1 (2.13%) Cognos Business Intelligence
2 1 (2.13%) Unit4 Business World
Cloud Services
1 6 (12.77%) Microsoft Azure
Communications & Networking
1 1 (2.13%) TCP/IP
Database & Business Intelligence
1 41 (87.23%) SQL Server
2 15 (31.91%) SQL Server Integration Services
3 13 (27.66%) SQL Server Reporting Services
4 12 (25.53%) SQL Server 2008
4 12 (25.53%) SQL Server 2012
5 8 (17.02%) SQL Server Analysis Services
6 7 (14.89%) Data Warehouse
7 5 (10.64%) SQL Server 2014
8 4 (8.51%) Power BI
9 3 (6.38%) Azure SQL Database
9 3 (6.38%) QlikView
9 3 (6.38%) Relational Database
9 3 (6.38%) SQL Server 2005
10 2 (4.26%) Big Data
10 2 (4.26%) Crystal Reports
10 2 (4.26%) Microsoft Analysis Services
10 2 (4.26%) RDBMS
11 1 (2.13%) MongoDB
11 1 (2.13%) Oracle Database
11 1 (2.13%) Oracle Database 12c
Development Applications
1 6 (12.77%) Git (software)
1 6 (12.77%) Visual Studio
2 3 (6.38%) Subversion
2 3 (6.38%) Visual Studio Team System
3 1 (2.13%) CruiseControl
3 1 (2.13%) IntelliJ
3 1 (2.13%) Jenkins
3 1 (2.13%) JIRA
3 1 (2.13%) JUnit
3 1 (2.13%) Maven
3 1 (2.13%) PowerBuilder
3 1 (2.13%) Team Foundation Server
3 1 (2.13%) TeamCity
3 1 (2.13%) Toad
General
1 6 (12.77%) Finance
2 3 (6.38%) Banking
3 1 (2.13%) Advertising
Job Titles
1 34 (72.34%) Developer
2 10 (21.28%) .NET Developer
3 8 (17.02%) C# Developer
4 7 (14.89%) Analyst
4 7 (14.89%) SQL Developer
5 5 (10.64%) C# .NET Developer
6 4 (8.51%) Business Intelligence Developer
6 4 (8.51%) DBA
6 4 (8.51%) SQL Analyst
6 4 (8.51%) SQL DBA
7 3 (6.38%) Architect
7 3 (6.38%) Business Analyst
7 3 (6.38%) Business Intelligence Architect
7 3 (6.38%) Data Warehouse Developer
7 3 (6.38%) ETL Developer
7 3 (6.38%) Oracle Developer
7 3 (6.38%) SQL BI Architect
7 3 (6.38%) SQL Support Analyst
7 3 (6.38%) Support Analyst
8 2 (4.26%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 20 (42.55%) .NET
2 13 (27.66%) ASP.NET
3 8 (17.02%) jQuery
4 7 (14.89%) CSS
4 7 (14.89%) HTML
5 5 (10.64%) ASP.NET MVC
5 5 (10.64%) WCF
5 5 (10.64%) WPF
6 4 (8.51%) .NET Framework
7 3 (6.38%) AngularJS
7 3 (6.38%) ASP.NET Web Forms
7 3 (6.38%) MDX
7 3 (6.38%) Web Services
7 3 (6.38%) XML
8 2 (4.26%) ASP.NET Web API
8 2 (4.26%) RabbitMQ
8 2 (4.26%) WinForms
9 1 (2.13%) FIX Protocol
9 1 (2.13%) Hibernate
9 1 (2.13%) JSON
Miscellaneous
1 5 (10.64%) Analytical Skills
2 2 (4.26%) Clustering
2 2 (4.26%) Data Structures
3 1 (2.13%) Fintech
3 1 (2.13%) Hedge funds
3 1 (2.13%) Mainframe
Operating Systems
1 2 (4.26%) Windows
1 2 (4.26%) Windows Server
2 1 (2.13%) MVS
2 1 (2.13%) Unix
Processes & Methodologies
1 11 (23.40%) Agile Software Development
2 10 (21.28%) Business Intelligence
2 10 (21.28%) MVC
3 8 (17.02%) ETL
4 6 (12.77%) Data Modelling
4 6 (12.77%) Migration
5 5 (10.64%) Kimball Methodology
6 3 (6.38%) Data Extraction
6 3 (6.38%) Data Visualisation
6 3 (6.38%) ERP
6 3 (6.38%) ETL Development
6 3 (6.38%) Performance Tuning
6 3 (6.38%) Scrum
6 3 (6.38%) Technical Analysis
6 3 (6.38%) Visualisation
7 2 (4.26%) Data Management
7 2 (4.26%) Incident Management
7 2 (4.26%) SDLC
7 2 (4.26%) Stakeholder Management
7 2 (4.26%) Web Development
Programming Languages
1 47 (100.00%) SQL
2 19 (40.43%) C#
3 9 (19.15%) JavaScript
4 6 (12.77%) Java
5 5 (10.64%) PL/SQL
6 3 (6.38%) VB
7 2 (4.26%) Python
7 2 (4.26%) VB.NET
8 1 (2.13%) C
8 1 (2.13%) C++
8 1 (2.13%) MATLAB
8 1 (2.13%) PowerShell
8 1 (2.13%) R
8 1 (2.13%) XPath
Qualifications
1 1 (2.13%) SC Cleared
1 1 (2.13%) Security Cleared
Quality Assurance & Compliance
1 1 (2.13%) Disclosure Scotland
1 1 (2.13%) SLA
System Software
1 1 (2.13%) Firmware
Vendors
1 14 (29.79%) Microsoft
2 6 (12.77%) Oracle
3 4 (8.51%) Cognos
4 3 (6.38%) DevExpress
5 2 (4.26%) Infor
5 2 (4.26%) Informatica
6 1 (2.13%) IBM
6 1 (2.13%) Perforce
6 1 (2.13%) Reuters
6 1 (2.13%) SAP
6 1 (2.13%) Tableau
6 1 (2.13%) Telerik