Period
to 20 November 2017

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

Transact-SQL
East of England > Hertfordshire
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 86 63 46
Rank change year-on-year -23 -17 +37
Permanent jobs citing T-SQL 149 183 288
As % of all permanent IT jobs advertised in Hertfordshire 3.39% 4.13% 5.34%
As % of the Programming Languages category 6.46% 8.63% 11.44%
Number of salaries quoted 127 161 299
Hertfordshire median annual salary £45,000 £45,000 £47,500
Median salary % change year-on-year - -5.26% +14.46%
10th Percentile £31,250 £31,250 £26,250
90th Percentile £61,250 £62,500 £57,500
East of England median annual salary £45,000 £45,000 £45,000

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

All Programming Languages
Hertfordshire
Permanent vacancies with a requirement for coding skills 2306 2120 2517
As % of all permanent IT jobs advertised in Hertfordshire 52.42% 47.86% 46.67%
Number of salaries quoted 2007 1836 2199
Hertfordshire median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £31,250 £27,500 £26,250
90th Percentile £67,500 £68,750 £65,000
East of England median annual salary £47,000 £45,000 £42,500
% change year-on-year +4.44% +5.88% +2.41%

T-SQL
Job Vacancy Trend in Hertfordshire

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

Job vacancy trend for T-SQL in Hertfordshire

T-SQL
Salary Trend in Hertfordshire

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

Salary trend for T-SQL in Hertfordshire

T-SQL
Salary Histogram in Hertfordshire

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

Salary histogram for T-SQL in Hertfordshire

T-SQL
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Hertfordshire region over the 6 months to 20 November 2017. 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
Watford -1 49 £52,000 -5.45% 2
Welwyn Garden City -3 15 £45,000 +12.50%
Broxbourne +7 12 £45,000 +5.88%
Hemel Hempstead +6 12 £41,250 -8.33% 1
Hatfield +10 11 £42,500 -
St Albans -21 8 - -
Stevenage 0 7 £35,000 -22.22%
Hitchin - 7 £35,000 -
Letchworth +8 5 £42,500 +6.25%
Harpenden 0 3 £57,500 +35.29%
Borehamwood -18 3 £50,000 +11.11% 3
Rickmansworth - 3 £52,500 -
Bishop's Stortford - 2 £67,500 -
Knebworth - 1 £50,000 -
T-SQL
East of England

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

1 135 (90.60%) SQL
2 114 (76.51%) SQL Server
3 87 (58.39%) .NET
4 71 (47.65%) C#
5 67 (44.97%) Microsoft
6 65 (43.62%) SQL Server Integration Services
7 49 (32.89%) ETL
8 48 (32.21%) MVC
9 44 (29.53%) Business Intelligence
9 44 (29.53%) HTML
10 42 (28.19%) JavaScript
11 41 (27.52%) CSS
11 41 (27.52%) SQL Server Reporting Services
12 40 (26.85%) Web Services
13 39 (26.17%) SQL Server Analysis Services
14 36 (24.16%) Agile Software Development
15 35 (23.49%) Data Warehouse
16 34 (22.82%) SQL Server 2012
17 33 (22.15%) PowerShell
18 30 (20.13%) Unit Testing
18 30 (20.13%) ASP.NET
18 30 (20.13%) AngularJS
19 29 (19.46%) Team Foundation Server
19 29 (19.46%) jQuery
20 28 (18.79%) SOAP
20 28 (18.79%) REST
21 25 (16.78%) ASP.NET Web API
22 24 (16.11%) SAP
22 24 (16.11%) Data Modelling
23 23 (15.44%) .NET Framework

T-SQL
Co-occurring IT Skills in Hertfordshire 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 8 (5.37%) IIS
2 6 (4.03%) Apache
2 6 (4.03%) Drupal
2 6 (4.03%) Tomcat
3 5 (3.36%) SAS
4 1 (0.67%) CMS
4 1 (0.67%) DNN
4 1 (0.67%) LiveLink
4 1 (0.67%) SharePoint
4 1 (0.67%) Umbraco
Applications
1 10 (6.71%) Microsoft Excel
2 5 (3.36%) SPSS
3 2 (1.34%) Microsoft Office
4 1 (0.67%) Adobe Illustrator
4 1 (0.67%) Photoshop
Business Applications
1 7 (4.70%) Dynamics CRM
2 5 (3.36%) Remedy ITSM
3 4 (2.68%) SAP SRM
4 3 (2.01%) Dynamics NAV
4 3 (2.01%) FastStats
5 1 (0.67%) SAP ERP
Cloud Services
1 20 (13.42%) Microsoft Azure
2 7 (4.70%) Amazon AWS
2 7 (4.70%) Amazon EC2
3 6 (4.03%) Adobe Creative Cloud
4 5 (3.36%) SaaS
5 1 (0.67%) Google Analytics
Communications & Networking
1 14 (9.40%) DNS
1 14 (9.40%) Firewall
2 6 (4.03%) FTP
2 6 (4.03%) HTTP
3 5 (3.36%) SSL
4 1 (0.67%) Internet
4 1 (0.67%) SMS
Database & Business Intelligence
1 114 (76.51%) SQL Server
2 65 (43.62%) SQL Server Integration Services
3 41 (27.52%) SQL Server Reporting Services
4 39 (26.17%) SQL Server Analysis Services
5 35 (23.49%) Data Warehouse
6 34 (22.82%) SQL Server 2012
7 21 (14.09%) Power BI
8 20 (13.42%) SQL Server 2008
8 20 (13.42%) SQL Server 2016
9 16 (10.74%) MS Access
9 16 (10.74%) SQL Server 2014
10 14 (9.40%) SAP Data Services
11 10 (6.71%) QlikView
12 9 (6.04%) Relational Database
12 9 (6.04%) SAP BW
13 8 (5.37%) Big Data
14 7 (4.70%) OLAP
15 6 (4.03%) DTS
15 6 (4.03%) RDBMS
15 6 (4.03%) Sybase ASE
Development Applications
1 29 (19.46%) Team Foundation Server
2 20 (13.42%) Visual Studio
3 12 (8.05%) Selenium
4 9 (6.04%) Jenkins
5 7 (4.70%) Flyway
5 7 (4.70%) SQL Server Management Studio (SSMS)
6 6 (4.03%) Cucumber
6 6 (4.03%) Git (software)
7 5 (3.36%) SpecFlow
8 4 (2.68%) Subversion
8 4 (2.68%) TeamCity
9 3 (2.01%) JIRA
9 3 (2.01%) WebDriver
10 2 (1.34%) Fiddler
10 2 (1.34%) git-flow
10 2 (1.34%) TestComplete
11 1 (0.67%) Appium
11 1 (0.67%) Calabash
11 1 (0.67%) Moq
11 1 (0.67%) Robot Framework
General
1 17 (11.41%) Finance
2 9 (6.04%) Marketing
3 8 (5.37%) Electronics
4 7 (4.70%) Advertising
4 7 (4.70%) Retail
5 4 (2.68%) Legal
6 1 (0.67%) Automotive
6 1 (0.67%) French Language
6 1 (0.67%) Pharmaceutical
Job Titles
1 95 (63.76%) Developer
2 33 (22.15%) .NET Developer
3 31 (20.81%) Business Intelligence Developer
4 20 (13.42%) C# Developer
5 16 (10.74%) Analyst
5 16 (10.74%) C# .NET Developer
6 15 (10.07%) DBA
6 15 (10.07%) SQL DBA
7 12 (8.05%) Senior Developer
8 11 (7.38%) ASP.NET MVC Developer
8 11 (7.38%) SQL Developer
9 10 (6.71%) Tester
9 10 (6.71%) Web Developer
10 9 (6.04%) ASP.NET Developer
10 9 (6.04%) Programmer
11 8 (5.37%) Senior DBA
11 8 (5.37%) Senior SQL DBA
12 7 (4.70%) Data Manager
12 7 (4.70%) Senior SQL Server DBA
12 7 (4.70%) Software Manager
Libraries, Frameworks & Software Standards
1 87 (58.39%) .NET
2 44 (29.53%) HTML
3 41 (27.52%) CSS
4 40 (26.85%) Web Services
5 30 (20.13%) AngularJS
5 30 (20.13%) ASP.NET
6 29 (19.46%) jQuery
7 28 (18.79%) REST
7 28 (18.79%) SOAP
8 25 (16.78%) ASP.NET Web API
9 23 (15.44%) .NET Framework
9 23 (15.44%) ASP.NET MVC
10 22 (14.77%) HTML5
11 20 (13.42%) Entity Framework
12 19 (12.75%) MDX
13 18 (12.08%) JSON
14 17 (11.41%) WCF
15 16 (10.74%) XML
16 14 (9.40%) Ionic Framework
17 13 (8.72%) Twitter Bootstrap
Miscellaneous
1 15 (10.07%) Analytical Skills
2 6 (4.03%) Greenfield Project
2 6 (4.03%) User Experience
3 5 (3.36%) Computer Science
4 4 (2.68%) Virtual Team
5 2 (1.34%) Clustering
5 2 (1.34%) Management Information System
6 1 (0.67%) Enterprise Software
Operating Systems
1 6 (4.03%) Unix
1 6 (4.03%) Windows
2 3 (2.01%) Windows Server
Processes & Methodologies
1 49 (32.89%) ETL
2 48 (32.21%) MVC
3 44 (29.53%) Business Intelligence
4 36 (24.16%) Agile Software Development
5 30 (20.13%) Unit Testing
6 24 (16.11%) Data Modelling
7 23 (15.44%) Kimball Methodology
8 21 (14.09%) Web Development
9 20 (13.42%) Performance Tuning
10 16 (10.74%) Database Tuning
10 16 (10.74%) ETL Development
10 16 (10.74%) Inmon Methodology
11 13 (8.72%) BDD
12 11 (7.38%) Test Automation
13 10 (6.71%) CRM
13 10 (6.71%) TDD
13 10 (6.71%) Time Management
14 9 (6.04%) E-Commerce
15 8 (5.37%) Scrum
15 8 (5.37%) SOA
Programming Languages
1 135 (90.60%) SQL
2 71 (47.65%) C#
3 42 (28.19%) JavaScript
4 33 (22.15%) PowerShell
5 20 (13.42%) Java
6 18 (12.08%) VBA
7 17 (11.41%) TypeScript
8 12 (8.05%) VB.NET
9 8 (5.37%) PL/SQL
9 8 (5.37%) XAML
10 7 (4.70%) PHP
11 6 (4.03%) Python
11 6 (4.03%) Shell Script
11 6 (4.03%) XQuery
12 5 (3.36%) XPath
13 3 (2.01%) VB
14 2 (1.34%) C
14 2 (1.34%) C++
15 1 (0.67%) R
Qualifications
1 18 (12.08%) Degree
2 4 (2.68%) Computer Science Degree
3 1 (0.67%) ISEB
3 1 (0.67%) ISTQB
3 1 (0.67%) ISTQB Foundation Certification
3 1 (0.67%) ITIL Certification
Quality Assurance & Compliance
1 12 (8.05%) QA
2 6 (4.03%) RosettaNet
3 4 (2.68%) SLA
4 3 (2.01%) Data Quality
5 1 (0.67%) DICOM
5 1 (0.67%) HL7
Vendors
1 67 (44.97%) Microsoft
2 24 (16.11%) SAP
3 18 (12.08%) Cognos
4 16 (10.74%) IBM
5 9 (6.04%) Xamarin
6 7 (4.70%) Adobe
6 7 (4.70%) Oracle
7 6 (4.03%) Sybase
7 6 (4.03%) Tableau
8 5 (3.36%) Remedy
9 3 (2.01%) RedGate
10 2 (1.34%) Google
11 1 (0.67%) Twitter