Period
to 21 November 2017

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 21 November 2017 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
21 Nov 2017
Same period 2016 Same period 2015
Rank 7 6 5
Rank change year-on-year -1 -1 0
Contract jobs citing SQL 689 642 873
As % of all contract IT jobs advertised in Scotland 13.71% 14.89% 14.17%
As % of the Programming Languages category 35.79% 36.92% 45.83%
Number of daily rates quoted 387 437 498
Scotland median daily rate £380 £340 £350
Median daily rate % change year-on-year +11.76% -2.86% -0.58%
10th Percentile £288 £260 £262
90th Percentile £488 £461 £516
UK median daily rate £425 £400 £395
% change year-on-year +6.25% +1.27% +5.33%
Number of hourly rates quoted 16 15 13
Scotland median hourly rate £24.00 £40.00 £40.00
Median hourly rate % change year-on-year -40.00% - +128.57%
10th Percentile £15.06 £14.85 £15.35
90th Percentile £195.00 £48.38 £44.28
UK median hourly rate £27.00 £28.00 £27.89
% change year-on-year -3.57% +0.39% +9.91%

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 1925 1739 1905
As % of all contract IT jobs advertised in Scotland 38.30% 40.34% 30.93%
Number of daily rates quoted 1155 1050 1036
Scotland median daily rate £388 £350 £350
Median daily rate % change year-on-year +10.71% - -6.67%
10th Percentile £281 £263 £260
90th Percentile £525 £475 £500
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 28 31 44
Scotland median hourly rate £27.00 £40.00 £37.50
Median hourly rate % change year-on-year -32.50% +6.67% +7.14%
10th Percentile £15.09 £14.85 £14.39
90th Percentile £195.00 £52.00 £55.00
UK median hourly rate £40.00 £37.50 £37.45
% change year-on-year +6.67% +0.13% +20.81%

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 21 November 2017.

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 21 November 2017.

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 21 November 2017. 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 377 £388 +3.33% 30
Glasgow 0 236 £375 +10.29% 45
Renfrewshire -1 16 £412 +28.75%
Aberdeen -6 9 £378 +139.68% 2
Stirling - 8 £263 -
Fife -3 5 £300 +9.09% 3
West Lothian -16 5 £315 -3.08% 1
Dundee +6 4 £400 +10.34% 3
North Lanarkshire - 4 - - 1
Inverclyde - 3 £325 -
South Lanarkshire -4 2 - -
Highlands -7 2 £250 -9.09% 1
East Ayrshire - 2 £350 -
South Ayrshire +6 1 £225 -
Perthshire - 1 - - 1
East Lothian - 1 - -
SQL
UK

For the 6 months to 21 November 2017, IT contractor jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Scotland region with a requirement for SQL.

1 226 (32.80%) Agile Software Development
2 225 (32.66%) Finance
3 193 (28.01%) Java
4 158 (22.93%) Oracle
5 133 (19.30%) SQL Server
6 125 (18.14%) JavaScript
7 111 (16.11%) Linux
8 96 (13.93%) Analytical Skills
9 89 (12.92%) C#
10 88 (12.77%) Test Automation
11 87 (12.63%) PL/SQL
12 86 (12.48%) Windows
13 84 (12.19%) Unix
14 82 (11.90%) Python
15 81 (11.76%) .NET
16 80 (11.61%) Banking
17 77 (11.18%) HTML
17 77 (11.18%) Relational Database
18 75 (10.89%) Microsoft
19 73 (10.60%) Business Intelligence
20 72 (10.45%) Perl
21 71 (10.30%) Spring
22 70 (10.16%) ETL
23 66 (9.58%) Data Warehouse
23 66 (9.58%) XML
23 66 (9.58%) Git (software)
24 62 (9.00%) OO
25 59 (8.56%) SAS
26 58 (8.42%) T-SQL
27 57 (8.27%) Scrum

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 59 (8.56%) SAS
2 31 (4.50%) IIS
3 20 (2.90%) SharePoint
4 16 (2.32%) MQSeries
5 15 (2.18%) CICS
6 14 (2.03%) Tomcat
7 13 (1.89%) Apache
8 12 (1.74%) JBoss
9 11 (1.60%) Oracle SOA Suite
10 10 (1.45%) Confluence
11 4 (0.58%) Apache Spark
11 4 (0.58%) BizTalk Server
11 4 (0.58%) ColdFusion
12 3 (0.44%) CMS
13 2 (0.29%) Apache Solr
13 2 (0.29%) MS Exchange
13 2 (0.29%) WebSphere
13 2 (0.29%) WebSphere Application Server
14 1 (0.15%) Mule
14 1 (0.15%) Skype for Business
Applications
1 30 (4.35%) Microsoft Excel
1 30 (4.35%) Microsoft Office
2 15 (2.18%) Microsoft PowerPoint
3 5 (0.73%) MS Visio
4 4 (0.58%) Microsoft Project
4 4 (0.58%) Spreadsheet
5 2 (0.29%) SPSS
Business Applications
1 15 (2.18%) Markit EDM
2 9 (1.31%) Oracle BPM
3 5 (0.73%) Payment Gateway
4 3 (0.44%) Cognos Business Intelligence
5 2 (0.29%) assyst
5 2 (0.29%) Dynamics CRM
5 2 (0.29%) Oracle Applications
6 1 (0.15%) Cognos TM1
6 1 (0.15%) Dynamics AX
6 1 (0.15%) Infor M3
6 1 (0.15%) Oracle 11i
6 1 (0.15%) Sonata
Cloud Services
1 22 (3.19%) Microsoft Azure
2 18 (2.61%) Amazon AWS
3 6 (0.87%) Office 365
4 5 (0.73%) Google Analytics
4 5 (0.73%) PaaS
5 4 (0.58%) GitHub
5 4 (0.58%) IaaS
6 2 (0.29%) Azure Active Directory
6 2 (0.29%) Cloud Computing
6 2 (0.29%) SaaS
7 1 (0.15%) Azure Data Factory
7 1 (0.15%) npm
7 1 (0.15%) Yammer
Communications & Networking
1 28 (4.06%) SSL
2 17 (2.47%) Firewall
2 17 (2.47%) Kerberos
3 16 (2.32%) HTTP
4 15 (2.18%) SSH
5 13 (1.89%) HTTPS
5 13 (1.89%) Internet
6 10 (1.45%) DNS
7 9 (1.31%) SAN
8 8 (1.16%) DHCP
9 7 (1.02%) TCP/IP
10 4 (0.58%) Skype
11 3 (0.44%) Ethernet
11 3 (0.44%) ISDN
11 3 (0.44%) VoIP
12 2 (0.29%) AMQP
12 2 (0.29%) CTI
12 2 (0.29%) VPN
12 2 (0.29%) VSAN
13 1 (0.15%) NAS
Database & Business Intelligence
1 133 (19.30%) SQL Server
2 77 (11.18%) Relational Database
3 66 (9.58%) Data Warehouse
4 53 (7.69%) RDBMS
5 44 (6.39%) DB2
6 43 (6.24%) NoSQL
6 43 (6.24%) Oracle Database
7 38 (5.52%) SQL Server Integration Services
8 37 (5.37%) SQL Server Reporting Services
9 35 (5.08%) SQL Server Analysis Services
10 27 (3.92%) SQL Server 2012
11 25 (3.63%) Big Data
12 22 (3.19%) MongoDB
12 22 (3.19%) MySQL
12 22 (3.19%) Power BI
13 16 (2.32%) Hadoop
13 16 (2.32%) Oracle Reports
14 15 (2.18%) SQL Server 2008
15 14 (2.03%) Oracle Database 12c
15 14 (2.03%) PowerCenter
Development Applications
1 66 (9.58%) Git (software)
2 45 (6.53%) Maven
2 45 (6.53%) Subversion
3 39 (5.66%) Jenkins
4 29 (4.21%) JIRA
5 28 (4.06%) JUnit
6 26 (3.77%) Mercurial
6 26 (3.77%) Team Foundation Server
7 22 (3.19%) Selenium
8 18 (2.61%) Visual Studio
9 14 (2.03%) Cucumber
10 13 (1.89%) JMeter
10 13 (1.89%) SpecFlow
10 13 (1.89%) TeamCity
11 11 (1.60%) Oracle Forms
12 10 (1.45%) FitNesse
12 10 (1.45%) Hudson
13 9 (1.31%) Ant
14 8 (1.16%) Appium
14 8 (1.16%) JBehave
General
1 225 (32.66%) Finance
2 80 (11.61%) Banking
3 22 (3.19%) Retail Banking
4 11 (1.60%) Investment Banking
4 11 (1.60%) Publishing
5 7 (1.02%) Corporate Banking
6 6 (0.87%) Front Office
6 6 (0.87%) Legal
6 6 (0.87%) Retail
7 5 (0.73%) Law
7 5 (0.73%) Manufacturing
8 4 (0.58%) Telecoms
9 3 (0.44%) Marketing
10 2 (0.29%) Electronics
11 1 (0.15%) Advertising
11 1 (0.15%) Financial Institution
11 1 (0.15%) German Language
11 1 (0.15%) Italian Language
11 1 (0.15%) Private Banking
11 1 (0.15%) Spanish Language
Job Titles
1 303 (43.98%) Developer
2 183 (26.56%) Analyst
3 93 (13.50%) Java Developer
4 58 (8.42%) SQL Developer
5 51 (7.40%) Test Analyst
6 41 (5.95%) Consultant
6 41 (5.95%) Data Analyst
7 31 (4.50%) Business Analyst
7 31 (4.50%) Senior Analyst
8 29 (4.21%) Oracle Developer
9 28 (4.06%) .NET Developer
10 26 (3.77%) Systems Analyst
11 25 (3.63%) Business Intelligence Developer
12 24 (3.48%) Senior Developer
13 22 (3.19%) DBA
14 20 (2.90%) Applications Support
14 20 (2.90%) Senior Test Analyst
15 19 (2.76%) PL/SQL Developer
15 19 (2.76%) Technical Analyst
16 18 (2.61%) Architect
Libraries, Frameworks & Software Standards
1 81 (11.76%) .NET
2 77 (11.18%) HTML
3 71 (10.30%) Spring
4 66 (9.58%) XML
5 57 (8.27%) CSS
6 47 (6.82%) Web Services
7 44 (6.39%) Hibernate
8 36 (5.22%) AngularJS
9 29 (4.21%) RESTful
10 28 (4.06%) ASP.NET
11 26 (3.77%) JSON
12 25 (3.63%) jQuery
13 22 (3.19%) JMS
14 19 (2.76%) Ajax
14 19 (2.76%) HTML5
14 19 (2.76%) SOAP
15 18 (2.61%) Middleware
15 18 (2.61%) React
16 15 (2.18%) ISPF
17 14 (2.03%) J2SE
Miscellaneous
1 96 (13.93%) Analytical Skills
2 37 (5.37%) Data Structures
3 27 (3.92%) Algorithms
4 23 (3.34%) PKI
5 21 (3.05%) Greenfield Project
6 19 (2.76%) Computer Science
7 18 (2.61%) Mainframe
8 17 (2.47%) Enterprise Software
9 13 (1.89%) Credit Risk
10 8 (1.16%) Virtual Team
11 7 (1.02%) User Experience
12 6 (0.87%) Management Information System
13 5 (0.73%) Data Centre
13 5 (0.73%) Equity Derivative
13 5 (0.73%) Mobile App
14 4 (0.58%) Clustering
14 4 (0.58%) Fixed Income
14 4 (0.58%) Market Risk
14 4 (0.58%) SWIFT
15 3 (0.44%) Derivative
Operating Systems
1 111 (16.11%) Linux
2 86 (12.48%) Windows
3 84 (12.19%) Unix
4 43 (6.24%) Windows Server 2012
5 34 (4.93%) Windows Server
6 31 (4.50%) Red Hat Enterprise Linux
7 26 (3.77%) Windows Server 2008
8 20 (2.90%) Windows 7
9 16 (2.32%) Windows 10
10 15 (2.18%) zOS
11 5 (0.73%) Apple iOS
11 5 (0.73%) Solaris
12 3 (0.44%) Windows Server 2003
12 3 (0.44%) Windows XP
13 2 (0.29%) CentOS
13 2 (0.29%) Windows 8
14 1 (0.15%) Android
14 1 (0.15%) Ubuntu
14 1 (0.15%) Windows 2000
14 1 (0.15%) Windows Vista
Processes & Methodologies
1 226 (32.80%) Agile Software Development
2 88 (12.77%) Test Automation
3 73 (10.60%) Business Intelligence
4 70 (10.16%) ETL
5 62 (9.00%) OO
6 57 (8.27%) Scrum
7 49 (7.11%) Continuous Integration
8 48 (6.97%) Analytics
9 47 (6.82%) Data Modelling
10 46 (6.68%) Data Analysis
11 40 (5.81%) BDD
12 36 (5.22%) Web Development
13 34 (4.93%) TDD
14 33 (4.79%) ITIL
14 33 (4.79%) User Acceptance Testing
15 32 (4.64%) Migration
16 29 (4.21%) Asset Management
16 29 (4.21%) SDLC
17 28 (4.06%) Software Engineering
18 27 (3.92%) User Stories
Programming Languages
1 193 (28.01%) Java
2 125 (18.14%) JavaScript
3 89 (12.92%) C#
4 87 (12.63%) PL/SQL
5 82 (11.90%) Python
6 72 (10.45%) Perl
7 58 (8.42%) T-SQL
8 51 (7.40%) PowerShell
9 31 (4.50%) Shell Script
10 21 (3.05%) C++
11 17 (2.47%) REXX
12 16 (2.32%) JCL
12 16 (2.32%) Scala
13 15 (2.18%) Assembly Language
13 15 (2.18%) CLIST
14 14 (2.03%) PHP
14 14 (2.03%) VB
15 12 (1.74%) VB.NET
16 9 (1.31%) Ruby
16 9 (1.31%) VBScript
Qualifications
1 41 (5.95%) Degree
2 28 (4.06%) Security Cleared
3 19 (2.76%) SC Cleared
4 10 (1.45%) ISEB
5 8 (1.16%) Microsoft Certification
6 5 (0.73%) Computer Science Degree
6 5 (0.73%) ISTQB
7 4 (0.58%) Numerate Degree
8 3 (0.44%) DV Cleared
8 3 (0.44%) MCSA
9 2 (0.29%) BPSS Clearance
9 2 (0.29%) CCNA
9 2 (0.29%) CCNP
9 2 (0.29%) CIMA
9 2 (0.29%) Cisco Certification
9 2 (0.29%) HND
9 2 (0.29%) ISTQB Advanced Certification
9 2 (0.29%) MCSD
9 2 (0.29%) MCTS
9 2 (0.29%) VMware Certified Professional (VCP)
Quality Assurance & Compliance
1 21 (3.05%) QA
2 19 (2.76%) Data Quality
3 14 (2.03%) Disclosure Scotland
4 7 (1.02%) EMIR
5 4 (0.58%) ISO/IEC 27001
6 3 (0.44%) GDPR
6 3 (0.44%) SLA
7 2 (0.29%) Dodd-Frank
8 1 (0.15%) Basel II
8 1 (0.15%) ISO 22301
8 1 (0.15%) ISO/IEC 20000
8 1 (0.15%) MiFID
System Software
1 34 (4.93%) Active Directory
2 15 (2.18%) Job Entry Subsystem
2 15 (2.18%) RACF
2 15 (2.18%) Time Sharing Option
3 13 (1.89%) VMware Infrastructure
4 11 (1.60%) Docker
4 11 (1.60%) Microsoft App-V
5 5 (0.73%) Terminal Services
5 5 (0.73%) XenApp
6 4 (0.58%) Virtual Machines
6 4 (0.58%) VMware ESXi
7 3 (0.44%) Apache ZooKeeper
7 3 (0.44%) NFS
8 2 (0.29%) vSphere
9 1 (0.15%) Hyper-V
9 1 (0.15%) OpenAM
9 1 (0.15%) VMware NSX
Systems Management
1 30 (4.35%) SCCM
2 16 (2.32%) Ansible
3 15 (2.18%) zSecure
4 13 (1.89%) WSUS
5 10 (1.45%) IBM BigFix
5 10 (1.45%) Systems Management Server (SMS)
6 9 (1.31%) Opscode Chef
7 8 (1.16%) HP Quality Center
7 8 (1.16%) Puppet
7 8 (1.16%) SCOM
8 6 (0.87%) Netcool
9 4 (0.58%) WMI
10 2 (0.29%) EnCase
10 2 (0.29%) OpenView Configuration Management
11 1 (0.15%) Cobbler
11 1 (0.15%) EMC NetWorker
11 1 (0.15%) Kubernetes
11 1 (0.15%) MAINVIEW
11 1 (0.15%) SolarWinds Orion
11 1 (0.15%) Tivoli
Vendors
1 158 (22.93%) Oracle
2 75 (10.89%) Microsoft
3 45 (6.53%) Sybase
4 32 (4.64%) IBM
5 27 (3.92%) HP
6 22 (3.19%) Teradata
7 21 (3.05%) Red Hat
8 19 (2.76%) VMware
9 17 (2.47%) Informatica
10 16 (2.32%) CA
11 14 (2.03%) Cognos
12 13 (1.89%) Tableau
13 12 (1.74%) Perforce
13 12 (1.74%) Symantec
14 11 (1.60%) SAP
15 9 (1.31%) Dell
16 8 (1.16%) MicroStrategy
17 7 (1.02%) Cisco
17 7 (1.02%) Citrix
17 7 (1.02%) CyberArk