Period
to 19 June 2018

The median contractor rate for a SQL Analyst was £358 per day in advertised job vacancies in Edinburgh during the 6 months to 19 June 2018.

The first table below provides contractor rate benchmarking and summary statistics including a comparison to 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 Analyst
Scotland > Edinburgh
6 months to
19 Jun 2018
Same period 2017 Same period 2016
Rank 114 98 134
Rank change year-on-year -16 +36 -31
Contract jobs requiring a SQL Analyst 15 10 6
As % of all contract IT jobs advertised in Edinburgh 0.52% 0.49% 0.21%
As % of the Job Titles category 0.54% 0.51% 0.22%
Number of daily rates quoted 17 9 5
Edinburgh median daily rate £358 £440 £330
Median daily rate % change year-on-year -18.75% +33.33% -9.59%
10th Percentile £268 £329 £263
90th Percentile £450 £452 £504
Scotland median daily rate £358 £425 £325
% change year-on-year -15.88% +30.77% -
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate - £17.32 -

The following table is for comparison with the above and includes summary statistics for all contract IT job vacancies advertised in Edinburgh. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of contract jobs in our overall sample.

All Contract IT Job Vacancies
Edinburgh
Contract vacancies in Edinburgh with a recognized job title 2,779 1,942 2,725
% of contract IT jobs with a recognized job title 96.06% 95.90% 95.95%
Number of daily rates quoted 1,639 1,204 1,484
Edinburgh median daily rate £403 £400 £400
Median daily rate % change year-on-year +0.63% - +6.67%
10th Percentile £263 £239 £275
90th Percentile £557 £550 £561
Scotland median daily rate £400 £375 £375
% change year-on-year +6.67% - -
Number of hourly rates quoted 42 26 16
Edinburgh median hourly rate £17.25 £20.75 £15.41
Median hourly rate % change year-on-year -16.87% +34.67% -25.75%
10th Percentile £10.28 £12.75 £10.89
90th Percentile £44.45 £52.09 £45.63
Scotland median hourly rate £16.50 £22.25 £22.25
% change year-on-year -25.84% - +5.48%

SQL Analyst
Job Vacancy Trend in Edinburgh

Job postings that featured SQL Analyst in the job title as a percentage of all IT jobs advertised in Edinburgh.

Job vacancy trend for SQL Analyst in Edinburgh

SQL Analyst
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for SQL Analyst in Edinburgh

SQL Analyst
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing SQL Analyst in Edinburgh over the 6 months to 19 June 2018.

Contractor daily rate histogram for SQL Analyst in Edinburgh

SQL Analyst
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for SQL Analyst in Edinburgh

SQL Analyst Skill Set
Top 30 Co-occurring IT Skills in Edinburgh

For the 6 months to 19 June 2018, SQL Analyst contract jobs required the following IT skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Edinburgh region featuring SQL Analyst in the job title.

1 15 (100.00%) SQL
2 9 (60.00%) Finance
3 6 (40.00%) Oracle
3 6 (40.00%) Agile Software Development
4 5 (33.33%) Data Warehouse
5 4 (26.67%) Business Analysis
6 3 (20.00%) Analytical Skills
6 3 (20.00%) Data Mapping
6 3 (20.00%) Credit Risk
6 3 (20.00%) Banking
6 3 (20.00%) Microsoft Excel
6 3 (20.00%) Data Analysis
6 3 (20.00%) Stakeholder Management
6 3 (20.00%) ETL
6 3 (20.00%) XML
6 3 (20.00%) VBA
7 2 (13.33%) PL/SQL
7 2 (13.33%) T-SQL
7 2 (13.33%) Unix
7 2 (13.33%) SQL Server
7 2 (13.33%) Migration
7 2 (13.33%) Systems Analysis
7 2 (13.33%) User Acceptance Testing
7 2 (13.33%) Data Migration
7 2 (13.33%) Financial Analysis
7 2 (13.33%) Stakeholder Engagement
7 2 (13.33%) Data Structures
7 2 (13.33%) Oracle Database
7 2 (13.33%) SDLC
7 2 (13.33%) Target Operating Model

SQL Analyst Skill Set
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 1 (6.67%) Confluence
Applications
1 3 (20.00%) Microsoft Excel
2 1 (6.67%) Spreadsheet
Business Applications
1 1 (6.67%) Oracle EBS
Communications & Networking
1 1 (6.67%) TCP/IP
Database & Business Intelligence
1 5 (33.33%) Data Warehouse
2 2 (13.33%) Oracle Database
2 2 (13.33%) SQL Server
3 1 (6.67%) SQL Server 2008
3 1 (6.67%) SQL Server 2012
3 1 (6.67%) SQL Server 2014
Development Applications
1 1 (6.67%) JIRA
1 1 (6.67%) Oracle APEX
General
1 9 (60.00%) Finance
2 3 (20.00%) Banking
Libraries, Frameworks & Software Standards
1 3 (20.00%) XML
Miscellaneous
1 3 (20.00%) Analytical Skills
1 3 (20.00%) Credit Risk
2 2 (13.33%) Data Structures
Operating Systems
1 2 (13.33%) Unix
Processes & Methodologies
1 6 (40.00%) Agile Software Development
2 4 (26.67%) Business Analysis
3 3 (20.00%) Data Analysis
3 3 (20.00%) Data Mapping
3 3 (20.00%) ETL
3 3 (20.00%) Stakeholder Management
4 2 (13.33%) Data Migration
4 2 (13.33%) Financial Analysis
4 2 (13.33%) Migration
4 2 (13.33%) SDLC
4 2 (13.33%) Stakeholder Engagement
4 2 (13.33%) Systems Analysis
4 2 (13.33%) Target Operating Model
4 2 (13.33%) User Acceptance Testing
5 1 (6.67%) Anti-Money Laundering
5 1 (6.67%) Data Flow Diagram
5 1 (6.67%) Defect Management
5 1 (6.67%) Logical Data Model
5 1 (6.67%) Performance Monitoring
5 1 (6.67%) Test Scripting
Programming Languages
1 15 (100.00%) SQL
2 3 (20.00%) VBA
3 2 (13.33%) PL/SQL
3 2 (13.33%) T-SQL
Quality Assurance & Compliance
1 1 (6.67%) Data Quality
Vendors
1 6 (40.00%) Oracle
2 1 (6.67%) Informatica
2 1 (6.67%) Microsoft