The table below looks at the statistics for T-SQL skills in IT contracts advertised for the Scotland region. Included is a guide to the contractor rates offered in IT contracts that have cited T-SQL over the 3 months to 19 January 2017 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Transact-SQL
UK / Scotland
Rank 76 103 70
Rank change year-on-year
+27 -33
Contract jobs citing T-SQL 27 27 55
As % of all contract IT jobs located in Scotland 1.62% 1.02% 2.09%
As % of the Programming Languages category 3.56% 3.05% 5.14%
Number of daily rates quoted 23 17 42
Median daily rate £375 £330 £339
Median daily rate % change year-on-year
+13.63% -2.58%
90% offered a daily rate of more than £280 £325 £283
10% offered a daily rate of more than £480 £400 £400
UK excluding London median daily rate £360 £338 £325
% change year-on-year
+6.66% +3.84%
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 £16.00 £29.75 £35.75
% change year-on-year
-46.21% -16.78%

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in contract jobs advertised in the Scotland region.

Programming Languages Category
Scotland
Contract IT job ads with a match in the
Programming Languages category
758 884 1069
As % of all contract IT jobs located in Scotland 45.50% 33.43% 40.71%
Number of daily rates quoted 421 523 610
Median daily rate £365 £368 £375
Median daily rate % change year-on-year
-0.68% -2.00%
90% offered a daily rate of more than £275 £267 £285
10% offered a daily rate of more than £468 £493 £475
UK excluding London median daily rate £388 £375 £350
% change year-on-year
+3.33% +7.14%
Number of hourly rates quoted 27 12 11
Median hourly rate £43.00 £37.50 £32.50
Median hourly rate % change year-on-year
+14.66% +15.38%
90% offered a hourly rate of more than £15.89 £22.50 £14.85
10% offered a hourly rate of more than £55.00 £43.50 £47.50
UK excluding London median hourly rate £40.50 £40.00 £35.18
% change year-on-year
+1.25% +13.71%

T-SQL
Jobs Demand Trend in Scotland

The demand trend of contract jobs across the Scotland region citing T-SQL as a proportion of all IT contracts with a match in the Programming Languages category.

T-SQL Jobs Demand Trend in Scotland

T-SQL
Daily Rate Trend in Scotland

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

T-SQL Daily Rate Trend in Scotland

T-SQL
Daily Rate Histogram in Scotland

This chart provides a histogram of daily rates quoted in contract IT jobs citing T-SQL across the Scotland region over the 3 months to 19 January 2017.

T-SQL Daily Rate Histogram in Scotland

T-SQL
Hourly Rate Trend in Scotland

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

T-SQL Hourly Rate Trend 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 19 January 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
Glasgow +16 12 £375 +7.14% 4
Edinburgh +12 9 £375 +13.63% 2
West Lothian -2 5 £320 +3.22%
Inverclyde - 1 £375 -
T-SQL
UK

T-SQL
Top 30 Related IT Skills in Scotland

For the 6 months to 19 January 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 60 (100.00%) SQL
2 54 (90.00%) SQL Server
3 29 (48.33%) .NET
4 26 (43.33%) C#
5 21 (35.00%) SQL Server Integration Services
6 19 (31.67%) ASP.NET
7 17 (28.33%) Microsoft
8 15 (25.00%) SQL Server 2008
9 14 (23.33%) Business Intelligence
9 14 (23.33%) Agile Software Development
9 14 (23.33%) SQL Server Reporting Services
10 13 (21.67%) MVC
11 12 (20.00%) JavaScript
11 12 (20.00%) SQL Server 2012
12 10 (16.67%) ETL
12 10 (16.67%) Migration
13 9 (15.00%) Data Warehouse
13 9 (15.00%) HTML
13 9 (15.00%) CSS
13 9 (15.00%) SQL Server Analysis Services
13 9 (15.00%) jQuery
14 8 (13.33%) Oracle
15 7 (11.67%) .NET Framework
15 7 (11.67%) VB
15 7 (11.67%) XML
15 7 (11.67%) WCF
15 7 (11.67%) Microsoft Azure
16 6 (10.00%) Data Extraction
16 6 (10.00%) WPF
16 6 (10.00%) QlikView

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 (3.33%) BizTalk Server
1 2 (3.33%) Oracle Coherence
1 2 (3.33%) SharePoint
Applications
1 4 (6.67%) MS Excel
2 3 (5.00%) MS Office
2 3 (5.00%) MS Visio
Business Applications
1 5 (8.33%) Infor CloudSuite Industrial (formerly SyteLine)
2 3 (5.00%) Dynamics CRM
3 1 (1.67%) Cognos Business Intelligence
3 1 (1.67%) Unit4 Business World
Cloud Services
1 7 (11.67%) Microsoft Azure
2 2 (3.33%) SaaS
Communications & Networking
1 1 (1.67%) Intranet
1 1 (1.67%) TCP/IP
Database & Business Intelligence
1 54 (90.00%) SQL Server
2 21 (35.00%) SQL Server Integration Services
3 15 (25.00%) SQL Server 2008
4 14 (23.33%) SQL Server Reporting Services
5 12 (20.00%) SQL Server 2012
6 9 (15.00%) Data Warehouse
6 9 (15.00%) SQL Server Analysis Services
7 6 (10.00%) QlikView
8 5 (8.33%) SQL Server 2014
9 4 (6.67%) Power BI
10 3 (5.00%) Azure SQL Database
10 3 (5.00%) Crystal Reports
10 3 (5.00%) Oracle Reports
11 2 (3.33%) Microsoft Analysis Services
11 2 (3.33%) MongoDB
11 2 (3.33%) Relational Database
11 2 (3.33%) SQL Server 2005
12 1 (1.67%) BusinessObjects
12 1 (1.67%) Oracle Database 11g
12 1 (1.67%) RDBMS
Development Applications
1 6 (10.00%) Visual Studio
2 5 (8.33%) Git (software)
3 3 (5.00%) JIRA
3 3 (5.00%) Subversion
3 3 (5.00%) Team Foundation Server
3 3 (5.00%) Visual Studio Team System
4 2 (3.33%) IntelliJ
4 2 (3.33%) Jenkins
4 2 (3.33%) JUnit
4 2 (3.33%) Maven
5 1 (1.67%) CruiseControl
5 1 (1.67%) Cucumber
5 1 (1.67%) PowerBuilder
5 1 (1.67%) SQL Server Management Studio (SSMS)
5 1 (1.67%) TeamCity
5 1 (1.67%) Toad
General
1 6 (10.00%) Finance
2 3 (5.00%) Banking
2 3 (5.00%) Manufacturing
3 2 (3.33%) Advertising
Job Titles
1 43 (71.67%) Developer
2 18 (30.00%) .NET Developer
3 9 (15.00%) Analyst
4 8 (13.33%) SQL Developer
5 6 (10.00%) C# Developer
6 4 (6.67%) Business Intelligence Developer
6 4 (6.67%) C# .NET Developer
6 4 (6.67%) ETL Developer
7 3 (5.00%) Applications Support
7 3 (5.00%) Architect
7 3 (5.00%) ASP.NET Developer
7 3 (5.00%) Business Analyst
7 3 (5.00%) Business Intelligence Architect
7 3 (5.00%) Data Warehouse Developer
7 3 (5.00%) DBA
7 3 (5.00%) Delphi Developer
7 3 (5.00%) SQL Analyst
7 3 (5.00%) SQL BI Architect
7 3 (5.00%) SQL DBA
7 3 (5.00%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 29 (48.33%) .NET
2 19 (31.67%) ASP.NET
3 9 (15.00%) CSS
3 9 (15.00%) HTML
3 9 (15.00%) jQuery
4 7 (11.67%) .NET Framework
4 7 (11.67%) WCF
4 7 (11.67%) XML
5 6 (10.00%) ASP.NET MVC
5 6 (10.00%) WPF
6 5 (8.33%) Web Services
7 3 (5.00%) ASP.NET Web Forms
7 3 (5.00%) MDX
7 3 (5.00%) WinForms
8 2 (3.33%) Ajax
8 2 (3.33%) ASP.NET Web API
8 2 (3.33%) JMS
8 2 (3.33%) LINQ
8 2 (3.33%) Middleware
8 2 (3.33%) Spring
Miscellaneous
1 6 (10.00%) Data Extraction
2 3 (5.00%) Analytical Skills
2 3 (5.00%) Data Structures
2 3 (5.00%) Visualisation
3 2 (3.33%) Data Integration
4 1 (1.67%) Hedge funds
4 1 (1.67%) Statistics
Operating Systems
1 3 (5.00%) Windows
2 2 (3.33%) Windows Server
3 1 (1.67%) Linux
3 1 (1.67%) Unix
3 1 (1.67%) Windows Server 2012
Processes & Methodologies
1 14 (23.33%) Agile Software Development
1 14 (23.33%) Business Intelligence
2 13 (21.67%) MVC
3 10 (16.67%) ETL
3 10 (16.67%) Migration
4 6 (10.00%) Data Modelling
4 6 (10.00%) Kimball Methodology
5 5 (8.33%) Performance Tuning
6 4 (6.67%) ETL Development
6 4 (6.67%) Unit Testing
7 3 (5.00%) Analytics
7 3 (5.00%) CRM
7 3 (5.00%) Data Deduplication
7 3 (5.00%) Data Visualisation
7 3 (5.00%) ERP
7 3 (5.00%) High Availability
7 3 (5.00%) OO
7 3 (5.00%) SDLC
7 3 (5.00%) Service Management
7 3 (5.00%) Technical Analysis
Programming Languages
1 60 (100.00%) SQL
2 26 (43.33%) C#
3 12 (20.00%) JavaScript
4 7 (11.67%) VB
5 5 (8.33%) Java
6 4 (6.67%) PL/SQL
6 4 (6.67%) VBA
7 3 (5.00%) Delphi
7 3 (5.00%) Python
7 3 (5.00%) VB.NET
8 2 (3.33%) PowerShell
9 1 (1.67%) XPath
Qualifications
1 1 (1.67%) Security Cleared
Quality Assurance & Compliance
1 1 (1.67%) Data Quality
1 1 (1.67%) Disclosure Scotland
Vendors
1 17 (28.33%) Microsoft
2 8 (13.33%) Oracle
3 5 (8.33%) Infor
4 4 (6.67%) Cognos
5 3 (5.00%) DevExpress
6 2 (3.33%) IBM
6 2 (3.33%) Informatica
6 2 (3.33%) Reuters
6 2 (3.33%) SAP
7 1 (1.67%) Tableau
Glasgow, Lanarkshire
Harvey Nash plc
Rate: £350 - £400 per day
Posted: Yesterday
Edinburgh, Midlothian
HAYS INFORMATION TECHNOLOGY
Rate: £275.00 - £325.00 per day
Posted: 2 days ago