Period
to 5 July 2020

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for Data Modelling skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Modelling over the 6 months to 5 July 2020 with a comparison to the same period in the previous 2 years.

Data Modelling
Scotland > Edinburgh
6 months to
5 Jul 2020
Same period 2019 Same period 2018
Rank 78 115 71
Rank change year-on-year +37 -44 +20
Permanent jobs citing Data Modelling 16 48 86
As % of all permanent jobs advertised in Edinburgh 1.33% 1.74% 3.12%
As % of the Processes & Methodologies category 1.48% 1.85% 3.29%
Number of salaries quoted 5 31 93
Median annual salary £55,000 £52,500 £42,500
Median salary % change year-on-year +4.76% +23.53% -29.17%
10th Percentile £29,750 £36,250 £28,250
90th Percentile £60,000 £76,031 £70,000
Scotland median annual salary £45,000 £50,720 £45,000
% change year-on-year -11.28% +12.71% -10.00%

Data Modelling is in the Processes and Methodologies 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 process or methodology skills.

All Process and Methodology Skills
Edinburgh
Permanent vacancies with a requirement for process or methodology skills 1,084 2,590 2,615
As % of all permanent IT jobs advertised in Edinburgh 90.41% 93.94% 94.95%
Number of salaries quoted 588 1,640 1,675
Median annual salary £50,000 £45,100 £45,000
Median salary % change year-on-year +10.86% +0.22% -
10th Percentile £31,675 £29,000 £28,000
90th Percentile £77,875 £72,500 £71,250
Scotland median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - -

Data Modelling
Job Vacancy Trend in Edinburgh

Job postings citing Data Modelling as a proportion of all IT jobs advertised in Edinburgh.

Job vacancy trend for Data Modelling in Edinburgh

Data Modelling
Salary Trend in Edinburgh

3-month moving average salary quoted in jobs citing Data Modelling in Edinburgh.

Salary trend for Data Modelling in Edinburgh

Data Modelling
Salary Histogram in Edinburgh

Salary distribution for jobs citing Data Modelling in Edinburgh over the 6 months to 5 July 2020.

Salary histogram for Data Modelling in Edinburgh

For the 6 months to 5 July 2020, IT jobs citing Data Modelling also mentioned the following 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 with a requirement for Data Modelling.

1 11 (68.75%) Finance
2 8 (50.00%) Business Intelligence
2 8 (50.00%) SQL Server Integration Services
3 6 (37.50%) Azure
3 6 (37.50%) AWS
3 6 (37.50%) SQL
3 6 (37.50%) Agile Software Development
4 5 (31.25%) Python
4 5 (31.25%) Data Warehouse
4 5 (31.25%) ETL
4 5 (31.25%) Scala
4 5 (31.25%) Hadoop
4 5 (31.25%) Java
4 5 (31.25%) Data Management
4 5 (31.25%) Apache Hive
4 5 (31.25%) Google
4 5 (31.25%) Impala
4 5 (31.25%) Apache Spark
4 5 (31.25%) Databricks
5 4 (25.00%) Azure Data Factory
5 4 (25.00%) Power Platform
5 4 (25.00%) Backlog Management
5 4 (25.00%) Power BI
5 4 (25.00%) R
5 4 (25.00%) GCP
5 4 (25.00%) Big Data
5 4 (25.00%) Talend
5 4 (25.00%) Kafka
5 4 (25.00%) Kimball Methodology
5 4 (25.00%) Analytics

Data Modelling
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 5 (31.25%) Apache Spark
Cloud Services
1 6 (37.50%) AWS
1 6 (37.50%) Azure
2 4 (25.00%) Amazon EMR
2 4 (25.00%) Azure Data Factory
2 4 (25.00%) GCP
2 4 (25.00%) Power Platform
Database & Business Intelligence
1 8 (50.00%) SQL Server Integration Services
2 5 (31.25%) Apache Hive
2 5 (31.25%) Data Warehouse
2 5 (31.25%) Hadoop
2 5 (31.25%) Impala
3 4 (25.00%) Big Data
3 4 (25.00%) Power BI
3 4 (25.00%) SQL Server
3 4 (25.00%) SQL Server Reporting Services
4 3 (18.75%) NoSQL
5 1 (6.25%) Apache Cassandra
5 1 (6.25%) MongoDB
Development Applications
1 2 (12.50%) Git (software)
General
1 11 (68.75%) Finance
2 3 (18.75%) Retail
Job Titles
1 6 (37.50%) Analyst
2 5 (31.25%) Data Engineer
3 4 (25.00%) Business Intelligence Analyst
4 2 (12.50%) Head of Data Management
5 1 (6.25%) Architect
5 1 (6.25%) Big Data Engineer
5 1 (6.25%) Configuration Analyst
5 1 (6.25%) Data Analyst
5 1 (6.25%) Data Architect
5 1 (6.25%) Financial Analyst
5 1 (6.25%) Report Analyst
5 1 (6.25%) Software Engineer
Libraries, Frameworks & Software Standards
1 4 (25.00%) Kafka
Miscellaneous
1 1 (6.25%) CMDB
Processes & Methodologies
1 8 (50.00%) Business Intelligence
2 6 (37.50%) Agile Software Development
3 5 (31.25%) Data Management
3 5 (31.25%) ETL
4 4 (25.00%) Analytics
4 4 (25.00%) Backlog Management
4 4 (25.00%) Business Analysis
4 4 (25.00%) Data Architecture
4 4 (25.00%) Kimball Methodology
4 4 (25.00%) Visualisation
5 3 (18.75%) Data Engineering
6 2 (12.50%) Data Governance
6 2 (12.50%) Data Lineage
6 2 (12.50%) Problem-Solving
6 2 (12.50%) Stakeholder Management
7 1 (6.25%) Configuration Management
7 1 (6.25%) Data Analysis
7 1 (6.25%) ITIL
7 1 (6.25%) Project Management
7 1 (6.25%) Tech Ops
Programming Languages
1 6 (37.50%) SQL
2 5 (31.25%) Java
2 5 (31.25%) Python
2 5 (31.25%) Scala
3 4 (25.00%) R
Quality Assurance & Compliance
1 2 (12.50%) Data Quality
Vendors
1 5 (31.25%) Databricks
1 5 (31.25%) Google
2 4 (25.00%) Microsoft
2 4 (25.00%) Talend
3 1 (6.25%) Dynatrace
3 1 (6.25%) HP
3 1 (6.25%) ServiceNow