Period
to 23 November 2017

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

Transact-SQL
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 38 59 27
Rank change year-on-year +21 -32 +18
Permanent jobs citing T-SQL 39 16 59
As % of all permanent IT jobs advertised in York 5.81% 2.48% 10.31%
As % of the Programming Languages category 7.94% 3.94% 15.95%
Number of salaries quoted 33 11 58
York median annual salary £42,500 £45,000 £32,500
Median salary % change year-on-year -5.56% +38.46% -7.14%
10th Percentile £28,950 £33,750 £23,750
90th Percentile £57,500 £47,500 £42,875
North Yorkshire median annual salary £41,250 £32,500 £35,000
% change year-on-year +26.92% -7.14% -9.09%

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

All Programming Languages
York
Permanent vacancies with a requirement for coding skills 491 406 370
As % of all permanent IT jobs advertised in York 73.17% 62.95% 64.69%
Number of salaries quoted 396 338 330
York median annual salary £40,000 £40,000 £39,000
Median salary % change year-on-year - +2.56% -2.50%
10th Percentile £27,500 £26,925 £23,750
90th Percentile £60,000 £51,625 £50,000
North Yorkshire median annual salary £40,000 £40,000 £37,500
% change year-on-year - +6.67% -

T-SQL
Job Vacancy Trend in York

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

Job vacancy trend for T-SQL in York

T-SQL
Salary Trend in York

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

Salary trend for T-SQL in York

T-SQL
Salary Histogram in York

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

Salary histogram for T-SQL in York

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

1 39 (100.00%) SQL
2 37 (94.87%) SQL Server
3 30 (76.92%) SQL Server Integration Services
4 29 (74.36%) SQL Server Reporting Services
4 29 (74.36%) SQL Server Analysis Services
5 15 (38.46%) C#
5 15 (38.46%) .NET
6 14 (35.90%) Performance Tuning
7 13 (33.33%) PowerShell
7 13 (33.33%) CRM
8 12 (30.77%) SQL Server 2008
9 10 (25.64%) NoSQL
9 10 (25.64%) Data Warehouse
10 9 (23.08%) Microsoft
10 9 (23.08%) Migration
11 8 (20.51%) SQL Server 2016
12 7 (17.95%) Data Modelling
12 7 (17.95%) Business Intelligence
13 6 (15.38%) ETL
13 6 (15.38%) ASP.NET
13 6 (15.38%) JavaScript
13 6 (15.38%) Finance
13 6 (15.38%) Power BI
14 5 (12.82%) MVC
15 4 (10.26%) Microsoft Azure
15 4 (10.26%) jQuery
16 3 (7.69%) LINQ
16 3 (7.69%) Big Data
16 3 (7.69%) Line Management
16 3 (7.69%) AngularJS

T-SQL
Co-occurring IT Skills in York 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 3 (7.69%) IIS
2 1 (2.56%) SharePoint
Applications
1 3 (7.69%) Microsoft Excel
2 1 (2.56%) S-PLUS
Business Applications
1 1 (2.56%) Visualfiles
Cloud Services
1 4 (10.26%) Microsoft Azure
Database & Business Intelligence
1 37 (94.87%) SQL Server
2 30 (76.92%) SQL Server Integration Services
3 29 (74.36%) SQL Server Analysis Services
3 29 (74.36%) SQL Server Reporting Services
4 12 (30.77%) SQL Server 2008
5 10 (25.64%) Data Warehouse
5 10 (25.64%) NoSQL
6 8 (20.51%) SQL Server 2016
7 6 (15.38%) Power BI
8 3 (7.69%) Big Data
9 1 (2.56%) BusinessObjects
9 1 (2.56%) OLAP
9 1 (2.56%) OLAP Cube
9 1 (2.56%) SQL Server 2012
9 1 (2.56%) SQL Server 2014
General
1 6 (15.38%) Finance
2 3 (7.69%) Marketing
Job Titles
1 17 (43.59%) Developer
2 14 (35.90%) DBA
2 14 (35.90%) SQL DBA
3 12 (30.77%) Senior DBA
3 12 (30.77%) Senior SQL DBA
4 6 (15.38%) Business Intelligence Developer
4 6 (15.38%) SQL Developer
4 6 (15.38%) SQL Server DBA
5 5 (12.82%) Development Manager
6 4 (10.26%) Database Developer
6 4 (10.26%) Database Manager
6 4 (10.26%) Senior SQL Server DBA
6 4 (10.26%) T-SQL Developer
7 3 (7.69%) .NET Developer
7 3 (7.69%) .NET Development Manager
7 3 (7.69%) Applications Support
7 3 (7.69%) Applications Support Analyst
7 3 (7.69%) CRM Database Manager
7 3 (7.69%) CRM Manager
7 3 (7.69%) SSRS Developer
Libraries, Frameworks & Software Standards
1 15 (38.46%) .NET
2 6 (15.38%) ASP.NET
3 4 (10.26%) jQuery
4 3 (7.69%) .NET Framework
4 3 (7.69%) AngularJS
4 3 (7.69%) CSS
4 3 (7.69%) HTML
4 3 (7.69%) LINQ
4 3 (7.69%) WCF
5 2 (5.13%) ASP.NET MVC
5 2 (5.13%) Twitter Bootstrap
5 2 (5.13%) Web Services
5 2 (5.13%) WPF
6 1 (2.56%) Entity Framework
6 1 (2.56%) Razor View Engine
6 1 (2.56%) REST
Miscellaneous
1 3 (7.69%) Analytical Skills
1 3 (7.69%) Clustering
2 2 (5.13%) Management Information System
3 1 (2.56%) Greenfield Project
3 1 (2.56%) Mobile App
3 1 (2.56%) Replication
3 1 (2.56%) User Experience
Operating Systems
1 1 (2.56%) Android
1 1 (2.56%) Windows
Processes & Methodologies
1 14 (35.90%) Performance Tuning
2 13 (33.33%) CRM
3 9 (23.08%) Migration
4 7 (17.95%) Business Intelligence
4 7 (17.95%) Data Modelling
5 6 (15.38%) ETL
6 5 (12.82%) MVC
7 3 (7.69%) Line Management
8 2 (5.13%) Data Management
8 2 (5.13%) Data Strategy
8 2 (5.13%) Document Management
9 1 (2.56%) Database Optimisation
9 1 (2.56%) OOP
9 1 (2.56%) Presales
9 1 (2.56%) SDLC
9 1 (2.56%) SOLID
9 1 (2.56%) Validation
9 1 (2.56%) Web Development
Programming Languages
1 39 (100.00%) SQL
2 15 (38.46%) C#
3 13 (33.33%) PowerShell
4 6 (15.38%) JavaScript
5 2 (5.13%) Java
6 1 (2.56%) C
6 1 (2.56%) VB
6 1 (2.56%) VB.NET
Qualifications
1 2 (5.13%) Degree
Vendors
1 9 (23.08%) Microsoft
2 1 (2.56%) Apple
2 1 (2.56%) IDERA
2 1 (2.56%) RedGate