The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for SQL skills. Included is a benchmarking guide to the salaries 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.

SQL (Structured Query Language)
North West / Lancashire
3 months to
30 Apr 2017
Same period 2016 Same period 2015
Rank 2 2 2
Rank change year-on-year 0 0  
Permanent jobs citing SQL 152 122 136
As % of all permanent IT jobs advertised in Lancashire 38.00% 30.50% 29.31%
As % of the Programming Languages category 61.54% 52.81% 50.00%
Number of salaries quoted 144 101 107
Median salary £36,250 £33,000 £36,000
Median salary % change year-on-year +9.84% -8.33%  
90% offered a salary of more than £24,500 £24,000 £25,961
10% offered a salary of more than £50,000 £45,000 £46,800
UK excluding London median salary £40,000 £40,000 £40,000

SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Lancashire with a requirement for programming language skills.

Programming Language Skills
Lancashire
Permanent job vacancies with a requirement for programming language skills 247 231 272
As % of all permanent IT job vacancies advertised in Lancashire 61.75% 57.75% 58.62%
Number of salaries quoted 233 202 215
Median salary £35,000 £35,000 £35,000
90% offered a salary of more than £25,000 £26,000 £25,000
10% offered a salary of more than £50,000 £45,000 £45,000
UK excluding London median salary £41,500 £41,500 £40,000
% change year-on-year - +3.75%  

SQL
Job Vacancy Trend in Lancashire

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

Job vacancy trend for SQL in Lancashire

SQL
Salary Trend in Lancashire

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

Salary trend for SQL in Lancashire

SQL
Salary Histogram in Lancashire

The salary distribution of IT jobs citing SQL in Lancashire over the 3 months to 30 April 2017.

Salary histogram for SQL in Lancashire

SQL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL within the Lancashire region over the 3 months to 30 April 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Preston +3 48 £40,000 +6.66% 2
Blackpool +4 26 £32,500 +30.00% 3
Burnley +2 24 £35,000 +7.69% 4
Chorley -1 23 £24,250 -23.01% 6
Blackburn -7 5 £47,500 +35.71% 6
Skelmersdale +2 4 £35,000 -6.66% 1
Lancaster 0 4 £34,750 -
Colne - 2 £32,500 -
Nelson - 1 £37,500 -
Rossendale - 1 £37,500 - 1
SQL
North West

For the 6 months to 30 April 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 Lancashire region with a requirement for SQL.

1 124 (40.39%) JavaScript
2 117 (38.11%) SQL Server
3 114 (37.13%) HTML
4 101 (32.90%) CSS
5 89 (28.99%) .NET
6 80 (26.06%) T-SQL
7 76 (24.76%) C#
8 74 (24.10%) jQuery
9 69 (22.48%) Agile Software Development
10 65 (21.17%) SDLC
11 59 (19.22%) MVC
12 58 (18.89%) Oracle
12 58 (18.89%) Unit Testing
13 53 (17.26%) Microsoft
14 45 (14.66%) Business Intelligence
15 44 (14.33%) SQL Server Integration Services
16 43 (14.01%) HTML5
17 42 (13.68%) Web Development
18 39 (12.70%) SQL Server Reporting Services
18 39 (12.70%) Java
19 38 (12.38%) iSeries
19 38 (12.38%) ASP.NET
19 38 (12.38%) IBM
20 36 (11.73%) ERP
21 34 (11.07%) ITIL
21 34 (11.07%) DB2
21 34 (11.07%) RPG
22 33 (10.75%) Spring
22 33 (10.75%) TDD
22 33 (10.75%) Degree

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 21 (6.84%) Tomcat
2 5 (1.63%) Apache
2 5 (1.63%) BizTalk Server
2 5 (1.63%) OpenEdge
3 4 (1.30%) CMS
3 4 (1.30%) IIS
4 3 (0.98%) Kentico
4 3 (0.98%) Mongoose
5 2 (0.65%) WordPress
6 1 (0.33%) ColdFusion
6 1 (0.33%) Confluence
6 1 (0.33%) Drupal
6 1 (0.33%) Exchange Server 2013
6 1 (0.33%) GroupWise
6 1 (0.33%) JBoss
6 1 (0.33%) MS Exchange
6 1 (0.33%) SAS
6 1 (0.33%) SharePoint
Applications
1 19 (6.19%) Microsoft Excel
2 2 (0.65%) Microsoft Office
2 2 (0.65%) Microsoft PowerPoint
2 2 (0.65%) MS Visio
Business Applications
1 6 (1.95%) SAP Oil and Gas
2 4 (1.30%) Dynamics CRM
3 1 (0.33%) Magento
3 1 (0.33%) OpenCart
3 1 (0.33%) osCommerce
Cloud Services
1 4 (1.30%) SaaS
2 1 (0.33%) Microsoft Azure
Communications & Networking
1 11 (3.58%) Firewall
1 11 (3.58%) LAN
1 11 (3.58%) WAN
2 10 (3.26%) HTTP
3 4 (1.30%) SNMP
4 2 (0.65%) Internet
4 2 (0.65%) TCP/IP
5 1 (0.33%) Cisco IOS
5 1 (0.33%) HTTPS
5 1 (0.33%) Wireless
Database & Business Intelligence
1 117 (38.11%) SQL Server
2 44 (14.33%) SQL Server Integration Services
3 39 (12.70%) SQL Server Reporting Services
4 34 (11.07%) DB2
5 32 (10.42%) MySQL
6 27 (8.79%) Power BI
7 20 (6.51%) Oracle Database
8 19 (6.19%) Apache Cassandra
8 19 (6.19%) Hadoop
8 19 (6.19%) Oracle Database 11g
9 15 (4.89%) Data Warehouse
9 15 (4.89%) SQL Server 2014
10 14 (4.56%) SQL Server Analysis Services
11 13 (4.23%) SQL Server 2008
12 10 (3.26%) MongoDB
13 9 (2.93%) Data Mining
13 9 (2.93%) PostgreSQL
14 6 (1.95%) RDBMS
14 6 (1.95%) Relational Database
15 5 (1.63%) SQL Server 2016
Development Applications
1 20 (6.51%) Git (software)
2 15 (4.89%) JIRA
3 12 (3.91%) Team Foundation Server
4 10 (3.26%) Visual Studio
5 8 (2.61%) Oracle APEX
5 8 (2.61%) Oracle Forms
6 6 (1.95%) Selenium
7 4 (1.30%) gulp
7 4 (1.30%) Jenkins
8 3 (0.98%) Artifactory
8 3 (0.98%) Atlassian Bamboo
8 3 (0.98%) Maven
8 3 (0.98%) Mercurial
8 3 (0.98%) SonarQube
8 3 (0.98%) Sonatype Nexus
8 3 (0.98%) Subversion
9 2 (0.65%) Cucumber
9 2 (0.65%) Gerrit
9 2 (0.65%) SpecFlow
9 2 (0.65%) WebDriver
General
1 19 (6.19%) Finance
2 13 (4.23%) Manufacturing
3 10 (3.26%) Retail
4 9 (2.93%) Marketing
5 7 (2.28%) Telecoms
6 6 (1.95%) Advertising
6 6 (1.95%) Electronics
7 5 (1.63%) Legal
8 4 (1.30%) Pharmaceutical
9 3 (0.98%) Music Industry
10 1 (0.33%) Automotive
10 1 (0.33%) Military
Job Titles
1 162 (52.77%) Developer
2 102 (33.22%) Analyst
3 54 (17.59%) Support Analyst
4 52 (16.94%) .NET Developer
5 51 (16.61%) SQL Developer
6 42 (13.68%) Applications Support
7 41 (13.36%) Applications Support Analyst
7 41 (13.36%) C# Developer
8 39 (12.70%) C# .NET Developer
9 36 (11.73%) Software Developer
10 33 (10.75%) Java Developer
11 31 (10.10%) JavaScript Developer
12 28 (9.12%) SQL Analyst
13 25 (8.14%) Programmer
14 19 (6.19%) ASP.NET Developer
15 18 (5.86%) Data Analyst
16 16 (5.21%) C# ASP.NET Developer
16 16 (5.21%) Senior Developer
16 16 (5.21%) Senior Programmer
17 15 (4.89%) Java Software Developer
Libraries, Frameworks & Software Standards
1 114 (37.13%) HTML
2 101 (32.90%) CSS
3 89 (28.99%) .NET
4 74 (24.10%) jQuery
5 43 (14.01%) HTML5
6 38 (12.38%) ASP.NET
7 33 (10.75%) Spring
8 26 (8.47%) Node.js
8 26 (8.47%) Twitter Bootstrap
8 26 (8.47%) Web Services
9 25 (8.14%) Hibernate
10 24 (7.82%) REST
11 22 (7.17%) .NET Framework
12 19 (6.19%) Apache Camel
12 19 (6.19%) RabbitMQ
12 19 (6.19%) SOAP
12 19 (6.19%) XML
13 16 (5.21%) AngularJS
13 16 (5.21%) ASP.NET MVC
14 15 (4.89%) JSON
Miscellaneous
1 38 (12.38%) iSeries
2 32 (10.42%) AS400
3 28 (9.12%) Greenfield Project
4 19 (6.19%) Analytical Skills
4 19 (6.19%) Computer Science
5 13 (4.23%) Management Information System
6 10 (3.26%) Enterprise Software
7 8 (2.61%) Clustering
8 7 (2.28%) User Experience
9 4 (1.30%) e-Health
9 4 (1.30%) EPoS
9 4 (1.30%) Mainframe
9 4 (1.30%) Replication
9 4 (1.30%) Smart Meter
10 3 (0.98%) iPad
11 2 (0.65%) Driving Licence
11 2 (0.65%) Mobile App
12 1 (0.33%) Smartphone
Operating Systems
1 19 (6.19%) Windows
2 18 (5.86%) Unix
3 13 (4.23%) Apple iOS
3 13 (4.23%) Linux
4 11 (3.58%) Solaris
5 6 (1.95%) Android
6 4 (1.30%) Windows Server
6 4 (1.30%) Windows Server 2012
7 3 (0.98%) Windows Server 2008
8 2 (0.65%) AIX
8 2 (0.65%) Windows 2000
8 2 (0.65%) Windows Server 2003
Processes & Methodologies
1 69 (22.48%) Agile Software Development
2 65 (21.17%) SDLC
3 59 (19.22%) MVC
4 58 (18.89%) Unit Testing
5 45 (14.66%) Business Intelligence
6 42 (13.68%) Web Development
7 36 (11.73%) ERP
8 34 (11.07%) ITIL
9 33 (10.75%) TDD
10 29 (9.45%) Waterfall
11 25 (8.14%) Software Engineering
12 21 (6.84%) Software Deployment
13 20 (6.51%) OO
14 17 (5.54%) Disaster Recovery
14 17 (5.54%) E-Commerce
15 16 (5.21%) Analytics
16 14 (4.56%) Data Analytics
17 13 (4.23%) Data Analysis
18 11 (3.58%) OOD
19 10 (3.26%) Performance Tuning
Programming Languages
1 124 (40.39%) JavaScript
2 80 (26.06%) T-SQL
3 76 (24.76%) C#
4 39 (12.70%) Java
5 34 (11.07%) RPG
6 19 (6.19%) Groovy
7 18 (5.86%) PHP
8 16 (5.21%) VBA
9 14 (4.56%) VB
10 12 (3.91%) Python
11 11 (3.58%) C
12 8 (2.61%) C++
12 8 (2.61%) Objective-C
12 8 (2.61%) PL/SQL
13 7 (2.28%) VB6
14 6 (1.95%) ES6
15 5 (1.63%) VB.NET
16 2 (0.65%) ActionScript
16 2 (0.65%) ActionScript 3.0
17 1 (0.33%) Bash Shell
Qualifications
1 33 (10.75%) Degree
2 9 (2.93%) Microsoft Certification
3 6 (1.95%) SC Cleared
3 6 (1.95%) Security Cleared
4 5 (1.63%) DBS Check
4 5 (1.63%) ISEB
4 5 (1.63%) ISTQB
5 4 (1.30%) BPSS Clearance
6 2 (0.65%) ISTQB Foundation Certification
6 2 (0.65%) NVQ Level 4
7 1 (0.33%) MCAD
7 1 (0.33%) MCPD
7 1 (0.33%) MCSE
Quality Assurance & Compliance
1 10 (3.26%) QA
2 3 (0.98%) SLA
System Software
1 12 (3.91%) Active Directory
2 11 (3.58%) Hyper-V
3 5 (1.63%) vSphere
4 2 (0.65%) VMware Infrastructure
5 1 (0.33%) NDS
5 1 (0.33%) NetIQ eDirectory
5 1 (0.33%) VMware ESX
5 1 (0.33%) VMware ESXi
5 1 (0.33%) VMware Server
Systems Management
1 4 (1.30%) BMC PATROL
1 4 (1.30%) Nagios
1 4 (1.30%) OpenView
1 4 (1.30%) Tivoli
1 4 (1.30%) Tivoli Endpoint Manager
2 1 (0.33%) HP Quality Center
2 1 (0.33%) SCCM
2 1 (0.33%) SCOM
Vendors
1 58 (18.89%) Oracle
2 53 (17.26%) Microsoft
3 38 (12.38%) IBM
4 18 (5.86%) Tableau
5 15 (4.89%) VMware
6 12 (3.91%) Cisco
7 10 (3.26%) Xamarin
8 8 (2.61%) Apple
8 8 (2.61%) DevExpress
9 7 (2.28%) HP
10 6 (1.95%) SAP
11 4 (1.30%) BMC
11 4 (1.30%) CA
11 4 (1.30%) Compuware
11 4 (1.30%) Dynatrace
11 4 (1.30%) Nimsoft
12 3 (0.98%) Adobe
13 2 (0.65%) Epicor
13 2 (0.65%) Mitel
13 2 (0.65%) Sybase
Burnley
Energize Recruitment Solutions Ltd
Salary: £28000 - £35000 per annum
Posted: 2 days ago
Chorley
Applause IT Ltd
Salary: £30000 - £42000 per annum + bens
Posted: Yesterday
Blackburn
Energize Recruitment Solutions Ltd
Salary: £24000 - £30000 per annum
Posted: 2 days ago
Blackburn, Lancashire
Oscar
Salary: £25000 - £35000 per annum + competitive benefits
Posted: 2 days ago
Blackburn, Lancashire
Applause IT Innovation
Salary: £38000 - £40000 per annum + Benefits
Posted: 5 days ago
Skelmersdale, Lancashire
Greywood Associates Limited
Salary: £30000 - £40000 per annum + bens
Posted: 5 days ago
Lancashire
Verticality Ltd
Salary: to 60k DOE + Benefits
Posted: 3 days ago
Burnley, Lancashire
Fruition IT Resources Limited
Salary: £30000 - £40000 per annum + excellent benefits
Posted: 4 days ago
Chorley, Lancashire
Adria Solutions Ltd
Salary: £30000 - £40000 per annum + Benefits
Posted: 4 days ago
Burnley, Lancashire
Fruition IT Resources Limited
Salary: £30000 - £45000 per annum + Benefits
Posted: 3 days ago
Blackpool, Lancashire
Greywood Associates Limited
Salary: £30000 - £35000 per annum + bens
Posted: 5 days ago
Chorley, Lancashire
Verticality Ltd
Salary: to £25k DOE + Extensive benefits
Posted: 3 days ago
Blackburn, Lancashire
Oscar
Salary: £35000 - £45000 per annum
Posted: Yesterday
Chorley, Lancashire
Verticality Ltd
Salary: £22-25k DOE + benefits
Posted: 3 days ago
Preston, Lancashire
Recann
Salary: £0.00 per annum
Posted: 3 days ago
Chorley, Lancashire
Adria Solutions Ltd
Salary: £30000 - £50000 per annum + Benefits
Posted: 5 days ago
Burnley, Lancashire
Greywood Associates Limited
Salary: £35000 - £45000 per annum + bens
Posted: 5 days ago
Leyland, Lancashire
AWD Recruitment
Salary: circa. £40,000 per annum + Excellent Benefits
Posted: 2 days ago
Blackpool
Noir Consulting
Salary: £35000 - £45000 per annum + Bonus + Pension + Benefits
Posted: 5 days ago
Blackpool
Noir Consulting
Salary: £35000 - £45000 per annum + Bonus + Pension + Benefits
Posted: 5 days ago
Blackburn, Lancashire
Dawson & Walsh
Salary: £40000 - £55000 per annum + Bonus + Pension + Benefits
Posted: 6 days ago
Rossendale, Lancashire
ReThink Recruitment
Salary: £25000.00 per annum
Posted: 6 days ago
Chorley
Applause IT Ltd
Salary: £20000 - £25000 per annum
Posted: 27 days ago
Preston
Hays Specialist Recruitment Ltd
Salary: £18000.00 - £25000.00 per annum
Posted: 27 days ago