The table below looks at the statistics for ERD skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited ERD over the 3 months to 25 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
25 Feb 2017
Same period 2016 Same period 2015
Entity-Relationship Diagram (ER Diagram)
UK
Rank 824 911 945
Rank change year-on-year
+87 +34
Permanent jobs citing ERD 17 28 21
As % of all permanent IT jobs located in the UK 0.020% 0.027% 0.020%
As % of the Processes & Methodologies category 0.023% 0.031% 0.023%
Number of salaries quoted 14 24 15
Median salary £50,000 £48,750 £46,000
Median salary % change year-on-year
+2.56% +5.97%
90% offered a salary of more than £39,000 £40,000 £40,000
10% offered a salary of more than £63,500 £90,000 £70,000
UK excluding London median salary £50,000 £50,000 £40,000
% change year-on-year
- +25.00%

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised across the UK.

Processes & Methodologies Category
UK
Permanent IT job ads with a match in the
Processes & Methodologies category
73636 90103 92424
As % of all permanent IT jobs located in the UK 88.79% 88.28% 86.67%
Number of salaries quoted 60524 74752 75526
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year
- +5.26%
90% offered a salary of more than £32,500 £32,500 £31,250
10% offered a salary of more than £77,500 £75,000 £75,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ERD
Jobs Demand Trend

The demand trend of job ads citing ERD as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ERD Jobs Demand Trend in the UK

ERD
Salary Trend

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

ERD Salary Trend in the UK

ERD
Salary Histogram

This chart provides a salary histogram for IT jobs citing ERD over the 3 months to 25 February 2017 within the UK.

ERD Salary Histogram in the UK

ERD
Top 21 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 3 months to 25 February 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
England +86 14 £50,000 +2.56% 1
North West -4 9 £40,000 -
Preston - 8 £40,000 -
Lancashire - 8 £40,000 -
London +57 3 £90,000 +89.47% 1
Berkshire - 2 £50,000 -
Oxfordshire - 2 £50,000 -
Oxford - 2 £50,000 -
Bath - 2 £50,000 -
Swindon - 2 £50,000 -
Reading - 2 £50,000 -
Somerset - 2 £50,000 -
Wiltshire - 2 £50,000 -
South East - 2 £50,000 -
South West - 2 £50,000 -
West Midlands +37 1 £50,000 -
Manchester -27 1 £32,500 -
Worcestershire - 1 £50,000 -
Gloucester - 1 £50,000 -
Worcester - 1 £50,000 -
Gloucestershire - 1 £50,000 -

ERD
Top 30 Related IT Skills

For the 6 months to 25 February 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 19 (63.33%) Data Modelling
2 17 (56.67%) UML
2 17 (56.67%) SQL
3 16 (53.33%) Oracle
4 11 (36.67%) ETL
5 9 (30.00%) SQL Server
5 9 (30.00%) PL/SQL
5 9 (30.00%) Oracle Database
5 9 (30.00%) Analytical Skills
6 8 (26.67%) Apple
6 8 (26.67%) Objective-C
6 8 (26.67%) Oracle Forms
6 8 (26.67%) Data Warehouse
6 8 (26.67%) Oracle APEX
6 8 (26.67%) Oracle Database 11g
6 8 (26.67%) Apple iOS
7 7 (23.33%) Business Intelligence
8 6 (20.00%) SOA
8 6 (20.00%) Manufacturing
8 6 (20.00%) Data Quality
8 6 (20.00%) Agile Software Development
8 6 (20.00%) SDLC
9 5 (16.67%) Analytics
9 5 (16.67%) Master Data Management
9 5 (16.67%) Data Management
9 5 (16.67%) SQL Server Reporting Services
9 5 (16.67%) Data Analysis
9 5 (16.67%) Data Integration
9 5 (16.67%) Scrum
9 5 (16.67%) Microsoft

ERD
Top Related 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:

Applications
1 3 (10.00%) MS Excel
2 2 (6.67%) MS Visio
3 1 (3.33%) MS PowerPoint
3 1 (3.33%) MS Project
Communications & Networking
1 1 (3.33%) Internet
Database & Business Intelligence
1 9 (30.00%) Oracle Database
1 9 (30.00%) SQL Server
2 8 (26.67%) Data Warehouse
2 8 (26.67%) Oracle Database 11g
3 5 (16.67%) SQL Server Reporting Services
4 4 (13.33%) SQL Server Analysis Services
4 4 (13.33%) SQL Server Integration Services
5 3 (10.00%) MySQL
5 3 (10.00%) NoSQL
5 3 (10.00%) SQL Server 2008
5 3 (10.00%) SQL Server 2012
5 3 (10.00%) Star Schema
6 2 (6.67%) Big Data
6 2 (6.67%) Enterprise Data Warehouse
6 2 (6.67%) Hadoop
6 2 (6.67%) SQL Server 2005
7 1 (3.33%) BusinessObjects
7 1 (3.33%) BusinessObjects XI
7 1 (3.33%) OLTP
7 1 (3.33%) RDBMS
Development Applications
1 8 (26.67%) Oracle APEX
1 8 (26.67%) Oracle Forms
2 3 (10.00%) JIRA
General
1 6 (20.00%) Manufacturing
2 4 (13.33%) Retail
3 3 (10.00%) Legal
3 3 (10.00%) Marketing
4 2 (6.67%) Finance
5 1 (3.33%) Advertising
5 1 (3.33%) Banking
Job Titles
1 9 (30.00%) Developer
2 8 (26.67%) Architect
2 8 (26.67%) Oracle Developer
3 6 (20.00%) Data Architect
3 6 (20.00%) PL/SQL Developer
3 6 (20.00%) SQL Developer
4 4 (13.33%) Analyst
4 4 (13.33%) DBA
4 4 (13.33%) Oracle Forms Developer
5 3 (10.00%) Business Intelligence Lead
5 3 (10.00%) Data Modeller
6 2 (6.67%) Business Intelligence Architect
6 2 (6.67%) Database Developer
6 2 (6.67%) Lead Architect
6 2 (6.67%) Oracle Database Developer
6 2 (6.67%) Production DBA
6 2 (6.67%) Report Analyst
6 2 (6.67%) Senior DBA
6 2 (6.67%) SQL Database Developer
6 2 (6.67%) SQL DBA
Libraries, Frameworks & Software Standards
1 5 (16.67%) XML
2 3 (10.00%) HTML
2 3 (10.00%) Middleware
2 3 (10.00%) REST
2 3 (10.00%) SOAP
2 3 (10.00%) Web Services
3 2 (6.67%) Classic ASP
3 2 (6.67%) Cocoa
3 2 (6.67%) Cocoa Touch
3 2 (6.67%) jQuery
3 2 (6.67%) JSON
3 2 (6.67%) Kafka
4 1 (3.33%) .NET
4 1 (3.33%) ASP.NET
4 1 (3.33%) CSS
4 1 (3.33%) MDX
Miscellaneous
1 9 (30.00%) Analytical Skills
2 4 (13.33%) Computer Science
3 3 (10.00%) Management Information System
3 3 (10.00%) Semantic Web
4 2 (6.67%) Data Structures
4 2 (6.67%) Enterprise Software
4 2 (6.67%) Replication
Operating Systems
1 8 (26.67%) Apple iOS
2 2 (6.67%) Linux
2 2 (6.67%) Unix
Processes & Methodologies
1 19 (63.33%) Data Modelling
2 17 (56.67%) UML
3 11 (36.67%) ETL
4 7 (23.33%) Business Intelligence
5 6 (20.00%) Agile Software Development
5 6 (20.00%) SDLC
5 6 (20.00%) SOA
6 5 (16.67%) Analytics
6 5 (16.67%) Data Analysis
6 5 (16.67%) Data Integration
6 5 (16.67%) Data Management
6 5 (16.67%) Master Data Management
6 5 (16.67%) Scrum
7 3 (10.00%) EAI
7 3 (10.00%) Enterprise Architecture
7 3 (10.00%) Information Architecture
7 3 (10.00%) Information Management
7 3 (10.00%) OOP
7 3 (10.00%) Open Source
7 3 (10.00%) Use Case
Programming Languages
1 17 (56.67%) SQL
2 9 (30.00%) PL/SQL
3 8 (26.67%) Objective-C
4 3 (10.00%) JavaScript
5 2 (6.67%) T-SQL
6 1 (3.33%) Java
6 1 (3.33%) Python
Qualifications
1 3 (10.00%) Degree
2 2 (6.67%) OCP
2 2 (6.67%) Oracle Certification
Quality Assurance & Compliance
1 6 (20.00%) Data Quality
2 1 (3.33%) QA
Systems Management
1 2 (6.67%) Failover Clustering
Vendors
1 16 (53.33%) Oracle
2 8 (26.67%) Apple
3 5 (16.67%) Microsoft
4 2 (6.67%) Informatica
5 1 (3.33%) Cognos
5 1 (3.33%) IBM
5 1 (3.33%) Pega
5 1 (3.33%) Salesforce.com
5 1 (3.33%) Tableau