Period
to 17 December 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 17 December 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Scotland > Edinburgh
6 months to
17 Dec 2018
Same period 2017 Same period 2016
Rank 102 91 108
Rank change year-on-year -11 +17 -7
Permanent jobs citing T-SQL 49 61 26
As % of all permanent IT jobs advertised in Edinburgh 1.94% 2.33% 1.15%
As % of the Programming Languages category 3.73% 3.91% 2.20%
Number of salaries quoted 30 45 23
Edinburgh median annual salary £40,000 £40,000 £37,500
Median salary % change year-on-year - +6.67% -14.34%
10th Percentile £26,250 £31,400 £26,250
90th Percentile £47,500 £47,500 £46,942
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,312 1,559 1,182
As % of all permanent IT jobs advertised in Edinburgh 52.06% 59.53% 52.32%
Number of salaries quoted 825 1,005 823
Edinburgh median annual salary £45,000 £41,000 £45,000
Median salary % change year-on-year +9.76% -8.89% +8.43%
10th Percentile £29,750 £28,000 £29,750
90th Percentile £68,750 £61,250 £60,000
Scotland median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

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 17 December 2018.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 17 December 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 48 (97.96%) SQL
2 38 (77.55%) SQL Server
3 25 (51.02%) SQL Server Integration Services
4 24 (48.98%) Microsoft
5 18 (36.73%) .NET
6 15 (30.61%) ASP.NET
6 15 (30.61%) Performance Tuning
7 13 (26.53%) C#
8 12 (24.49%) JavaScript
8 12 (24.49%) Data Modelling
8 12 (24.49%) Relational Database
9 10 (20.41%) Test Automation
9 10 (20.41%) Statistics
9 10 (20.41%) User Acceptance Testing
9 10 (20.41%) Disaster Recovery
9 10 (20.41%) Oracle
9 10 (20.41%) SDLC
10 9 (18.37%) Defect Management
10 9 (18.37%) Storage Management
10 9 (18.37%) ETL
10 9 (18.37%) Migration
10 9 (18.37%) Bugzilla
10 9 (18.37%) Replication
10 9 (18.37%) Test Scripting
10 9 (18.37%) Capacity Planning
11 8 (16.33%) Microsoft Azure
11 8 (16.33%) Test Planning
11 8 (16.33%) Manual Testing
11 8 (16.33%) .NET Framework
11 8 (16.33%) SQL Server Reporting Services

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.12%) IIS
2 1 (2.04%) SharePoint
Cloud Services
1 8 (16.33%) Microsoft Azure
2 1 (2.04%) Amazon AWS
2 1 (2.04%) Office 365
Communications & Networking
1 3 (6.12%) DNS
Database & Business Intelligence
1 38 (77.55%) SQL Server
2 25 (51.02%) SQL Server Integration Services
3 12 (24.49%) Relational Database
4 8 (16.33%) SQL Server Reporting Services
5 6 (12.24%) SQL Server Analysis Services
5 6 (12.24%) SSDT
6 3 (6.12%) Apache Cassandra
6 3 (6.12%) Big Data
6 3 (6.12%) Crystal Reports
6 3 (6.12%) MongoDB
6 3 (6.12%) MySQL
6 3 (6.12%) NoSQL
6 3 (6.12%) Oracle Reports
6 3 (6.12%) Pentaho
7 2 (4.08%) Data Warehouse
7 2 (4.08%) SQL Server 2012
8 1 (2.04%) Enterprise Data Warehouse
8 1 (2.04%) Power BI
Development Applications
1 9 (18.37%) Bugzilla
2 8 (16.33%) Visual Studio
3 3 (6.12%) Git (software)
3 3 (6.12%) LoadRunner
4 2 (4.08%) SQL Server Management Studio (SSMS)
5 1 (2.04%) Selenium
5 1 (2.04%) Team Foundation Server
5 1 (2.04%) TestComplete
General
1 3 (6.12%) Banking
1 3 (6.12%) Finance
1 3 (6.12%) Marketing
Job Titles
1 18 (36.73%) Developer
2 12 (24.49%) DBA
3 9 (18.37%) SQL DBA
4 8 (16.33%) Administrator
4 8 (16.33%) Tester
5 7 (14.29%) Analyst
5 7 (14.29%) Automation Tester
5 7 (14.29%) SQL Developer
6 5 (10.20%) .NET Developer
6 5 (10.20%) Software Developer
6 5 (10.20%) T-SQL Developer
7 4 (8.16%) Database Developer
7 4 (8.16%) SQL Database Developer
7 4 (8.16%) SQL Server DBA
8 3 (6.12%) Consultant
8 3 (6.12%) Data Analyst
8 3 (6.12%) Data Consultant
8 3 (6.12%) Microsoft Consultant
8 3 (6.12%) Test Analyst
9 2 (4.08%) C# Developer
Libraries, Frameworks & Software Standards
1 18 (36.73%) .NET
2 15 (30.61%) ASP.NET
3 8 (16.33%) .NET Framework
4 6 (12.24%) CSS
4 6 (12.24%) HTML
4 6 (12.24%) XML
5 5 (10.20%) jQuery
6 4 (8.16%) Ajax
6 4 (8.16%) AngularJS
6 4 (8.16%) Web Services
7 2 (4.08%) Entity Framework
7 2 (4.08%) JSON
7 2 (4.08%) RabbitMQ
Miscellaneous
1 9 (18.37%) Replication
2 6 (12.24%) Greenfield Project
3 3 (6.12%) Analytical Skills
3 3 (6.12%) Management Information System
4 2 (4.08%) Virtual Team
5 1 (2.04%) Mobile App
Operating Systems
1 3 (6.12%) Unix
Processes & Methodologies
1 15 (30.61%) Performance Tuning
2 12 (24.49%) Data Modelling
3 10 (20.41%) Disaster Recovery
3 10 (20.41%) SDLC
3 10 (20.41%) Statistics
3 10 (20.41%) Test Automation
3 10 (20.41%) User Acceptance Testing
4 9 (18.37%) Capacity Planning
4 9 (18.37%) Defect Management
4 9 (18.37%) ETL
4 9 (18.37%) Migration
4 9 (18.37%) Storage Management
4 9 (18.37%) Test Scripting
5 8 (16.33%) API Testing
5 8 (16.33%) Business Intelligence
5 8 (16.33%) Manual Testing
5 8 (16.33%) Test Planning
6 7 (14.29%) Agile Software Development
7 6 (12.24%) Web Development
8 5 (10.20%) Analytics
Programming Languages
1 48 (97.96%) SQL
2 13 (26.53%) C#
3 12 (24.49%) JavaScript
4 4 (8.16%) VB.NET
5 3 (6.12%) PowerShell
5 3 (6.12%) Shell Script
6 2 (4.08%) TypeScript
7 1 (2.04%) F#
7 1 (2.04%) Python
7 1 (2.04%) R
7 1 (2.04%) VB
7 1 (2.04%) VB6
Qualifications
1 3 (6.12%) Degree
2 1 (2.04%) ISEB
2 1 (2.04%) ISTQB
Quality Assurance & Compliance
1 3 (6.12%) GDPR
1 3 (6.12%) SLA
2 1 (2.04%) QA
System Software
1 3 (6.12%) Active Directory
1 3 (6.12%) Firmware
Vendors
1 24 (48.98%) Microsoft
2 10 (20.41%) Oracle
3 3 (6.12%) HP
4 1 (2.04%) Xamarin