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

SQL (Structured Query Language)
North West > Lancashire
6 months to
18 Jul 2018
Same period 2017 Same period 2016
Rank 2 2 3
Rank change year-on-year 0 +1 -1
Permanent jobs citing SQL 231 318 211
As % of all permanent IT jobs advertised in Lancashire 26.19% 36.34% 26.21%
As % of the Programming Languages category 50.00% 59.33% 46.89%
Number of salaries quoted 213 298 184
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £26,000 £23,250 £23,500
90th Percentile £53,950 £50,000 £45,000
North West median annual salary £40,500 £40,000 £37,500
% change year-on-year +1.25% +6.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 462 536 450
As % of all permanent IT jobs advertised in Lancashire 52.38% 61.26% 55.90%
Number of salaries quoted 427 485 388
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £25,900 £25,000 £22,750
90th Percentile £56,250 £47,500 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +2.56%

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 18 July 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 18 July 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 70 £35,000 +7.69% 8
Preston -1 59 £35,000 -10.26% 9
Blackpool -3 16 £32,500 - 3
Lancaster -2 15 £35,000 -6.67%
Blackburn -10 13 £31,000 -4.62% 5
Burnley -4 5 £35,000 - 1
Colne +3 2 £27,500 -15.38%
Ormskirk +1 1 £35,000 +11.11%
Skelmersdale +1 1 £40,000 +17.65%
Accrington - 1 £40,000 -
SQL
North West

For the 6 months to 18 July 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 87 (37.66%) SQL Server
2 60 (25.97%) .NET
3 58 (25.11%) Agile Software Development
4 53 (22.94%) C#
5 50 (21.65%) Oracle
6 47 (20.35%) CSS
6 47 (20.35%) HTML
6 47 (20.35%) JavaScript
6 47 (20.35%) Microsoft
7 46 (19.91%) SQL Server Reporting Services
8 45 (19.48%) Data Warehouse
8 45 (19.48%) Analytical Skills
9 44 (19.05%) T-SQL
10 39 (16.88%) SDLC
11 38 (16.45%) Business Intelligence
12 37 (16.02%) SQL Server Integration Services
13 34 (14.72%) jQuery
14 32 (13.85%) MVC
15 31 (13.42%) Java
15 31 (13.42%) ASP.NET
16 30 (12.99%) Problem-Solving
17 28 (12.12%) Software Deployment
17 28 (12.12%) Finance
18 27 (11.69%) OO
19 26 (11.26%) ETL
20 25 (10.82%) Web Development
21 24 (10.39%) ITIL
22 23 (9.96%) Microsoft Excel
23 21 (9.09%) SQL Server 2016
24 20 (8.66%) Software Engineering

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 (8.23%) IIS
2 5 (2.16%) SharePoint
3 4 (1.73%) CMS
3 4 (1.73%) OpenEdge
4 2 (0.87%) IBM Notes
5 1 (0.43%) Exchange Server 2010
5 1 (0.43%) MS Exchange
5 1 (0.43%) Tomcat
5 1 (0.43%) WordPress
Applications
1 23 (9.96%) Microsoft Excel
2 16 (6.93%) Microsoft Project
3 14 (6.06%) MS Visio
4 12 (5.19%) Microsoft Office
Business Applications
1 10 (4.33%) Dynamics NAV
2 3 (1.30%) Dynamics CRM
3 2 (0.87%) NetSuite
4 1 (0.43%) Cognos TM1
4 1 (0.43%) Dynamics AX
4 1 (0.43%) Infor CloudSuite Industrial (formerly SyteLine)
4 1 (0.43%) Oracle Payables
4 1 (0.43%) Oracle Receivables
4 1 (0.43%) Sage 200
4 1 (0.43%) Sage X3
4 1 (0.43%) SAP Business One
4 1 (0.43%) Unit4 Business World
Cloud Services
1 10 (4.33%) Google Analytics
2 9 (3.90%) Amazon AWS
3 5 (2.16%) Microsoft Azure
3 5 (2.16%) Office 365
4 4 (1.73%) Google Tag Manager
4 4 (1.73%) SaaS
5 3 (1.30%) npm
6 2 (0.87%) Google Cloud Platform
7 1 (0.43%) Cloud Computing
Communications & Networking
1 4 (1.73%) SAN
2 3 (1.30%) HTTP
2 3 (1.30%) Internet
2 3 (1.30%) LAN
3 2 (0.87%) TCP/IP
4 1 (0.43%) Firewall
4 1 (0.43%) Intranet
4 1 (0.43%) VLAN
4 1 (0.43%) VoIP
4 1 (0.43%) WAN
Database & Business Intelligence
1 87 (37.66%) SQL Server
2 46 (19.91%) SQL Server Reporting Services
3 45 (19.48%) Data Warehouse
4 37 (16.02%) SQL Server Integration Services
5 21 (9.09%) SQL Server 2016
6 16 (6.93%) MS Access
6 16 (6.93%) MySQL
6 16 (6.93%) OLAP
6 16 (6.93%) SQL Server Analysis Services
7 12 (5.19%) OLTP
8 11 (4.76%) PostgreSQL
9 10 (4.33%) BusinessObjects
10 9 (3.90%) Hadoop
11 8 (3.46%) Apache Cassandra
12 6 (2.60%) Relational Database
12 6 (2.60%) SQL Server 2008
13 5 (2.16%) Crystal Reports
13 5 (2.16%) Power BI
14 4 (1.73%) OLAP Cube
15 3 (1.30%) SQL Server 2012
Development Applications
1 17 (7.36%) Visual Studio
2 12 (5.19%) ERwin
3 7 (3.03%) Selenium
4 4 (1.73%) Git (software)
4 4 (1.73%) SQL Server Management Studio (SSMS)
4 4 (1.73%) Subversion
5 3 (1.30%) Cucumber
5 3 (1.30%) JIRA
5 3 (1.30%) JUnit
6 2 (0.87%) Team Foundation Server
7 1 (0.43%) Dreamweaver
7 1 (0.43%) NUnit
General
1 28 (12.12%) Finance
2 10 (4.33%) Retail
3 9 (3.90%) Manufacturing
4 8 (3.46%) Marketing
5 7 (3.03%) Legal
6 6 (2.60%) Advertising
7 5 (2.16%) Aerospace
8 4 (1.73%) Brand Awareness
9 1 (0.43%) Back Office
9 1 (0.43%) Military
Job Titles
1 112 (48.48%) Developer
2 62 (26.84%) Analyst
3 41 (17.75%) SQL Developer
4 36 (15.58%) Applications Support
5 35 (15.15%) Support Analyst
6 34 (14.72%) .NET Developer
7 32 (13.85%) Applications Support Analyst
7 32 (13.85%) C# Developer
8 26 (11.26%) C# .NET Developer
9 19 (8.23%) Software Developer
10 18 (7.79%) C# Software Developer
10 18 (7.79%) Senior Developer
11 17 (7.36%) Java Developer
12 16 (6.93%) SQL Analyst
13 15 (6.49%) .NET Software Developer
14 14 (6.06%) VBA Developer
15 13 (5.63%) Microsoft Developer
15 13 (5.63%) Senior SQL Developer
16 12 (5.19%) Architect
16 12 (5.19%) Data Architect
Libraries, Frameworks & Software Standards
1 60 (25.97%) .NET
2 47 (20.35%) CSS
2 47 (20.35%) HTML
3 34 (14.72%) jQuery
4 31 (13.42%) ASP.NET
5 17 (7.36%) Spring
6 16 (6.93%) Ajax
7 12 (5.19%) Classic ASP
7 12 (5.19%) Web Services
8 10 (4.33%) AngularJS
8 10 (4.33%) Hibernate
9 8 (3.46%) .NET Core
9 8 (3.46%) Apache Camel
9 8 (3.46%) ASP.NET MVC
9 8 (3.46%) RabbitMQ
9 8 (3.46%) RESTful
9 8 (3.46%) Twitter Bootstrap
9 8 (3.46%) XML
10 7 (3.03%) .NET Framework
11 6 (2.60%) Entity Framework
Miscellaneous
1 45 (19.48%) Analytical Skills
2 13 (5.63%) Management Information System
3 12 (5.19%) Hybrid Cloud
4 8 (3.46%) Computer Science
5 6 (2.60%) Self-Motivation
6 5 (2.16%) Clustering
6 5 (2.16%) Data Protection Act
7 4 (1.73%) Fintech
7 4 (1.73%) User Experience
8 3 (1.30%) Enterprise Software
8 3 (1.30%) N-Tier
9 2 (0.87%) e-Learning
10 1 (0.43%) Client/Server
10 1 (0.43%) Data Centre
10 1 (0.43%) Driving Licence
10 1 (0.43%) FMCG
10 1 (0.43%) Replication
Operating Systems
1 15 (6.49%) Windows
2 8 (3.46%) Windows Server
2 8 (3.46%) Windows Server 2012
3 7 (3.03%) Android
4 6 (2.60%) Windows Server 2008
5 5 (2.16%) Unix
6 4 (1.73%) Windows 10
6 4 (1.73%) Windows Server 2003
7 3 (1.30%) Linux
Processes & Methodologies
1 58 (25.11%) Agile Software Development
2 39 (16.88%) SDLC
3 38 (16.45%) Business Intelligence
4 32 (13.85%) MVC
5 30 (12.99%) Problem-Solving
6 28 (12.12%) Software Deployment
7 27 (11.69%) OO
8 26 (11.26%) ETL
9 25 (10.82%) Web Development
10 24 (10.39%) ITIL
11 20 (8.66%) Software Engineering
12 19 (8.23%) Data Modelling
13 18 (7.79%) Data Architecture
13 18 (7.79%) Kanban
14 16 (6.93%) Analytics
14 16 (6.93%) Continuous Improvement
14 16 (6.93%) CRM
14 16 (6.93%) Migration
15 15 (6.49%) Data Analysis
15 15 (6.49%) Service Delivery
Programming Languages
1 53 (22.94%) C#
2 47 (20.35%) JavaScript
3 44 (19.05%) T-SQL
4 31 (13.42%) Java
5 19 (8.23%) VBA
6 12 (5.19%) C
7 11 (4.76%) PHP
8 8 (3.46%) Groovy
8 8 (3.46%) Java 8
8 8 (3.46%) PowerShell
9 6 (2.60%) VB.NET
10 5 (2.16%) C++
10 5 (2.16%) Ruby
11 4 (1.73%) Python
11 4 (1.73%) VB
11 4 (1.73%) VBScript
12 2 (0.87%) PL/SQL
12 2 (0.87%) VC++
13 1 (0.43%) Perl
13 1 (0.43%) RPG
Qualifications
1 18 (7.79%) Security Cleared
2 17 (7.36%) Degree
3 16 (6.93%) SC Cleared
4 8 (3.46%) Microsoft Certification
5 4 (1.73%) MCSE
6 3 (1.30%) Computer Science Degree
6 3 (1.30%) ISEB
7 2 (0.87%) ISTQB
8 1 (0.43%) ISTQB Foundation Certification
8 1 (0.43%) ITIL Certification
Quality Assurance & Compliance
1 9 (3.90%) GDPR
2 4 (1.73%) QA
3 1 (0.43%) SLA
System Software
1 7 (3.03%) Active Directory
2 4 (1.73%) BitLocker
2 4 (1.73%) vSphere
3 3 (1.30%) Docker
3 3 (1.30%) Hyper-V
4 1 (0.43%) VMware Infrastructure
Systems Management
1 4 (1.73%) Microsoft Clustering
1 4 (1.73%) SCCM
2 2 (0.87%) Kubernetes
3 1 (0.43%) FortiGate
3 1 (0.43%) Rancher
Vendors
1 50 (21.65%) Oracle
2 47 (20.35%) Microsoft
3 12 (5.19%) Google
4 11 (4.76%) VMware
5 8 (3.46%) Xamarin
6 6 (2.60%) Sage
7 5 (2.16%) SAP
7 5 (2.16%) Tealeaf
8 4 (1.73%) Cisco
9 3 (1.30%) Atlassian
9 3 (1.30%) Epicor
10 2 (0.87%) Capita
10 2 (0.87%) IFS
10 2 (0.87%) Lotus
10 2 (0.87%) Tableau
11 1 (0.43%) Baan
11 1 (0.43%) Citrix
11 1 (0.43%) HP
11 1 (0.43%) IBM
11 1 (0.43%) Intel