The following table provides summary statistics for contract job vacancies advertised in Preston with a requirement for SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL over the 3 months to 30 April 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.

SQL (Structured Query Language)
Lancashire / Preston
3 months to
30 Apr 2017
Same period 2016 Same period 2015
Rank 13 11 4
Rank change year-on-year -2 -7  
Contract jobs citing SQL 19 10 23
As % of all contract IT jobs advertised in Preston 10.61% 8.00% 21.30%
As % of the Programming Languages category 55.88% 22.22% 47.92%
Number of daily rates quoted 9 3 15
Median daily rate £325 £300 £350
Median daily rate % change year-on-year +8.33% -14.28%  
90% offered a daily rate of more than £266 £192 £225
10% offered a daily rate of more than £360 £350 £474
UK excluding London median daily rate £375 £365 £350
% change year-on-year +2.73% +4.28%  
Number of hourly rates quoted 4 4 1
Median hourly rate £42.75 £41.00 £16.00
Median hourly rate % change year-on-year +4.26% +156.25%  
UK excluding London median hourly rate £40.00 £26.00 £25.00
% change year-on-year +53.84% +4.00%  

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 Preston with a requirement for programming language skills.

Contract Programming Language Skills
Preston
Contract job vacancies with a requirement for programming language skills 34 45 48
As % of all contract IT job vacancies advertised in Preston 18.99% 36.00% 44.44%
Number of daily rates quoted 13 19 29
Median daily rate £313 £345 £375
Median daily rate % change year-on-year -9.42% -8.00%  
90% offered a daily rate of more than £288 £300 £316
10% offered a daily rate of more than £351 £450 £538
UK excluding London median daily rate £390 £375 £350
% change year-on-year +4.00% +7.14%  
Number of hourly rates quoted 14 13 6
Median hourly rate £42.50 £41.50 £37.00
Median hourly rate % change year-on-year +2.40% +12.16%  
UK excluding London median hourly rate £42.50 £38.00 £36.00
% change year-on-year +11.84% +5.55%  

SQL
Job Vacancy Trend in Preston

The job posting trend of jobs advertised in Preston citing SQL as a proportion of all contract or permanent IT jobs with a match in the Programming Languages category.

Job vacancy trend for SQL in Preston

SQL
Contractor Daily Rate Trend in Preston

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

Contractor daily rate trend for SQL in Preston

SQL
Contractor Daily Rate Histogram in Preston

The daily rate distribution of IT jobs citing SQL in Preston over the 3 months to 30 April 2017.

Contractor daily rate histogram for SQL in Preston

SQL
Contractor Hourly Rate Trend in Preston

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

Contractor hourly rate trend for SQL in Preston

For the 6 months to 30 April 2017, IT contractor jobs citing 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 Preston region with a requirement for SQL.

1 13 (41.94%) Oracle
2 12 (38.71%) Perl
3 9 (29.03%) PL/SQL
3 9 (29.03%) Microsoft
3 9 (29.03%) Unit Testing
3 9 (29.03%) Security Cleared
3 9 (29.03%) Oracle Database
4 8 (25.81%) Integration Testing
4 8 (25.81%) XML
4 8 (25.81%) Degree
5 7 (22.58%) Software Engineering
5 7 (22.58%) HOOD
5 7 (22.58%) Finance
5 7 (22.58%) Windows
5 7 (22.58%) SQL Server
5 7 (22.58%) Ada
5 7 (22.58%) SC Cleared
5 7 (22.58%) Avionics
5 7 (22.58%) Rational DOORS
6 6 (19.35%) Rational Rhapsody
6 6 (19.35%) Oracle GoldenGate
6 6 (19.35%) SDLC
6 6 (19.35%) C
6 6 (19.35%) HTML
6 6 (19.35%) CSS
6 6 (19.35%) Migration
6 6 (19.35%) Oracle RMAN
7 5 (16.13%) Agile Software Development
7 5 (16.13%) UML
7 5 (16.13%) C#

SQL
Co-occurring IT Skills in Preston 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 2 (6.45%) PowerExchange
2 1 (3.23%) WebSphere
2 1 (3.23%) WebSphere Application Server
Applications
1 3 (9.68%) Microsoft Excel
1 3 (9.68%) Microsoft PowerPoint
2 2 (6.45%) Microsoft Office
Communications & Networking
1 1 (3.23%) SSH
1 1 (3.23%) TCP/IP
Database & Business Intelligence
1 9 (29.03%) Oracle Database
2 7 (22.58%) SQL Server
3 5 (16.13%) TKPROF
4 3 (9.68%) Data Warehouse
4 3 (9.68%) RDBMS
4 3 (9.68%) Relational Database
4 3 (9.68%) SQL Server 2008
5 2 (6.45%) DB2
6 1 (3.23%) Big Data
6 1 (3.23%) Oracle Database 12c
6 1 (3.23%) SQL Server 2005
6 1 (3.23%) SQL Server 2012
6 1 (3.23%) SQL Server Integration Services
6 1 (3.23%) SQL Server Reporting Services
6 1 (3.23%) SQLPlus
Development Applications
1 7 (22.58%) Rational DOORS
2 6 (19.35%) Rational Rhapsody
3 5 (16.13%) Toad
3 5 (16.13%) VectorCAST
3 5 (16.13%) Visual Studio
4 2 (6.45%) ClearCase
4 2 (6.45%) SQL Server Management Studio (SSMS)
5 1 (3.23%) Subversion
5 1 (3.23%) Talend Open Studio
5 1 (3.23%) Team Foundation Server
General
1 7 (22.58%) Avionics
1 7 (22.58%) Finance
2 4 (12.90%) Manufacturing
3 3 (9.68%) Aerospace
3 3 (9.68%) Military
4 2 (6.45%) Banking
4 2 (6.45%) Telecoms
5 1 (3.23%) Automotive
Job Titles
1 13 (41.94%) Developer
2 7 (22.58%) DBA
3 5 (16.13%) Administrator
3 5 (16.13%) Oracle DBA
3 5 (16.13%) Software Engineer
4 4 (12.90%) .NET Developer
4 4 (12.90%) Systems Engineer
5 3 (9.68%) Analyst
5 3 (9.68%) Architect
5 3 (9.68%) Database Architect
5 3 (9.68%) Informatica Developer
5 3 (9.68%) Oracle Architect
6 2 (6.45%) Ada Engineer
6 2 (6.45%) COBOL Developer
6 2 (6.45%) DOORS Engineer
6 2 (6.45%) Senior Software Engineer
6 2 (6.45%) SQL DBA
7 1 (3.23%) Analyst Developer
7 1 (3.23%) Database Developer
7 1 (3.23%) Senior Analyst Programmer
Libraries, Frameworks & Software Standards
1 8 (25.81%) XML
2 6 (19.35%) CSS
2 6 (19.35%) HTML
2 6 (19.35%) Oracle GoldenGate
3 5 (16.13%) .NET
4 4 (12.90%) ASP.NET
4 4 (12.90%) Web Services
5 3 (9.68%) .NET Framework
5 3 (9.68%) ASP.NET MVC
6 2 (6.45%) Ajax
6 2 (6.45%) HTML5
6 2 (6.45%) KnockoutJS
6 2 (6.45%) RESTful
6 2 (6.45%) SOAP
6 2 (6.45%) WCF
6 2 (6.45%) WinForms
7 1 (3.23%) EJB
7 1 (3.23%) JSP
7 1 (3.23%) Servlets
7 1 (3.23%) Struts
Miscellaneous
1 3 (9.68%) Analytical Skills
1 3 (9.68%) Clustering
2 2 (6.45%) Greenfield Project
3 1 (3.23%) Data Centre
3 1 (3.23%) Management Information System
3 1 (3.23%) Replication
Operating Systems
1 7 (22.58%) Windows
2 2 (6.45%) zOS
3 1 (3.23%) AIX
3 1 (3.23%) HPUX
3 1 (3.23%) Linux
3 1 (3.23%) Red Hat Enterprise Linux
3 1 (3.23%) Solaris
3 1 (3.23%) Unix
3 1 (3.23%) Windows Server
Processes & Methodologies
1 9 (29.03%) Unit Testing
2 8 (25.81%) Integration Testing
3 7 (22.58%) HOOD
3 7 (22.58%) Software Engineering
4 6 (19.35%) Migration
4 6 (19.35%) SDLC
5 5 (16.13%) Agile Software Development
5 5 (16.13%) UML
6 4 (12.90%) Hazard Analysis
6 4 (12.90%) MVC
6 4 (12.90%) Programme Management
7 3 (9.68%) Change Data Capture
7 3 (9.68%) Data Migration
7 3 (9.68%) ETL
7 3 (9.68%) Performance Tuning
8 2 (6.45%) Data Protection
8 2 (6.45%) OO
8 2 (6.45%) OOD
8 2 (6.45%) Performance Monitoring
8 2 (6.45%) Waterfall
Programming Languages
1 12 (38.71%) Perl
2 9 (29.03%) PL/SQL
3 7 (22.58%) Ada
4 6 (19.35%) C
5 5 (16.13%) C#
5 5 (16.13%) PowerShell
6 4 (12.90%) JavaScript
7 3 (9.68%) COBOL
8 2 (6.45%) T-SQL
9 1 (3.23%) Java
9 1 (3.23%) Shell Script
9 1 (3.23%) VBScript
Qualifications
1 9 (29.03%) Security Cleared
2 8 (25.81%) Degree
3 7 (22.58%) SC Cleared
4 2 (6.45%) DV Cleared
4 2 (6.45%) HND
4 2 (6.45%) Microsoft Certification
4 2 (6.45%) NVQ Level 3
5 1 (3.23%) BC Cleared
5 1 (3.23%) OCMJD
5 1 (3.23%) OCPJP
5 1 (3.23%) OCPJWCD
5 1 (3.23%) Oracle Certification
5 1 (3.23%) Sun Certification
Quality Assurance & Compliance
1 2 (6.45%) QA
System Software
1 1 (3.23%) Virtual Machines
Systems Management
1 6 (19.35%) Oracle RMAN
2 1 (3.23%) Data Guard
2 1 (3.23%) Oracle Enterprise Manager
Vendors
1 13 (41.94%) Oracle
2 9 (29.03%) Microsoft
3 3 (9.68%) HP
3 3 (9.68%) Informatica
4 1 (3.23%) IBM
4 1 (3.23%) Red Hat
4 1 (3.23%) Sun
4 1 (3.23%) Talend