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

Transact-SQL
East of England > Hertfordshire
6 months to
21 Jul 2018
Same period 2017 Same period 2016
Rank 117 96 78
Rank change year-on-year -21 -18 -17
Permanent jobs citing T-SQL 109 132 172
As % of all permanent IT jobs advertised in Hertfordshire 2.39% 3.04% 3.59%
As % of the Programming Languages category 4.61% 6.09% 8.74%
Number of salaries quoted 96 112 151
Hertfordshire median annual salary £50,000 £45,000 £45,000
Median salary % change year-on-year +11.11% - -
10th Percentile £32,125 £33,300 £32,500
90th Percentile £60,000 £61,250 £70,000
East of England median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +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,362 2,169 1,968
As % of all permanent IT jobs advertised in Hertfordshire 51.72% 50.01% 41.09%
Number of salaries quoted 2,011 1,899 1,635
Hertfordshire median annual salary £50,000 £47,000 £45,000
Median salary % change year-on-year +6.38% +4.44% -
10th Percentile £30,500 £31,250 £29,000
90th Percentile £72,500 £70,000 £68,750
East of England median annual salary £47,500 £45,000 £43,000
% change year-on-year +5.56% +4.65% +1.18%

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 21 July 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 21 July 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 +25 44 £50,000 +11.11% 7
Rickmansworth +10 17 £55,000 +22.22% 1
Welwyn Garden City -25 16 £47,500 +35.71% 1
Hemel Hempstead +5 9 £35,500 -21.11% 1
St Albans -14 9 £35,000 -22.22%
Hatfield -18 4 £50,000 +17.65%
Stevenage - 2 £42,500 - 3
Letchworth +22 1 £45,000 +2.86%
Royston - 1 £48,000 -
T-SQL
East of England

For the 6 months to 21 July 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 103 (94.50%) SQL
2 70 (64.22%) SQL Server
2 70 (64.22%) SQL Server Reporting Services
3 56 (51.38%) Business Intelligence
4 53 (48.62%) SQL Server Integration Services
5 50 (45.87%) Microsoft
6 48 (44.04%) ETL
7 45 (41.28%) SQL Server Analysis Services
8 42 (38.53%) Data Warehouse
9 41 (37.61%) Power BI
10 35 (32.11%) C#
11 32 (29.36%) Visualisation
12 30 (27.52%) .NET
13 27 (24.77%) VBA
14 26 (23.85%) Microsoft Excel
15 25 (22.94%) Analytical Skills
16 23 (21.10%) Agile Software Development
17 22 (20.18%) Degree
18 21 (19.27%) Finance
18 21 (19.27%) JavaScript
19 20 (18.35%) HTML
19 20 (18.35%) Java
20 19 (17.43%) MVC
20 19 (17.43%) REST
21 18 (16.51%) Microsoft Azure
21 18 (16.51%) Web Services
22 16 (14.68%) MongoDB
23 15 (13.76%) SQL Server 2012
23 15 (13.76%) Sybase
24 14 (12.84%) Migration

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 7 (6.42%) Tomcat
2 6 (5.50%) Apache
3 3 (2.75%) Confluence
3 3 (2.75%) SharePoint
4 1 (0.92%) JBoss
4 1 (0.92%) WebSphere
4 1 (0.92%) WebSphere Application Server
Applications
1 26 (23.85%) Microsoft Excel
2 1 (0.92%) Microsoft PowerPoint
Business Applications
1 8 (7.34%) Cognos Business Intelligence
1 8 (7.34%) Cognos TM1
2 3 (2.75%) Oracle Assets
2 3 (2.75%) Oracle Cash Management
2 3 (2.75%) Oracle Payables
2 3 (2.75%) Oracle Receivables
3 1 (0.92%) Aareon QL
3 1 (0.92%) Unit4 Business World
Cloud Services
1 18 (16.51%) Microsoft Azure
2 7 (6.42%) Amazon AWS
3 5 (4.59%) Office 365
Communications & Networking
1 4 (3.67%) DNS
1 4 (3.67%) Firewall
Database & Business Intelligence
1 70 (64.22%) SQL Server
1 70 (64.22%) SQL Server Reporting Services
2 53 (48.62%) SQL Server Integration Services
3 45 (41.28%) SQL Server Analysis Services
4 42 (38.53%) Data Warehouse
5 41 (37.61%) Power BI
6 16 (14.68%) MongoDB
7 15 (13.76%) SQL Server 2012
8 14 (12.84%) Sybase ASE
9 13 (11.93%) SQL Server 2016
10 12 (11.01%) MS Access
11 9 (8.26%) Big Data
12 8 (7.34%) Data Mining
12 8 (7.34%) Microsoft Analysis Services
12 8 (7.34%) OLAP
12 8 (7.34%) Snowflake Schema
12 8 (7.34%) Star Schema
13 7 (6.42%) SQL Server 2008
14 6 (5.50%) MySQL
14 6 (5.50%) NoSQL
Development Applications
1 10 (9.17%) Jenkins
1 10 (9.17%) Selenium
2 9 (8.26%) SQL Server Management Studio (SSMS)
2 9 (8.26%) Team Foundation Server
3 6 (5.50%) Cucumber
4 5 (4.59%) Git (software)
5 4 (3.67%) JMeter
5 4 (3.67%) jMock
5 4 (3.67%) JUnit
6 3 (2.75%) Octopus Deploy
6 3 (2.75%) ReSharper
6 3 (2.75%) TeamCity
7 2 (1.83%) Bitbucket
7 2 (1.83%) Visual Studio
General
1 21 (19.27%) Finance
2 10 (9.17%) Marketing
3 9 (8.26%) Advertising
4 3 (2.75%) General Ledger
5 2 (1.83%) Retail
6 1 (0.92%) Law
6 1 (0.92%) Legal
Job Titles
1 68 (62.39%) Developer
2 30 (27.52%) Business Intelligence Developer
3 21 (19.27%) Analyst
4 17 (15.60%) SQL Developer
5 10 (9.17%) Business Intelligence Analyst
6 8 (7.34%) Data Analyst
6 8 (7.34%) Microsoft BI Developer
6 8 (7.34%) Microsoft Developer
6 8 (7.34%) SQL Analyst
7 7 (6.42%) ETL Developer
7 7 (6.42%) Java Developer
7 7 (6.42%) SQL BI Developer
8 6 (5.50%) Analyst Developer
8 6 (5.50%) Architect
8 6 (5.50%) Data Migration Developer
8 6 (5.50%) Data Warehouse Developer
8 6 (5.50%) Digital Architect
8 6 (5.50%) SSIS Developer
9 5 (4.59%) Report Developer
9 5 (4.59%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 30 (27.52%) .NET
2 20 (18.35%) HTML
3 19 (17.43%) REST
4 18 (16.51%) Web Services
5 14 (12.84%) HTML5
6 13 (11.93%) AngularJS
6 13 (11.93%) Spring
7 12 (11.01%) MDX
8 10 (9.17%) .NET Framework
8 10 (9.17%) CSS
9 9 (8.26%) XML
10 8 (7.34%) ASP.NET
10 8 (7.34%) ASP.NET MVC
10 8 (7.34%) SOAP
11 7 (6.42%) Entity Framework
11 7 (6.42%) Hibernate
11 7 (6.42%) JSP
11 7 (6.42%) Spring MVC
12 4 (3.67%) ADO.NET
12 4 (3.67%) Twitter Bootstrap
Miscellaneous
1 25 (22.94%) Analytical Skills
2 12 (11.01%) Computer Science
3 10 (9.17%) Greenfield Project
4 6 (5.50%) Reference Data
5 5 (4.59%) Data Structures
6 4 (3.67%) Fintech
7 3 (2.75%) Management Information System
8 1 (0.92%) Algorithms
8 1 (0.92%) Replication
Operating Systems
1 11 (10.09%) Windows
2 8 (7.34%) Linux
3 1 (0.92%) Unix
Processes & Methodologies
1 56 (51.38%) Business Intelligence
2 48 (44.04%) ETL
3 32 (29.36%) Visualisation
4 23 (21.10%) Agile Software Development
5 19 (17.43%) MVC
6 14 (12.84%) Analytics
6 14 (12.84%) Database Tuning
6 14 (12.84%) Migration
7 13 (11.93%) Data Migration
7 13 (11.93%) Problem-Solving
8 11 (10.09%) Unit Testing
9 10 (9.17%) Data Visualisation
9 10 (9.17%) Kimball Methodology
9 10 (9.17%) Performance Tuning
10 9 (8.26%) Scaled Agile Framework
10 9 (8.26%) TDD
11 8 (7.34%) Dashboard Development
11 8 (7.34%) Data Analysis
11 8 (7.34%) Data Modelling
11 8 (7.34%) OO
Programming Languages
1 103 (94.50%) SQL
2 35 (32.11%) C#
3 27 (24.77%) VBA
4 21 (19.27%) JavaScript
5 20 (18.35%) Java
6 12 (11.01%) Data Analysis Expressions (DAX)
6 12 (11.01%) PL/SQL
7 11 (10.09%) PowerShell
8 10 (9.17%) Python
9 6 (5.50%) Go
10 3 (2.75%) TypeScript
11 2 (1.83%) C
11 2 (1.83%) C++
11 2 (1.83%) VB
12 1 (0.92%) R
12 1 (0.92%) Shell Script
Qualifications
1 22 (20.18%) Degree
2 6 (5.50%) SC Cleared
2 6 (5.50%) Security Cleared
3 4 (3.67%) PhD
4 2 (1.83%) DBS Check
Quality Assurance & Compliance
1 6 (5.50%) Data Quality
Vendors
1 50 (45.87%) Microsoft
2 15 (13.76%) Sybase
3 11 (10.09%) Cognos
3 11 (10.09%) Tableau
4 9 (8.26%) Oracle
5 5 (4.59%) SAP
6 4 (3.67%) Salesforce.com
6 4 (3.67%) Talend
7 3 (2.75%) New Relic
8 2 (1.83%) IBM
9 1 (0.92%) Aareon
9 1 (0.92%) AppDynamics
9 1 (0.92%) MicroStrategy
9 1 (0.92%) Xamarin