Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Scotland 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 20 November 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
UK > Scotland
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 109 115 111
Rank change year-on-year +6 -4 -43
Permanent jobs citing T-SQL 135 100 147
As % of all permanent IT jobs advertised in Scotland 2.39% 1.95% 2.28%
As % of the Programming Languages category 3.90% 3.65% 4.56%
Number of salaries quoted 82 59 96
Scotland median annual salary £40,000 £38,000 £40,500
Median salary % change year-on-year +5.26% -6.17% -1.82%
10th Percentile £31,250 £26,250 £31,250
90th Percentile £48,975 £50,250 £57,500
UK median annual salary £45,000 £44,500 £42,500
% change year-on-year +1.12% +4.71% -

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 Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Permanent vacancies with a requirement for coding skills 3458 2743 3227
As % of all permanent IT jobs advertised in Scotland 61.30% 53.55% 50.14%
Number of salaries quoted 2237 1692 2010
Scotland median annual salary £42,500 £42,000 £40,000
Median salary % change year-on-year +1.19% +5.00% -
10th Percentile £28,750 £28,000 £27,500
90th Percentile £62,500 £60,000 £60,000
UK median annual salary £49,500 £47,500 £45,000
% change year-on-year +4.21% +5.56% +2.27%

T-SQL
Job Vacancy Trend in Scotland

Job postings citing T-SQL as a percentage of all IT jobs advertised in Scotland.

Job vacancy trend for T-SQL in Scotland

T-SQL
Salary Trend in Scotland

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Scotland.

Salary trend for T-SQL in Scotland

T-SQL
Salary Histogram in Scotland

The salary distribution of IT jobs citing T-SQL in Scotland over the 6 months to 20 November 2017.

Salary histogram for T-SQL in Scotland

T-SQL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Scotland region over the 6 months to 20 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +23 59 £42,500 +13.33% 5
Glasgow -19 49 £40,000 -3.03% 2
Orkney Islands - 11 - -
West Lothian +3 7 £31,250 -10.71%
Fife +4 3 £32,500 +20.37%
Inverclyde +1 2 £32,500 -
Aberdeen - 2 £60,000 -
Dundee - 1 - -
Aberdeenshire - 1 £40,000 -
South Lanarkshire - 1 £41,500 -
Lothian - 1 £43,000 -
T-SQL
UK

For the 6 months to 20 November 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 Scotland region with a requirement for T-SQL.

1 121 (89.63%) SQL Server
2 118 (87.41%) SQL
3 65 (48.15%) SQL Server Integration Services
4 64 (47.41%) SQL Server Reporting Services
5 57 (42.22%) Microsoft
6 55 (40.74%) Business Intelligence
7 39 (28.89%) Data Warehouse
7 39 (28.89%) C#
7 39 (28.89%) .NET
8 38 (28.15%) SQL Server 2012
9 35 (25.93%) Agile Software Development
9 35 (25.93%) ETL
10 29 (21.48%) Finance
11 22 (16.30%) ASP.NET
12 21 (15.56%) Unit Testing
13 20 (14.81%) MVC
14 19 (14.07%) JavaScript
14 19 (14.07%) Degree
15 18 (13.33%) Tableau
15 18 (13.33%) XML
16 17 (12.59%) Data Analysis
16 17 (12.59%) SQL Server Analysis Services
16 17 (12.59%) Team Foundation Server
17 15 (11.11%) Integration Testing
17 15 (11.11%) jQuery
17 15 (11.11%) System Integration Testing
17 15 (11.11%) HTML
17 15 (11.11%) Project Management
18 14 (10.37%) CRM
18 14 (10.37%) CSS

T-SQL
Co-occurring IT Skills in Scotland 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 7 (5.19%) IIS
2 5 (3.70%) CMS
2 5 (3.70%) Oracle Coherence
3 2 (1.48%) FileNet
4 1 (0.74%) SharePoint
Applications
1 3 (2.22%) Microsoft Office
2 2 (1.48%) Adobe Illustrator
2 2 (1.48%) Photoshop
Business Applications
1 4 (2.96%) Dynamics CRM
2 2 (1.48%) Cognos Business Intelligence
3 1 (0.74%) Cognos TM1
3 1 (0.74%) Oracle EBS
Cloud Services
1 10 (7.41%) SaaS
2 4 (2.96%) Microsoft Azure
3 2 (1.48%) Oracle Service Cloud
4 1 (0.74%) Azure Data Factory
4 1 (0.74%) Dynamics 365
Communications & Networking
1 4 (2.96%) Internet
2 2 (1.48%) Intranet
Database & Business Intelligence
1 121 (89.63%) SQL Server
2 65 (48.15%) SQL Server Integration Services
3 64 (47.41%) SQL Server Reporting Services
4 39 (28.89%) Data Warehouse
5 38 (28.15%) SQL Server 2012
6 17 (12.59%) SQL Server Analysis Services
7 11 (8.15%) Relational Database
7 11 (8.15%) SQL Server 2014
8 9 (6.67%) SQL Server 2008
9 8 (5.93%) Power BI
9 8 (5.93%) SQL Server 2016
10 5 (3.70%) MongoDB
11 4 (2.96%) Big Data
11 4 (2.96%) OLTP
11 4 (2.96%) RDBMS
11 4 (2.96%) SQL Server 2005
12 3 (2.22%) Enterprise Data Warehouse
12 3 (2.22%) Microsoft Analysis Services
13 2 (1.48%) Azure SQL Database
13 2 (1.48%) NoSQL
Development Applications
1 17 (12.59%) Team Foundation Server
2 11 (8.15%) JUnit
3 10 (7.41%) Maven
3 10 (7.41%) Visual Studio
4 9 (6.67%) Subversion
5 7 (5.19%) JIRA
6 6 (4.44%) tSQLt
7 5 (3.70%) IntelliJ
7 5 (3.70%) Jenkins
8 4 (2.96%) TeamCity
9 2 (1.48%) Dreamweaver
General
1 29 (21.48%) Finance
2 11 (8.15%) Banking
3 6 (4.44%) Investment Banking
4 3 (2.22%) Advertising
5 2 (1.48%) Back Office
5 2 (1.48%) Law
5 2 (1.48%) Legal
Job Titles
1 114 (84.44%) Developer
2 72 (53.33%) SQL Developer
3 36 (26.67%) Business Intelligence Developer
3 36 (26.67%) SQL Server Developer
4 24 (17.78%) SQL BI Developer
5 23 (17.04%) SSIS Developer
6 17 (12.59%) .NET Developer
6 17 (12.59%) SQL Server BI Developer
7 13 (9.63%) C# Developer
7 13 (9.63%) SSRS Developer
8 11 (8.15%) DBA
9 10 (7.41%) Analyst
10 9 (6.67%) Senior Developer
11 8 (5.93%) Software Developer
11 8 (5.93%) SQL DBA
12 7 (5.19%) ASP.NET Developer
12 7 (5.19%) C# .NET Developer
13 6 (4.44%) ASP.NET MVC Developer
13 6 (4.44%) C# ASP.NET Developer
13 6 (4.44%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 39 (28.89%) .NET
2 22 (16.30%) ASP.NET
3 18 (13.33%) XML
4 15 (11.11%) HTML
4 15 (11.11%) jQuery
5 14 (10.37%) CSS
6 9 (6.67%) ASP.NET MVC
7 8 (5.93%) WPF
8 7 (5.19%) JSON
8 7 (5.19%) WCF
8 7 (5.19%) Web Services
9 6 (4.44%) .NET Framework
9 6 (4.44%) AngularJS
9 6 (4.44%) Entity Framework
9 6 (4.44%) HTML5
10 5 (3.70%) JDBC
10 5 (3.70%) JMS
10 5 (3.70%) REST
10 5 (3.70%) SOAP
10 5 (3.70%) Spring
Miscellaneous
1 8 (5.93%) Computer Science
2 6 (4.44%) Analytical Skills
3 4 (2.96%) Management Information System
3 4 (2.96%) Replication
4 2 (1.48%) Clustering
4 2 (1.48%) Greenfield Project
4 2 (1.48%) Reference Data
5 1 (0.74%) Fintech
Operating Systems
1 3 (2.22%) Windows
2 1 (0.74%) Windows Server
Processes & Methodologies
1 55 (40.74%) Business Intelligence
2 35 (25.93%) Agile Software Development
2 35 (25.93%) ETL
3 21 (15.56%) Unit Testing
4 20 (14.81%) MVC
5 17 (12.59%) Data Analysis
6 15 (11.11%) Integration Testing
6 15 (11.11%) Project Management
6 15 (11.11%) System Integration Testing
7 14 (10.37%) CRM
8 10 (7.41%) OO
8 10 (7.41%) SDLC
9 9 (6.67%) Test Automation
10 7 (5.19%) Database Optimisation
10 7 (5.19%) Performance Tuning
11 6 (4.44%) Continuous Improvement
11 6 (4.44%) Continuous Integration
12 5 (3.70%) Investment Management
12 5 (3.70%) Multithreading
12 5 (3.70%) Open Source
Programming Languages
1 118 (87.41%) SQL
2 39 (28.89%) C#
3 19 (14.07%) JavaScript
4 13 (9.63%) VB
5 9 (6.67%) Java
6 8 (5.93%) PowerShell
7 5 (3.70%) VB.NET
8 4 (2.96%) VB6
9 3 (2.22%) PHP
10 2 (1.48%) VBA
11 1 (0.74%) C
11 1 (0.74%) Data Analysis Expressions (DAX)
11 1 (0.74%) Python
11 1 (0.74%) R
Qualifications
1 19 (14.07%) Degree
2 3 (2.22%) Microsoft Certification
3 2 (1.48%) Computer Science Degree
4 1 (0.74%) SC Cleared
4 1 (0.74%) Security Cleared
Quality Assurance & Compliance
1 3 (2.22%) QA
2 2 (1.48%) Data Quality
2 2 (1.48%) SLA
System Software
1 1 (0.74%) VMware Infrastructure
1 1 (0.74%) vSphere
Systems Management
1 1 (0.74%) Microsoft Clustering
1 1 (0.74%) Systems Management Server (SMS)
Vendors
1 57 (42.22%) Microsoft
2 18 (13.33%) Tableau
3 5 (3.70%) Informatica
3 5 (3.70%) Oracle
3 5 (3.70%) Reuters
4 4 (2.96%) Cognos
4 4 (2.96%) IBM
5 2 (1.48%) Adobe
6 1 (0.74%) MicroStrategy
6 1 (0.74%) Salesforce.com
6 1 (0.74%) Teradata
6 1 (0.74%) VMware
6 1 (0.74%) Xamarin