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

3 months to
24 Feb 2017
Same period 2016 Same period 2015
Entity-Relationship Diagram (ER Diagram)
UK / England
Rank 821 905 919
Rank change year-on-year
+84 +14
Permanent jobs citing ERD 14 28 19
As % of all permanent IT jobs located in England 0.018% 0.029% 0.019%
As % of the Processes & Methodologies category 0.020% 0.033% 0.022%
Number of salaries quoted 14 24 13
Median salary £50,000 £48,750 £42,500
Median salary % change year-on-year
+2.56% +14.70%
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 in the England region.

Processes & Methodologies Category
England
Permanent IT job ads with a match in the
Processes & Methodologies category
70158 84275 86248
As % of all permanent IT jobs located in England 88.85% 88.36% 86.67%
Number of salaries quoted 58065 70779 71293
Median salary £50,000 £50,000 £48,500
Median salary % change year-on-year
- +3.09%
90% offered a salary of more than £32,500 £32,500 £31,500
10% offered a salary of more than £77,500 £75,000 £77,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ERD
Jobs Demand Trend in England

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

ERD Jobs Demand Trend in England

ERD
Salary Trend in England

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

ERD Salary Trend in England

ERD
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing ERD across the England region over the 3 months to 24 February 2017.

ERD Salary Histogram in England

ERD
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ERD within the England region over the 3 months to 24 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
North West -3 9 £40,000 -
London +56 3 £90,000 +89.47% 1
South East - 2 £50,000 -
South West - 2 £50,000 -
West Midlands +30 1 £50,000 -
ERD
UK

ERD
Top 30 Related IT Skills in England

For the 6 months to 24 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 across the England region with a requirement for ERD.

1 17 (62.96%) SQL
2 16 (59.26%) Oracle
2 16 (59.26%) Data Modelling
3 14 (51.85%) UML
4 11 (40.74%) ETL
5 9 (33.33%) SQL Server
5 9 (33.33%) PL/SQL
5 9 (33.33%) Oracle Database
5 9 (33.33%) Analytical Skills
6 8 (29.63%) Apple
6 8 (29.63%) Objective-C
6 8 (29.63%) Oracle Forms
6 8 (29.63%) Data Warehouse
6 8 (29.63%) Oracle APEX
6 8 (29.63%) Oracle Database 11g
6 8 (29.63%) Apple iOS
7 7 (25.93%) Business Intelligence
8 6 (22.22%) Manufacturing
8 6 (22.22%) Data Quality
8 6 (22.22%) Agile Software Development
8 6 (22.22%) SDLC
9 5 (18.52%) Analytics
9 5 (18.52%) Master Data Management
9 5 (18.52%) Data Management
9 5 (18.52%) SQL Server Reporting Services
9 5 (18.52%) Data Analysis
9 5 (18.52%) Data Integration
9 5 (18.52%) Scrum
9 5 (18.52%) Microsoft
9 5 (18.52%) XML

ERD
Top Related IT Skills in England 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 (11.11%) MS Excel
2 2 (7.41%) MS Visio
3 1 (3.70%) MS PowerPoint
3 1 (3.70%) MS Project
Communications & Networking
1 1 (3.70%) Internet
Database & Business Intelligence
1 9 (33.33%) Oracle Database
1 9 (33.33%) SQL Server
2 8 (29.63%) Data Warehouse
2 8 (29.63%) Oracle Database 11g
3 5 (18.52%) SQL Server Reporting Services
4 4 (14.81%) SQL Server Analysis Services
4 4 (14.81%) SQL Server Integration Services
5 3 (11.11%) MySQL
5 3 (11.11%) NoSQL
5 3 (11.11%) SQL Server 2008
5 3 (11.11%) SQL Server 2012
5 3 (11.11%) Star Schema
6 2 (7.41%) Big Data
6 2 (7.41%) Enterprise Data Warehouse
6 2 (7.41%) Hadoop
6 2 (7.41%) SQL Server 2005
7 1 (3.70%) BusinessObjects
7 1 (3.70%) BusinessObjects XI
7 1 (3.70%) OLTP
7 1 (3.70%) RDBMS
Development Applications
1 8 (29.63%) Oracle APEX
1 8 (29.63%) Oracle Forms
2 3 (11.11%) JIRA
General
1 6 (22.22%) Manufacturing
2 4 (14.81%) Retail
3 3 (11.11%) Legal
4 2 (7.41%) Finance
5 1 (3.70%) Advertising
5 1 (3.70%) Banking
Job Titles
1 9 (33.33%) Developer
2 8 (29.63%) Oracle Developer
3 6 (22.22%) PL/SQL Developer
3 6 (22.22%) SQL Developer
4 5 (18.52%) Architect
5 4 (14.81%) Analyst
5 4 (14.81%) DBA
5 4 (14.81%) Oracle Forms Developer
6 3 (11.11%) Business Intelligence Lead
6 3 (11.11%) Data Architect
6 3 (11.11%) Data Modeller
7 2 (7.41%) Business Analyst
7 2 (7.41%) Business Intelligence Architect
7 2 (7.41%) Database Developer
7 2 (7.41%) Lead Architect
7 2 (7.41%) Oracle Database Developer
7 2 (7.41%) Production DBA
7 2 (7.41%) Report Analyst
7 2 (7.41%) Senior DBA
7 2 (7.41%) SQL DBA
Libraries, Frameworks & Software Standards
1 5 (18.52%) XML
2 3 (11.11%) HTML
2 3 (11.11%) Middleware
2 3 (11.11%) REST
2 3 (11.11%) SOAP
2 3 (11.11%) Web Services
3 2 (7.41%) Classic ASP
3 2 (7.41%) Cocoa
3 2 (7.41%) Cocoa Touch
3 2 (7.41%) jQuery
3 2 (7.41%) JSON
3 2 (7.41%) Kafka
4 1 (3.70%) .NET
4 1 (3.70%) ASP.NET
4 1 (3.70%) CSS
4 1 (3.70%) MDX
Miscellaneous
1 9 (33.33%) Analytical Skills
2 4 (14.81%) Computer Science
3 3 (11.11%) Management Information System
3 3 (11.11%) Semantic Web
4 2 (7.41%) Data Structures
4 2 (7.41%) Enterprise Software
4 2 (7.41%) Replication
Operating Systems
1 8 (29.63%) Apple iOS
2 2 (7.41%) Linux
2 2 (7.41%) Unix
Processes & Methodologies
1 16 (59.26%) Data Modelling
2 14 (51.85%) UML
3 11 (40.74%) ETL
4 7 (25.93%) Business Intelligence
5 6 (22.22%) Agile Software Development
5 6 (22.22%) SDLC
6 5 (18.52%) Analytics
6 5 (18.52%) Data Analysis
6 5 (18.52%) Data Integration
6 5 (18.52%) Data Management
6 5 (18.52%) Master Data Management
6 5 (18.52%) Scrum
7 3 (11.11%) EAI
7 3 (11.11%) Enterprise Architecture
7 3 (11.11%) Event-Driven Architecture
7 3 (11.11%) High Availability
7 3 (11.11%) OO
7 3 (11.11%) OOP
7 3 (11.11%) SOA
7 3 (11.11%) Use Case
Programming Languages
1 17 (62.96%) SQL
2 9 (33.33%) PL/SQL
3 8 (29.63%) Objective-C
4 3 (11.11%) JavaScript
5 2 (7.41%) T-SQL
6 1 (3.70%) Java
6 1 (3.70%) Python
Qualifications
1 3 (11.11%) Degree
2 2 (7.41%) OCP
2 2 (7.41%) Oracle Certification
Quality Assurance & Compliance
1 6 (22.22%) Data Quality
2 1 (3.70%) QA
Systems Management
1 2 (7.41%) Failover Clustering
Vendors
1 16 (59.26%) Oracle
2 8 (29.63%) Apple
3 5 (18.52%) Microsoft
4 2 (7.41%) Informatica
5 1 (3.70%) Cognos
5 1 (3.70%) IBM
5 1 (3.70%) Pega
5 1 (3.70%) Salesforce.com
5 1 (3.70%) Tableau