Period
to 20 May 2018

The median annual salary for a Data Analyst was £50,000 in advertised job vacancies in Edinburgh during the 6 months to 20 May 2018.

The first table below provides salary benchmarking and summary statistics including a comparison to same period in the previous 2 years.

Data Analyst
Scotland > Edinburgh
6 months to
20 May 2018
Same period 2017 Same period 2016
Rank 108 105 138
Rank change year-on-year -3 +33 -20
Permanent jobs requiring a Data Analyst 38 34 9
As % of all permanent IT jobs advertised in Edinburgh 1.46% 1.52% 0.36%
As % of the Job Titles category 1.52% 1.60% 0.38%
Number of salaries quoted 24 14 4
Edinburgh median annual salary £50,000 £33,750 £45,750
Median salary % change year-on-year +48.15% -26.23% +40.77%
10th Percentile £31,500 £26,400 £27,300
90th Percentile £70,000 £52,500 £66,825
Scotland median annual salary £50,000 £35,000 £35,000
% change year-on-year +42.86% - +3.70%

The following table is for comparison with the above and includes summary statistics for all permanent 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 permanent jobs in our overall sample.

All Permanent IT Job Vacancies
Edinburgh
Permanent vacancies in Edinburgh with a recognized job title 2,496 2,126 2,391
% of permanent IT jobs with a recognized job title 96.00% 95.17% 94.81%
Number of salaries quoted 1,664 1,377 1,545
Edinburgh median annual salary £45,000 £45,000 £45,000
10th Percentile £28,000 £28,750 £26,750
90th Percentile £68,750 £70,000 £67,500
Scotland median annual salary £45,000 £44,000 £43,500
% change year-on-year +2.27% +1.15% +2.35%

Data Analyst
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Data Analyst in Edinburgh

Data Analyst
Salary Trend in Edinburgh

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

Salary trend for Data Analyst in Edinburgh

Data Analyst
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Data Analyst in Edinburgh over the 6 months to 20 May 2018.

Salary histogram for Data Analyst in Edinburgh

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

For the 6 months to 20 May 2018, Data Analyst job roles required the following IT skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Edinburgh region featuring Data Analyst in the job title.

1 32 (84.21%) SQL
2 26 (68.42%) SAS
3 21 (55.26%) Finance
4 15 (39.47%) Analytical Skills
5 14 (36.84%) SQL Server Integration Services
5 14 (36.84%) ETL
5 14 (36.84%) SQL Server
6 12 (31.58%) Hadoop
6 12 (31.58%) Tableau
7 11 (28.95%) Analytics
8 10 (26.32%) Data Quality
8 10 (26.32%) Relational Database
8 10 (26.32%) Oracle
8 10 (26.32%) Business Intelligence
9 9 (23.68%) Data Modelling
9 9 (23.68%) Python
9 9 (23.68%) Banking
9 9 (23.68%) Data Analysis
9 9 (23.68%) Data Governance
10 8 (21.05%) Business Analysis
10 8 (21.05%) Microsoft Excel
11 7 (18.42%) Microsoft Office
11 7 (18.42%) Microsoft
11 7 (18.42%) Informatica
11 7 (18.42%) Project Management
11 7 (18.42%) Microsoft PowerPoint
11 7 (18.42%) Degree
11 7 (18.42%) Computer Science
12 6 (15.79%) Data Architecture
12 6 (15.79%) Open Source

Data 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 26 (68.42%) SAS
2 3 (7.89%) Apache Spark
3 1 (2.63%) SharePoint
Applications
1 8 (21.05%) Microsoft Excel
2 7 (18.42%) Microsoft Office
2 7 (18.42%) Microsoft PowerPoint
3 6 (15.79%) Microsoft Project
3 6 (15.79%) MS Visio
4 1 (2.63%) SPSS
Cloud Services
1 1 (2.63%) Amazon AWS
1 1 (2.63%) Cortana Intelligence Suite
1 1 (2.63%) Google Cloud Platform
1 1 (2.63%) Microsoft Azure
Database & Business Intelligence
1 14 (36.84%) SQL Server
1 14 (36.84%) SQL Server Integration Services
2 12 (31.58%) Hadoop
3 10 (26.32%) Relational Database
4 4 (10.53%) Big Data
5 3 (7.89%) Base SAS
5 3 (7.89%) Data Mining
5 3 (7.89%) Power BI
5 3 (7.89%) QlikView
5 3 (7.89%) RDBMS
5 3 (7.89%) SQL Server Reporting Services
6 2 (5.26%) SQL Server 2014
7 1 (2.63%) Amazon Redshift
7 1 (2.63%) BusinessObjects
7 1 (2.63%) HBase
7 1 (2.63%) IBM InfoSphere
7 1 (2.63%) MySQL
7 1 (2.63%) Oracle BI EE
7 1 (2.63%) SAS Enterprise Guide
7 1 (2.63%) SQL Server Analysis Services
General
1 21 (55.26%) Finance
2 9 (23.68%) Banking
3 1 (2.63%) Legal
Libraries, Frameworks & Software Standards
1 2 (5.26%) .NET
2 1 (2.63%) D3.js
2 1 (2.63%) Natural Language Processing
Miscellaneous
1 15 (39.47%) Analytical Skills
2 7 (18.42%) Computer Science
3 3 (7.89%) Fintech
4 1 (2.63%) Clustering
4 1 (2.63%) Credit Risk
4 1 (2.63%) Management Information System
Operating Systems
1 1 (2.63%) Linux
Processes & Methodologies
1 14 (36.84%) ETL
2 11 (28.95%) Analytics
3 10 (26.32%) Business Intelligence
4 9 (23.68%) Data Analysis
4 9 (23.68%) Data Governance
4 9 (23.68%) Data Modelling
5 8 (21.05%) Business Analysis
6 7 (18.42%) Project Management
7 6 (15.79%) Data Architecture
7 6 (15.79%) Open Source
7 6 (15.79%) Root Cause Analysis
8 4 (10.53%) Dashboard Development
8 4 (10.53%) Data Cleansing
8 4 (10.53%) Problem-Solving
9 3 (7.89%) Anti-Money Laundering
9 3 (7.89%) Creative Thinking
9 3 (7.89%) Data Development
9 3 (7.89%) Data Migration
9 3 (7.89%) Data Science
9 3 (7.89%) Data Transformation
Programming Languages
1 32 (84.21%) SQL
2 9 (23.68%) Python
3 6 (15.79%) Java
4 5 (13.16%) R
4 5 (13.16%) T-SQL
4 5 (13.16%) VBA
5 2 (5.26%) C
5 2 (5.26%) C#
5 2 (5.26%) C++
5 2 (5.26%) MATLAB
5 2 (5.26%) VB
6 1 (2.63%) JavaScript
Qualifications
1 7 (18.42%) Degree
2 3 (7.89%) Numerate Degree
3 1 (2.63%) PhD
3 1 (2.63%) Security Cleared
Quality Assurance & Compliance
1 10 (26.32%) Data Quality
2 1 (2.63%) Dodd-Frank
2 1 (2.63%) EMIR
2 1 (2.63%) FATCA
2 1 (2.63%) MiFID
2 1 (2.63%) Solvency II
Vendors
1 12 (31.58%) Tableau
2 10 (26.32%) Oracle
3 7 (18.42%) Informatica
3 7 (18.42%) Microsoft
4 6 (15.79%) Talend
5 3 (7.89%) Sybase
6 2 (5.26%) Google
6 2 (5.26%) IBM
6 2 (5.26%) Pega
6 2 (5.26%) Teradata
7 1 (2.63%) Apple
7 1 (2.63%) Capita
7 1 (2.63%) Minitab
7 1 (2.63%) SAP
7 1 (2.63%) Vertica