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

Transact-SQL
Yorkshire > North Yorkshire
6 months to
25 May 2018
Same period 2017 Same period 2016
Rank 42 55 52
Rank change year-on-year +13 -3 +3
Permanent jobs citing T-SQL 75 69 85
As % of all permanent IT jobs advertised in North Yorkshire 5.69% 4.46% 4.87%
As % of the Programming Languages category 10.50% 7.32% 9.11%
Number of salaries quoted 82 64 77
North Yorkshire median annual salary £52,500 £40,000 £37,500
Median salary % change year-on-year +31.25% +6.67% +10.29%
10th Percentile £36,375 £29,125 £22,500
90th Percentile £65,000 £47,500 £46,250
Yorkshire median annual salary £45,000 £40,000 £40,000
% change year-on-year +12.50% - -

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 714 943 933
As % of all permanent IT jobs advertised in North Yorkshire 54.21% 60.96% 53.47%
Number of salaries quoted 617 824 802
North Yorkshire median annual salary £40,000 £40,000 £40,000
10th Percentile £27,500 £26,299 £26,250
90th Percentile £53,750 £51,250 £52,500
Yorkshire median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +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 25 May 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 25 May 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 +8 66 £52,500 +31.25% 4
Harrogate -7 2 £55,000 +30.95% 3
Middlesbrough +8 1 £27,500 -3.51%
Northallerton -3 1 £37,500 - 1
T-SQL
Yorkshire

For the 6 months to 25 May 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 72 (96.00%) SQL
2 61 (81.33%) SQL Server
3 46 (61.33%) SQL Server Analysis Services
4 44 (58.67%) Microsoft Azure
4 44 (58.67%) SQL Server Integration Services
5 41 (54.67%) SQL Server Reporting Services
6 38 (50.67%) Business Intelligence
7 33 (44.00%) PowerShell
7 33 (44.00%) Performance Tuning
8 26 (34.67%) NoSQL
9 25 (33.33%) Finance
9 25 (33.33%) C#
10 24 (32.00%) Microsoft
10 24 (32.00%) Migration
11 22 (29.33%) .NET
12 21 (28.00%) JavaScript
13 18 (24.00%) ASP.NET
14 17 (22.67%) Agile Software Development
14 17 (22.67%) Data Virtualisation
14 17 (22.67%) HDInsight
14 17 (22.67%) Entity Framework
14 17 (22.67%) Data Lake
14 17 (22.67%) Azure Data Factory
15 16 (21.33%) .NET Framework
16 15 (20.00%) Data Modelling
17 14 (18.67%) MVC
18 13 (17.33%) Data Warehouse
19 12 (16.00%) ETL
19 12 (16.00%) Git (software)
19 12 (16.00%) ASP.NET MVC

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:

Cloud Services
1 44 (58.67%) Microsoft Azure
2 17 (22.67%) Azure Data Factory
3 8 (10.67%) Amazon AWS
4 4 (5.33%) Cloud Computing
4 4 (5.33%) PaaS
5 2 (2.67%) NuGet
6 1 (1.33%) SaaS
Communications & Networking
1 1 (1.33%) SMS
Database & Business Intelligence
1 61 (81.33%) SQL Server
2 46 (61.33%) SQL Server Analysis Services
3 44 (58.67%) SQL Server Integration Services
4 41 (54.67%) SQL Server Reporting Services
5 26 (34.67%) NoSQL
6 17 (22.67%) Data Lake
6 17 (22.67%) HDInsight
7 13 (17.33%) Data Warehouse
8 7 (9.33%) Power BI
9 5 (6.67%) SQL Server 2008
10 4 (5.33%) QlikView
11 2 (2.67%) Big Data
12 1 (1.33%) Azure SQL Data Warehouse
Development Applications
1 12 (16.00%) Git (software)
2 11 (14.67%) Team Foundation Server
3 4 (5.33%) Visual Studio Team System
4 3 (4.00%) Visual Studio
4 3 (4.00%) VSS/SourceSafe
4 3 (4.00%) webpack
5 2 (2.67%) Subversion
5 2 (2.67%) TeamCity
General
1 25 (33.33%) Finance
2 1 (1.33%) Advertising
Job Titles
1 33 (44.00%) DBA
2 31 (41.33%) Developer
3 29 (38.67%) SQL DBA
4 27 (36.00%) SQL Server DBA
5 13 (17.33%) Senior DBA
6 11 (14.67%) C# Developer
7 10 (13.33%) Business Intelligence Developer
8 9 (12.00%) Senior SQL DBA
9 8 (10.67%) Applications Developer
9 8 (10.67%) Applications Support
9 8 (10.67%) Senior SQL Server DBA
10 6 (8.00%) .NET Developer
10 6 (8.00%) C# .NET Developer
11 5 (6.67%) T-SQL Developer
12 4 (5.33%) Administrator
12 4 (5.33%) Azure Consultant
12 4 (5.33%) Azure Developer
12 4 (5.33%) Data Analyst
12 4 (5.33%) Data Warehouse Analyst
12 4 (5.33%) SSAS Developer
Libraries, Frameworks & Software Standards
1 22 (29.33%) .NET
2 18 (24.00%) ASP.NET
3 17 (22.67%) Entity Framework
4 16 (21.33%) .NET Framework
5 12 (16.00%) ASP.NET MVC
6 8 (10.67%) CSS
6 8 (10.67%) HTML
7 7 (9.33%) AngularJS
8 6 (8.00%) LINQ
9 5 (6.67%) KnockoutJS
10 3 (4.00%) Ajax
10 3 (4.00%) XML
11 2 (2.67%) .NET Core
11 2 (2.67%) ASP.NET Web API
11 2 (2.67%) CSS3
11 2 (2.67%) HTML5
11 2 (2.67%) jQuery
11 2 (2.67%) REST
11 2 (2.67%) WCF
11 2 (2.67%) WPF
Miscellaneous
1 4 (5.33%) Computer Science
2 3 (4.00%) W3C
3 1 (1.33%) Analytical Skills
Processes & Methodologies
1 38 (50.67%) Business Intelligence
2 33 (44.00%) Performance Tuning
3 24 (32.00%) Migration
4 17 (22.67%) Agile Software Development
4 17 (22.67%) Data Virtualisation
5 15 (20.00%) Data Modelling
6 14 (18.67%) MVC
7 12 (16.00%) ETL
8 10 (13.33%) Software Engineering
8 10 (13.33%) Visualisation
9 7 (9.33%) MVVM
9 7 (9.33%) OOP
10 6 (8.00%) Continuous Integration
11 5 (6.67%) Data Visualisation
11 5 (6.67%) Problem-Solving
11 5 (6.67%) Software Testing
11 5 (6.67%) TDD
11 5 (6.67%) Web Development
12 4 (5.33%) Data Analysis
12 4 (5.33%) Decision-Making
Programming Languages
1 72 (96.00%) SQL
2 33 (44.00%) PowerShell
3 25 (33.33%) C#
4 21 (28.00%) JavaScript
5 2 (2.67%) VB.NET
Qualifications
1 4 (5.33%) Computer Science Degree
1 4 (5.33%) Degree
Quality Assurance & Compliance
1 2 (2.67%) QA
System Software
1 3 (4.00%) Virtual Machines
Systems Management
1 1 (1.33%) Systems Management Server (SMS)
Vendors
1 24 (32.00%) Microsoft
2 10 (13.33%) Tableau
3 2 (2.67%) Xamarin