Period
to 16 January 2018

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

Transact-SQL
East of England > Hertfordshire
6 months to
16 Jan 2018
Same period 2017 Same period 2016
Rank 89 68 38
Rank change year-on-year -21 -30 +67
Permanent jobs citing T-SQL 132 172 300
As % of all permanent IT jobs advertised in Hertfordshire 2.97% 3.91% 5.97%
As % of the Programming Languages category 5.67% 7.84% 13.19%
Number of salaries quoted 113 152 288
Hertfordshire median annual salary £50,000 £45,000 £47,500
Median salary % change year-on-year +11.11% -5.26% +18.75%
10th Percentile £31,250 £31,250 £26,750
90th Percentile £67,500 £55,000 £65,000
East of England median annual salary £45,000 £43,000 £45,000
% change year-on-year +4.65% -4.44% +8.43%

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 2,330 2,195 2,274
As % of all permanent IT jobs advertised in Hertfordshire 52.45% 49.93% 45.28%
Number of salaries quoted 2,030 1,885 1,986
Hertfordshire median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £31,250 £29,000 £27,000
90th Percentile £67,600 £68,750 £67,500
East of England median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% -

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 16 January 2018.

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 16 January 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
Watford +18 40 £55,000 - 4
Welwyn Garden City -6 13 £45,000 +12.50%
St Albans -19 11 £40,000 -5.88% 6
Hemel Hempstead -6 8 £47,500 +11.76% 3
Stevenage +9 7 £35,000 +2.94%
Hatfield +4 7 £55,000 - 1
Borehamwood -13 7 £50,000 -4.76%
Hitchin 0 6 £35,000 +6.06%
Rickmansworth -6 6 £52,500 +16.67% 1
Broxbourne +3 5 £45,000 -5.26%
Bishop's Stortford - 2 £67,500 -
Letchworth - 2 £38,750 -
Harpenden -12 1 - -
Knebworth - 1 £50,000 -
T-SQL
East of England

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

1 124 (93.94%) SQL
2 105 (79.55%) SQL Server
3 75 (56.82%) .NET
4 70 (53.03%) Microsoft
5 61 (46.21%) SQL Server Integration Services
6 58 (43.94%) C#
7 48 (36.36%) Business Intelligence
8 45 (34.09%) SQL Server Reporting Services
9 43 (32.58%) SQL Server Analysis Services
10 42 (31.82%) ETL
10 42 (31.82%) MVC
11 40 (30.30%) Data Warehouse
12 39 (29.55%) Agile Software Development
13 37 (28.03%) JavaScript
13 37 (28.03%) Web Services
14 36 (27.27%) PowerShell
15 35 (26.52%) Team Foundation Server
16 31 (23.48%) HTML
17 30 (22.73%) CSS
17 30 (22.73%) SOAP
18 29 (21.97%) Unit Testing
18 29 (21.97%) REST
18 29 (21.97%) SQL Server 2012
18 29 (21.97%) AngularJS
19 27 (20.45%) Kimball Methodology
19 27 (20.45%) Power BI
19 27 (20.45%) .NET Framework
19 27 (20.45%) Data Modelling
20 25 (18.94%) SAP
21 24 (18.18%) Cognos

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 5 (3.79%) Apache
1 5 (3.79%) Drupal
1 5 (3.79%) Tomcat
2 4 (3.03%) IIS
3 3 (2.27%) SAS
4 1 (0.76%) CMS
4 1 (0.76%) DNN
4 1 (0.76%) SharePoint
Applications
1 10 (7.58%) Microsoft Excel
2 3 (2.27%) SPSS
3 2 (1.52%) Microsoft Office
Business Applications
1 6 (4.55%) Remedy ITSM
2 4 (3.03%) SAP SRM
3 1 (0.76%) Dynamics CRM
3 1 (0.76%) SAP ERP
Cloud Services
1 18 (13.64%) Microsoft Azure
2 9 (6.82%) Amazon AWS
3 7 (5.30%) Amazon EC2
4 5 (3.79%) Adobe Creative Cloud
4 5 (3.79%) SaaS
Communications & Networking
1 17 (12.88%) DNS
1 17 (12.88%) Firewall
2 7 (5.30%) FTP
2 7 (5.30%) HTTP
3 6 (4.55%) SSL
4 1 (0.76%) Internet
4 1 (0.76%) SMS
Database & Business Intelligence
1 105 (79.55%) SQL Server
2 61 (46.21%) SQL Server Integration Services
3 45 (34.09%) SQL Server Reporting Services
4 43 (32.58%) SQL Server Analysis Services
5 40 (30.30%) Data Warehouse
6 29 (21.97%) SQL Server 2012
7 27 (20.45%) Power BI
8 24 (18.18%) SQL Server 2016
9 20 (15.15%) MS Access
9 20 (15.15%) SQL Server 2014
10 17 (12.88%) SAP Data Services
11 12 (9.09%) SAP BW
12 8 (6.06%) SQL Server 2008
12 8 (6.06%) Sybase ASE
13 7 (5.30%) Microsoft Analysis Services
14 6 (4.55%) QlikView
14 6 (4.55%) Relational Database
14 6 (4.55%) SQL Server 2005
15 5 (3.79%) Snowflake Schema
15 5 (3.79%) Star Schema
Development Applications
1 35 (26.52%) Team Foundation Server
2 17 (12.88%) Visual Studio
3 14 (10.61%) Selenium
4 12 (9.09%) SQL Server Management Studio (SSMS)
5 11 (8.33%) Jenkins
6 7 (5.30%) Flyway
6 7 (5.30%) Git (software)
7 5 (3.79%) Cucumber
7 5 (3.79%) SpecFlow
7 5 (3.79%) TeamCity
8 3 (2.27%) JIRA
8 3 (2.27%) JMeter
8 3 (2.27%) jMock
8 3 (2.27%) JUnit
8 3 (2.27%) Octopus Deploy
8 3 (2.27%) ReSharper
8 3 (2.27%) WebDriver
9 2 (1.52%) git-flow
9 2 (1.52%) TestComplete
10 1 (0.76%) Moq
General
1 16 (12.12%) Finance
2 12 (9.09%) Advertising
3 7 (5.30%) Retail
4 5 (3.79%) Marketing
5 4 (3.03%) Electronics
5 4 (3.03%) Legal
6 1 (0.76%) French Language
Job Titles
1 81 (61.36%) Developer
2 34 (25.76%) Business Intelligence Developer
3 22 (16.67%) .NET Developer
4 14 (10.61%) C# Developer
5 12 (9.09%) DBA
5 12 (9.09%) SQL DBA
6 11 (8.33%) Analyst
7 10 (7.58%) ASP.NET MVC Developer
7 10 (7.58%) C# .NET Developer
7 10 (7.58%) Tester
8 9 (6.82%) Software Manager
9 8 (6.06%) Angular Developer
9 8 (6.06%) Java Developer
9 8 (6.06%) Senior DBA
9 8 (6.06%) Senior Developer
9 8 (6.06%) Senior SQL DBA
9 8 (6.06%) SQL Developer
9 8 (6.06%) SQL Server DBA
10 7 (5.30%) Business Developer
10 7 (5.30%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 75 (56.82%) .NET
2 37 (28.03%) Web Services
3 31 (23.48%) HTML
4 30 (22.73%) CSS
4 30 (22.73%) SOAP
5 29 (21.97%) AngularJS
5 29 (21.97%) REST
6 27 (20.45%) .NET Framework
7 23 (17.42%) ASP.NET
8 22 (16.67%) ASP.NET Web API
9 21 (15.91%) Entity Framework
10 20 (15.15%) ASP.NET MVC
10 20 (15.15%) jQuery
10 20 (15.15%) MDX
11 16 (12.12%) XML
12 14 (10.61%) JSON
13 11 (8.33%) HTML5
13 11 (8.33%) Twitter Bootstrap
13 11 (8.33%) WCF
14 9 (6.82%) Spring
Miscellaneous
1 15 (11.36%) Analytical Skills
2 5 (3.79%) Greenfield Project
2 5 (3.79%) User Experience
2 5 (3.79%) Virtual Team
3 4 (3.03%) Clustering
4 3 (2.27%) Computer Science
4 3 (2.27%) Management Information System
5 2 (1.52%) Reference Data
6 1 (0.76%) Data Structures
6 1 (0.76%) Enterprise Software
6 1 (0.76%) NHS
Operating Systems
1 8 (6.06%) Windows
2 7 (5.30%) Unix
3 3 (2.27%) Linux
Processes & Methodologies
1 48 (36.36%) Business Intelligence
2 42 (31.82%) ETL
2 42 (31.82%) MVC
3 39 (29.55%) Agile Software Development
4 29 (21.97%) Unit Testing
5 27 (20.45%) Data Modelling
5 27 (20.45%) Kimball Methodology
6 23 (17.42%) Performance Tuning
7 22 (16.67%) Database Tuning
8 20 (15.15%) ETL Development
8 20 (15.15%) Inmon Methodology
9 16 (12.12%) Scrum
10 13 (9.85%) Web Development
11 12 (9.09%) TDD
11 12 (9.09%) Test Automation
12 10 (7.58%) BDD
12 10 (7.58%) ITSM
13 9 (6.82%) Data Mapping
13 9 (6.82%) Dimensional Modelling
13 9 (6.82%) SOLID
Programming Languages
1 124 (93.94%) SQL
2 58 (43.94%) C#
3 37 (28.03%) JavaScript
4 36 (27.27%) PowerShell
5 21 (15.91%) Java
5 21 (15.91%) VBA
6 12 (9.09%) TypeScript
7 11 (8.33%) PL/SQL
8 7 (5.30%) Shell Script
8 7 (5.30%) VB.NET
8 7 (5.30%) XQuery
9 6 (4.55%) Python
9 6 (4.55%) XPath
10 5 (3.79%) PHP
11 4 (3.03%) XAML
12 2 (1.52%) C
12 2 (1.52%) C++
12 2 (1.52%) VB
13 1 (0.76%) R
Qualifications
1 12 (9.09%) Degree
2 2 (1.52%) SC Cleared
2 2 (1.52%) Security Cleared
3 1 (0.76%) Computer Science Degree
3 1 (0.76%) ISEB
3 1 (0.76%) ISTQB
3 1 (0.76%) ISTQB Foundation Certification
3 1 (0.76%) ITIL Certification
3 1 (0.76%) MCSA
3 1 (0.76%) Microsoft Certification
Quality Assurance & Compliance
1 12 (9.09%) QA
2 7 (5.30%) RosettaNet
3 2 (1.52%) Data Quality
4 1 (0.76%) DICOM
4 1 (0.76%) HL7
4 1 (0.76%) SLA
Vendors
1 70 (53.03%) Microsoft
2 25 (18.94%) SAP
3 24 (18.18%) Cognos
4 21 (15.91%) IBM
5 12 (9.09%) Oracle
6 8 (6.06%) Sybase
7 7 (5.30%) Tableau
8 6 (4.55%) Remedy
9 5 (3.79%) Adobe
10 4 (3.03%) Xamarin
11 1 (0.76%) Google
11 1 (0.76%) New Relic
11 1 (0.76%) Twitter