Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Lichfield 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 20 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Staffordshire > Lichfield
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 2 2 3
Rank change year-on-year 0 +1 -1
Permanent jobs citing SQL 60 58 45
As % of all permanent IT jobs advertised in Lichfield 40.54% 43.94% 31.25%
As % of the Programming Languages category 58.25% 76.32% 54.88%
Number of salaries quoted 56 56 43
Lichfield median annual salary £40,000 £37,500 £35,000
Median salary % change year-on-year +6.67% +7.14% +7.69%
10th Percentile £26,000 £22,750 £21,250
90th Percentile £52,500 £50,250 £60,000
Staffordshire median annual salary £37,500 £37,500 £37,375
% change year-on-year - +0.33% +6.79%

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

All Programming Languages
Lichfield
Permanent vacancies with a requirement for coding skills 103 76 82
As % of all permanent IT jobs advertised in Lichfield 69.59% 57.58% 56.94%
Number of salaries quoted 95 74 76
Lichfield median annual salary £40,000 £37,500 £35,000
Median salary % change year-on-year +6.67% +7.14% +7.69%
10th Percentile £26,000 £22,750 £21,250
90th Percentile £52,500 £50,250 £50,000
Staffordshire median annual salary £37,500 £37,500 £35,000
% change year-on-year - +7.14% -

SQL
Job Vacancy Trend in Lichfield

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

Job vacancy trend for SQL in Lichfield

SQL
Salary Trend in Lichfield

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

Salary trend for SQL in Lichfield

SQL
Salary Histogram in Lichfield

The salary distribution of IT jobs citing SQL in Lichfield over the 6 months to 20 November 2017.

Salary histogram for SQL in Lichfield

For the 6 months to 20 November 2017, 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 Lichfield region with a requirement for SQL.

1 45 (75.00%) C#
2 44 (73.33%) .NET
3 35 (58.33%) AngularJS
4 25 (41.67%) ASP.NET
5 24 (40.00%) HTML
5 24 (40.00%) MVC
6 22 (36.67%) jQuery
6 22 (36.67%) PL/SQL
7 20 (33.33%) Classic ASP
8 19 (31.67%) JavaScript
8 19 (31.67%) .NET Framework
8 19 (31.67%) Twitter Bootstrap
8 19 (31.67%) HTML5
8 19 (31.67%) Entity Framework
9 18 (30.00%) Microsoft
10 17 (28.33%) Visual Studio
10 17 (28.33%) VB.NET
11 16 (26.67%) XML
11 16 (26.67%) SharePoint
11 16 (26.67%) Pharmaceutical
12 15 (25.00%) NHS
12 15 (25.00%) CRM
12 15 (25.00%) Microsoft Office
12 15 (25.00%) LINQ
12 15 (25.00%) Dynamics CRM
12 15 (25.00%) SharePoint Server
12 15 (25.00%) Workflow
12 15 (25.00%) KnockoutJS
13 14 (23.33%) Web Development
13 14 (23.33%) Oracle

SQL
Co-occurring IT Skills in Lichfield 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 16 (26.67%) SharePoint
2 15 (25.00%) SharePoint Server
3 3 (5.00%) IIS
4 1 (1.67%) JBoss
4 1 (1.67%) MS Exchange
Applications
1 15 (25.00%) Microsoft Office
Business Applications
1 15 (25.00%) Dynamics CRM
2 2 (3.33%) iTrent
2 2 (3.33%) Unit4 Business World
3 1 (1.67%) Dynamics NAV
Cloud Services
1 3 (5.00%) SaaS
2 2 (3.33%) Office 365
Communications & Networking
1 1 (1.67%) Cisco IOS
1 1 (1.67%) SAN
1 1 (1.67%) SMS
Database & Business Intelligence
1 11 (18.33%) SQL Server
2 5 (8.33%) Relational Database
3 4 (6.67%) QlikView
3 4 (6.67%) SQL Server Reporting Services
4 2 (3.33%) BusinessObjects
4 2 (3.33%) Crystal Reports
4 2 (3.33%) Data Warehouse
4 2 (3.33%) IBM PureData
4 2 (3.33%) Power BI
4 2 (3.33%) SQL Server 2008
4 2 (3.33%) SQL Server Analysis Services
4 2 (3.33%) SQL Server Integration Services
5 1 (1.67%) Big Data
5 1 (1.67%) MySQL
5 1 (1.67%) Oracle Database
5 1 (1.67%) SQL Server 2012
Development Applications
1 17 (28.33%) Visual Studio
2 5 (8.33%) Subversion
3 4 (6.67%) Git (software)
3 4 (6.67%) Jenkins
3 4 (6.67%) JIRA
3 4 (6.67%) MSI
4 2 (3.33%) Talend Open Studio
5 1 (1.67%) Eclipse
General
1 16 (26.67%) Pharmaceutical
Job Titles
1 51 (85.00%) Developer
2 38 (63.33%) .NET Developer
3 29 (48.33%) C# .NET Developer
3 29 (48.33%) C# Developer
4 17 (28.33%) Senior Developer
5 15 (25.00%) Senior .NET Developer
5 15 (25.00%) Senior C# .NET Developer
5 15 (25.00%) Senior C# Developer
6 13 (21.67%) ASP.NET Developer
7 12 (20.00%) C# ASP.NET Developer
8 7 (11.67%) Junior
8 7 (11.67%) Junior Developer
8 7 (11.67%) Software Developer
9 5 (8.33%) SQL Developer
10 4 (6.67%) Analyst
11 3 (5.00%) Junior .NET Developer
11 3 (5.00%) Junior ASP.NET Developer
11 3 (5.00%) Junior C# .NET Developer
11 3 (5.00%) Junior C# Developer
11 3 (5.00%) Systems Engineer
Libraries, Frameworks & Software Standards
1 44 (73.33%) .NET
2 35 (58.33%) AngularJS
3 25 (41.67%) ASP.NET
4 24 (40.00%) HTML
5 22 (36.67%) jQuery
6 20 (33.33%) Classic ASP
7 19 (31.67%) .NET Framework
7 19 (31.67%) Entity Framework
7 19 (31.67%) HTML5
7 19 (31.67%) Twitter Bootstrap
8 16 (26.67%) XML
9 15 (25.00%) KnockoutJS
9 15 (25.00%) LINQ
10 8 (13.33%) ASP.NET Web API
11 5 (8.33%) CSS
12 3 (5.00%) NHibernate
13 2 (3.33%) WCF
13 2 (3.33%) WPF
14 1 (1.67%) JSF
14 1 (1.67%) Symfony
Miscellaneous
1 15 (25.00%) NHS
2 4 (6.67%) Computer Science
2 4 (6.67%) Management Information System
3 3 (5.00%) Analytical Skills
4 1 (1.67%) iPad
Operating Systems
1 6 (10.00%) Windows
2 4 (6.67%) Windows Server
3 3 (5.00%) Windows 10
3 3 (5.00%) Windows 7
3 3 (5.00%) Windows Server 2008
4 2 (3.33%) Windows Mobile
Processes & Methodologies
1 24 (40.00%) MVC
2 15 (25.00%) CRM
2 15 (25.00%) Workflow
3 14 (23.33%) Web Development
4 13 (21.67%) Business Analysis
5 12 (20.00%) Agile Software Development
5 12 (20.00%) Customer Requirements
6 11 (18.33%) Unit Testing
7 9 (15.00%) SDLC
8 7 (11.67%) Continuous Integration
9 6 (10.00%) Analytics
9 6 (10.00%) Business Intelligence
10 5 (8.33%) Test Automation
11 4 (6.67%) Copywriting
12 3 (5.00%) Data Analytics
12 3 (5.00%) Mentoring
12 3 (5.00%) Web Design
13 2 (3.33%) Dimensional Modelling
13 2 (3.33%) Master Data Management
13 2 (3.33%) Performance Analysis
Programming Languages
1 45 (75.00%) C#
2 22 (36.67%) PL/SQL
3 19 (31.67%) JavaScript
4 17 (28.33%) VB.NET
5 2 (3.33%) T-SQL
6 1 (1.67%) Java
6 1 (1.67%) PHP
Qualifications
1 2 (3.33%) SC Cleared
1 2 (3.33%) Security Cleared
2 1 (1.67%) CCENT
2 1 (1.67%) CCNA
2 1 (1.67%) Cisco Certification
2 1 (1.67%) Computer Science Degree
2 1 (1.67%) Degree
2 1 (1.67%) MCP
2 1 (1.67%) MCSA
2 1 (1.67%) MCSE
2 1 (1.67%) Microsoft Certification
Quality Assurance & Compliance
1 13 (21.67%) QA
2 2 (3.33%) Data Quality
3 1 (1.67%) ISO/IEC 20000
System Software
1 4 (6.67%) Active Directory
2 1 (1.67%) Hyper-V
2 1 (1.67%) VMware Infrastructure
Vendors
1 18 (30.00%) Microsoft
2 14 (23.33%) Oracle
3 4 (6.67%) VMware
4 3 (5.00%) HP
5 2 (3.33%) Cognos
5 2 (3.33%) IBM
5 2 (3.33%) Talend
6 1 (1.67%) Cisco
6 1 (1.67%) Zend