Period
to 22 February 2018

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 22 February 2018 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
22 Feb 2018
Same period 2017 Same period 2016
Rank 108 82 92
Rank change year-on-year -26 +10 -14
Contract jobs citing T-SQL 36 25 44
As % of all contract IT jobs advertised in Edinburgh 1.21% 1.41% 1.46%
As % of the Programming Languages category 3.44% 3.32% 4.93%
Number of daily rates quoted 24 18 30
Edinburgh median daily rate £400 £350 £340
Median daily rate % change year-on-year +14.29% +2.94% -15.00%
10th Percentile £338 £275 £299
90th Percentile £454 £490 £600
Scotland median daily rate £375 £350 £350
% change year-on-year +7.14% - -
Number of hourly rates quoted 0 1 0
Edinburgh median hourly rate - £45.00 -
Scotland median hourly rate - £45.00 £22.50
% change year-on-year - +100.00% -52.63%

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 1,047 752 893
As % of all contract IT jobs advertised in Edinburgh 35.13% 42.39% 29.62%
Number of daily rates quoted 660 481 512
Edinburgh median daily rate £400 £388 £400
Median daily rate % change year-on-year +3.23% -3.13% +6.67%
10th Percentile £313 £263 £263
90th Percentile £568 £500 £550
Scotland median daily rate £400 £360 £375
% change year-on-year +11.11% -4.00% -
Number of hourly rates quoted 9 13 9
Edinburgh median hourly rate £21.00 £52.00 £32.43
Median hourly rate % change year-on-year -59.62% +60.37% -14.67%
10th Percentile £16.18 £23.60 £21.80
90th Percentile £36.50 £52.17 £41.25
Scotland median hourly rate £20.21 £43.50 £37.50
% change year-on-year -53.54% +16.00% +38.89%

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 22 February 2018.

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 22 February 2018, IT contractor jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Edinburgh region with a requirement for T-SQL.

1 36 (100.00%) SQL
2 29 (80.56%) SQL Server
3 19 (52.78%) Microsoft
4 17 (47.22%) Business Intelligence
5 15 (41.67%) Data Warehouse
6 14 (38.89%) SQL Server Reporting Services
7 12 (33.33%) SQL Server Analysis Services
8 11 (30.56%) C#
9 10 (27.78%) SQL Server Integration Services
10 9 (25.00%) .NET
10 9 (25.00%) ASP.NET
10 9 (25.00%) SQL Server 2012
11 8 (22.22%) SharePoint
11 8 (22.22%) Finance
11 8 (22.22%) SQL Server 2008
11 8 (22.22%) PowerPivot
12 7 (19.44%) Data Integration
12 7 (19.44%) PowerShell
12 7 (19.44%) ETL
13 6 (16.67%) Windows
13 6 (16.67%) MVC
13 6 (16.67%) Team Foundation Server
13 6 (16.67%) Analytical Skills
14 5 (13.89%) Power BI
14 5 (13.89%) XML
14 5 (13.89%) Data Modelling
15 4 (11.11%) CSS
15 4 (11.11%) Web Services
15 4 (11.11%) HTML
15 4 (11.11%) Agile Software Development

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 8 (22.22%) SharePoint
2 3 (8.33%) ColdFusion
Applications
1 2 (5.56%) Microsoft Office
Business Applications
1 1 (2.78%) Dynamics AX
1 1 (2.78%) Dynamics CRM
Database & Business Intelligence
1 29 (80.56%) SQL Server
2 15 (41.67%) Data Warehouse
3 14 (38.89%) SQL Server Reporting Services
4 12 (33.33%) SQL Server Analysis Services
5 10 (27.78%) SQL Server Integration Services
6 9 (25.00%) SQL Server 2012
7 8 (22.22%) PowerPivot
7 8 (22.22%) SQL Server 2008
8 5 (13.89%) Power BI
9 3 (8.33%) MySQL
9 3 (8.33%) SQL Server 2005
10 2 (5.56%) Relational Database
11 1 (2.78%) Biml
11 1 (2.78%) Business Intelligence Development Studio
11 1 (2.78%) Data Mart
11 1 (2.78%) Data Mining
11 1 (2.78%) Enterprise Data Warehouse
11 1 (2.78%) OLAP
11 1 (2.78%) OLTP
11 1 (2.78%) Oracle Reports
Development Applications
1 6 (16.67%) Team Foundation Server
2 3 (8.33%) Git (software)
2 3 (8.33%) NUnit
3 2 (5.56%) JIRA
3 2 (5.56%) Redmine
3 2 (5.56%) SpecFlow
4 1 (2.78%) CruiseControl
4 1 (2.78%) SQL Server Management Studio (SSMS)
4 1 (2.78%) Subversion
4 1 (2.78%) Visual Studio
General
1 8 (22.22%) Finance
2 1 (2.78%) Banking
2 1 (2.78%) Retail Banking
Job Titles
1 24 (66.67%) Developer
2 10 (27.78%) SQL Developer
3 7 (19.44%) .NET Developer
3 7 (19.44%) Business Intelligence Developer
4 6 (16.67%) SQL Server Developer
5 5 (13.89%) C# Developer
5 5 (13.89%) Senior Developer
6 4 (11.11%) C# .NET Developer
6 4 (11.11%) Consultant
6 4 (11.11%) DBA
6 4 (11.11%) SQL BI Developer
7 3 (8.33%) Analyst
7 3 (8.33%) Business Intelligence Consultant
7 3 (8.33%) Data Warehouse Developer
7 3 (8.33%) Senior .NET Developer
7 3 (8.33%) Senior C# .NET Developer
7 3 (8.33%) Senior C# Developer
7 3 (8.33%) SSAS Developer
7 3 (8.33%) SSIS Developer
7 3 (8.33%) VB.NET Developer
Libraries, Frameworks & Software Standards
1 9 (25.00%) .NET
1 9 (25.00%) ASP.NET
2 5 (13.89%) XML
3 4 (11.11%) CSS
3 4 (11.11%) HTML
3 4 (11.11%) Web Services
4 3 (8.33%) .NET Framework
4 3 (8.33%) JSON
4 3 (8.33%) XSLT
5 2 (5.56%) ASP.NET MVC
5 2 (5.56%) ASP.NET Web API
5 2 (5.56%) jQuery
5 2 (5.56%) LESS
5 2 (5.56%) Node.js
5 2 (5.56%) Twitter Bootstrap
5 2 (5.56%) WCF
5 2 (5.56%) WinForms
5 2 (5.56%) WPF
6 1 (2.78%) RabbitMQ
6 1 (2.78%) RESTful
Miscellaneous
1 6 (16.67%) Analytical Skills
2 2 (5.56%) Fixed Income
3 1 (2.78%) Data Structures
3 1 (2.78%) Derivative
3 1 (2.78%) Greenfield Project
3 1 (2.78%) Replication
3 1 (2.78%) Swaptions
Operating Systems
1 6 (16.67%) Windows
2 2 (5.56%) Windows Server
Processes & Methodologies
1 17 (47.22%) Business Intelligence
2 7 (19.44%) Data Integration
2 7 (19.44%) ETL
3 6 (16.67%) MVC
4 5 (13.89%) Data Modelling
5 4 (11.11%) Agile Software Development
5 4 (11.11%) Portfolio Management
6 3 (8.33%) Continuous Improvement
6 3 (8.33%) Kanban
6 3 (8.33%) Kimball Methodology
6 3 (8.33%) Mentoring
6 3 (8.33%) Performance Tuning
6 3 (8.33%) User Acceptance Testing
6 3 (8.33%) Visualisation
6 3 (8.33%) Web Development
7 2 (5.56%) Asset Management
7 2 (5.56%) Continuous Integration
7 2 (5.56%) Open Source
7 2 (5.56%) Software Engineering
7 2 (5.56%) Test Automation
Programming Languages
1 36 (100.00%) SQL
2 11 (30.56%) C#
3 7 (19.44%) PowerShell
4 3 (8.33%) JavaScript
4 3 (8.33%) PHP
4 3 (8.33%) PL/SQL
4 3 (8.33%) VB.NET
5 2 (5.56%) Data Analysis Expressions (DAX)
6 1 (2.78%) VB
6 1 (2.78%) VBA
Qualifications
1 1 (2.78%) Degree
Quality Assurance & Compliance
1 1 (2.78%) Data Quality
System Software
1 2 (5.56%) vSphere
Vendors
1 19 (52.78%) Microsoft
2 3 (8.33%) Oracle
2 3 (8.33%) Tableau
3 1 (2.78%) Informatica
3 1 (2.78%) MicroStrategy
3 1 (2.78%) RedGate
3 1 (2.78%) Twitter