Period
to 22 July 2017

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

SQL (Structured Query Language)
Fife > Dunfermline
6 months to
22 Jul 2017
Same period 2016 Same period 2015
Rank 1 8 4
Rank change year-on-year +7 -4 +7
Permanent jobs citing SQL 9 6 10
As % of all permanent IT jobs advertised in Dunfermline 37.50% 15.00% 19.61%
As % of the Programming Languages category 52.94% 26.09% 34.48%
Number of salaries quoted 8 6 10
Dunfermline median annual salary £40,000 £33,500 £42,926
Median salary % change year-on-year +19.40% -21.96% +1.00%
10th Percentile £32,500 £21,000 £32,000
90th Percentile £47,500 £40,625 £44,688
Fife median annual salary £39,137 £29,500 £42,926
% change year-on-year +32.67% -31.28% +22.64%

SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Dunfermline with a requirement for programming language skills.

Programming Language Skills
Dunfermline
Permanent job vacancies with a requirement for programming language skills 17 23 29
As % of all permanent IT job vacancies advertised in Dunfermline 70.83% 57.50% 56.86%
Number of salaries quoted 14 14 28
Dunfermline median annual salary £39,569 £36,250 £36,750
Median salary % change year-on-year +9.15% -1.36% -8.13%
10th Percentile £28,625 £23,400 £27,550
90th Percentile £47,050 £50,500 £44,688
Fife median annual salary £39,137 £33,500 £39,000
% change year-on-year +16.83% -14.10% -2.50%

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

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

1 6 (66.67%) .NET
1 6 (66.67%) C#
2 3 (33.33%) XAML
2 3 (33.33%) C++
2 3 (33.33%) HTML
2 3 (33.33%) JavaScript
2 3 (33.33%) PL/SQL
2 3 (33.33%) Oracle
2 3 (33.33%) Visual Studio
2 3 (33.33%) CSS
2 3 (33.33%) Linux
2 3 (33.33%) Python
2 3 (33.33%) SharePoint
2 3 (33.33%) Business Intelligence
2 3 (33.33%) Microsoft
2 3 (33.33%) Software Engineering
2 3 (33.33%) WPF
2 3 (33.33%) Data Integration
2 3 (33.33%) RESTful
2 3 (33.33%) Office 365
2 3 (33.33%) C
3 1 (11.11%) Test Automation
3 1 (11.11%) QA
3 1 (11.11%) QA Automation

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:

Application Platforms
1 3 (33.33%) SharePoint
Cloud Services
1 3 (33.33%) Office 365
Development Applications
1 3 (33.33%) Visual Studio
Job Titles
1 6 (66.67%) Developer
2 3 (33.33%) Applications Developer
2 3 (33.33%) Oracle Developer
3 2 (22.22%) PL/SQL Developer
3 2 (22.22%) Software Engineer
3 2 (22.22%) SQL Developer
4 1 (11.11%) C# Software Engineer
4 1 (11.11%) C++ Software Engineer
4 1 (11.11%) QA Automation Engineer
4 1 (11.11%) QA Engineer
4 1 (11.11%) QA Test Engineer
4 1 (11.11%) Systems Test Engineer
4 1 (11.11%) Test Automation Engineer
4 1 (11.11%) Test Engineer
Libraries, Frameworks & Software Standards
1 6 (66.67%) .NET
2 3 (33.33%) CSS
2 3 (33.33%) HTML
2 3 (33.33%) RESTful
2 3 (33.33%) WPF
Operating Systems
1 3 (33.33%) Linux
Processes & Methodologies
1 3 (33.33%) Business Intelligence
1 3 (33.33%) Data Integration
1 3 (33.33%) Software Engineering
2 1 (11.11%) QA Automation
2 1 (11.11%) Test Automation
Programming Languages
1 6 (66.67%) C#
2 3 (33.33%) C
2 3 (33.33%) C++
2 3 (33.33%) JavaScript
2 3 (33.33%) PL/SQL
2 3 (33.33%) Python
2 3 (33.33%) XAML
Quality Assurance & Compliance
1 1 (11.11%) QA
Vendors
1 3 (33.33%) Microsoft
1 3 (33.33%) Oracle
Dunfermline
Hays IT - Uk Posting account
Salary: £39137.00 per annum
Posted: 12 days ago