Period
to 14 December 2017

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

Transact-SQL
Scotland > Edinburgh
6 months to
14 Dec 2017
Same period 2016 Same period 2015
Rank 85 109 97
Rank change year-on-year +24 -12 -51
Permanent jobs citing T-SQL 62 26 64
As % of all permanent IT jobs advertised in Edinburgh 2.34% 1.13% 2.12%
As % of the Programming Languages category 3.92% 2.17% 5.00%
Number of salaries quoted 46 23 49
Edinburgh median annual salary £40,000 £37,500 £43,553
Median salary % change year-on-year +6.67% -13.90% +2.48%
10th Percentile £31,500 £26,250 £32,250
90th Percentile £47,500 £46,942 £55,750
Scotland median annual salary £40,000 £40,000 £42,000
% change year-on-year - -4.76% -1.18%

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 1581 1197 1281
As % of all permanent IT jobs advertised in Edinburgh 59.59% 52.04% 42.43%
Number of salaries quoted 1018 837 855
Edinburgh median annual salary £40,000 £45,000 £41,500
Median salary % change year-on-year -11.11% +8.43% +3.75%
10th Percentile £28,000 £30,000 £26,500
90th Percentile £61,250 £60,000 £58,650
Scotland median annual salary £42,500 £42,500 £40,000
% change year-on-year - +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 14 December 2017.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 14 December 2017, IT jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Edinburgh region with a requirement for T-SQL.

1 57 (91.94%) SQL Server
2 46 (74.19%) SQL
3 38 (61.29%) Microsoft
4 35 (56.45%) SQL Server Reporting Services
5 34 (54.84%) Business Intelligence
6 32 (51.61%) SQL Server Integration Services
7 26 (41.94%) ETL
8 22 (35.48%) .NET
8 22 (35.48%) SQL Server 2012
9 20 (32.26%) Tableau
9 20 (32.26%) C#
10 19 (30.65%) Finance
11 16 (25.81%) Data Warehouse
12 15 (24.19%) Team Foundation Server
12 15 (24.19%) Agile Software Development
13 14 (22.58%) Integration Testing
13 14 (22.58%) Project Management
13 14 (22.58%) System Integration Testing
14 13 (20.97%) ASP.NET
15 11 (17.74%) XML
16 10 (16.13%) VB
16 10 (16.13%) SDLC
17 9 (14.52%) SQL Server Analysis Services
18 8 (12.90%) JavaScript
18 8 (12.90%) SQL Server 2014
19 7 (11.29%) Power BI
19 7 (11.29%) HTML
19 7 (11.29%) CSS
19 7 (11.29%) PowerShell
20 6 (9.68%) SQL Server 2008

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 2 (3.23%) FileNet
2 1 (1.61%) IIS
Applications
1 2 (3.23%) Microsoft Office
Business Applications
1 5 (8.06%) Dynamics CRM
2 2 (3.23%) Dynamics AX
Cloud Services
1 2 (3.23%) Oracle Service Cloud
2 1 (1.61%) Dynamics 365
2 1 (1.61%) Microsoft Azure
Communications & Networking
1 4 (6.45%) Internet
Database & Business Intelligence
1 57 (91.94%) SQL Server
2 35 (56.45%) SQL Server Reporting Services
3 32 (51.61%) SQL Server Integration Services
4 22 (35.48%) SQL Server 2012
5 16 (25.81%) Data Warehouse
6 9 (14.52%) SQL Server Analysis Services
7 8 (12.90%) SQL Server 2014
8 7 (11.29%) Power BI
9 6 (9.68%) SQL Server 2008
10 4 (6.45%) SQL Server 2016
11 3 (4.84%) Microsoft Analysis Services
12 2 (3.23%) OLAP
12 2 (3.23%) OLTP
12 2 (3.23%) PowerPivot
13 1 (1.61%) Azure SQL Database
13 1 (1.61%) Big Data
13 1 (1.61%) RDBMS
13 1 (1.61%) Relational Database
Development Applications
1 15 (24.19%) Team Foundation Server
2 2 (3.23%) JIRA
3 1 (1.61%) Bugzilla
3 1 (1.61%) TestComplete
3 1 (1.61%) Visual Studio
General
1 19 (30.65%) Finance
2 4 (6.45%) Banking
3 2 (3.23%) Law
3 2 (3.23%) Legal
Job Titles
1 53 (85.48%) Developer
2 31 (50.00%) SQL Developer
3 28 (45.16%) Business Intelligence Developer
4 21 (33.87%) SQL BI Developer
4 21 (33.87%) SQL Server Developer
4 21 (33.87%) SSIS Developer
5 16 (25.81%) SQL Server BI Developer
6 12 (19.35%) SSRS Developer
7 8 (12.90%) .NET Developer
8 6 (9.68%) C# Developer
9 4 (6.45%) ASP.NET Developer
9 4 (6.45%) ASP.NET MVC Developer
9 4 (6.45%) C# .NET Developer
9 4 (6.45%) C# ASP.NET Developer
9 4 (6.45%) Data Warehouse Developer
9 4 (6.45%) DBA
9 4 (6.45%) Power BI Developer
10 3 (4.84%) Senior ASP.NET MVC Developer
10 3 (4.84%) Senior C# .NET Developer
10 3 (4.84%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 22 (35.48%) .NET
2 13 (20.97%) ASP.NET
3 11 (17.74%) XML
4 7 (11.29%) CSS
4 7 (11.29%) HTML
5 5 (8.06%) ASP.NET MVC
5 5 (8.06%) jQuery
6 4 (6.45%) WCF
7 3 (4.84%) AngularJS
7 3 (4.84%) JSON
7 3 (4.84%) MDX
8 2 (3.23%) RabbitMQ
8 2 (3.23%) Web Services
9 1 (1.61%) CSS3
9 1 (1.61%) HTML5
9 1 (1.61%) KnockoutJS
9 1 (1.61%) Twitter Bootstrap
Miscellaneous
1 2 (3.23%) Analytical Skills
1 2 (3.23%) Mobile App
2 1 (1.61%) Fintech
2 1 (1.61%) Greenfield Project
2 1 (1.61%) Replication
Operating Systems
1 1 (1.61%) Windows
1 1 (1.61%) Windows Server
Processes & Methodologies
1 34 (54.84%) Business Intelligence
2 26 (41.94%) ETL
3 15 (24.19%) Agile Software Development
4 14 (22.58%) Integration Testing
4 14 (22.58%) Project Management
4 14 (22.58%) System Integration Testing
5 10 (16.13%) SDLC
6 5 (8.06%) CRM
6 5 (8.06%) MVC
7 3 (4.84%) Analytics
7 3 (4.84%) Software Engineering
7 3 (4.84%) Web Development
8 2 (3.23%) Business Analysis
8 2 (3.23%) Configuration Management
8 2 (3.23%) Customer Requirements
8 2 (3.23%) Data Protection
8 2 (3.23%) Performance Management
8 2 (3.23%) Scrum
8 2 (3.23%) UML
8 2 (3.23%) Workflow
Programming Languages
1 46 (74.19%) SQL
2 20 (32.26%) C#
3 10 (16.13%) VB
4 8 (12.90%) JavaScript
5 7 (11.29%) PowerShell
6 4 (6.45%) PHP
6 4 (6.45%) VB.NET
6 4 (6.45%) VB6
7 2 (3.23%) VBA
8 1 (1.61%) C
8 1 (1.61%) Data Analysis Expressions (DAX)
Qualifications
1 6 (9.68%) Degree
2 1 (1.61%) ISEB
2 1 (1.61%) ISTQB
Quality Assurance & Compliance
1 2 (3.23%) QA
1 2 (3.23%) SLA
System Software
1 1 (1.61%) vSphere
Systems Management
1 1 (1.61%) Systems Management Server (SMS)
Vendors
1 38 (61.29%) Microsoft
2 20 (32.26%) Tableau
3 2 (3.23%) Oracle