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

SQL (Structured Query Language)
North West > Lancashire
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 2 2 2
Rank change year-on-year 0 0 +2
Permanent jobs citing SQL 181 288 238
As % of all permanent IT jobs advertised in Lancashire 24.59% 33.53% 27.55%
As % of the Programming Languages category 53.24% 56.14% 49.38%
Number of salaries quoted 157 252 218
Lancashire median annual salary £35,000 £35,000 £37,500
Median salary % change year-on-year - -6.67% +4.17%
10th Percentile £25,500 £25,000 £26,100
90th Percentile £50,000 £45,000 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.26%

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 340 513 482
As % of all permanent IT jobs advertised in Lancashire 46.20% 59.72% 55.79%
Number of salaries quoted 293 431 432
Lancashire median annual salary £37,500 £35,000 £37,250
Median salary % change year-on-year +7.14% -6.04% +6.43%
10th Percentile £25,550 £26,000 £25,775
90th Percentile £53,500 £47,500 £45,000
North West median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

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 23 October 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 23 October 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
Preston +2 59 £37,500 - 10
Chorley 0 38 £35,000 - 3
Blackpool 0 19 £38,500 +22.22% 7
Blackburn +1 18 £31,000 -4.62% 13
Lancaster +5 10 £35,000 -22.22% 1
Skelmersdale +1 1 £40,000 +60.00% 1
Burnley -7 1 £30,000 -14.29%
SQL
North West

For the 6 months to 23 October 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 59 (32.60%) SQL Server
2 43 (23.76%) Microsoft
3 39 (21.55%) Agile Software Development
3 39 (21.55%) SQL Server Reporting Services
4 38 (20.99%) .NET
5 37 (20.44%) C#
6 32 (17.68%) HTML
7 31 (17.13%) Oracle
8 30 (16.57%) JavaScript
8 30 (16.57%) SQL Server Integration Services
9 29 (16.02%) Java
9 29 (16.02%) T-SQL
10 27 (14.92%) CSS
10 27 (14.92%) Business Intelligence
11 23 (12.71%) MVC
11 23 (12.71%) Data Warehouse
11 23 (12.71%) Web Development
12 22 (12.15%) Software Engineering
13 21 (11.60%) Analytical Skills
14 20 (11.05%) ASP.NET
15 19 (10.50%) Windows
15 19 (10.50%) Problem-Solving
16 18 (9.94%) Degree
17 17 (9.39%) SDLC
18 16 (8.84%) Power BI
18 16 (8.84%) Software Deployment
18 16 (8.84%) Finance
19 15 (8.29%) ITIL
19 15 (8.29%) Microsoft Excel
20 14 (7.73%) Spring

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 7 (3.87%) MS Exchange
2 4 (2.21%) SharePoint
2 4 (2.21%) WebLogic
2 4 (2.21%) WordPress
3 3 (1.66%) CMS
3 3 (1.66%) Kentico
4 1 (0.55%) Exchange Server 2010
4 1 (0.55%) IIS
4 1 (0.55%) Jupyter
4 1 (0.55%) NServiceBus
4 1 (0.55%) SAS
4 1 (0.55%) Tomcat
4 1 (0.55%) WebSphere
Applications
1 15 (8.29%) Microsoft Excel
2 9 (4.97%) Microsoft Office
3 3 (1.66%) Adobe Creative Suite
4 1 (0.55%) Microsoft PowerPoint
4 1 (0.55%) SPSS
Business Applications
1 5 (2.76%) Dynamics NAV
2 3 (1.66%) Dynamics CRM
3 2 (1.10%) NetSuite
3 2 (1.10%) Sage 200
4 1 (0.55%) Dynamics AX
4 1 (0.55%) Infor CloudSuite Industrial (formerly SyteLine)
4 1 (0.55%) Oracle Payables
4 1 (0.55%) Oracle Receivables
4 1 (0.55%) Sage 500
4 1 (0.55%) Unit4 Business World
Cloud Services
1 10 (5.52%) Microsoft Azure
2 5 (2.76%) Amazon AWS
3 4 (2.21%) Google Analytics
4 3 (1.66%) Google Cloud Platform
5 2 (1.10%) npm
5 2 (1.10%) Yarn
6 1 (0.55%) Dynamics 365
Communications & Networking
1 6 (3.31%) Firewall
1 6 (3.31%) MPLS
1 6 (3.31%) NAS
1 6 (3.31%) Skype
1 6 (3.31%) VoIP
1 6 (3.31%) VPN
2 1 (0.55%) Intranet
2 1 (0.55%) SMS
Database & Business Intelligence
1 59 (32.60%) SQL Server
2 39 (21.55%) SQL Server Reporting Services
3 30 (16.57%) SQL Server Integration Services
4 23 (12.71%) Data Warehouse
5 16 (8.84%) Power BI
6 14 (7.73%) MySQL
7 13 (7.18%) SQL Server 2008
8 10 (5.52%) SQL Server Analysis Services
9 8 (4.42%) Hadoop
9 8 (4.42%) OLAP
9 8 (4.42%) SQL Server 2012
10 7 (3.87%) Apache Cassandra
10 7 (3.87%) DB2
10 7 (3.87%) OLTP
11 6 (3.31%) Relational Database
11 6 (3.31%) SQL Server 2016
12 5 (2.76%) NoSQL
13 4 (2.21%) BusinessObjects
13 4 (2.21%) Crystal Reports
13 4 (2.21%) PostgreSQL
Development Applications
1 9 (4.97%) Git (software)
2 8 (4.42%) Selenium
2 8 (4.42%) Visual Studio
3 7 (3.87%) ERwin
4 3 (1.66%) Cucumber
4 3 (1.66%) Grunt
4 3 (1.66%) gulp
4 3 (1.66%) JIRA
4 3 (1.66%) JUnit
4 3 (1.66%) WebDriver
4 3 (1.66%) webpack
5 2 (1.10%) Appium
5 2 (1.10%) Jenkins
5 2 (1.10%) PHPUnit
5 2 (1.10%) Protractor
5 2 (1.10%) Team Foundation Server
6 1 (0.55%) Atlassian Bamboo
General
1 16 (8.84%) Finance
2 9 (4.97%) Retail
3 6 (3.31%) Legal
4 4 (2.21%) German Language
5 3 (1.66%) Advertising
5 3 (1.66%) Dutch Language
5 3 (1.66%) French Language
5 3 (1.66%) Italian Language
5 3 (1.66%) Manufacturing
5 3 (1.66%) Marketing
6 1 (0.55%) Billing
6 1 (0.55%) Local Government
Job Titles
1 75 (41.44%) Developer
2 43 (23.76%) Analyst
3 28 (15.47%) SQL Developer
4 24 (13.26%) Applications Support
5 22 (12.15%) Support Analyst
6 19 (10.50%) Applications Support Analyst
7 15 (8.29%) .NET Developer
7 15 (8.29%) C# Developer
8 14 (7.73%) Senior Developer
9 12 (6.63%) Senior SQL Developer
9 12 (6.63%) Software Developer
9 12 (6.63%) SQL Analyst
10 11 (6.08%) Business Intelligence Developer
10 11 (6.08%) C# .NET Developer
10 11 (6.08%) Development Manager
11 10 (5.52%) Java Developer
11 10 (5.52%) Software Development Manager
11 10 (5.52%) Software Engineer
11 10 (5.52%) Software Manager
12 9 (4.97%) Test Analyst
Libraries, Frameworks & Software Standards
1 38 (20.99%) .NET
2 32 (17.68%) HTML
3 27 (14.92%) CSS
4 20 (11.05%) ASP.NET
5 14 (7.73%) jQuery
5 14 (7.73%) Spring
6 12 (6.63%) AngularJS
6 12 (6.63%) React
7 8 (4.42%) Twitter Bootstrap
7 8 (4.42%) XML
8 7 (3.87%) Apache Camel
8 7 (3.87%) RabbitMQ
8 7 (3.87%) RESTful
8 7 (3.87%) Web Services
9 6 (3.31%) .NET Core
9 6 (3.31%) CSS3
9 6 (3.31%) Node.js
9 6 (3.31%) Vue.js
10 4 (2.21%) Angular 2
10 4 (2.21%) ASP.NET MVC
Miscellaneous
1 21 (11.60%) Analytical Skills
2 11 (6.08%) Computer Science
3 7 (3.87%) AS400
3 7 (3.87%) Data Structures
3 7 (3.87%) Hybrid Cloud
3 7 (3.87%) iSeries
4 6 (3.31%) Algorithms
4 6 (3.31%) Self-Motivation
5 5 (2.76%) Management Information System
6 3 (1.66%) Enterprise Software
6 3 (1.66%) N-Tier
6 3 (1.66%) User Experience
7 2 (1.10%) Data Centre
7 2 (1.10%) e-Learning
7 2 (1.10%) Greenfield Project
7 2 (1.10%) Smart Energy
7 2 (1.10%) Smart Meter
8 1 (0.55%) Analytical Mindset
8 1 (0.55%) EPoS
8 1 (0.55%) Mobile App
Operating Systems
1 19 (10.50%) Windows
2 13 (7.18%) Linux
3 11 (6.08%) Windows Server
4 6 (3.31%) Android
5 4 (2.21%) Red Hat Enterprise Linux
5 4 (2.21%) Windows Server 2012
6 3 (1.66%) Windows 7
6 3 (1.66%) Windows 8
7 1 (0.55%) Unix
7 1 (0.55%) Windows Mobile
7 1 (0.55%) Windows Phone
7 1 (0.55%) Windows Server 2008
Processes & Methodologies
1 39 (21.55%) Agile Software Development
2 27 (14.92%) Business Intelligence
3 23 (12.71%) MVC
3 23 (12.71%) Web Development
4 22 (12.15%) Software Engineering
5 19 (10.50%) Problem-Solving
6 17 (9.39%) SDLC
7 16 (8.84%) Software Deployment
8 15 (8.29%) ITIL
9 14 (7.73%) ETL
10 13 (7.18%) Logistics
10 13 (7.18%) Migration
11 12 (6.63%) Analytics
11 12 (6.63%) Data Analysis
11 12 (6.63%) Data Modelling
11 12 (6.63%) Unit Testing
12 10 (5.52%) ERP
12 10 (5.52%) Test Automation
13 9 (4.97%) OOP
13 9 (4.97%) Test Scripting
Programming Languages
1 37 (20.44%) C#
2 30 (16.57%) JavaScript
3 29 (16.02%) Java
3 29 (16.02%) T-SQL
4 8 (4.42%) Python
4 8 (4.42%) RPG
5 7 (3.87%) Groovy
5 7 (3.87%) Java 8
5 7 (3.87%) RPG IV
6 6 (3.31%) PHP
7 3 (1.66%) COBOL
8 2 (1.10%) C
8 2 (1.10%) C++
8 2 (1.10%) R
8 2 (1.10%) VBScript
9 1 (0.55%) Data Analysis Expressions (DAX)
9 1 (0.55%) PL/SQL
9 1 (0.55%) Ruby
9 1 (0.55%) VB.NET
Qualifications
1 18 (9.94%) Degree
2 7 (3.87%) ISEB
3 5 (2.76%) Computer Science Degree
3 5 (2.76%) SC Cleared
3 5 (2.76%) Security Cleared
4 4 (2.21%) ISTQB Foundation Certification
5 3 (1.66%) ISTQB
5 3 (1.66%) Microsoft Certification
6 1 (0.55%) Master's Degree
6 1 (0.55%) MCP
6 1 (0.55%) Numerate Degree
6 1 (0.55%) PhD
Quality Assurance & Compliance
1 11 (6.08%) QA
2 6 (3.31%) GDPR
System Software
1 9 (4.97%) Hyper-V
2 8 (4.42%) Active Directory
3 5 (2.76%) Docker
4 4 (2.21%) Virtual Machines
Systems Management
1 3 (1.66%) Kubernetes
2 2 (1.10%) HP ALM
Vendors
1 43 (23.76%) Microsoft
2 31 (17.13%) Oracle
3 7 (3.87%) Google
3 7 (3.87%) IBM
3 7 (3.87%) VMware
4 6 (3.31%) Sage
4 6 (3.31%) Xamarin
5 5 (2.76%) Tableau
6 4 (2.21%) Red Hat
6 4 (2.21%) SAP
6 4 (2.21%) Tealeaf
7 3 (1.66%) Adobe
7 3 (1.66%) Atlassian
8 2 (1.10%) HP
8 2 (1.10%) IFS
9 1 (0.55%) Citrix
9 1 (0.55%) Epicor
9 1 (0.55%) Infor
9 1 (0.55%) Teradata
9 1 (0.55%) Twitter