Period
to 22 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Colchester 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 22 November 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
Essex > Colchester
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 31 42 47
Rank change year-on-year +11 +5 -1
Permanent jobs citing T-SQL 12 13 12
As % of all permanent IT jobs advertised in Colchester 5.04% 3.64% 3.33%
As % of the Programming Languages category 10.08% 7.39% 5.38%
Number of salaries quoted 11 9 12
Colchester median annual salary £43,500 £67,500 £65,000
Median salary % change year-on-year -35.56% +3.85% +132.14%
Essex median annual salary £45,000 £50,000 £45,000
% change year-on-year -10.00% +11.11% +12.50%

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 Colchester with a requirement for coding skills.

All Programming Languages
Colchester
Permanent vacancies with a requirement for coding skills 119 176 223
As % of all permanent IT jobs advertised in Colchester 50.00% 49.30% 61.94%
Number of salaries quoted 95 155 215
Colchester median annual salary £43,500 £40,000 £35,000
Median salary % change year-on-year +8.75% +14.29% -12.50%
10th Percentile £24,550 £28,100 £22,500
90th Percentile £63,750 £67,500 £65,000
Essex median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

T-SQL
Job Vacancy Trend in Colchester

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

Job vacancy trend for T-SQL in Colchester

T-SQL
Salary Trend in Colchester

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Colchester.

Salary trend for T-SQL in Colchester

T-SQL
Salary Histogram in Colchester

The salary distribution of IT jobs citing T-SQL in Colchester over the 6 months to 22 November 2017.

Salary histogram for T-SQL in Colchester

For the 6 months to 22 November 2017, 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 Colchester region with a requirement for T-SQL.

1 12 (100.00%) SQL
2 8 (66.67%) Microsoft
2 8 (66.67%) .NET
2 8 (66.67%) C#
3 7 (58.33%) Business Intelligence
3 7 (58.33%) SQL Server Reporting Services
3 7 (58.33%) SQL Server Integration Services
3 7 (58.33%) SQL Server Analysis Services
4 6 (50.00%) Power BI
5 5 (41.67%) Agile Software Development
6 4 (33.33%) Microsoft Certification
6 4 (33.33%) C++
6 4 (33.33%) Visual Studio
6 4 (33.33%) C
6 4 (33.33%) VoIP
6 4 (33.33%) Software Engineering
6 4 (33.33%) Multithreading
6 4 (33.33%) WPF
6 4 (33.33%) Multithreaded Programming
7 3 (25.00%) Microsoft Azure
7 3 (25.00%) SQL Server
8 2 (16.67%) OLAP
8 2 (16.67%) Data Warehouse
8 2 (16.67%) ETL
8 2 (16.67%) Finance
8 2 (16.67%) Advertising
8 2 (16.67%) OLTP
8 2 (16.67%) Business Analysis
8 2 (16.67%) Degree
8 2 (16.67%) Data Management

T-SQL
Co-occurring IT Skills in Colchester 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:

Cloud Services
1 3 (25.00%) Microsoft Azure
2 1 (8.33%) Amazon AWS
2 1 (8.33%) Azure Data Factory
Communications & Networking
1 4 (33.33%) VoIP
Database & Business Intelligence
1 7 (58.33%) SQL Server Analysis Services
1 7 (58.33%) SQL Server Integration Services
1 7 (58.33%) SQL Server Reporting Services
2 6 (50.00%) Power BI
3 3 (25.00%) SQL Server
4 2 (16.67%) Data Warehouse
4 2 (16.67%) OLAP
4 2 (16.67%) OLTP
4 2 (16.67%) Qlik Sense
4 2 (16.67%) Spotfire
5 1 (8.33%) Amazon Aurora
5 1 (8.33%) Amazon RDS
5 1 (8.33%) Data Lake
5 1 (8.33%) HDInsight
5 1 (8.33%) Informix
5 1 (8.33%) MySQL
5 1 (8.33%) NoSQL
5 1 (8.33%) RDBMS
5 1 (8.33%) Relational Database
Development Applications
1 4 (33.33%) Visual Studio
2 2 (16.67%) SQL Server Management Studio (SSMS)
3 1 (8.33%) Atlassian Bamboo
3 1 (8.33%) Git (software)
General
1 2 (16.67%) Advertising
1 2 (16.67%) Finance
Job Titles
1 9 (75.00%) Developer
2 5 (41.67%) SQL Developer
3 4 (33.33%) C# Developer
3 4 (33.33%) C# Software Developer
3 4 (33.33%) C++ Developer
3 4 (33.33%) C++ Software Developer
3 4 (33.33%) C++/C# Developer
3 4 (33.33%) Software Developer
3 4 (33.33%) T-SQL Developer
4 3 (25.00%) Business Intelligence Developer
5 2 (16.67%) Business Intelligence Lead
6 1 (8.33%) Administrator
6 1 (8.33%) Database Developer
6 1 (8.33%) DBA
6 1 (8.33%) Senior DBA
Libraries, Frameworks & Software Standards
1 8 (66.67%) .NET
2 4 (33.33%) WPF
Miscellaneous
1 1 (8.33%) Analytical Skills
1 1 (8.33%) Computer Science
Operating Systems
1 1 (8.33%) Linux
1 1 (8.33%) Unix
Processes & Methodologies
1 7 (58.33%) Business Intelligence
2 5 (41.67%) Agile Software Development
3 4 (33.33%) Multithreaded Programming
3 4 (33.33%) Multithreading
3 4 (33.33%) Software Engineering
4 2 (16.67%) Analytics
4 2 (16.67%) Business Analysis
4 2 (16.67%) Data Analytics
4 2 (16.67%) Data Management
4 2 (16.67%) Data Visualisation
4 2 (16.67%) ETL
4 2 (16.67%) Visualisation
5 1 (8.33%) Continuous Improvement
5 1 (8.33%) Data Analysis
5 1 (8.33%) Data Security
5 1 (8.33%) Data Virtualisation
5 1 (8.33%) Migration
5 1 (8.33%) OO
5 1 (8.33%) Performance Tuning
5 1 (8.33%) System Testing
Programming Languages
1 12 (100.00%) SQL
2 8 (66.67%) C#
3 4 (33.33%) C
3 4 (33.33%) C++
4 1 (8.33%) PL/SQL
4 1 (8.33%) PowerShell
Qualifications
1 4 (33.33%) Microsoft Certification
2 2 (16.67%) Degree
Systems Management
1 1 (8.33%) Systems Management Server (SMS)
Vendors
1 8 (66.67%) Microsoft
2 2 (16.67%) Atlassian
2 2 (16.67%) Tableau
3 1 (8.33%) IBM
3 1 (8.33%) Oracle