Period
to 22 January 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 22 January 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
North West > Lancashire
6 months to
22 Jan 2018
Same period 2017 Same period 2016
Rank 2 2 2
Rank change year-on-year 0 0 +3
Permanent jobs citing SQL 225 308 209
As % of all permanent IT jobs advertised in Lancashire 27.54% 32.70% 23.48%
As % of the Programming Languages category 48.60% 58.89% 46.04%
Number of salaries quoted 188 295 179
Lancashire median annual salary £35,000 £36,000 £34,000
Median salary % change year-on-year -2.78% +5.88% -
10th Percentile £23,175 £22,750 £24,600
90th Percentile £49,500 £45,000 £45,000
North West median annual salary £40,000 £40,000 £38,500
% change year-on-year - +3.90% +2.67%

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 463 523 454
As % of all permanent IT jobs advertised in Lancashire 56.67% 55.52% 51.01%
Number of salaries quoted 380 477 358
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £25,000 £22,771 £23,500
90th Percentile £55,000 £46,000 £45,725
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 22 January 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 22 January 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 78 £35,000 - 5
Preston -5 40 £38,000 +5.56% 11
Burnley 0 20 £35,000 +7.69% 5
Blackburn -1 17 £31,250 -21.88% 10
Skelmersdale +6 9 £32,500 -7.14% 1
Lancaster -15 8 £39,250 -12.78% 7
Blackpool -3 7 £32,500 -15.58% 2
Rossendale 0 3 £40,000 -11.11%
Poulton-le-Fylde - 3 £32,500 -
Accrington - 3 £36,250 - 1
Newton-le-Willows +3 1 £45,000 +40.63% 2
Colne +3 1 £26,500 -37.65% 1
Darwen - 1 - - 1
SQL
North West

For the 6 months to 22 January 2018, 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 116 (51.56%) SQL Server
2 69 (30.67%) T-SQL
3 66 (29.33%) .NET
4 64 (28.44%) C#
5 51 (22.67%) Microsoft
6 49 (21.78%) CSS
7 47 (20.89%) JavaScript
7 47 (20.89%) Business Intelligence
8 45 (20.00%) HTML
9 44 (19.56%) MVC
10 43 (19.11%) ASP.NET
11 41 (18.22%) SQL Server Integration Services
12 39 (17.33%) SQL Server Reporting Services
13 37 (16.44%) Oracle
14 34 (15.11%) Agile Software Development
15 32 (14.22%) Windows
16 31 (13.78%) jQuery
17 30 (13.33%) Data Warehouse
17 30 (13.33%) Degree
18 29 (12.89%) Java
19 27 (12.00%) ITIL
20 26 (11.56%) VBA
20 26 (11.56%) Web Development
20 26 (11.56%) ASP.NET MVC
21 24 (10.67%) Finance
21 24 (10.67%) TDD
22 23 (10.22%) Management Information System
23 22 (9.78%) .NET Framework
23 22 (9.78%) Analytical Skills
24 21 (9.33%) SQL Server 2008

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 9 (4.00%) SharePoint
2 7 (3.11%) BizTalk Server
2 7 (3.11%) OpenEdge
3 6 (2.67%) SAS
4 5 (2.22%) ColdFusion
4 5 (2.22%) MS Exchange
5 3 (1.33%) Tomcat
6 2 (0.89%) IIS
6 2 (0.89%) WordPress
7 1 (0.44%) Apache
7 1 (0.44%) CMS
7 1 (0.44%) nginx
7 1 (0.44%) NServiceBus
7 1 (0.44%) WebSphere
Applications
1 5 (2.22%) Microsoft Excel
2 4 (1.78%) SPSS
3 3 (1.33%) Microsoft Office
Business Applications
1 7 (3.11%) Cognos Business Intelligence
2 4 (1.78%) Dynamics CRM
3 3 (1.33%) Dynamics AX
3 3 (1.33%) Dynamics GP
3 3 (1.33%) Infor M3
4 2 (0.89%) Cognos TM1
4 2 (0.89%) Magento
4 2 (0.89%) Oracle EBS R12
5 1 (0.44%) Payment Gateway
5 1 (0.44%) Sage 50
5 1 (0.44%) SAP Business One
Cloud Services
1 4 (1.78%) Office 365
2 2 (0.89%) Microsoft Azure
3 1 (0.44%) Amazon AWS
3 1 (0.44%) Azure Machine Learning
3 1 (0.44%) Dynamics 365
3 1 (0.44%) SaaS
Communications & Networking
1 7 (3.11%) LAN
1 7 (3.11%) VLAN
1 7 (3.11%) WAN
2 3 (1.33%) SAN
3 2 (0.89%) Intranet
4 1 (0.44%) DNS
4 1 (0.44%) Firewall
4 1 (0.44%) Internet
4 1 (0.44%) TCP/IP
Database & Business Intelligence
1 116 (51.56%) SQL Server
2 41 (18.22%) SQL Server Integration Services
3 39 (17.33%) SQL Server Reporting Services
4 30 (13.33%) Data Warehouse
5 21 (9.33%) SQL Server 2008
6 17 (7.56%) Oracle Database
7 16 (7.11%) SQL Server 2005
8 15 (6.67%) SQL Server 2016
8 15 (6.67%) SQL Server Analysis Services
9 14 (6.22%) Relational Database
10 13 (5.78%) DTS
10 13 (5.78%) MySQL
10 13 (5.78%) PostgreSQL
10 13 (5.78%) SQL Server 2012
10 13 (5.78%) SQL Server 2014
11 12 (5.33%) Power BI
12 11 (4.89%) RDBMS
13 9 (4.00%) BusinessObjects
13 9 (4.00%) Hadoop
14 8 (3.56%) Apache Cassandra
Development Applications
1 9 (4.00%) Visual Studio
2 6 (2.67%) Git (software)
3 5 (2.22%) PowerBuilder
4 4 (1.78%) JIRA
5 3 (1.33%) SoapUI
6 2 (0.89%) GitLab
6 2 (0.89%) Jenkins
6 2 (0.89%) Oracle APEX
6 2 (0.89%) Oracle Forms
6 2 (0.89%) PhpStorm
6 2 (0.89%) SQL Server Management Studio (SSMS)
6 2 (0.89%) Subversion
7 1 (0.44%) Atlassian Bamboo
7 1 (0.44%) Bitbucket
7 1 (0.44%) Dreamweaver
7 1 (0.44%) Eclipse
7 1 (0.44%) Jasmine
7 1 (0.44%) Selenium
7 1 (0.44%) Team Foundation Server
General
1 24 (10.67%) Finance
2 11 (4.89%) Manufacturing
3 10 (4.44%) Retail
4 7 (3.11%) Marketing
5 5 (2.22%) Advertising
6 3 (1.33%) Pharmaceutical
7 2 (0.89%) Aerospace
7 2 (0.89%) Back Office
7 2 (0.89%) Games
7 2 (0.89%) Telecoms
Job Titles
1 116 (51.56%) Developer
2 63 (28.00%) Analyst
3 36 (16.00%) SQL Developer
4 34 (15.11%) SQL Analyst
5 33 (14.67%) .NET Developer
6 23 (10.22%) C# Developer
7 21 (9.33%) C# .NET Developer
8 20 (8.89%) Applications Support
8 20 (8.89%) ASP.NET MVC Developer
9 19 (8.44%) Business Intelligence Developer
10 18 (8.00%) Applications Support Analyst
10 18 (8.00%) Support Analyst
11 16 (7.11%) ASP.NET Developer
11 16 (7.11%) C# ASP.NET Developer
11 16 (7.11%) DBA
11 16 (7.11%) Software Developer
12 15 (6.67%) Administrator
12 15 (6.67%) SQL BI Developer
13 14 (6.22%) SQL DBA
13 14 (6.22%) Test Analyst
Libraries, Frameworks & Software Standards
1 66 (29.33%) .NET
2 49 (21.78%) CSS
3 45 (20.00%) HTML
4 43 (19.11%) ASP.NET
5 31 (13.78%) jQuery
6 26 (11.56%) ASP.NET MVC
7 22 (9.78%) .NET Framework
8 19 (8.44%) REST
9 18 (8.00%) Web Services
10 17 (7.56%) Entity Framework
11 16 (7.11%) HTML5
11 16 (7.11%) Spring
11 16 (7.11%) XML
12 13 (5.78%) Hibernate
13 12 (5.33%) LINQ
13 12 (5.33%) MDX
14 11 (4.89%) ASP.NET Web Forms
14 11 (4.89%) SOAP
15 10 (4.44%) AngularJS
15 10 (4.44%) Node.js
Miscellaneous
1 23 (10.22%) Management Information System
2 22 (9.78%) Analytical Skills
3 13 (5.78%) Computer Science
4 6 (2.67%) Fintech
5 4 (1.78%) Greenfield Project
5 4 (1.78%) NHS
6 2 (0.89%) Analytical Mindset
6 2 (0.89%) Clustering
6 2 (0.89%) Mobile App
6 2 (0.89%) N-Tier
7 1 (0.44%) Data Structures
7 1 (0.44%) iPad
7 1 (0.44%) Linux Command Line
7 1 (0.44%) Replication
7 1 (0.44%) Smart Meter
7 1 (0.44%) W3C
Operating Systems
1 32 (14.22%) Windows
2 14 (6.22%) Windows Server 2008
2 14 (6.22%) Windows Server 2012
3 8 (3.56%) Linux
4 7 (3.11%) Unix
5 3 (1.33%) Windows Server
6 2 (0.89%) Ubuntu
6 2 (0.89%) Windows Server 2003
7 1 (0.44%) Android
7 1 (0.44%) Apple iOS
7 1 (0.44%) Windows 10
Processes & Methodologies
1 47 (20.89%) Business Intelligence
2 44 (19.56%) MVC
3 34 (15.11%) Agile Software Development
4 27 (12.00%) ITIL
5 26 (11.56%) Web Development
6 24 (10.67%) TDD
7 20 (8.89%) OO
7 20 (8.89%) Unit Testing
8 17 (7.56%) Analytics
8 17 (7.56%) ERP
9 15 (6.67%) Data Analysis
10 13 (5.78%) Test Automation
10 13 (5.78%) Test Scripting
11 12 (5.33%) Dashboard Development
11 12 (5.33%) Data Analytics
11 12 (5.33%) Workflow
12 11 (4.89%) Mentoring
12 11 (4.89%) Software Testing
13 10 (4.44%) ETL
14 9 (4.00%) Service Delivery
Programming Languages
1 69 (30.67%) T-SQL
2 64 (28.44%) C#
3 47 (20.89%) JavaScript
4 29 (12.89%) Java
5 26 (11.56%) VBA
6 18 (8.00%) PHP
7 11 (4.89%) PL/SQL
8 8 (3.56%) Groovy
8 8 (3.56%) VB.NET
9 6 (2.67%) Ruby
10 4 (1.78%) Python
10 4 (1.78%) VB
11 3 (1.33%) PHP 5
11 3 (1.33%) PHP 7
12 2 (0.89%) C
12 2 (0.89%) TypeScript
12 2 (0.89%) X++
13 1 (0.44%) C++
13 1 (0.44%) PowerShell
13 1 (0.44%) Shell Script
Qualifications
1 30 (13.33%) Degree
2 12 (5.33%) ISEB
2 12 (5.33%) ISTQB Foundation Certification
3 6 (2.67%) ISTQB
4 4 (1.78%) PhD
5 3 (1.33%) Computer Science Degree
5 3 (1.33%) NVQ Level 4
6 2 (0.89%) Master's Degree
6 2 (0.89%) Microsoft Certification
7 1 (0.44%) ACCA
7 1 (0.44%) CCNA
7 1 (0.44%) CIMA
7 1 (0.44%) Cisco Certification
7 1 (0.44%) ITIL Certification
7 1 (0.44%) MCSE
7 1 (0.44%) SC Cleared
7 1 (0.44%) Security Cleared
Quality Assurance & Compliance
1 17 (7.56%) QA
2 4 (1.78%) Data Quality
2 4 (1.78%) SLA
3 2 (0.89%) PMO
4 1 (0.44%) Sarbanes-Oxley
System Software
1 15 (6.67%) VMware Infrastructure
2 8 (3.56%) Active Directory
3 3 (1.33%) vSphere
4 1 (0.44%) BitLocker
4 1 (0.44%) Hyper-V
4 1 (0.44%) Oracle Clusterware
Systems Management
1 7 (3.11%) FortiGate
2 2 (0.89%) SCCM
2 2 (0.89%) Systems Management Server (SMS)
3 1 (0.44%) Data Guard
3 1 (0.44%) Enterprise Manager Cloud Control
3 1 (0.44%) Microsoft Clustering
3 1 (0.44%) Oracle Flashback
3 1 (0.44%) Oracle RMAN
Vendors
1 51 (22.67%) Microsoft
2 37 (16.44%) Oracle
3 18 (8.00%) VMware
4 13 (5.78%) Tableau
5 10 (4.44%) Cognos
6 9 (4.00%) IBM
7 8 (3.56%) Cisco
8 7 (3.11%) Capita
8 7 (3.11%) HP
8 7 (3.11%) Intel
8 7 (3.11%) Juniper
8 7 (3.11%) ProCurve
8 7 (3.11%) Sophos
9 5 (2.22%) Adobe
9 5 (2.22%) Epicor
9 5 (2.22%) Infor
9 5 (2.22%) Sybase
10 2 (0.89%) Sage
10 2 (0.89%) Zend
11 1 (0.44%) Twitter