Period
to 20 November 2017

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 6 months to 20 November 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
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 122 117 119
Rank change year-on-year -5 +2 -15
Contract jobs citing T-SQL 65 58 87
As % of all contract IT jobs advertised in Scotland 1.31% 1.35% 1.40%
As % of the Programming Languages category 3.40% 3.34% 4.53%
Number of daily rates quoted 42 45 62
Scotland median daily rate £400 £350 £350
Median daily rate % change year-on-year +14.29% - -6.67%
10th Percentile £258 £279 £266
90th Percentile £475 £420 £571
UK median daily rate £414 £375 £375
% change year-on-year +10.33% - +7.14%
Number of hourly rates quoted 4 4 1
Scotland median hourly rate £190.00 £46.13 £42.50
Median hourly rate % change year-on-year +311.92% +8.53% -
10th Percentile £185.00 £42.38 £41.25
90th Percentile £195.00 £48.38 £43.75
UK median hourly rate £27.25 £40.00 £23.75
% change year-on-year -31.88% +68.42% -34.03%

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 Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Contract vacancies with a requirement for coding skills 1909 1735 1920
As % of all contract IT jobs advertised in Scotland 38.36% 40.39% 30.98%
Number of daily rates quoted 1146 1050 1043
Scotland median daily rate £388 £350 £350
Median daily rate % change year-on-year +10.71% - -6.67%
10th Percentile £283 £263 £260
90th Percentile £525 £475 £500
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 28 31 45
Scotland median hourly rate £27.00 £40.00 £37.50
Median hourly rate % change year-on-year -32.50% +6.67% +7.14%
10th Percentile £15.09 £14.85 £14.48
90th Percentile £195.00 £52.00 £55.00
UK median hourly rate £40.00 £37.50 £37.50
% change year-on-year +6.67% - +21.95%

T-SQL
Job Vacancy Trend in Scotland

Job postings citing T-SQL as a percentage of all IT jobs advertised in Scotland.

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 6 months to 20 November 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 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +4 40 £405 +15.71% 5
Glasgow -4 17 £318 -7.64% 2
Inverclyde - 5 £325 -
West Lothian -6 1 £338 -
Aberdeen -7 1 £425 -
T-SQL
UK

For the 6 months to 20 November 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 58 (89.23%) SQL
2 55 (84.62%) SQL Server
3 26 (40.00%) Microsoft
4 21 (32.31%) Business Intelligence
5 19 (29.23%) .NET
5 19 (29.23%) Data Warehouse
5 19 (29.23%) SQL Server Reporting Services
5 19 (29.23%) SQL Server 2012
6 18 (27.69%) SQL Server Analysis Services
7 15 (23.08%) Agile Software Development
8 14 (21.54%) SQL Server Integration Services
8 14 (21.54%) C#
8 14 (21.54%) ETL
9 13 (20.00%) Data Modelling
10 12 (18.46%) ASP.NET
11 10 (15.38%) SharePoint
11 10 (15.38%) Analytical Skills
12 9 (13.85%) Power BI
12 9 (13.85%) PowerPivot
12 9 (13.85%) Finance
12 9 (13.85%) XML
13 8 (12.31%) MVC
13 8 (12.31%) SQL Server 2008
14 7 (10.77%) Git (software)
14 7 (10.77%) Team Foundation Server
14 7 (10.77%) Data Integration
14 7 (10.77%) PowerShell
14 7 (10.77%) Relational Database
14 7 (10.77%) SQL Server Management Studio (SSMS)
14 7 (10.77%) Web Services

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 10 (15.38%) SharePoint
2 3 (4.62%) ColdFusion
3 2 (3.08%) BizTalk Server
Applications
1 4 (6.15%) Microsoft Office
Business Applications
1 2 (3.08%) Dynamics CRM
Cloud Services
1 3 (4.62%) Microsoft Azure
2 1 (1.54%) PaaS
Database & Business Intelligence
1 55 (84.62%) SQL Server
2 19 (29.23%) Data Warehouse
2 19 (29.23%) SQL Server 2012
2 19 (29.23%) SQL Server Reporting Services
3 18 (27.69%) SQL Server Analysis Services
4 14 (21.54%) SQL Server Integration Services
5 9 (13.85%) Power BI
5 9 (13.85%) PowerPivot
6 8 (12.31%) SQL Server 2008
7 7 (10.77%) Relational Database
8 6 (9.23%) RDBMS
9 4 (6.15%) SQL Server 2005
9 4 (6.15%) Sybase ASE
10 3 (4.62%) Data Mining
10 3 (4.62%) MySQL
10 3 (4.62%) SQL Server 2000
10 3 (4.62%) SQL Server 2014
10 3 (4.62%) SQL Server 2016
11 1 (1.54%) Biml
11 1 (1.54%) Enterprise Data Warehouse
Development Applications
1 7 (10.77%) Git (software)
1 7 (10.77%) SQL Server Management Studio (SSMS)
1 7 (10.77%) Team Foundation Server
2 4 (6.15%) JIRA
2 4 (6.15%) Visual Studio
3 3 (4.62%) NUnit
4 2 (3.08%) Redmine
4 2 (3.08%) SpecFlow
4 2 (3.08%) Subversion
5 1 (1.54%) CruiseControl
5 1 (1.54%) PowerBuilder
5 1 (1.54%) Toad
General
1 9 (13.85%) Finance
2 6 (9.23%) Banking
3 1 (1.54%) Advertising
3 1 (1.54%) Investment Banking
3 1 (1.54%) Law
3 1 (1.54%) Retail
3 1 (1.54%) Retail Banking
Job Titles
1 42 (64.62%) Developer
2 15 (23.08%) SQL Developer
3 13 (20.00%) .NET Developer
3 13 (20.00%) Analyst
4 11 (16.92%) Business Intelligence Developer
5 6 (9.23%) DBA
5 6 (9.23%) SQL Analyst
5 6 (9.23%) SQL Server Developer
6 5 (7.69%) C# Developer
6 5 (7.69%) Data Analyst
6 5 (7.69%) Senior Developer
6 5 (7.69%) VB.NET Developer
7 4 (6.15%) 2nd Line Support
7 4 (6.15%) Analyst Developer
7 4 (6.15%) C# .NET Developer
7 4 (6.15%) SAP Engineer
7 4 (6.15%) SQL BI Developer
7 4 (6.15%) SQL Server Analyst
7 4 (6.15%) Technical Developer
8 3 (4.62%) Senior C# .NET Developer
Libraries, Frameworks & Software Standards
1 19 (29.23%) .NET
2 12 (18.46%) ASP.NET
3 9 (13.85%) XML
4 7 (10.77%) .NET Framework
4 7 (10.77%) CSS
4 7 (10.77%) HTML
4 7 (10.77%) Web Services
5 4 (6.15%) jQuery
5 4 (6.15%) JSON
5 4 (6.15%) XSLT
6 3 (4.62%) Ajax
6 3 (4.62%) Entity Framework
6 3 (4.62%) WCF
7 2 (3.08%) ASP.NET MVC
7 2 (3.08%) ASP.NET Web API
7 2 (3.08%) LESS
7 2 (3.08%) Node.js
7 2 (3.08%) Twitter Bootstrap
7 2 (3.08%) WinForms
7 2 (3.08%) WPF
Miscellaneous
1 10 (15.38%) Analytical Skills
2 4 (6.15%) Greenfield Project
3 1 (1.54%) Algorithms
3 1 (1.54%) Blog
3 1 (1.54%) Data Structures
3 1 (1.54%) Derivative
3 1 (1.54%) Enterprise Software
3 1 (1.54%) Reference Data
3 1 (1.54%) Swaptions
Operating Systems
1 5 (7.69%) Unix
2 4 (6.15%) Linux
2 4 (6.15%) Solaris
2 4 (6.15%) Windows
Processes & Methodologies
1 21 (32.31%) Business Intelligence
2 15 (23.08%) Agile Software Development
3 14 (21.54%) ETL
4 13 (20.00%) Data Modelling
5 8 (12.31%) MVC
6 7 (10.77%) Data Analysis
6 7 (10.77%) Data Integration
6 7 (10.77%) Scrum
7 5 (7.69%) Kimball Methodology
7 5 (7.69%) Logical Data Model
7 5 (7.69%) Performance Tuning
7 5 (7.69%) Physical Data Model
7 5 (7.69%) Project Management
7 5 (7.69%) Waterfall
7 5 (7.69%) Web Development
8 4 (6.15%) Continuous Improvement
8 4 (6.15%) Data Mapping
8 4 (6.15%) Information Management
8 4 (6.15%) ITIL
8 4 (6.15%) SDLC
Programming Languages
1 58 (89.23%) SQL
2 14 (21.54%) C#
3 7 (10.77%) PowerShell
4 6 (9.23%) JavaScript
4 6 (9.23%) VB.NET
5 5 (7.69%) Data Analysis Expressions (DAX)
6 4 (6.15%) Korn
6 4 (6.15%) Perl
6 4 (6.15%) PL/SQL
6 4 (6.15%) Python
6 4 (6.15%) Shell Script
6 4 (6.15%) VB
7 3 (4.62%) PHP
8 1 (1.54%) TypeScript
8 1 (1.54%) VB6
Qualifications
1 1 (1.54%) Degree
Quality Assurance & Compliance
1 3 (4.62%) Data Quality
2 1 (1.54%) Disclosure Scotland
2 1 (1.54%) QA
2 1 (1.54%) SLA
System Software
1 2 (3.08%) Docker
Vendors
1 26 (40.00%) Microsoft
2 4 (6.15%) Oracle
2 4 (6.15%) SAP
2 4 (6.15%) Sybase
3 2 (3.08%) Cognos
3 2 (3.08%) RedGate
3 2 (3.08%) Tableau
4 1 (1.54%) Informatica
4 1 (1.54%) MicroStrategy
4 1 (1.54%) Twitter