Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Scotland 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 18 November 2017 with a comparison to the same period in the previous 2 years.

Data Modelling
UK > Scotland
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 105 83 109
Rank change year-on-year -22 +26 -36
Permanent jobs citing Data Modelling 130 147 150
As % of all permanent IT jobs advertised in Scotland 2.32% 2.83% 2.33%
As % of the Processes & Methodologies category 2.55% 3.09% 2.56%
Number of salaries quoted 72 104 109
Scotland median annual salary £44,250 £50,000 £47,500
Median salary % change year-on-year -11.50% +5.26% +2.15%
10th Percentile £31,500 £37,000 £32,500
90th Percentile £72,250 £75,000 £71,750
UK median annual salary £55,000 £55,000 £55,000

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 Scotland with a requirement for process or methodology skills.

All Process and Methodology Skills
Scotland
Permanent vacancies with a requirement for process or methodology skills 5097 4751 5852
As % of all permanent IT jobs advertised in Scotland 90.82% 91.40% 90.87%
Number of salaries quoted 3246 2882 3705
Scotland median annual salary £45,000 £44,000 £42,500
Median salary % change year-on-year +2.27% +3.53% +2.41%
10th Percentile £28,250 £28,250 £27,750
90th Percentile £66,250 £65,000 £63,750
UK median annual salary £50,000 £49,000 £47,500
% change year-on-year +2.04% +3.16% +5.56%

Data Modelling
Job Vacancy Trend in Scotland

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

Job vacancy trend for Data Modelling in Scotland

Data Modelling
Salary Trend in Scotland

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

Salary trend for Data Modelling in Scotland

Data Modelling
Salary Histogram in Scotland

The salary distribution of IT jobs citing Data Modelling in Scotland over the 6 months to 18 November 2017.

Salary histogram for Data Modelling in Scotland

Data Modelling
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Modelling within the Scotland region over the 6 months to 18 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +13 82 £45,000 - 1
Edinburgh -55 39 £45,000 -16.28% 4
Inverclyde +1 4 £37,500 -
Stirling 0 1 - -
Aberdeen -5 1 - -
South Lanarkshire - 1 £41,500 -
Scottish Borders - 1 £35,000 -
Falkirk - 1 - -
Data Modelling
UK

For the 6 months to 18 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 Scotland region with a requirement for Data Modelling.

1 84 (64.62%) SQL
2 54 (41.54%) Agile Software Development
3 41 (31.54%) Stakeholder Management
4 36 (27.69%) SQL Server
5 33 (25.38%) Microsoft
6 31 (23.85%) Finance
7 29 (22.31%) Relational Database
8 28 (21.54%) TDD
8 28 (21.54%) Degree
9 27 (20.77%) Business Intelligence
9 27 (20.77%) ETL
10 26 (20.00%) Data Warehouse
11 25 (19.23%) C#
12 23 (17.69%) OO
13 21 (16.15%) Oracle
13 21 (16.15%) GAP Analysis
13 21 (16.15%) Business Process Modelling
14 20 (15.38%) Analytical Skills
15 19 (14.62%) .NET
15 19 (14.62%) Business Analysis
15 19 (14.62%) Team Foundation Server
16 18 (13.85%) Continuous Integration
16 18 (13.85%) Git (software)
16 18 (13.85%) Requirements Engineering
16 18 (13.85%) Moq
16 18 (13.85%) NUnit
16 18 (13.85%) Banking
16 18 (13.85%) ASP.NET
16 18 (13.85%) OOD
16 18 (13.85%) MVC

Data Modelling
Co-occurring IT Skills in Scotland 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 (5.38%) Tomcat
1 7 (5.38%) WebSphere
2 6 (4.62%) Apache Spark
2 6 (4.62%) JBoss
2 6 (4.62%) WebLogic
2 6 (4.62%) WebLogic Portal
3 4 (3.08%) SAS
4 2 (1.54%) Apache
5 1 (0.77%) Jupyter
Applications
1 4 (3.08%) Microsoft Office
1 4 (3.08%) MS Visio
2 1 (0.77%) Microsoft Excel
2 1 (0.77%) Microsoft PowerPoint
Business Applications
1 3 (2.31%) Cognos Business Intelligence
1 3 (2.31%) Dynamics CRM
2 1 (0.77%) IntelliMatch
2 1 (0.77%) Oracle EBS
Cloud Services
1 6 (4.62%) Amazon AWS
2 3 (2.31%) Google Analytics
2 3 (2.31%) Google Cloud Platform
3 2 (1.54%) Amazon EMR
3 2 (1.54%) Dynamics 365
3 2 (1.54%) IBM Blueworks
3 2 (1.54%) Microsoft Azure
4 1 (0.77%) Azure Machine Learning
4 1 (0.77%) IaaS
4 1 (0.77%) PaaS
4 1 (0.77%) SaaS
Database & Business Intelligence
1 36 (27.69%) SQL Server
2 29 (22.31%) Relational Database
3 26 (20.00%) Data Warehouse
4 9 (6.92%) Big Data
5 8 (6.15%) SQL Server Reporting Services
5 8 (6.15%) Star Schema
6 7 (5.38%) Data Mining
6 7 (5.38%) DB2
6 7 (5.38%) Hadoop
7 6 (4.62%) Power BI
7 6 (4.62%) SQL Server Integration Services
8 5 (3.85%) RDBMS
8 5 (3.85%) Snowflake Schema
9 4 (3.08%) BusinessObjects
9 4 (3.08%) Oracle Database
9 4 (3.08%) Oracle Database 11g
9 4 (3.08%) Oracle Database 12c
9 4 (3.08%) SQL Server 2012
10 3 (2.31%) Apache Hive
10 3 (2.31%) QlikView
Development Applications
1 19 (14.62%) Team Foundation Server
2 18 (13.85%) Git (software)
2 18 (13.85%) Moq
2 18 (13.85%) NUnit
3 6 (4.62%) ERwin
3 6 (4.62%) Log4j
4 4 (3.08%) Oracle Forms
5 3 (2.31%) MagicDraw
6 2 (1.54%) JUnit
6 2 (1.54%) SQL Server Management Studio (SSMS)
7 1 (0.77%) JIRA
General
1 31 (23.85%) Finance
2 18 (13.85%) Banking
3 8 (6.15%) Investment Banking
4 5 (3.85%) Financial Institution
5 4 (3.08%) Advertising
6 3 (2.31%) Games
6 3 (2.31%) Marketing
6 3 (2.31%) Retail
6 3 (2.31%) Retail Banking
7 2 (1.54%) Law
7 2 (1.54%) Publishing
8 1 (0.77%) Back Office
8 1 (0.77%) Electronics
8 1 (0.77%) Legal
8 1 (0.77%) Manufacturing
8 1 (0.77%) Telecoms
Job Titles
1 56 (43.08%) Analyst
2 36 (27.69%) Business Analyst
3 33 (25.38%) Developer
4 17 (13.08%) Senior Analyst
5 16 (12.31%) .NET Developer
6 15 (11.54%) Data Analyst
7 13 (10.00%) Senior Business Analyst
8 12 (9.23%) Consultant
8 12 (9.23%) Software Developer
8 12 (9.23%) SQL Developer
9 11 (8.46%) .NET Software Developer
9 11 (8.46%) Architect
9 11 (8.46%) C# .NET Developer
9 11 (8.46%) C# Developer
9 11 (8.46%) C# Software Developer
10 10 (7.69%) Senior Developer
11 9 (6.92%) ASP.NET MVC Developer
11 9 (6.92%) Senior .NET Developer
12 8 (6.15%) Business Development Analyst
12 8 (6.15%) Software Development Analyst
Libraries, Frameworks & Software Standards
1 19 (14.62%) .NET
2 18 (13.85%) ASP.NET
3 17 (13.08%) ASP.NET MVC
3 17 (13.08%) XML
4 9 (6.92%) .NET Framework
4 9 (6.92%) Entity Framework
4 9 (6.92%) Unity DI Container
5 7 (5.38%) HTML
5 7 (5.38%) JMS
6 6 (4.62%) CSS
6 6 (4.62%) JSP
6 6 (4.62%) Web Services
7 3 (2.31%) Middleware
7 3 (2.31%) Pandas
7 3 (2.31%) XML Schema
8 2 (1.54%) Ajax
8 2 (1.54%) FIX Protocol
8 2 (1.54%) Hibernate
8 2 (1.54%) JSON
8 2 (1.54%) Spring
Miscellaneous
1 20 (15.38%) Analytical Skills
2 7 (5.38%) Computer Science
3 4 (3.08%) Reference Data
4 3 (2.31%) Credit Risk
4 3 (2.31%) Management Information System
4 3 (2.31%) N-Tier
4 3 (2.31%) Taxonomies
5 2 (1.54%) Data Structures
5 2 (1.54%) Equities
5 2 (1.54%) Fixed Income
5 2 (1.54%) FMCG
6 1 (0.77%) 3D Graphics
6 1 (0.77%) Algorithms
6 1 (0.77%) Fintech
6 1 (0.77%) Mobile App
6 1 (0.77%) Renewable Energy
Operating Systems
1 9 (6.92%) Linux
2 6 (4.62%) Unix
Processes & Methodologies
1 54 (41.54%) Agile Software Development
2 41 (31.54%) Stakeholder Management
3 28 (21.54%) TDD
4 27 (20.77%) Business Intelligence
4 27 (20.77%) ETL
5 23 (17.69%) OO
6 21 (16.15%) Business Process Modelling
6 21 (16.15%) GAP Analysis
7 19 (14.62%) Business Analysis
8 18 (13.85%) Continuous Integration
8 18 (13.85%) MVC
8 18 (13.85%) OOD
8 18 (13.85%) Requirements Engineering
9 17 (13.08%) Analytics
10 16 (12.31%) Data Analysis
11 15 (11.54%) User Stories
12 12 (9.23%) Collaborative Working
13 11 (8.46%) Data Management
13 11 (8.46%) SDLC
13 11 (8.46%) Use Case
Programming Languages
1 84 (64.62%) SQL
2 25 (19.23%) C#
3 17 (13.08%) Java
4 8 (6.15%) PL/SQL
4 8 (6.15%) Python
5 4 (3.08%) C++
5 4 (3.08%) PowerShell
6 3 (2.31%) COBOL
6 3 (2.31%) JCL
6 3 (2.31%) Korn
6 3 (2.31%) Perl
6 3 (2.31%) R
6 3 (2.31%) Smalltalk
6 3 (2.31%) T-SQL
7 2 (1.54%) JavaScript
8 1 (0.77%) C
8 1 (0.77%) GLSL
8 1 (0.77%) HiveQL
8 1 (0.77%) MATLAB
8 1 (0.77%) PHP
Qualifications
1 28 (21.54%) Degree
2 15 (11.54%) Microsoft Certification
2 15 (11.54%) Security Cleared
3 13 (10.00%) MCAD
3 13 (10.00%) MCSD
3 13 (10.00%) MCTS
4 2 (1.54%) MCSA
5 1 (0.77%) Computer Science Degree
5 1 (0.77%) SC Cleared
Quality Assurance & Compliance
1 9 (6.92%) QA
2 6 (4.62%) Data Quality
3 2 (1.54%) ISO 20022
4 1 (0.77%) GDPR
Vendors
1 33 (25.38%) Microsoft
2 21 (16.15%) Oracle
3 10 (7.69%) IBM
4 7 (5.38%) Google
4 7 (5.38%) Misys
5 5 (3.85%) Cognizant
5 5 (3.85%) Perforce
6 4 (3.08%) Cognos
6 4 (3.08%) SAP
7 3 (2.31%) Informatica
7 3 (2.31%) Tableau
8 2 (1.54%) Ab Initio
9 1 (0.77%) Canon
9 1 (0.77%) Intel
9 1 (0.77%) MicroStrategy
9 1 (0.77%) SunGard