Period
to 20 January 2018

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

SQL (Structured Query Language)
Fife > Dunfermline
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 9 2 5
Rank change year-on-year -7 +3 0
Permanent jobs citing SQL 3 11 9
As % of all permanent IT jobs advertised in Dunfermline 11.54% 36.67% 24.32%
As % of the Programming Languages category 20.00% 61.11% 37.50%
Number of salaries quoted 3 10 8
Dunfermline median annual salary £36,000 £37,500 £42,926
Median salary % change year-on-year -4.00% -12.64% -
10th Percentile £31,600 £25,750 £32,350
90th Percentile £51,800 £42,750 £44,688
Fife median annual salary £33,750 £35,000 £35,500
% change year-on-year -3.57% -1.41% -17.30%

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

All Programming Languages
Dunfermline
Permanent vacancies with a requirement for coding skills 15 18 24
As % of all permanent IT jobs advertised in Dunfermline 57.69% 60.00% 64.86%
Number of salaries quoted 11 16 21
Dunfermline median annual salary £45,000 £32,500 £38,000
Median salary % change year-on-year +38.46% -14.47% -9.52%
10th Percentile £32,500 £26,000 £27,750
90th Percentile £62,500 £42,500 £44,688
Fife median annual salary £40,000 £32,500 £35,500
% change year-on-year +23.08% -8.45% +1.43%

SQL
Job Vacancy Trend in Dunfermline

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

Job vacancy trend for SQL in Dunfermline

SQL
Salary Trend in Dunfermline

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

Salary trend for SQL in Dunfermline

SQL
Salary Histogram in Dunfermline

The salary distribution of IT jobs citing SQL in Dunfermline over the 6 months to 20 January 2018.

Salary histogram for SQL in Dunfermline

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

1 3 (100.00%) .NET
1 3 (100.00%) C#
2 2 (66.67%) SDLC
2 2 (66.67%) Software Engineering
2 2 (66.67%) WPF
3 1 (33.33%) MVC
3 1 (33.33%) XAML
3 1 (33.33%) Agile Software Development
3 1 (33.33%) MySQL
3 1 (33.33%) SQL Server
3 1 (33.33%) Visual Studio
3 1 (33.33%) ASP.NET
3 1 (33.33%) Web Services
3 1 (33.33%) Linux
3 1 (33.33%) Python
3 1 (33.33%) Microsoft
3 1 (33.33%) Microsoft Certification
3 1 (33.33%) Unit Testing
3 1 (33.33%) Integration Testing
3 1 (33.33%) Domain-Driven Design
3 1 (33.33%) RESTful
3 1 (33.33%) Amazon AWS
3 1 (33.33%) ASP.NET MVC
3 1 (33.33%) Entity Framework
3 1 (33.33%) CQRS
3 1 (33.33%) ASP.NET Web API
3 1 (33.33%) Mobile Development
3 1 (33.33%) .NET Framework
3 1 (33.33%) Degree
3 1 (33.33%) JSON

SQL
Co-occurring IT Skills in Dunfermline 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:

Cloud Services
1 1 (33.33%) Amazon AWS
Database & Business Intelligence
1 1 (33.33%) MySQL
1 1 (33.33%) SQL Server
Development Applications
1 1 (33.33%) Visual Studio
Job Titles
1 2 (66.67%) Developer
2 1 (33.33%) .NET Developer
2 1 (33.33%) ASP.NET Developer
2 1 (33.33%) C# Developer
2 1 (33.33%) C# Software Developer
2 1 (33.33%) Senior C# Developer
2 1 (33.33%) Senior C# Software Developer
2 1 (33.33%) Senior Developer
2 1 (33.33%) Senior Software Developer
2 1 (33.33%) Software Developer
2 1 (33.33%) Software Engineer
2 1 (33.33%) SQL Developer
2 1 (33.33%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 3 (100.00%) .NET
2 2 (66.67%) WPF
3 1 (33.33%) .NET Framework
3 1 (33.33%) ASP.NET
3 1 (33.33%) ASP.NET MVC
3 1 (33.33%) ASP.NET Web API
3 1 (33.33%) Entity Framework
3 1 (33.33%) JSON
3 1 (33.33%) RESTful
3 1 (33.33%) Web Services
Miscellaneous
1 1 (33.33%) Computer Science
Operating Systems
1 1 (33.33%) Linux
Processes & Methodologies
1 2 (66.67%) SDLC
1 2 (66.67%) Software Engineering
2 1 (33.33%) Agile Software Development
2 1 (33.33%) CQRS
2 1 (33.33%) Domain-Driven Design
2 1 (33.33%) Integration Testing
2 1 (33.33%) Mobile Development
2 1 (33.33%) MVC
2 1 (33.33%) Unit Testing
Programming Languages
1 3 (100.00%) C#
2 1 (33.33%) C
2 1 (33.33%) C++
2 1 (33.33%) Python
2 1 (33.33%) T-SQL
2 1 (33.33%) XAML
Qualifications
1 1 (33.33%) Computer Science Degree
1 1 (33.33%) Degree
1 1 (33.33%) Microsoft Certification
Vendors
1 1 (33.33%) Microsoft