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

Transact-SQL
Scotland > Edinburgh
6 months to
19 Feb 2018
Same period 2017 Same period 2016
Rank 91 102 86
Rank change year-on-year +11 -16 -42
Permanent jobs citing T-SQL 60 28 67
As % of all permanent IT jobs advertised in Edinburgh 2.22% 1.29% 2.41%
As % of the Programming Languages category 4.01% 2.31% 5.84%
Number of salaries quoted 41 26 54
Edinburgh median annual salary £40,000 £40,000 £42,750
Median salary % change year-on-year - -6.43% +0.59%
10th Percentile £30,000 £26,250 £31,250
90th Percentile £47,500 £45,480 £55,000
Scotland median annual salary £42,500 £40,000 £39,250
% change year-on-year +6.25% +1.91% -7.65%

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,497 1,210 1,147
As % of all permanent IT jobs advertised in Edinburgh 55.34% 55.91% 41.21%
Number of salaries quoted 1,013 783 778
Edinburgh median annual salary £42,500 £42,500 £42,500
10th Percentile £28,000 £28,750 £27,000
90th Percentile £65,000 £60,000 £60,000
Scotland median annual salary £43,500 £42,500 £40,000
% change year-on-year +2.35% +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 19 February 2018.

Salary histogram for T-SQL in Edinburgh

For the 6 months to 19 February 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 53 (88.33%) SQL Server
2 46 (76.67%) SQL
3 38 (63.33%) Microsoft
4 31 (51.67%) SQL Server Reporting Services
5 29 (48.33%) Business Intelligence
6 28 (46.67%) SQL Server Integration Services
7 25 (41.67%) ETL
8 23 (38.33%) .NET
9 21 (35.00%) C#
10 17 (28.33%) Tableau
10 17 (28.33%) SQL Server 2012
11 15 (25.00%) Finance
12 14 (23.33%) Data Warehouse
12 14 (23.33%) Agile Software Development
13 13 (21.67%) Team Foundation Server
14 12 (20.00%) ASP.NET
15 11 (18.33%) XML
15 11 (18.33%) Project Management
15 11 (18.33%) Integration Testing
15 11 (18.33%) System Integration Testing
16 8 (13.33%) JavaScript
16 8 (13.33%) VB
17 7 (11.67%) HTML
17 7 (11.67%) CSS
17 7 (11.67%) SQL Server Analysis Services
17 7 (11.67%) PowerShell
17 7 (11.67%) SDLC
17 7 (11.67%) Power BI
18 6 (10.00%) Degree
18 6 (10.00%) CRM

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.33%) FileNet
Applications
1 2 (3.33%) Microsoft Office
Business Applications
1 5 (8.33%) Dynamics CRM
2 2 (3.33%) Dynamics AX
Cloud Services
1 2 (3.33%) Oracle Service Cloud
2 1 (1.67%) Amazon AWS
2 1 (1.67%) Dynamics 365
2 1 (1.67%) Microsoft Azure
Communications & Networking
1 1 (1.67%) Remote Desktop
Database & Business Intelligence
1 53 (88.33%) SQL Server
2 31 (51.67%) SQL Server Reporting Services
3 28 (46.67%) SQL Server Integration Services
4 17 (28.33%) SQL Server 2012
5 14 (23.33%) Data Warehouse
6 7 (11.67%) Power BI
6 7 (11.67%) SQL Server Analysis Services
7 4 (6.67%) SQL Server 2008
8 3 (5.00%) Relational Database
8 3 (5.00%) SQL Server 2014
9 2 (3.33%) OLAP
9 2 (3.33%) OLTP
9 2 (3.33%) PowerPivot
10 1 (1.67%) Big Data
10 1 (1.67%) Enterprise Data Warehouse
10 1 (1.67%) GIS
10 1 (1.67%) Microsoft Analysis Services
10 1 (1.67%) Spatial Data
10 1 (1.67%) SQL Server 2016
Development Applications
1 13 (21.67%) Team Foundation Server
2 3 (5.00%) Bugzilla
2 3 (5.00%) TestComplete
2 3 (5.00%) Visual Studio
3 2 (3.33%) JIRA
4 1 (1.67%) SQL Server Management Studio (SSMS)
4 1 (1.67%) TestRail
General
1 15 (25.00%) Finance
2 2 (3.33%) Banking
2 2 (3.33%) Law
2 2 (3.33%) Legal
3 1 (1.67%) Billing
Job Titles
1 46 (76.67%) Developer
2 25 (41.67%) Business Intelligence Developer
3 23 (38.33%) SQL Developer
4 18 (30.00%) SQL BI Developer
4 18 (30.00%) SSIS Developer
5 14 (23.33%) SQL Server Developer
6 13 (21.67%) SQL Server BI Developer
7 9 (15.00%) SSRS Developer
8 7 (11.67%) .NET Developer
9 5 (8.33%) DBA
10 4 (6.67%) Data Warehouse Developer
10 4 (6.67%) Power BI Developer
11 3 (5.00%) Analyst
11 3 (5.00%) Business Intelligence Analyst
11 3 (5.00%) C# Developer
11 3 (5.00%) SQL DBA
11 3 (5.00%) SQL Server DBA
11 3 (5.00%) VB Developer
12 2 (3.33%) Analyst Developer
12 2 (3.33%) Senior Tester
Libraries, Frameworks & Software Standards
1 23 (38.33%) .NET
2 12 (20.00%) ASP.NET
3 11 (18.33%) XML
4 7 (11.67%) CSS
4 7 (11.67%) HTML
5 4 (6.67%) jQuery
5 4 (6.67%) JSON
6 3 (5.00%) AngularJS
6 3 (5.00%) ASP.NET MVC
6 3 (5.00%) MDX
6 3 (5.00%) RabbitMQ
6 3 (5.00%) Web Services
7 2 (3.33%) .NET Framework
7 2 (3.33%) KnockoutJS
7 2 (3.33%) Twitter Bootstrap
7 2 (3.33%) WCF
8 1 (1.67%) HTML5
8 1 (1.67%) LINQ
8 1 (1.67%) SOAP
8 1 (1.67%) WPF
Miscellaneous
1 3 (5.00%) Analytical Skills
1 3 (5.00%) Mobile App
2 1 (1.67%) Greenfield Project
2 1 (1.67%) Replication
Operating Systems
1 2 (3.33%) Windows
1 2 (3.33%) Windows Server
Processes & Methodologies
1 29 (48.33%) Business Intelligence
2 25 (41.67%) ETL
3 14 (23.33%) Agile Software Development
4 11 (18.33%) Integration Testing
4 11 (18.33%) Project Management
4 11 (18.33%) System Integration Testing
5 7 (11.67%) SDLC
6 6 (10.00%) CRM
7 4 (6.67%) Analytics
7 4 (6.67%) Defect Management
7 4 (6.67%) User Acceptance Testing
8 3 (5.00%) MVC
8 3 (5.00%) Test Automation
8 3 (5.00%) UML
8 3 (5.00%) Web Development
9 2 (3.33%) Business Analysis
9 2 (3.33%) Configuration Management
9 2 (3.33%) Performance Management
9 2 (3.33%) Software Engineering
9 2 (3.33%) Workflow
Programming Languages
1 46 (76.67%) SQL
2 21 (35.00%) C#
3 8 (13.33%) JavaScript
3 8 (13.33%) VB
4 7 (11.67%) PowerShell
5 4 (6.67%) VB6
6 3 (5.00%) PHP
6 3 (5.00%) VB.NET
7 2 (3.33%) VBA
8 1 (1.67%) C
8 1 (1.67%) Data Analysis Expressions (DAX)
Qualifications
1 6 (10.00%) Degree
2 3 (5.00%) ISEB
2 3 (5.00%) ISTQB
Quality Assurance & Compliance
1 2 (3.33%) QA
1 2 (3.33%) SLA
System Software
1 1 (1.67%) vSphere
Systems Management
1 2 (3.33%) Systems Management Server (SMS)
Vendors
1 38 (63.33%) Microsoft
2 17 (28.33%) Tableau
3 2 (3.33%) Oracle
4 1 (1.67%) Axosoft