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

Transact-SQL
Scotland > Edinburgh
6 months to
15 Oct 2018
Same period 2017 Same period 2016
Rank 102 102 107
Rank change year-on-year 0 +5 -8
Permanent jobs citing T-SQL 48 51 31
As % of all permanent IT jobs advertised in Edinburgh 1.91% 1.92% 1.35%
As % of the Programming Languages category 3.70% 3.13% 2.93%
Number of salaries quoted 25 40 24
Edinburgh median annual salary £40,000 £43,750 £37,500
Median salary % change year-on-year -8.57% +16.67% -11.76%
10th Percentile £29,250 £32,250 £26,250
90th Percentile £47,500 £47,625 £51,875
Scotland median annual salary £40,000 £40,000 £37,750
% change year-on-year - +5.96% -5.63%

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,296 1,629 1,059
As % of all permanent IT jobs advertised in Edinburgh 51.53% 61.38% 46.10%
Number of salaries quoted 820 1,000 728
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,250 £27,975 £28,675
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 15 October 2018.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 15 October 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 47 (97.92%) SQL
2 38 (79.17%) SQL Server
3 30 (62.50%) SQL Server Integration Services
4 29 (60.42%) Microsoft
5 19 (39.58%) .NET
6 18 (37.50%) C#
7 13 (27.08%) Performance Tuning
8 12 (25.00%) Data Modelling
8 12 (25.00%) ETL
8 12 (25.00%) SQL Server Reporting Services
9 11 (22.92%) Agile Software Development
9 11 (22.92%) ASP.NET
9 11 (22.92%) Business Intelligence
10 10 (20.83%) Disaster Recovery
10 10 (20.83%) Finance
10 10 (20.83%) User Acceptance Testing
11 9 (18.75%) SQL Server Analysis Services
11 9 (18.75%) Test Automation
11 9 (18.75%) Capacity Planning
11 9 (18.75%) Statistics
11 9 (18.75%) Migration
11 9 (18.75%) Replication
11 9 (18.75%) Visual Studio
11 9 (18.75%) JavaScript
11 9 (18.75%) Relational Database
11 9 (18.75%) Storage Management
12 8 (16.67%) Defect Management
12 8 (16.67%) Oracle
12 8 (16.67%) Bugzilla
13 7 (14.58%) Data Warehouse

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 1 (2.08%) CMS
1 1 (2.08%) SharePoint
1 1 (2.08%) Umbraco
Business Applications
1 3 (6.25%) Dynamics CRM
Cloud Services
1 7 (14.58%) Microsoft Azure
2 2 (4.17%) Google Analytics
3 1 (2.08%) Amazon AWS
3 1 (2.08%) Google Cloud Platform
3 1 (2.08%) Office 365
Communications & Networking
1 1 (2.08%) SMS
Database & Business Intelligence
1 38 (79.17%) SQL Server
2 30 (62.50%) SQL Server Integration Services
3 12 (25.00%) SQL Server Reporting Services
4 9 (18.75%) Relational Database
4 9 (18.75%) SQL Server Analysis Services
5 7 (14.58%) Data Warehouse
5 7 (14.58%) SSDT
6 4 (8.33%) SQL Server 2012
7 3 (6.25%) Enterprise Data Warehouse
8 2 (4.17%) SQL Server 2014
9 1 (2.08%) BigQuery
9 1 (2.08%) Crystal Reports
9 1 (2.08%) MongoDB
9 1 (2.08%) MySQL
9 1 (2.08%) Oracle Reports
9 1 (2.08%) Pentaho
9 1 (2.08%) Power BI
9 1 (2.08%) RDBMS
9 1 (2.08%) SQL Server 2008
9 1 (2.08%) SQL Server 2016
Development Applications
1 9 (18.75%) Visual Studio
2 8 (16.67%) Bugzilla
3 4 (8.33%) SQL Server Management Studio (SSMS)
3 4 (8.33%) Team Foundation Server
4 3 (6.25%) TestComplete
5 1 (2.08%) Git (software)
5 1 (2.08%) Selenium
General
1 10 (20.83%) Finance
2 3 (6.25%) Marketing
Job Titles
1 15 (31.25%) Developer
2 13 (27.08%) DBA
3 10 (20.83%) SQL DBA
4 8 (16.67%) Administrator
4 8 (16.67%) Analyst
5 6 (12.50%) SQL Developer
5 6 (12.50%) Test Analyst
6 5 (10.42%) T-SQL Developer
7 4 (8.33%) Business Intelligence Analyst
7 4 (8.33%) Business Intelligence Developer
7 4 (8.33%) Software Developer
7 4 (8.33%) SQL Server DBA
7 4 (8.33%) Test Automation Engineer
7 4 (8.33%) Test Engineer
7 4 (8.33%) Tester
8 3 (6.25%) .NET Developer
8 3 (6.25%) Consultant
8 3 (6.25%) Database Developer
8 3 (6.25%) Microsoft Consultant
8 3 (6.25%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 19 (39.58%) .NET
2 11 (22.92%) ASP.NET
3 7 (14.58%) .NET Framework
4 4 (8.33%) AngularJS
5 3 (6.25%) HTML
5 3 (6.25%) jQuery
6 2 (4.17%) CSS
6 2 (4.17%) RabbitMQ
6 2 (4.17%) REST
6 2 (4.17%) Web Services
7 1 (2.08%) Ajax
7 1 (2.08%) ASP.NET MVC
7 1 (2.08%) ASP.NET Web API
7 1 (2.08%) Entity Framework
7 1 (2.08%) HTML5
7 1 (2.08%) Razor View Engine
7 1 (2.08%) XML
Miscellaneous
1 9 (18.75%) Replication
2 3 (6.25%) Analytical Skills
2 3 (6.25%) Greenfield Project
3 2 (4.17%) Computer Science
3 2 (4.17%) Virtual Team
4 1 (2.08%) Enterprise Software
4 1 (2.08%) Fintech
4 1 (2.08%) Management Information System
4 1 (2.08%) Mobile App
Operating Systems
1 3 (6.25%) Unix
Processes & Methodologies
1 13 (27.08%) Performance Tuning
2 12 (25.00%) Data Modelling
2 12 (25.00%) ETL
3 11 (22.92%) Agile Software Development
3 11 (22.92%) Business Intelligence
4 10 (20.83%) Disaster Recovery
4 10 (20.83%) User Acceptance Testing
5 9 (18.75%) Capacity Planning
5 9 (18.75%) Migration
5 9 (18.75%) Statistics
5 9 (18.75%) Storage Management
5 9 (18.75%) Test Automation
6 8 (16.67%) Defect Management
7 7 (14.58%) Manual Testing
7 7 (14.58%) Problem-Solving
7 7 (14.58%) Test Planning
8 6 (12.50%) API Testing
8 6 (12.50%) SDLC
9 5 (10.42%) Analytics
9 5 (10.42%) Decision-Making
Programming Languages
1 47 (97.92%) SQL
2 18 (37.50%) C#
3 9 (18.75%) JavaScript
4 3 (6.25%) PowerShell
4 3 (6.25%) Shell Script
4 3 (6.25%) VB.NET
5 1 (2.08%) Python
5 1 (2.08%) R
5 1 (2.08%) TypeScript
5 1 (2.08%) VB
5 1 (2.08%) VB6
Qualifications
1 4 (8.33%) ISEB
1 4 (8.33%) ISTQB
2 3 (6.25%) Degree
3 1 (2.08%) Numerate Degree
Quality Assurance & Compliance
1 3 (6.25%) SLA
2 2 (4.17%) Data Quality
3 1 (2.08%) GDPR
3 1 (2.08%) QA
System Software
1 3 (6.25%) Firmware
Vendors
1 29 (60.42%) Microsoft
2 8 (16.67%) Oracle
3 2 (4.17%) Google
3 2 (4.17%) Tableau
4 1 (2.08%) Xamarin