Data Modelling Jobs in Scotland

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 3 months to 27 June 2017 with a comparison to the same period in the previous 2 years.

Data Modelling UK / Scotland
Location	3 months to 27 Jun 2017	Same period 2016	Same period 2015
Rank	112	81	99
Rank change year-on-year	-31	+18
Permanent jobs citing Data Modelling	45	81	67
As % of all permanent IT jobs advertised in Scotland	1.66%	2.83%	2.15%
As % of the Processes & Methodologies category	1.81%	3.09%	2.39%
Number of salaries quoted	22	53	38
Median salary	£48,500	£48,500	£44,000
Median salary % change year-on-year	-	+10.22%
90% offered a salary of more than	£33,250	£40,284	£36,000
10% offered a salary of more than	£70,000	£76,400	£56,400
UK excluding London median salary	£48,500	£47,500	£45,500
% change year-on-year	+2.10%	+4.39%

Data Modelling is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for process and methodology skills.

Process & Methodology Skills Scotland
Permanent job vacancies with a requirement for process and methodology skills	2480	2618	2803
As % of all permanent IT job vacancies advertised in Scotland	91.38%	91.35%	89.93%
Number of salaries quoted	1589	1478	1763
Median salary	£45,000	£45,000	£44,000
Median salary % change year-on-year	-	+2.27%
90% offered a salary of more than	£31,500	£30,000	£32,000
10% offered a salary of more than	£67,500	£60,000	£65,000
UK excluding London median salary	£45,000	£45,000	£44,000
% change year-on-year	-	+2.27%

Data Modelling
Job Vacancy Trend in Scotland

The job posting trend of jobs advertised in Scotland citing Data Modelling as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

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 3 months to 27 June 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 3 months to 27 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location	Rank Change on Same Period Last Year	Matching Permanent IT Job Ads	Median Salary Last 3 Months	Median Salary % Change on Same Period Last Year	Live Job Vacancies
Glasgow	+6	31	£48,500	+7.77%	2
Edinburgh	-35	14	£52,500	-2.32%	6
Data Modelling UK

Data Modelling
Top 30 Co-occurring IT Skills in Scotland

For the 6 months to 27 June 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	57 (51.35%)	SQL
2	47 (42.34%)	Relational Database
3	40 (36.04%)	Finance
4	39 (35.14%)	Oracle
5	33 (29.73%)	Data Warehouse
6	30 (27.03%)	RDBMS
7	29 (26.13%)	ETL
8	27 (24.32%)	Agile Software Development
9	26 (23.42%)	SQL Server
10	25 (22.52%)	Stakeholder Management
11	23 (20.72%)	Business Intelligence
12	22 (19.82%)	PL/SQL
12	22 (19.82%)	Security Cleared
13	20 (18.02%)	Unix
14	19 (17.12%)	Use Case

14	19 (17.12%)	Oracle Database
15	18 (16.22%)	Analytics
15	18 (16.22%)	MicroStrategy
16	17 (15.32%)	Data Management
16	17 (15.32%)	Oracle Database 11g
16	17 (15.32%)	Performance Tuning
17	16 (14.41%)	Talend
17	16 (14.41%)	Talend Open Studio
17	16 (14.41%)	C#
17	16 (14.41%)	Microsoft
17	16 (14.41%)	OO
18	15 (13.51%)	Oracle Database 10g
18	15 (13.51%)	Oracle8/8i Database
18	15 (13.51%)	Oracle9i Database
18	15 (13.51%)	PVCS

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
Applications
Business Applications
Cloud Services
Communications & Networking
Database & Business Intelligence
Development Applications
General
Job Titles
Libraries, Frameworks & Software Standards
Miscellaneous
Operating Systems
Processes & Methodologies
Programming Languages
Qualifications
Quality Assurance & Compliance
Vendors

Application Platforms
1	12 (10.81%)	Oracle SOA Suite
2	8 (7.21%)	Apache Spark
3	6 (5.41%)	JBoss
4	3 (2.70%)	SharePoint
5	2 (1.80%)	SAS
6	1 (0.90%)	Confluence
6	1 (0.90%)	IIS

Applications
1	4 (3.60%)	Microsoft Excel
2	3 (2.70%)	MS Visio
3	1 (0.90%)	Microsoft Office
3	1 (0.90%)	Microsoft PowerPoint

Business Applications
1	6 (5.41%)	Oracle BPM
2	2 (1.80%)	Dynamics CRM
3	1 (0.90%)	Eloqua
3	1 (0.90%)	HFM
3	1 (0.90%)	Hyperion Planning
3	1 (0.90%)	IntelliMatch
3	1 (0.90%)	Markit EDM
3	1 (0.90%)	Oracle 11i
3	1 (0.90%)	Oracle EBS
3	1 (0.90%)	Oracle EBS R12
3	1 (0.90%)	Oracle ERP

Cloud Services
1	2 (1.80%)	Microsoft Azure
1	2 (1.80%)	SaaS
2	1 (0.90%)	Google Analytics
2	1 (0.90%)	iPaaS
2	1 (0.90%)	PaaS

Communications & Networking
1	1 (0.90%)	TCP/IP

Database & Business Intelligence
1	47 (42.34%)	Relational Database
2	33 (29.73%)	Data Warehouse
3	30 (27.03%)	RDBMS
4	26 (23.42%)	SQL Server
5	19 (17.12%)	Oracle Database
6	17 (15.32%)	Oracle Database 11g
7	15 (13.51%)	Oracle Database 10g
7	15 (13.51%)	Oracle8/8i Database
7	15 (13.51%)	Oracle9i Database
8	10 (9.01%)	Hadoop
9	8 (7.21%)	Apache Hive
9	8 (7.21%)	HBase
10	5 (4.50%)	BusinessObjects
10	5 (4.50%)	Data Mining
11	3 (2.70%)	Big Data
11	3 (2.70%)	NoSQL
11	3 (2.70%)	Star Schema
12	2 (1.80%)	Azure SQL Database
12	2 (1.80%)	Oracle ODI
12	2 (1.80%)	SQL Server 2012

Development Applications
1	16 (14.41%)	Talend Open Studio
2	15 (13.51%)	PVCS
3	11 (9.91%)	ERwin
4	10 (9.01%)	Team Foundation Server
5	8 (7.21%)	Git (software)
5	8 (7.21%)	Moq
5	8 (7.21%)	NUnit
6	4 (3.60%)	JUnit
6	4 (3.60%)	Visual Studio
7	3 (2.70%)	MagicDraw
8	2 (1.80%)	Eclipse
8	2 (1.80%)	Jenkins
8	2 (1.80%)	JIRA
8	2 (1.80%)	Maven
8	2 (1.80%)	NSubstitute

General
1	40 (36.04%)	Finance
2	5 (4.50%)	Banking
2	5 (4.50%)	Marketing
3	2 (1.80%)	Law
4	1 (0.90%)	Financial Institution
4	1 (0.90%)	Games
4	1 (0.90%)	General Ledger
4	1 (0.90%)	Legal

Job Titles
1	41 (36.94%)	Analyst
2	35 (31.53%)	Developer
3	27 (24.32%)	Business Analyst
4	24 (21.62%)	Architect
5	20 (18.02%)	Senior Developer
6	18 (16.22%)	Oracle Developer
7	15 (13.51%)	Senior Oracle Developer
8	11 (9.91%)	Data Architect
8	11 (9.91%)	Senior Architect
9	10 (9.01%)	Senior Data Architect
10	8 (7.21%)	Senior Analyst
11	7 (6.31%)	.NET Developer
11	7 (6.31%)	Senior Business Analyst
12	6 (5.41%)	.NET Software Developer
12	6 (5.41%)	C# .NET Developer
12	6 (5.41%)	C# Developer
12	6 (5.41%)	C# Software Developer
12	6 (5.41%)	Data Analyst
12	6 (5.41%)	Software Developer
12	6 (5.41%)	Solutions Architect

Libraries, Frameworks & Software Standards
1	11 (9.91%)	.NET
2	10 (9.01%)	ASP.NET
3	9 (8.11%)	ASP.NET MVC
4	8 (7.21%)	JPA
5	7 (6.31%)	Hibernate
5	7 (6.31%)	Kafka
5	7 (6.31%)	XML
6	6 (5.41%)	.NET Framework
6	6 (5.41%)	Apache CXF
6	6 (5.41%)	Entity Framework
6	6 (5.41%)	JSF
6	6 (5.41%)	RichFaces
7	5 (4.50%)	Drools
7	5 (4.50%)	XML Schema
8	4 (3.60%)	Unity DI Container
8	4 (3.60%)	XSLT
9	3 (2.70%)	HTML
10	2 (1.80%)	CSS
10	2 (1.80%)	J2EE
10	2 (1.80%)	SOAP

Miscellaneous
1	12 (10.81%)	Analytical Skills
2	9 (8.11%)	Taxonomies
3	5 (4.50%)	Computer Science
4	3 (2.70%)	Data Structures
4	3 (2.70%)	Management Information System
5	2 (1.80%)	Enterprise Software
5	2 (1.80%)	Equities
5	2 (1.80%)	Fixed Income
5	2 (1.80%)	Reference Data
6	1 (0.90%)	Client/Server
6	1 (0.90%)	Greenfield Project
6	1 (0.90%)	SCADA

Operating Systems
1	20 (18.02%)	Unix
2	3 (2.70%)	Linux

Processes & Methodologies
1	29 (26.13%)	ETL
2	27 (24.32%)	Agile Software Development
3	25 (22.52%)	Stakeholder Management
4	23 (20.72%)	Business Intelligence
5	19 (17.12%)	Use Case
6	18 (16.22%)	Analytics
7	17 (15.32%)	Data Management
7	17 (15.32%)	Performance Tuning
8	16 (14.41%)	OO
9	15 (13.51%)	Business Analysis
9	15 (13.51%)	Infrastructure Management
10	13 (11.71%)	Logical Data Model
10	13 (11.71%)	SOA
11	12 (10.81%)	Data Architecture
11	12 (10.81%)	SDLC
12	11 (9.91%)	Data Integration
13	10 (9.01%)	Data Analysis
13	10 (9.01%)	Master Data Management
13	10 (9.01%)	MVC
13	10 (9.01%)	UML

Programming Languages
1	57 (51.35%)	SQL
2	22 (19.82%)	PL/SQL
3	16 (14.41%)	C#
4	14 (12.61%)	Java
5	5 (4.50%)	JavaScript
6	3 (2.70%)	Korn
6	3 (2.70%)	Perl
6	3 (2.70%)	PowerShell
7	2 (1.80%)	Ruby
7	2 (1.80%)	XPath
8	1 (0.90%)	C
8	1 (0.90%)	C++
8	1 (0.90%)	PHP
8	1 (0.90%)	T-SQL

Qualifications
1	22 (19.82%)	Security Cleared
2	12 (10.81%)	Degree
3	3 (2.70%)	ISEB
3	3 (2.70%)	MCAD
3	3 (2.70%)	MCSD
3	3 (2.70%)	MCTS
3	3 (2.70%)	Microsoft Certification
4	1 (0.90%)	ACCA
4	1 (0.90%)	IIBA
4	1 (0.90%)	ITIL Certification
4	1 (0.90%)	Oracle Certification

Quality Assurance & Compliance
1	6 (5.41%)	Data Quality
2	4 (3.60%)	QA
3	2 (1.80%)	ISO 20022
4	1 (0.90%)	SLA

Vendors
1	39 (35.14%)	Oracle
2	18 (16.22%)	MicroStrategy
3	16 (14.41%)	Microsoft
3	16 (14.41%)	Talend
4	9 (8.11%)	IBM
5	8 (7.21%)	Teradata
6	5 (4.50%)	Informatica
7	3 (2.70%)	Cognos
7	3 (2.70%)	Hyperion
8	2 (1.80%)	MuleSoft
8	2 (1.80%)	Perforce
8	2 (1.80%)	Tableau
9	1 (0.90%)	CA
9	1 (0.90%)	CODA
9	1 (0.90%)	Google
9	1 (0.90%)	Salesforce.com
9	1 (0.90%)	SunGard