Period
to 21 November 2017

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

Transact-SQL
Scotland > Glasgow
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 98 75 82
Rank change year-on-year -23 +7 -6
Permanent jobs citing T-SQL 50 63 81
As % of all permanent IT jobs advertised in Glasgow 2.16% 2.92% 3.15%
As % of the Programming Languages category 3.39% 4.72% 5.34%
Number of salaries quoted 23 26 50
Glasgow median annual salary £40,000 £41,250 £34,750
Median salary % change year-on-year -3.03% +18.71% -13.13%
10th Percentile £32,500 £30,250 £29,875
90th Percentile £56,500 £50,750 £58,750
Scotland median annual salary £40,000 £38,000 £40,500
% change year-on-year +5.26% -6.17% -1.82%

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

All Programming Languages
Glasgow
Permanent vacancies with a requirement for coding skills 1477 1334 1516
As % of all permanent IT jobs advertised in Glasgow 63.80% 61.85% 58.94%
Number of salaries quoted 929 693 880
Glasgow median annual salary £47,500 £40,000 £40,000
Median salary % change year-on-year +18.75% - -
10th Percentile £32,000 £28,750 £28,750
90th Percentile £67,500 £60,000 £58,875
Scotland median annual salary £42,500 £42,000 £40,000
% change year-on-year +1.19% +5.00% -

T-SQL
Job Vacancy Trend in Glasgow

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

Job vacancy trend for T-SQL in Glasgow

T-SQL
Salary Trend in Glasgow

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

Salary trend for T-SQL in Glasgow

T-SQL
Salary Histogram in Glasgow

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

Salary histogram for T-SQL in Glasgow

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

1 50 (100.00%) SQL
2 42 (84.00%) SQL Server
3 31 (62.00%) SQL Server Integration Services
4 25 (50.00%) SQL Server Reporting Services
5 21 (42.00%) Business Intelligence
6 20 (40.00%) Data Warehouse
7 18 (36.00%) Microsoft
8 15 (30.00%) C#
8 15 (30.00%) Unit Testing
9 14 (28.00%) Agile Software Development
10 13 (26.00%) .NET
11 11 (22.00%) JUnit
12 10 (20.00%) JavaScript
12 10 (20.00%) OO
12 10 (20.00%) Maven
12 10 (20.00%) SQL Server 2012
13 9 (18.00%) XML
13 9 (18.00%) Java
13 9 (18.00%) Finance
14 8 (16.00%) HTML
14 8 (16.00%) Subversion
14 8 (16.00%) SQL Server Analysis Services
15 7 (14.00%) Degree
15 7 (14.00%) Visual Studio
15 7 (14.00%) ETL
16 6 (12.00%) MVC
16 6 (12.00%) CMS
16 6 (12.00%) IIS
16 6 (12.00%) ASP.NET
16 6 (12.00%) CSS

T-SQL
Co-occurring IT Skills in Glasgow 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 6 (12.00%) CMS
1 6 (12.00%) IIS
2 5 (10.00%) Oracle Coherence
3 1 (2.00%) SharePoint
Applications
1 2 (4.00%) Adobe Illustrator
1 2 (4.00%) Photoshop
2 1 (2.00%) Microsoft Office
Business Applications
1 2 (4.00%) Cognos Business Intelligence
2 1 (2.00%) Cognos TM1
Cloud Services
1 2 (4.00%) Microsoft Azure
2 1 (2.00%) Azure Data Factory
Communications & Networking
1 2 (4.00%) Intranet
Database & Business Intelligence
1 42 (84.00%) SQL Server
2 31 (62.00%) SQL Server Integration Services
3 25 (50.00%) SQL Server Reporting Services
4 20 (40.00%) Data Warehouse
5 10 (20.00%) SQL Server 2012
6 8 (16.00%) SQL Server Analysis Services
7 6 (12.00%) Relational Database
8 5 (10.00%) MongoDB
9 4 (8.00%) OLTP
10 3 (6.00%) Big Data
10 3 (6.00%) Enterprise Data Warehouse
10 3 (6.00%) Power BI
10 3 (6.00%) SQL Server 2016
11 2 (4.00%) DTS
11 2 (4.00%) NoSQL
11 2 (4.00%) OLAP
11 2 (4.00%) SQL Server 2005
12 1 (2.00%) BusinessObjects
12 1 (2.00%) Oracle Reports
12 1 (2.00%) QlikView
Development Applications
1 11 (22.00%) JUnit
2 10 (20.00%) Maven
3 8 (16.00%) Subversion
4 7 (14.00%) Visual Studio
5 6 (12.00%) tSQLt
6 5 (10.00%) IntelliJ
6 5 (10.00%) Jenkins
6 5 (10.00%) JIRA
7 4 (8.00%) TeamCity
8 2 (4.00%) Dreamweaver
9 1 (2.00%) Team Foundation Server
General
1 9 (18.00%) Finance
2 6 (12.00%) Banking
2 6 (12.00%) Investment Banking
3 3 (6.00%) Advertising
4 2 (4.00%) Back Office
4 2 (4.00%) Law
4 2 (4.00%) Legal
Job Titles
1 43 (86.00%) Developer
2 22 (44.00%) SQL Developer
3 10 (20.00%) SQL Server Developer
4 9 (18.00%) Business Intelligence Developer
5 7 (14.00%) .NET Developer
6 6 (12.00%) Analyst
7 5 (10.00%) Java Developer
7 5 (10.00%) Senior Developer
8 3 (6.00%) Analyst Developer
8 3 (6.00%) Business Intelligence Analyst
8 3 (6.00%) C# Developer
8 3 (6.00%) DBA
8 3 (6.00%) Senior Java Developer
8 3 (6.00%) SQL DBA
9 2 (4.00%) Business Analyst
9 2 (4.00%) Database Developer
9 2 (4.00%) Senior SQL Server Developer
9 2 (4.00%) SQL Database Developer
9 2 (4.00%) Systems Analyst
9 2 (4.00%) Systems Developer
Libraries, Frameworks & Software Standards
1 13 (26.00%) .NET
2 9 (18.00%) XML
3 8 (16.00%) HTML
4 6 (12.00%) .NET Framework
4 6 (12.00%) ASP.NET
4 6 (12.00%) CSS
4 6 (12.00%) Entity Framework
4 6 (12.00%) HTML5
4 6 (12.00%) jQuery
4 6 (12.00%) WPF
5 5 (10.00%) JDBC
5 5 (10.00%) JMS
5 5 (10.00%) JSON
5 5 (10.00%) REST
5 5 (10.00%) SOAP
5 5 (10.00%) Spring
5 5 (10.00%) Web Services
6 4 (8.00%) FIX Protocol
7 2 (4.00%) AngularJS
7 2 (4.00%) React
Miscellaneous
1 6 (12.00%) Computer Science
2 4 (8.00%) Management Information System
3 2 (4.00%) Analytical Skills
4 1 (2.00%) Greenfield Project
Processes & Methodologies
1 21 (42.00%) Business Intelligence
2 15 (30.00%) Unit Testing
3 14 (28.00%) Agile Software Development
4 10 (20.00%) OO
5 7 (14.00%) ETL
6 6 (12.00%) Continuous Integration
6 6 (12.00%) Database Optimisation
6 6 (12.00%) MVC
7 5 (10.00%) Concurrent Programming
7 5 (10.00%) Investment Management
7 5 (10.00%) Multithreading
7 5 (10.00%) Performance Tuning
7 5 (10.00%) Test Automation
8 4 (8.00%) Continuous Improvement
8 4 (8.00%) OOP
8 4 (8.00%) Open Source
9 3 (6.00%) Stakeholder Management
9 3 (6.00%) Time Management
9 3 (6.00%) Visualisation
10 2 (4.00%) Data Visualisation
Programming Languages
1 50 (100.00%) SQL
2 15 (30.00%) C#
3 10 (20.00%) JavaScript
4 9 (18.00%) Java
5 2 (4.00%) PowerShell
5 2 (4.00%) VB
6 1 (2.00%) Python
6 1 (2.00%) R
Qualifications
1 7 (14.00%) Degree
Quality Assurance & Compliance
1 1 (2.00%) Data Quality
Vendors
1 18 (36.00%) Microsoft
2 5 (10.00%) Informatica
2 5 (10.00%) Reuters
3 4 (8.00%) IBM
4 3 (6.00%) Cognos
5 2 (4.00%) Adobe
5 2 (4.00%) Oracle
6 1 (2.00%) MicroStrategy
6 1 (2.00%) Salesforce.com
6 1 (2.00%) Teradata