Period
to 21 November 2017

The following table provides summary statistics for contract job vacancies advertised in Watford 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 21 November 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
Hertfordshire > Watford
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 26 29 29
Rank change year-on-year +3 0 -8
Contract jobs citing T-SQL 21 13 7
As % of all contract IT jobs advertised in Watford 4.77% 4.55% 2.83%
As % of the Programming Languages category 10.50% 12.38% 6.31%
Number of daily rates quoted 11 6 7
Watford median daily rate £500 £320 £350
Median daily rate % change year-on-year +56.25% -8.57% +4.48%
10th Percentile £325 £213 £325
90th Percentile £600 £340 £405
Hertfordshire median daily rate £463 £340 £350
% change year-on-year +36.03% -2.86% -4.11%
Number of hourly rates quoted 1 0 0
Watford median hourly rate £17.50 - -
Hertfordshire median hourly rate £17.50 - -

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Watford with a requirement for coding skills.

All Programming Languages
Watford
Contract vacancies with a requirement for coding skills 200 105 111
As % of all contract IT jobs advertised in Watford 45.45% 36.71% 44.94%
Number of daily rates quoted 106 40 51
Watford median daily rate £425 £413 £400
Median daily rate % change year-on-year +3.03% +3.13% +6.67%
10th Percentile £300 £229 £325
90th Percentile £603 £538 £438
Hertfordshire median daily rate £423 £390 £375
% change year-on-year +8.33% +4.00% +7.14%
Number of hourly rates quoted 3 0 0
Watford median hourly rate £40.00 - -
Hertfordshire median hourly rate £17.15 £49.75 £34.50
% change year-on-year -65.52% +44.20% +72.50%

T-SQL
Job Vacancy Trend in Watford

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

Job vacancy trend for T-SQL in Watford

T-SQL
Contractor Daily Rate Trend in Watford

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

Contractor daily rate trend for T-SQL in Watford

T-SQL
Contractor Daily Rate Histogram in Watford

The daily rate distribution of IT jobs citing T-SQL in Watford over the 6 months to 21 November 2017.

Contractor daily rate histogram for T-SQL in Watford

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

1 21 (100.00%) SQL
2 17 (80.95%) SQL Server
3 13 (61.90%) Migration
3 13 (61.90%) Data Migration
4 12 (57.14%) SQL Server Reporting Services
5 11 (52.38%) C#
5 11 (52.38%) Reference Data
5 11 (52.38%) Data Mapping
5 11 (52.38%) SC Cleared
5 11 (52.38%) Security Cleared
5 11 (52.38%) Talend Open Studio
5 11 (52.38%) Data Quality
5 11 (52.38%) Talend
5 11 (52.38%) Analytical Skills
6 7 (33.33%) SQL Server Integration Services
7 6 (28.57%) Finance
7 6 (28.57%) XML
7 6 (28.57%) Business Intelligence
7 6 (28.57%) Database Tuning
8 5 (23.81%) Data Lake
8 5 (23.81%) Data Warehouse
8 5 (23.81%) Data Modelling
8 5 (23.81%) ETL
8 5 (23.81%) PL/SQL
8 5 (23.81%) .NET
8 5 (23.81%) Oracle
9 4 (19.05%) Agile Software Development
9 4 (19.05%) OLAP
9 4 (19.05%) RDBMS
9 4 (19.05%) Power BI

T-SQL
Co-occurring IT Skills in Watford 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 1 (4.76%) Elasticsearch
Business Applications
1 1 (4.76%) Dynamics CRM
1 1 (4.76%) iTrent
1 1 (4.76%) Oracle Assets
1 1 (4.76%) Oracle Cash Management
1 1 (4.76%) Oracle Payables
1 1 (4.76%) Oracle Receivables
Cloud Services
1 1 (4.76%) Azure Data Factory
1 1 (4.76%) Microsoft Azure
Database & Business Intelligence
1 17 (80.95%) SQL Server
2 12 (57.14%) SQL Server Reporting Services
3 7 (33.33%) SQL Server Integration Services
4 5 (23.81%) Data Lake
4 5 (23.81%) Data Warehouse
5 4 (19.05%) Big Data
5 4 (19.05%) OLAP
5 4 (19.05%) Power BI
5 4 (19.05%) RDBMS
5 4 (19.05%) Relational Database
5 4 (19.05%) SQL Server Analysis Services
6 3 (14.29%) OLAP Cube
7 2 (9.52%) Crystal Reports
7 2 (9.52%) MongoDB
7 2 (9.52%) SQL Server 2016
7 2 (9.52%) Sybase ASE
8 1 (4.76%) BusinessObjects
8 1 (4.76%) OLTP
8 1 (4.76%) PostgreSQL
8 1 (4.76%) SQL Server 2012
Development Applications
1 11 (52.38%) Talend Open Studio
2 3 (14.29%) Visual Studio
3 1 (4.76%) Jenkins
3 1 (4.76%) JMeter
3 1 (4.76%) jMock
3 1 (4.76%) JUnit
3 1 (4.76%) Selenium
General
1 6 (28.57%) Finance
2 1 (4.76%) General Ledger
2 1 (4.76%) Legal
Job Titles
1 11 (52.38%) Consultant
2 9 (42.86%) Developer
3 8 (38.10%) SQL Server Consultant
4 5 (23.81%) Business Intelligence Developer
5 3 (14.29%) Analyst
5 3 (14.29%) Analyst Developer
5 3 (14.29%) Business Intelligence Analyst
5 3 (14.29%) Developer Analyst
6 2 (9.52%) Data Consultant
6 2 (9.52%) Java Developer
6 2 (9.52%) SQL Developer
7 1 (4.76%) Data Migration Consultant
7 1 (4.76%) Data Migration Specialist
7 1 (4.76%) Data Warehouse Consultant
7 1 (4.76%) Java Engineer
7 1 (4.76%) Microsoft Consultant
7 1 (4.76%) Migration Consultant
7 1 (4.76%) MIS Developer
7 1 (4.76%) Report Developer
7 1 (4.76%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 6 (28.57%) XML
2 5 (23.81%) .NET
3 2 (9.52%) AngularJS
3 2 (9.52%) Hibernate
3 2 (9.52%) JSP
3 2 (9.52%) Spring
3 2 (9.52%) Web Services
4 1 (4.76%) HTML
4 1 (4.76%) HTML5
4 1 (4.76%) J2EE
4 1 (4.76%) MDX
4 1 (4.76%) Oracle GoldenGate
4 1 (4.76%) REST
4 1 (4.76%) Spring Boot
4 1 (4.76%) Spring MVC
4 1 (4.76%) Twitter Bootstrap
Miscellaneous
1 11 (52.38%) Analytical Skills
1 11 (52.38%) Reference Data
Operating Systems
1 2 (9.52%) Linux
1 2 (9.52%) Windows
2 1 (4.76%) Unix
Processes & Methodologies
1 13 (61.90%) Data Migration
1 13 (61.90%) Migration
2 11 (52.38%) Data Mapping
3 6 (28.57%) Business Intelligence
3 6 (28.57%) Database Tuning
4 5 (23.81%) Data Modelling
4 5 (23.81%) ETL
5 4 (19.05%) Agile Software Development
6 3 (14.29%) Kimball Methodology
6 3 (14.29%) Workflow
7 2 (9.52%) CRM
7 2 (9.52%) Microservices
8 1 (4.76%) Dashboard Development
8 1 (4.76%) Data Analysis
8 1 (4.76%) Data Deduplication
8 1 (4.76%) ERP
8 1 (4.76%) MVC
8 1 (4.76%) Stakeholder Management
8 1 (4.76%) Test Automation
8 1 (4.76%) Validation
Programming Languages
1 21 (100.00%) SQL
2 11 (52.38%) C#
3 5 (23.81%) PL/SQL
4 3 (14.29%) VB.NET
5 2 (9.52%) Java
5 2 (9.52%) JavaScript
6 1 (4.76%) C
6 1 (4.76%) Python
Qualifications
1 11 (52.38%) SC Cleared
1 11 (52.38%) Security Cleared
Quality Assurance & Compliance
1 11 (52.38%) Data Quality
Vendors
1 11 (52.38%) Talend
2 5 (23.81%) Oracle
3 2 (9.52%) Microsoft
3 2 (9.52%) Sybase
4 1 (4.76%) RedGate
4 1 (4.76%) SAP