Period
to 21 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Guildford 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
Surrey > Guildford
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 71 40 68
Rank change year-on-year -31 +28 +30
Permanent jobs citing T-SQL 22 45 50
As % of all permanent IT jobs advertised in Guildford 2.61% 5.57% 3.92%
As % of the Programming Languages category 4.80% 11.45% 7.34%
Number of salaries quoted 22 45 50
Guildford median annual salary £40,000 £47,500 £42,500
Median salary % change year-on-year -15.79% +11.76% -5.56%
10th Percentile £32,500 £27,500 £28,750
90th Percentile £51,250 £60,750 £52,500
Surrey median annual salary £51,250 £47,500 £45,000
% change year-on-year +7.90% +5.56% -3.23%

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

All Programming Languages
Guildford
Permanent vacancies with a requirement for coding skills 458 393 681
As % of all permanent IT jobs advertised in Guildford 54.33% 48.64% 53.45%
Number of salaries quoted 428 380 631
Guildford median annual salary £42,500 £47,500 £42,500
Median salary % change year-on-year -10.53% +11.76% -5.56%
10th Percentile £26,750 £30,000 £27,500
90th Percentile £60,300 £66,250 £63,750
Surrey median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

T-SQL
Job Vacancy Trend in Guildford

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

Job vacancy trend for T-SQL in Guildford

T-SQL
Salary Trend in Guildford

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

Salary trend for T-SQL in Guildford

T-SQL
Salary Histogram in Guildford

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

Salary histogram for T-SQL in Guildford

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 Guildford region with a requirement for T-SQL.

1 22 (100.00%) SQL
2 21 (95.45%) SQL Server
3 20 (90.91%) MVC
4 16 (72.73%) ASP.NET
4 16 (72.73%) .NET
4 16 (72.73%) C#
5 15 (68.18%) ASP.NET MVC
6 11 (50.00%) Microsoft Azure
7 9 (40.91%) Windows
8 8 (36.36%) Web Services
8 8 (36.36%) AngularJS
9 7 (31.82%) React
9 7 (31.82%) CSS
9 7 (31.82%) HTML
9 7 (31.82%) .NET Framework
10 6 (27.27%) Degree
10 6 (27.27%) OO
11 5 (22.73%) Microsoft
11 5 (22.73%) SOAP
11 5 (22.73%) Agile Software Development
11 5 (22.73%) TDD
11 5 (22.73%) WCF
11 5 (22.73%) jQuery
11 5 (22.73%) Continuous Integration
11 5 (22.73%) ASP.NET Web Forms
11 5 (22.73%) Entity Framework
11 5 (22.73%) REST
11 5 (22.73%) Responsive Web Design
12 4 (18.18%) Functional Testing
12 4 (18.18%) Ember.js

T-SQL
Co-occurring IT Skills in Guildford 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 4 (18.18%) JBoss
2 3 (13.64%) Confluence
Cloud Services
1 11 (50.00%) Microsoft Azure
Database & Business Intelligence
1 21 (95.45%) SQL Server
2 4 (18.18%) MySQL
3 3 (13.64%) JasperReports
4 1 (4.55%) RDBMS
4 1 (4.55%) Relational Database
Development Applications
1 4 (18.18%) Arquillian
1 4 (18.18%) JUnit
1 4 (18.18%) Mockito
1 4 (18.18%) Team Foundation Server
2 3 (13.64%) Jenkins
2 3 (13.64%) JIRA
2 3 (13.64%) JMeter
2 3 (13.64%) Maven
2 3 (13.64%) Octopus Deploy
2 3 (13.64%) Selenium
2 3 (13.64%) Subversion
Job Titles
1 22 (100.00%) Developer
2 13 (59.09%) .NET Developer
3 10 (45.45%) ASP.NET Developer
3 10 (45.45%) C# .NET Developer
3 10 (45.45%) C# ASP.NET Developer
3 10 (45.45%) C# Developer
4 6 (27.27%) Software Developer
5 4 (18.18%) Java Developer
6 3 (13.64%) .NET Software Developer
7 2 (9.09%) Senior Developer
7 2 (9.09%) Senior SQL Developer
7 2 (9.09%) SQL Developer
8 1 (4.55%) ASP.NET MVC Developer
8 1 (4.55%) C# Software Developer
8 1 (4.55%) Full Stack Developer
8 1 (4.55%) Graduate
8 1 (4.55%) Graduate .NET Developer
8 1 (4.55%) Graduate Developer
8 1 (4.55%) Graduate Software Developer
Libraries, Frameworks & Software Standards
1 16 (72.73%) .NET
1 16 (72.73%) ASP.NET
2 15 (68.18%) ASP.NET MVC
3 8 (36.36%) AngularJS
3 8 (36.36%) Web Services
4 7 (31.82%) .NET Framework
4 7 (31.82%) CSS
4 7 (31.82%) HTML
4 7 (31.82%) React
5 5 (22.73%) ASP.NET Web Forms
5 5 (22.73%) Entity Framework
5 5 (22.73%) jQuery
5 5 (22.73%) REST
5 5 (22.73%) SOAP
5 5 (22.73%) WCF
6 4 (18.18%) Backbone.js
6 4 (18.18%) Java EE
6 4 (18.18%) JSON
6 4 (18.18%) LINQ
6 4 (18.18%) Spring
Miscellaneous
1 4 (18.18%) Animation
2 1 (4.55%) Data Structures
Operating Systems
1 9 (40.91%) Windows
Processes & Methodologies
1 20 (90.91%) MVC
2 6 (27.27%) OO
3 5 (22.73%) Agile Software Development
3 5 (22.73%) Continuous Integration
3 5 (22.73%) Responsive Web Design
3 5 (22.73%) TDD
4 4 (18.18%) 3D Animation
4 4 (18.18%) Cross-Browser Development
4 4 (18.18%) Functional Testing
4 4 (18.18%) OOD
4 4 (18.18%) Web Design
5 3 (13.64%) Load Testing
5 3 (13.64%) Test Automation
6 2 (9.09%) OOP
6 2 (9.09%) Software Engineering
6 2 (9.09%) Unit Testing
7 1 (4.55%) Data Analysis
7 1 (4.55%) Data Modelling
7 1 (4.55%) Scrum
7 1 (4.55%) Test Scripting
Programming Languages
1 22 (100.00%) SQL
2 16 (72.73%) C#
3 4 (18.18%) Java
3 4 (18.18%) PowerShell
3 4 (18.18%) Python
4 3 (13.64%) JavaScript
5 2 (9.09%) VB
6 1 (4.55%) XPath
Qualifications
1 6 (27.27%) Degree
Vendors
1 5 (22.73%) Microsoft
2 2 (9.09%) Oracle