Period
to 19 August 2018

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 6 months to 19 August 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Scotland > Edinburgh
6 months to
19 Aug 2018
Same period 2017 Same period 2016
Rank 101 103 113
Rank change year-on-year +2 +10 -11
Permanent jobs citing T-SQL 45 41 33
As % of all permanent IT jobs advertised in Edinburgh 1.78% 1.62% 1.32%
As % of the Programming Languages category 3.56% 2.60% 3.02%
Number of salaries quoted 26 31 26
Edinburgh median annual salary £39,250 £40,000 £45,000
Median salary % change year-on-year -1.88% -11.11% +5.88%
10th Percentile £29,250 £32,500 £33,750
90th Percentile £62,500 £47,500 £55,000
Scotland median annual salary £40,000 £40,000 £40,000

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Edinburgh with a requirement for coding skills.

All Programming Languages
Edinburgh
Permanent vacancies with a requirement for coding skills 1,264 1,575 1,094
As % of all permanent IT jobs advertised in Edinburgh 49.94% 62.11% 43.76%
Number of salaries quoted 806 946 727
Edinburgh median annual salary £45,000 £40,000 £45,000
Median salary % change year-on-year +12.50% -11.11% +12.50%
10th Percentile £29,000 £27,500 £29,460
90th Percentile £67,500 £62,500 £60,550
Scotland median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +2.41%

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
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Edinburgh.

Salary trend for T-SQL in Edinburgh

T-SQL
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing T-SQL in Edinburgh over the 6 months to 19 August 2018.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 19 August 2018, IT 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 permanent job ads across the Edinburgh region with a requirement for T-SQL.

1 45 (100.00%) SQL
2 33 (73.33%) SQL Server
3 26 (57.78%) C#
4 24 (53.33%) .NET
5 22 (48.89%) Microsoft
5 22 (48.89%) SQL Server Integration Services
6 15 (33.33%) ASP.NET
7 13 (28.89%) SQL Server Reporting Services
8 12 (26.67%) Agile Software Development
8 12 (26.67%) Finance
9 11 (24.44%) Microsoft Azure
10 9 (20.00%) MVC
10 9 (20.00%) JavaScript
10 9 (20.00%) Business Intelligence
11 8 (17.78%) Data Warehouse
11 8 (17.78%) User Acceptance Testing
11 8 (17.78%) AngularJS
12 7 (15.56%) Problem-Solving
12 7 (15.56%) CRM
13 6 (13.33%) Visual Studio
13 6 (13.33%) OO
13 6 (13.33%) OOD
13 6 (13.33%) ETL
13 6 (13.33%) HTML
13 6 (13.33%) VB.NET
13 6 (13.33%) Bugzilla
13 6 (13.33%) Technical Architecture
13 6 (13.33%) Test Automation
13 6 (13.33%) ASP.NET MVC
13 6 (13.33%) Software Engineering

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 3 (6.67%) CMS
1 3 (6.67%) Umbraco
2 2 (4.44%) EPiServer
2 2 (4.44%) SAS
3 1 (2.22%) SharePoint
Business Applications
1 3 (6.67%) Dynamics CRM
Cloud Services
1 11 (24.44%) Microsoft Azure
2 2 (4.44%) Google Analytics
3 1 (2.22%) Google Cloud Platform
3 1 (2.22%) Office 365
Communications & Networking
1 1 (2.22%) SMS
Database & Business Intelligence
1 33 (73.33%) SQL Server
2 22 (48.89%) SQL Server Integration Services
3 13 (28.89%) SQL Server Reporting Services
4 8 (17.78%) Data Warehouse
5 5 (11.11%) Relational Database
5 5 (11.11%) SQL Server Analysis Services
6 4 (8.89%) SQL Server 2012
6 4 (8.89%) SQL Server 2014
7 3 (6.67%) Enterprise Data Warehouse
8 1 (2.22%) BigQuery
8 1 (2.22%) Microsoft Analysis Services
8 1 (2.22%) Power BI
8 1 (2.22%) RDBMS
8 1 (2.22%) SQL Server 2008
8 1 (2.22%) SQL Server 2016
8 1 (2.22%) SSDT
Development Applications
1 6 (13.33%) Bugzilla
1 6 (13.33%) Visual Studio
2 4 (8.89%) SQL Server Management Studio (SSMS)
2 4 (8.89%) Team Foundation Server
2 4 (8.89%) TestComplete
3 2 (4.44%) Selenium
General
1 12 (26.67%) Finance
Job Titles
1 14 (31.11%) Developer
2 12 (26.67%) Analyst
3 8 (17.78%) DBA
4 6 (13.33%) Architect
4 6 (13.33%) Technical Architect
4 6 (13.33%) Test Analyst
5 5 (11.11%) .NET Developer
5 5 (11.11%) Business Intelligence Analyst
5 5 (11.11%) Data Analyst
5 5 (11.11%) SQL DBA
5 5 (11.11%) Test Automation Engineer
5 5 (11.11%) Test Engineer
6 4 (8.89%) Administrator
6 4 (8.89%) Business Intelligence Developer
7 3 (6.67%) Business Test Analyst
7 3 (6.67%) SQL Analyst
7 3 (6.67%) SQL Data Analyst
7 3 (6.67%) SQL Server DBA
7 3 (6.67%) SSIS Analyst
7 3 (6.67%) SSRS Analyst
Libraries, Frameworks & Software Standards
1 24 (53.33%) .NET
2 15 (33.33%) ASP.NET
3 8 (17.78%) AngularJS
4 6 (13.33%) .NET Framework
4 6 (13.33%) ASP.NET MVC
4 6 (13.33%) HTML
5 4 (8.89%) jQuery
6 3 (6.67%) ASP.NET Web API
6 3 (6.67%) CSS
6 3 (6.67%) HTML5
6 3 (6.67%) RabbitMQ
6 3 (6.67%) Razor View Engine
7 2 (4.44%) Entity Framework
7 2 (4.44%) REST
7 2 (4.44%) Web Services
8 1 (2.22%) Ajax
8 1 (2.22%) XML
Miscellaneous
1 4 (8.89%) Analytical Skills
2 3 (6.67%) Replication
3 2 (4.44%) Mobile App
4 1 (2.22%) Computer Science
4 1 (2.22%) Enterprise Software
4 1 (2.22%) Fintech
Operating Systems
1 3 (6.67%) Unix
2 1 (2.22%) Windows
2 1 (2.22%) Windows Server
Processes & Methodologies
1 12 (26.67%) Agile Software Development
2 9 (20.00%) Business Intelligence
2 9 (20.00%) MVC
3 8 (17.78%) User Acceptance Testing
4 7 (15.56%) CRM
4 7 (15.56%) Problem-Solving
5 6 (13.33%) CQRS
5 6 (13.33%) Defect Management
5 6 (13.33%) ETL
5 6 (13.33%) Microservices
5 6 (13.33%) OO
5 6 (13.33%) OOD
5 6 (13.33%) Performance Tuning
5 6 (13.33%) Software Engineering
5 6 (13.33%) Technical Architecture
5 6 (13.33%) Test Automation
6 5 (11.11%) Capacity Planning
6 5 (11.11%) Data Modelling
6 5 (11.11%) Disaster Recovery
6 5 (11.11%) Security Testing
Programming Languages
1 45 (100.00%) SQL
2 26 (57.78%) C#
3 9 (20.00%) JavaScript
4 6 (13.33%) VB.NET
5 3 (6.67%) PowerShell
5 3 (6.67%) Shell Script
5 3 (6.67%) VB
6 2 (4.44%) C
6 2 (4.44%) C++
6 2 (4.44%) Java
6 2 (4.44%) TypeScript
6 2 (4.44%) VBA
7 1 (2.22%) R
7 1 (2.22%) VB6
Qualifications
1 5 (11.11%) ISEB
1 5 (11.11%) ISTQB
2 2 (4.44%) Degree
3 1 (2.22%) Numerate Degree
Quality Assurance & Compliance
1 3 (6.67%) QA
1 3 (6.67%) SLA
2 2 (4.44%) Data Quality
System Software
1 3 (6.67%) Firmware
Vendors
1 22 (48.89%) Microsoft
2 5 (11.11%) Oracle
3 4 (8.89%) Tableau
4 2 (4.44%) Google
4 2 (4.44%) Pega