Period
to 17 October 2018

The following table provides summary statistics for contract job vacancies advertised in Scotland with a requirement for SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL over the 6 months to 17 October 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

SQL (Structured Query Language)
UK > Scotland
6 months to
17 Oct 2018
Same period 2017 Same period 2016
Rank 6 6 6
Rank change year-on-year 0 0 -1
Contract jobs citing SQL 811 712 731
As % of all contract IT jobs advertised in Scotland 15.13% 14.67% 14.87%
As % of the Programming Languages category 37.24% 36.38% 38.39%
Number of daily rates quoted 457 394 492
Scotland median daily rate £400 £388 £350
Median daily rate % change year-on-year +3.23% +10.71% -
10th Percentile £256 £300 £260
90th Percentile £538 £530 £475
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% +3.23%
Number of hourly rates quoted 11 14 21
Scotland median hourly rate £17.00 £27.00 £36.00
Median hourly rate % change year-on-year -37.04% -25.00% +20.00%
10th Percentile £10.75 £16.50 £18.50
90th Percentile £35.00 £195.00 £45.75
UK median hourly rate £25.00 £27.08 £29.00
% change year-on-year -7.68% -6.62% +8.41%

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Contract vacancies with a requirement for coding skills 2,178 1,957 1,904
As % of all contract IT jobs advertised in Scotland 40.63% 40.32% 38.72%
Number of daily rates quoted 1,244 1,157 1,131
Scotland median daily rate £400 £388 £350
Median daily rate % change year-on-year +3.23% +10.71% -
10th Percentile £294 £281 £263
90th Percentile £538 £525 £475
UK median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 21 25 38
Scotland median hourly rate £30.00 £35.00 £40.00
Median hourly rate % change year-on-year -14.29% -12.50% +23.36%
10th Percentile £10.75 £15.68 £22.35
90th Percentile £44.27 £195.00 £45.40
UK median hourly rate £42.00 £40.00 £37.50
% change year-on-year +5.00% +6.67% +2.74%

SQL
Job Vacancy Trend in Scotland

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

Job vacancy trend for SQL in Scotland

SQL
Contractor Daily Rate Trend in Scotland

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL in Scotland.

Contractor daily rate trend for SQL in Scotland

SQL
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing SQL in Scotland over the 6 months to 17 October 2018.

Contractor daily rate histogram for SQL in Scotland

SQL
Contractor Hourly Rate Trend in Scotland

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL in Scotland.

Contractor hourly rate trend for SQL in Scotland

SQL
Contractor Hourly Rate Histogram in Scotland

The hourly rate distribution of IT jobs citing SQL in Scotland over the 6 months to 17 October 2018.

Contractor hourly rate histogram for SQL in Scotland

SQL
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL within the Scotland region over the 6 months to 17 October 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh 0 369 £400 +3.23% 87
Glasgow 0 321 £400 +6.67% 89
Renfrewshire -2 47 £285 -29.80% 1
West Lothian +19 26 £265 -15.87% 8
Aberdeen +10 6 £550 +29.41% 7
Dundee -8 5 £310 -22.50% 3
Midlothian - 5 - - 3
Stirling -5 3 £388 -3.13% 3
Highlands - 3 - -
North Lanarkshire 0 2 - -
South Lanarkshire -5 2 £156 - 3
Fife +1 1 - - 4
East Lothian - 1 - -
SQL
UK

For the 6 months to 17 October 2018, IT contractor jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Scotland region with a requirement for SQL.

1 314 (38.72%) Agile Software Development
2 240 (29.59%) Oracle
3 233 (28.73%) Finance
4 216 (26.63%) SQL Server
5 208 (25.65%) Java
6 158 (19.48%) C#
7 139 (17.14%) .NET
8 136 (16.77%) Microsoft
9 128 (15.78%) JavaScript
10 127 (15.66%) Relational Database
11 121 (14.92%) Linux
12 112 (13.81%) Windows
13 104 (12.82%) HTML
14 103 (12.70%) Test Automation
15 99 (12.21%) Python
16 95 (11.71%) ETL
17 87 (10.73%) Banking
18 84 (10.36%) Unix
18 84 (10.36%) PL/SQL
19 79 (9.74%) CSS
19 79 (9.74%) Oracle Database
20 77 (9.49%) AngularJS
21 76 (9.37%) Git (software)
21 76 (9.37%) Scrum
21 76 (9.37%) Spring
22 75 (9.25%) Continuous Integration
23 74 (9.12%) SOAP
24 73 (9.00%) Analytical Skills
25 72 (8.88%) Jenkins
26 71 (8.75%) DevOps

SQL
Co-occurring IT Skills in Scotland 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 51 (6.29%) SAS
2 28 (3.45%) Apache
3 24 (2.96%) SharePoint
4 22 (2.71%) Tomcat
5 20 (2.47%) Confluence
6 17 (2.10%) WebSphere
7 13 (1.60%) JBoss
8 11 (1.36%) SharePoint 2013
9 9 (1.11%) Apache Spark
10 5 (0.62%) GlassFish
11 4 (0.49%) Apache Pig
11 4 (0.49%) CICS
11 4 (0.49%) Skype for Business
12 3 (0.37%) CMS
12 3 (0.37%) Elasticsearch
12 3 (0.37%) MQSeries
12 3 (0.37%) MS Exchange
12 3 (0.37%) Mule ESB
12 3 (0.37%) Oracle SOA Suite
12 3 (0.37%) Oracle Workflow
Applications
1 53 (6.54%) Microsoft Excel
2 25 (3.08%) Microsoft Office
3 15 (1.85%) Microsoft PowerPoint
4 6 (0.74%) MS Visio
5 4 (0.49%) Spreadsheet
6 3 (0.37%) Chatbot
6 3 (0.37%) Microsoft Project
7 1 (0.12%) 3ds Max
7 1 (0.12%) Adobe Illustrator
7 1 (0.12%) Maya
7 1 (0.12%) Photoshop
Business Applications
1 10 (1.23%) Dynamics CRM
2 9 (1.11%) Markit EDM
3 4 (0.49%) WebTrends
4 3 (0.37%) SessionCam
4 3 (0.37%) thinkFolio
5 2 (0.25%) Actimize
5 2 (0.25%) Dynamics AX
5 2 (0.25%) Maximo
5 2 (0.25%) Oracle Applications
5 2 (0.25%) Sage 200
5 2 (0.25%) Sonata
6 1 (0.12%) Cognos Business Intelligence
6 1 (0.12%) Cognos TM1
6 1 (0.12%) Dynamics NAV
6 1 (0.12%) Oracle BPM
6 1 (0.12%) Oracle Cash Management
6 1 (0.12%) Sage 300 ERP
6 1 (0.12%) Sage CRM
Cloud Services
1 59 (7.27%) Office 365
2 57 (7.03%) Microsoft Azure
3 44 (5.43%) Amazon AWS
4 18 (2.22%) GitHub
5 15 (1.85%) Dynamics 365
6 11 (1.36%) PaaS
7 10 (1.23%) Azure Data Factory
7 10 (1.23%) SaaS
8 7 (0.86%) Google Analytics
8 7 (0.86%) npm
9 6 (0.74%) Google Tag Manager
9 6 (0.74%) Yarn
10 5 (0.62%) Amazon EC2
10 5 (0.62%) Amazon S3
10 5 (0.62%) Cloud Computing
10 5 (0.62%) Google Cloud Platform
11 4 (0.49%) NuGet
12 3 (0.37%) AdWords
12 3 (0.37%) Amazon EMR
13 2 (0.25%) Mailgun
Communications & Networking
1 44 (5.43%) DNS
2 42 (5.18%) DHCP
3 10 (1.23%) Firewall
4 9 (1.11%) HTTP
4 9 (1.11%) SAN
5 8 (0.99%) TCP/IP
6 6 (0.74%) SSL
7 5 (0.62%) AMQP
7 5 (0.62%) FTP
7 5 (0.62%) NAS
7 5 (0.62%) VPN
8 4 (0.49%) VLAN
8 4 (0.49%) Wireless
9 3 (0.37%) HTTPS
9 3 (0.37%) Internet
9 3 (0.37%) Kerberos
9 3 (0.37%) SSH
10 2 (0.25%) BIG-IP
10 2 (0.25%) NetScaler
10 2 (0.25%) WEP
Database & Business Intelligence
1 216 (26.63%) SQL Server
2 127 (15.66%) Relational Database
3 79 (9.74%) Oracle Database
4 70 (8.63%) MongoDB
5 66 (8.14%) NoSQL
6 55 (6.78%) Data Warehouse
7 51 (6.29%) Hadoop
8 50 (6.17%) RDBMS
9 47 (5.80%) MySQL
10 45 (5.55%) Oracle Database 12c
11 43 (5.30%) DB2
12 40 (4.93%) SQL Server Reporting Services
13 32 (3.95%) Big Data
13 32 (3.95%) SQL Server Integration Services
14 30 (3.70%) PostgreSQL
15 27 (3.33%) Power BI
16 24 (2.96%) BusinessObjects
17 17 (2.10%) Data Lake
18 16 (1.97%) MS Access
18 16 (1.97%) Neo4j
Development Applications
1 76 (9.37%) Git (software)
2 72 (8.88%) Jenkins
3 49 (6.04%) JIRA
4 40 (4.93%) Oracle Forms
5 38 (4.69%) Team Foundation Server
6 37 (4.56%) Selenium
7 35 (4.32%) JUnit
8 32 (3.95%) Visual Studio
9 31 (3.82%) HP UFT
10 30 (3.70%) Maven
11 27 (3.33%) WinRunner
12 23 (2.84%) Cucumber
13 21 (2.59%) TeamCity
14 16 (1.97%) NUnit
15 15 (1.85%) JMeter
16 14 (1.73%) Bitbucket
16 14 (1.73%) SpecFlow
17 11 (1.36%) FitNesse
17 11 (1.36%) Gradle
17 11 (1.36%) Subversion
General
1 233 (28.73%) Finance
2 87 (10.73%) Banking
3 22 (2.71%) Retail
4 16 (1.97%) Manufacturing
5 14 (1.73%) Investment Banking
6 11 (1.36%) Retail Banking
7 10 (1.23%) Legal
7 10 (1.23%) Marketing
8 8 (0.99%) Financial Institution
9 7 (0.86%) Advertising
10 6 (0.74%) Telecoms
11 5 (0.62%) Billing
11 5 (0.62%) Front Office
11 5 (0.62%) Pharmaceutical
12 3 (0.37%) Corporate Banking
13 2 (0.25%) Games
13 2 (0.25%) Law
14 1 (0.12%) Back Office
14 1 (0.12%) Electronics
14 1 (0.12%) International Banking
Job Titles
1 340 (41.92%) Developer
2 146 (18.00%) Analyst
3 56 (6.91%) Java Developer
4 45 (5.55%) Data Analyst
5 44 (5.43%) .NET Developer
6 43 (5.30%) Architect
7 41 (5.06%) DBA
8 40 (4.93%) SQL Developer
9 39 (4.81%) Test Analyst
10 34 (4.19%) C# Developer
11 31 (3.82%) Applications Support
12 29 (3.58%) Tester
13 26 (3.21%) Oracle Developer
13 26 (3.21%) Senior Developer
13 26 (3.21%) Software Developer
14 25 (3.08%) Support Engineer
15 24 (2.96%) Python Developer
16 22 (2.71%) Applications Engineer
16 22 (2.71%) Applications Support Engineer
16 22 (2.71%) SQL Analyst
Libraries, Frameworks & Software Standards
1 139 (17.14%) .NET
2 104 (12.82%) HTML
3 79 (9.74%) CSS
4 77 (9.49%) AngularJS
5 76 (9.37%) Spring
6 74 (9.12%) SOAP
7 71 (8.75%) XML
8 68 (8.38%) REST
9 65 (8.01%) Web Services
10 60 (7.40%) ASP.NET
11 46 (5.67%) HTML5
12 40 (4.93%) jQuery
12 40 (4.93%) JSON
13 39 (4.81%) .NET Framework
14 38 (4.69%) ASP.NET MVC
15 37 (4.56%) React
16 26 (3.21%) CSS3
17 20 (2.47%) Hibernate
18 18 (2.22%) ASP.NET Web API
18 18 (2.22%) Node.js
Miscellaneous
1 73 (9.00%) Analytical Skills
2 36 (4.44%) Clustering
3 26 (3.21%) PDA
4 22 (2.71%) Computer Science
5 20 (2.47%) Greenfield Project
6 19 (2.34%) Self-Motivation
7 15 (1.85%) Data Structures
7 15 (1.85%) Replication
8 13 (1.60%) Credit Risk
8 13 (1.60%) Enterprise Software
9 12 (1.48%) Cyberthreat
9 12 (1.48%) User Experience
10 11 (1.36%) Management Information System
11 10 (1.23%) Cloud Native
11 10 (1.23%) Fintech
12 9 (1.11%) Private Cloud
13 8 (0.99%) Algorithms
14 7 (0.86%) Derivative
14 7 (0.86%) Mainframe
15 6 (0.74%) Data Centre
Operating Systems
1 121 (14.92%) Linux
2 112 (13.81%) Windows
3 84 (10.36%) Unix
4 42 (5.18%) Windows Server
4 42 (5.18%) Windows Server 2008
5 38 (4.69%) Windows 7
6 29 (3.58%) Windows Server 2003
7 27 (3.33%) AIX
8 12 (1.48%) Windows Server 2012
9 10 (1.23%) zOS
10 7 (0.86%) Solaris
11 4 (0.49%) Windows 2000 Server
12 3 (0.37%) Red Hat Enterprise Linux
12 3 (0.37%) Windows 10
12 3 (0.37%) Windows Phone
13 2 (0.25%) Android
13 2 (0.25%) Apple iOS
13 2 (0.25%) Windows 8
14 1 (0.12%) Data ONTAP
14 1 (0.12%) Mac OS
Processes & Methodologies
1 314 (38.72%) Agile Software Development
2 103 (12.70%) Test Automation
3 95 (11.71%) ETL
4 76 (9.37%) Scrum
5 75 (9.25%) Continuous Integration
6 71 (8.75%) DevOps
7 70 (8.63%) Analytics
8 63 (7.77%) Business Intelligence
8 63 (7.77%) OO
9 61 (7.52%) Microservices
10 59 (7.27%) Problem-Solving
11 58 (7.15%) Migration
11 58 (7.15%) Software Engineering
12 57 (7.03%) SDLC
13 56 (6.91%) MVC
14 48 (5.92%) Change Management
14 48 (5.92%) Data Modelling
15 43 (5.30%) Software Testing
16 40 (4.93%) Data Analysis
17 39 (4.81%) Test Scripting
Programming Languages
1 208 (25.65%) Java
2 158 (19.48%) C#
3 128 (15.78%) JavaScript
4 99 (12.21%) Python
5 84 (10.36%) PL/SQL
6 64 (7.89%) Perl
7 57 (7.03%) Shell Script
8 56 (6.91%) T-SQL
9 44 (5.43%) PowerShell
10 29 (3.58%) VBA
11 28 (3.45%) Bash Shell
12 25 (3.08%) PHP
12 25 (3.08%) Ruby
13 21 (2.59%) TypeScript
14 20 (2.47%) C++
15 19 (2.34%) R
16 18 (2.22%) Java 8
16 18 (2.22%) VB
17 16 (1.97%) Go
17 16 (1.97%) VBScript
Qualifications
1 71 (8.75%) Security Cleared
2 56 (6.91%) Degree
3 55 (6.78%) SC Cleared
4 32 (3.95%) ISTQB
5 17 (2.10%) CISM
5 17 (2.10%) CISSP
6 12 (1.48%) Computer Science Degree
6 12 (1.48%) DV Cleared
7 9 (1.11%) BPSS Clearance
8 6 (0.74%) ISEB
9 5 (0.62%) PRINCE2 Certification
9 5 (0.62%) SAS Certification
10 4 (0.49%) ISTQB Foundation Certification
11 3 (0.37%) PhD
11 3 (0.37%) PMP
12 2 (0.25%) DBS Check
12 2 (0.25%) Numerate Degree
13 1 (0.12%) BC Cleared
13 1 (0.12%) CITP
13 1 (0.12%) TOGAF Certification
Quality Assurance & Compliance
1 44 (5.43%) QA
2 22 (2.71%) Data Quality
3 20 (2.47%) GDPR
4 16 (1.97%) FINRA
5 10 (1.23%) Disclosure Scotland
6 8 (0.99%) SLA
7 6 (0.74%) PMO
8 4 (0.49%) IFRS
8 4 (0.49%) IFRS 9
9 1 (0.12%) COBIT
9 1 (0.12%) EMIR
9 1 (0.12%) Sarbanes-Oxley
System Software
1 53 (6.54%) Active Directory
2 41 (5.06%) VMware Infrastructure
3 32 (3.95%) VMware ESXi
4 28 (3.45%) Hyper-V
5 26 (3.21%) Virtual Desktop
6 19 (2.34%) Docker
7 15 (1.85%) XenApp
8 7 (0.86%) RACF
8 7 (0.86%) Terminal Services
8 7 (0.86%) XenDesktop
9 6 (0.74%) HDFS
9 6 (0.74%) Microsoft App-V
9 6 (0.74%) XenServer
10 5 (0.62%) Virtual Machines
10 5 (0.62%) vSphere
11 3 (0.37%) Job Entry Subsystem
11 3 (0.37%) Time Sharing Option
12 2 (0.25%) OpenAM
12 2 (0.25%) Postfix
13 1 (0.12%) Oracle RAC
Systems Management
1 30 (3.70%) HP ALM
2 26 (3.21%) McAfee ePO
3 23 (2.84%) Terraform
4 20 (2.47%) Ansible
5 16 (1.97%) HP Quality Center
6 15 (1.85%) SCCM
7 13 (1.60%) Puppet
8 10 (1.23%) Opscode Chef
9 7 (0.86%) Control-M
10 6 (0.74%) Systems Management Server (SMS)
11 4 (0.49%) Kubernetes
11 4 (0.49%) OMEGAMON
11 4 (0.49%) Packer
12 3 (0.37%) Backup Exec
12 3 (0.37%) Host Intrusion Detection System
12 3 (0.37%) Malwarebytes
12 3 (0.37%) Network Intrusion Detection System
12 3 (0.37%) Norton AntiVirus
12 3 (0.37%) zSecure
13 2 (0.25%) Fail2ban
Vendors
1 240 (29.59%) Oracle
2 136 (16.77%) Microsoft
3 48 (5.92%) VMware
4 45 (5.55%) Citrix
5 43 (5.30%) McAfee
6 41 (5.06%) HP
7 35 (4.32%) Tableau
8 32 (3.95%) Ivanti
9 30 (3.70%) Veritas
10 25 (3.08%) IBM
10 25 (3.08%) Sybase
11 22 (2.71%) Teradata
12 19 (2.34%) Symantec
13 18 (2.22%) Cloudera
14 17 (2.10%) Epicor
14 17 (2.10%) Informatica
15 16 (1.97%) Hortonworks
15 16 (1.97%) Varonis
16 14 (1.73%) Talend
17 12 (1.48%) Charles River