Period
to 19 November 2017

The following table provides summary statistics for permanent job vacancies with a requirement for ERD skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ERD over the 6 months to 19 November 2017 with a comparison to the same period in the previous 2 years.

Entity-Relationship Diagram (ER Diagram)
UK
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 1150 1164 1221
Rank change year-on-year +14 +57 +40
Permanent jobs citing ERD 48 54 87
As % of all permanent IT jobs advertised in the UK 0.027% 0.029% 0.040%
As % of the Processes & Methodologies category 0.030% 0.032% 0.045%
Number of salaries quoted 50 48 73
UK median annual salary £55,000 £50,000 £55,000
Median salary % change year-on-year +10.00% -9.09% +14.58%
10th Percentile £32,450 £37,500 £37,500
90th Percentile £70,000 £62,725 £77,000
UK excluding London median annual salary £50,000 £40,000 £42,000
% change year-on-year +25.00% -4.76% -8.70%

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

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 160296 168588 194039
As % of all permanent IT jobs advertised in the UK 89.92% 89.36% 88.77%
Number of salaries quoted 126459 140088 159820
UK median annual salary £50,000 £49,476 £47,500
Median salary % change year-on-year +1.06% +4.16% +5.56%
10th Percentile £28,750 £28,000 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £44,000 £42,500 £42,500
% change year-on-year +3.53% - +6.25%

ERD
Job Vacancy Trend

Job postings citing ERD as a percentage of all IT jobs advertised.

Job vacancy trend for ERD in the UK

ERD
Salary Trend

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

Salary trend for ERD in the UK

ERD
Salary Histogram

The salary distribution of IT jobs citing ERD over the 6 months to 19 November 2017.

Salary histogram for ERD in the UK

ERD
Top 11 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the UK over the 6 months to 19 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
England +35 46 £54,750 +9.50% 1
UK excluding London +57 30 £50,000 +25.00% 1
London -20 16 £60,000 +9.09% 1
North of England +13 12 £42,000 +29.23%
North West - 9 £65,000 -
East of England - 7 £65,000 -
South West - 7 £50,000 -
Midlands +33 4 £48,500 +21.25%
West Midlands +15 4 £48,500 +21.25%
Yorkshire +27 3 £42,000 +29.23%
South East +54 1 £70,000 +21.74%

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

1 28 (58.33%) SQL
2 26 (54.17%) Data Modelling
3 25 (52.08%) UML
4 22 (45.83%) Finance
5 18 (37.50%) Agile Software Development
5 18 (37.50%) SQL Server
6 16 (33.33%) Business Intelligence
7 15 (31.25%) Data Warehouse
8 13 (27.08%) Oracle
8 13 (27.08%) XML
9 11 (22.92%) PHP
10 10 (20.83%) C#
11 9 (18.75%) MySQL
11 9 (18.75%) Data Analysis
11 9 (18.75%) Degree
11 9 (18.75%) Use Case
11 9 (18.75%) Logical Data Model
12 8 (16.67%) Physical Data Model
12 8 (16.67%) Data Management
13 7 (14.58%) Microsoft
13 7 (14.58%) .NET
13 7 (14.58%) Java
13 7 (14.58%) AngularJS
13 7 (14.58%) Relational Database
13 7 (14.58%) Hadoop
13 7 (14.58%) Big Data
14 6 (12.50%) Data Quality
14 6 (12.50%) Analytics
14 6 (12.50%) PL/SQL
14 6 (12.50%) ASP.NET

ERD
Co-occurring IT Skills 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 3 (6.25%) BizTalk Server
1 3 (6.25%) IIS
1 3 (6.25%) SharePoint
2 2 (4.17%) Apache
2 2 (4.17%) Apache Spark
2 2 (4.17%) SharePoint Server
Applications
1 2 (4.17%) Microsoft Excel
1 2 (4.17%) Microsoft PowerPoint
1 2 (4.17%) Microsoft Project
2 1 (2.08%) MS Visio
Business Applications
1 3 (6.25%) Dynamics CRM
Cloud Services
1 5 (10.42%) Microsoft Azure
2 3 (6.25%) npm
3 1 (2.08%) Amazon AWS
3 1 (2.08%) GitHub
3 1 (2.08%) OpenShift
3 1 (2.08%) SaaS
Database & Business Intelligence
1 18 (37.50%) SQL Server
2 15 (31.25%) Data Warehouse
3 9 (18.75%) MySQL
4 7 (14.58%) Big Data
4 7 (14.58%) Hadoop
4 7 (14.58%) Relational Database
5 5 (10.42%) Data Lake
5 5 (10.42%) SQL Server Analysis Services
5 5 (10.42%) SQL Server Integration Services
5 5 (10.42%) SQL Server Reporting Services
5 5 (10.42%) Star Schema
6 4 (8.33%) SQL Server 2005
6 4 (8.33%) SQL Server 2008
6 4 (8.33%) SQL Server 2012
7 3 (6.25%) MariaDB
7 3 (6.25%) Oracle Database
7 3 (6.25%) PostgreSQL
8 2 (4.17%) DB2
8 2 (4.17%) Oracle Reports
8 2 (4.17%) RDBMS
Development Applications
1 3 (6.25%) Git (software)
1 3 (6.25%) gulp
1 3 (6.25%) jspm
1 3 (6.25%) SQL Server Management Studio (SSMS)
1 3 (6.25%) Team Foundation Server
1 3 (6.25%) VSS/SourceSafe
2 2 (4.17%) Talend Open Studio
3 1 (2.08%) Cucumber
3 1 (2.08%) Jenkins
3 1 (2.08%) Sonatype Nexus
3 1 (2.08%) Visual Studio
General
1 22 (45.83%) Finance
2 5 (10.42%) Financial Institution
3 3 (6.25%) Marketing
3 3 (6.25%) Retail
4 2 (4.17%) Banking
5 1 (2.08%) Back Office
5 1 (2.08%) French Language
5 1 (2.08%) Games
Job Titles
1 26 (54.17%) Developer
2 10 (20.83%) Architect
3 9 (18.75%) Data Architect
4 8 (16.67%) Analyst
5 6 (12.50%) C# Developer
6 5 (10.42%) .NET Developer
6 5 (10.42%) Business Analyst
6 5 (10.42%) Business Intelligence Developer
6 5 (10.42%) C# .NET Developer
6 5 (10.42%) Full Stack Developer
7 4 (8.33%) Business Developer
7 4 (8.33%) Web Developer
8 3 (6.25%) Angular Developer
8 3 (6.25%) Oracle Developer
9 2 (4.17%) Agile C# Developer
9 2 (4.17%) Agile Developer
9 2 (4.17%) C# Programmer
9 2 (4.17%) ETL Architect
9 2 (4.17%) LAMP Developer
9 2 (4.17%) SQL Developer
Libraries, Frameworks & Software Standards
1 13 (27.08%) XML
2 7 (14.58%) .NET
2 7 (14.58%) AngularJS
3 6 (12.50%) ASP.NET
3 6 (12.50%) jQuery
4 4 (8.33%) .NET Framework
4 4 (8.33%) CSS
4 4 (8.33%) HTML
5 3 (6.25%) Angular 2
5 3 (6.25%) ASP.NET MVC
5 3 (6.25%) ASP.NET Web API
5 3 (6.25%) Aurelia
5 3 (6.25%) Entity Framework
5 3 (6.25%) JSON
5 3 (6.25%) Laravel
5 3 (6.25%) NHibernate
5 3 (6.25%) Sass
5 3 (6.25%) SignalR
5 3 (6.25%) SOAP
5 3 (6.25%) WCF
Miscellaneous
1 5 (10.42%) Semantic Web
2 4 (8.33%) Computer Science
3 2 (4.17%) Management Information System
3 2 (4.17%) Reinsurance
4 1 (2.08%) CUDA
4 1 (2.08%) Distributed Denial-of-Service
4 1 (2.08%) Fintech
4 1 (2.08%) Online Games
4 1 (2.08%) Private Cloud
4 1 (2.08%) Public Cloud
Operating Systems
1 6 (12.50%) Linux
2 4 (8.33%) Windows
3 2 (4.17%) Unix
4 1 (2.08%) Android
4 1 (2.08%) Apple iOS
4 1 (2.08%) Windows Server
4 1 (2.08%) Windows Server 2012
Processes & Methodologies
1 26 (54.17%) Data Modelling
2 25 (52.08%) UML
3 18 (37.50%) Agile Software Development
4 16 (33.33%) Business Intelligence
5 9 (18.75%) Data Analysis
5 9 (18.75%) Logical Data Model
5 9 (18.75%) Use Case
6 8 (16.67%) Data Management
6 8 (16.67%) Physical Data Model
7 6 (12.50%) Analytics
7 6 (12.50%) Business Analysis
7 6 (12.50%) ETL
7 6 (12.50%) MVC
8 5 (10.42%) Data Integration
8 5 (10.42%) EAI
8 5 (10.42%) Master Data Management
8 5 (10.42%) Technical Architecture
8 5 (10.42%) User Acceptance Testing
9 4 (8.33%) Test Automation
9 4 (8.33%) Web Development
Programming Languages
1 28 (58.33%) SQL
2 11 (22.92%) PHP
3 10 (20.83%) C#
4 7 (14.58%) Java
5 6 (12.50%) PL/SQL
6 5 (10.42%) JavaScript
7 4 (8.33%) T-SQL
8 3 (6.25%) TypeScript
8 3 (6.25%) VB
9 2 (4.17%) Python
10 1 (2.08%) C
10 1 (2.08%) C++
10 1 (2.08%) Data Analysis Expressions (DAX)
10 1 (2.08%) Fortran
10 1 (2.08%) Lisp
10 1 (2.08%) MATLAB
10 1 (2.08%) Perl
10 1 (2.08%) PowerShell
10 1 (2.08%) R
10 1 (2.08%) Ruby
Qualifications
1 9 (18.75%) Degree
2 3 (6.25%) Computer Science Degree
3 1 (2.08%) CBAP
3 1 (2.08%) IIBA
3 1 (2.08%) Numerate Degree
3 1 (2.08%) PhD
3 1 (2.08%) Postgraduate
3 1 (2.08%) Security Cleared
Quality Assurance & Compliance
1 6 (12.50%) Data Quality
2 1 (2.08%) PCI DSS
2 1 (2.08%) QA
System Software
1 1 (2.08%) Docker
Systems Management
1 1 (2.08%) Ansible
1 1 (2.08%) Puppet
Vendors
1 13 (27.08%) Oracle
2 7 (14.58%) Microsoft
3 2 (4.17%) Guidewire
3 2 (4.17%) Informatica
3 2 (4.17%) Talend
4 1 (2.08%) Cognos
4 1 (2.08%) IBM
4 1 (2.08%) Pega
4 1 (2.08%) Salesforce.com
4 1 (2.08%) WorldPay