Period
to 19 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Colchester with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 19 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Essex > Colchester
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 2 13 12
Rank change year-on-year +11 -1 -7
Permanent jobs citing SQL 66 53 62
As % of all permanent IT jobs advertised in Colchester 27.62% 14.97% 17.13%
As % of the Programming Languages category 53.66% 29.94% 27.43%
Number of salaries quoted 58 46 66
Colchester median annual salary £45,000 £40,000 £35,000
Median salary % change year-on-year +12.50% +14.29% -7.89%
10th Percentile £25,650 £31,250 £23,500
90th Percentile £62,875 £67,500 £65,000
Essex median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

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 123 177 226
As % of all permanent IT jobs advertised in Colchester 51.46% 50.00% 62.43%
Number of salaries quoted 100 154 218
Colchester median annual salary £45,000 £40,000 £35,000
Median salary % change year-on-year +12.50% +14.29% -12.50%
10th Percentile £24,925 £27,500 £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% -

SQL
Job Vacancy Trend in Colchester

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

Job vacancy trend for SQL in Colchester

SQL
Salary Trend in Colchester

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

Salary trend for SQL in Colchester

SQL
Salary Histogram in Colchester

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

Salary histogram for SQL in Colchester

For the 6 months to 19 November 2017, IT jobs citing 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 SQL.

1 23 (34.85%) Agile Software Development
2 19 (28.79%) ETL
2 19 (28.79%) Oracle
3 18 (27.27%) Data Warehouse
4 17 (25.76%) SQL Server
4 17 (25.76%) PL/SQL
4 17 (25.76%) Relational Database
5 16 (24.24%) Oracle Database
5 16 (24.24%) RDBMS
6 15 (22.73%) Business Intelligence
7 14 (21.21%) .NET
7 14 (21.21%) Linux
8 12 (18.18%) T-SQL
8 12 (18.18%) Microsoft
9 11 (16.67%) Analytical Skills
9 11 (16.67%) C#
10 10 (15.15%) Analytics
11 9 (13.64%) Power BI
11 9 (13.64%) IIS
11 9 (13.64%) E-Commerce
11 9 (13.64%) Validation
12 8 (12.12%) SQL Server Reporting Services
12 8 (12.12%) XML
12 8 (12.12%) SOAP
12 8 (12.12%) Dynatrace
12 8 (12.12%) Splunk
12 8 (12.12%) SQL Server Analysis Services
13 7 (10.61%) SLA
13 7 (10.61%) SQL Server Integration Services
14 6 (9.09%) Marketing

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:

Application Platforms
1 9 (13.64%) IIS
2 6 (9.09%) Apache
3 3 (4.55%) JBoss
4 1 (1.52%) Apache Spark
Applications
1 3 (4.55%) Microsoft Excel
2 2 (3.03%) Microsoft Office
Business Applications
1 3 (4.55%) SessionCam
Cloud Services
1 3 (4.55%) Amazon AWS
1 3 (4.55%) Google Analytics
2 2 (3.03%) Microsoft Azure
3 1 (1.52%) Amazon EC2
3 1 (1.52%) Amazon ElastiCache
3 1 (1.52%) Amazon Glacier
3 1 (1.52%) Amazon S3
3 1 (1.52%) IaaS
3 1 (1.52%) PaaS
Communications & Networking
1 4 (6.06%) VoIP
2 2 (3.03%) SMS
3 1 (1.52%) Firewall
3 1 (1.52%) PuTTY
Database & Business Intelligence
1 18 (27.27%) Data Warehouse
2 17 (25.76%) Relational Database
2 17 (25.76%) SQL Server
3 16 (24.24%) Oracle Database
3 16 (24.24%) RDBMS
4 9 (13.64%) Power BI
5 8 (12.12%) SQL Server Analysis Services
5 8 (12.12%) SQL Server Reporting Services
6 7 (10.61%) SQL Server Integration Services
7 3 (4.55%) Big Data
7 3 (4.55%) Hadoop
7 3 (4.55%) MySQL
7 3 (4.55%) OLAP
7 3 (4.55%) OLTP
7 3 (4.55%) SQL Server 2008
8 2 (3.03%) Amazon RDS
8 2 (3.03%) Qlik Sense
8 2 (3.03%) Spotfire
9 1 (1.52%) OLAP Cube
9 1 (1.52%) SQL Server 2014
Development Applications
1 6 (9.09%) SoapUI
2 4 (6.06%) Visual Studio
3 2 (3.03%) SQL Server Management Studio (SSMS)
4 1 (1.52%) Atlassian Bamboo
4 1 (1.52%) Git (software)
4 1 (1.52%) JIRA
4 1 (1.52%) TestRail
General
1 6 (9.09%) Marketing
2 5 (7.58%) Manufacturing
3 4 (6.06%) Finance
4 3 (4.55%) Advertising
5 2 (3.03%) Electronics
5 2 (3.03%) Pharmaceutical
5 2 (3.03%) Telecoms
6 1 (1.52%) Automotive
6 1 (1.52%) Games
Job Titles
1 35 (53.03%) Developer
2 22 (33.33%) SQL Developer
3 19 (28.79%) Analyst
4 17 (25.76%) Database Developer
5 16 (24.24%) Oracle Developer
6 15 (22.73%) Oracle Database Developer
7 12 (18.18%) ETL Developer
7 12 (18.18%) Oracle ETL Developer
7 12 (18.18%) PL/SQL Developer
7 12 (18.18%) SQL Database Developer
8 11 (16.67%) Applications Support
8 11 (16.67%) Applications Support Analyst
8 11 (16.67%) Data Warehouse Developer
8 11 (16.67%) Oracle Data Warehouse Developer
8 11 (16.67%) Support Analyst
9 6 (9.09%) C# Developer
10 5 (7.58%) Senior Developer
10 5 (7.58%) Software Developer
11 4 (6.06%) C++ Developer
11 4 (6.06%) Web Analyst
Libraries, Frameworks & Software Standards
1 14 (21.21%) .NET
2 8 (12.12%) SOAP
2 8 (12.12%) XML
3 4 (6.06%) CSS
3 4 (6.06%) HTML
3 4 (6.06%) WPF
4 3 (4.55%) jQuery
4 3 (4.55%) Web Services
5 2 (3.03%) ASP.NET
5 2 (3.03%) ASP.NET MVC
5 2 (3.03%) RESTful
6 1 (1.52%) .NET Framework
6 1 (1.52%) JSON
Miscellaneous
1 11 (16.67%) Analytical Skills
2 2 (3.03%) Computer Science
2 2 (3.03%) Data Centre
2 2 (3.03%) Greenfield Project
2 2 (3.03%) Life Science
3 1 (1.52%) N-Tier
Operating Systems
1 14 (21.21%) Linux
2 2 (3.03%) Windows
3 1 (1.52%) Unix
Processes & Methodologies
1 23 (34.85%) Agile Software Development
2 19 (28.79%) ETL
3 15 (22.73%) Business Intelligence
4 10 (15.15%) Analytics
5 9 (13.64%) E-Commerce
5 9 (13.64%) Validation
6 6 (9.09%) Data Visualisation
6 6 (9.09%) Visualisation
7 5 (7.58%) Data Analytics
7 5 (7.58%) Data Management
7 5 (7.58%) DevOps
7 5 (7.58%) Root Cause Analysis
8 4 (6.06%) Multithreaded Programming
8 4 (6.06%) Multithreading
8 4 (6.06%) Software Engineering
8 4 (6.06%) User Acceptance Testing
9 3 (4.55%) Budget Control
9 3 (4.55%) Continuous Integration
9 3 (4.55%) Problem Management
9 3 (4.55%) Unit Testing
Programming Languages
1 17 (25.76%) PL/SQL
2 12 (18.18%) T-SQL
3 11 (16.67%) C#
4 6 (9.09%) JavaScript
5 4 (6.06%) C
5 4 (6.06%) C++
5 4 (6.06%) Java
6 1 (1.52%) Perl
6 1 (1.52%) PHP
Qualifications
1 5 (7.58%) Microsoft Certification
2 3 (4.55%) Degree
3 1 (1.52%) AWS Certification
3 1 (1.52%) ISEB
3 1 (1.52%) MCSA
Quality Assurance & Compliance
1 7 (10.61%) SLA
2 2 (3.03%) Data Quality
3 1 (1.52%) QA
System Software
1 6 (9.09%) vSphere
Systems Management
1 3 (4.55%) Puppet
2 1 (1.52%) Systems Management Server (SMS)
Vendors
1 19 (28.79%) Oracle
2 12 (18.18%) Microsoft
3 8 (12.12%) Dynatrace
3 8 (12.12%) Splunk
4 4 (6.06%) Tableau
5 3 (4.55%) Google
5 3 (4.55%) Software AG
5 3 (4.55%) webMethods
6 2 (3.03%) Atlassian
6 2 (3.03%) SAP
7 1 (1.52%) IBM