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

Transact-SQL
East of England > Hertfordshire
6 months to
16 Oct 2018
Same period 2017 Same period 2016
Rank 70 86 66
Rank change year-on-year +16 -20 -21
Permanent jobs citing T-SQL 155 149 177
As % of all permanent IT jobs advertised in Hertfordshire 3.84% 3.53% 4.01%
As % of the Programming Languages category 7.61% 6.63% 8.73%
Number of salaries quoted 141 126 156
Hertfordshire median annual salary £45,000 £45,000 £45,000
10th Percentile £25,000 £31,250 £32,500
90th Percentile £65,000 £61,250 £70,000
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 2,036 2,249 2,028
As % of all permanent IT jobs advertised in Hertfordshire 50.40% 53.36% 46.00%
Number of salaries quoted 1,726 1,962 1,741
Hertfordshire median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £31,250 £29,250
90th Percentile £72,500 £67,500 £68,750
East of England median annual salary £47,500 £45,000 £45,000
% 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 October 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 October 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 +23 77 £45,000 -5.26% 5
Welwyn Garden City -12 27 £55,000 +22.22%
Rickmansworth +8 13 £55,000 +4.76% 1
St Albans -5 8 £35,000 -
Waltham Cross - 5 £47,500 - 5
Stevenage +3 3 £42,500 +21.43% 1
Cheshunt - 2 £42,500 -
Letchworth +12 1 £45,000 +5.88%
Abbots Langley - 1 £60,000 - 1
Royston - 1 £48,000 -
T-SQL
East of England

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

1 149 (96.13%) SQL
2 96 (61.94%) SQL Server Reporting Services
3 92 (59.35%) SQL Server
4 90 (58.06%) C#
5 63 (40.65%) SQL Server Integration Services
6 59 (38.06%) Business Intelligence
7 55 (35.48%) Microsoft
8 54 (34.84%) ETL
9 51 (32.90%) .NET
10 50 (32.26%) Agile Software Development
11 49 (31.61%) SQL Server Analysis Services
12 48 (30.97%) VBA
12 48 (30.97%) JavaScript
12 48 (30.97%) Microsoft Excel
13 46 (29.68%) Data Warehouse
14 44 (28.39%) Power BI
15 43 (27.74%) Analytical Skills
16 40 (25.81%) HTML
16 40 (25.81%) Migration
17 38 (24.52%) Problem-Solving
18 35 (22.58%) Computer Science
19 34 (21.94%) Visualisation
19 34 (21.94%) MVC
19 34 (21.94%) Web Services
20 32 (20.65%) Java
20 32 (20.65%) PL/SQL
21 31 (20.00%) Data Migration
22 30 (19.35%) Scaled Agile Framework
23 27 (17.42%) Degree
24 26 (16.77%) Finance

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 9 (5.81%) SharePoint
2 6 (3.87%) Tomcat
3 4 (2.58%) Apache
3 4 (2.58%) Confluence
4 2 (1.29%) Elasticsearch
4 2 (1.29%) JBoss
4 2 (1.29%) WebSphere
4 2 (1.29%) WebSphere Application Server
Applications
1 48 (30.97%) Microsoft Excel
2 1 (0.65%) Microsoft PowerPoint
Business Applications
1 13 (8.39%) Cognos Business Intelligence
1 13 (8.39%) Cognos TM1
2 8 (5.16%) Dynamics CRM
2 8 (5.16%) Dynamics NAV
3 1 (0.65%) Aareon QL
3 1 (0.65%) Oracle Assets
3 1 (0.65%) Oracle Cash Management
3 1 (0.65%) Oracle Payables
3 1 (0.65%) Oracle Receivables
3 1 (0.65%) Unit4 Business World
Cloud Services
1 17 (10.97%) Amazon AWS
2 11 (7.10%) Microsoft Azure
3 5 (3.23%) Office 365
Communications & Networking
1 5 (3.23%) DNS
1 5 (3.23%) Firewall
2 2 (1.29%) HTTP
2 2 (1.29%) Internet
2 2 (1.29%) TCP/IP
Database & Business Intelligence
1 96 (61.94%) SQL Server Reporting Services
2 92 (59.35%) SQL Server
3 63 (40.65%) SQL Server Integration Services
4 49 (31.61%) SQL Server Analysis Services
5 46 (29.68%) Data Warehouse
6 44 (28.39%) Power BI
7 22 (14.19%) MongoDB
7 22 (14.19%) MS Access
8 17 (10.97%) SQL Server 2016
9 14 (9.03%) Crystal Reports
9 14 (9.03%) OLAP
10 13 (8.39%) Data Mining
10 13 (8.39%) Microsoft Analysis Services
10 13 (8.39%) SQL Server 2012
11 12 (7.74%) NoSQL
12 11 (7.10%) Sybase ASE
13 9 (5.81%) PostgreSQL
14 6 (3.87%) MySQL
15 5 (3.23%) Big Data
15 5 (3.23%) SAP Data Services
Development Applications
1 13 (8.39%) Team Foundation Server
2 11 (7.10%) Jenkins
2 11 (7.10%) Selenium
3 9 (5.81%) JIRA
3 9 (5.81%) Subversion
4 7 (4.52%) Git (software)
5 6 (3.87%) Cucumber
5 6 (3.87%) Visual Studio
6 3 (1.94%) SpecFlow
6 3 (1.94%) WebDriver
7 2 (1.29%) JMeter
7 2 (1.29%) jMock
7 2 (1.29%) JUnit
General
1 26 (16.77%) Finance
2 17 (10.97%) Marketing
3 6 (3.87%) Retail
4 3 (1.94%) Games
5 2 (1.29%) Telecoms
6 1 (0.65%) General Ledger
6 1 (0.65%) Legal
Job Titles
1 124 (80.00%) Developer
2 38 (24.52%) Business Intelligence Developer
3 26 (16.77%) SQL Developer
4 20 (12.90%) Software Developer
5 15 (9.68%) Analyst
5 15 (9.68%) Data Migration Developer
5 15 (9.68%) Developer/Software Engineer
5 15 (9.68%) ETL Developer
5 15 (9.68%) Graduate
5 15 (9.68%) Graduate Developer
5 15 (9.68%) Graduate Software Engineer
5 15 (9.68%) Software Engineer
6 13 (8.39%) SQL Server Developer
7 12 (7.74%) Senior Developer
8 11 (7.10%) C# Developer
9 10 (6.45%) .NET Developer
9 10 (6.45%) Microsoft BI Developer
9 10 (6.45%) Microsoft Developer
9 10 (6.45%) Senior Business Intelligence Developer
10 9 (5.81%) Oracle ETL Developer
Libraries, Frameworks & Software Standards
1 51 (32.90%) .NET
2 40 (25.81%) HTML
3 34 (21.94%) Web Services
4 24 (15.48%) CSS
5 21 (13.55%) JSON
6 19 (12.26%) XML
7 17 (10.97%) REST
8 16 (10.32%) HTML5
8 16 (10.32%) MDX
9 15 (9.68%) .NET Framework
9 15 (9.68%) ASP.NET
10 14 (9.03%) ADO.NET
10 14 (9.03%) Entity Framework
11 13 (8.39%) Spring
12 10 (6.45%) jQuery
12 10 (6.45%) SOAP
13 9 (5.81%) Hibernate
14 8 (5.16%) AngularJS
14 8 (5.16%) Apache Flex
14 8 (5.16%) WPF
Miscellaneous
1 43 (27.74%) Analytical Skills
2 35 (22.58%) Computer Science
3 15 (9.68%) Reference Data
4 8 (5.16%) Greenfield Project
4 8 (5.16%) Mobile App
5 4 (2.58%) Management Information System
6 2 (1.29%) Data Structures
6 2 (1.29%) Replication
7 1 (0.65%) Fintech
Operating Systems
1 11 (7.10%) Windows
2 8 (5.16%) Linux
3 2 (1.29%) Unix
Processes & Methodologies
1 59 (38.06%) Business Intelligence
2 54 (34.84%) ETL
3 50 (32.26%) Agile Software Development
4 40 (25.81%) Migration
5 38 (24.52%) Problem-Solving
6 34 (21.94%) MVC
6 34 (21.94%) Visualisation
7 31 (20.00%) Data Migration
8 30 (19.35%) Scaled Agile Framework
9 24 (15.48%) Analytics
10 19 (12.26%) OO
11 18 (11.61%) BDD
11 18 (11.61%) Test Automation
12 17 (10.97%) Data Analysis
12 17 (10.97%) OOP
13 15 (9.68%) Data Mapping
13 15 (9.68%) Mathematics
13 15 (9.68%) Physics
13 15 (9.68%) Software Engineering
13 15 (9.68%) TDD
Programming Languages
1 149 (96.13%) SQL
2 90 (58.06%) C#
3 48 (30.97%) JavaScript
3 48 (30.97%) VBA
4 32 (20.65%) Java
4 32 (20.65%) PL/SQL
5 16 (10.32%) Python
5 16 (10.32%) VBScript
6 13 (8.39%) PowerShell
7 12 (7.74%) C++
7 12 (7.74%) Go
8 10 (6.45%) Data Analysis Expressions (DAX)
8 10 (6.45%) VB
9 9 (5.81%) PHP
10 8 (5.16%) Pascal
10 8 (5.16%) VB.NET
11 5 (3.23%) TypeScript
12 4 (2.58%) C
13 2 (1.29%) Shell Script
Qualifications
1 27 (17.42%) Degree
2 15 (9.68%) PhD
2 15 (9.68%) SC Cleared
2 15 (9.68%) Security Cleared
3 1 (0.65%) Computer Science Degree
3 1 (0.65%) DBS Check
Quality Assurance & Compliance
1 15 (9.68%) Data Quality
System Software
1 2 (1.29%) Hyper-V
1 2 (1.29%) VirtualBox
1 2 (1.29%) VMware Infrastructure
Systems Management
1 1 (0.65%) Microsoft Clustering
Vendors
1 55 (35.48%) Microsoft
2 24 (15.48%) Talend
3 16 (10.32%) Oracle
4 15 (9.68%) Cognos
4 15 (9.68%) Sybase
4 15 (9.68%) Tableau
5 14 (9.03%) Salesforce.com
6 5 (3.23%) SAP
7 2 (1.29%) AppDynamics
7 2 (1.29%) New Relic
7 2 (1.29%) VMware
8 1 (0.65%) Aareon
8 1 (0.65%) IBM
8 1 (0.65%) MicroStrategy
8 1 (0.65%) RedGate