Period
to 22 January 2018

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

Transact-SQL
Hertfordshire > St Albans
6 months to
22 Jan 2018
Same period 2017 Same period 2016
Rank 55 30 36
Rank change year-on-year -25 +6 +23
Permanent jobs citing T-SQL 13 40 40
As % of all permanent IT jobs advertised in St Albans 3.45% 9.85% 14.93%
As % of the Programming Languages category 4.58% 12.86% 19.23%
Number of salaries quoted 7 23 38
St Albans median annual salary £40,000 £45,000 £46,250
Median salary % change year-on-year -11.11% -2.70% -0.54%
10th Percentile £33,750 £29,750 £25,000
90th Percentile £46,750 £55,500 £65,000
Hertfordshire median annual salary £50,000 £45,000 £47,500
% change year-on-year +11.11% -5.26% +18.75%

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

All Programming Languages
St Albans
Permanent vacancies with a requirement for coding skills 284 311 208
As % of all permanent IT jobs advertised in St Albans 75.33% 76.60% 77.61%
Number of salaries quoted 258 281 199
St Albans median annual salary £53,750 £52,500 £45,000
Median salary % change year-on-year +2.38% +16.67% -10.00%
10th Percentile £33,750 £32,500 £25,000
90th Percentile £72,875 £72,500 £72,500
Hertfordshire median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

T-SQL
Job Vacancy Trend in St Albans

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

Job vacancy trend for T-SQL in St Albans

T-SQL
Salary Trend in St Albans

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

Salary trend for T-SQL in St Albans

For the 6 months to 22 January 2018, 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 St Albans region with a requirement for T-SQL.

1 13 (100.00%) C#
1 13 (100.00%) SQL
2 10 (76.92%) .NET
2 10 (76.92%) Agile Software Development
3 7 (53.85%) TDD
3 7 (53.85%) JavaScript
3 7 (53.85%) .NET Framework
3 7 (53.85%) ASP.NET MVC
3 7 (53.85%) Entity Framework
3 7 (53.85%) AngularJS
3 7 (53.85%) SQL Server
3 7 (53.85%) ASP.NET
3 7 (53.85%) OO
3 7 (53.85%) MVC
3 7 (53.85%) Scrum
4 6 (46.15%) SOLID
5 5 (38.46%) Octopus Deploy
5 5 (38.46%) Microsoft Azure
5 5 (38.46%) ReSharper
5 5 (38.46%) TeamCity
5 5 (38.46%) Git (software)
6 4 (30.77%) SQL Server Integration Services
6 4 (30.77%) SQL Server Reporting Services
6 4 (30.77%) Windows
6 4 (30.77%) OOP
7 3 (23.08%) Finance
7 3 (23.08%) Stakeholder Management
7 3 (23.08%) GIS
7 3 (23.08%) Web Design
7 3 (23.08%) Programme Management

T-SQL
Co-occurring IT Skills in St Albans 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 (23.08%) SAS
Applications
1 3 (23.08%) SPSS
Cloud Services
1 5 (38.46%) Microsoft Azure
Database & Business Intelligence
1 7 (53.85%) SQL Server
2 4 (30.77%) SQL Server Integration Services
2 4 (30.77%) SQL Server Reporting Services
3 3 (23.08%) Big Data
3 3 (23.08%) BusinessObjects
3 3 (23.08%) GIS
3 3 (23.08%) Hadoop
3 3 (23.08%) QlikView
3 3 (23.08%) Relational Database
4 2 (15.38%) SQL Server 2016
Development Applications
1 5 (38.46%) Git (software)
1 5 (38.46%) Octopus Deploy
1 5 (38.46%) ReSharper
1 5 (38.46%) TeamCity
2 3 (23.08%) Jenkins
2 3 (23.08%) Selenium
2 3 (23.08%) SpecFlow
2 3 (23.08%) Team Foundation Server
2 3 (23.08%) WebDriver
3 2 (15.38%) Bitbucket
General
1 3 (23.08%) Finance
Job Titles
1 7 (53.85%) Developer
2 6 (46.15%) .NET Developer
3 3 (23.08%) Analytics Manager
3 3 (23.08%) Angular Developer
3 3 (23.08%) Automation Tester
3 3 (23.08%) Data Analytics Manager
3 3 (23.08%) Data Manager
3 3 (23.08%) Fraud Manager
3 3 (23.08%) Junior
3 3 (23.08%) Junior Automation Tester
3 3 (23.08%) Junior Tester
3 3 (23.08%) Senior Analytics Manager
3 3 (23.08%) Senior Manager
3 3 (23.08%) Senior Technical Manager
3 3 (23.08%) Software Manager
3 3 (23.08%) Technical Manager
3 3 (23.08%) Tester
4 2 (15.38%) ASP.NET MVC Developer
4 2 (15.38%) Azure Developer
4 2 (15.38%) C# Developer
Libraries, Frameworks & Software Standards
1 10 (76.92%) .NET
2 7 (53.85%) .NET Framework
2 7 (53.85%) AngularJS
2 7 (53.85%) ASP.NET
2 7 (53.85%) ASP.NET MVC
2 7 (53.85%) Entity Framework
3 3 (23.08%) CSS
3 3 (23.08%) Gherkin
3 3 (23.08%) HTML
Miscellaneous
1 3 (23.08%) Analytical Skills
2 1 (7.69%) Greenfield Project
Operating Systems
1 4 (30.77%) Windows
Processes & Methodologies
1 10 (76.92%) Agile Software Development
2 7 (53.85%) MVC
2 7 (53.85%) OO
2 7 (53.85%) Scrum
2 7 (53.85%) TDD
3 6 (46.15%) SOLID
4 4 (30.77%) OOP
5 3 (23.08%) BDD
5 3 (23.08%) Business Intelligence
5 3 (23.08%) Data Analysis
5 3 (23.08%) Data Analytics
5 3 (23.08%) Data Visualisation
5 3 (23.08%) ETL
5 3 (23.08%) Programme Management
5 3 (23.08%) Project Management
5 3 (23.08%) Resource Management
5 3 (23.08%) Stakeholder Management
5 3 (23.08%) Test Automation
5 3 (23.08%) Visualisation
5 3 (23.08%) Web Design
Programming Languages
1 13 (100.00%) C#
1 13 (100.00%) SQL
2 7 (53.85%) JavaScript
3 3 (23.08%) Java
3 3 (23.08%) PowerShell
3 3 (23.08%) Python
3 3 (23.08%) VB.NET
Qualifications
1 3 (23.08%) Degree
Vendors
1 3 (23.08%) SAP
1 3 (23.08%) Tableau
2 2 (15.38%) New Relic