Period
to 17 November 2017

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 17 November 2017 with a comparison to the same period in the previous 2 years.

Data Modelling
Scotland > Edinburgh
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 114 56 91
Rank change year-on-year -58 +35 +13
Permanent jobs citing Data Modelling 39 89 71
As % of all permanent IT jobs advertised in Edinburgh 1.44% 3.84% 2.32%
As % of the Processes & Methodologies category 1.58% 4.14% 2.53%
Number of salaries quoted 19 71 66
Edinburgh median annual salary £45,000 £52,500 £47,500
Median salary % change year-on-year -14.29% +10.53% +3.26%
10th Percentile £35,000 £37,500 £34,750
90th Percentile £57,500 £75,000 £69,750
Scotland median annual salary £44,250 £50,000 £47,500
% change year-on-year -11.50% +5.26% +3.26%

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 2467 2148 2803
As % of all permanent IT jobs advertised in Edinburgh 91.20% 92.63% 91.57%
Number of salaries quoted 1483 1390 1765
Edinburgh median annual salary £42,500 £45,000 £42,500
Median salary % change year-on-year -5.56% +5.88% +1.19%
10th Percentile £27,000 £29,400 £27,500
90th Percentile £66,250 £69,325 £65,000
Scotland median annual salary £45,000 £44,000 £42,500
% change year-on-year +2.27% +3.53% +2.41%

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

Salary histogram for Data Modelling in Edinburgh

For the 6 months to 17 November 2017, IT jobs citing Data Modelling also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Edinburgh region with a requirement for Data Modelling.

1 22 (56.41%) SQL
2 14 (35.90%) Finance
2 14 (35.90%) Banking
2 14 (35.90%) Oracle
3 13 (33.33%) ETL
4 11 (28.21%) Stakeholder Management
5 10 (25.64%) Business Analysis
5 10 (25.64%) Use Case
5 10 (25.64%) Stakeholder and Relationship Management
6 9 (23.08%) Business Intelligence
7 8 (20.51%) Java
8 7 (17.95%) Google
8 7 (17.95%) TDD
8 7 (17.95%) WebSphere
8 7 (17.95%) Web Development
8 7 (17.95%) Asset Management
8 7 (17.95%) Workflow
8 7 (17.95%) HTML
8 7 (17.95%) SQL Server
8 7 (17.95%) DB2
8 7 (17.95%) XML
8 7 (17.95%) IBM
8 7 (17.95%) Misys
8 7 (17.95%) Tomcat
8 7 (17.95%) JMS
9 6 (15.38%) Data Warehouse
9 6 (15.38%) JBoss
9 6 (15.38%) WebLogic Portal
9 6 (15.38%) CSS
9 6 (15.38%) JSP

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 7 (17.95%) Tomcat
1 7 (17.95%) WebSphere
2 6 (15.38%) JBoss
2 6 (15.38%) WebLogic
2 6 (15.38%) WebLogic Portal
3 5 (12.82%) Apache Spark
4 4 (10.26%) SAS
5 2 (5.13%) Apache
Business Applications
1 1 (2.56%) Dynamics CRM
Cloud Services
1 3 (7.69%) Google Analytics
1 3 (7.69%) Google Cloud Platform
2 2 (5.13%) Amazon AWS
2 2 (5.13%) Amazon EMR
Database & Business Intelligence
1 7 (17.95%) DB2
1 7 (17.95%) SQL Server
2 6 (15.38%) Data Warehouse
2 6 (15.38%) Hadoop
3 4 (10.26%) Oracle Database
3 4 (10.26%) Oracle Database 11g
3 4 (10.26%) Oracle Database 12c
4 3 (7.69%) Base SAS
4 3 (7.69%) Big Data
4 3 (7.69%) Power BI
4 3 (7.69%) QlikView
4 3 (7.69%) SAS Enterprise Guide
4 3 (7.69%) Snowflake Schema
4 3 (7.69%) Star Schema
5 2 (5.13%) Amazon Redshift
5 2 (5.13%) Apache Hive
5 2 (5.13%) PostgreSQL
6 1 (2.56%) SQL Server 2012
6 1 (2.56%) SQL Server Integration Services
6 1 (2.56%) SQL Server Reporting Services
Development Applications
1 6 (15.38%) Log4j
2 4 (10.26%) Oracle Forms
3 1 (2.56%) JIRA
3 1 (2.56%) Team Foundation Server
General
1 14 (35.90%) Banking
1 14 (35.90%) Finance
2 6 (15.38%) Investment Banking
3 5 (12.82%) Financial Institution
4 2 (5.13%) Marketing
5 1 (2.56%) Electronics
5 1 (2.56%) Manufacturing
5 1 (2.56%) Retail
5 1 (2.56%) Telecoms
Job Titles
1 20 (51.28%) Analyst
2 10 (25.64%) Business Analyst
3 8 (20.51%) Business Development Analyst
3 8 (20.51%) Data Analyst
3 8 (20.51%) Development Analyst
3 8 (20.51%) Software Analyst
3 8 (20.51%) Software Development Analyst
3 8 (20.51%) Software Development Business Analyst
4 7 (17.95%) Consultant
4 7 (17.95%) Senior Analyst
5 6 (15.38%) Developer
5 6 (15.38%) Product Consultant
6 4 (10.26%) Oracle Developer
6 4 (10.26%) Senior Business Analyst
6 4 (10.26%) SQL Developer
7 3 (7.69%) Designer
7 3 (7.69%) PL/SQL Developer
7 3 (7.69%) SAS Analyst
7 3 (7.69%) Senior Data Analyst
7 3 (7.69%) Senior SAS Analyst
Libraries, Frameworks & Software Standards
1 7 (17.95%) HTML
1 7 (17.95%) JMS
1 7 (17.95%) XML
2 6 (15.38%) CSS
2 6 (15.38%) JSP
2 6 (15.38%) Web Services
3 3 (7.69%) Middleware
4 2 (5.13%) Pandas
4 2 (5.13%) scikit-learn
5 1 (2.56%) .NET
5 1 (2.56%) ASP.NET
5 1 (2.56%) OpenGL
5 1 (2.56%) WebGL
Miscellaneous
1 3 (7.69%) Computer Science
1 3 (7.69%) Credit Risk
1 3 (7.69%) N-Tier
2 1 (2.56%) 3D Graphics
2 1 (2.56%) Analytical Skills
Operating Systems
1 3 (7.69%) Linux
Processes & Methodologies
1 13 (33.33%) ETL
2 11 (28.21%) Stakeholder Management
3 10 (25.64%) Business Analysis
3 10 (25.64%) Stakeholder and Relationship Management
3 10 (25.64%) Use Case
4 9 (23.08%) Business Intelligence
5 7 (17.95%) Asset Management
5 7 (17.95%) TDD
5 7 (17.95%) Web Development
5 7 (17.95%) Workflow
6 6 (15.38%) Analytics
6 6 (15.38%) Data Analysis
6 6 (15.38%) Target Operating Model
7 5 (12.82%) Agile Software Development
7 5 (12.82%) Business Transformation
7 5 (12.82%) Wealth Management
8 4 (10.26%) Software Engineering
8 4 (10.26%) Visualisation
9 3 (7.69%) Data Integration
9 3 (7.69%) Data Mapping
Programming Languages
1 22 (56.41%) SQL
2 8 (20.51%) Java
3 4 (10.26%) PL/SQL
4 3 (7.69%) COBOL
4 3 (7.69%) JCL
4 3 (7.69%) Python
5 1 (2.56%) C
5 1 (2.56%) C#
5 1 (2.56%) C++
5 1 (2.56%) GLSL
5 1 (2.56%) PHP
5 1 (2.56%) R
Qualifications
1 5 (12.82%) Degree
2 1 (2.56%) Computer Science Degree
Vendors
1 14 (35.90%) Oracle
2 7 (17.95%) Google
2 7 (17.95%) IBM
2 7 (17.95%) Misys
3 5 (12.82%) Cognizant
4 3 (7.69%) Perforce
4 3 (7.69%) Tableau
5 2 (5.13%) Ab Initio
6 1 (2.56%) Canon
6 1 (2.56%) Intel
6 1 (2.56%) SAP