Period
to 23 July 2017

The following table provides summary statistics for contract job vacancies advertised in Hertfordshire with a requirement for T-SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited T-SQL over the 6 months to 23 July 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Transact-SQL
East of England > Hertfordshire
6 months to
23 Jul 2017
Same period 2016 Same period 2015
Rank 58 62 81
Rank change year-on-year +4 +19 -19
Contract jobs citing T-SQL 33 28 26
As % of all contract IT jobs advertised in Hertfordshire 2.58% 2.00% 1.60%
As % of the Programming Languages category 6.83% 7.00% 4.67%
Number of daily rates quoted 22 15 19
Hertfordshire median daily rate £350 £388 £360
Median daily rate % change year-on-year -9.68% +7.64% -4.00%
10th Percentile £258 £248 £287
90th Percentile £500 £453 £505
East of England median daily rate £350 £350 £350
Number of hourly rates quoted 0 0 0
Hertfordshire median hourly rate - - -
East of England median hourly rate £37.50 £40.00 -
% change year-on-year -6.25% - -

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Hertfordshire with a requirement for programming language skills.

Contract Programming Language Skills
Hertfordshire
Contract job vacancies with a requirement for programming language skills 483 400 557
As % of all contract IT job vacancies advertised in Hertfordshire 37.79% 28.61% 34.34%
Number of daily rates quoted 281 224 257
Hertfordshire median daily rate £410 £389 £363
Median daily rate % change year-on-year +5.47% +7.24% +3.57%
10th Percentile £256 £263 £269
90th Percentile £588 £514 £488
East of England median daily rate £400 £375 £365
% change year-on-year +6.67% +2.74% +4.29%
Number of hourly rates quoted 29 22 25
Hertfordshire median hourly rate £42.50 £44.70 £32.50
Median hourly rate % change year-on-year -4.92% +37.54% -12.16%
10th Percentile £15.00 £11.96 £19.79
90th Percentile £53.15 £53.75 £40.15
East of England median hourly rate £40.00 £37.50 £37.50
% change year-on-year +6.67% - -

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
Contractor Daily Rate Trend in Hertfordshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing T-SQL in Hertfordshire.

Contractor daily rate trend for T-SQL in Hertfordshire

T-SQL
Contractor Daily Rate Histogram in Hertfordshire

The daily rate distribution of IT jobs citing T-SQL in Hertfordshire over the 6 months to 23 July 2017.

Contractor daily rate histogram for T-SQL in Hertfordshire

T-SQL
Contractor Hourly Rate Trend in Hertfordshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing T-SQL in Hertfordshire.

Contractor hourly rate trend for T-SQL in Hertfordshire

T-SQL
Contract Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing T-SQL within the Hertfordshire region over the 6 months to 23 July 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Watford +2 19 £350 +33.33% 1
Hemel Hempstead +14 7 £360 -7.40% 1
Hatfield -10 2 £339 - 2
Borehamwood 0 1 - -
T-SQL
East of England

For the 6 months to 23 July 2017, IT contractor 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 contract ads across the Hertfordshire region with a requirement for T-SQL.

1 32 (96.97%) SQL
2 21 (63.64%) SQL Server
3 19 (57.58%) C#
4 17 (51.52%) JavaScript
5 16 (48.48%) .NET
6 12 (36.36%) HTML
6 12 (36.36%) Finance
7 11 (33.33%) Web Services
7 11 (33.33%) SQL Server Reporting Services
7 11 (33.33%) AngularJS
8 10 (30.30%) HTML5
8 10 (30.30%) ASP.NET
8 10 (30.30%) Java
8 10 (30.30%) MVC
9 9 (27.27%) Migration
9 9 (27.27%) Hibernate
9 9 (27.27%) Microsoft
9 9 (27.27%) Sybase
9 9 (27.27%) Windows
9 9 (27.27%) Linux
9 9 (27.27%) JSP
9 9 (27.27%) Spring
9 9 (27.27%) Sybase ASE
10 8 (24.24%) MongoDB
10 8 (24.24%) SQL Server 2008
10 8 (24.24%) CSS
10 8 (24.24%) Crystal Reports
10 8 (24.24%) Twitter Bootstrap
11 7 (21.21%) Analytical Skills
11 7 (21.21%) C

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 (15.15%) Elasticsearch
2 3 (9.09%) IIS
3 1 (3.03%) CMS
Applications
1 1 (3.03%) Microsoft Excel
1 1 (3.03%) Microsoft Office
Business Applications
1 1 (3.03%) Oracle Assets
1 1 (3.03%) Oracle Cash Management
1 1 (3.03%) Oracle Payables
1 1 (3.03%) Oracle Receivables
Communications & Networking
1 1 (3.03%) SMS
Database & Business Intelligence
1 21 (63.64%) SQL Server
2 11 (33.33%) SQL Server Reporting Services
3 9 (27.27%) Sybase ASE
4 8 (24.24%) Crystal Reports
4 8 (24.24%) MongoDB
4 8 (24.24%) SQL Server 2008
5 7 (21.21%) SQL Server Integration Services
6 6 (18.18%) Data Warehouse
6 6 (18.18%) PostgreSQL
7 5 (15.15%) SQL Server 2012
8 4 (12.12%) Big Data
8 4 (12.12%) SQL Server Analysis Services
9 3 (9.09%) Data Lake
9 3 (9.09%) Power BI
9 3 (9.09%) SQL Server 2014
10 2 (6.06%) DTS
10 2 (6.06%) OLAP Cube
10 2 (6.06%) QlikView
10 2 (6.06%) RDBMS
10 2 (6.06%) Relational Database
Development Applications
1 5 (15.15%) Talend Open Studio
1 5 (15.15%) Visual Studio
2 2 (6.06%) Jenkins
2 2 (6.06%) JMeter
2 2 (6.06%) jMock
2 2 (6.06%) JUnit
2 2 (6.06%) Selenium
General
1 12 (36.36%) Finance
2 1 (3.03%) General Ledger
2 1 (3.03%) Legal
2 1 (3.03%) Telecoms
Job Titles
1 26 (78.79%) Developer
2 9 (27.27%) Java Developer
3 7 (21.21%) .NET Developer
4 5 (15.15%) Consultant
4 5 (15.15%) SQL Developer
4 5 (15.15%) SQL Server Consultant
5 4 (12.12%) ASP.NET Developer
5 4 (12.12%) C# .NET Developer
5 4 (12.12%) C# Developer
6 3 (9.09%) ASP.NET MVC Developer
6 3 (9.09%) Business Intelligence Developer
6 3 (9.09%) Java Engineer
6 3 (9.09%) Web Developer
7 2 (6.06%) Analyst Developer
7 2 (6.06%) Business Intelligence Analyst
7 2 (6.06%) C# ASP.NET Developer
7 2 (6.06%) Developer Analyst
7 2 (6.06%) SQL Server Developer
7 2 (6.06%) VB.NET Developer
7 2 (6.06%) VB.NET/ASP.NET Developer
Libraries, Frameworks & Software Standards
1 16 (48.48%) .NET
2 12 (36.36%) HTML
3 11 (33.33%) AngularJS
3 11 (33.33%) Web Services
4 10 (30.30%) ASP.NET
4 10 (30.30%) HTML5
5 9 (27.27%) Hibernate
5 9 (27.27%) JSP
5 9 (27.27%) Spring
6 8 (24.24%) CSS
6 8 (24.24%) Twitter Bootstrap
7 6 (18.18%) ASP.NET MVC
7 6 (18.18%) CSS3
7 6 (18.18%) J2EE
7 6 (18.18%) jQuery
8 5 (15.15%) Classic ASP
8 5 (15.15%) JSON
8 5 (15.15%) XHTML
8 5 (15.15%) XML
9 4 (12.12%) Spring Boot
Miscellaneous
1 7 (21.21%) Analytical Skills
2 5 (15.15%) Reference Data
3 2 (6.06%) Greenfield Project
3 2 (6.06%) Tandem
4 1 (3.03%) Computer Science
4 1 (3.03%) IVR
4 1 (3.03%) Mobile App
4 1 (3.03%) NHS
Operating Systems
1 9 (27.27%) Linux
1 9 (27.27%) Windows
2 2 (6.06%) Unix
3 1 (3.03%) Red Hat Enterprise Linux
Processes & Methodologies
1 10 (30.30%) MVC
2 9 (27.27%) Migration
3 6 (18.18%) Agile Software Development
3 6 (18.18%) Data Migration
4 5 (15.15%) Data Mapping
4 5 (15.15%) Database Tuning
4 5 (15.15%) ETL
4 5 (15.15%) Microservices
5 4 (12.12%) Web Development
6 3 (9.09%) Business Intelligence
6 3 (9.09%) Data Modelling
6 3 (9.09%) Kimball Methodology
7 2 (6.06%) BDD
7 2 (6.06%) Data Integration
7 2 (6.06%) Requirements Analysis
7 2 (6.06%) Stakeholder Management
7 2 (6.06%) TDD
7 2 (6.06%) Time Management
7 2 (6.06%) Web Application Development
7 2 (6.06%) Workflow
Programming Languages
1 32 (96.97%) SQL
2 19 (57.58%) C#
3 17 (51.52%) JavaScript
4 10 (30.30%) Java
5 7 (21.21%) C
6 4 (12.12%) PL/SQL
6 4 (12.12%) VB.NET
7 3 (9.09%) Python
7 3 (9.09%) VBScript
8 1 (3.03%) C++
8 1 (3.03%) MATLAB
8 1 (3.03%) R
8 1 (3.03%) VBA
Qualifications
1 5 (15.15%) SC Cleared
1 5 (15.15%) Security Cleared
2 2 (6.06%) Degree
Quality Assurance & Compliance
1 5 (15.15%) Data Quality
Vendors
1 9 (27.27%) Microsoft
1 9 (27.27%) Sybase
2 5 (15.15%) Talend
3 4 (12.12%) Oracle
4 1 (3.03%) Avaya
4 1 (3.03%) Blue Prism
4 1 (3.03%) Mitel
4 1 (3.03%) Red Hat
4 1 (3.03%) SAP