Period
to 24 April 2019

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 24 April 2019 with a comparison to the same period in the previous 2 years.

Transact-SQL
Scotland > Edinburgh
6 months to
24 Apr 2019
Same period 2018 Same period 2017
Rank 93 98 109
Rank change year-on-year +5 +11 -15
Permanent jobs citing T-SQL 63 52 30
As % of all permanent IT jobs advertised in Edinburgh 2.40% 1.97% 1.37%
As % of the Programming Languages category 4.34% 3.90% 2.30%
Number of salaries quoted 46 34 25
Edinburgh median annual salary £38,750 £40,000 £40,000
Median salary % change year-on-year -3.13% - -9.09%
10th Percentile £29,750 £29,825 £34,500
90th Percentile £48,750 £62,500 £45,750
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,453 1,333 1,302
As % of all permanent IT jobs advertised in Edinburgh 55.27% 50.53% 59.37%
Number of salaries quoted 939 914 823
Edinburgh median annual salary £43,000 £44,500 £42,500
Median salary % change year-on-year -3.37% +4.71% -
10th Percentile £27,750 £28,000 £28,750
90th Percentile £65,000 £67,000 £62,500
Scotland median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +3.66%

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 24 April 2019.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 24 April 2019, 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 60 (95.24%) SQL
2 49 (77.78%) SQL Server
3 28 (44.44%) SQL Server Reporting Services
3 28 (44.44%) SQL Server Integration Services
4 27 (42.86%) Business Intelligence
5 25 (39.68%) Visual Studio
6 21 (33.33%) .NET
7 19 (30.16%) Microsoft
8 18 (28.57%) ETL
8 18 (28.57%) Agile Software Development
9 16 (25.40%) Team Foundation Server
10 15 (23.81%) Data Warehouse
11 14 (22.22%) SQL Server Management Studio (SSMS)
12 12 (19.05%) ASP.NET
13 11 (17.46%) System Testing
13 11 (17.46%) Regression Testing
13 11 (17.46%) Relational Database
14 10 (15.87%) JavaScript
14 10 (15.87%) Windows
14 10 (15.87%) .NET Framework
15 9 (14.29%) Test Management
15 9 (14.29%) Test Automation
15 9 (14.29%) IIS
15 9 (14.29%) HTML
15 9 (14.29%) CSS
15 9 (14.29%) XML
15 9 (14.29%) Banking
15 9 (14.29%) Test Planning
15 9 (14.29%) Change Data Capture
15 9 (14.29%) Bug Management

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 9 (14.29%) IIS
Applications
1 2 (3.17%) Chatbot
Cloud Services
1 6 (9.52%) SaaS
2 4 (6.35%) Microsoft Azure
Communications & Networking
1 7 (11.11%) DNS
2 2 (3.17%) Firewall
Database & Business Intelligence
1 49 (77.78%) SQL Server
2 28 (44.44%) SQL Server Integration Services
2 28 (44.44%) SQL Server Reporting Services
3 15 (23.81%) Data Warehouse
4 11 (17.46%) Relational Database
5 8 (12.70%) Enterprise Data Warehouse
6 6 (9.52%) Big Data
7 5 (7.94%) OLAP
7 5 (7.94%) OLTP
7 5 (7.94%) SQL Server 2012
8 4 (6.35%) Apache Cassandra
8 4 (6.35%) Crystal Reports
8 4 (6.35%) MongoDB
8 4 (6.35%) MySQL
8 4 (6.35%) NoSQL
8 4 (6.35%) Oracle Reports
8 4 (6.35%) Pentaho
9 1 (1.59%) QlikView
9 1 (1.59%) SQL Server 2014
9 1 (1.59%) SQL Server 2016
Development Applications
1 25 (39.68%) Visual Studio
2 16 (25.40%) Team Foundation Server
3 14 (22.22%) SQL Server Management Studio (SSMS)
4 7 (11.11%) LoadRunner
5 6 (9.52%) Bugzilla
6 4 (6.35%) Git (software)
7 1 (1.59%) Cucumber
7 1 (1.59%) MSTest
7 1 (1.59%) NUnit
7 1 (1.59%) Protractor
7 1 (1.59%) Selenium
7 1 (1.59%) TeamCity
General
1 9 (14.29%) Banking
2 4 (6.35%) Finance
3 3 (4.76%) Games
4 2 (3.17%) Investment Banking
4 2 (3.17%) Legal
4 2 (3.17%) Retail
Job Titles
1 31 (49.21%) Analyst
2 22 (34.92%) Developer
3 17 (26.98%) Test Analyst
4 15 (23.81%) Business Intelligence Analyst
4 15 (23.81%) Senior Analyst
4 15 (23.81%) Senior Test Analyst
5 12 (19.05%) Senior Business Intelligence Analyst
6 11 (17.46%) Business Test Analyst
7 10 (15.87%) SQL Analyst
8 9 (14.29%) .NET Developer
8 9 (14.29%) SQL Developer
8 9 (14.29%) Support Analyst
9 8 (12.70%) Tester
10 6 (9.52%) Automation Tester
10 6 (9.52%) SQL Support Analyst
11 5 (7.94%) VB.NET Developer
12 4 (6.35%) Data Analyst
13 3 (4.76%) Applications Support
13 3 (4.76%) Applications Support Analyst
13 3 (4.76%) C# Developer
Libraries, Frameworks & Software Standards
1 21 (33.33%) .NET
2 12 (19.05%) ASP.NET
3 10 (15.87%) .NET Framework
4 9 (14.29%) CSS
4 9 (14.29%) HTML
4 9 (14.29%) XML
5 7 (11.11%) Ajax
5 7 (11.11%) jQuery
5 7 (11.11%) Web Services
6 3 (4.76%) AngularJS
7 2 (3.17%) Elastic Stack
7 2 (3.17%) Entity Framework
7 2 (3.17%) JSON
7 2 (3.17%) WinForms
7 2 (3.17%) WPF
8 1 (1.59%) WCF
Miscellaneous
1 6 (9.52%) Management Information System
2 5 (7.94%) Analytical Skills
3 3 (4.76%) Greenfield Project
4 2 (3.17%) Robotics
5 1 (1.59%) Fintech
Operating Systems
1 10 (15.87%) Windows
2 2 (3.17%) Android
2 2 (3.17%) Unix
2 2 (3.17%) Windows Server
Processes & Methodologies
1 27 (42.86%) Business Intelligence
2 18 (28.57%) Agile Software Development
2 18 (28.57%) ETL
3 11 (17.46%) Regression Testing
3 11 (17.46%) System Testing
4 9 (14.29%) Bug Management
4 9 (14.29%) Change Data Capture
4 9 (14.29%) Defect Management
4 9 (14.29%) Test Automation
4 9 (14.29%) Test Management
4 9 (14.29%) Test Planning
5 7 (11.11%) Analytics
5 7 (11.11%) API Testing
5 7 (11.11%) Manual Testing
5 7 (11.11%) Performance Testing
5 7 (11.11%) Release Management
5 7 (11.11%) Test Scripting
5 7 (11.11%) Web Development
6 6 (9.52%) Computer Science
6 6 (9.52%) User Acceptance Testing
Programming Languages
1 60 (95.24%) SQL
2 10 (15.87%) JavaScript
3 8 (12.70%) C#
3 8 (12.70%) Java
3 8 (12.70%) PowerShell
3 8 (12.70%) Python
4 7 (11.11%) VB.NET
5 2 (3.17%) F#
5 2 (3.17%) R
5 2 (3.17%) TypeScript
Qualifications
1 6 (9.52%) Degree
Quality Assurance & Compliance
1 4 (6.35%) GDPR
2 1 (1.59%) QA
System Software
1 7 (11.11%) Active Directory
2 2 (3.17%) VMware Infrastructure
2 2 (3.17%) XenApp
Vendors
1 19 (30.16%) Microsoft
2 7 (11.11%) HP
3 4 (6.35%) Oracle
4 2 (3.17%) Blue Prism
4 2 (3.17%) Cognizant
4 2 (3.17%) F5
4 2 (3.17%) VMware
4 2 (3.17%) Xamarin
5 1 (1.59%) Aderant
5 1 (1.59%) iManage
5 1 (1.59%) Intapp