Period
to 20 November 2017

The following table provides summary statistics for contract job vacancies advertised in Edinburgh 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
Scotland > Edinburgh
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 94 98 97
Rank change year-on-year +4 -1 -11
Contract jobs citing T-SQL 40 29 39
As % of all contract IT jobs advertised in Edinburgh 1.37% 1.38% 1.22%
As % of the Programming Languages category 3.86% 3.78% 4.53%
Number of daily rates quoted 25 23 30
Edinburgh median daily rate £405 £350 £375
Median daily rate % change year-on-year +15.71% -6.67% -6.25%
10th Percentile £348 £277 £263
90th Percentile £467 £425 £600
Scotland median daily rate £400 £350 £350
% change year-on-year +14.29% - -6.67%
Number of hourly rates quoted 0 4 1
Edinburgh median hourly rate - £46.13 £42.50
Median hourly rate % change year-on-year - +8.53% -
Scotland median hourly rate £190.00 £46.13 £42.50
% change year-on-year +311.92% +8.53% -

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

All Programming Languages
Edinburgh
Contract vacancies with a requirement for coding skills 1035 768 861
As % of all contract IT jobs advertised in Edinburgh 35.57% 36.45% 26.89%
Number of daily rates quoted 633 479 500
Edinburgh median daily rate £388 £375 £375
Median daily rate % change year-on-year +3.33% - -3.23%
10th Percentile £286 £275 £263
90th Percentile £538 £488 £538
Scotland median daily rate £388 £350 £350
% change year-on-year +10.71% - -6.67%
Number of hourly rates quoted 10 11 12
Edinburgh median hourly rate £30.50 £47.25 £28.96
Median hourly rate % change year-on-year -35.45% +63.14% -17.25%
10th Percentile £20.20 £41.25 £15.00
90th Percentile £43.39 £52.00 £40.38
Scotland median hourly rate £27.00 £40.00 £37.50
% change year-on-year -32.50% +6.67% +7.14%

T-SQL
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for T-SQL in Edinburgh

T-SQL
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for T-SQL in Edinburgh

T-SQL
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing T-SQL in Edinburgh over the 6 months to 20 November 2017.

Contractor daily rate histogram for T-SQL in Edinburgh

T-SQL
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for T-SQL in Edinburgh

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 Edinburgh region with a requirement for T-SQL.

1 40 (100.00%) SQL
2 34 (85.00%) SQL Server
3 22 (55.00%) Microsoft
4 17 (42.50%) Business Intelligence
5 16 (40.00%) SQL Server Analysis Services
6 15 (37.50%) SQL Server Reporting Services
7 14 (35.00%) .NET
8 12 (30.00%) ASP.NET
8 12 (30.00%) Data Warehouse
9 11 (27.50%) C#
9 11 (27.50%) SQL Server 2012
10 10 (25.00%) SharePoint
11 9 (22.50%) PowerPivot
12 8 (20.00%) Analytical Skills
12 8 (20.00%) Finance
13 7 (17.50%) Data Modelling
13 7 (17.50%) XML
13 7 (17.50%) MVC
13 7 (17.50%) SQL Server Integration Services
13 7 (17.50%) Data Integration
13 7 (17.50%) Power BI
14 6 (15.00%) SQL Server 2008
14 6 (15.00%) Team Foundation Server
14 6 (15.00%) Agile Software Development
14 6 (15.00%) CSS
14 6 (15.00%) Web Services
14 6 (15.00%) HTML
14 6 (15.00%) ETL
15 5 (12.50%) JavaScript
15 5 (12.50%) VB.NET

T-SQL
Co-occurring IT Skills in Edinburgh 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 (25.00%) SharePoint
2 3 (7.50%) ColdFusion
3 1 (2.50%) BizTalk Server
Applications
1 3 (7.50%) Microsoft Office
Business Applications
1 2 (5.00%) Dynamics CRM
Database & Business Intelligence
1 34 (85.00%) SQL Server
2 16 (40.00%) SQL Server Analysis Services
3 15 (37.50%) SQL Server Reporting Services
4 12 (30.00%) Data Warehouse
5 11 (27.50%) SQL Server 2012
6 9 (22.50%) PowerPivot
7 7 (17.50%) Power BI
7 7 (17.50%) SQL Server Integration Services
8 6 (15.00%) SQL Server 2008
9 4 (10.00%) SQL Server 2005
10 3 (7.50%) Data Mining
10 3 (7.50%) MySQL
10 3 (7.50%) SQL Server 2000
11 1 (2.50%) Business Intelligence Development Studio
11 1 (2.50%) Oracle Database 11g
11 1 (2.50%) Oracle Database 12c
11 1 (2.50%) Oracle Reports
11 1 (2.50%) PostgreSQL
11 1 (2.50%) SQL Server 2014
11 1 (2.50%) SQL Server 2016
Development Applications
1 6 (15.00%) Team Foundation Server
2 3 (7.50%) Git (software)
2 3 (7.50%) NUnit
2 3 (7.50%) Visual Studio
3 2 (5.00%) JIRA
3 2 (5.00%) Redmine
3 2 (5.00%) SpecFlow
4 1 (2.50%) CruiseControl
4 1 (2.50%) PowerBuilder
4 1 (2.50%) SQL Server Management Studio (SSMS)
4 1 (2.50%) Subversion
4 1 (2.50%) Toad
General
1 8 (20.00%) Finance
2 5 (12.50%) Banking
3 1 (2.50%) Advertising
3 1 (2.50%) Retail Banking
Job Titles
1 31 (77.50%) Developer
2 11 (27.50%) .NET Developer
2 11 (27.50%) SQL Developer
3 10 (25.00%) Business Intelligence Developer
4 7 (17.50%) Analyst
5 6 (15.00%) SQL Server Developer
6 5 (12.50%) C# Developer
6 5 (12.50%) VB.NET Developer
7 4 (10.00%) Analyst Developer
7 4 (10.00%) C# .NET Developer
7 4 (10.00%) Senior Developer
7 4 (10.00%) SQL Analyst
7 4 (10.00%) SQL BI Developer
7 4 (10.00%) Technical Developer
8 3 (7.50%) DBA
8 3 (7.50%) Senior .NET Developer
8 3 (7.50%) Senior C# .NET Developer
8 3 (7.50%) Senior C# Developer
8 3 (7.50%) SSAS Developer
8 3 (7.50%) SSIS Developer
Libraries, Frameworks & Software Standards
1 14 (35.00%) .NET
2 12 (30.00%) ASP.NET
3 7 (17.50%) XML
4 6 (15.00%) CSS
4 6 (15.00%) HTML
4 6 (15.00%) Web Services
5 5 (12.50%) .NET Framework
6 4 (10.00%) jQuery
7 3 (7.50%) Ajax
7 3 (7.50%) JSON
7 3 (7.50%) XSLT
8 2 (5.00%) ASP.NET MVC
8 2 (5.00%) ASP.NET Web API
8 2 (5.00%) LESS
8 2 (5.00%) Node.js
8 2 (5.00%) Twitter Bootstrap
8 2 (5.00%) WCF
8 2 (5.00%) WinForms
8 2 (5.00%) WPF
9 1 (2.50%) Entity Framework
Miscellaneous
1 8 (20.00%) Analytical Skills
2 4 (10.00%) Greenfield Project
3 1 (2.50%) Data Structures
3 1 (2.50%) Derivative
3 1 (2.50%) Enterprise Software
3 1 (2.50%) Swaptions
Operating Systems
1 4 (10.00%) Windows
2 1 (2.50%) Unix
Processes & Methodologies
1 17 (42.50%) Business Intelligence
2 7 (17.50%) Data Integration
2 7 (17.50%) Data Modelling
2 7 (17.50%) MVC
3 6 (15.00%) Agile Software Development
3 6 (15.00%) ETL
4 5 (12.50%) Web Development
5 4 (10.00%) Scrum
6 3 (7.50%) Continuous Improvement
6 3 (7.50%) Kanban
6 3 (7.50%) Mentoring
6 3 (7.50%) User Acceptance Testing
6 3 (7.50%) Visualisation
7 2 (5.00%) BDD
7 2 (5.00%) Continuous Integration
7 2 (5.00%) Data Visualisation
7 2 (5.00%) Open Source
7 2 (5.00%) Performance Tuning
7 2 (5.00%) Stakeholder Engagement
7 2 (5.00%) Test Automation
Programming Languages
1 40 (100.00%) SQL
2 11 (27.50%) C#
3 5 (12.50%) Data Analysis Expressions (DAX)
3 5 (12.50%) JavaScript
3 5 (12.50%) PowerShell
3 5 (12.50%) VB.NET
4 4 (10.00%) PL/SQL
5 3 (7.50%) PHP
5 3 (7.50%) VB
Qualifications
1 1 (2.50%) Degree
Quality Assurance & Compliance
1 1 (2.50%) Data Quality
Vendors
1 22 (55.00%) Microsoft
2 4 (10.00%) Oracle
3 2 (5.00%) Tableau
4 1 (2.50%) Informatica
4 1 (2.50%) MicroStrategy
4 1 (2.50%) RedGate
4 1 (2.50%) Twitter