Period
to 21 April 2018

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 6 months to 21 April 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
North West > Lancashire
6 months to
21 Apr 2018
Same period 2017 Same period 2016
Rank 2 2 2
Rank change year-on-year 0 0 +3
Permanent jobs citing SQL 247 314 210
As % of all permanent IT jobs advertised in Lancashire 26.45% 34.89% 28.34%
As % of the Programming Languages category 47.68% 60.50% 49.88%
Number of salaries quoted 217 303 187
Lancashire median annual salary £35,000 £35,000 £33,000
Median salary % change year-on-year - +6.06% +0.76%
10th Percentile £24,650 £22,750 £23,500
90th Percentile £55,000 £47,500 £45,000
North West median annual salary £42,500 £40,000 £38,000
% change year-on-year +6.25% +5.26% +1.33%

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

All Programming Languages
Lancashire
Permanent vacancies with a requirement for coding skills 518 519 421
As % of all permanent IT jobs advertised in Lancashire 55.46% 57.67% 56.82%
Number of salaries quoted 456 478 354
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £24,750 £22,750 £23,575
90th Percentile £55,000 £50,000 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +6.67%

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
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 6 months to 21 April 2018.

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 6 months to 21 April 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Chorley +1 88 £35,000 +16.67% 7
Preston -3 53 £32,500 -13.33% 9
Lancaster -7 21 £35,000 +9.38% 3
Blackburn -10 18 £28,500 -3.39% 4
Burnley -3 11 £35,000 - 1
Blackpool -8 6 £35,500 +5.97% 5
Skelmersdale +1 3 £33,000 -5.71% 1
Accrington - 3 £37,500 - 1
Colne +8 2 £27,500 -16.67%
Darwen - 1 - -
Ormskirk - 1 £35,000 -
SQL
North West

For the 6 months to 21 April 2018, IT 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 permanent job ads across the Lancashire region with a requirement for SQL.

1 111 (44.94%) SQL Server
2 80 (32.39%) .NET
3 72 (29.15%) C#
4 63 (25.51%) T-SQL
5 61 (24.70%) Agile Software Development
6 60 (24.29%) CSS
7 58 (23.48%) HTML
7 58 (23.48%) JavaScript
8 55 (22.27%) Oracle
9 48 (19.43%) Microsoft
10 45 (18.22%) SQL Server Reporting Services
11 44 (17.81%) ASP.NET
11 44 (17.81%) Data Warehouse
12 43 (17.41%) MVC
13 41 (16.60%) SQL Server Integration Services
13 41 (16.60%) Analytical Skills
14 40 (16.19%) Business Intelligence
15 37 (14.98%) Problem-Solving
16 35 (14.17%) jQuery
17 34 (13.77%) OO
18 32 (12.96%) SDLC
19 31 (12.55%) ITIL
20 30 (12.15%) VBA
21 28 (11.34%) Finance
22 27 (10.93%) Java
23 24 (9.72%) SQL Server 2016
24 23 (9.31%) Continuous Improvement
24 23 (9.31%) Service Delivery
25 22 (8.91%) Management Information System
25 22 (8.91%) Windows

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 19 (7.69%) IIS
2 9 (3.64%) OpenEdge
3 5 (2.02%) CMS
4 4 (1.62%) SharePoint
5 2 (0.81%) ColdFusion
5 2 (0.81%) IBM Notes
5 2 (0.81%) WordPress
6 1 (0.40%) BizTalk Server
6 1 (0.40%) MS Exchange
6 1 (0.40%) nginx
6 1 (0.40%) NServiceBus
6 1 (0.40%) SAS
6 1 (0.40%) WebSphere
Applications
1 22 (8.91%) Microsoft Excel
2 15 (6.07%) Microsoft Project
3 14 (5.67%) MS Visio
4 11 (4.45%) Microsoft Office
Business Applications
1 5 (2.02%) Dynamics NAV
2 3 (1.21%) Infor M3
3 2 (0.81%) Cognos TM1
4 1 (0.40%) Cognos Business Intelligence
4 1 (0.40%) Dynamics AX
4 1 (0.40%) Sage X3
4 1 (0.40%) SAP Business One
Cloud Services
1 6 (2.43%) Amazon AWS
1 6 (2.43%) Google Analytics
1 6 (2.43%) Office 365
2 5 (2.02%) SaaS
3 4 (1.62%) Google Tag Manager
4 3 (1.21%) npm
5 2 (0.81%) Microsoft Azure
6 1 (0.40%) Cloud Computing
Communications & Networking
1 9 (3.64%) LAN
2 8 (3.24%) VLAN
2 8 (3.24%) WAN
3 6 (2.43%) SAN
4 4 (1.62%) Internet
5 3 (1.21%) HTTP
5 3 (1.21%) Intranet
5 3 (1.21%) TCP/IP
6 2 (0.81%) Firewall
7 1 (0.40%) DNS
7 1 (0.40%) VoIP
Database & Business Intelligence
1 111 (44.94%) SQL Server
2 45 (18.22%) SQL Server Reporting Services
3 44 (17.81%) Data Warehouse
4 41 (16.60%) SQL Server Integration Services
5 24 (9.72%) SQL Server 2016
6 20 (8.10%) PostgreSQL
7 19 (7.69%) SQL Server Analysis Services
8 17 (6.88%) MS Access
9 16 (6.48%) Relational Database
10 14 (5.67%) BusinessObjects
10 14 (5.67%) RDBMS
11 12 (4.86%) MySQL
12 11 (4.45%) SQL Server 2005
13 9 (3.64%) OLAP
13 9 (3.64%) SQL Server 2014
14 8 (3.24%) DTS
14 8 (3.24%) Microsoft Analysis Services
14 8 (3.24%) Oracle Database
14 8 (3.24%) SQL Server 2012
15 7 (2.83%) Hadoop
Development Applications
1 20 (8.10%) Visual Studio
2 8 (3.24%) Git (software)
3 6 (2.43%) Subversion
4 5 (2.02%) ERwin
4 5 (2.02%) Selenium
4 5 (2.02%) SQL Server Management Studio (SSMS)
5 4 (1.62%) JIRA
6 3 (1.21%) Team Foundation Server
7 2 (0.81%) Dreamweaver
7 2 (0.81%) GitLab
7 2 (0.81%) Jenkins
7 2 (0.81%) Oracle APEX
7 2 (0.81%) PhpStorm
7 2 (0.81%) PowerBuilder
8 1 (0.40%) Atlassian Bamboo
8 1 (0.40%) Bitbucket
8 1 (0.40%) Eclipse
8 1 (0.40%) Jasmine
8 1 (0.40%) NUnit
General
1 28 (11.34%) Finance
2 10 (4.05%) Marketing
2 10 (4.05%) Retail
3 9 (3.64%) Manufacturing
4 7 (2.83%) Aerospace
5 6 (2.43%) Advertising
6 4 (1.62%) Brand Awareness
7 2 (0.81%) Back Office
7 2 (0.81%) Legal
7 2 (0.81%) Telecoms
8 1 (0.40%) Games
8 1 (0.40%) Military
Job Titles
1 131 (53.04%) Developer
2 59 (23.89%) Analyst
3 44 (17.81%) .NET Developer
4 38 (15.38%) SQL Developer
5 35 (14.17%) C# Developer
6 29 (11.74%) C# .NET Developer
7 23 (9.31%) Applications Support
7 23 (9.31%) Applications Support Analyst
7 23 (9.31%) Software Developer
7 23 (9.31%) Support Analyst
8 22 (8.91%) SQL Analyst
9 19 (7.69%) DBA
10 18 (7.29%) .NET Software Developer
11 17 (6.88%) SQL DBA
12 16 (6.48%) ASP.NET MVC Developer
12 16 (6.48%) C# Software Developer
12 16 (6.48%) Java Developer
13 15 (6.07%) Administrator
13 15 (6.07%) Business Intelligence Developer
13 15 (6.07%) VBA Developer
Libraries, Frameworks & Software Standards
1 80 (32.39%) .NET
2 60 (24.29%) CSS
3 58 (23.48%) HTML
4 44 (17.81%) ASP.NET
5 35 (14.17%) jQuery
6 21 (8.50%) ASP.NET MVC
7 17 (6.88%) Web Services
8 16 (6.48%) Spring
9 14 (5.67%) .NET Framework
9 14 (5.67%) Ajax
10 13 (5.26%) AngularJS
11 12 (4.86%) HTML5
11 12 (4.86%) REST
12 11 (4.45%) Classic ASP
12 11 (4.45%) Entity Framework
13 10 (4.05%) Hibernate
13 10 (4.05%) XML
14 8 (3.24%) RESTful
15 6 (2.43%) CSS3
15 6 (2.43%) RabbitMQ
Miscellaneous
1 41 (16.60%) Analytical Skills
2 22 (8.91%) Management Information System
3 8 (3.24%) Fintech
4 6 (2.43%) Computer Science
5 5 (2.02%) Clustering
5 5 (2.02%) Data Protection Act
5 5 (2.02%) Hybrid Cloud
6 4 (1.62%) User Experience
7 3 (1.21%) Greenfield Project
7 3 (1.21%) Self-Motivation
8 2 (0.81%) Analytical Mindset
8 2 (0.81%) Mobile App
8 2 (0.81%) N-Tier
9 1 (0.40%) Driving Licence
9 1 (0.40%) FMCG
Operating Systems
1 22 (8.91%) Windows
2 14 (5.67%) Windows Server 2012
3 13 (5.26%) Windows Server 2008
4 9 (3.64%) Unix
5 5 (2.02%) Windows 10
5 5 (2.02%) Windows Server 2003
6 4 (1.62%) Linux
6 4 (1.62%) Windows Server
7 3 (1.21%) Android
8 2 (0.81%) Ubuntu
9 1 (0.40%) Apple iOS
Processes & Methodologies
1 61 (24.70%) Agile Software Development
2 43 (17.41%) MVC
3 40 (16.19%) Business Intelligence
4 37 (14.98%) Problem-Solving
5 34 (13.77%) OO
6 32 (12.96%) SDLC
7 31 (12.55%) ITIL
8 23 (9.31%) Continuous Improvement
8 23 (9.31%) Service Delivery
9 22 (8.91%) Web Development
10 21 (8.50%) ERP
10 21 (8.50%) Software Deployment
11 19 (7.69%) ETL
12 18 (7.29%) Analytics
12 18 (7.29%) Kanban
13 16 (6.48%) Performance Tuning
13 16 (6.48%) Software Engineering
14 13 (5.26%) Data Analysis
14 13 (5.26%) TDD
14 13 (5.26%) Test Automation
Programming Languages
1 72 (29.15%) C#
2 63 (25.51%) T-SQL
3 58 (23.48%) JavaScript
4 30 (12.15%) VBA
5 27 (10.93%) Java
6 19 (7.69%) PHP
7 13 (5.26%) C
8 11 (4.45%) VB.NET
9 9 (3.64%) PowerShell
9 9 (3.64%) Ruby
10 6 (2.43%) Groovy
10 6 (2.43%) Java 8
10 6 (2.43%) VB
11 4 (1.62%) C++
12 3 (1.21%) PL/SQL
13 2 (0.81%) VBScript
13 2 (0.81%) VC++
14 1 (0.40%) Pascal
14 1 (0.40%) Python
14 1 (0.40%) Shell Script
Qualifications
1 17 (6.88%) Degree
2 14 (5.67%) Security Cleared
3 12 (4.86%) SC Cleared
4 6 (2.43%) Microsoft Certification
5 5 (2.02%) MCSE
6 4 (1.62%) ISEB
7 2 (0.81%) Computer Science Degree
7 2 (0.81%) ISTQB
7 2 (0.81%) ISTQB Foundation Certification
8 1 (0.40%) ACCA
8 1 (0.40%) CCNA
8 1 (0.40%) CIMA
8 1 (0.40%) Cisco Certification
8 1 (0.40%) ITIL Certification
8 1 (0.40%) NVQ Level 4
Quality Assurance & Compliance
1 8 (3.24%) QA
2 4 (1.62%) GDPR
3 2 (0.81%) SLA
4 1 (0.40%) PMO
System Software
1 13 (5.26%) Active Directory
2 9 (3.64%) VMware Infrastructure
3 6 (2.43%) vSphere
4 5 (2.02%) BitLocker
5 1 (0.40%) Docker
5 1 (0.40%) Oracle Clusterware
Systems Management
1 8 (3.24%) FortiGate
2 5 (2.02%) Microsoft Clustering
2 5 (2.02%) SCCM
3 1 (0.40%) Data Guard
3 1 (0.40%) Enterprise Manager Cloud Control
3 1 (0.40%) Oracle Flashback
3 1 (0.40%) Oracle RMAN
3 1 (0.40%) Rancher
3 1 (0.40%) Systems Management Server (SMS)
Vendors
1 55 (22.27%) Oracle
2 48 (19.43%) Microsoft
3 15 (6.07%) VMware
4 11 (4.45%) Cisco
5 8 (3.24%) HP
5 8 (3.24%) Intel
5 8 (3.24%) Juniper
5 8 (3.24%) ProCurve
5 8 (3.24%) Sophos
6 7 (2.83%) Capita
6 7 (2.83%) Google
7 5 (2.02%) Epicor
7 5 (2.02%) Infor
8 4 (1.62%) Tableau
9 3 (1.21%) Cognos
9 3 (1.21%) IBM
9 3 (1.21%) Sage
9 3 (1.21%) Sybase
9 3 (1.21%) Xamarin
10 2 (0.81%) Adobe