Period
to 18 December 2017

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

SQL (Structured Query Language)
Scotland > Edinburgh
6 months to
18 Dec 2017
Same period 2016 Same period 2015
Rank 3 5 6
Rank change year-on-year +2 +1 -1
Permanent jobs citing SQL 658 379 489
As % of all permanent IT jobs advertised in Edinburgh 24.94% 16.77% 16.30%
As % of the Programming Languages category 42.07% 32.06% 38.78%
Number of salaries quoted 365 272 361
Edinburgh median annual salary £40,000 £43,250 £42,000
Median salary % change year-on-year -7.51% +2.98% +5.00%
10th Percentile £26,708 £28,075 £27,500
90th Percentile £60,000 £60,000 £59,750
Scotland median annual salary £40,000 £40,000 £40,000

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

All Programming Languages
Edinburgh
Permanent vacancies with a requirement for coding skills 1564 1182 1261
As % of all permanent IT jobs advertised in Edinburgh 59.29% 52.30% 42.03%
Number of salaries quoted 1010 823 849
Edinburgh median annual salary £41,000 £45,000 £41,500
Median salary % change year-on-year -8.89% +8.43% +3.75%
10th Percentile £28,000 £29,750 £26,500
90th Percentile £61,250 £60,000 £58,550
Scotland median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

SQL
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for SQL in Edinburgh

SQL
Salary Trend in Edinburgh

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

Salary trend for SQL in Edinburgh

SQL
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing SQL in Edinburgh over the 6 months to 18 December 2017.

Salary histogram for SQL in Edinburgh

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

1 258 (39.21%) Finance
2 183 (27.81%) Business Intelligence
3 178 (27.05%) Oracle
4 160 (24.32%) SQL Server
4 160 (24.32%) Banking
5 149 (22.64%) C#
6 148 (22.49%) .NET
7 146 (22.19%) Agile Software Development
8 130 (19.76%) Java
9 127 (19.30%) Infrastructure Management
10 124 (18.84%) SAS
11 115 (17.48%) Microsoft
11 115 (17.48%) Stakeholder Management
12 113 (17.17%) Analytical Skills
13 103 (15.65%) HTML
13 103 (15.65%) Data Management
14 98 (14.89%) JavaScript
15 96 (14.59%) Analytics
16 89 (13.53%) Degree
17 85 (12.92%) CSS
18 82 (12.46%) Windows
19 78 (11.85%) Retail Banking
20 77 (11.70%) Software Engineering
21 76 (11.55%) PL/SQL
22 75 (11.40%) Teradata
23 72 (10.94%) Mentoring
24 63 (9.57%) ETL
25 62 (9.42%) Python
25 62 (9.42%) Microsoft Azure
26 57 (8.66%) Relational Database

SQL
Co-occurring IT Skills in Edinburgh 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 124 (18.84%) SAS
2 25 (3.80%) IIS
3 21 (3.19%) JBoss
4 20 (3.04%) Apache
4 20 (3.04%) SharePoint
5 16 (2.43%) Tomcat
6 10 (1.52%) WebLogic
7 9 (1.37%) Apache Spark
8 8 (1.22%) MS Exchange
9 7 (1.06%) Confluence
9 7 (1.06%) WebSphere
10 6 (0.91%) Exchange Server 2010
10 6 (0.91%) WebLogic Portal
11 4 (0.61%) Umbraco
12 3 (0.46%) BizTalk Server
12 3 (0.46%) Blackberry Enterprise Server
12 3 (0.46%) Oracle SOA Suite
12 3 (0.46%) SharePoint 2010
12 3 (0.46%) Skype for Business
13 2 (0.30%) SharePoint 2013
Applications
1 13 (1.98%) Microsoft Excel
2 9 (1.37%) Microsoft Office
3 6 (0.91%) InfoPath
4 2 (0.30%) Microsoft PowerPoint
5 1 (0.15%) Mingle
5 1 (0.15%) MS Visio
5 1 (0.15%) SPSS
Business Applications
1 7 (1.06%) Cognos Business Intelligence
2 6 (0.91%) Dynamics CRM
2 6 (0.91%) Oracle EBS R12
2 6 (0.91%) Oracle Financials
2 6 (0.91%) Oracle Procure-to-Pay
2 6 (0.91%) SAP GRC
3 2 (0.30%) Dynamics AX
4 1 (0.15%) Actimize
4 1 (0.15%) FastStats
4 1 (0.15%) NetSuite
Cloud Services
1 62 (9.42%) Microsoft Azure
2 19 (2.89%) Amazon AWS
3 14 (2.13%) Azure Active Directory
3 14 (2.13%) Cloud Computing
3 14 (2.13%) npm
4 7 (1.06%) GitHub
4 7 (1.06%) Office 365
5 6 (0.91%) Google Cloud Platform
5 6 (0.91%) SaaS
6 2 (0.30%) Amazon EMR
6 2 (0.30%) Google Analytics
6 2 (0.30%) Oracle Service Cloud
7 1 (0.15%) Azure Machine Learning
7 1 (0.15%) Dynamics 365
7 1 (0.15%) Slack
Communications & Networking
1 12 (1.82%) Firewall
2 10 (1.52%) DHCP
2 10 (1.52%) DNS
2 10 (1.52%) SAN
3 7 (1.06%) SMS
4 5 (0.76%) GPRS
5 4 (0.61%) Internet
5 4 (0.61%) LAN
5 4 (0.61%) TCP/IP
5 4 (0.61%) WAN
6 2 (0.30%) Network Security
6 2 (0.30%) VPN
6 2 (0.30%) Wi-Fi
7 1 (0.15%) ATM
7 1 (0.15%) OSPF
7 1 (0.15%) SSH
7 1 (0.15%) SSL
7 1 (0.15%) VLAN
7 1 (0.15%) Wireless
7 1 (0.15%) WLAN
Database & Business Intelligence
1 160 (24.32%) SQL Server
2 57 (8.66%) Relational Database
3 56 (8.51%) Oracle Database
4 55 (8.36%) Data Warehouse
5 49 (7.45%) Big Data
6 48 (7.29%) Data Mining
7 47 (7.14%) SQL Server Integration Services
8 45 (6.84%) Base SAS
9 44 (6.69%) SQL Server Reporting Services
10 42 (6.38%) SAS Enterprise Guide
11 33 (5.02%) SAS Data Integration Studio
12 31 (4.71%) Oracle Database 11g
12 31 (4.71%) SAS Visual Analytics
13 30 (4.56%) PostgreSQL
14 28 (4.26%) GIS
15 25 (3.80%) Amazon Redshift
15 25 (3.80%) QlikView
16 22 (3.34%) Oracle Database 10g
17 18 (2.74%) Oracle OWB
17 18 (2.74%) RDBMS
Development Applications
1 55 (8.36%) Git (software)
2 29 (4.41%) Selenium
3 27 (4.10%) ProC
4 21 (3.19%) Oracle APEX
5 20 (3.04%) Visual Studio
6 19 (2.89%) JUnit
7 17 (2.58%) Protractor
8 16 (2.43%) NetBeans
8 16 (2.43%) Subversion
9 14 (2.13%) Grunt
9 14 (2.13%) gulp
9 14 (2.13%) Jasmine
10 13 (1.98%) JIRA
10 13 (1.98%) TestNG
11 11 (1.67%) Jenkins
11 11 (1.67%) Maven
12 10 (1.52%) Oracle Forms
13 9 (1.37%) Cucumber
13 9 (1.37%) LoadRunner
13 9 (1.37%) Log4j
General
1 258 (39.21%) Finance
2 160 (24.32%) Banking
3 78 (11.85%) Retail Banking
4 11 (1.67%) Military
5 8 (1.22%) Marketing
6 7 (1.06%) Financial Institution
6 7 (1.06%) Legal
7 6 (0.91%) Advertising
7 6 (0.91%) Investment Banking
7 6 (0.91%) Telecoms
8 5 (0.76%) Retail
9 3 (0.46%) Automotive
9 3 (0.46%) Games
10 2 (0.30%) Dutch Language
10 2 (0.30%) French Language
10 2 (0.30%) German Language
10 2 (0.30%) Law
10 2 (0.30%) Spanish Language
11 1 (0.15%) Arabic Language
11 1 (0.15%) Multimedia
Job Titles
1 198 (30.09%) Developer
2 138 (20.97%) Analyst
3 97 (14.74%) Consultant
4 64 (9.73%) Data Analyst
5 62 (9.42%) SQL Analyst
6 48 (7.29%) Software Engineer
7 44 (6.69%) Senior Analyst
8 40 (6.08%) SAS Consultant
9 37 (5.62%) Oracle Developer
10 34 (5.17%) .NET Developer
10 34 (5.17%) Business Analyst
10 34 (5.17%) SQL Developer
11 32 (4.86%) Infrastructure Engineer
12 31 (4.71%) C# Developer
12 31 (4.71%) DBA
12 31 (4.71%) SQL Data Analyst
13 30 (4.56%) Technical Analyst
13 30 (4.56%) Technical Business Analyst
14 27 (4.10%) Data Scientist
14 27 (4.10%) Senior Developer
Libraries, Frameworks & Software Standards
1 148 (22.49%) .NET
2 103 (15.65%) HTML
3 85 (12.92%) CSS
4 46 (6.99%) RESTful
5 43 (6.53%) Web Services
6 39 (5.93%) ASP.NET
7 31 (4.71%) AngularJS
8 28 (4.26%) SOAP
8 28 (4.26%) XML
9 27 (4.10%) Swing
10 26 (3.95%) HTML5
11 22 (3.34%) Spring
12 20 (3.04%) Hibernate
13 17 (2.58%) WPF
14 16 (2.43%) Java EE
14 16 (2.43%) Node.js
15 15 (2.28%) JSP
16 12 (1.82%) ASP.NET MVC
17 11 (1.67%) Angular 2
17 11 (1.67%) jQuery
Miscellaneous
1 113 (17.17%) Analytical Skills
2 25 (3.80%) Algorithms
3 24 (3.65%) Computer Science
4 19 (2.89%) Mobile App
5 18 (2.74%) Enterprise Software
6 16 (2.43%) Robotics
7 14 (2.13%) EMC VNX
7 14 (2.13%) Virtual Team
8 12 (1.82%) Credit Risk
9 10 (1.52%) User Experience
10 8 (1.22%) Data Centre
11 7 (1.06%) Fintech
12 6 (0.91%) Greenfield Project
13 4 (0.61%) Data Structures
13 4 (0.61%) Replication
14 3 (0.46%) Blackberry
14 3 (0.46%) Clustering
14 3 (0.46%) Management Information System
15 2 (0.30%) Mainframe
15 2 (0.30%) Smart Meter
Operating Systems
1 82 (12.46%) Windows
2 40 (6.08%) Unix
3 32 (4.86%) Linux
4 31 (4.71%) Windows Server
5 16 (2.43%) Windows Server 2008
6 15 (2.28%) Windows Server 2012
7 11 (1.67%) Windows Server 2003
8 8 (1.22%) Mac OS
9 6 (0.91%) Apple iOS
10 3 (0.46%) Red Hat Enterprise Linux
10 3 (0.46%) Ubuntu
10 3 (0.46%) Windows 7
11 2 (0.30%) Android
11 2 (0.30%) Windows 2000
11 2 (0.30%) Windows Vista
11 2 (0.30%) Windows XP
Processes & Methodologies
1 183 (27.81%) Business Intelligence
2 146 (22.19%) Agile Software Development
3 127 (19.30%) Infrastructure Management
4 115 (17.48%) Stakeholder Management
5 103 (15.65%) Data Management
6 96 (14.59%) Analytics
7 77 (11.70%) Software Engineering
8 72 (10.94%) Mentoring
9 63 (9.57%) ETL
10 56 (8.51%) Data Analysis
11 53 (8.05%) People Management
12 52 (7.90%) Software Testing
13 49 (7.45%) MVC
14 48 (7.29%) Test Automation
15 47 (7.14%) TDD
16 46 (6.99%) SDLC
17 38 (5.78%) ITIL
18 34 (5.17%) Visualisation
19 32 (4.86%) Innovative Thinking
20 31 (4.71%) Machine Learning
Programming Languages
1 149 (22.64%) C#
2 130 (19.76%) Java
3 98 (14.89%) JavaScript
4 76 (11.55%) PL/SQL
5 62 (9.42%) Python
6 45 (6.84%) T-SQL
7 41 (6.23%) PowerShell
8 27 (4.10%) PROC SQL
8 27 (4.10%) SAS Macro
9 26 (3.95%) C++
10 18 (2.74%) Shell Script
11 17 (2.58%) R
12 14 (2.13%) VB
13 13 (1.98%) TypeScript
14 10 (1.52%) PHP
15 9 (1.37%) Perl
15 9 (1.37%) VBA
16 8 (1.22%) Scala
16 8 (1.22%) VB.NET
17 6 (0.91%) C
Qualifications
1 89 (13.53%) Degree
2 30 (4.56%) Numerate Degree
3 17 (2.58%) Microsoft Certification
4 12 (1.82%) Security Cleared
5 10 (1.52%) ISTQB
6 8 (1.22%) Computer Science Degree
7 7 (1.06%) MCDBA
7 7 (1.06%) MCITP
8 6 (0.91%) Oracle Certification
9 5 (0.76%) MCP
9 5 (0.76%) OCP
9 5 (0.76%) PhD
9 5 (0.76%) SAP Certification
10 4 (0.61%) ISEB
10 4 (0.61%) MCSE
10 4 (0.61%) Postgraduate
11 3 (0.46%) AWS Certification
11 3 (0.46%) HND
12 2 (0.30%) BPSS Clearance
12 2 (0.30%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 13 (1.98%) QA
2 9 (1.37%) SLA
3 3 (0.46%) Data Quality
3 3 (0.46%) ISO/IEC 27001
4 1 (0.15%) GDPR
4 1 (0.15%) IFRS
4 1 (0.15%) IFRS 9
System Software
1 34 (5.17%) Active Directory
2 21 (3.19%) VMware Infrastructure
3 19 (2.89%) vSphere
4 16 (2.43%) Hyper-V
5 7 (1.06%) Docker
6 6 (0.91%) VMware ESXi
7 5 (0.76%) Oracle RAC
8 4 (0.61%) Microsoft App-V
9 3 (0.46%) XenApp
9 3 (0.46%) XenDesktop
Systems Management
1 19 (2.89%) Opscode Chef
2 18 (2.74%) SCCM
3 15 (2.28%) SCOM
4 7 (1.06%) Ansible
5 5 (0.76%) Oracle RMAN
5 5 (0.76%) Puppet
6 4 (0.61%) Data Guard
6 4 (0.61%) Perfmon
7 3 (0.46%) HockeyApp
7 3 (0.46%) Nagios
7 3 (0.46%) Rancher
7 3 (0.46%) Symantec Endpoint Protection
7 3 (0.46%) Symantec Enterprise Vault
7 3 (0.46%) Terraform
8 2 (0.30%) Business Desktop Deployment
8 2 (0.30%) Systems Management Server (SMS)
9 1 (0.15%) Ambari
9 1 (0.15%) Failover Clustering
Vendors
1 178 (27.05%) Oracle
2 115 (17.48%) Microsoft
3 75 (11.40%) Teradata
4 37 (5.62%) Informatica
4 37 (5.62%) VMware
5 35 (5.32%) Cognos
5 35 (5.32%) MicroStrategy
6 26 (3.95%) Tableau
7 25 (3.80%) HP
8 23 (3.50%) Cisco
9 16 (2.43%) SAP
10 14 (2.13%) EMC
11 9 (1.37%) IBM
12 8 (1.22%) Google
13 7 (1.06%) Misys
14 5 (0.76%) Cognizant
14 5 (0.76%) Remedy
14 5 (0.76%) Twitter
15 4 (0.61%) CA
15 4 (0.61%) Perforce