Period
to 21 February 2018

The following table provides summary statistics for permanent job vacancies advertised in North Yorkshire 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 February 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Yorkshire > North Yorkshire
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 52 53 33
Rank change year-on-year +1 -20 +45
Permanent jobs citing T-SQL 50 66 109
As % of all permanent IT jobs advertised in North Yorkshire 3.84% 4.17% 6.39%
As % of the Programming Languages category 6.75% 7.63% 12.88%
Number of salaries quoted 47 63 106
North Yorkshire median annual salary £52,500 £40,000 £35,000
Median salary % change year-on-year +31.25% +14.29% -12.50%
10th Percentile £24,500 £30,000 £23,750
90th Percentile £65,000 £45,000 £43,125
Yorkshire median annual salary £45,000 £40,000 £38,000
% change year-on-year +12.50% +5.26% -5.00%

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

All Programming Languages
North Yorkshire
Permanent vacancies with a requirement for coding skills 741 865 846
As % of all permanent IT jobs advertised in North Yorkshire 56.91% 54.71% 49.56%
Number of salaries quoted 628 756 751
North Yorkshire median annual salary £40,000 £40,000 £40,000
10th Percentile £27,500 £24,750 £26,250
90th Percentile £55,000 £51,250 £52,500
Yorkshire median annual salary £41,500 £40,000 £40,000
% change year-on-year +3.75% - +6.67%

T-SQL
Job Vacancy Trend in North Yorkshire

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

Job vacancy trend for T-SQL in North Yorkshire

T-SQL
Salary Trend in North Yorkshire

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

Salary trend for T-SQL in North Yorkshire

T-SQL
Salary Histogram in North Yorkshire

The salary distribution of IT jobs citing T-SQL in North Yorkshire over the 6 months to 21 February 2018.

Salary histogram for T-SQL in North Yorkshire

T-SQL
Job Locations in North Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the North Yorkshire region over the 6 months to 21 February 2018. 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
York +7 39 £52,500 +16.67% 5
Middlesbrough -3 2 £24,000 -16.52%
Harrogate -9 1 £55,000 +69.23% 1
T-SQL
Yorkshire

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

1 47 (94.00%) SQL Server
2 46 (92.00%) SQL
3 34 (68.00%) SQL Server Integration Services
3 34 (68.00%) SQL Server Analysis Services
4 33 (66.00%) SQL Server Reporting Services
5 28 (56.00%) PowerShell
5 28 (56.00%) Performance Tuning
6 23 (46.00%) Migration
7 21 (42.00%) NoSQL
8 19 (38.00%) Microsoft Azure
8 19 (38.00%) C#
9 17 (34.00%) Microsoft
10 15 (30.00%) .NET
11 12 (24.00%) JavaScript
11 12 (24.00%) Finance
12 11 (22.00%) Business Intelligence
13 8 (16.00%) Agile Software Development
13 8 (16.00%) Data Virtualisation
13 8 (16.00%) ASP.NET
13 8 (16.00%) HDInsight
13 8 (16.00%) Data Lake
13 8 (16.00%) Azure Data Factory
14 7 (14.00%) SQL Server 2008
15 6 (12.00%) Team Foundation Server
15 6 (12.00%) CSS
15 6 (12.00%) HTML
16 5 (10.00%) OOP
16 5 (10.00%) OO
16 5 (10.00%) CRM
16 5 (10.00%) Data Modelling

T-SQL
Co-occurring IT Skills in North Yorkshire 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 (6.00%) IIS
2 1 (2.00%) SharePoint
Applications
1 2 (4.00%) Microsoft Excel
1 2 (4.00%) Microsoft Office
Cloud Services
1 19 (38.00%) Microsoft Azure
2 8 (16.00%) Azure Data Factory
3 2 (4.00%) Cloud Computing
3 2 (4.00%) PaaS
4 1 (2.00%) Amazon AWS
4 1 (2.00%) SaaS
Database & Business Intelligence
1 47 (94.00%) SQL Server
2 34 (68.00%) SQL Server Analysis Services
2 34 (68.00%) SQL Server Integration Services
3 33 (66.00%) SQL Server Reporting Services
4 21 (42.00%) NoSQL
5 8 (16.00%) Data Lake
5 8 (16.00%) HDInsight
6 7 (14.00%) SQL Server 2008
7 3 (6.00%) Data Warehouse
8 1 (2.00%) Azure SQL Data Warehouse
8 1 (2.00%) Big Data
8 1 (2.00%) SQL Server 2016
Development Applications
1 6 (12.00%) Team Foundation Server
2 3 (6.00%) Visual Studio
3 2 (4.00%) Git (software)
3 2 (4.00%) Visual Studio Team System
3 2 (4.00%) VSS/SourceSafe
3 2 (4.00%) webpack
4 1 (2.00%) NuGet
4 1 (2.00%) Subversion
4 1 (2.00%) TeamCity
General
1 12 (24.00%) Finance
2 1 (2.00%) Marketing
Job Titles
1 28 (56.00%) DBA
2 22 (44.00%) SQL DBA
3 19 (38.00%) SQL Server DBA
4 17 (34.00%) Senior DBA
5 14 (28.00%) Developer
6 11 (22.00%) Senior SQL DBA
7 8 (16.00%) Administrator
7 8 (16.00%) Senior SQL Server DBA
8 7 (14.00%) C# Developer
9 6 (12.00%) .NET Developer
10 5 (10.00%) C# .NET Developer
11 4 (8.00%) Database Developer
12 3 (6.00%) Analyst
12 3 (6.00%) Applications Support
12 3 (6.00%) Applications Support Analyst
12 3 (6.00%) Development Manager
12 3 (6.00%) Junior
12 3 (6.00%) Junior C# Developer
12 3 (6.00%) Junior Developer
12 3 (6.00%) Support Analyst
Libraries, Frameworks & Software Standards
1 15 (30.00%) .NET
2 8 (16.00%) ASP.NET
3 6 (12.00%) CSS
3 6 (12.00%) HTML
4 5 (10.00%) Entity Framework
5 4 (8.00%) AngularJS
6 3 (6.00%) .NET Framework
6 3 (6.00%) KnockoutJS
7 2 (4.00%) Ajax
7 2 (4.00%) LINQ
7 2 (4.00%) XML
8 1 (2.00%) ASP.NET MVC
8 1 (2.00%) ASP.NET Web API
8 1 (2.00%) COM
8 1 (2.00%) jQuery
8 1 (2.00%) REST
8 1 (2.00%) WCF
Miscellaneous
1 2 (4.00%) Computer Science
1 2 (4.00%) W3C
2 1 (2.00%) Analytical Skills
2 1 (2.00%) Clustering
2 1 (2.00%) Greenfield Project
2 1 (2.00%) User Experience
Processes & Methodologies
1 28 (56.00%) Performance Tuning
2 23 (46.00%) Migration
3 11 (22.00%) Business Intelligence
4 8 (16.00%) Agile Software Development
4 8 (16.00%) Data Virtualisation
5 5 (10.00%) CRM
5 5 (10.00%) Data Modelling
5 5 (10.00%) OO
5 5 (10.00%) OOP
6 4 (8.00%) MVC
7 3 (6.00%) Continuous Integration
7 3 (6.00%) Data Visualisation
7 3 (6.00%) MVVM
7 3 (6.00%) Scrum
7 3 (6.00%) TDD
7 3 (6.00%) Unit Testing
7 3 (6.00%) Visualisation
7 3 (6.00%) Web Development
8 2 (4.00%) Line Management
8 2 (4.00%) Software Testing
Programming Languages
1 46 (92.00%) SQL
2 28 (56.00%) PowerShell
3 19 (38.00%) C#
4 12 (24.00%) JavaScript
5 2 (4.00%) Java
5 2 (4.00%) VBA
6 1 (2.00%) VB
6 1 (2.00%) VB.NET
Qualifications
1 4 (8.00%) Degree
2 2 (4.00%) Computer Science Degree
System Software
1 2 (4.00%) Virtual Machines
Systems Management
1 2 (4.00%) Systems Management Server (SMS)
Vendors
1 17 (34.00%) Microsoft
2 1 (2.00%) Tableau