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

SQL (Structured Query Language)
Fife / Dunfermline
3 months to
22 Apr 2017
Same period 2016 Same period 2015
Rank 3 7 6
Rank change year-on-year +4 -1  
Permanent jobs citing SQL 2 3 6
As % of all permanent IT jobs advertised in Dunfermline 22.22% 17.65% 19.35%
As % of the Programming Languages category 100.00% 25.00% 50.00%
Number of salaries quoted 2 3 6
Median salary £44,000 £33,500 £42,926
Median salary % change year-on-year +31.34% -21.95%  
UK excluding London median salary £40,000 £40,000 £40,000

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 2 12 12
As % of all permanent IT job vacancies advertised in Dunfermline 22.22% 70.59% 38.71%
Number of salaries quoted 2 6 12
Median salary £44,000 £33,500 £37,500
Median salary % change year-on-year +31.34% -10.66%  
UK excluding London median salary £41,500 £41,000 £40,000
% change year-on-year +1.21% +2.50%  

SQL
Job Vacancy Trend in Dunfermline

The job posting trend of jobs advertised in Dunfermline citing SQL as a proportion of all permanent or contract IT jobs with a match in the Programming Languages category.

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 April 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 (46.15%) HTML
1 6 (46.15%) JavaScript
1 6 (46.15%) Microsoft Office
1 6 (46.15%) CSS
1 6 (46.15%) Linux
2 5 (38.46%) Automated Testing
3 4 (30.77%) Software Engineering
3 4 (30.77%) Banking
3 4 (30.77%) JSF
3 4 (30.77%) ISTQB
3 4 (30.77%) Manual Testing
3 4 (30.77%) ISEB
3 4 (30.77%) MVC
3 4 (30.77%) Finance
3 4 (30.77%) TCP/IP
3 4 (30.77%) Java
4 3 (23.08%) C#
4 3 (23.08%) .NET
4 3 (23.08%) J2EE
4 3 (23.08%) Hibernate
4 3 (23.08%) Microsoft
5 2 (15.38%) Windows
5 2 (15.38%) Electronics
5 2 (15.38%) Configuration Management
5 2 (15.38%) Business Intelligence
5 2 (15.38%) RDBMS
5 2 (15.38%) SharePoint
5 2 (15.38%) Office 365
5 2 (15.38%) Relational Database
5 2 (15.38%) SDLC

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 2 (15.38%) SharePoint
Applications
1 6 (46.15%) Microsoft Office
Business Applications
1 1 (7.69%) Dynamics NAV
Cloud Services
1 2 (15.38%) Office 365
Communications & Networking
1 4 (30.77%) TCP/IP
Database & Business Intelligence
1 2 (15.38%) RDBMS
1 2 (15.38%) Relational Database
2 1 (7.69%) SQL Server
General
1 4 (30.77%) Banking
1 4 (30.77%) Finance
2 2 (15.38%) Electronics
Job Titles
1 5 (38.46%) Developer
2 4 (30.77%) Analyst
2 4 (30.77%) Software Analyst
2 4 (30.77%) Software Test Analyst
2 4 (30.77%) Test Analyst
3 2 (15.38%) Applications Developer
3 2 (15.38%) Java Developer
3 2 (15.38%) Java Engineer
3 2 (15.38%) Java Software Engineer
3 2 (15.38%) Software Engineer
3 2 (15.38%) Software Tester
3 2 (15.38%) Tester
4 1 (7.69%) Development Engineer
4 1 (7.69%) DevOps Engineer
4 1 (7.69%) Dynamics NAV Developer
4 1 (7.69%) Operations Engineer
4 1 (7.69%) Process Engineer
4 1 (7.69%) Senior Java Engineer
4 1 (7.69%) Senior Java Software Engineer
4 1 (7.69%) Senior Software Engineer
Libraries, Frameworks & Software Standards
1 6 (46.15%) CSS
1 6 (46.15%) HTML
2 4 (30.77%) JSF
3 3 (23.08%) .NET
3 3 (23.08%) Hibernate
3 3 (23.08%) J2EE
4 1 (7.69%) Java EE
4 1 (7.69%) JPA
4 1 (7.69%) Servlets
Miscellaneous
1 1 (7.69%) Analytical Skills
Operating Systems
1 6 (46.15%) Linux
2 2 (15.38%) Windows
Processes & Methodologies
1 5 (38.46%) Automated Testing
2 4 (30.77%) Manual Testing
2 4 (30.77%) MVC
2 4 (30.77%) Software Engineering
3 2 (15.38%) Business Intelligence
3 2 (15.38%) Configuration Management
3 2 (15.38%) Mathematics
3 2 (15.38%) Physics
3 2 (15.38%) SDLC
3 2 (15.38%) Software Testing
4 1 (7.69%) Agile Software Development
4 1 (7.69%) DevOps
4 1 (7.69%) ERP
4 1 (7.69%) Image Processing
4 1 (7.69%) OO
4 1 (7.69%) Performance Testing
4 1 (7.69%) Project Planning
4 1 (7.69%) SOA
Programming Languages
1 6 (46.15%) JavaScript
2 4 (30.77%) Java
3 3 (23.08%) C#
4 1 (7.69%) C
Qualifications
1 4 (30.77%) ISEB
1 4 (30.77%) ISTQB
2 2 (15.38%) Degree
Vendors
1 3 (23.08%) Microsoft
Dunfermline, Fife
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £48000.00 per annum
Posted: 3 days ago