Period
to 16 December 2018

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 16 December 2018 with a comparison to the same period in the previous 2 years.

Data Modelling
Scotland > Edinburgh
6 months to
16 Dec 2018
Same period 2017 Same period 2016
Rank 96 106 50
Rank change year-on-year +10 -56 +28
Permanent jobs citing Data Modelling 53 43 92
As % of all permanent IT jobs advertised in Edinburgh 2.11% 1.64% 4.04%
As % of the Processes & Methodologies category 2.25% 1.77% 4.31%
Number of salaries quoted 24 19 73
Edinburgh median annual salary £43,500 £45,000 £55,000
Median salary % change year-on-year -3.33% -18.18% +15.79%
10th Percentile £28,500 £32,500 £37,500
90th Percentile £67,500 £58,000 £75,000
Scotland median annual salary £50,000 £45,000 £52,500
% change year-on-year +11.11% -14.29% +10.53%

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 2,355 2,425 2,136
As % of all permanent IT jobs advertised in Edinburgh 93.94% 92.59% 93.81%
Number of salaries quoted 1,427 1,498 1,418
Edinburgh median annual salary £45,000 £42,500 £45,000
Median salary % change year-on-year +5.88% -5.56% +2.27%
10th Percentile £28,750 £27,500 £29,750
90th Percentile £73,750 £65,000 £70,000
Scotland median annual salary £45,000 £45,000 £44,500
% change year-on-year - +1.12% +4.71%

Data Modelling
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Data Modelling in Edinburgh

Data Modelling
Salary Trend in Edinburgh

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

Salary trend for Data Modelling in Edinburgh

Data Modelling
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Data Modelling in Edinburgh over the 6 months to 16 December 2018.

Salary histogram for Data Modelling in Edinburgh

For the 6 months to 16 December 2018, 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 32 (60.38%) SQL
2 22 (41.51%) Oracle
3 20 (37.74%) Finance
4 17 (32.08%) ETL
5 14 (26.42%) Data Warehouse
5 14 (26.42%) SQL Server
5 14 (26.42%) Performance Tuning
6 13 (24.53%) Analytics
6 13 (24.53%) Business Intelligence
6 13 (24.53%) SQL Server Integration Services
7 12 (22.64%) T-SQL
7 12 (22.64%) Migration
7 12 (22.64%) Microsoft
8 10 (18.87%) Stakeholder Management
8 10 (18.87%) Statistics
8 10 (18.87%) Data Analysis
9 9 (16.98%) Replication
9 9 (16.98%) Hadoop
9 9 (16.98%) Disaster Recovery
9 9 (16.98%) Capacity Planning
9 9 (16.98%) Big Data
9 9 (16.98%) Storage Management
10 8 (15.09%) IBM
11 7 (13.21%) Java
11 7 (13.21%) Computer Science
11 7 (13.21%) Use Case
11 7 (13.21%) Software Engineering
11 7 (13.21%) Agile Software Development
11 7 (13.21%) Degree
11 7 (13.21%) Logical Data Model

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 (9.43%) SAS
2 3 (5.66%) Apache Spark
2 3 (5.66%) Oracle SOA Suite
3 2 (3.77%) Apache Pig
4 1 (1.89%) Apache
4 1 (1.89%) PowerExchange
Applications
1 2 (3.77%) Microsoft Excel
2 1 (1.89%) Microsoft Office
2 1 (1.89%) Microsoft PowerPoint
2 1 (1.89%) SPSS
Business Applications
1 1 (1.89%) Eloqua
1 1 (1.89%) Markit EDM
Cloud Services
1 4 (7.55%) Amazon AWS
2 3 (5.66%) Microsoft Azure
3 1 (1.89%) Amazon EC2
3 1 (1.89%) Amazon EMR
3 1 (1.89%) Amazon S3
3 1 (1.89%) AWS Lambda
3 1 (1.89%) Force.com
3 1 (1.89%) Google Analytics
3 1 (1.89%) Google Cloud Platform
3 1 (1.89%) SaaS
3 1 (1.89%) Serverless
Database & Business Intelligence
1 14 (26.42%) Data Warehouse
1 14 (26.42%) SQL Server
2 13 (24.53%) SQL Server Integration Services
3 9 (16.98%) Big Data
3 9 (16.98%) Hadoop
4 5 (9.43%) Relational Database
5 4 (7.55%) DataStage
5 4 (7.55%) IBM InfoSphere
5 4 (7.55%) NoSQL
5 4 (7.55%) Oracle Database
5 4 (7.55%) Oracle Database 11g
5 4 (7.55%) Oracle Database 12c
5 4 (7.55%) QlikView
5 4 (7.55%) SQL Server Analysis Services
5 4 (7.55%) SQL Server Reporting Services
6 3 (5.66%) Apache Cassandra
6 3 (5.66%) Crystal Reports
6 3 (5.66%) MongoDB
6 3 (5.66%) Oracle Reports
6 3 (5.66%) Pentaho
Development Applications
1 5 (9.43%) ERwin
1 5 (9.43%) Oracle Forms
2 4 (7.55%) Hudson
3 3 (5.66%) ER Studio
3 3 (5.66%) Git (software)
3 3 (5.66%) Toad
General
1 20 (37.74%) Finance
2 4 (7.55%) Banking
2 4 (7.55%) Marketing
3 2 (3.77%) Investment Banking
3 2 (3.77%) Retail Banking
Job Titles
1 10 (18.87%) Analyst
2 9 (16.98%) DBA
2 9 (16.98%) SQL DBA
3 7 (13.21%) Consultant
3 7 (13.21%) Developer
4 6 (11.32%) Data Engineer
5 5 (9.43%) Administrator
6 4 (7.55%) Business Analyst
6 4 (7.55%) Data Modeller
6 4 (7.55%) Oracle Developer
6 4 (7.55%) SQL Server DBA
7 3 (5.66%) Business Intelligence Consultant
7 3 (5.66%) Data Analyst
7 3 (5.66%) Technical Leader
8 2 (3.77%) Designer
8 2 (3.77%) Lead Business Analyst
8 2 (3.77%) QlikView Consultant
8 2 (3.77%) Technical Analyst
8 2 (3.77%) Technical Architect
8 2 (3.77%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 3 (5.66%) Apache CXF
1 3 (5.66%) Apache OpenJPA
1 3 (5.66%) CGI
1 3 (5.66%) Hibernate
1 3 (5.66%) JPA
1 3 (5.66%) JSF
1 3 (5.66%) RichFaces
1 3 (5.66%) Web Services
2 1 (1.89%) .NET
2 1 (1.89%) Kafka
2 1 (1.89%) Natural Language Processing
2 1 (1.89%) XML
Miscellaneous
1 9 (16.98%) Replication
2 7 (13.21%) Analytical Skills
3 3 (5.66%) Fintech
3 3 (5.66%) Management Information System
4 2 (3.77%) Self-Motivation
4 2 (3.77%) User Experience
5 1 (1.89%) Credit Risk
5 1 (1.89%) iPad
5 1 (1.89%) iPhone
Operating Systems
1 6 (11.32%) Unix
2 3 (5.66%) Linux
3 2 (3.77%) AIX
4 1 (1.89%) Apple iOS
Processes & Methodologies
1 17 (32.08%) ETL
2 14 (26.42%) Performance Tuning
3 13 (24.53%) Analytics
3 13 (24.53%) Business Intelligence
4 12 (22.64%) Migration
5 10 (18.87%) Data Analysis
5 10 (18.87%) Stakeholder Management
5 10 (18.87%) Statistics
6 9 (16.98%) Capacity Planning
6 9 (16.98%) Disaster Recovery
6 9 (16.98%) Storage Management
7 7 (13.21%) Agile Software Development
7 7 (13.21%) Computer Science
7 7 (13.21%) Data Science
7 7 (13.21%) Logical Data Model
7 7 (13.21%) Physical Data Model
7 7 (13.21%) Software Engineering
7 7 (13.21%) Use Case
8 5 (9.43%) Business Development
8 5 (9.43%) Mentoring
Programming Languages
1 32 (60.38%) SQL
2 12 (22.64%) T-SQL
3 7 (13.21%) Java
4 5 (9.43%) PL/SQL
4 5 (9.43%) Python
4 5 (9.43%) R
5 3 (5.66%) Java 8
6 2 (3.77%) MATLAB
6 2 (3.77%) Scala
7 1 (1.89%) Apex Code
7 1 (1.89%) C#
7 1 (1.89%) VB
Qualifications
1 7 (13.21%) Degree
2 1 (1.89%) PhD
Quality Assurance & Compliance
1 3 (5.66%) Data Quality
1 3 (5.66%) GDPR
System Software
1 4 (7.55%) Tivoli Workload Scheduler
2 1 (1.89%) Docker
2 1 (1.89%) HDFS
Systems Management
1 4 (7.55%) Tivoli
2 2 (3.77%) Systems Management Server (SMS)
3 1 (1.89%) Ambari
3 1 (1.89%) Kubernetes
3 1 (1.89%) Oozie
Vendors
1 22 (41.51%) Oracle
2 12 (22.64%) Microsoft
3 8 (15.09%) IBM
4 6 (11.32%) Teradata
5 4 (7.55%) Informatica
5 4 (7.55%) Tableau
6 3 (5.66%) Red Hat
7 2 (3.77%) Google
7 2 (3.77%) Salesforce.com
8 1 (1.89%) CA
8 1 (1.89%) Canon
8 1 (1.89%) Cloudera
8 1 (1.89%) MicroStrategy
8 1 (1.89%) Remedy