Period
to 19 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for SQL Server skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server over the 6 months to 19 January 2018 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server (MS SQL)
North West > Lancashire
6 months to
19 Jan 2018
Same period 2017 Same period 2016
Rank 3 7 3
Rank change year-on-year +4 -4 +5
Permanent jobs citing SQL Server 201 201 195
As % of all permanent IT jobs advertised in Lancashire 24.48% 21.36% 21.69%
As % of the Database & Business Intelligence category 66.78% 59.82% 60.56%
Number of salaries quoted 171 187 184
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £28,000 £26,250 £27,500
90th Percentile £47,500 £43,750 £45,000
North West median annual salary £40,000 £40,000 £40,000

SQL Server is in the Databases and Business Intelligence 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 database or business intelligence skills.

All Database and Business Intelligence Skills
Lancashire
Permanent vacancies with a requirement for database or business intelligence skills 301 336 322
As % of all permanent IT jobs advertised in Lancashire 36.66% 35.71% 35.82%
Number of salaries quoted 253 313 259
Lancashire median annual salary £35,000 £37,500 £35,000
Median salary % change year-on-year -6.67% +7.14% +7.69%
10th Percentile £27,550 £27,500 £27,250
90th Percentile £55,000 £45,000 £46,250
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.26%

SQL Server
Job Vacancy Trend in Lancashire

Job postings citing SQL Server as a percentage of all IT jobs advertised in Lancashire.

Job vacancy trend for SQL Server in Lancashire

SQL Server
Salary Trend in Lancashire

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

Salary trend for SQL Server in Lancashire

SQL Server
Salary Histogram in Lancashire

The salary distribution of IT jobs citing SQL Server in Lancashire over the 6 months to 19 January 2018.

Salary histogram for SQL Server in Lancashire

SQL Server
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 Server within the Lancashire region over the 6 months to 19 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 0 55 £35,000 - 1
Preston +4 49 £38,000 +1.33% 12
Lancaster - 16 £40,500 - 2
Blackburn +6 15 £28,500 -21.38% 3
Burnley +4 15 £35,000 +8.53% 2
Blackpool +2 11 £35,000 -9.09% 4
Accrington - 3 £36,250 - 1
Skelmersdale -3 2 £24,250 -35.33%
Darwen - 2 £32,500 - 1
Newton-le-Willows +3 1 £45,000 +40.63% 1
Rossendale - 1 £47,500 -
SQL Server
North West

For the 6 months to 19 January 2018, IT jobs citing SQL Server 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 Server.

1 118 (58.71%) SQL
2 102 (50.75%) .NET
3 96 (47.76%) C#
4 86 (42.79%) ASP.NET
5 73 (36.32%) Microsoft
6 70 (34.83%) MVC
7 57 (28.36%) T-SQL
8 55 (27.36%) ASP.NET MVC
9 54 (26.87%) Business Intelligence
10 52 (25.87%) Agile Software Development
10 52 (25.87%) TDD
11 43 (21.39%) Web Application Development
12 42 (20.90%) Windows
13 41 (20.40%) SQL Server Integration Services
13 41 (20.40%) SQL Server 2016
14 38 (18.91%) BDD
15 36 (17.91%) ASP.NET MVC 5
16 33 (16.42%) ASP.NET Web API
16 33 (16.42%) RESTful
17 32 (15.92%) .NET Framework
17 32 (15.92%) JavaScript
18 30 (14.93%) Data Warehouse
18 30 (14.93%) WCF
19 29 (14.43%) Web Development
19 29 (14.43%) Entity Framework
20 28 (13.93%) SQL Server Reporting Services
21 26 (12.94%) Git (software)
22 25 (12.44%) Degree
22 25 (12.44%) VMware
22 25 (12.44%) Finance

SQL Server
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 10 (4.98%) MS Exchange
2 8 (3.98%) SharePoint
3 7 (3.48%) BizTalk Server
4 5 (2.49%) IIS
5 4 (1.99%) SAS
6 3 (1.49%) WordPress
7 1 (0.50%) nginx
7 1 (0.50%) NServiceBus
7 1 (0.50%) WebSphere
Applications
1 9 (4.48%) Microsoft Office
2 4 (1.99%) Microsoft Excel
2 4 (1.99%) SPSS
Business Applications
1 7 (3.48%) Cognos Business Intelligence
2 6 (2.99%) Dynamics CRM
3 5 (2.49%) Dynamics GP
4 2 (1.00%) Cognos TM1
5 1 (0.50%) Dynamics AX
5 1 (0.50%) Payment Gateway
5 1 (0.50%) Sage 50
Cloud Services
1 8 (3.98%) Office 365
2 3 (1.49%) Amazon AWS
3 2 (1.00%) Microsoft Azure
4 1 (0.50%) Azure Machine Learning
4 1 (0.50%) Dynamics 365
4 1 (0.50%) SaaS
Communications & Networking
1 11 (5.47%) SAN
2 8 (3.98%) LAN
2 8 (3.98%) WAN
3 7 (3.48%) VLAN
4 4 (1.99%) Internet
4 4 (1.99%) Network Security
5 2 (1.00%) ADSL
5 2 (1.00%) DHCP
5 2 (1.00%) DNS
5 2 (1.00%) Firewall
5 2 (1.00%) Intranet
5 2 (1.00%) MPLS
6 1 (0.50%) FTP
6 1 (0.50%) PBX
6 1 (0.50%) Wireless
Database & Business Intelligence
1 41 (20.40%) SQL Server 2016
1 41 (20.40%) SQL Server Integration Services
2 30 (14.93%) Data Warehouse
3 28 (13.93%) SQL Server Reporting Services
4 22 (10.95%) NoSQL
4 22 (10.95%) SQL Server 2014
5 21 (10.45%) SQL Server 2008
6 16 (7.96%) SQL Server 2005
7 15 (7.46%) SQL Server Analysis Services
8 14 (6.97%) DTS
9 13 (6.47%) SQL Server 2012
10 12 (5.97%) Power BI
11 11 (5.47%) MySQL
12 9 (4.48%) PostgreSQL
13 8 (3.98%) Microsoft Analysis Services
14 3 (1.49%) BusinessObjects
14 3 (1.49%) Relational Database
15 2 (1.00%) Data Mining
15 2 (1.00%) DB2
15 2 (1.00%) Redis
Development Applications
1 26 (12.94%) Git (software)
2 9 (4.48%) Visual Studio
3 2 (1.00%) Jenkins
3 2 (1.00%) JIRA
3 2 (1.00%) SQL Server Management Studio (SSMS)
4 1 (0.50%) Atlassian Bamboo
4 1 (0.50%) Bitbucket
4 1 (0.50%) Dreamweaver
4 1 (0.50%) GitLab
4 1 (0.50%) NUnit
4 1 (0.50%) Oracle APEX
4 1 (0.50%) PhpStorm
4 1 (0.50%) Selenium
4 1 (0.50%) Subversion
4 1 (0.50%) Team Foundation Server
General
1 25 (12.44%) Finance
2 22 (10.95%) Retail
3 10 (4.98%) Games
4 5 (2.49%) Pharmaceutical
5 3 (1.49%) Advertising
6 2 (1.00%) Aerospace
6 2 (1.00%) Marketing
6 2 (1.00%) Telecoms
7 1 (0.50%) Banking
7 1 (0.50%) Legal
7 1 (0.50%) Manufacturing
Job Titles
1 125 (62.19%) Developer
2 81 (40.30%) .NET Developer
3 46 (22.89%) C# Developer
4 41 (20.40%) C# .NET Developer
5 38 (18.91%) Analyst
6 31 (15.42%) SQL Analyst
7 29 (14.43%) ASP.NET MVC Developer
8 27 (13.43%) SQL Developer
9 26 (12.94%) ASP.NET Developer
10 25 (12.44%) C# ASP.NET Developer
11 19 (9.45%) Business Intelligence Developer
12 15 (7.46%) SQL BI Developer
13 12 (5.97%) Software Developer
13 12 (5.97%) SQL Server Developer
14 11 (5.47%) C# Software Developer
15 9 (4.48%) Software Analyst
15 9 (4.48%) Software Test Analyst
15 9 (4.48%) SQL Support Analyst
15 9 (4.48%) Test Analyst
15 9 (4.48%) Tester
Libraries, Frameworks & Software Standards
1 102 (50.75%) .NET
2 86 (42.79%) ASP.NET
3 55 (27.36%) ASP.NET MVC
4 36 (17.91%) ASP.NET MVC 5
5 33 (16.42%) ASP.NET Web API
5 33 (16.42%) RESTful
6 32 (15.92%) .NET Framework
7 30 (14.93%) WCF
8 29 (14.43%) Entity Framework
9 24 (11.94%) Node.js
10 22 (10.95%) Twitter Bootstrap
11 21 (10.45%) HTML
12 19 (9.45%) AngularJS
12 19 (9.45%) ASP.NET Web Forms
12 19 (9.45%) XML
13 18 (8.96%) CSS
14 17 (8.46%) KnockoutJS
15 15 (7.46%) jQuery
16 14 (6.97%) Code First Entity Framework
17 13 (6.47%) Web Services
Miscellaneous
1 17 (8.46%) Management Information System
2 14 (6.97%) Analytical Skills
3 11 (5.47%) Greenfield Project
4 8 (3.98%) Computer Science
5 7 (3.48%) Enterprise Software
6 6 (2.99%) Fintech
6 6 (2.99%) NHS
7 5 (2.49%) e-Learning
8 4 (1.99%) Digital TV
9 2 (1.00%) Clustering
9 2 (1.00%) Mobile App
9 2 (1.00%) N-Tier
10 1 (0.50%) Data Structures
10 1 (0.50%) Replication
10 1 (0.50%) Tandem
Operating Systems
1 42 (20.90%) Windows
2 20 (9.95%) Windows Server 2008
3 15 (7.46%) Windows Server 2012
4 9 (4.48%) Windows Server
5 8 (3.98%) Linux
6 7 (3.48%) Windows Server 2003
7 5 (2.49%) Unix
8 3 (1.49%) Windows 7
9 2 (1.00%) Windows 10
10 1 (0.50%) Solaris
10 1 (0.50%) Ubuntu
Processes & Methodologies
1 70 (34.83%) MVC
2 54 (26.87%) Business Intelligence
3 52 (25.87%) Agile Software Development
3 52 (25.87%) TDD
4 43 (21.39%) Web Application Development
5 38 (18.91%) BDD
6 29 (14.43%) Web Development
7 21 (10.45%) ITIL
8 19 (9.45%) OO
9 16 (7.96%) E-Commerce
9 16 (7.96%) Unit Testing
10 15 (7.46%) Scrum
11 13 (6.47%) Analytics
12 12 (5.97%) Dashboard Development
12 12 (5.97%) Data Analytics
13 11 (5.47%) Continuous Improvement
13 11 (5.47%) Data Analysis
13 11 (5.47%) SDLC
13 11 (5.47%) Workflow
14 10 (4.98%) Software Testing
Programming Languages
1 118 (58.71%) SQL
2 96 (47.76%) C#
3 57 (28.36%) T-SQL
4 32 (15.92%) JavaScript
5 24 (11.94%) VBA
6 21 (10.45%) Ruby
7 15 (7.46%) VB.NET
8 13 (6.47%) VB
9 12 (5.97%) Java
10 6 (2.99%) C
11 5 (2.49%) VB6
12 4 (1.99%) PHP
12 4 (1.99%) Python
13 3 (1.49%) PowerShell
14 2 (1.00%) TypeScript
15 1 (0.50%) Bash Shell
15 1 (0.50%) PHP 7
Qualifications
1 25 (12.44%) Degree
2 9 (4.48%) ISEB
2 9 (4.48%) ISTQB Foundation Certification
3 8 (3.98%) Microsoft Certification
4 7 (3.48%) MCSE
5 4 (1.99%) HND
5 4 (1.99%) PhD
6 3 (1.49%) NVQ Level 4
7 2 (1.00%) Master's Degree
8 1 (0.50%) CCNA
8 1 (0.50%) Cisco Certification
8 1 (0.50%) ITIL Certification
8 1 (0.50%) SC Cleared
8 1 (0.50%) Security Cleared
Quality Assurance & Compliance
1 11 (5.47%) QA
2 7 (3.48%) SLA
3 6 (2.99%) Data Quality
4 2 (1.00%) GDPR
5 1 (0.50%) PCI DSS
System Software
1 19 (9.45%) Active Directory
2 16 (7.96%) VMware Infrastructure
3 4 (1.99%) vSphere
4 2 (1.00%) Docker
4 2 (1.00%) VMware ESXi
5 1 (0.50%) BitLocker
5 1 (0.50%) Hyper-V
Systems Management
1 7 (3.48%) FortiGate
1 7 (3.48%) SCCM
2 4 (1.99%) Systems Management Server (SMS)
3 2 (1.00%) vCenter Server
3 2 (1.00%) WSUS
4 1 (0.50%) AirWatch
4 1 (0.50%) HP SIM
4 1 (0.50%) Microsoft Clustering
Vendors
1 73 (36.32%) Microsoft
2 25 (12.44%) VMware
3 13 (6.47%) Tableau
4 10 (4.98%) Cisco
4 10 (4.98%) Cognos
4 10 (4.98%) HP
5 9 (4.48%) IBM
6 7 (3.48%) Intel
6 7 (3.48%) Juniper
6 7 (3.48%) ProCurve
6 7 (3.48%) Sophos
7 6 (2.99%) Capita
8 5 (2.49%) Oracle
8 5 (2.49%) Xamarin
9 2 (1.00%) Citrix
9 2 (1.00%) Facebook
10 1 (0.50%) Google
10 1 (0.50%) Sage
10 1 (0.50%) Twitter
10 1 (0.50%) WatchGuard