Period
to 22 February 2018

The following table provides summary statistics for contract job vacancies advertised in Lancashire with a requirement for SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL over the 6 months to 22 February 2018 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)
North West > Lancashire
6 months to
22 Feb 2018
Same period 2017 Same period 2016
Rank 6 5 10
Rank change year-on-year -1 +5 -6
Contract jobs citing SQL 72 114 112
As % of all contract IT jobs advertised in Lancashire 16.04% 19.62% 12.19%
As % of the Programming Languages category 37.31% 51.12% 30.85%
Number of daily rates quoted 57 78 105
Lancashire median daily rate £375 £343 £375
Median daily rate % change year-on-year +9.49% -8.67% +7.14%
10th Percentile £250 £244 £216
90th Percentile £615 £533 £600
North West median daily rate £373 £350 £352
% change year-on-year +6.43% -0.57% +5.86%
Number of hourly rates quoted 5 21 19
Lancashire median hourly rate £51.50 £43.00 £37.00
Median hourly rate % change year-on-year +19.77% +16.22% +74.12%
10th Percentile £43.00 £36.50 £34.50
90th Percentile £53.00 £57.50 £47.07
North West median hourly rate £32.25 £39.00 £37.00
% change year-on-year -17.31% +5.41% +54.17%

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

All Programming Languages
Lancashire
Contract vacancies with a requirement for coding skills 193 223 363
As % of all contract IT jobs advertised in Lancashire 42.98% 38.38% 39.50%
Number of daily rates quoted 125 156 238
Lancashire median daily rate £410 £366 £373
Median daily rate % change year-on-year +11.95% -1.68% +6.43%
10th Percentile £263 £263 £209
90th Percentile £525 £531 £517
North West median daily rate £400 £375 £375
% change year-on-year +6.67% - +9.89%
Number of hourly rates quoted 21 38 46
Lancashire median hourly rate £42.50 £42.50 £38.50
Median hourly rate % change year-on-year - +10.39% +8.45%
10th Percentile £37.00 £35.94 £32.50
90th Percentile £52.25 £50.00 £47.33
North West median hourly rate £37.50 £40.00 £37.00
% change year-on-year -6.25% +8.11% +13.85%

SQL
Job Vacancy Trend in Lancashire

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

Job vacancy trend for SQL in Lancashire

SQL
Contractor Daily Rate Trend in Lancashire

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

Contractor daily rate trend for SQL in Lancashire

SQL
Contractor Daily Rate Histogram in Lancashire

The daily rate distribution of IT jobs citing SQL in Lancashire over the 6 months to 22 February 2018.

Contractor daily rate histogram for SQL in Lancashire

SQL
Contractor Hourly Rate Trend in Lancashire

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

Contractor hourly rate trend for SQL in Lancashire

SQL
Contract Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL within the Lancashire region over the 6 months to 22 February 2018. 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
Blackpool +7 29 £425 +1.19% 4
Preston -12 6 £375 +15.38% 18
Blackburn +3 4 £363 -3.33% 2
Burnley +1 3 - - 3
Chorley 0 3 £348 +11.20% 4
Lytham St Annes +1 1 - -
Lancaster - 1 £201 - 6
SQL
North West

For the 6 months to 22 February 2018, IT contractor jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Lancashire region with a requirement for SQL.

1 31 (43.06%) Agile Software Development
2 28 (38.89%) Java
3 27 (37.50%) JavaScript
4 26 (36.11%) Test Automation
5 24 (33.33%) TDD
6 21 (29.17%) BDD
7 20 (27.78%) SQL Server
8 19 (26.39%) Software Engineering
9 18 (25.00%) Git (software)
9 18 (25.00%) MySQL
10 17 (23.61%) JIRA
11 16 (22.22%) Open Source
11 16 (22.22%) MongoDB
11 16 (22.22%) Node.js
11 16 (22.22%) REST
11 16 (22.22%) PostgreSQL
11 16 (22.22%) Relational Database
12 15 (20.83%) SFIA
13 14 (19.44%) SDLC
13 14 (19.44%) Cucumber
14 13 (18.06%) Confluence
14 13 (18.06%) Red Hat Enterprise Linux
14 13 (18.06%) NoSQL
14 13 (18.06%) Linux
14 13 (18.06%) Data Warehouse
14 13 (18.06%) Slack
14 13 (18.06%) Microservices
14 13 (18.06%) Mentoring
14 13 (18.06%) Coaching
15 12 (16.67%) C#

SQL
Co-occurring IT Skills in Lancashire 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 13 (18.06%) Confluence
2 3 (4.17%) SAS
3 2 (2.78%) WebSphere
4 1 (1.39%) CMS
4 1 (1.39%) IIS
4 1 (1.39%) MQSeries
4 1 (1.39%) SharePoint
4 1 (1.39%) WebSphere Application Server
Applications
1 5 (6.94%) Microsoft Excel
2 2 (2.78%) Microsoft Office
Business Applications
1 1 (1.39%) INSURE/90
1 1 (1.39%) Oracle General Ledger
1 1 (1.39%) Oracle Payables
1 1 (1.39%) Oracle Receivables
Cloud Services
1 13 (18.06%) Slack
2 1 (1.39%) Amazon AWS
2 1 (1.39%) Office 365
Communications & Networking
1 2 (2.78%) HTTP
2 1 (1.39%) SMS
Database & Business Intelligence
1 20 (27.78%) SQL Server
2 18 (25.00%) MySQL
3 16 (22.22%) MongoDB
3 16 (22.22%) PostgreSQL
3 16 (22.22%) Relational Database
4 13 (18.06%) Data Warehouse
4 13 (18.06%) NoSQL
5 9 (12.50%) Apache Cassandra
6 6 (8.33%) RDBMS
6 6 (8.33%) SQL Server Integration Services
7 5 (6.94%) Big Data
8 4 (5.56%) SQL Server Reporting Services
9 2 (2.78%) Apache Hive
9 2 (2.78%) BusinessObjects
9 2 (2.78%) DB2
9 2 (2.78%) Hadoop
9 2 (2.78%) HBase
9 2 (2.78%) Pentaho
9 2 (2.78%) PowerPivot
9 2 (2.78%) SQL Server 2008
Development Applications
1 18 (25.00%) Git (software)
2 17 (23.61%) JIRA
3 14 (19.44%) Cucumber
4 12 (16.67%) Jenkins
5 10 (13.89%) Jasmine
6 9 (12.50%) JUnit
7 6 (8.33%) Rational Team Concert
8 4 (5.56%) ClearQuest
8 4 (5.56%) TestDirector
9 3 (4.17%) Visual Studio
10 2 (2.78%) ERwin
10 2 (2.78%) SQL Server Management Studio (SSMS)
10 2 (2.78%) Team Foundation Server
11 1 (1.39%) HP UFT
11 1 (1.39%) Oracle APEX
11 1 (1.39%) Oracle Forms
11 1 (1.39%) Sahi
11 1 (1.39%) Selenium
11 1 (1.39%) Subversion
11 1 (1.39%) WATIR
General
1 7 (9.72%) Finance
2 2 (2.78%) Manufacturing
2 2 (2.78%) Retail
3 1 (1.39%) Advertising
3 1 (1.39%) Arabic Language
3 1 (1.39%) Back Office
3 1 (1.39%) Banking
3 1 (1.39%) Marketing
Job Titles
1 32 (44.44%) Developer
2 11 (15.28%) Java Developer
3 9 (12.50%) Analyst
3 9 (12.50%) Software Engineer
4 8 (11.11%) Software Developer
5 7 (9.72%) Architect
5 7 (9.72%) Java Engineer
5 7 (9.72%) Java Software Engineer
5 7 (9.72%) QA Tester
5 7 (9.72%) Tester
6 6 (8.33%) Data Architect
6 6 (8.33%) SQL Developer
7 5 (6.94%) .NET Developer
7 5 (6.94%) Java Software Developer
8 4 (5.56%) Business Intelligence Developer
8 4 (5.56%) Full Stack Developer
9 3 (4.17%) Agile Developer
9 3 (4.17%) Consultant
9 3 (4.17%) Lead Developer
10 2 (2.78%) Programmer
Libraries, Frameworks & Software Standards
1 16 (22.22%) Node.js
1 16 (22.22%) REST
2 10 (13.89%) HTML
3 9 (12.50%) CSS
4 8 (11.11%) .NET
5 7 (9.72%) AngularJS
6 6 (8.33%) SOAP
6 6 (8.33%) Web Services
6 6 (8.33%) XML
7 5 (6.94%) ASP.NET
7 5 (6.94%) React
7 5 (6.94%) Spring
7 5 (6.94%) WCF
8 4 (5.56%) JDBC
8 4 (5.56%) WinForms
9 3 (4.17%) RESTful
10 2 (2.78%) ASP.NET MVC
10 2 (2.78%) CSS3
10 2 (2.78%) HTML5
10 2 (2.78%) jQuery
Miscellaneous
1 8 (11.11%) Analytical Skills
2 5 (6.94%) Enterprise Software
2 5 (6.94%) Management Information System
3 2 (2.78%) Greenfield Project
4 1 (1.39%) AS400
4 1 (1.39%) CESG
4 1 (1.39%) Data Structures
4 1 (1.39%) iSeries
4 1 (1.39%) Mobile App
4 1 (1.39%) NHS
Operating Systems
1 13 (18.06%) Linux
1 13 (18.06%) Red Hat Enterprise Linux
2 3 (4.17%) Unix
3 2 (2.78%) Windows
4 1 (1.39%) Android
4 1 (1.39%) Apple iOS
4 1 (1.39%) Windows 10
Processes & Methodologies
1 31 (43.06%) Agile Software Development
2 26 (36.11%) Test Automation
3 24 (33.33%) TDD
4 21 (29.17%) BDD
5 19 (26.39%) Software Engineering
6 16 (22.22%) Open Source
7 15 (20.83%) SFIA
8 14 (19.44%) SDLC
9 13 (18.06%) Coaching
9 13 (18.06%) Mentoring
9 13 (18.06%) Microservices
10 11 (15.28%) MVC
11 10 (13.89%) Business Intelligence
11 10 (13.89%) Scrum
11 10 (13.89%) User Stories
12 9 (12.50%) Kanban
13 7 (9.72%) Continuous Delivery
13 7 (9.72%) Continuous Integration
13 7 (9.72%) Scenario Testing
13 7 (9.72%) Software Delivery
Programming Languages
1 28 (38.89%) Java
2 27 (37.50%) JavaScript
3 12 (16.67%) C#
4 10 (13.89%) Python
5 5 (6.94%) PowerShell
5 5 (6.94%) VB
6 4 (5.56%) T-SQL
6 4 (5.56%) VBA
7 2 (2.78%) Bash Shell
7 2 (2.78%) C++
7 2 (2.78%) PL/SQL
7 2 (2.78%) RPG
7 2 (2.78%) RPG IV
7 2 (2.78%) Ruby
7 2 (2.78%) Shell Script
8 1 (1.39%) COBOL
8 1 (1.39%) PHP
Qualifications
1 11 (15.28%) Security Cleared
2 10 (13.89%) SC Cleared
3 2 (2.78%) BPSS Clearance
3 2 (2.78%) Degree
4 1 (1.39%) CESG Certified Professional
4 1 (1.39%) CISMP
4 1 (1.39%) IISP
4 1 (1.39%) Microsoft Certification
4 1 (1.39%) PRINCE2 Certification
Quality Assurance & Compliance
1 9 (12.50%) QA
2 3 (4.17%) Data Quality
3 1 (1.39%) Disclosure Scotland
System Software
1 2 (2.78%) Docker
Vendors
1 9 (12.50%) Microsoft
1 9 (12.50%) Oracle
1 9 (12.50%) Red Hat
2 4 (5.56%) IBM
2 4 (5.56%) Tableau
3 3 (4.17%) Informatica
4 2 (2.78%) CA
4 2 (2.78%) Jaspersoft
4 2 (2.78%) ServiceNow
4 2 (2.78%) Splunk
5 1 (1.39%) Cognos