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 9 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
9 Dec 2016
Same period 2015 Same period 2014
Entity-Relationship Diagram (ER Diagram)
Rank 857 902 940
Rank change year-on-year
+45 +38
Permanent jobs citing ERD 7 32 26
As % of all permanent IT jobs located in England 0.008% 0.032% 0.024%
As % of the Processes & Methodologies category 0.009% 0.037% 0.028%
Number of salaries quoted 7 29 20
Median salary £65,000 £46,500 £50,000
Median salary % change year-on-year
+39.78% -7.00%
90% offered a salary of more than £38,500 £40,000 £40,000
10% offered a salary of more than £68,000 £60,000 £70,000
UK excluding London median salary £57,500 £40,000 £46,000
% change year-on-year
+43.75% -13.04%
ERD
UK

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
74022 87052 91292
As % of all permanent IT jobs located in England 88.06% 87.52% 85.71%
Number of salaries quoted 61537 72688 75688
Median salary £50,000 £50,000 £49,000
Median salary % change year-on-year
- +2.04%
90% offered a salary of more than £32,500 £32,500 £31,500
10% offered a salary of more than £77,500 £72,500 £75,000
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 9 December 2016.

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 9 December 2016. 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
(Click see detailed
statistics and trends)
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
London +48 5 £65,000 +15.55%
South East +78 2 £57,500 -
ERD
UK

ERD
Top 30 Related IT Skills in England

For the 6 months to 9 December 2016, 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 37 (86.05%) Data Modelling
2 33 (76.74%) UML
3 20 (46.51%) ETL
4 19 (44.19%) Oracle
5 18 (41.86%) Agile Software Development
6 16 (37.21%) Business Intelligence
7 15 (34.88%) SQL
8 14 (32.56%) SQL Server
9 13 (30.23%) Retail
9 13 (30.23%) SDLC
10 12 (27.91%) Waterfall
10 12 (27.91%) SOA
10 12 (27.91%) OOP
10 12 (27.91%) OO
10 12 (27.91%) Legal
11 11 (25.58%) Data Analysis
11 11 (25.58%) SQL Server Integration Services
12 10 (23.26%) SQL Server Reporting Services
12 10 (23.26%) Open Source
12 10 (23.26%) High Availability
12 10 (23.26%) Performance Tuning
13 9 (20.93%) Database Security
13 9 (20.93%) Database Mirroring
13 9 (20.93%) Failover Clustering
13 9 (20.93%) SQL Server Analysis Services
13 9 (20.93%) Statistics
13 9 (20.93%) Replication
13 9 (20.93%) Unix
13 9 (20.93%) OCP
13 9 (20.93%) Oracle Certification

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:

Application Platforms
1 4 (9.30%) Oracle SOA Suite
Applications
1 4 (9.30%) MS Visio
2 3 (6.98%) MS Excel
3 1 (2.33%) MS Office
Database & Business Intelligence
1 14 (32.56%) SQL Server
2 11 (25.58%) SQL Server Integration Services
3 10 (23.26%) SQL Server Reporting Services
4 9 (20.93%) SQL Server Analysis Services
5 7 (16.28%) Data Warehouse
6 6 (13.95%) SQL Server 2005
6 6 (13.95%) SQL Server 2008
6 6 (13.95%) SQL Server 2012
7 4 (9.30%) MySQL
7 4 (9.30%) NoSQL
7 4 (9.30%) Relational Database
8 3 (6.98%) Star Schema
9 2 (4.65%) Big Data
9 2 (4.65%) BusinessObjects
10 1 (2.33%) BusinessObjects XI
10 1 (2.33%) OLAP
10 1 (2.33%) OLTP
10 1 (2.33%) Power BI
10 1 (2.33%) PowerPivot
10 1 (2.33%) RDBMS
Development Applications
1 3 (6.98%) ERwin
1 3 (6.98%) Subversion
2 1 (2.33%) JIRA
General
1 13 (30.23%) Retail
2 12 (27.91%) Legal
3 4 (9.30%) Finance
4 1 (2.33%) Advertising
4 1 (2.33%) Banking
Job Titles
1 12 (27.91%) Analyst
2 11 (25.58%) Data Modeller
3 9 (20.93%) DBA
3 9 (20.93%) SQL DBA
4 7 (16.28%) Business Analyst
5 6 (13.95%) Development DBA
5 6 (13.95%) Production DBA
6 5 (11.63%) Developer
7 4 (9.30%) Architect
7 4 (9.30%) Business Intelligence Analyst
7 4 (9.30%) Business Intelligence Business Analyst
7 4 (9.30%) Data Business Analyst
7 4 (9.30%) SQL Analyst
7 4 (9.30%) SQL Data Analyst
7 4 (9.30%) UML Analyst
7 4 (9.30%) UML Business Analyst
8 3 (6.98%) Data Architect
8 3 (6.98%) Front End Developer (Client-Side Developer)
8 3 (6.98%) MySQL DBA
9 2 (4.65%) Business Change Analyst
Libraries, Frameworks & Software Standards
1 8 (18.60%) Middleware
1 8 (18.60%) REST
1 8 (18.60%) SOAP
2 6 (13.95%) XML
3 5 (11.63%) Web Services
4 4 (9.30%) MDX
5 3 (6.98%) CSS
5 3 (6.98%) HTML
6 1 (2.33%) .NET
6 1 (2.33%) ASP.NET
Miscellaneous
1 9 (20.93%) Replication
1 9 (20.93%) Statistics
2 7 (16.28%) Analytical Skills
3 6 (13.95%) Computer Science
4 3 (6.98%) Data Integration
4 3 (6.98%) Reference Data
4 3 (6.98%) Semantic Web
5 2 (4.65%) Enterprise Software
5 2 (4.65%) Management Information System
6 1 (2.33%) Data Extraction
Operating Systems
1 9 (20.93%) Unix
Processes & Methodologies
1 37 (86.05%) Data Modelling
2 33 (76.74%) UML
3 20 (46.51%) ETL
4 18 (41.86%) Agile Software Development
5 16 (37.21%) Business Intelligence
6 13 (30.23%) SDLC
7 12 (27.91%) OO
7 12 (27.91%) OOP
7 12 (27.91%) SOA
7 12 (27.91%) Waterfall
8 11 (25.58%) Data Analysis
9 10 (23.26%) High Availability
9 10 (23.26%) Open Source
9 10 (23.26%) Performance Tuning
10 9 (20.93%) Database Mirroring
10 9 (20.93%) Database Security
11 8 (18.60%) Enterprise Architecture
11 8 (18.60%) Event-Driven Architecture
11 8 (18.60%) Service Design
11 8 (18.60%) User Acceptance Testing
Programming Languages
1 15 (34.88%) SQL
2 9 (20.93%) T-SQL
3 5 (11.63%) Java
4 3 (6.98%) JavaScript
4 3 (6.98%) PowerShell
5 2 (4.65%) C#
6 1 (2.33%) PL/SQL
6 1 (2.33%) Python
Qualifications
1 9 (20.93%) OCP
1 9 (20.93%) Oracle Certification
2 6 (13.95%) Degree
Quality Assurance & Compliance
1 8 (18.60%) Data Quality
2 4 (9.30%) QA
Systems Management
1 9 (20.93%) Failover Clustering
Vendors
1 19 (44.19%) Oracle
2 8 (18.60%) Microsoft
3 4 (9.30%) Tableau
4 3 (6.98%) IBM
4 3 (6.98%) Pega
4 3 (6.98%) Salesforce.com
5 2 (4.65%) Guidewire
5 2 (4.65%) Informatica
6 1 (2.33%) Cognos
6 1 (2.33%) Kronos
6 1 (2.33%) Sony